{| |+ 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
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.
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
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.
save point saves the dbms and check point simply check the database thats it simple
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.
Data warehouse is the database on which we apply data mining.
the difference is about the transactions. the normal database is not included deadline, but the real time database is.
Database is the data stored in the server and Database administrator is the person who designs the database.
difference between mbo and traditional management
what is the difference between a 'traditional' and a 'personal' CV
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 restarunt and traditional restaurant?
CACHE is multidimensional and postconsonantal database and its supporting scripting
differences between document management and database technology
difference between modern and traditional banking is
DBMS: Set of software applications combined w/ a database
* Inventory: A concept of having something stored. * Warehouse: A building to store goods in.