Four different views regarding the design of a data warehousemust be considered: the top-down view, the data source view, the data warehouse view, and the business query view.
The top-down view allows the selection of the relevant information necessary for the data warehouse. This information matches the current and future business needs.
The data source view exposes the information being captured, stored, and managed by operational systems. This information may be documented at various levels of detail and accuracy, from individual data source tables to integrated data source tables. Data sources are often modeled by traditional data modeling techniques, such as the entity-relationship model or CASE (computer-aided software engineering) tools.
The data warehouse view includes fact tables and dimension tables. It represents the information that is stored inside the data warehouse, including precalculated totals and counts, as well as information regarding the source, date, and time of origin, added to provide historical context.
Finally, the business query view is the perspective of data in the data warehouse from the viewpoint of the end user.
分享到：
相关推荐
A Qualitatively Different Principle for the Organization of Big Data Processing Section II: Big Data Security: Security, Privacy, and Accountability Chapter 8. Integration with Cloud Computing ...
(b) the name of the table, the names of the table's attributes, the data types of the table's attributes, the formats of the table's attributes, and the maximum number of rows that the table can have...
This project has been assigned by SwePart Transmissions AB. It is about calculation and dimensioning, ...designing the geometry and determination of the properties regarding the cycloid reducer.
a learning algorithm sequentially requests the labels of selected data points from a large pool of unlabeled data. This contrasts with passive learning, where the labeled data are taken at random. The...
In performing data mining many decisions need to be made regarding the choice of methodology, the choice of data, the choice of tools, and the choice of algorithms. Throughout this book the reader ...
In performing data mining many decisions need to be made regarding the choice of methodology, the choice of data, the choice of tools, and the choice of algorithms., Throughout this book the reader ...
This paper presents the use of a computer method of the ventilation process simulation for the analysis of the flow distribution of air and gases in the area of wall mining work and the adjacent goaf....
Determination of the instants ofglottal closure (GC) from speech wave using wavelet transform is equivalent to finding a particular local modulus maxima pattern across several scales in the time-scale...
In the third section, the contributors describe the modeling of CPS as a network of robots and explore issues regarding the design of CPS. The fourth section focuses on the impact of ubiquitous ...
Big Data Stream Techniques and Algorithms―explores research issues regarding the management and mining of Big Data in streaming environments Big Data Privacy―focuses on models, techniques, and ...
The growth of this information, calls for good design principles so that it can leverage the different big data tools available in market today. From the information consumption standpoint, business ...
the assumption that the data is an instance of a graph with random edge weights. The resulting distribution on the weights formalizes and quanti es the intuitive notion that vertices in the same ...
regarding the implementation and use of the information systems. Academic institutions are large organizations characterized by diversity of form. There are many ordinary administrative and managerial...
Based on the basic machine equations, the continuous and the discrete machine models of IM, PMSM and DFIM are derived and questions regarding feedback acquisition and the practical implementation of ...
With so many users and such a large amount of data, the requirements of analyzing large data sets leads to the need for further advancements to information processing. Big Data Processing With ...
serves as an additional reference regarding the functionality of the str class. • Over 450 illustrations have been created or revised. • New and revised exercises bring the overall total number to ...
The greatest compliment you can give an author of a technical book is “This is the book I wish I had when I got started with this subject.” This is the goal we set for our‐ selves when we started ...
The scope of the physical layer is the actual transfer of the bits between the different nodes with respect to all electrical properties. Within one network the physical layer, of course, has to be ...
it is necessary to employ advanced data processing methods to convert the original multi-source heterogeneous field monitoring data into different types of specific physical indicators in order to ...
pattern on the basis of its nearest neighbors in a recorded data set is addressed from the point of view of Dempster-Shafer theory. Each neighbor of a sample to be classified is considered as an item ...