What are the different types of data warehouse systems?

There are two main data warehouse systems; Normalized and dimensional. In the normalized structure, the data is limited to a simple presentation of factual information. There is no context or background to data beyond what the user is willing to correlate. In the dimensional system, information comes in the context of other facts that show what data as a whole is. In this case, there is a lot of information available, whether you want it or not.

The two main data warehouse systems are two extremes. In most data warehouses, the middle terrain is achieved between these two. Real descriptions are for the cleanest form of style, although it rarely encounters.

Normalized data are easier from both data warehouse systems for implementation and handling. In this style, information is limited to individual facts without any connection with other data. For example, the serial product number and product name are assembled without additional Information. Information is available to everyone alreadyA user who may want it, but has to do a job to mean anything.

In order to understand information in normalized data warehouse systems, the user collects the connected information to connect the entire image. In order to find the client's telephone number, the above information may be associated with the serial number and account number of the person who purchased the item. Then the number and name of the account could be placed. Finally, the name and phone number are found. Each of these steps is a separate question for the database submitted by the user to collect information.

Dimensional data is the exact opposite. In general, these data warehouse systems for people are the simplest, but the most difficult to change or manipulate. After collecting information, everything is combined into one large ball of data. Instead of serial product number, the whole shopping invoice would go at the same time.

If the user should search for TeLefon number in a dimensional database, the process would be different. The serial number would bring the whole history for this client, names and data of all purchased and any calls or return on services. In addition, every address and telephone number that the client has ever used. The picture is very complete, but perhaps so complete that the required information is difficult to find.