Article Index - 1994

December, 1994 (Volume 7, Number 13)

Logical Client/Server
Finally, a logical definition of client/server. (Column: From the Editor)
Kalman, David; Page 12

Information at What Price?
Ensuring data quality at a major European weather forecasting center. (Column: Mission-Critical View)
Bloor, Robin; Page 16

Publishing at Your Fingertips
A look at database publishing from your PC -- it's easier than you think. (Column: SQL Explorer)
Celko, Joe; Page 20

Lockheed Succeeds with C/S
Lockheed's Promis system is expected to save millions of dollars a year by streamlining business processes. (Column: C/S Developer)
Linthicum, David S.; Page 26

EasyCASE System Designer 4.12
(Review)
Herndon, David; Page 30

XDB-Server 4.0
(Review)
Winchell, Jeff; Page 36

Soft Notes
(News)
Editors, .; Page 40

No Longer Neglected
Data choreography revisited. (Column: From the Editor)
Kalman, David; Page 12

The Painful Performance Problem
Adding gigabytes of memory and CPU cycles will increase your performance, right? Wrong. (Column: Mission-Critical View)
Bloor, Robin; Page 14

Making the Most of Marketing
A marketing database can help you keep track of customer information, but beware of what it might tell you. (Column: SQL Explorer)
Celko, Joe; Page 18

All Systems Go with ObjectPro
In a market riddled with faux object-oriented development tools, Trinzic's new product stands out as truly OO. (Column: C/S Developer)
Linthicum, David S.; Page 25

C/S Elements 1.02a
Neuron Data's cross platform development tool for database applications. (Review)
Linthicum, David S.; Page 32

Maxim 1.0 for Windows
(Review)
Indermaur, Kurt; Page 36

Soft Notes
(News)
Editors, .; Page 37

Testing the GUI
As it gets easier and easier to build powerful GUI-based applications, one question remains: How do you know if they work right? (Feature)
Marsh, Vivien; Page 52

Automated Testing in PowerBuilder with SQA TeamTest
(Sidebar)
Bourne, Kelly; Page 58

XDB: DB2 Compatibility and Beyond (Dr. S. Bing Yao, founder of XDB Systems)
XDB Systems stakes out desktop territory, where DB2 compatibility is not required. (Interview)
Kalman, David; Page 64

Building Applications From Models
Sketching an application model on a napkin is no longer feasible; today's large-scale applications demand integrated case and modeling tools. (Feature)
Frank, Maurice; Page 72

New Accounting Infrastructures
Integrating and extending the reach of client/server financial systems. (Feature)
McKie, Stewart; Page 80

Should You Model Derived Data?
The arguments for and against putting derived data in your data model. (Feature)
Tillmann, George; Page 88

Developing Applications with Novell's Visual AppBuilder
As the trend toward visual programming continues, Novell enters the ring with its hard-hitting development environment. (Feature)
Olympia, Ph.D., P. L.; Page 92

Getting Integrity in SQL Server
User-defined integrity has been neglected for too long; here's how SQL Server System 10 is doing it. (Feature)
Mullins, Craig; Page 99

PowerBuilder's Double Dialog Dilemma
Solving a problem with PowerBuilder's AcceptText() function. (Column: Developer's Notebook)
Hatfield, Bill; Page 103

Things SQL Can Do
A look at why decision-support queries can be done in standard SQL with a minimum of fuss. (Column: Server Side)
Roti, Steve; Page 112

The Form Factor
A foray into building a forms-based client/server front end. (Column: Desktop DBMS)
Spitzer, Tom; Page 115

Client/Server Connection
(News)
Editors, .; Page 120

Getting Relational Right
In honor of the relational model's 25th anniversary, a tribute to Dr. E. F. Codd. (Column: From the Editor)
Kalman, David; Page 12

New Kids on the Block
Still wondering what the future 5GLs will look like? They're already here. (Column: Mission-Critical View)
Bloor, Robin; Page 14

The Price of Fame and Glory
Joe exposes, discusses, and analyzes the news from Database and Client/Server World. (Column: SQL Explorer)
Celko, Joe; Page 18

