answersLogoWhite

0

These maybe appear to be similar but they have very important differences.

Data Base: It contains a collection of current status of the stored data. The structure is achieved by organising the data according to a data base model. Today, the most common model is the rational model. The most important task of on-line operational database system is to perform on-line transaction and query processing. So, these systems are named Online Transactional Processing (OLTP) systems. Moreover, database system support ad-hoc query and online transaction processing, can be used for other purposes such as data warehousing.

Data Warehouse: Data warehouse is a repository of information collected from multiple sources, such as different databases of a company in different places, which stored under a unified schema, over a history of time. Moreover, it is used for decision support and data analysis. It consists of a process of data cleaning, data integration, data transform, data loading, and data refreshing. Data warehouse is used for Online Analytical Processing (OLAP).

The major difference between OLTP and OLAP are summarised as follows:

OLTP is customer-oriented and it's used by clients, and clerks. But, OLAP is market-oriented and is used for data analysis by managers and analysts.

These have different content too, the first one has current data with detail. Furthermore, is easily used for getting decision; however, another one has large amount of historical data, which provides facilities for summarisation, and store information in different levels of granularity. Because of their huge volume, OLAP data are stored on multiple storage media.

The main similarity is that both of them are repositories of information, storage large amounts of data.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is a system based system?

A database system is a term that is typically used to encapsulate the constructs of a data model, database Management system (DBMS) and database .. (natsume)


A phylum is based on what similarities between animals?

Internal Similarities.


What is a data based system?

A database system is a term that is typically used to encapsulate the constructs of a data model, database Management system (DBMS) and database .. (natsume)


What kind of a database management system is Oracle Database?

Oracle database is the first database management system based on the System-R model of IBM and the first relational database that uses SQL. Though it supports various operating systems.


What model was the Relational Database Management System based on?

The Relational Database Management System was based on a good model. It is based on first-order predicate logic which was discovered in 1969 by a man named Codd.


The modern classification system is based on structural similarities and?

Evolutionary Relationship


Is MySQL DBMS or RDBMS?

AnswerMySQL, like most modern Database Management Systems is based on the relational model. So it is a RDBMS (Relational Database Management System).


5 Designed a system of classifying organisms based on their physical and structural similarities?

Linnaeus


What is the difference between a computerised database and a paper-based database?

Computerised data is on a computer (well yah) and a paper database is on a peice of paper ( XD ). It is also easier with a Computerised database as it is easier!!!!! :D:D:D:D:D


What is a paper based database?

One paper-based database I can readily think of is a phone book. Paper based database is database that consists of many papers, not a e-database! Paper-based communicaton is anything written, drawn or printed.


Similarities between UNIX and Windows?

UNIX is a command-based OS. In contrast, Windows is a menu-based OS.


What is the one that does not belong between Linux Unix Solaris and D SQL sever?

The Odd OneLINUX, UNIX, SOLARIS are the UNIX based operating system.SQL SERVER is a database system from IBM.