1 / 16

Chapter 13

Database Processing. 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. ODBC. Open Database Connectivity;

miyo
Download Presentation

Chapter 13

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Processing Chapter 13 Accessing the Database Server: ODBC, OLE DB, and ADO David M. Kroenke © 2000 Prentice Hall

  2. Typical Web Server Page 340 Figure 13-1 © 2000 Prentice Hall

  3. ODBC Open Database Connectivity; DBMS-independent means for processing relational database data • ORACLE • SYBASE • INFORMIX Page 342

  4. ODBC Terminology • Data sourcethe 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

  5. Role of ODBC Standard Page 340 Figure 13-2 © 2000 Prentice Hall

  6. ODBC Architecture Page 343 Figure 13-5 © 2000 Prentice Hall

  7. Conformance Levels • ODBC concerned with APIapplication program interface • SQL • Minimum • Core • Extended Page 344

  8. ODBC Data Source Types • Fileshared among database users • Systemlocal to a single computer • User only available to the user who created it Page 346

  9. 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 non-relational data Page 348

  10. 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

  11. Role of OLE DB Page 341 Figure 13-3 © 2000 Prentice Hall

  12. OLE DB Goals Page 349 Figure 13-10 © 2000 Prentice Hall

  13. OLE DB Data Providers Page 350 Figure 13-11 © 2000 Prentice Hall

  14. ADO Active Data Objects; an interface that enables programmers in almost any language (including scripting) to access OLE DB functionality Page 351

  15. Role of ADO Page 342 Figure 13-4 © 2000 Prentice Hall

  16. ADO Object Model Page 352 Figure 13-14 © 2000 Prentice Hall

More Related