ALERT

[FREE DEMO] Deploy Your Enterprise Cloud in Minutes

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.

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:
  • Consumers: Applications requiring data access
  • Providers: Software components that supply consumer data by using OLE DB APIs
When requesting OLE DB data, an application follows this sequence:
  1. Initialize the OLE.
  2. Establish a connection to the data's source.
  3. Use a command to request access.
  4. Process the application query to acquire request results.
  5. Provide the requested DSO.

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
Tweat cdn.techopedia.com
"Techopedia" on Twitter


'@Techopedia'
Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Resources
The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
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
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
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.