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
What else can I help you with?
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.
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.
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 are difference between cache database and sql database?
CACHE is multidimensional and postconsonantal database and its supporting scripting
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 difference between database management and documents management systems?
differences between document management and database technology
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 bop and traditional restaruant?
what is the difference between bop restarunt and traditional restaurant?
What is the difference between database and data warehouse?
Typically, a database versus a data warehouse, is "OLTP" (online transaction processing). That means that live inserts/updates/deletes happen to the database all the time. A data warehouse is used for statistics and trending. Nighly data feeds from stores are populated into the tables. During the day, no inserts/updates/deletes occur on the database--it is used for data gathering (queries) only.
What is the difference between inventory and warehouse?
* Inventory: A concept of having something stored. * Warehouse: A building to store goods in.
