Purchase Solution

Data warehouse concepts

Not what you're looking for?

Ask Custom Question

Please provide a detailed expkanation of the following concepts
o An explanation of data warehouse concepts
o The benefits of data mining
o The hazards of data mining
o Recommendations on managing benefits and minimizing hazards

Purchase this Solution

Solution Summary

Data warehouse concepts, standards of data mining, recommendations on managing benefits and minimizing hazards.

Solution Preview

Data warehouse concepts
A data warehouse is a storage medium designed with very specific characteristics and relevant application of interest such that the data contained in the database is subject-oriented; this means data contained is related to a certain subject area for instance a data warehouse containing data pertaining to lung cancer patients only. The main reason for an explicit aspect is to make it a basis for decision-making and decision-supporting activities. A data warehouse has significant features to support the way it is structured:
- The information is integrated which allows multiple dynamics views and possibilities of processing it. It provides analytics for trending, patterning, researching, marketing, and decision-making.
- The data or information contained in a data warehouse is usually only accessed for reading purposes; therefore information doesn't change much and remains consistent due to the fact that it is not processed like in a transactional database.
- Data is collected and fed into a data warehouse from several sources that relate to the subject of interest
- Historical information is particularly safeguarded and kept intact in a data warehouse as it provides rich background information especially in a health care system.
- The data warehouse development cycle is unlike the software development life cycle
- Other characteristics include a lax on performance, availability, and non-redundancy. It is a flexible store where data sets are accessed as snapshots or summaries based on a subject.
- Main tools that enable access to data warehouses include reporting tools such as Business Objects, query languages such as SQL, OLAP tools, and ...

Purchase this Solution


Free BrainMass Quizzes
Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

C# variables and classes

This quiz contains questions about C# classes and variables.