Data Warehouse Configurations For Your Data Warehousing System

A data warehouse configuration is commonly known as the logical architecture. It is the foundation on which a data warehouse is built or you can say the logical architecture is a configuration map of the data to be stored in the warehouse. A Data Warehouse configuration includes a central Enterprise Data Store; an optional Operational Data Store; one or more optional individual business area Data Marts; and one or more Metadata Store or Repositories. When discussing options with your data warehousing consultant, these are some of the things that you must consider.

– Enterprise Data Store (EDS): This is the central repository that supplies atomic integrated information to the whole organization. The EDS can be defined as the cornerstone of a data warehouse and this can be accessed for immediate informational needs as well as for analytical processing to assist strategic decision-making in an organization. The EDS may contain data from the existing subject area operational systems as well as from external sources. This data further feeds individual Data Marts that are accessed by end-user query tools at the user’s desktop. The EDS can also be called as the collection of daily “snapshots” of enterprise-wide data taken over an extended time period. Thus it creates an optimum environment for strategic analysis.

– Operational Data Store: It is a “snapshot” of a moment in time’s enterprise-wide data. An ODS is a set of relational databases designed to perform simple queries on small amounts of data as opposed to the complex queries on much greater volumes of data typically stored in the data warehouse. In other words, an ODS stores only very recent information, rather than storing permanent information like the data warehouse.

– Individual Data Mart: It is the summarized subset of the enterprise’s data specific to a functional area or department, geographical region, or time period. Access to the EDS can often be difficult or slow, thanks to the volume of data it contains. This is when the role of Data Marts comes into play. Data Marts filter, condense and summarize information for specific business areas. However in the absence of the Data Mart layer, users can access the EDS directly.

– Metadata Store or Repository: This is a catalog of reference information about the primary data. It provides users and developers with a road map to the information in the data warehouse. Metadata is further divided into two categories- information for technical use or transformational and information for business end-users. Transformational metadata serves a technical purpose for development and maintenance of the warehouse, while end-user metadata serves a business purpose. Basically, this type of metadata translates a cryptic name code that represents a data element into a meaningful description so that end-users can recognize and use the data. On the other hand, transformational metadata maps the data element from its source system to the data warehouse, identifying it by source field name, destination field code, transformation routine, business rules for usage and derivation, format, key, size, index and other relevant transformational and structural information.

Related Posts

Why Is Dating Important?

Dating is a phase of heartfelt or potentially sexual connections in people by which at least two individuals meet socially, perhaps as companions or with the point…

Dubai Holiday Packages – Enjoy a Majestic Stay in the City Of Merchants

One of the seven emirates which comprise the Unified Bedouin Emirates, Dubai, represents the triumph of man over nature. dubai tour packages draws individuals from across the…

Trekking the Pangarchulla Trek – Travel Guide and Information

The Pangarchulla Trek in India is one of the most famous trekking ventures in the country. India is famous as “the Place that is known for the…

The Importance of Driver Updates in Online Gaming

In the age of online gaming, purchasing, and mobile software แทงบอลออนไลน์ applications, most people are inclined towards using what is new and available online. With the young…

Age of Conan Level Guide – Some Tips to Help You Level Up Fast in This Online Game

Age of Conan is a popular game that you can enjoy online. However, like any other online games, you may be wondering how to make your leveling…

Know More About Farmville Online Game

There are presently over sixty million individuals playing this famous online game named “Farmville”. This is a game where you will have your own farm and you…

Leave a Reply

Your email address will not be published.