QuickStudy: Data Collections

Bases, Marts, Warehouses

By Marc Songini

April 15, 2002 12:00 PM ET

Comments

Computerworld - The explosion of e-business - and the massive amount of data it created - has made data management and organization more important than ever. We often hear the terms database, data warehouse and data mart, but the differences among them aren't always clear. Some experts say that the difference between, say, a data mart and a data warehouse is more conceptual than real. Nonetheless, here are some general rules of thumb to sort out these terms.

In the Beginning . . .

A datum is a raw piece of information that's capable of being moved and stored. In the broadest sense, a database is a collection or aggregation of such data, along with information on how pieces of data relate to one another.

More
Computerworld
QuickStudies

A database is typically organized into records - one record per item, such as an order - that are themselves divided into several fields, with each field containing information about a specific aspect or attribute of the item. For an order, these could include customer data, part numbers, prices and discounts.

In theory, a database doesn't even require a computer, but it certainly makes its use a lot more scalable and efficient, says Mike Schiff, an analyst at Current Analysis Inc. in Sterling, Va. A pocket address book is certainly a database, but searching contact entries by city or industry requires flipping through each page.

Database management systems, such as those from Microsoft Corp., Oracle Corp. or IBM, act as the underlying vault and retrieval technology.

In addition to storing data, a database management system handles security and access control, says Schiff. Business intelligence tools then access this data for analysis. However, databases rarely exist just to run analytical operations; in general, they're vital to running a business.

Database management systems can be organized in different ways. A relational database stores information in tables and then joins or combines those tables across common fields. A hierarchical database stores data in a tree structure; an order record might have every line item underneath it. An object-oriented database encapsulates both data and business logic.

Comment Recommend Digg Twitter ShareThis

Email Print Send Feedback Reprints

Jump to comments

relational databases

Additional Resources

WHITE PAPER

Do You Know the 7 Steps to Successful Data Migration?

Approximately 60 percent of data migration projects overrun time or budget, while some fail completely. Download this white paper, "Enhancing Your Chance for Successful Data Migration," to learn the critical steps you need to take to execute a data migration project with minimum cost and risk to your business.

WHITE PAPER

Total Cost of Ownership of Server Computing Vs. PCs

Read the Gartner research note to learn why the TCO of a server-based computing deployment used to deliver all applications to users is around 50% lower than that of an unmanaged desktop deployment.

WHITE PAPER

IDC White Paper: Linux in a Global Recession

Economic downturns have a tendency to accelerate emerging technologies, boost the adoption of effective solutions, and punish solutions that are not cost competitive or that are out of synch with industry trends. This IDC White Paper presents the results of an IDC survey of 330 companies in Western Europe, Asia/Pacific and the Americas that measures the receptiveness to Linux and takes into consideration changing views driven by the disruptive economic environment that businesses face today.

What People Are Saying

0 comments | Add new

See all comments (0) | Add new

White Papers & Webcasts

Informatica 9 Launch: Transform your Business. Transform your world.

LIVE Nov 10, 2009 12:00 PM ET

Architecting Business Intelligence Applications for Change: The Open Solution

LIVE Nov 12, 2009 02:00 PM ET

IDC Research Report: The Business Value of Consolidating on Energy-Efficient Servers
Download this Resource Now!

Top to Bottom Performance Management Excellence at the City of Chicago
View now.

HP Technology Guide for Scalable Business Solutions
Download This Resource Now!

Architecting Business Intelligence Applications for Change: The Open Solution
Register for this webcast today!

Clipper Group Report: HP Provides Enhanced Options for Data Center
Download this Resource Now!

Enterprise Data Governance: Bridging the Business-IT Gap
Register for this live webcast today!

Technology Brief: Technologies in HP ProLiant G6 c-Class server blades with Intel Xeon processors
Download this Resource Now!

Informatica 9 Launch: Transform your Business. Transform your world.
Business and IT will finally be on the same page. Data quality issues will be a thing of the past. The promise of...

Introducing the HP ProLiant G6 servers
Download this Resource Now!

Lower IT Costs with Oracle Database 11g Release 2
Register for this webcast now!

All White Papers | All Webcasts