next → ← prev Show
Difference between Operational Database and Data WarehouseThe Operational Database is the source of information for the data warehouse. It includes detailed information used to run the day to day operations of the business. The data frequently changes as updates are made and reflect the current value of the last transactions. Operational Database Management Systems also called as OLTP (Online Transactions Processing Databases), are used to manage dynamic data in real-time. Data Warehouse Systems serve users or knowledge workers in the purpose of data analysis and decision-making. Such systems can organize and present information in specific formats to accommodate the diverse needs of various users. These systems are called as Online-Analytical Processing (OLAP) Systems. Data Warehouse and the OLTP database are both relational databases. However, the goals of both these databases are different.
Difference between OLTP and OLAPOLTP SystemOLTP System handle with operational data. Operational data are those data contained in the operation of a particular system. Example, ATM transactions and Bank transactions, etc. OLAP SystemOLAP handle with Historical Data or Archival Data. Historical data are those data that are achieved over a long period. For example, if we collect the last 10 years information about flight reservation, the data can give us much meaningful data such as the trends in the reservation. This may provide useful information like peak time of travel, what kind of people are traveling in various classes (Economy/Business) etc. The major difference between an OLTP and OLAP system is the amount of data analyzed in a single transaction. Whereas an OLTP manage many concurrent customers and queries touching only an individual record or limited groups of files at a time. An OLAP system must have the capability to operate on millions of files to answer a single query.
Next TopicData Warehouse Architecture ← prev next → What are the 5 reasons that business analysis is difficult from operational databases?What are the 5 reasons for why business analysis is difficult from operational databases?. Inconsistent data information.. Lack of data standards.. Poor data quality.. Inadequate data usefulness.. Ineffective direct data access.. Which of the following is an approach to business governance that values decisions that can be backed up with verifiable data?Data-driven decision management (DDDM) is an approach to business governance that values decisions that can be backed up with verifiable data. The success of the data-driven approach is reliant upon the quality of the data gathered and the effectiveness of its analysis and interpretation.
What is a technique for establishing a match or balance between the source data and the target data warehouse multiple choice question?A data map is a technique for establishing a match, or balance, between the source data and the target data warehouse. A data point is an individual item on a graph or chart. Organizational data includes simple structured data elements in a database.
|