The theoretic foundation and practical significance of conversion from Visual FoxPro two dimension table to Excel worksheet is discussed in this paper and the programming method of striding over platform in the environment of Visual Basic is brought forward for realization of the conversion.
The optimization of the materialized view and the dimension table schema and the clustering index is researched to increase the key index to appraise query technology such as query speed and storage space.
By decomposing the information that involved in process of fixture design,analyzing the data structure of fixture design information, adapting multi-dimensional data structure that focused on fixture and based relation database's fact table/dimension table,and presenting a compound knowledge indicating model based on knowledge and case, construct a fixture design resource repository including workpiece information repository, manufacturing information repository,fixture design knowledge repository and parametric 3D fixture elements and components repository.
The purpose to construct data warehouse is to better data analysis and provide valuable information for enterprises, so this paper designs and realizes the application OLAP of the data Warehouse, using Analysis Services, a tool of Microsoft. The whole process goes as follow: establishes a multidimensional data set, connects fact table and dimensional table, presents data by Excel, analyzes data according to demands, and provides important information for decision-makers.
There are many methods to be used to form the Data Warehouse,but the more mature is by dimensional modeling. From the dimensionality, the thesis narrates how to form the fact table and dimensional table of campus data warehouse by the example of daily affairs, and how to get some information from the fact table.
According to fundamental theory of data mining, some sample questionnaire forms are designed to survey students who took the course - Program Design in C, the survey results are converted into dimensional tables with an appropriate data weight algorithm, and dynamically converted dimensional tables into fact tables.
Through comparing the difference between CRM system and ERM system in B2C environment,the schema of ERM data warehouse was discussed. The schema contains the user-behavior-fact table to record all activities of different users,the basic data dimensional tables and clustering data dimensional tables. An improved method of the schema of ERM data warehouse under the different E-commerce environments was also discussed.
They are a dimension list being as a list of Dimension objects and a fact list being as a list of Column objects.
The table under the dimension list shows the number of outpatient visits variable dimensioned by patient's residence and age group and sex.
The structure of 5-dimensional and 6-dimensional table algebras with basis including elements b,c satisfying was obtained.The 7-dimensional and 8-dimensional table algebras with basis including elements b,csatisfying(*)whem Irr were also discussed.
This paper researches on the smooth technology of noisy edge in the processing of computer images, which includes four parts: the edge detection, edge curve smoothing, regional filling and regional shrinking.It puts forward the concept of combining edges so as to reduce
This paper presents a Bayes method to estimate the expected proportions for high-way contingency tables appropriate when prior knowledge about the interaction effects can be described by a particular kind of exchangeability assumption.We give the expressions of estimates for four-way contingency tables based on general expressions equations.It extends the work of Leonard (1975)and Nazaret(1987) and useful algorithm also discussed.