Chapter 7 - Database Management

XML Introduction

Database processing and document processing need each other

XML Web services

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

ADO.NET

an improved version of ADO was developed as part of Microsoft's .NET initiative

SQL injection attacks

are attempts to issue SQL commands through a web interface such as a web form

OLE DB was created

by Microsoft in the mid 1990s: - object oriented interface - encapsulated data-server functionality - designed not just for access to relational database, but also for accessing many other types of data as well - readily accessible to programming languages, such a C, C#, and Java - not as accessible to Visual Basic and scripting languages

data source name (DSN)

each data source is given one and it is used to reference the data source

LAMP

is AMP running on the Linux operating system

WAMP

is AMP running on the Windows operating system

file data source

is a file that can be shared among database users - the only requirement is that the users have the same DBMS driver and privilege to access the database

Trigger

is a program attached to a specific table or view within a database and executed by the DBMS when specific events occur using that table or view

ODBC data source

is an ODBC data structure that identifies a database and the DBMS that processes it

user data source

is available only to the user who created it

system data source

is one that is local to a single computer - the operating system and any user on that system (with proper permission) can use a system data source

Stored Procedure

is similar to a computer program function and provides a reusable, single-purpose shortcut to completing some task: it is stored in the database itself

data source

is the database, its associated DBMS, operating system, and network platform

application program

issues requests: - to create a connection with a data source - to issue SQL statements and receive results - to process errors - to start, commit, and roll back transactions

Document processing

needs database processing for storing and manipulating data

Database Processing

needs document processing for expressing database views

XML (extensible markup language)

provides a standardized yet customizable way to describe the content of documents: - used as a standardized means to define and communicate documents for processing over the internet

AMP

refers to a combination of the Apache Web server, the MySQL DBMS, and the PHP or Pearl programming language

Open Database Connectivity (ODBC)

standard was developed in the early 1990s: - provides a DBMS-independent means for processing relational database data

Application Programming Interface (API)

- is a 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

ODBC driver

- processes ODBC requests - submits specific SQL statements to a given type of data source: there is a different driver for each data source type it is the responsibility of the driver to ensure that standard ODBC commands execute correctly - converts data source error codes and messages into the ODBC standard codes and messages

ODBC

- provides a standard means for each of these requests - defines a standard set of error codes and messages

ODBC driver manager

- serves as an intermediary between the application and DBMS drivers - when the application requests a connection, the driver: determines the types of DBMS that processes a given ODBC data source loads the appropriate driver into memory (if it is not already loaded)

Active Data Objects (ADO)

- set of objects for utilizing OLE DB - designed for use by any language, including VB, VBScript, and Jscript