Shared Flashcard Set

Details

DBMS Chapter 6
Universal interface to relational DBS
34
Other
Graduate
01/16/2015
Click here to study/print these flashcards.

Create your own flash cards! Sign up here.

Additional Other Flashcards

 

 

Cards

Term
Embedded API
 Definition
  • the SQL instructions are embedded in a host language
  • SQL code is proccesed in precompilation
  • DBS is hidden form end users and needs almost no maintence 
Term
Call-Level API
 Definition

provides methods that can be called to perform the desired DB operations, no inside software and can be accessed by user

  • establishing a db connections
  • buffering and executing SQL instructions
  • processing query reults 
  • returing status information
Term
SQL binding
 Definition

pertains to the conversion of SQL code to an internal format the can be executed by the DB engine

Following Tasks:

  1. validation of table and column names
  2. authorisation checks
  3. generation and optimisation of an access path 
  4. generation of machine code
  5. binding of acces path to database
Term
Static SQL Early binding
 Definition
converstion of SQL code happens during precompilation
Term
Dynamic SQL:Late binding
 Definition
conserison of SQL code to an internal format happens during execution
Term
API
 Definition
  • application programming interface
  • is a set of routines,protocols,and tools for building software application
Term
Generic API
 Definition
general API that isnt DB specific
Term
Specific API
 Definition
if we have oracle APIE we need an oracle DB
Term
ODBC API
 Definition
this is a call-level interface, with support for both early and late binding
Term
database drivers
 Definition
routine libraries that are tailored to interact with a particular DBMS type
Term
ODBC driver manager
 Definition
responsible for selecting the appropriate driver to access a particular DBMS type
Term
SPI
 Definition
  • Service provider interface
  • interface between the driver manager and database drivers
Term

ODBC

(Open DataBase Connectivity)

 Definition
  • Developed by Microscoft as an open standard to provide applcations with a uniform interface to relationals DBMS
  • It hides underlying DBMS specific API or a particular DBMS vendor
  • Components:
  • ODBC API
  • database drivers
  • ODBC driver manager 
  • Service Provider Interface
Term
JDBC
 Definition
implements a call-level database API that is independent of the underlying DBMS-Java based
Term
ODBC Bridge
 Definition
can convert ODBC into JDBC
Term
DriverManager interface
 Definition
provides a uniform interface to establish a database connection. It manages the installed database drivers and provides transparent access to a wide range of DB products
Term
getConnection
 Definition
method results in the DB being connected by means of the corresponding driver. The database can be identified by URL or username and password
Term
Driver interface
 Definition

driver object is never accessed directly by application, no concern to programmer. Driver mediates between DriverManager and DB

  • Types:
  1. driver to access DBMS through native interface
  2. DBMS-neutral 'net protocol' driver
  3. JDBC-ODBC 'bridge' driver
Term
Connection interface
 Definition

connection object represents an individual database session. encompasses functionality required to maintain a database connection

is also transaction control- defines commit and rollback methods
Term
Statement interface
 Definition
java abstraction of an SQL query that generates a ResultSet object containing the results
Term
PreparedStatement
 Definition
separates binding and execution of a query
Term
Callable statement
 Definition
calls a stored procedure
Term
ResultSet
 Definition
object that contains the query result of a select query that was executed through a Statement objecy. each one maintains a cursor which indicates the current row. next() can be used to move it
Term
getXXX()
 Definition
current row of results cna be read. XXX refers to data type of the desired column. also possible to inquire for metadata
Term
ResultSetMetaData
 Definition
used to retrieve metadata regarding the query result
Term
DatabaseMetaData
 Definition
used to retrieve metadate regarding the database
Term
SQLException class
 Definition
used for error handling
Term
SQLJ
 Definition
  • implements the embedded SQL standard for Java, only static SQL.
  • code is precompiled into standard java which DB accesses the DB through underlying call-level interface
  • at compile time the SQL code can be checked for syntactial correctness,typ compatibility and conformance to the corresponding DB schema
Term
connection-context
 Definition
each SQLJ clause has one as specified by means of JDBC
Term
Host variables
 Definition
java objects can be used as parameters in SQLJ instructions
Term
Iterator
 Definition
this is an object that contains the result rows of an SQL query, which can be accessed one by one
Term
CALL statement
 Definition
used to invoke a stored procedure
Supporting users have an ad free experience!