DBMS - January 1998


Transaction Processing Today by Ken Rudin OLTP systems support day-to-day operations and supply data to data warehouses. They also manage large volumes of transactions for e-commerce. In the first installment of a year-long series from the Emergent Corp., Ken Rudin explains what it takes to build a successful OLTP system and how emerging trends will affect tomorrowıs OLTP developers. Bringing up Supermarts by Ralph Kimball One of the most widely debated issues in data warehousing is how to plan the warehouse construction. Do we build the whole data warehouse all at once or do we build separate subject-area data marts whenever we feel like it? Ralph Kimball provides his own architectural plan for designing data marts and integrating them with your enterprise data warehouse.	From the Editor by Maurice Frank Year 2000: the sequel. Enterprise Manager by Judith Hurwitz Sorting out middleware. Data Warehouse Architect by Ralph Kimball Transactions and snapshots. SQL for Smarties by Joe Celko Intranet insecurity. Application Architect by David S. Linthicum IBMıs San Francisco project. Server Side by Martin Rennhackkamp Sybase Adaptive Server 11.5. Net Developer by Nelson King Comparing Microsoft and JavaSoft frameworks.
Special Section: Year 2000 Issues Oracle Year 2000 Pitfalls By Ben Lis The Year 2000 is not just a problem for mainframe applications. This article reviews common Y2K issues for Oracle-based apps that can crop up in almost any DBMS. Social Security After 2000 By Steve Wilent The Social Security Administrationıs (SSA) systems are riddled with dates, but the SSA is not worried. Find out how the SSA began preparing for the year 2000 as early as 1989. Testing Year 2000 Conversions By Andrew Pollner You found and fixed the code, but now itıs time to test your conversions. Learn several approaches for certifying that your applications will work in the next century.

Transaction Processing Today
by Ken Rudin
OLTP systems support day-to-day operations and supply data to data warehouses. They also manage large volumes of transactions for e-commerce. In the first installment of a year-long series from the Emergent Corp., Ken Rudin explains what it takes to build a successful OLTP system and how emerging trends will affect tomorrowıs OLTP developers.

Bringing up Supermarts
by Ralph Kimball
One of the most widely debated issues in data warehousing is how to plan the warehouse construction. Do we build the whole data warehouse all at once or do we build separate subject-area data marts whenever we feel like it? Ralph Kimball provides his own architectural plan for designing data marts and integrating them with your enterprise data warehouse.

From the Editor
by Maurice Frank
Year 2000: the sequel.

Enterprise Manager
by Judith Hurwitz
Sorting out middleware.

Data Warehouse Architect
by Ralph Kimball
Transactions and snapshots.

SQL for Smarties
by Joe Celko
Intranet insecurity.

Application Architect
by David S. Linthicum
IBMıs San Francisco project.

Server Side
by Martin Rennhackkamp
Sybase Adaptive Server 11.5.

Net Developer
by Nelson King
Comparing Microsoft and JavaSoft frameworks.

Special Section: Year 2000 Issues

Oracle Year 2000 Pitfalls
By Ben Lis
The Year 2000 is not just a problem for mainframe applications. This article reviews common Y2K issues for Oracle-based apps that can crop up in almost any DBMS.

Social Security After 2000
By Steve Wilent
The Social Security Administrationıs (SSA) systems are riddled with dates, but the SSA is not worried. Find out how the SSA began preparing for the year 2000 as early as 1989.

Testing Year 2000 Conversions
By Andrew Pollner
You found and fixed the code, but now itıs time to test your conversions. Learn several approaches for certifying that your applications will work in the next century.

ONLINE NOW:
Java for Electronic Commerce
By Kurt Indermaur
Two nascent technologies are converging ı but how reliable are the results?

Hands-On Reviews

Seagate Softwareıs Crystal Reports Professional 6.0 adds new interactive Web publishing features to its report writer for developers and end users.
By Julie Woods McNamara
Sylvain Faust Inc.ıs SQL-Optimizer 1.0.4 is a performance-management SQL monitor for Oracle servers.
By Robin Schumacher
Soft Notes, new products and upgrades.

Letters

Event Alerter
A calendar of conferences, trade shows, and seminars.
Start Here
Industry insight and commentary.

1998 Editor's Choice Awards

Please send questions or comments to dbms@mfi.com
Updated December 12, 1997.