This article needs additional citations for verification .(July 2018) |
Initial release | 1972 |
---|---|
Stable release | 15.1 (z/OS) and 12.0 (z/VSE) / February 26, 2016 |
Written in | C, Assembly |
Operating system | z/OS, z/VSE |
Platform | Mainframe |
Available in | English |
License | Proprietary EULA |
Website | www |
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.
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.
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.
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.
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.
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.
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 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.
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]
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.
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.
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]
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.
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.
Ingres Database is a proprietary SQL relational database management system intended to support large commercial and government applications.
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.
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.
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.
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.
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.
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."
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."