The actual daily operational and business intelligence have some different requirements for data and databases. With traditional data management is difficult to establish.

The desire of every IT manager should be in the company’s ability to access constantly on the most recent data. However, the systems are not yet ready, as confirmed advisor Wolfgang Zinke, an expert in database management and data warehousing, “This is, however, with today’s database technology is not feasible.” In his opinion, but takes only the integration of operational and analytical processing on a single data base for success.

This eliminates tedious and error-prone processes involved in the archiving and the ETL (extract, transform and load), which still take place between operational and BI systems. In addition, the ubiquitous Redundnaz and waste of resources to be stopped. The results are in favor of timely and reliable BI reports.

So far, there is the core problem, that data in operational systems and BI systems usually adapt to each other. The reason is that they require different data models.
Moreover hindered large-scale Query Processing in operational BI processing. A further complication is that BI systems must often rely on historical data, while operating systems, snapshots of the data and they process and overwrite it.

Data modeling
data dealing, Data modeling, data processing, dealing with data