Article Index - 1998

Sorted by issue date (newest to oldest) and page number

1998 (Volume 11)

September
August
July
June
May
April
March
February
January

Letters
(Letters)
Page 4

Passing the Torch
The end of DBMS is just another beginning. (Column: From the Editor)
Stodder, David B.; Page 6

Application Integration
Merging integration and business value. (Column: Enterprise Manager)
Hurwitz, Judith; Knickle, Kimberly; Page 8

Help for Hierarchies
Helper tables handle dimensions with complex hierarchies. (Column: Data Warehouse Architect)
Kimball, Ralph; Page 12

Yet Another SQL Sequel
What the future holds for Celko, Plato, and Aristotle. (Column: SQL for Smarties)
Celko, Joe; Page 18

Message Brokers Rising
Message brokers provide an ideal solution for integrating enterprise applications. (Column: Application Architect)
Linthicum, David S.; Page 20

Rational Rose 98
Rational Rose 98 is a visual modeling tool for enterprise-level modeling and component construction. It includes support for COM/DCOM, JavaBeans, CORBA, and ActiveX. (Review)
Schumacher, Robin; Page 24

KisMeta Validator 1.1
Validator is a standards tool that lets you set up, disseminate, and enforce standards. It contains a database of standards in the form of naming conventions, data type standards, and field specifications. (Review)
Carnell, Michael; Page 27

At Your Service?
A state-of-the-industry report on electronic agents for E-commerce. (Feature)
Indermaur, Kurt; Page 31

Pakcaged Apps on Scalable Systems
The increasing demands of data warehousin, data minin, E-commerce, and Web access are making packaged application scalability a critical requirement. (Feature)
Jernigan, Kevin; Page 39

Application Clusters on the Rise
Application clusters are the next major leap in clustering technology, lettingyou apply high-end design principles and tehnology to any scale application at a reasonable cost. (Feature)
Bheemarasetti, Satyam; Page 45

One for the Road
Sybase's new Adaptive Server Anywhere 6.0 takes the high road. (Column: Server Side)
Rennhackkamp, Martin; Page 55

The Store's the Thing
Comparison shopping for better online commerce. (Column: Net Developer)
King, Nelson; Page 61

August, 1998 (Volume 11, Number 8)

Letters
(Letters)
Page 4

Minding Your Marts and Martlets
Do data marts cause the very same chaos they were supposed to end? (Column: From the Editor)
Parkes, Clara H.; Page 6

The Hypertier Component Model
A flexible applications architecture will help your organization succeed. (Column: Enterprise Manager)
Hurwitz, Judith; Page 8

Help for Dimensional Modeling
Helper tables let you design and manage multivalued dimensions successfully. (Column: Data Warehouse Architect)
Kimball, Ralph; Page 14

Happier Marriages Through Math
Procedural code can be useful for computation-intensive queries. (Column: SQL for Smarties)
Celko, Joe; Page 18

Middleware Performance
Some performance guidelines for selecting middleware. (Column: Application Architect)
Linthicum, David S.; Page 22

Microsoft Visual J++ 6.0
Visual J++ 6.0 is a Java development tool that directs support for the Windows API, most notably through support of Component Object Model (COM) objects and the Windows Foundation Classes (WFC) for Java. (Review)
Reichard, Kevin; Page 27

AlphaBlox Enlighten 1.1
AlphaBlox Enlighten produces analysis applications for the Web. These applications are focused on reporting, summarizing, aggregating, and navigating large amounts of information. (Review)
Ritter, Dave; Page 30

Reaping the Web for Your Data Warehouse
The application of Web technology to data warehousing is an intriguing combination, but does it deliver practical value? (Feature)
Hackathorn, Richard D.; Page 36

Scoping Your Data Mart Implementation
Think all data w3arehouse projects are the same? Think again. (Feature)
Dyche, Jill; Page 43

