A database is a collection of related data which represents some elements of the real world. It is designed to be built and populated with data for a specific task. It is also a building block of your data solution.
In this tutorial, you will learn
A data warehouse is an information system which stores historical and commutative data from single or multiple sources. It is designed to analyze, report, integrate transaction data from different sources.
Data Warehouse eases the analysis and reporting process of an organization. It is also a single version of truth for the organization for decision making and forecasting process.
Here, are prime reasons for using Database system:
Here, are Important reasons for using Data Warehouse:
Is designed to record
Is designed to analyze
The database uses the Online Transactional Processing (OLTP)
Data warehouse uses Online Analytical Processing (OLAP).
The database helps to perform fundamental operations for your business
Data warehouse allows you to analyze your business.
Tables and Joins
Tables and joins of a database are complex as they are normalized.
Table and joins are simple in a data warehouse because they are denormalized.
Is an application-oriented collection of data
It is a subject-oriented collection of data
Generally limited to a single application
Stores data from any number of applications
Data is available real-time
Data is refreshed from source systems as and when needed
ER modeling techniques are used for designing.
Data modeling techniques are used for designing.
Data stored in the Database is up to date.
Current and Historical Data is stored in Data Warehouse. May not be up to date.
Storage of data
Flat Relational Approach method is used for data storage.
Data Ware House uses dimensional and normalized approach for the data structure. Example: Star and snowflake schema.
Simple transaction queries are used.
Complex queries are used for analysis purpose.
Detailed Data is stored in a database.
It stores highly summarized data.
Use in the banking sector for customer information, account-related activities, payments, deposits, loans, credit cards, etc.
Use for reservations and schedule information.
To store student information, course registrations, colleges, and results.
It helps to store call records, monthly bills, balance maintenance, etc.
Helps you to store information related stock, sales, and purchases of stocks and bonds.
Sales & Production
Use for storing customer, product and sales details.
It is used for the data management of the supply chain and for tracking production of items, inventories status.
Detail about employee's salaries, deduction, generation of paychecks, etc.
It is used for airline system management operations like crew assignment, analyzes of route, frequent flyer program discount schemes for passenger, etc.
It is used in the banking sector to manage the resources available on the desk effectively.
Data warehouse used to strategize and predict outcomes, create patient's treatment reports, etc. Advanced machine learning, big data enable datawarehouse systems can predict ailments.
Data warehouses are widely used to analyze data patterns, customer trends, and to track market movements quickly.
It helps you to track items, identify the buying pattern of the customer, promotions and also used for determining pricing policy.
In this sector, data warehouse used for product promotions, sales decisions and to make distribution decisions.
To sum up, we can say that the database helps to perform the fundamental operation of business while the data warehouse helps you to analyze your business. You choose either one of them based on your business goals.
本文分享自微信公众号 - 有关SQL（SQLHub），作者：Lenis
原文出处及转载信息见文内详细说明，如有侵权，请联系 firstname.lastname@example.org 删除。
【导读】专知内容组整理了最近六篇机器翻译（Machine Translation）相关文章，为大家进行介绍，欢迎查看! 1. Baselines and tes...