Data Warehouse
Data Warehouse
what is a relational database and a data warehouse? explain?
need the answers for these questions
1)what is a relational database? explain
2) what is a data warehouse? for what purpose would it be used?
A relational database can keep parts of a record in different tables. An example would be an invoice which had today’s transactions, the buyer’s name, and the manufacturer of each item sold. The buyer’s address and account number would be in the buyer table and not need to be entered for everything that buyer got.
Data Warehouse
The Importance, Structure and Functions of Data Warehouse Architecture
Information is the foundation of progress. The apposite utilization of correct and complete data with the aim of ultimate progression opens new doors for evolution. As it is applicable for this larger society, also it is equally pertinent for its each and every unit. A corporation or an enterprise functions as an important element in the overall progress of society by active wealth and human resource management with the end of new products. For this important unit of society, information management or, using the more technical terms, the data warehouse architecture serves its core obligation.
The emergence of the age of Information Technology and the revolution of the information management system have developed new dimensions of data warehousing and mining. There are instances where a business suffers from loss because management is undergoing through a state of information drought and information misuse. Generally, an enterprise with at least a year’s execution history develops serious necessity for enterprise data warehouse. A proper business decision should be shaped and founded on exact and complete data.
The utilization of information technology for this purpose will not only reduce the time and labor of data management, but also save large amount of money. Moreover, it will fetch in long run more and more profits to a business organization. Along with this, the quality of business decision or business presentation will be increased manifolds. The quality business intelligence will magnify the prosperity.
The data warehouse architecture represents in a methodical way the logical structure of various elements in an organization with its functions and services. The architecture also explains changing relationships among these various elements and predicts the future growth of this overall organization. Well-built data warehouse architecture is constructed with both data and technical terms. Various experts have given different opinions on the use and mechanism of data warehouse architecture.
Depending on the business process, hardware, operating systems, networking, desktop machines and the decision-making technologies a complete data warehouse is prepared. For proper functioning of data warehouse, business requirement should be kept in mind, and the structure should be updated regularly, made available widely, analyzed functionally, supported with meta data flexibly and prepared to serve reliably.
A well-made data warehouse serves not only as an organized framework for your organization, but also it improves the operational procedure and flexibility enhancing development and repetitive utilization and providing improved communication tool for management. Ultimately it coordinates all analogous efforts.
There are various data warehouse-consulting services available now a days to help you with this corporate data warehousing and mining process. They study, analyze and provide you with complete data warehouse for your business. Their experienced and highly qualified experts not only present to you the quality service but also guarantees your business profits.
About the Author
Catherine is a management consultant, and systems administrator. For more information on data warehouse architecture, she recommends to visit http://www.worcestergroupinc.com
What are the various data source components for the data warehouse?
Data source Components are:
Production Data
Internal Data
Achieved Data
External Data
For detail read Data Warehousing Fundamental by Paulraj Ponniah Chapter 2 Page 28 Topic Overview of the Components
Industry Data Warehouse (IDW)
