Transcript Chapter 13: Accessing the Database Server: ODBC, OLE DB

Database Processing
Chapter 13
Chapter 13
Accessing the Database Server:
ODBC, OLE DB, and ADO
David M. Kroenke
© 2000 Prentice Hall
Typical Web Server
Page 340
Figure 13-1
© 2000 Prentice Hall
Chapter 13
ODBC
Open Database Connectivity;
DBMS-independent means for
processing relational database data
– ORACLE
– SYBASE
– INFORMIX
Page 342
© 2000 Prentice Hall
Chapter 13
ODBC Terminology
• Data source the database, its associated
DBMS, operating system, and network
platform
• Driver manager intermediary between the
application and DBMS drivers
• Driver processes ODBC requests and
submits SQL statements to a data source
Page 343
© 2000 Prentice Hall
Role of ODBC Standard
Page 340
Figure 13-2
© 2000 Prentice Hall
ODBC Architecture
Page 343
Figure 13-5
© 2000 Prentice Hall
Chapter 13
Conformance Levels
• ODBC concerned with API
application program interface
• SQL
– Minimum
– Core
– Extended
Page 344
© 2000 Prentice Hall
Chapter 13
ODBC Data Source Types
• File shared among database users
• System local to a single computer
• User only available to the user who
created it
Page 346
© 2000 Prentice Hall
Chapter 13
OLE DB
Object Linking and Embedding
Database;
Provides an object-oriented interface
to data of almost any type and used
as an interface to ODBC and nonrelational data
Page 348
© 2000 Prentice Hall
Chapter 13
Object Terminology
• Abstraction a generalization of something
• Method actions that an object can
perform
• Property a characteristic of a recordset
abstraction
• Collection object that contains a group of
other objects
Page 348
© 2000 Prentice Hall
Role of OLE DB
Page 341
Figure 13-3
© 2000 Prentice Hall
OLE DB Goals
Page 349
Figure 13-10
© 2000 Prentice Hall
OLE DB Data Providers
Page 350
Figure 13-11
© 2000 Prentice Hall
Chapter 13
ADO
Active Data Objects;
an interface that enables programmers
in almost any language (including
scripting) to access OLE DB
functionality
Page 351
© 2000 Prentice Hall
Role of ADO
Page 342
Figure 13-4
© 2000 Prentice Hall
ADO Object Model
Page 352
Figure 13-14
© 2000 Prentice Hall