Are we JAMming?
JAM 6 is solid and extremely portable, but it still needs some work. (Column: C/S Developer)
Linthicum, David S.; Page 24

Capsule 1.0
(Review)
Frank, Maurice; Page 28

db-UIM/X 2.5
(Review)
Carnahan, Ron; Page 30

Access Developer's Toolkit 2.0
(Review)
Taylor, Allen G.; Page 34

Soft Notes
(News)
Editors, .; Page 36

The Relational Model Turns 25
...And we're still trying to get it right. (Feature)
McGovern, David; Page 46

Why Ask Why?
Pondering the industry's more imponderable conundrums. (Column: From the Editor)
Kalman, David; Page 10

Workflow and Document Management
Managing documentation efficiently in an inefficient world. (Column: Mission-Critical View)
Bloor, Robin; Page 12

The Great Key Debate
Seven reasons to use intelligent keys over surrogate keys. (Column: SQL Explorer)
Celko, Joe; Page 17

CASE Does PowerBuilder
CASE vendors are finally letting their tools go GUI. (Column: C/S Developer)
Linthicum, David S.; Page 24

DataEdit 2.1
(Review)
Frank, Maurice; Page 28

Skribe Professional 4.0
(Review)
Indermaur, Kurt; Page 32

RaSQL/B for FoxPro
(Review)
Schnapp, Marc; Page 34

Soft Notes
(News)
Editors, .; Page 40

Database Security in a Client/Server World
Understanding the unique challenges of keeping your client/server database environment secure. (Feature)
Bobrowski, Steve; Page 48

Kerberos and Network Authentication Systems
Kerberos is a secret-key authentication system. (Sidebar)
Bobrowski, Steve; Page 54

DBMS Readers Write
Readers relate their positive, negative, and disastrous experiences with recent buyouts and acquisitions. (Column: From the Editor)
Kalman, David; Page 8

The Disappearing Programmer
As object-oriented concepts take hold, the need for specialized programming is declining. (Column: Mission-Critical View)
Bloor, Robin; Page 14

Traveling on the Trade Show Circuit
Three things are guaranteed in this industry: death, mergers, and trade shows. (Column: SQL Explorer)
Celko, Joe; Page 19

Defending OOP with VisualAge
Why OO technology and some of its products are worth the battle past the marketing hype. (Column: C/S Developer)
Linthicum, David S.; Page 22

Access 2.0
(Review)
Taylor, Allen G.; Page 26

ODBC Sniffer and SQL Sniffer
(Review)
North, Ken; Page 28

Cross-Platform Development: The Next Frontier
(Feature)
Frank, Maurice; Page 40

Partitioning the Future (Martin J. Sprinzen, President and CEO, Forte Software)
Forte Software emerges from development with its long-awaited enterprise client/server application development environment. (Interview)
Kalman, David; Page 50

Banking on Client/Server
A pilot project at Chase Manhattan Bank proves that migrating from the mainframe to a client/server environment is both possible and practical. (Feature)
Rideout, Rodney; Page 57

Designing for Flexibility with Multiple Document Interfaces
A lead developer explains how the Minneapolis Star Tribune uses MDI's to embed information in a customer-service application. (Feature)
Shekleton, John; Page 64

Accounting Objects: Financial Applications Go Object Oriented
How accounting software packages can -- and should -- exploit object-oriented features. (Feature)
McKie, Stewart; Page 69

How Do You GUI?
Designing an elegant and practical user interface means sometimes bending the rules. (Column: Desktop DBMS)
Spitzer, Tom; Page 83

