FREE DM Review Site Registration!
Sign-up today and access DM Review on the Web!

Your FREE registration entitles you to:

FREE email newsletters

FREE access to all DM Review content

FREE access to web seminars, resource portals, our white paper library and more!

   

Publisher reserves the right to serve qualified requesters only.

Databases Channel

Articles

Time and Time Again: Managing Time in Relational Databases, Part 25 - Original and Temporal Inserts

We turn to temporal integrity constraints as they apply to insert and to upsert transactions.

Time and Time Again - Managing Time in Relational Databases, Part 24: Original and Temporal Updates (Concluded)

As this series continues, context becomes increasingly important so that the thread of the discussion is not lost.

Time and Time Again: Managing Time in Relational Databases, Part 23 - Original and Temporal Updates

This article continues our discussion reviewing temporal RI rules.

Essential Steps for the Integrated Enterprise Data Warehouse, Part 1

This article provides guidance to what an integrated EDW is and what design elements are needed to achieve integration.

Time and Time Again: Managing Time in Relational Databases - Part 22: Original and Temporal Deletes

This article completes our discussion of delete transactions.

Columns

Data Archiving - A Quiet Market Reaches Take-off Velocity

Data archiving is a quiet market with significant potential. Given the growth in data volumes and intolerance for response time delays, interest in the capabilities of archiving, retention and restore software is reaching take-off speed.

The Problems of Megadata Searches

This column explores what would happen if databases were organizied more like libaries.

Data Models are Not Database Design

Examine the assumption that a data model can capture all the information about the design of a database.

The Logical/Physical Challenge in Data Management

Ask the Experts

How does the newest release of MySQL measure up to the task of managing a several GB database, especially in reporting?

Is there a best practice associated with the number of distinct databases that should be used in the overall warehouse?

Do you have any specific suggestions about the use of a primary key in fact tables?

What are native connections? How are they different from ODBC connections? What are the advantages and disadvantages of native connections?

Do you think that multidimensional databases (MDDBs) are hindered by poor scalability?

White Papers

Databasing in the 90s: Data and What We're Doing with It!

By Jennifer Barrett - Acxiom Corporation

Constant Replicator DB for MySQL Cluster

By Constant Data

eStore Advantage - Extending Microsoft eConnect for MBS Great Plains

By Nodus Technologies, Inc.

Is Your Database Eating Out The Heart of Your IT Infrastructure.

By IDG

UML for C#

By Harold Halbleib

Books

Oracle8 Data Warehousing

By Gary Dodge, Tim Gorman

Oracle Database Administration: The Essential Reference

By David Kreines and Brian Laskey

SQL Server 7 Data Warehousing

By Michael Abbey, Ian Abramson, Larry Barnes, Rajan Venkitachalam, Benjamin Taub and Michael J. Corey




Industry Vendors