Chapter 7 DBMS

internet application processing

NETWORK BECOMES AN INTEGRAL PART OF THE APPLICATION

Data sources

OBDC data structure that identifies a databse name and the DBMS and that processes it

PHP

PHP = server side language = designed for web dev but used as a general purpose programming language - can be embedded *) is a scripting language that can be embedded in Web pages*

XML web services general

XML Web Services allow application functionality on one Web server to be shared and incorporated into Web applications on other Web servers.

XML

extensible markup language = standard means for defining the structure of documents and for transmitting documents from one computer to another

dataprocessing environment

it's complicated, multifaceted (multiple users, queries etc) and has a lot of processing constraints (ref integegrity, cascading deletion ...)

XML web services

o = When database applications are written as XML Web Services, any computer in the world can access the database applications using standard interfaces, and it appears as if the applications are local to the machine that uses those applications.

API (application programming interface)

o API = collection of objects, methods and properties for executing DBMS functions from program code. Each DBMS has its own API, and APIs vary from one DBMS product to another

types of data sources

o File data source =Can be shared among database users o System data source =Local to a single computer o User data source Only available to the person who created it

types of tiered architecture

oTier one = work station w/ web browser oTwo tier architecture = webserver and DBMS are on same server oThree-tier architecture = web server, DBMS are on separate servers

ODBC

open database connectivity --- = Provides a DBMS-independent means for processing relational database data.

Software Stack

set of software subsystems /components to create a compelte Platform such that no additional software is needed to support applications ((applications either "run on" or "run on top of" the resulting platform))

OLEB/OLE-DB

standard is an API designed by Microsoft which allows accessing data from a variety of sources in a uniform manner ((ADO/ ADO.NET = set of objects for utilizing OLE-DB))

N-tier architecture

tier = # of computers involved in the database application

database stored procedure and triggers

• A DBMS Stored procedure = set of SQL statements w/ an assigned name that is stored in a database so that it can be shared by programs o Trigger = invokes a stored procedure by the DBMS when specific activity occurs

Database processing and XML

• Applications can be written to accept XML documents and extract the data for storage in the database. *xml used for transmission of database data*

XML importance

• XML is important for database processing because it provides a standardized means of submitting data to a database and for receiving results back from the database.

ODBC 3 tier web server architecture

1. application program, ODBC driver manager and ODBC driver all reside on teh Web server 2. the DBMS driver sends requests to data sources on the database server 3. a datasource = (is the database, its associated DBMS, OS, and network platform )

5 ways database can be processed

1. forms 2. reports 3. queries 4. Active server oages 5. Java server

benefit of using stored procedure

1. reduces amt of info sent to database server (1 compilation step) 2. supports reusability of SQL code (just needs to call on the stored procedure instead of writing the same code each time)

ODBC : application program

1. the application program issues requests -create connection w/ data source/ -issue SQL - process errors - do transactions *ODBC defines set standard (of error codes sand messages) for each of these requests*

ODBC: driver manager

2. driver manager = intermediary bet app and DBMS drivers - when application requests connection the driver, #determines type of DBMS that processes the given data source and loads the appropriate driver to memory #

ODBC: the driver

3. driver = processes the requests - submits the spec SQL statements (diff driver for each data source type) - converts Data source error codes and messags to ODBC standard codes and messages

IIS

= IIS = internet information services = secure, easy to manage modular and extensible platform for reliably hosting websites, webservices and applications

AMP, LAMP, WAMP

AMP refers to the Software Stack that creates the platform containing the Apache Web Server, the MySQL DBMS, and the PHP or Pearl programming language. LAMP is AMP that creates the platform for running on the Linux Operating System. WAMP is AMP that creates the platform for running running on the Windows Operating System