DATACOM/DB

Last updated
Initial release1972 (1972)
Stable release
15.1 (z/OS) and 12.0 (z/VSE) / February 26, 2016;7 years ago (2016-02-26)
Written in C, Assembly
Operating system z/OS, z/VSE
Platform Mainframe
Available in English
License Proprietary EULA
Website www.ca.com

Datacom/DB is a relational database management system [1] for mainframe computers. It was developed in the early 1970s by Computer Information Management Company and was subsequently owned by Insyte, Applied Data Research, Ameritech, and Computer Associates International, Inc. Datacom was acquired by CA Technologies (formerly Computer Associates), which renamed it to CA-Datacom/DB and later to CA Datacom/DB. In 2018, Broadcom acquired CA Technologies which included the CA Datacom product family. In 2021, Broadcom has dropped the CA and now refers to the product family as Datacom or Datacom/DB.

Contents

Origin

The genesis of modern DBMS technology occurred in the 1970s with the advent of huge databases that were cumbersome to manage and maintain. As long as most mainframe processing was done in batch mode, the rapidity of maintenance operations was not a key ingredient to success. During the 1970s however, the introduction of online systems required that information become quickly available and dynamically maintained. Some of the most dramatic changes occurred in the banking and credit industry:

Datacom was initially designed to rapidly retrieve data from massive files using Inverted List technology. Although very well suited for rapid retrieval, it was less effective when handling large amounts of data maintenance. To solve this problem, Datacom/DB transitioned to relational technology utilizing special index-driven capabilities that radically improved maintenance with no loss in retrieval speed. This relational version of Datacom served as the foundation for a continuing stream of industry-leading enhancements that have preserved its position as an extremely cost-effective and high-performing DBMS for the IBM mainframe.

History

Credit Bureau industry

In the 1950s and 1960s, credit bureaus were local organizations that maintained paper records about local borrowers and retail customers, usually storing these records in small envelopes filed in literally hundreds of file cabinets. In fact, one major credit bureau attempted to speed up its transaction rate by having its employees wear roller skates to move rapidly from file cabinet to file cabinet!

In 1965, a project was initiated by IBM to use its new System/360 mainframe computers to automate the two largest credit bureaus - Chilton Corporation of Dallas and the Credit Bureau of Greater Houston - and the national association of credit bureaus. Three IBM veterans were selected to head up the development team. At the successful conclusion of this project, the three men agreed that their credit industry automation experience could equip them to build systems for other credit bureaus, so they collaborated to start Computer Information Management Company in Dallas in 1968.

Computer Information Management Co.

CIM logo.jpg

The team’s specialty with IBM had been the development of telecommunication-based applications. Building on this expertise, one of CIM’s first contracts was with First National Bank of Fort Worth, for which CIM designed an online teller system. At this time CICS was not functioning well, so CIM wrote a general purpose telecommunications monitor system which was later packaged and named Generalized Multi-Tasking Monitor (GMT).

Many of the subsequent consulting jobs undertaken by CIM were in the finance industry. At that time, savings and loan institutions were characterized by having huge collections of data but very few daily transactions. Because there were serious performance problems with ISAM, CIM designed a key-driven adjunct to GMT to manage the data for a large West Coast savings bank. This implementation became the foundation of Datacom/DB.

CIM continued to procure heavily-technical programming and consulting jobs and to sell GMT as a product. However, GMT was a tough product to sell to most executives because it was a very technical sale. Top management in many prospective companies usually did not have the technical knowledge to understand the requirements of a teleprocessing monitor. Consequently, CIM needed to find prospective sites with technically knowledgeable data processing (DP) managers or sites that gave significant executive power to their lead technicians.

Insyte

Insyte Datacom logo.jpg

In the early 1970s a Houston-based venture capitalist acquired a small group of companies which he named Information System Technologies (known as Insyte and pronounced “insight”). In 1974 Insyte acquired CIM’s promissory notes to gain control of CIM. Insyte replaced top management and made the decision to split the teleprocessing monitor from its key-driven access method and rename the two parts as Datacom/DC (for data communications) and Datacom/DB (for database). To emphasize the products’ relationship with Insyte, the company was renamed Insyte Datacom.

Datacom/DB’s primary competitors at this time were IDMS, IMS, DL/1, ADABAS, DBOMP, and Cincom Systems' TOTAL. Although still a very small company, Insyte Datacom became well known throughout the marketplace for the outstanding speed and efficiency of its Datacom/DB and Datacom/DC applications.

Applied Data Research

Applied Data Research logo.jpg

In 1978 Insyte sold Insyte Datacom to Applied Data Research, which was based in Princeton, New Jersey. This sale came about as a result of a business relationship that had been created between Insyte and ADR by which Datacom/DC was provided to ADR/Vollie clients as an online programmer’s workstation. In the late 1970s ADR recognized that DBMS products were going to become increasingly important – and set out to acquire one. After a 2-year search ADR acquired the assets and people of Insyte Datacom in November 1978. ADR began aggressively marketing Datacom in the United States and worldwide.

