100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
Previously searched by you
"Comprehensive Notes on Python Programming, Data Mining and Data Warehousing Techniques, and Essential Soft Skills for Career Success", "Comprehensive Notes on Python Programming, Data Mining and Warehousing, and Essential Soft Skills for Succes$8.49
Add to cart
"Comprehensive Notes on Python Programming, Data Mining and Data Warehousing Techniques, and Essential Soft Skills for Career Success", "Comprehensive Notes on Python Programming, Data Mining and Warehousing, and Essential Soft Skills for Succes
Data Warehouse
Data Warehouse is a relational database management system (RDBMS)
construct to meet the requirement of transaction processing systems. It can
be loosely described as any centralized data repository which can be queried
for business benefits. It is a database that stores information oriented to
satisfy decision-making requests. It is a group of decision support
technologies, targets to enabling the knowledge worker (executive,
manager, and analyst) to make superior and higher decisions. So, Data
Warehousing support architectures and tool for business executives to
systematically organize, understand and use their information to make
strategic decisions.
Data Warehouse environment contains an extraction, transportation, and
loading (ETL) solution, an online analytical processing (OLAP) engine,
customer analysis tools, and other applications that handle the process of
gathering information and delivering it to business users.
What is a Data Warehouse?
A Data Warehouse (DW) is a relational database that is designed for query
and analysis rather than transaction processing. It includes historical data
derived from transaction data from single and multiple sources.
A Data Warehouse provides integrated, enterprise-wide, historical data and
focuses on providing support for decision-makers for data modeling and
analysis.
A Data Warehouse is a group of data specific to the entire organization, not
only to a particular group of users.
It is not used for daily operations and transaction processing but used for
making decisions.
A Data Warehouse can be viewed as a data system with the following
attributes:
o It is a database designed for investigative tasks, using data from
various applications.
o It supports a relatively small number of clients with relatively long
interactions.
, o It includes current and historical data to provide a historical
perspective of information.
o Its usage is read-intensive.
o It contains a few large tables.
"Data Warehouse is a subject-oriented, integrated, and time-variant store of
information in support of management's decisions."
Goals of Data Warehousing
o To help reporting as well as analysis
o Maintain the organization's historical information
o Be the foundation for decision making.
Need for Data Warehouse
Data Warehouse is needed for the following reasons:
1. 1) Business User: Business users require a data warehouse to view
summarized data from the past. Since these people are non-technical,
the data may be presented to them in an elementary form.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller ajijnadaf. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.49. You're not tied to anything after your purchase.
