inmon data warehouse architecture

integration architecture of Oracle/MySQL. InfobrightApplicable scenarios Big data analysis applications. Webpage/online analysis, mobile analysis, customer behavior analysis, analysis marketing and advertising Log/event management system. China Telecom detailed ticket analysis and report, System/network security certification records Data Mart. Specific

A brief explanation of common nouns in data data Warehouse Data Warehouse in the middle of the 80 's, Mr. William H.inmon, the "Father of the warehouse", defined the concept of data war

use the same data, which should be refreshed in accordance with pre-agreed rules to ensure synchronization and consistency. Scalability When there are new needs and changes, the structure of the logical data model can be extensible and transparent to the user.There are, of course, other principles in which the ultimate goal of these principles is to better meet the user's use. Summary

improvement in the short term, which will only worsen things in the long run. Enterprise's activity, also is a kind of "system", also is affected by the subtle and closely related actions, each other influence, this kind of influence often has to be full of over the period of the period to show out. Being a small part of the community and wanting to see the whole change is doubly difficult. We tend to focus on a fragment of the system, but we can't figure out why some of the most fundamental p

SQL ServerCategory 4Data warehouse modelingMethods are mainly divided into the following four types. The first type is the three-paradigm modeling of relational databases. We usually use the three-paradigm modeling method to build various types of operational database systems. The second category is the three-paradigm data warehouse modeling promoted by

priority for the securities industry, and Sybase's program provides us with perfect security controls. With the development of our business, system expansion will be an unavoidable problem, Sybase's solution allows us to start from a simple architecture, and can easily and smoothly expand the existing architecture to meet future needs. At the same time their program also takes into account the new

the search. Quick response to complex aggregate class queries: For complex analytical SQL queries such as SUM, COUNT, AVG, GROUP by Infobright the value Save design overhead. No complex Data Warehouse model design requirements (such as star model, snowflake model), no need materialized views, data partitioning, index building Conserve storage r

response to complex aggregate class queries: For complex analytical SQL queries such as SUM, COUNT, AVG, GROUP by The value of Infobright Save design overhead. No complex Data Warehouse model design requirements (such as star model, snowflake model), no need materialized views, data partitioning, index building Conserve storage resources. High compression rat

it as a shortcut to BI and analytics, because integrated devices are much shorter than traditional data warehouse systems in their deployment cycles. There are many structural similarities between integrated devices and traditional data warehouse systems, but the traditional approach involves more software and hardwa

Partitioning a relational data warehouse The following sections will briefly explain the concept of a relational data warehouse, the benefits of partitioning a relational data warehouse, and the benefits of migrating to Microsoft

Based on the Informix Data Warehouse system implementation methodology, we can divide the implementation of the data warehouse into the following steps: 1. Business Needs analysis Business requirements analysis is the basis of data war