Computerworld - Fifty years ago, data management was simple. Data processing meant running millions of punched cards through banks of sorting, collating and tabulating machines, with the results being printed on paper or punched onto still more cards. And data management meant physically storing and hauling around all those punched cards.
That began to change in 1951, when Remington Rand Inc.'s Univac I computer offered a magnetic tape drive that could input hundreds of records per second. In 1956, IBM rolled out the first disk drive, the Model 305 RAMAC. The drive had 50 platters, each 2 ft. in diameter, that could hold a total of 5MB of data. With disks, data could be accessed at random, not just sequentially, as with cards and tape.
But for decades, most firms had only used data in batch runs for accounting, and it took time for an idea like navigating through data to catch on.
Data Management Is Born
In 1961, Charles Bachman at General Electric Co. developed the first successful database management system. Bachman's integrated data store (IDS) featured data schemas and logging. But it ran only on GE mainframes, could use only a single file for the database, and all generation of data tables had to be hand-coded.
One customer, BF Goodrich Chemical Co., eventually had to rewrite the entire system to make it usable, calling the result integrated data management system (IDMS).
In 1968, IBM rolled out IMS, a hierarchical database for its mainframes. In 1973, Cullinane Corp. (later called Cullinet Software Inc.) began selling a much-enhanced version of Goodrich's IDMS and was on its way to becoming the largest software company in the world at that time.
Meanwhile, IBM researcher Edgar F. "Ted" Codd was looking for a better way to organize databases. In 1969, Codd came up with the idea of a relational database, organized entirely in flat tables. IBM put more people to work on the project, code-named System/R, in its San Jose labs. However, IBM's commitment to IMS kept System/R from becoming a product until 1980.
But at the University of California, Berkeley in 1973, Michael Stonebraker and Eugene Wong used published information on System/R to begin work on their own relational database. Their Ingres project would eventually be commercialized by Oracle Corp., Ingres Corp. and other Silicon Valley vendors. And in 1976, Honeywell Inc. shipped Multics Relational Data Store, the first commercial relational database.
By the late 1960s, a new kind of database software was being developed: decision support systems (DSS), designed to let managers put data to better use in their decision-making. The first commercial online analytical processing tool, Express, became available in 1970. Other DSS systems followed, many developed inside corporate IT departments.
In 1985, the first "business intelligence" system was developed for Procter & Gamble Co. by Metaphor Computer Systems Inc. to link sales information and retail scanner data. That same year, Pilot Software Inc. began selling Command Center, the first commercial client/server executive information system.
Also that year, back at Berkeley, the Ingres project had mutated into Postgres, with a goal of developing an object-oriented database. The next year, Graphael Inc. shipped Gbase, the first commercial object database.
In 1988, IBM researchers Barry Devlin and Paul Murphy coined the term information warehouse, and IT shops began building experimental data warehouses. In 1991, W.H. "Bill" Inmon made data warehouses practical when he published a how-to guide, Building the Data Warehouse (John Wiley & Sons).
With the widespread adoption of PC-based client/server computing and packaged enterprise software in the 1990s, the transformation of data management was complete. It was no longer just storing and maintaining data, but slicing, dicing and serving it up in whatever ways users demanded.
And now, on with the story. . . .
The Univac uses magnetic tape as well as punched cards for data storage.
1956: IBM introduces first magnetic hard disk drive in its Model 305 RAMAC.
1961: Charles Bachman at GE develops the first database management system, IDS.
1968: IBM offers the IMS hierarchical database for System/360 mainframes.
1951: Univac uses magnetic tape as well as punched cards for data storage.
1969: Edgar F. "Ted" Codd invents the relational database.
1969: Edgar F. Ted Codd invents the relational database.
1973: Cullinane, led by John J. Cullinane, ships IDMS, a network-model database for IBM mainframes.
1976: Honeywell ships Multics Relational Data Store, the first commercial relational database.
1979: Oracle introduces the first commercial SQL relational database management system.
1983: IBM introduces DB2.
1985: The first business intelligence system is designed for Procter & Gamble.
1991: W.H. Bill Inmon publishes Building the Data Warehouse.
1991: W.H. "Bill" Inmon publishes Building the Data Warehouse.
- Taming Data Chaos
- The Story So Far
- Merging Data Silos
- Beware of Data Overload from External Data
- Learn to Manage Data, Not Crises
- Data's Tower of Babel
- Extracting Dollars From Data
- Why ROI is so Elusive
- Collections of Data: Bases, Marts, Warehouses
- The Power of Location
- Seeding for Data Growth
- The Search is On
- The Data Designers
- Demise of the Disk Era
- Dawn of a New Database
- Keeping CFOs Happy
- Case Studies in Data Management
- Hot Issues: Scalability and Data Integration
Read more about Business Intelligence/Analytics in Computerworld's Business Intelligence/Analytics Topic Center.
- Reducing Expenses Starts with the Programming Skills of Operations Groups Reducing expenses can start with the programming skills of operations groups. Read this article to learn how to improve the bottom line, and...
- Big Data, Big Mess: Sound Risk Intelligence Through Complete Context This paper examines the insecurity of the small businesses in the supply chain and offers tips to close those backdoors into the enterprise.
- CIOs strive to harness Big Data while keeping an eye on the bottom line Read this whitepaper to learn how Red Hat Storage Server allows CIOs to confidently support business growth, manage cost and risk, capitalize on...
- Enterprise architects challenged to manage data explosion Read this whitepaper to find out how Red Hat Storage Server can allow enterprises to quickly and confidently deliver business applications that minimize...
- Live Webcast Charting Your Analytical Future - "Making predictive analytics part of your business processes" Webinar This session will show how predictive analytics can be used throughout the organization by anyone looking for answers and how organizations can make...
- Charting Your Analytical Future - "Making predictive analytics part of your business processes" Webinar This session will show how predictive analytics can be used throughout the organization by anyone looking for answers and how organizations can make...
- Capturing Data in Motion: Delivering Real-Time Insight from Data Streams This webcast will help organizations of all types and sizes learn about a technology and business strategy for tapping into the wealth of... All Business Intelligence/Analytics White Papers | Webcasts
Our new bimonthly Internet of Things newsletter helps you keep pace with the rapidly evolving technologies, trends and developments related to the IoT. Subscribe now and stay up to date!