Difference between Operational Database(OLTP) and Data Warehouse/(OLAP).

-

 Difference between Operational Database(OLTP) and Data Warehouse/(OLAP).

• The 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 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.



Operational Database(OLTP) 

  • Operational systems are designed to support high-volume transaction processing.
  • Operational systems are usually concerned with current data.
  • Data within operational systems are mainly updated regularly according to need.
  • It is designed for real-time business dealing and processes.
  • It is optimized for a simple set of transactions, generally adding or retrieving a single row at a time per table.
  • It is optimized for validation of incoming information during transactions, uses validation data tables.
  • It supports thousands of concurrent clients.
  • Operational systems are widely process-oriented.
  • Operational systems are usually optimized to perform fast inserts and updates of associatively small volumes of data.
  • Data In
  • Less Number of data accessed.
  • Relational databases are created for online transactional processing (OLTP).



 Data Warehouse/(OLAP)

  • Data warehousing systems are typically designed to support high-volume analytical processing (i.e., OLAP).
  • Data warehousing systems are usually concerned with historical data.
  • Non-volatile, new data may be added regularly. Once Added rarely changed.
  • It is designed for the analysis of business measures by subject area, categories, and attributes.
  • It is optimized for extensive loads and high, complex, unpredictable queries that access many rows per table.
  • Loaded with consistent, valid information, requires no real-time validation.
  • It supports a few concurrent clients relative to OLTP.
  • Data warehousing systems are widely subject-oriented.
  • Data warehousing systems are usually optimized to perform fast retrievals of relatively high volumes of data.
  • Data Out
  • A large Number of data accessed.
  • Data Warehouse designed for on-line Analytical Processing (OLAP).

Comments

Post a Comment

Popular posts from this blog

What is the cloud cube model? Explain in context to the Jericho cloud cube model along with its various dimensions.

-
Image
Cloud Cube model   The Cloud Cube model helps classify a four-dimensional factor cloud network. Its concentration is on protecting and safeguarding the cloud network. This cloud cube model lets you securely pick cloud formation. This model serves to provide a safe and secured Internet network for IT administrators enterprises, and business leaders. Jericho cloud cube model  Jericho Forum is an international independent group of information security leaders & their focus is on how to protect and secure cloud networks. They put forward a model that helps to categorize a cloud network based on four-dimensional factors. The Jericho Cloud Cube Model describes the multidimensional elements of cloud computing, framing not only cloud use cases, but also how they are deployed and used. The Cloud Cube Model, established and developed by the Jericho Forum, assists in categorizing cloud networks based on four dimensions: Internal/External Proprietary/Open Perimeterised/De-perimet...
Read more

Explain cloud computing reference model .

-
Image
 CLOUD COMPUTING REFERENCE MODEL The cloud computing reference model is a general high-level architecture and is meant for a cloud computing reference architecture provided, which outlines the primary performer/actor and the understanding of the cloud computing needs, uses, features, and standards. An overview of the NIST primary players, as indicated in the figure below. Each performer is an entity that might be a person or a cloud computing activity and role. The NIST cloud computing reference architecture identifies five organization that takes part in a transaction or process and complete duties in cloud computing. 1. Cloud consumer:  The cloud consumer is the cloud computing service's most significant stakeholder. A cloud consumer is a person or organization who has a commercial connection with a cloud provider and consumes its services. A cloud consumer browses a cloud provider's service catalog, requests the right service, establishes service contracts with the cloud pr...
Read more

Discuss classification or taxonomy of virtualization at different levels.

-
Image
Taxonomy of virtualization Virtualization is mainly used to emulate the execution environment, storage, and networks. The execution environment is classified into two: – Process-level – implemented on top of an existing operating system.  – System-level – implemented directly on hardware and does not or minimum requirement of the existing operating system. OR,  Virtualization covers a wide range of emulation techniques that are applied to different areas of computing. A classification of these techniques helps us better understand their characteristics and use  V irtualization is mainly used to emulate  ● Execution Environments: To provide support for the execution of the programs eg. OS, and Application.  ○ Process Level: Implemented on top of an existing OS that has full control of the hardware  ○ System Level: Implemented directly on Hardware and do not require support from existing OS.  ● Storage: Storage vi...
Read more