answersLogoWhite

0

{| |+ Differences |- | Data warehouse database OLTP database Designed for analysis of business measures by categories and attributes Designed for real time business operations. Optimized for bulk loads and large, complex, unpredictable queries that access many rows per table. Optimized for a common set of transactions, usually adding or retrieving a single row at a time per table. Loaded with consistent, valid data; requires no real time validation Optimized for validation of incoming data during transactions; uses validation data tables. Supports few concurrent users relative to OLTP Supports thousands of concurrent users. |}

http://www.geekinterview.com/question_details/15800

User Avatar

Wiki User

16y ago

What else can I help you with?

Continue Learning about Statistics

Difference between data warehouse and datamart?

A data warehouse has multiple functional areas whereby a centralized organizational unit is responsible for implementing it. On the contrary, data marts focus on particular functional areas hence are simple forms of a data warehouse.


What is the difference between data warehouse testing and conventional testing?

ETL stands for Extract-Transform-Load and it is a process of how data is loaded from the source system to the data warehouse. Data is extracted from an OLTP database, transformed to match the data warehouse schema and loaded into the data warehouse database.Many data warehouses also incorporate data from non-OLTP systems such as text files, legacy systems and spreadsheets. Conventional testing is a sort of testing in which the test engineers will check the developed application or its related parts are working accordingly to the expectations of customer or not, from coding phase of SDLC to the end


Difference between database file and flat file in DBMS?

Database file is one that is stored on a server and it is in the format that the database needs to read it. It is also stored in the database catalog. A flat file is one that is dumped from a database to import or export into another database or program. A flat file is fields of data separated by delimiters, which keep the fields separated for export/import.


What is difference between check point and save point in DBMS?

save point saves the dbms and check point simply check the database thats it simple


Difference between data warehouse and OLTP?

A data warehouse differs from OLTP in that the former handles many large and complex queries regarding various rows of a table while the latter retrieves data from single rows. At the same time, a data warehouse is not real time and supports few users at a time compared to OLTP that can support many concurrent users.

Related Questions

What are the key relationships between data warehouse and data mining?

Data warehouse is the database on which we apply data mining.


What is Difference between real time database and simple database?

the difference is about the transactions. the normal database is not included deadline, but the real time database is.


What is the difference between database and database administrator?

Database is the data stored in the server and Database administrator is the person who designs the database.


Difference between MBO and traditional management?

difference between mbo and traditional management


What is the difference between a traditional and a personal CV?

what is the difference between a 'traditional' and a 'personal' CV


What is the Comparative study between traditional data management system and database management system?

The difference between management and comparative is that one is about sex and the other is about touching up lovers


What is the difference between bop and traditional restaruant?

what is the difference between bop restarunt and traditional restaurant?


What are difference between cache database and sql database?

CACHE is multidimensional and postconsonantal database and its supporting scripting


What is the difference between database management and documents management systems?

differences between document management and database technology


What is the difference between traditional banking and modern banking?

difference between modern and traditional banking is


What is the difference between a database management system and a database?

DBMS: Set of software applications combined w/ a database


What is the difference between inventory and warehouse?

* Inventory: A concept of having something stored. * Warehouse: A building to store goods in.