IDEAL

The ADR sales force concentrated on Datacom/DB and enjoyed remarkable success worldwide with several thousand clients in dozens of industries. As an offshoot of this success ADR recognized the need for a highly efficient and sophisticated application development language for Datacom/DB. This development language would need to offset the normal difficulties of writing telecommunication-based application programs. ADR’s Princeton-based application language development team had developed MetaCOBOL, which generated detailed and accurate COBOL statements from a high-level logical language set. Soon after the purchase of Datacom the team designed IDEAL. “Interactive Development Environment for an Application Lifecycle” was a watershed achievement in database application language development.

Combining IDEAL and its highly-productive programming environment with Datacom/DB’s ease-of-use and Datacom/DC’s high performance gave ADR a very potent product combination which dominated industry performance throughout the 1980s.

Datacom/DC vs. IBM's CICS and VTAM

Datacom/DC was designed as a solution to CICS’ difficult-to-use and poorly performing characteristics. Although Datacom/DC solved virtually all of CICS’s shortcomings and provided high performance, IBM continued to pour massive resources into CICS. VTAM’s introduction in the late 1980s meant that much of Datacom/DC would have to be gutted and rewritten. Rather than pursue this tack, ADR chose to back out of that marketplace and replaced Datacom/DC with CICS Services as the interface between CICS, Datacom and later, IDEAL.

Even though IDEAL was originally designed to work only with Datacom/DB, IDEAL was subsequently developed as a service for DB2.

DATACOM/DB for Edos

ADR licensed DATACOM/DB to TCSC, a firm which sold modified versions of IBM's DOS/360 and DOS/VS operating systems, known as Edos (later also known as Edos/VS and Edos/VSE). When, in 1980, Nixdorf Computer bought TCSC, Nixdorf sought to continue the licensing arrangement; ADR and NCSC went to court in a dispute over whether the licensing arrangement was terminated by the acquisition. [2] ADR and Nixdorf settled out of court in 1981, with an agreement that Nixdorf could continue to resell ADR's products. [3]

Ameritech

ADR Ameritech logo.jpg

In 1986 ADR was acquired by Chicago-based Ameritech. Ameritech’s primary motivation was a belief that communications and software would eventually become intertwined and Ameritech wanted to be in the game at the outset.

Computer Associates

CA r 1c Black 2014-transparent.png

Although Ameritech’s original motivation would prove accurate in later years, Ameritech sold ADR to Computer Associates in 1988. The acquisition by CA incorporated Datacom/DB and IDEAL into CA’s already large family of mainframe products. One of the hallmarks of Datacom/DB has been its ability to provide major new enhancements to existing application programs without requiring any recoding.

Datacom/DB and IDEAL remain major CA products today and are the data processing backbones of many Fortune 500 companies as well as many U.S. federal agencies.

CA, Inc. v ISI Pty Limited

In 2012, CA was successful in a lawsuit against an Australian software company, ISI Pty Limited, which offered a software product "2BDB2" designed to simplify migration from Datacom to IBM's DB2 relational database. 2BDB2 contained macros designed to interoperate with those CA macros used by software to access Datacom, but which instead connected to DB2. The Federal Court of Australia found that 2BDB2's macros were based on those included in CA Datacom, and thus infringed on CA's copyright; while there is an interoperability exception under Australian copyright law, the Federal Court adopted a narrow reading of that exception, rendering it largely unavailable to ISVs such as ISI. The Federal Court also found that ISI had illegally relied on CA's confidential information in developing the 2BDB2 product. [4] [5]

CADRE

Cadre logo 2.jpg

The first Datacom user conference was held in Dallas in 1974. Every year since then an annual user conference has been held. When Insyte Datacom was sold to ADR in 1978, the conferences continued and they were renamed CADRE. So CADRE or its logical predecessor has been in existence since 1974.

Bibliography

Related Research Articles

<span class="mw-page-title-main">Database</span> Organized collection of data in computing

In computing, a database is an organized collection of data stored and accessed electronically through the use of a database management system. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases spans formal techniques and practical considerations, including data modeling, efficient data representation and storage, query languages, security and privacy of sensitive data, and distributed computing issues, including supporting concurrent access and fault tolerance.

A relational database is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A system used to maintain relational databases is a relational database management system (RDBMS). Many relational database systems are equipped with the option of using SQL for querying and updating the database.

<span class="mw-page-title-main">Ingres (database)</span>

Ingres Database is a proprietary SQL relational database management system intended to support large commercial and government applications.

<span class="mw-page-title-main">IBM Db2</span> Relational model database server

Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB/2, then DB2 until 2017 and finally changed to its present form.

ISAM is a method for creating, maintaining, and manipulating computer files of data so that records can be retrieved sequentially or randomly by one or more keys. Indexes of key fields are maintained to achieve fast retrieval of required file records in Indexed files. IBM originally developed ISAM for mainframe computers, but implementations are available for most computer systems.

<span class="mw-page-title-main">CICS</span> IBM mainframe transaction monitor

