Using a relational system on Wall Street: the good, the bad, the ugly, and the ideal

ABSTRACT

Developers of a Wall Street financial application were able to exploit a relational DBMS to advantage for some data management tasks (the good). For others, the relational system was not helpful (the bad), or could be pressed into service only by means of major or minor contortions (the ugly). The authors identify database constructs that would have simplified developing the application (the ideal).

REFERENCES

• 1: Antonio Albano , Luca Cardelli , Renzo Orsini, GALILEO: a strongly-typed, interactive conceptual language, ACM Transactions on Database Systems (TODS), v.10 n.2, p.230-260, June 1985 [doi>10.1145/3857.3859]
• 2: A. Albano , G. Ghelli , M. E. Occhiuto , R. Orsini, A strongly typed, interactive object-oriented database programming language, Proceedings on the 1986 international workshop on Object-oriented database systems, p.94-103, September 23-26, 1986, Pacific Grove, California, United States
• 3: T. Lougenia Anderson , Earl F. Ecklund, Jr. , David Maier, PROTEUS: objectifying the DBMS user interface, Proceedings on the 1986 international workshop on Object-oriented database systems, p.133-145, September 23-26, 1986, Pacific Grove, California, United States
• 4: Timothy Andrews , Craig Harris, Combining language and database advances in an object-oriented development environment, Conference proceedings on Object-oriented programming systems, languages and applications, p.430-440, October 04-08, 1987, Orlando, Florida, United States
• 5: M. M. Astrahan , M. W. Blasgen , D. D. Chamberlin , K. P. Eswaran , J. N. Gray , P. P. Griffiths , W. F. King , R. A. Lorie , P. R. McJones , J. W. Mehl , G. R. Putzolu , I. L. Traiger , B. W. Wade , V. Watson, System R: relational approach to database management, ACM Transactions on Database Systems (TODS), v.1 n.2, p.97-137, June 1976 [doi>10.1145/320455.320457]
• 6: Malcolm P. Atkinson , Ronald Morrison, Procedures as persistent data objects, ACM Transactions on Programming Languages and Systems (TOPLAS), v.7 n.4, p.539-559, Oct. 1985 [doi>10.1145/4472.4477]
• 7: Atkinson, M. P., et al. An approach to persistent programming. Cornput. J. 26, 4(1983), 360-365.
• 8: Bancilhon, F., and Mater, D. Multilanguage object-oriented systems: New answer to old database problems? Tech. Rep. 21-88, 1988. Altair, Domaine de Voluceau BPI05, Rocquencourt 78153 Le Chesnay Cedex, France.
• 9: Jay Banerjee , Won Kim , Hyoung-Joo Kim , Henry F. Korth, Semantics and implementation of schema evolution in object-oriented databases, Proceedings of the 1987 ACM SIGMOD international conference on Management of data, p.311-322, May 27-29, 1987, San Francisco, California, United States
• 10: D. S. Batory , T. Y. Leung , T. E. Wise, Implementation concepts for an extensible data model and data language, ACM Transactions on Database Systems (TODS), v.13 n.3, p.231-262, Sept. 1988 [doi>10.1145/44498.45062]
• 11: Michael J. Carey , David J. DeWitt, A data model and query language for EXODUS, Proceedings of the 1988 ACM SIGMOD international conference on Management of data, p.413-423, June 01-03, 1988, Chicago, Illinois, United States
• 12: Michael J. Carey , David J. DeWitt , Daniel Frank , M. Muralikrishna , Goetz Graefe , Joel E. Richardson , Eugene J. Shekita, The architecture of the EXODUS extensible DBMS, Proceedings on the 1986 international workshop on Object-oriented database systems, p.52-65, September 23-26, 1986, Pacific Grove, California, United States
• 13: Peter Pin-Shan Chen, The entity-relationship model—toward a unified view of data, ACM Transactions on Database Systems (TODS), v.1 n.1, p.9-36, March 1976 [doi>10.1145/320434.320440]
• 14: Cedd, E. F. Fatal flaws in SQL (part 2). Datamation 34, 17(Sept. 1988), 71-74.
• 15: Cedd, E. F. Fatal flaws in SQL (part 1). Datamation 34, 16(Aug. 1988), 45-48.
• 16: George Copeland , David Maier, Making smalltalk a database system, Proceedings of the 1984 ACM SIGMOD international conference on Management of data, June 18-21, 1984, Boston, Massachusetts
• 17: P. Dadam , K. Kuespert , F. Andersen , H. Blanken , R. Erbe, A DBMS prototype to support extended NF2 relations: an integrated view on flat tables and hierarchies, Proceedings of the 1986 ACM SIGMOD international conference on Management of data, p.356-367, May 28-30, 1986, Washington, D.C., United States
• 18: Date, C. J. Database: A Primer, Addison-Wesley, Reading, Mass., 1983.
• 19: Umeshwar Dayal , John M Smith, PROBE: a knowledge-oriented database management system, On knowledge base management systems: integrating artificial intelligence and d atabase technologies, Springer-Verlag New York, Inc., New York, NY, 1986
• 20: Fishman, D. H., et al. Iris: An object-oriented database management system. ACM Trans. Office Inf. Syst. 5, l{Jan. 1987), 48-69.
• 21: John Guttag, Abstract data types and the development of data structures, Communications of the ACM, v.20 n.6, p.396-404, June 1977 [doi>10.1145/359605.359618]
• 22: Alfons Kemper , Peter C. Lockemann , Mechtild Wallrath, An object-oriented system for engineering applications, Proceedings of the 1987 ACM SIGMOD international conference on Management of data, p.299-310, May 27-29, 1987, San Francisco, California, United States
• 23: Won Kim , Jay Banerjee , Hong-Tai Chou , Jorge F. Garza , Darrel Woelk, Composite object support in an object-oriented database system, Conference proceedings on Object-oriented programming systems, languages and applications, p.118-125, October 04-08, 1987, Orlando, Florida, United States
• 24: C. Lecluse , P. Richard , F. Velez, O2, an object-oriented data model, Proceedings of the 1988 ACM SIGMOD international conference on Management of data, p.424-433, June 01-03, 1988, Chicago, Illinois, United States
• 25: Bruce Lindsay , John McPherson , Hamid Pirahesh, A data management extension architecture, Proceedings of the 1987 ACM SIGMOD international conference on Management of data, p.220-226, May 27-29, 1987, San Francisco, California, United States
• 26: David Maier , Jacob Stein , Allen Otis , Alan Purdy, Development of an object-oriented DBMS, Conference proceedings on Object-oriented programming systems, languages and applications, p.472-482, September 29-October 02, 1986, Portland, Oregon, United States
• 27: Frank Manola , Umeshwar Dayal, PDM: an object-oriented data model, Proceedings on the 1986 international workshop on Object-oriented database systems, p.18-25, September 23-26, 1986, Pacific Grove, California, United States
• 28: Patrick O'Brien , Bruce Bullis , Craig Schaffert, Persistent and shared objects in Trellis/Owl, Proceedings on the 1986 international workshop on Object-oriented database systems, p.113-123, September 23-26, 1986, Pacific Grove, California, United States
• 29: Ontologic, Inc. Vbase Integrated Object System Technical Overview. Billerica, Mass., 1986.
• 30: Oracle Corp. Oracle Database Administrator's Guide Version 6.0. Part No. 3601-V6.0. Belmont, Calif., 1988.
• 31: Peter Peinl , Andreas Reuter , Harald Sammer, High contention in a stock trading database: a case study, Proceedings of the 1988 ACM SIGMOD international conference on Management of data, p.260-268, June 01-03, 1988, Chicago, Illinois, United States
• 32: P. Schwarz , W. Chang , J. C. Freytag , G. Lohman , J. McPherson , C. Mohan , H. Pirahesh, Extensibility in the Starburst database system, Proceedings on the 1986 international workshop on Object-oriented database systems, p.85-92, September 23-26, 1986, Pacific Grove, California, United States
• 33: Andrea H. Skarra , Stanley B. Zdonik, The management of changing types in an object-oriented database, Conference proceedings on Object-oriented programming systems, languages and applications, p.483-495, September 29-October 02, 1986, Portland, Oregon, United States
• 34: Andrea H. Skarra , Stanley B. Zdonik , Stephen P. Reiss, An object server for an object-oriented database system, Proceedings on the 1986 international workshop on Object-oriented database systems, p.196-204, September 23-26, 1986, Pacific Grove, California, United States
• 35: Karen E. Smith , Stanley B. Zdonik, Intermedia: A case study of the differences between relational and object-oriented database systems, Conference proceedings on Object-oriented programming systems, languages and applications, p.452-465, October 04-08, 1987, Orlando, Florida, United States
• 36: Michael Stonebraker , Randy H. Katz , David A. Patterson , John K. Ousterhout, The Design of XPRS, Proceedings of the 14th International Conference on Very Large Data Bases, p.318-330, August 29-September 01, 1988
• 37: Michael Stonebraker , Lawrence A. Rowe, The design of POSTGRES, Proceedings of the 1986 ACM SIGMOD international conference on Management of data, p.340-355, May 28-30, 1986, Washington, D.C., United States
• 38: Michael Stonebraker , Gerald Held , Eugene Wong , Peter Kreps, The design and implementation of INGRES, ACM Transactions on Database Systems (TODS), v.1 n.3, p.189-222, Sept. 1976 [doi>10.1145/320473.320476]
• 39: Sybase, Inc. Commands Reference. Document number 3241-2.1. Berkeley, Calif., 1987.
• 40: CORPORATE Tandem Performance Group, A benchmark of non-stop SQL on the debit credit transaction, Proceedings of the 1988 ACM SIGMOD international conference on Management of data, p.337-341, June 01-03, 1988, Chicago, Illinois, United States

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
  H.4 INFORMATION SYSTEMS APPLICATIONS
      H.4.2 Types of Systems
          Subjects: Decision support (e.g., MIS)

  K. Computing Milieux
  K.6 MANAGEMENT OF COMPUTING AND INFORMATION SYSTEMS
      K.6.1 Project and People Management
          Subjects: Systems analysis and design

General Terms:
Algorithms, Design, Performance