The rollup and the drilldown are quite frequent based on dimension hierarchies in on-line analytical processing （OLAP）, but prefixCube does not directly support dimension hierarchies. The PrefixCube is extended for ...The rollup and the drilldown are quite frequent based on dimension hierarchies in on-line analytical processing （OLAP）, but prefixCube does not directly support dimension hierarchies. The PrefixCube is extended for incorporating hierarchical data cubes, i.e. cubes with hierarchical dimensions ,thus obtaining HierPrefixCube. HierPrefixCube retains advantages on computation and organization of PrefixCube, and it can directly support aggregate queries on levels of the dimension hierarchy.展开更多
In this study, the main factors influencing the measurements by means of the off-line low-field 1H NMR in the lab were discussed base on a robust calibration model established by the PLS algorithm using 255 crude oil ...In this study, the main factors influencing the measurements by means of the off-line low-field 1H NMR in the lab were discussed base on a robust calibration model established by the PLS algorithm using 255 crude oil samples. The preheating temperature had a great influence on the viscosity of oil samples and the resolution of spectral analysis. The repeatability of spectral measurements was impacted by the metal and wax content of the oil samples. For the case of high wax content oils, the wax species began to crystallize in the course of determination that could affect the repeatability of spectral measurements. These factors have evidenced why the preheating devices and filter unit are necessary when low field NMR system is used in the online analysis process. The investigation is very important for the on-line application of the low field NMR.展开更多
The analysis of relevant standards and guidelines proved the lack of information on actions and activities concerning data warehouse testing. The absence of the complex data warehouse testing methodology seems to be c...The analysis of relevant standards and guidelines proved the lack of information on actions and activities concerning data warehouse testing. The absence of the complex data warehouse testing methodology seems to be crucial particularly in the phase of the data warehouse implementation. The aim of this article is to suggest basic data warehouse testing activities as a final part of data warehouse testing methodology. The testing activities that must be implemented in the process of the data warehouse testing can be split into four logical units regarding the multidimensional database testing, data pump testing, metadata and OLAP （Online Analytical Processing） testing. Between main testing activities can be included： revision of the multidimensional database scheme, optimizing of fact tables number, problem of data explosion, testing for correctness of aggregation and summation of data etc.展开更多
Data structure and semantics of the traditional data model cannot effectively represent the data warehouse, it is difficult to effectively support online analytical processing （referred to as OLAP）. This paper is pr...Data structure and semantics of the traditional data model cannot effectively represent the data warehouse, it is difficult to effectively support online analytical processing （referred to as OLAP）. This paper is propose a new multidimensional data model based on the partial ordering and mapping. The data model can fully express the complex data structure and semantics of data warehouse, and provide an OLAP operation as the core of the operation of algebra, support structure in levels of complex aggregation operation sequence, which can effectively support the application of OLAE The data model supports the concept of aggregation function constraint, and provides constraint mechanism of the hierarchy aggregation function.展开更多
Objective To establish a warehouse on acupuncture-moxibution （acup-mox） methods to explore valuable laws about research and clinical application of acup-mox in a great number of literature by use of data mining tech...Objective To establish a warehouse on acupuncture-moxibution （acup-mox） methods to explore valuable laws about research and clinical application of acup-mox in a great number of literature by use of data mining technique and to promote acup-mox research and effective treatment of diseases. Methods According to the acup-mox literature information of different types, different subjects of the aeup-mox literature are determined and the relevant database is established. In the continuously enriched subject database, the data warehouse catering to multi-subjects and multi-dimensions is set up so as to provide a platform for wider application of aeup-mox literature information. Results Based on characteristics of the acup-mox literature, many subject databases, such as needling with filiform needle, moxibustion, etc., are established and clinical treatment laws of acup-mox are revealed by use of data mining method in the database established. Conclusion Establishment of the acup-mox literature warehouse provides a standard data expression model, rich attributes and relation between different literature information for study of aeup-mox literature by more effective techniques, and a rich and standard data basis for acup-mox researches.展开更多
文摘The rollup and the drilldown are quite frequent based on dimension hierarchies in on-line analytical processing （OLAP）, but prefixCube does not directly support dimension hierarchies. The PrefixCube is extended for incorporating hierarchical data cubes, i.e. cubes with hierarchical dimensions ,thus obtaining HierPrefixCube. HierPrefixCube retains advantages on computation and organization of PrefixCube, and it can directly support aggregate queries on levels of the dimension hierarchy.
基金the financial support from the SINOPEC (ST 13028)
文摘In this study, the main factors influencing the measurements by means of the off-line low-field 1H NMR in the lab were discussed base on a robust calibration model established by the PLS algorithm using 255 crude oil samples. The preheating temperature had a great influence on the viscosity of oil samples and the resolution of spectral analysis. The repeatability of spectral measurements was impacted by the metal and wax content of the oil samples. For the case of high wax content oils, the wax species began to crystallize in the course of determination that could affect the repeatability of spectral measurements. These factors have evidenced why the preheating devices and filter unit are necessary when low field NMR system is used in the online analysis process. The investigation is very important for the on-line application of the low field NMR.
文摘The analysis of relevant standards and guidelines proved the lack of information on actions and activities concerning data warehouse testing. The absence of the complex data warehouse testing methodology seems to be crucial particularly in the phase of the data warehouse implementation. The aim of this article is to suggest basic data warehouse testing activities as a final part of data warehouse testing methodology. The testing activities that must be implemented in the process of the data warehouse testing can be split into four logical units regarding the multidimensional database testing, data pump testing, metadata and OLAP （Online Analytical Processing） testing. Between main testing activities can be included： revision of the multidimensional database scheme, optimizing of fact tables number, problem of data explosion, testing for correctness of aggregation and summation of data etc.
文摘Data structure and semantics of the traditional data model cannot effectively represent the data warehouse, it is difficult to effectively support online analytical processing （referred to as OLAP）. This paper is propose a new multidimensional data model based on the partial ordering and mapping. The data model can fully express the complex data structure and semantics of data warehouse, and provide an OLAP operation as the core of the operation of algebra, support structure in levels of complex aggregation operation sequence, which can effectively support the application of OLAE The data model supports the concept of aggregation function constraint, and provides constraint mechanism of the hierarchy aggregation function.
基金Supported by National Natural Science Foundation of China: No.81072883
文摘Objective To establish a warehouse on acupuncture-moxibution （acup-mox） methods to explore valuable laws about research and clinical application of acup-mox in a great number of literature by use of data mining technique and to promote acup-mox research and effective treatment of diseases. Methods According to the acup-mox literature information of different types, different subjects of the aeup-mox literature are determined and the relevant database is established. In the continuously enriched subject database, the data warehouse catering to multi-subjects and multi-dimensions is set up so as to provide a platform for wider application of aeup-mox literature information. Results Based on characteristics of the acup-mox literature, many subject databases, such as needling with filiform needle, moxibustion, etc., are established and clinical treatment laws of acup-mox are revealed by use of data mining method in the database established. Conclusion Establishment of the acup-mox literature warehouse provides a standard data expression model, rich attributes and relation between different literature information for study of aeup-mox literature by more effective techniques, and a rich and standard data basis for acup-mox researches.