Developer's Notebook
Resizing DataWindow Controls (Column: Developer's Notebook)
Hatfield, Bill; Page 87

Objects Everywhere
Objects are everywhere, even on stage in a new object-oriented play. Also, excellent new products. (Column: From the Editor)
Kalman, David; Page 10

Chaos on the Desktop
If you think downsizing to PC/LANs will save your corporation money, think again. (Column: Mission-Critical View)
Bloor, Robin; Page 14

SQL in the City of Steel
The ANSI Committee tackles the issues of multimedia, objects, GISs, and the information highway. (Column: SQL Explorer)
Celko, Joe; Page 17

Object Surfing and Enfin
A brief look at object-oriented technology and one product that demonstrates OO's advantages. (Column: C/S Developer)
Linthicum, David S.; Page 22

InfoModeler 1.0
(Review)
Taylor, Allen G.; Page 30

ReportSmith 2.0
(Review)
Frank, Maurice; Page 34

Building the Data Mart
A new decision-support system architecture blends data mart and data warehouse strategies. (Feature)
Demarest, Marc; Page 44

The Doctor of DSS (Ralph Kimball)
For 10 years, the RDBMS industry has focused on getting data in. Decision-support system (DSS) specialist Ralph Kimball focuses on getting it out. (Interview)
Kalman, David; Page 54

A Drill-Down Analysis of Multidimensional Databases
If your analytical efforts feel stifled by the limitations of relational tables, you may profit by trying a multidimensional approach. (Feature)
Frank, Maurice; Page 60

Implementing A Multidimensional Database Model -- Four Gotchas
Tips for planning a multidimensional project. (Sidebar)
Brooks, Peter; Page 62

Multidimensional Makes A Difference
Three brief case studies of users who deployed multidimensional databases. (Sidebar)
Frank, Maurice; Page 64

A New Solution for Client/Server
The AS/400 -- yes, the AS/400 -- is bidding to become the "Solutions Champion" for client/server computing. (Feature)
Atre, Shaku; Page 72

Do-It-Yourself Software II
Now is the right time to check out Novell's AppWare -- it could change the way you develop applications. (Feature)
Olympia, Ph.D., P. L.; Page 78

Riding High on Expressway 103
A look at an effective DSS player in the dual database strategy game. (Column: Server Side)
Roti, Steve; Page 90

Courting the Xbase Market
Microsoft, Oracle, and Sybase set their sights on PC database users. (Column: Desktop DBMS)
Spitzer, Tom; Page 93

Who's Next
Who will be the next victim/victor in the current merger mania? (Column: From the Editor)
Kalman, David; Page 10

The Open Systems Paradox
As vendors struggle to differentiate their products, "Open Systems" remains a fantasy. (Column: Mission-Critical View)
Bloor, Robin; Page 14

Computing with the Sharks
Joe survives earthquakes, expensive tourist traps, and ANSI meetings to report on SQL standards and impressive new tools. (Column: SQL Explorer)
Celko, Joe; Page 18

A Better RPC?
General Magic delivers a promising new remote programming product for client/server applications. (Column: C/S Developer)
Linthicum, David S.; Page 24

Quest 2.1
(Review)
Frank, Maurice; Page 30

ProtoGen+ Visual Development Workbench 4.0
(Review)
Carnahan, Ron; Page 34

The Limits of PC Databases
Real-life PC applications that will challenge your notions of large-scale, mission critical computing. (Feature)
Winchell, Jeff; Page 44

The Visigenic View (Visigenic's Roger Sippl and Therese Langlais)
Roger Sippl's new client/server application development tool makes old languages new again. (Column: DBMS Interview)
Kalman, David; Page 50

Getting the Bugs Out
Ingres Windows4GL and PowerBuilder 3.0 include debugging tools that go beyond the call of duty. (Feature)
Bourne, Kelly; Page 54

Accounting Engines: Building Your Own Accounting Systems
Why customization features in accounting packages are critical for today's client/server environments. (Feature)
McKie, Stewart; Page 62

Monitoring Oracle7 Objects
Database administration with Oracle's SQLDBA and other tactics. (Feature)
Ault, Michael; Page 70

An Objective View of ObjectView 3.0
KnowledgeWare's new client/server offering provides significant improvements in openness, reusability, and collaborative development. (Feature)
Chaddha, Parmeet; Page 81

Quadbase-SQL XB Server
A new SQL database server for upsizing that lets organizations use their exisiing data. (Column: Server Side)
Roti, Steve; Page 91

A Brief History of Tom
A new column for PC developers who need to bridge the old and new worlds of desktop databases. (Column: Desktop DBMS)
Spitzer, Tom; Page 93

In the Public Interest?
The collision of 3GL and 4GL tools, and TPC trouble. (Column: From the Editor)
Kalman, David; Page 10

The Coming of Parallel Servers
Organizations looking for a high level of performance and scalability may find a savior in MPP technology. (Column: Mission-Critical View)
Bloor, Robin; Page 14

SQL 101: Part Deux
Now that you know how to build basic tables with SQL, it's time to use more advanced features. (Column: SQL Explorer)
Celko, Joe; Page 17

4GLs: Productivity at What Cost?
Liberal use of the new generation of 4GL "Power Tools" may cause problems in organizations that don't use them properly. (Column: C/S Developer)
Linthicum, David S.; Page 22

PowerClass 3.0a
(Review)
Frank, Maurice; Page 26

Unraveling Client/Server Architectures
The evolving wisdom about the distribution of presentation, business, and database logic in client/server systems. (Feature)
Edelstein, Herb; Page 34

Tools of the Trade (Sybase Inc.'s Frank Strelau)
The Sybase tool strategy takes shape for building back-office, front-office, and "extended-office" applications. (Interview)
Kalman, David; Rigney, Theresa; Page 44

Improving Data Legibility in Decision-Support Systems
Data illegibility has implications for data delivery, the decision-support system data store, and the client applications accessing the data store. (Feature)
Demarest, Marc; Page 55

Twelve Steps to Successful Client/Server
Guidelines to help developers stay on the right path while planning and developing client/server projects. (Feature)
Atre, Shaku; Page 70

Monitoring Servers
A look at how monitors can help solve bottlenecks and other server administration problems. (Column: Server Side)
Roti, Steve; Page 89

FoxPro's Dynamic Duo of Add-Ons
Two application development products for developers who aren't quite ready for FoxPro's power tools (Column: Set Expert On)
Olympia, Ph.D., P. L.; Page 91

The Low End Must Die
Why vendors must abandon low-end/high-end thinking, and Powersoft's new Desktop. (Column: From the Editor)
Kalman, David; Page 8

Changing of the Guard
Moving to client/server environments may mean updating your legacy staff. (Column: Mission-Critical View)
Bloor, Robin; Page 12

SQL 101: Basic Table Design, Part 1
When you understand the basics of the model, the more advanced concepts will come more easily. (Column: SQL Explorer)
Celko, Joe; Page 17

Distributed Database with Oracle7
An overview of distributed database and details on how to setup the links between servers (and clients) in a distributed Oracle system. (Column: C/S Developer)
McClanahan, David R.; Page 24

TrueGrid Pro 2.1
(Review)
Taylor, Allen G.; Page 28

Rapid SQL 1.0
(Review)
Frank, Maurice; Page 30

The New Btrieve (Btrieve Technologies' Nancy R. Woodward, Ron. R. Harris, and Douglas W. Woodward)
Novell departs the database business and gives Btrieve and NetWare SQL a new lease on life. (Interview)
Kalman, David; Page 42

Client/Server Strategy
Coping with complexity: the basics of designing client/server systems. (Feature)
Linthicum, David S.; Page 46

Client/Server Project Workbook
One successful consultant's step-by-step guide to building client/server systems. (Feature)
Shapiro, Irv; Page 56

CASE Tools for Client/Server
Descriptions of CASE tools that support client/server development. (Product Chart)
Frank, Maurice; Page 62

The Road to Normalization
Because there's a lot more to normalizing a database than just buying a CASE tool, here's a nuts-and-bolts guide. (Feature)
Celko, Joe; Hubbard, Douglas W.; Page 66

The Five Levels of Workflow
How workflow management technology will change the process of client/server accounting. (Feature)
McKie, Stewart; Page 74

Tightrope Across the Chasms
Complex requirements, a complex environment, and an impossible schedule make for a developer's nightmare. (Feature)
Rennhackkamp, Martin; Page 79

What is a TP Monitor?
A description of transaction processing monitors. (Sidebar)
Rennhackkamp, Martin; Page 81

Using Ingres/Star
A description of the distributed database features of Ingres/Star (Sidebar)
Rennhackkamp, Martin; Page 83

Client/Server Security
A look at client/server security problems and some possible solutions. (Column: Server Side)
Roti, Steve; Page 91

Sayonara, Y'all
Xbase programming with CodeBase++ (Column: Set Expert On)
Olympia, Ph.D., P. L.; Page 93

The End of Dignity?
Borland's new channel and new IBM tools. Plus, a DBMS CompuServe forum member shares his 10 rules for selecting databases and tools. (Column: From the Editor)
Kalman, David; Page 8

The Dawning of a Virtual World
Electronic communications and technologies will deliver client/server to general consumers. (Column: Mission-Critical View)
Bloor, Robin; Page 10

Down the Mississippi
Joe floats south from Chicago's Database and Client/Server World to report on standards from New Orleans. (Column: SQL Explorer)
Celko, Joe; Page 14

Developing with Vision
Unify's new event-driven development 4GL boasts strengths in platform portability and database access. (Column: C/S Developer)
McClanahan, David R.; Page 20

SQL Studio Version 1.0
(Review)
Roti, Steve; Page 28

OpenInsight 2.0
(Review)
Frank, Maurice; Page 30

DBMS in Cyberspace
Take a trip to cyberspace, with DBMS. (Column: From the Editor)
Kalman, David; Page 8

CASE History
Four directions in which CASE vendors have evolved products to reduce their early technology deficiencies. (Column: Mission-Critical View)
Bloor, Robin; Page 12

Innumeracy Revisited
Accumulating data without knowing what it means is useless. (Column: SQL Explorer)
Celko, Joe; Page 17

Q+E Database Library
QELIB remains the top tool for providing rich database access to your applications. (Column: C/S Developer)
McClanahan, David R.; Page 24

SQLAssist Version 4.0
(Review)
Frank, Maurice; Page 30

CA-Realizer Version 2.0
(Review)
Taylor, Allen G.; Page 32

Not for the Faint of Heart
Judging the 1993 Droege Developer's Competition. (Column: From the Editor)
Kalman, David; Page 8

Moving from the Mainframe
IBM still has its mainframe base, but it is losing upgrade revenue to new tools for migration and redevelopment. (Column: Mission-Critical View)
Bloor, Robin; Page 12

Textbase versus Database
Managing large amounts of corporate textual data requires more than just a relational solution. (Column: SQL Explorer)
Celko, Joe; Page 18

Uniface 4GL Development
Uniface Corp. delivers application development solutions independent of platform, OS, and DBMS. (Column: C/S Developer)
McClanahan, David R.; Page 22

R&R for Windows
(Review)
Yellick, Craig; Page 30

SQL-Programmer 1.5
(Review)
Frank, Maurice; Page 32

Impromptu Version 2.0
(Review)
Carnahan, Ron; Page 38

Redmond's Database Driver (Microsoft's Dr. David Fulton)
Dr. David Fulton orchestrates Microsoft's diverse database projects. (Interview)
Kalman, David; Page 50

Client/Server Protocols: Choosing the Right Connection
How to factor in network protocols when selecting your database server, network, and operating system. (Feature)
Linthicum, David S.; Page 60

Moving Away from the Network, Using Middleware
Using middleware to eliminate the need for proprietary protocols. (Sidebar)
Linthicum, David S.; Page 66

Learning Division in Elementary School
A relational division primer even your kids could understand. (Feature)
Celko, Joe; Page 72

Flexible Computing at Sprint
Using GUI desktop computers and mainframe database servers, Sprint eliminates multiple 3270 sessions for its customer-service reps, and boosts productivity. (Feature)
Watt, Peggy; Page 79

R:Base 4.5: The Stealth Upgrade
Microrim delivers major new features and improved performance in a ".5" release. (Feature)
Acker, Bob; Page 83

SQL Server for Windows NT
Microsoft's NT databse server entry offers high performance and numerous system-administration tools. (Column: Server Side)
Roti, Steve; Page 97

Cruising the Data Highway
A quick look at two new administrative tools that keep information from drowning you. (Column: Set Expert On)
Olympia, Ph.D., P. L.; Page 99