Wednesday, August 14, 2019

Data Warehouse vs Database

Data warehouses and Databases are both relational data systems, but were built to serve different purposes. A data warehouse is built to store large quantities of historical data and enable fast, complex queries across all the data, typically using Online Analytical Processing (OLAP). A database was built to store current transactions and enable fast access to specific transactions for ongoing business processes, known as Online Transaction Processing (OLTP).
ParameterDatabaseData Warehouse
PurposeIs designed to recordIs designed to analyze
Processing MethodThe database uses the Online Transactional Processing (OLTP)Data warehouse uses Online Analytical Processing (OLAP)
UsageThe database helps to perform fundamental operations for your businessData warehouse allows you to analyze your business
Tables and JoinsTables and joins of a database are complex as they are normalizedTable and joins are simple in a data warehouse because they are denormalized
OrientationIs an application-oriented collection of dataIt is a subject-oriented collection of data
Storage limitGenerally limited to a single applicationStores data from any number of applications
AvailabilityData is available real-timeData is refreshed from source systems as and when needed
UsageER modeling techniques are used for designingData modeling techniques are used for designing
TechniqueCapture dataAnalyze data
Data TypeData stored in the Database is up to dateCurrent and Historical Data is stored in Data Warehouse May not be up to date
Storage of dataFlat Relational Approach method is used for data storageData Ware House uses dimensional and normalized approach for the data structure Example: Star and snowflake schema
Query TypeSimple transaction queries are usedComplex queries are used for analysis purpose


No comments:

Post a Comment

Note: Only a member of this blog may post a comment.