answersLogoWhite

0


Best Answer

Data warehouse database

Designed for analysis of business measures by categories and attributes

Optimized for bulk loads and large, complex, unpredictable queries that access many rows per table.

Loaded with consistent, valid data; requires no real time validation

Supports few concurrent users relative to OLTP

OLTP database

Designed for real time business operations.

Optimized for a common set of transactions, usually adding or retrieving a single row at a time per table.

Optimized for validation of incoming data during transactions; uses validation data tables.

Supports thousands of concurrent users.

User Avatar

Wiki User

16y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are major differences between data warehousing and a relational database?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are the differences between database management system Vs relational dbms?

the database management system analysis the data or record but relational database management system links the database to each other.


How are relationship between tables expressed in a relational database?

Tables are the basic building blocks of a relational database.


What are the differences between Oracle 10g and ms sql database?

Oracle is an RDBMS aka Relational Database Management System and SQL (Structured Query Language) is a programming language.


Difference between database and relational database?

A database is a collection of data organized for easy access and manipulation, while a relational database is a type of database that stores data in a structured format using tables that are related to each other through keys. In a relational database, data is organized into rows and columns, and relationships between tables can be established using keys.


Difference between database and relational database explain with example?

Database = Generic name for a system to store data Relational Database = A specific type of database that utilizes relationships between data to not only store the data but further its efficiency in its manipulation.


What are the differences between Oracle and SQL?

Oracle is an RDBMS aka Relational Database Management System and SQL (Structured Query Language) is a programming language.


Differences between relational database management system and database management system?

A relational database management system (RDBMS) is a type of DBMS that stores data in a structured format using tables with rows and columns, and enforces relationships between data. A DBMS, on the other hand, is a broader term that encompasses various systems for managing databases, including relational, object-oriented, and NoSQL databases. In summary, an RDBMS is a specific type of DBMS that organizes data in a relational model.


Find out functional dependencies?

A constraint between two sets of attributes is known as functional dependency in relational database. Determination of functional dependencies is vital in database denormalization, normalization and relational model.


Are there any major similiarities between object oriented databases and relational databases?

In a Object Oriented Database, information is given in the form of objects as used in programming languages. "When database capabilities are combined with object programming language capabilities, the result is an object database management system (ODBMS). An ODBMS makes database objects appear as programming language objects in one or more object programming languages." (http://en.wikipedia.org/wiki/Object_database)"A relational database is a database that conforms to the relational model, and refers to a database's data and schema (the database's structure of how those data are arranged). Common usage of the term "Relational database management system" technically refers to the software used to create a relational database, but sometimes mistakenly refers to a relational database." (http://en.wikipedia.org/wiki/Relational_database)


What is the database that contains tables linked by common fields?

A relational database is a database that contains tables linked by common fields. These common fields are used to establish connections between the tables and to retrieve related data across multiple tables using queries.


What is a database that understands how information is connected called?

A database that understands how information is connected is called a relational database. It organizes data into tables with rows and columns, and uses keys to establish relationships between different tables. This allows for efficient storage and retrieval of interconnected information.


What is the most common type of relationship between tables in a relational database?

one-to-many relationship