IBM CICS is a family of mixed-language application servers that provide online transaction management and connectivity for applications on IBM mainframe systems under z/OS and z/VSE.

Adabas, a contraction of “adaptable database system," is a database package that was developed by Software AG to run on IBM mainframes. It was launched in 1971 as a non-relational database. As of 2019, Adabas is marketed for use on a wider range of platforms, including Linux, Unix, and Windows.

Gen is a Computer Aided Software Engineering (CASE) application development environment marketed by Broadcom Inc. Gen was previously known as CA Gen,IEF, Composer by IEF, Composer, COOL:Gen, Advantage:Gen and AllFusion Gen.

Model 204 (M204) is a database management system for IBM and compatible mainframe computers developed and commercialized by Computer Corporation of America. It was announced in 1965, and first deployed in 1972. It incorporates a programming language and an environment for application development. Implemented in assembly language for IBM System/360 and its successors, M204 can deal with very large databases and transaction loads of 1000 TPS.

<span class="mw-page-title-main">IDMS</span>

The Integrated Database Management System (IDMS) is a network model (CODASYL) database management system for mainframes. It was first developed at B.F. Goodrich and later marketed by Cullinane Database Systems. Since 1989 the product has been owned by Computer Associates, who renamed it Advantage CA-IDMS and later simply to CA IDMS.

Cullinet was a software company whose products included the database management system IDMS and the integrated software package Goldengate. In 1989, the company was bought by Computer Associates. Cullinet was headquartered at 400 Blue Hill Drive in Westwood, Massachusetts.

Cincom Systems, Inc., is a privately held multinational computer technology corporation founded in 1968 by Tom Nies, Tom Richley, and Claude Bogardus.

<span class="mw-page-title-main">Nixdorf Computer</span> German computer company

Nixdorf Computer AG was a West German computer company founded by Heinz Nixdorf in 1952. Headquartered in Paderborn, Germany, it became the fourth largest computer company in Europe, and a worldwide specialist in banking and point-of-sale systems.

A transaction processing system (TPS) is a software system, or software/hardware combination, that supports transaction processing.

<span class="mw-page-title-main">Applied Data Research</span>

Applied Data Research (ADR) was a large software vendor from the 1960s until the mid-1980s. ADR is often described as "the first independent software vendor".

Edos is a discontinued operating system based upon IBM's original mainframe DOS. The name stood for extended disk operating system. It was later purchased by the West German computer company Nixdorf, who renamed it to NIDOS.

<span class="mw-page-title-main">Michael Stonebraker</span> American computer scientist (born 1943)

Michael Ralph Stonebraker is a computer scientist specializing in database systems. Through a series of academic prototypes and commercial startups, Stonebraker's research and products are central to many relational databases. He is also the founder of many database companies, including Ingres Corporation, Illustra, Paradigm4, StreamBase Systems, Tamr, Vertica and VoltDB, and served as chief technical officer of Informix. For his contributions to database research, Stonebraker received the 2014 Turing Award, often described as "the Nobel Prize for computing."

<span class="mw-page-title-main">Distributed Data Management Architecture</span>

Distributed Data Management Architecture (DDM) is IBM's open, published software architecture for creating, managing and accessing data on a remote computer. DDM was initially designed to support record-oriented files; it was extended to support hierarchical directories, stream-oriented files, queues, and system command processing; it was further extended to be the base of IBM's Distributed Relational Database Architecture (DRDA); and finally, it was extended to support data description and conversion. Defined in the period from 1980 to 1993, DDM specifies necessary components, messages, and protocols, all based on the principles of object-orientation. DDM is not, in itself, a piece of software; the implementation of DDM takes the form of client and server products. As an open architecture, products can implement subsets of DDM architecture and products can extend DDM to meet additional requirements. Taken together, DDM products implement a distributed file system.

System 2000 (S2K) is a hierarchical database management system (DBMS). Although not a relational database, S2K does have SQL support. In 2007 it was noted that, while still 'running on systems cranking away in back rooms across the U.S.' it has a problem: "there's little curriculum coverage anymore at universities teaching computer science."

References

  1. Pratt & Adamski 1987 , p. 465
  2. Blumenthal, Marcia (18 August 1980), "ADR asks ruling on Datacom rights", Computerworld, IDG Enterprise, vol. 14, no. 33, p. 76, ISSN   0010-4841
  3. Enterprise, I. D. G. (20 April 1981), "ADR, Nixdorf Companies Settle Marketing Dispute", Computerworld, vol. 15, no. 16, p. 78, ISSN   0010-4841
  4. Golder, Tom; Gleeson, Jesse; Van Slkye, Brandon (September 2012). "I, object! A landmark case in relation to software copyright" (PDF). Computers & Law (83): 1–5. ISSN   0811-7225 . Retrieved 2017-03-27.
  5. Kennedy, Gabriela (2012). "Asia-Pacific news". Computer Law & Security Review. 28 (6): 714–726. doi:10.1016/j.clsr.2012.10.001. ISSN   0267-3649.