Object Linking and Embedding Database (OLE DB)
Definition - What does Object Linking and Embedding Database (OLE DB) mean?
Object Linking and Embedding Database (OLE DB) is a group of APIs used to facilitate and abtract access to application data of different file formats, including spreadsheets, structured query language (SQL)-based database management systems (DBMS), indexed-sequential files, and personal databases.
OLE DB is based on the Component Object Model (COM) and is part of the Microsoft Data Access Components (MDAC) software package, which is used to read and write data.
OLE DB is based on the Component Object Model (COM) and is part of the Microsoft Data Access Components (MDAC) software package, which is used to read and write data.
Techopedia explains Object Linking and Embedding Database (OLE DB)
The OLE DB object model components are data source objects (DSO), command objects, rowset objects and session objects. OLE DB uses abstraction sets to segregate stored application data, because different programs require access to different DSO types.
OLE DB classifications are:
OLE DB classifications are:
- Consumers: Applications requiring data access
- Providers: Software components that supply consumer data by using OLE DB APIs
- Initialize the OLE.
- Establish a connection to the data's source.
- Use a command to request access.
- Process the application query to acquire request results.
- Provide the requested DSO.
-
3 FREE Network Management Tools - Simplify everyday tasks and troubleshooting. 100% Free | No Expiration | Download them All
-
FREE Network Analyzer & Bandwidth Monitoring Bundle - FREE Network Analyzer & Bandwidth Monitoring Bundle makes it easy to quickly identify the types of network traffic by flow data capture and interface monitoring for bandwidth usage in real time!
Email Newsletter
Join thousands of others with our weekly newsletter
Please Wait...
Resources
![[WEBINAR] Building a Business-Driven Data Architecture](http://cdn.techopedia.com/images/uploads//qrcode.png?width=80&height=40)
Free Whitepaper: The Path to Hybrid Cloud:
The Path to Hybrid Cloud: Intelligent Bursting To Amazon Web Services & Microsoft Azure
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.
'@Techopedia'