ODBC
E35619
ODBC (Open Database Connectivity) is a standard API that enables applications to access and query data from a wide variety of relational and non-relational database management systems using a common interface.
Observed surface forms (2)
| Surface form | As subject | As object |
|---|---|---|
| OLE DB | 0 | 1 |
| Open Database Connectivity | 0 | 1 |
Statements (49)
| Predicate | Object |
|---|---|
| instanceOf |
application programming interface
→
data access standard → |
| abbreviation | ODBC self-link → |
| basedOn | Call Level Interface specification → |
| category |
data access middleware
→
database connectivity technology → |
| compatibleWith |
.NET languages via ODBC providers
→
C →
surface form:
C programming language
C++ →
surface form:
C++ programming language
Java via JDBC-ODBC bridge (historically) → |
| designGoal |
database independence for applications
→
uniform access to heterogeneous data sources → |
| developedBy | Microsoft → |
| enables | portability of database applications across DBMS → |
| fullName |
ODBC
self-linksurface differs
→
surface form:
Open Database Connectivity
|
| hasComponent |
ODBC Driver Manager
→
ODBC driver → data source name → |
| introducedIn | early 1990s → |
| managedBy | ODBC Driver Manager on host system → |
| provides |
API for connecting to data sources
→
API for executing SQL statements → API for metadata discovery → API for retrieving query results → common interface for database access → |
| purpose |
enable database-independent application development
→
provide a standard API for accessing databases → |
| relatedTo |
ADO.NET
→
JDBC → OLE DB → |
| requires | ODBC-compliant driver for each DBMS → |
| runsOn |
Linux
→
Windows →
surface form:
Microsoft Windows
macOS → |
| standardizedBy | Microsoft → |
| supports |
SQL databases
→
non-SQL data sources → non-relational database management systems → relational database management systems → |
| supportsFeature |
connection pooling
→
metadata functions → parameterized queries → prepared statements → scrollable cursors → transactions → |
| uses |
SQL as primary query language
→
connection strings → data source names → drivers to communicate with specific DBMS → |
Referenced by (10)
Full triples — surface form annotated when it differs from this entity's canonical label.
this entity surface form:
Open Database Connectivity
subject surface form:
IBM Db2
this entity surface form:
OLE DB