Dickeson--The Analytical Power of OLAPJune 1998
Using the MDBMS true cubic aspect, analysis is far faster and more efficient. If this technical stuff intrigues you, have a look at these Web sites: www.pilotsw.com/ olap/olap.htm; www.datamation. com/plugin/workbench/olap/stories/virt.htm; www.picksys. com/product/whtpapr.html.
Most of the literature about OLAP deals with marketing phenomena such as the correlation between diapers and beer. That's fine.
If some of you reading this column are printing sales or marketing people, give this some thought. Think about products, materials and customer base. Could online analysis lead to conclusions about core competency of your shop? Account preferences? Market segmentation?
If so, you'd be using OLAP for insights into enterprise effectiveness. I'm suggesting that we think "out of the marketing box" about OLAP—that we use this tool to improve printing process efficiency. There may well be more usefulness in printing process management for OLAP than in product marketing.
As E.F. Codd, the dean of the database world, puts it: The relational databases "were never intended to provide powerful functions for data synthesis, analysis and consolidation (the functions collectively known as multidimensional data analysis)." Online analysis—the MDBMS—is a concept whose time has now come for print process management!
We need to aggregate, synthesize and analyze our printing process information beyond the world of our job cost systems that presently use transactional analysis of an RDBMS system. There are 1,600 variables and 2,600 press events, and more than that must be aggregated, compared and related. Trends must be found and analyzed. Covariances and correlations that lead to actions and decisions need to be identified. Unscheduled stoppages of equipment must be reduced to improve time and materials efficiency.
It's beyond my competence to do more than point a direction. I don't know how my VCR works, but I use it to keep Blockbuster solvent.
OLAP isn't really new, just newly rediscovered and touted. In 1977, I witnessed a demonstration of an MDBMS on a microcomputer system called the Microdata Reality, and I could hardly believe the ease of query and analysis I was observing. It was named the Pick System, after its developer Richard Pick, who pioneered it for the military at about the same time in the late '60s that UNIX was being perfected. Pick Systems are now running in thousands of applications worldwide.
A year or two ago a new version of Pick, called D3, was introduced for UNIX, Windows 95, Windows NT and Visual Basic 5. It can run on terminals or PC workstations and is available with open database connectivity and SQL. I don't know how it works, but I'd sure like to use it, or one of the other dozen or so systems that are now available with OLAP capability, to analyze our printing processes.
—Roger V. Dickeson
About the Author
Roger Dickeson is a printing productivity consultant based in The Woodlands, TX. He can be reached via e-mail at firstname.lastname@example.org or email@example.com; or via fax at (281) 362-7572.