article

Free access

Data access for the masses through OLE DB

Author:

José A. BlakeleyAuthors Info & Claims

ACM SIGMOD Record, Volume 25, Issue 2

Pages 161 - 172

https://doi.org/10.1145/235968.233329

Published: 01 June 1996 Publication History

PDF eReader

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, et al., "Genesis: An Extensible Database Management System," IEEE Tr~ms. Software Eng., Vol. 14, No. 11, Nov. 1988, pp. 1,711-1,73().

Digital Library

Google Scholar

[2]

K. Geiger. "Inside ODBC," Microsoft Press, 1995.

Digital Library

Google Scholar

[3]

J, Gray :rod A. Reuter. "Transaction Processing: Concepts and Techniques," Morgan Kaufin~mn, 1995.

Digital Library

Google Scholar

[4]

D. I-~mght and J. Ferguson. "Microsoft Jet Database Engine Programmer's Guide," Microsoft Press, 1996.

Digital Library

Google Scholar

[5]

G.M. Lohman et al. "Extensions to Starburst: Objects. Types, Functions, and Rules,'" Communications of the ACM, Vol. 34, No. I0, Oct. 1991, pp. 94-109.

Digital Library

Google Scholar

[6]

Microsoft, "Guide to Microsoft Distributed Transaction Coordinator," Microsoft SQL Server, Version 6.5, 1996.

Google Scholar

[7]

Microsoft, "OLE 2 Programmer's Reference," Vols. i-2, Microsoft Press, 1994.

Digital Library

Google Scholar

[8]

Microsoft, "The Component Object Model Specification," 1996, Microsoft Deyelopment Library, CD- 14, january, 1996.

Google Scholar

[9]

OMG, "The Common Object Request Broker: Architecture and Specification," The Object M~magement Group, 1992.

Google Scholar

[10]

D. Vaskevitch. "Database in Crisis and Transition: A Technical Agenda for the Year 2001," Proc. of the ACM Sigmod 1994 Conf., pp. 484-489.

Digital Library

Google Scholar

[11]

D.L. Wells, J.A. Blakeley, C.W. Thompson. "Architecture of an Open Object-Oriented Database Management System." Computer, Vol. 25, No. 10, Oct. 1992, pp. 74-82.

Digital Library

Google Scholar

Cited By

View all

Irmert FLauterwald FNeumann CDaum MLenz RMeyer-Wegener KDesai BSacca DGreco S(2009)Semantics of a runtime adaptable transaction managerProceedings of the 2009 International Database Engineering & Applications Symposium10.1145/1620432.1620442(88-96)Online publication date: 16-Sep-2009
https://dl.acm.org/doi/10.1145/1620432.1620442
Irmert FDaum MMeyer-Wegener K(2008)A new approach to modular database systemsProceedings of the 2008 EDBT workshop on Software engineering for tailor-made data management10.1145/1385486.1385498(40-44)Online publication date: 29-Mar-2008
https://dl.acm.org/doi/10.1145/1385486.1385498
Blakeley JCunningham CEllis NRathakrishnan BWu M(2005)Distributed/Heterogeneous Query Processing in Microsoft SQL ServerProceedings of the 21st International Conference on Data Engineering10.1109/ICDE.2005.51(1001-1012)Online publication date: 5-Apr-2005
https://dl.acm.org/doi/10.1109/ICDE.2005.51
Show More Cited By

Index Terms

Data access for the masses through OLE DB
1. Information systems
  1. Data management systems
    1. Database design and models
2. Software and its engineering
  1. Software notations and tools
    1. General programming languages
      1. Language types

Recommendations

Data access for the masses through OLE DB
SIGMOD '96: Proceedings of the 1996 ACM SIGMOD international conference on Management of data

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 ...
OLE DB: A Component DBMS Architecture
ICDE '96: Proceedings of the Twelfth International Conference on Data Engineering

The article describes an effort at Microsoft whose primary goal is to enable applications to have uniform access to data stored in diverse DBMS and non DBMS information containers. Applications continue to take advantage of the benefits of database ...
Universal Data Access with OLE DB
COMPCON '97: Proceedings of the 42nd IEEE International Computer Conference

