Data access for the masses through OLE DB

ABSTRACT

This paper presents an overview of OLE DB, a set of interfaces being developed at Microsoft whose goal is to enable applications to have uniform access to data stored in DBMS and non-DBMS information containers. Applications will be able to take advantage of the benefits of database technology without having to transfer data from its place of origin to a DBMS. Our approach consists of defining an open, extensible Collection of interfaces that factor and encapsulate orthogonal, reusable portions of DBMS functionality. These interfaces define the boundaries of DBMS components such as record containers, query processors, and transaction coordinators that enable uniform, transactional access to data among such components. The proposed interfaces extend Microsoft's OLE/COM object services framework with database functionality, hence these interfaces are collectively referred to as OLE DB. The OLE DB functional areas include data access and updates (rowsets), query processing, schema information, notifications, transactions, security, and access to remote data. In a sense, OLE DB represents an effort to bring database technology to the masses. This paper presents an overview of the OLE DB approach and its areas of componentization.

REFERENCES

• 1: D. S. Batory , J. R. Barnett , J. F. Garza , K. P. Smith , K. Tsukuda , C. Twichell , T. E. Wise, GENESIS: An Extensible Database Management System, IEEE Transactions on Software Engineering, v.14 n.11, p.1711-1730, November 1988 [doi>10.1109/32.9057]
• 2: Kyle Geiger, Inside ODBC, Microsoft Press, Redmond, WA, 1995
• 3: Jim Gray , Andreas Reuter, Transaction Processing: Concepts and Techniques, Morgan Kaufmann Publishers Inc., San Francisco, CA, 1992
• 4: Dan Haught , Jim Ferguson , Peter Bateman , Mark Bukovec , Joel Gilman , Jim Gordon , Jim Van de Erve, Microsoft Jet database engine programmer's guide, Microsoft Press, Redmond, WA, 1996
• 5: Guy M. Lohman , Bruce Lindsay , Hamid Pirahesh , K. Bernhard Schiefer, Extensions to Starburst: objects, types, functions, and rules, Communications of the ACM, v.34 n.10, p.94-109, Oct. 1991 [doi>10.1145/125223.125266]
• 6: Microsoft, "Guide to Microsoft Distributed Transaction Coordinator," Microsoft SQL Server, Version 6.5, 1996.
• 7: CORPORATE Microsoft Press, Microsoft Win32 programmer's reference (vol. 3): functions A–G, Microsoft Press, Redmond, WA, 1993
• 8: Microsoft, "The Component Object Model Specification," 1996, Microsoft Deyelopment Library, CD- 14, january, 1996.
• 9: OMG, "The Common Object Request Broker: Architecture and Specification," The Object M~magement Group, 1992.
• 10: David Vaskevitch, Database in crisis and transition: a technical agenda for the year 2001, Proceedings of the 1994 ACM SIGMOD international conference on Management of data, p.484-489, May 24-27, 1994, Minneapolis, Minnesota, United States
• 11: David L. Wells , José A. Blakeley , Craig W. Thompson, Architecture of an Open Object-Oriented Database Management System, Computer, v.25 n.10, p.74-82, October 1992 [doi>10.1109/2.161282]

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.1 Logical Design

Additional Classification:
  D. Software
  D.3 PROGRAMMING LANGUAGES
      D.3.2 Language Classifications

          Nouns: OLE

General Terms:
Theory