Purchase Solution

Data Warehousing

Not what you're looking for?

Ask Custom Question

What is data warehousing? How are databases and data warehousing related? Do you believe data warehousing is a fad or a "real" technology which will benefit organizations?

What are XML databases? Are these of any value to organizations?

Purchase this Solution

Solution Preview

"What is data warehousing?"
- A data warehouse is a repository storing integrated information for efficient querying and analysis. Information is extracted from heterogeneous sources as it is generated or updated. The information is then translated into a common data model and integrated with existing data at the warehouse. When a user query is submitted to the warehouse, the needed information is already there, with inconsistencies and differences already resolved. This makes it much easier and more efficient to run queries over data that originally came from different sources. Key advantages of data warehousing include:
- Since query execution does not involve data translation and communication with remote sources, complex queries can be executed easily and efficiently.
- End users can use a single data model and query language.
- System design becomes simpler. For example, there is no need to perform query optimization over heterogeneous sources, a very difficult problem faced by other approaches.
- Information sources may be unreliable and may purge ...

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.

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.

Javscript Basics

Quiz on basics of javascript programming language.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.