by admin | Jun 7, 2015 | sem3
data warehousing data mart Listed below are the reasons to create a data mart: To partition data in order to impose access control strategies. To speed up the queries by reducing the volume of data to be scanned. To segment data into different hardware platforms. To...
by admin | Jun 7, 2015 | sem3
data warehouse metadata concepts Metadata is simply defined as data about data. The data that is used to represent other data is known as metadata. For example, the index of a book serves as a metadata for the contents in the book. In other words, we can say that...
by admin | Jun 7, 2015 | sem3
data warehousing partitioning strategy Partitioning is done to enhance performance and facilitate easy management of data. Partitioning also helps in balancing the various requirements of the system. It optimizes the hardware performance and simplifies the management...
by admin | Jun 7, 2015 | sem3
data warehousing schemas Schema is a logical description of the entire database. It includes the name and description of records of all record types including all associated data-items and aggregates. Much like a database, a data warehouse also requires to maintain a...
by admin | Jun 7, 2015 | sem3
Data Warehousing Relational OLAP Relational OLAP servers are placed between relational back-end server and client front-end tools. To store and manage the warehouse data, the relational OLAP uses relational or extended-relational DBMS. ROLAP includes the following:...
by admin | Jun 7, 2015 | sem3
data warehousing olap Online Analytical Processing Server (OLAP) is based on the multidimensional data model. It allows managers, and analysts to get an insight of the information through fast, consistent, and interactive access to information. This chapter cover the...