IBM's Intelligent Family
Decision making driven by IBM's business intelligence initiative. (Column: Server Side)
Rennhackkamp, Martin; Page 71

The Promise of EJB
The EJB specification brings a mutltitier model to the Java platform. (Column: Component Assembler)
Spitzer, Tom; Page 75

Back to the Future
(Column: Start Here)
Parkes, Clara H.; Page 80

July, 1998 (Volume 11, Number 7)

Letters
(Letters)
Page 4

Balanced Scorecards
Are they hypeful or helpful? Either way, they've arrived. (Column: From the Editor)
Parkes, Clara H.; Page 6

E-Business Software
Moving toward the virtual corporation. (Column: Enterprise Manager)
Hurwitz, Judith; Page 8

Professional Boundaries
Defining what a data warehouse manager should (and shouldn't) do. (Column: Data Warehouse Architect)
Kimball, Ralph; Page 14

Moving On
Migration paths, real and imagined. (Column: SQL for Smarties)
Celko, Joe; Page 18

Please Move to the Middle
Traditional client/server vendors are making strong moves toward middleware. (Column: Application Architect)
Linthicum, David S.; Page 22

Sagent Data Mart Solution
Sagent Data Mart Solution is a comprehensive decision-support environment designed to allow rapid construction, population, and maintenance of data marts as well as basic reporting from those data marts. Sagent WebLink facilitates use of a Web browser a (Review)
Couchman, Thomas D.; Page 27

ROAD: BeanBox 1.1
ROAD: BeanBox 1.1 is a Java toolkit that lets you access remote database servers using JDBC. (Review)
Morgan, Bryan; Page 32

ERP Meets Web E-Commerce
Are SAP, Baan, Oracle and PeopleSoft rising to the challenges to deliver Web e-commerce to their customers? (Feature)
McKie, Stewart; Page 39

The Unified Modeling Language Takes Shape
Rendering the fundamental components of the UML and the value different views provide. (Feature)
Reed, Paul; Page 47

Benchmarking OLTP Systems
Get the high performance levels and scalability you need by developing your own custom OLTP benchmarks. (Feature)
Fried, Kenny; Page 59

The Race is On!
Microsoft SQL Server rallies for the mobile database market. (Column: Server Side)
Rennhackkamp, Martin; Page 65

IBM: More Than a Hill o' Beans
Directing the future of E-business, the San Francisco project, and... Java? (Column: Net Developer)
King, Nelson; Page 68

When Bill Gates Becomes Big Stella: Insightful Anagrams
(Column: Start Here)
Parkes, Clara H.; Page 72

June, 1998 (Volume 11, Number 6)

Letters
(Letters)
Page 6

Embedding the Enterprise
Fitting bigger databases into smaller platforms. (Column: From the Editor)
Frank, Maurice; Page 10

Componentizing Packaged Apps
Bringing the promise of best of breed closer to reality. (Column: Enterprise Manager)
Hurwitz, Judith; Page 14

Pipelining Your Surrogates
A good surrogate key system is worth the work. (Column: Data Warehouse Architect)
Kimball, Ralph; Page 18

Call Me an Optimist
Good news about Web surfing, SQL-Optimizer 1.1 and VLDBs. (Column: SQL for Smarties)
Celko, Joe; Page 24

Emerging Solutions
Linking systems together intelligently with solutions-oriented middleware. (Column: Application Architect)
Linthicum, David S.; Page 32

Arbor Essbase OLAP Server 5
Essbase 5 is a mutidimensional OLAP database server suitable as an information delivery vehicle for a wide range of business intelligence applications. (Review)
Elkins, Steven B.; Page 41

Vision Jade 3.0
VisionJade is a Web-based application development environment that builds multi-tier business rules-based applications in Java. These applications can run on client platforms using Oracle, Sybase, or Microsoft SQL Server. (Review)
Mariano, John R.; Page 44

Server-Side Java
Java adds fuel for the database engine. (Feature)
King, Nelson; Page 51

Sphinx Awakens
Microsoft's new SQL Servre 7.0 boasts a faster engine, greater scalability, and extensive OLAP processing capabilities. Is it finally ready for the enterprise? (Feature)
Schumacher, Robin; Page 57

Editor's Choice Award Winners
(Feature)
Frank, Maurice; Page 66

Red Brick Warehouse 5.1
Relational data warehousing and data mining are reaching new heights. (Column: Server Side)
Rennhackkamp, Martin; Page 68

Getting That Secure Feeling
Intel's common data security architecture and Microsoft's Crypto API. (Column: Component Assembler)
Spitzer, Tom; Page 74

The Business Behind the Enterprise
(Column: Start Here)
Parkes, Clara H.; Page 80

May, 1998 (Volume 11, Number 5)

Letters
(Letters)
Page 6

What's Wrong with Components?
Component-based development is today's nirvana, but experience will expose its pitfalls. (Column: From the Editor)
Frank, Maurice; Page 8

Component Directions
Components are better than objects. Here's why. (Column: Enterprise Manager)
Hurwitz, Judith; Page 10

Surrogate Keys
Keep control over record identifiers by generating new keys for the data warehouse. (Column: Data Warehouse Architect)
Kimball, Ralph; Page 14

Tooling Around
Beanie babies and programing for client/server vs. the Web. (Column: SQL for Smarties)
Celko, Joe; Page 20

Conducting Components
Component management is a need whose time has come - so get ready. (Column: Application Architect)
Linthicum, David S.; Page 26

ISG Navigator 1.5
ISG Navigator is distributed middleware that allows you to access heterogeneous databases independent of location or data format. ISG supports OLE DB and ADO as well as ODBC. (Review)
Stachura, Victor; Page 31

Tango Enterprise 3.0
Tango Enterprise is a visual develpment tool that integrates ODBC-compliant SQL databases with Web servers. (Review)
Goddard, Douglas; Page 33

All Data to All Consumers
Universal data access is becoming a reality now that Microsoft has championed the cause - but at what cost to the rest of the industry? (Feature)
Spitzer, Tom; Page 39

The Middleware Muddle
Application servers and TP monitors are finding new life on the net. (Feature)
Ritter, Dave; Page 49

Backing up the Oracle Enterprise
Strategies for managing the successful backup and revovery of Oracle databases. (Feature)
Ashmore, Derek; Page 55

PeerDirect
Heterogeneous replication comes of age. (Column: Server Side)
Rennhackkamp, Martin; Page 67

XML Takes the Field
HTML is dead. XML is king. Long live HTML! (Column: Net Developer)
King, Nelson; Page 75

Middlewhere?
(Column: Start Here)
Parkes, Clara H.; Page 80

April, 1998 (Volume 11, Number 4)

Letters
(Letters)
Page 6

Center of Gravity
Microsoft's OLAP server will popularize multidimensional analysis. (Column: From the Editor)
Frank, Maurice; Page 8

Customizing Packaged Applications
Business differentiation comes at the risk of a maintenance nightmare. (Column: Enterprise Manager)
Hurwitz, Judith; Page 10

Is Data Staging Relational?
Or does it have more to do with sequential processing? (Column: Data Warehouse Architect)
Kimball, Ralph; Page 14

Access Denied
Pondering the difficulties of database access and the limitations of Microsoft Access. (Column: SQL for Smarties)
Celko, Joe; Page 20

Java Realities
Enterprise JavaBeans offers a new trade-off in the world of Java. (Column: Application Architect)
Linthicum, David S.; Page 24

Cold Fusion Application Server and Cold Fusion Studio
Fusing the development side and the deployment side for Web-centric database management is a new one-two punch from Allaire: the Cold Fusion Application Development System, consisting of Cold Fusion Application Server 3.1 and Cold Fusion Studio 3.1. (Review)
Reichard, Kevin; Page 29

Soft Notes
SQL Server 7.0 on the way. (News)
Parkes, Clara H.; Page 32

Open OLAP
New APIs and third-party development make it easier than ever to master your islands of data. (Feature)
Elkins, Steven B.; Page 34

Parallel Processing For OLTP
Although traditionally used for decision support workloads, parallel processing is finding its place in the world of OLTP. (Feature)
Zolkavich, Grant; Page 46

Modeling Object/Relational Databases
CASE Vendors are beginning to support universal servers, but the tools are still immature. (Feature)
Grimes, Seth; Page 51

Consulting the Database Crystal Ball
Monitoring vendor and university research can help you prepare for emerging database technologies. (Feature)
Brooks, Peter; Page 57

Cloudscape's JBMS
How one upstart is taking on the database market with buzzword compliance. (Column: Server Side)
Rennhackkamp, Martin; Page 62

MTS Matures
Administrating middle-tier applications with Microsoft's transaction server. (Column: Component Assembler)
Spitzer, Tom; Page 66

Press Release 101
(Column: Start Here)
Parkes, Clara H.; Page 72

March, 1998 (Volume 11, Number 3)

Letters
(Letters)
Page 6

Death of the Database?
Oracle, Sybase, and Informix are struggling financially as database server sales wane. (Column: From the Editor)
Frank, Maurice; Page 12

Dismantling Stovepipes
Integrating and linking applications. (Column: Enterprise Manager)
Foote, Steven; Hurwitz, Judith; Page 14

Meta Meta Data Data
Making a list of data about metadata and exploring information cataloging tools. (Column: Data Warehouse Architect)
Kimball, Ralph; Page 18

Synchronizing Data Access
Critiquing the three major types of concurrency control. (Column: SQL for Smarties)
Celko, Joe; Page 22

Getting Along
It doesn't have to be all or nothing when deciding between COM and CORBA. (Column: Application Architect)
Linthicum, David S.; Page 26

SilverStream 1.0
SilverStream 1.0 is a Web application platform that enables developers to build and deploy Java- or HTML-based business applications for the Inter/intra/extranet. (Review)
Smith, Brian; Page 29

Broadbase 1.1
Broadbase is a turnkey data mart solution that supports a broad range of analytical functions, including OLAP and Web access. (Review)
Schumacher, Robin; Page 32

Integrating Enterprise Applications
Just a few false moves can make your project collapse like a house of cards. (Feature)
Linthicum, David S.; Page 38

Data Binding in Dynamic HTML
Microsoft's DHTML extensions offload forms and data management into browsers. (Feature)
Dobson, Rick; Page 47

Scaling Operating Systems
How to pick, tune, and scale an operating system to shoulder the weight of powerful OLTP applications. (Feature)
Mayer, Curt; Page 55

Versant 5.0
Now is the time to retrain relational recruits to win the object war. (Column: Server Side)
Rennhackkamp, Martin; Page 61

Are We Architects or What?
Finding a way to deal with complexity. (Column: Net Developer)
King, Nelson; Page 66

The Long Road from Data to Wisdom
(Column: Start Here)
Parkes, Clara H.; Page 72

February, 1998 (Volume 11, Number 2)

Sense of the Summit
Examining Web database architectures and tool at the Net Database Summit. (Column: From the Editor)
Frank, Maurice; Page 8

Configuration Management
New tools automate the chores associated with component-based development. (Column: Enterprise Manager)
Hurwitz, Judith; Page 10

Human Reources Data Marts
Design guidelines for querying and analyzing employee data. (Column: Data Warehouse Architect)
Kimball, Ralph; Page 16

The Terrors of Translation Tables
Joe debunks a common technique for decoding codes into meaningful strings. (Column: SQL for Smarties)
Celko, Joe; Page 20

Crossing the Streams
Integrating packaged applications offers big payoff potential for businesses. (Column: Application Architect)
Linthicum, David S.; Page 24

Visual Cafe for Java 2.0
Visual Cafe for Java 2.0 is a major upgrade to a veteran Java development tool. Its database features are based on Symantec's dbANYWHERE middleware server. (Review)
Patel, Pratik R.; Page 29

Borland JBuilder Client/Server Suite
Jbuilder Client/Server Suite is Borland's new Java database development tool that includes Borland's database middleware and other database tools. (Review)
Carnell, Michael; Page 31

Assessing Java fo Electronic Commerce
Sun wants you to use Java for e-commerce. But is Java ready? (Feature)
Indermaur, Kurt; Page 38

Building on Bigger Boxes
The art of successfully selecting scalable hardware servers to support OLTP Systems. The second in the Emergent Corp. Transaction Processing Series. (Feature)
Prioreschi, Gordon; Page 47

JDBC and Firewalls
Connecting JDBC Applications to DBMSs through firewalls is a matter of security, performance, and cost. (Feature)
Gulesian, Marcia; Page 57

Integrating BackOffice Servers
Understanding how the various BackOffice servers interact will help you achieve true cooperative data access. (Feature)
Rahmel, Dan; Page 65

Managing Dynamic Queries
The Teleran System helps keep runaway queries at bay. (Column: Server Side)
Rennhackkamp, Martin; Page 71

Tiers Without Tears
Packaging logic into components makes multitier architectures less painful. (Column: Component Assembler)
Spitzer, Tom; Page 74

In Search of Great Architecture
(Column: Start Here)
Parkes, Clara H.; Page 80

January, 1998 (Volume 11, Number 1)

Letters
(Letters)
Page 6

Year 2000: A Warm-Up Exercise
Year 2000 strategies will be helpful when other numbers start to run out. (Column: From the Editor)
Frank, Maurice; Page 8

Sorting Out Middleware
Simplifying development has never been more complicated. (Column: Enterprise Manager)
Hurwitz, Judith; Page 10

The Operational Data Warehouse
It needs both a transaction version of data and a periodic snapshot version of data. (Column: Data Warehouse Architect)
Kimball, Ralph; Page 14

Making Things Secure
Joe discusses security for databases and CDs. (Column: SQL for Smarties)
Celko, Joe; Page 18

The Magical Framework Myth
IBM's San Francisco project brings new hope for enterprise frameworks. (Column: Application Architect)
Linthicum, David S.; Page 22

Crystal Reports Professional 6.0
Crystal Reports Professional 6.0 is a reporting and query tool for PC and SQL databases that offers both advanced development features and interactive Web publishing. (Review)
McNamara, Julie; Page 27

SQL-Optimizer 1.0.4
SQL-Optimizer is a performance management SQL monitor for Oracle servers. (Review)
Schumacher, Robin; Page 30

Soft Notes
(News)
Page 32

Transaction Processing Today
Everything you need to know about the powerful trends changing the face of DSS and OLTP. (Feature)
Rudin, Ken; Page 35

Bringing Up Supermarts
A step-by-step approach to building a data warehouse from granular data. (Feature)
Kimball, Ralph; Page 47

New Editor's Choice Awards
Nomination Guidelines and Procedures (Other)
Page 54

Oracle Year 2000 Pitfalls
Practical techniques for addressing the Y2K problem in Oracle-based applications. (Feature)
Lis, Ben; Page 55

Social Security After 2000
The Social Security adminstration revamps its massive databases to asssure the delivery of benefits into the next century. (Feature)
Wilent, Steve; Page 62

Testing Year 2000 Conversions
(Feature)
Pollner, Andrew; Page 67

Sybase Adapts
The inner workings of Adaptive Server Enterprise 11.5 (Column: Server Side)
Rennhackkamp, Martin; Page 71

As Good As The Foundation
In his premier DBMS column, Nelson King discusses foundation classes. (Column: Net Developer)
King, Nelson; Page 76

What's the beef behind the OLAP blab?
(Column: Start Here)
Parkes, Clara H.; Page 80