Big Data Warehousing

Sorted by:  

The Data Warehouse Supreme

Today’s state-of-the-art data warehouse typically looks like a complicated data warehouse deluxe. The data warehouse of tomorrow, though — the data warehouse supreme — will look quite different. There [more…]

Data Sources and Business Intelligence Tools for Data Warehouse Supreme

Because of the wide breadth of subject areas in a data warehouse supreme, it has numerous data sources. The good news: Because many of the sources are external to your own warehousing environment, you [more…]

Data Extraction, Movement, and Loading for Data Warehouse Supreme

A data warehouse has large-scale data distribution and advanced technologies that can integrate various “run the business” systems, improving the overall quality of the data assets across business information [more…]

Data Marts Sourced by a Data Warehouse

Many data warehousing experts would argue that a true data mart is a “retail outlet,” and a data warehouse provides its contents, as shown in this figure. [more…]

Top-Down, Quick-Strike Data Marts

Sometimes, you just don’t have a data warehouse from which to get data for your data mart, so you have to source the data from applications yourself. In many [more…]

What to Put in a Data Mart

If a data mart is a smaller-scale version of a data warehouse, this question comes up: What does “smaller scale” mean in reference to the contents of a data mart? The answer to this question is typically [more…]

Data Mart or Data Warehouse?

The idea of a data mart is hardly revolutionary, despite what you might read on blogs and in the computer trade press, and what you might hear at conferences or seminars. A data mart is simply a scaled-down [more…]

Implement a Data Mart — Quickly

No matter how you decide to divide the universe of possible contents into some subset for your data mart, remember that in order to obtain maximum business value from your data mart, you must implement [more…]

What’s a Relational Database Management System?

Forget all about the mathematical foundations of the relational model, the principles of normalization, and other highly technical aspects of RDBMSs. If you’re interested, consult any one of the many available [more…]

Relational Products and Data Warehousing

Here are some leading relational database products that you might want to use for your data warehouse. Almost all these vendors have, during the past few years, acquired additional products, including [more…]

Multidimensional Databases

This isn’t the first time in recent history that new types of database products have emerged and overcome RDBMS inefficiencies. Back in the 1980s, a class of applications was identified in which RDBMS [more…]

A Brief History of Data Warehousing

Many people, when they first hear the basic principles of data warehousing — particularly copying data from one place to another — think (or even say), “That doesn’t make any sense! Why waste time copying [more…]

How to Manufacture Data Assets

A data warehouse is a home for your high-value data, or data assets. Most organizations build a data warehouse for manufactured data assets in a relatively straightforward manner, following these steps [more…]

Ten Questions to Consider When You’re Selecting User Tools

Few things are more frustrating than successfully building a data warehouse and then having it rendered unusable by less-than-satisfactory user tools. This list presents some questions to consider when [more…]

Ten Secrets to Managing Your Project Successfully

Being a successful data warehouse project manager means that you have to do more — much more — than simply create project plans and ask team members to turn in weekly status reports. Here are a few secrets [more…]

Prepare for Semantics in Data Warehousing

If you evaluate how the technologies associated with data warehousing work, a lot of metadata is managed in a proprietary manner within the tool. Some have attempted in the past to solve the integration [more…]

How Semantics Applies to Business Intelligence

Ask yourself and your data warehousing project teams this question: How will you prepare for these technologies? Focus on three areas that you’re probably already working in — your business intelligence [more…]

Traditional Data Warehousing Means Analyzing Traditional Data Types

When planning for data warehousing, remember that today’s data landscape now encompasses a dizzying array of new information channels, new sources of data, and new analysis and reporting imperatives. [more…]

Data Warehousing and Multimedia Information

Every area of technology is constantly changing, and data warehousing is no exception. Because data warehousing is on the brink of a new generation of technologies, you must become familiar with some of [more…]

How Does Business Intelligence Work with Unstructured Data?

Suppose that you’re using an unstructured, multimedia-enabled data warehousing environment to do comparative analysis between services offered by your company [more…]

Data Warehousing: From Unstructured Information to Structured Data

Some data warehousing architecture plans demonstrate an approach of putting structured data first, in which a business analyst uses data warehousing as a gateway into appropriate unstructured supporting [more…]

Do You Need Data Warehousing Consultants?

You probably need data warehousing consultants, not because people from within your organization aren’t capable of working with data warehousing technology or completing a project without outside help. [more…]

Data Warehousing Consultants: Things to Watch Out For

If you’ve ever worked with IT consultants (data warehousing specialists), you realize that not all consultants are equally skilled, equally dedicated, or equipped with the same, shall we say, degree of [more…]

Tips for Data Warehousing Consultants

Most information on this website regarding data warehousing is oriented primarily toward the user community and how the people in it might find and retain consultants for their data warehousing projects [more…]

Meet with Data Warehousing Representatives

Shopping around for data warehousing products can include meetings with company reps. Before a vendor sales representative sets foot inside your office or initiates a Web conference with you, make absolutely [more…]


Sign Up for RSS Feeds

Computers & Software