Basic Concepts for a Data Warehouse

The concept of a data warehouse is a central database, they
is used to gather information from different parts of the business process. The definition of a data warehouse is the collection of data and how companies and individuals who are used to determine support. Data warehousing is the method used by companies, where they can create and maintain information for a wide view of business data.

Data Warehouses became a distinct type of computerDatabase during the late 1980's and early 1990. Data warehouse development, because the requirements are not satisfied with current operating systems. Ultimately, the need to create separate databases have been developed to support decision making based or government departments. With this demand, the development of operating systems and information has been produced.

Data Collection Tools

The need for enterprise-wide view of the data set in the operating systems. Data warehouses aredesigned to help companies manage and analyze data, and this helps fill the need for technical concepts. Integration is closely with career guidance. Data warehouses must put data from different sources in a consistent format. We must solve problems as naming conflicts and inconsistencies among units. If this concept is achieved, the data warehouse will be built.

The shape of the data stored has nothing to do with whetherone thing is a data warehouse. A data warehouse can be normalized or de-normalized. There may be a relational database, multidimensional database, flat file, hierarchical database, object database, etc. Data warehouse data will be changed often. Data warehouses are often be directed toward a specific action or legal person.

Data warehousing success can not be guaranteed for each project. The techniques involved can be very complicated and erroneous data can also lead to mistakes and failures.When management support is strong, resources committed for business values, and an enterprise vision is established, the end results may turn out to be more helpful for the organization or business. The main factors that create needs for data warehousing for most businesses today are requirements for the companywide view of quality information and departments separating informational from operational systems for improved performance for managing data.

Basic Concepts for a Data Warehouse