OLE DB is Microsoft's new data access API designed to enable access to all kinds of data sources, both database and non database, regardless of format or location. OLE DB builds on Microsoft's Component Object Model (COM), which is the foundation for ...

Comments

Information & Contributors

Information

Published In

ACM SIGMOD Record Volume 25, Issue 2

June 1996

557 pages

ISSN:0163-5808

DOI:10.1145/235968

Chairman:
T. H. Merrett
McGill Univ.
,
Editors:
H. V. Jagadish,
Inderpal Singh Mumick

Issue’s Table of Contents

SIGMOD '96: Proceedings of the 1996 ACM SIGMOD international conference on Management of data
June 1996
560 pages
ISBN:0897917944
DOI:10.1145/233269
Editor:
Jennifer Widom
Stanford Univ., Stanford, CT

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 June 1996

Published in SIGMOD Volume 25, Issue 2

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

32
Total Citations
View Citations
969
Total Downloads

Downloads (Last 12 months)142
Downloads (Last 6 weeks)20

Reflects downloads up to 13 Sep 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Irmert FLauterwald FNeumann CDaum MLenz RMeyer-Wegener KDesai BSacca DGreco S(2009)Semantics of a runtime adaptable transaction managerProceedings of the 2009 International Database Engineering & Applications Symposium10.1145/1620432.1620442(88-96)Online publication date: 16-Sep-2009
https://dl.acm.org/doi/10.1145/1620432.1620442
Irmert FDaum MMeyer-Wegener K(2008)A new approach to modular database systemsProceedings of the 2008 EDBT workshop on Software engineering for tailor-made data management10.1145/1385486.1385498(40-44)Online publication date: 29-Mar-2008
https://dl.acm.org/doi/10.1145/1385486.1385498
Blakeley JCunningham CEllis NRathakrishnan BWu M(2005)Distributed/Heterogeneous Query Processing in Microsoft SQL ServerProceedings of the 21st International Conference on Data Engineering10.1109/ICDE.2005.51(1001-1012)Online publication date: 5-Apr-2005
https://dl.acm.org/doi/10.1109/ICDE.2005.51
Brandmeyer JKarimi H(2000)Coupling methodologies for environmental modelsEnvironmental Modelling & Software10.1016/S1364-8152(00)00027-X15:5(479-488)Online publication date: Jul-2000
https://doi.org/10.1016/S1364-8152(00)00027-X
Reinwald BPirahesh HKrishnamoorthy GLapis GTran BVora S(1999)Heterogeneous query processing through SQL table functionsProceedings 15th International Conference on Data Engineering (Cat. No.99CB36337)10.1109/ICDE.1999.754952(366-373)Online publication date: 1999
https://doi.org/10.1109/ICDE.1999.754952
Rohm UBohm K(1999)Working together in Harmony-an implementation of the CORBA object query service and its evaluationProceedings 15th International Conference on Data Engineering (Cat. No.99CB36337)10.1109/ICDE.1999.754929(238-247)Online publication date: 1999
https://doi.org/10.1109/ICDE.1999.754929
Lakshmanan LSubramanian SGoyal NKrishnamurthy R(1998)On querying spreadsheetsProceedings 14th International Conference on Data Engineering10.1109/ICDE.1998.655769(134-141)Online publication date: 1998
https://doi.org/10.1109/ICDE.1998.655769
Vidal MRaschid LGruser J(1998)A meta-wrapper for scaling up to multiple autonomous distributed information sourcesProceedings 3rd IFCIS International Conference on Cooperative Information Systems (Cat No 98EX122) COOPIS-9810.1109/COOPIS.1998.706193(148-157)Online publication date: 1998
https://doi.org/10.1109/COOPIS.1998.706193
Tomasic ARaschid LValduriez P(1998)Scaling Access to Heterogeneous Data Sources with DISCOIEEE Transactions on Knowledge and Data Engineering10.1109/69.72973610:5(808-823)Online publication date: 1-Sep-1998
https://dl.acm.org/doi/10.1109/69.729736
McCollum CFaatz DHerndon WSebes EThomas R(1998)Distributed object technologies, databases, and securityDatabase Security XI10.1007/978-0-387-35285-5_2(17-31)Online publication date: 1998
https://doi.org/10.1007/978-0-387-35285-5_2
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Abstract

References

Cited By

Index Terms

Recommendations