![]() Various ETL tools are available in the market SSIS is one of them. What you get in the end is a data which is made perfect for reporting and separate from production OLTP so that performance of production system is not impacted while reports are running.ĮTL (Extract, Transform and Load) is the process that is used to extract the data from multiple database sources, transforming that based on the business rules and then loading them into the OLAP databases for reporting purposes. The data might go into some staging tables for cleansing before loading them into the OLAP database structure. OLAP (Online Analytical Processing) databases are extracts of one or more OLTP databases and are created for complex reporting, trend analysis and dashboards for decision making.ĭata is extracted from multiple OLTP sources using the ETL processes that run during off-peak hours. If you want to see a complex diagram of a system then have a look at AdventureWorks OLTP schema. ![]() The typical diagram of OLTP database looks something like below: Usually the OLTP data models are complex and hard to understand. Each entity is broken down into table(s) to store the data in an optimal way and to prevent data redundancy and data update anomalies. The data is kept in a normalized structures (3NF). Since OLTP databases are used by the production systems therefore response time is very critical (< 1 second) to give better user experience. OLTP (Online Transaction Processing) databases are operational databases designed to keep the day-to-day business data transactions in the most optimal way by support faster queries, faster inserts, minimal locking and avoiding duplicates. ![]() ![]() If you heard someone talking about databases then they are mostly “99.9%” of the times talking about the OLTP databases. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |