FACTOID # 5: China has the most workers, so it's a good thing they've also got the most TV's.
 
 Home   Encyclopedia   Statistics   Countries A-Z   Flags   Maps   Education   Forum   FAQ   About 
 
WHAT'S NEW
RECENT ARTICLES
More Recent Articles »
 

SEARCH ALL

FACTS & STATISTICS    Advanced view

Search encyclopedia, statistics and forums:

 

 

(* = Graphable)

 

 


Encyclopedia > OLE DB

OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB) is an API designed by Microsoft for accessing different types of data stores in a uniform manner. It is a set of interfaces implemented using the Component Object Model (COM); it is otherwise unrelated to OLE. It was designed as a higher-level replacement for, and successor to, ODBC, extending its feature set to support a wider variety of non-relational databases, such as object databases and spreadsheets that do not necessarily implement SQL. API may refer to: In computing, application programming interface In petroleum industry, American Petroleum Institute In education, Academic Performance Index This page concerning a three-letter acronym or abbreviation is a disambiguation page — a navigational aid which lists other pages that might otherwise share the same title. ... Microsoft Corporation, (NASDAQ: MSFT, HKSE: 4338) is a multinational computer technology corporation with global annual revenue of US$44. ... For other uses, see Data (disambiguation). ... Component Object Model (COM) is a platform for software componentry introduced by Microsoft in 1993. ... Object Linking and Embedding (OLE) is a technology that allows embedding and linking to documents and other objects, developed by Microsoft. ... Open Database Connectivity (ODBC) is a standard software API for connecting to database management systems (DBMS). ... Please see Relational database Relational algebra This is a disambiguation page: a list of articles associated with the same title. ... This article is about computing. ... In an object oriented database, information is represented in the form of objects as used in Object-Oriented Programming. ... Screenshot of a spreadsheet under OpenOffice A spreadsheet is a rectangular table (or grid) of information, often financial information. ... SQL (IPA: or ) is a computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management. ...


OLE DB separates the data store from the application that needs access to it through a set of abstractions that include the datasource, session, command and rowsets. This was done because different applications need access to different types and sources of data and do not necessarily want to know how to access functionality with technology-specific methods. OLE DB is conceptually divided into consumers and providers. The consumers are the applications that need access to the data, and the provider is the software component that implements the interface and therefore provides the data to the consumer. OLE DB is part of the Microsoft Data Access Components (MDAC) stack. MDAC is a group of Microsoft technologies that interact together as a framework that allows programmers a uniform and comprehensive way of developing applications for accessing almost any data store. OLE DB providers can be created to access such simple data stores as a text file and spreadsheet, through to such complex databases as Oracle, SQL Server and Sybase ASE. It can also provide access to hierarchial datastores such as email systems. Microsoft Data Access Components (commonly abbreviated MDAC) is a group of Microsoft technologies that interact together as a framework that allows programmers a uniform and comprehensive way of developing applications for accessing almost any data store. ... The term Oracle database may refer either to the database management system (DBMS) software released by Oracle Corporation as Oracle RDBMS, or to any of the individual databases managed by such software. ... Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. ... Adaptive Server Enterprise (ASE) is Sybase Corporations flagship relational database management system product. ...


However, because different data store technologies can have different capabilities, OLE DB providers may not implement every possible interface available to OLE DB. The capabilities that are available are implemented through the use of COM objects - an OLE DB provider will map the data store technologies functionality to a particular COM interface. Microsoft calls the availability of an interface to be "provider-specific" as it may not be applicable depending on the database technology involved. Additionally, however, providers may also augment the capabilities of a data store - these capabilities are known as services in Microsoft parlance.


OLE DB providers

  • Microsoft ships a few OLE DB Providers as part of its MDAC and JET kits
  • Simba Technologies ships SimbaProvider, an SDK used to build custom OLE DB for OLAP providers for multi-dimensional and star schema database connectivity.
  • OpenLink Software ships OLE DB Providers for a number of SQL DBMS, as well as OLE DB Bridges to ODBC and JDBC
  • SQLSummit.com: Catalogue of OLE DB Providers

  Results from FactBites:
 
OLE DB Chapter, First Edition : OLE DB Data Types (239 words)
OLE DB Data Types and Default SAS Formats shows all of the data types and default SAS formats that are supported by the SAS/ACCESS engine for OLE DB.
Default OLE DB Output Data Types shows the default data types that the SAS/ACCESS engine for OLE DB uses when creating DBMS tables.
The SAS/ACCESS engine for OLE DB allows non-default data types to be specified with the DBTYPE= data set option.
OLE DB Chapter, First Edition : Accessing OLE DB for OLAP Data (800 words)
The main difference between normal OLE DB access using SQL Pass-Through and this implementation for OLE DB for OLAP is the use of additional identifiers to pass MDX statements to the OLE DB for OLAP data.
During the process of "flattening" multidimensional data into a two-axis data set, OLE DB for OLAP builds column names from each level of the given dimension.
The provider used is the Microsoft OLE DB for OLAP provider named MSOLAP.
  More results at FactBites »


 

COMMENTARY     


Share your thoughts, questions and commentary here
Your name
Your comments
Please enter the 5-letter protection code

Want to know more?
Search encyclopedia, statistics and forums:

 


Lesson Plans | Student Area | Student FAQ | Reviews | Press Releases |  Feeds | Contact
The Wikipedia article included on this page is licensed under the GFDL.
Images may be subject to relevant owners' copyright.
All other elements are (c) copyright NationMaster.com 2003-5. All Rights Reserved.
Usage implies agreement with terms.