Integration Systems Models
3BI
Provider of Business Intelligence Solutions
Solutions
OLTP
ETL Tools
Reporting
OLAP
Customized data models to store integrated data and to enable and ease the reporting and analysis features of your Marketing Intelligence Solutions.

Reporting repository

Most of the time, the OLTP database is not suitable for reporting purposes in terms of query response time and ease of programming. The OLTP database structure needs to be transformed in order to provide the best response time as possible when querying the data for reporting purposes. Usually, the reporting database is read-only for reporting, while its data are updated through DTS/SSIS processes, either by batch or upon requests from the administrators.

Based on your reporting needs, we will define the best reporting database schema to keep the response time as low as possible.
Copyright © 2006 3BI Consulting. SA. All rights reserved.