chapter 13 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Chapter 13 PowerPoint Presentation
Download Presentation
Chapter 13

Loading in 2 Seconds...

play fullscreen
1 / 16

Chapter 13 - PowerPoint PPT Presentation


  • 98 Views
  • Uploaded on

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;

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Chapter 13' - miyo


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
chapter 13

Database Processing

Chapter 13

Accessing the Database Server: ODBC, OLE DB, and ADO

David M. Kroenke

© 2000 Prentice Hall

typical web server
Typical Web Server

Page 340

Figure 13-1

© 2000 Prentice Hall

slide3
ODBC

Open Database Connectivity;

DBMS-independent means for processing relational database data

  • ORACLE
  • SYBASE
  • INFORMIX

Page 342

odbc terminology
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

role of odbc standard
Role of ODBC Standard

Page 340

Figure 13-2

© 2000 Prentice Hall

odbc architecture
ODBC Architecture

Page 343

Figure 13-5

© 2000 Prentice Hall

conformance levels
Conformance Levels
  • ODBC concerned with APIapplication program interface
  • SQL
    • Minimum
    • Core
    • Extended

Page 344

odbc data source types
ODBC Data Source Types
  • Fileshared among database users
  • Systemlocal to a single computer
  • User only available to the user who created it

Page 346

ole db
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

object terminology
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

role of ole db
Role of OLE DB

Page 341

Figure 13-3

© 2000 Prentice Hall

ole db goals
OLE DB Goals

Page 349

Figure 13-10

© 2000 Prentice Hall

ole db data providers
OLE DB Data Providers

Page 350

Figure 13-11

© 2000 Prentice Hall

slide14
ADO

Active Data Objects;

an interface that enables programmers in almost any language (including scripting) to access OLE DB functionality

Page 351

role of ado
Role of ADO

Page 342

Figure 13-4

© 2000 Prentice Hall

ado object model
ADO Object Model

Page 352

Figure 13-14

© 2000 Prentice Hall