XML (Extensible Markup Language)

• Definite by the WWW Consortium (W3C)
• Initially intended as a document markup language not a database language
• The ability to denote new tags and to produce nested tag structures made XML a immense way to switch data, not just documents
• XML has grown to be the basis for all innovative generation data interchange formats.
• A wide diversity of tools is existing for parsing, browsing and querying XML documents/data

Database Administrator

Synchronize all the actions of the database system; the database administrator has a superior considerate of the enterprise’s information resources and requirements.

Database administrator's responsibilities include:-

1. Schema definition
2. Storage structure and admittance method explanation
3. Schema and physical organization alteration
4. Yielding user authority to admittance the database
5. Denote integrity constraints
6. Acting as liaison with users
7. Watch out performance and responding to alter in requirements

Database Users

Users are distinguished by the way they expect to interrelate with the system.

• Application programmers – interrelate with system all the way through DML calls
• Sophisticated users – form requests in a database query language
• Specialized users – write dedicated database applications that do not fit into the traditional data processing framework
• Naive users – appeal to one of the permanent application programs that have been written formerly

Examples, people accessing database in excess of the web, bank tellers, clerical staff

Database Architecture

The architecture of database systems is greatly prejudiced by the underlying computer system on which the database is running:

• Centralized
• Client-Server
• Parallel (Multiprocessor)
• Distributed

Transaction Management

A Transaction is a compilation of operations that carry out a single logical function in a database application.

Transaction management part ensures that the database remains in a consistent (correct) state even with system failure (e.g., power failures and operating system crashes) and transaction failures.

Concurrency control manager controls the interface between the concurrent transactions, to make certain the consistency of the database.

Database Design

The process of designing the general structure of the database:-

Logical Design – decide on the database schema. Database design necessitates that we find a “good” assortment of relation schemas.

Business decision – What attributes should we evidence in the database?

Computer Science decision – What relation schemas should we have and how should the attributes be disseminated between the various relation schemas?

Physical Design – Deciding on the physical layout of the database

Structured Query Language (SQL)

SQL: Extensively used non­procedural language

Example: Find the name of the customer with customer­id 192­83­7465

Select customer.customer_name

from customer

where customer.customer_id = ‘192­83­7465’

Example: Find the balances of all accounts detained by the customer with

customer­id 192­83­7465

Select account.balance

From depositor, account

where depositor.customer_id = ‘192­83­7465’ and

depositor.account_number = account.account_number

Application programs commonly access databases through one of:-

• Language extension to consent to embedded SQL
• Application program interface (e.g., ODBC/JDBC) which permit SQL
• Queries to be sent to a database

Data Definition Language (DDL)

• Specification notation for significant the database schema

Example: create table account (

Account number char (10),

Balance integer)

DDL compiler produces a set of tables stored in a data dictionary.

1. Data dictionary contains metadata (i.e., data about data)
2. Database schema
3. Data storage and definition language
4. Specifies the storage structure and admittance methods used

Integrity constraints

Domain constraints

Referential integrity (references constraint in SQL)

Assertions

Authorization

Data Manipulation Language (DML)

• Data Manipulation Language is a language for accessing and manipulate the data organized by the apposite data model.
• DML also known as query language.

Two classes of languages:-

1. Procedural – user specify what data is required and how to get those data
2. Declarative (nonprocedural) – user specifies what data is required without specify how to get those data

SQL is the most broadly used query languages

Data Models?

Data Model  is a collection of tools for describing:-

1. Data
2. Data relationships
3. Data semantics
4. Data constraints 

• Relational model
• Entity Relationship data model (generally for database design)
• Object based data models (Object-oriented and Object relational)
• Semi structured data model (XML) 

Other older models:-

• Network model
• Hierarchical model

Instance and Schema:-

Similar to types and variables in programming languages:-

Schema:– The logical structure of the database

Example: The database consists of information about a set of clientele and accounts and the connection between them)

Analogous to type information of a variable in a program.

Physical schema: Database design at the physical level

Logical schema: Database design at the logical level

Instance:- The actual content of the database at a particular point in time

Analogous to the value of a variable.

Physical Data Independence:– the ability to modify the physical schema without Changing the logical schema

Applications depend on the logical schema

In general, the interfaces between the various levels and components should be well defined so that changes in some part do not seriously influence others.

Levels of Abstraction:-

Physical level: Describes how a record (e.g., customer) is stored.

Logical level: describes data stored in database, and the relations among the data.

type customer = record

customer_id : string;

customer_name : string;

customer_street : string;

customer_city : integer;

end;

View level: application programs hide details of data types. Views can also hide information (such as an employee’s salary) for security Purposes

Purpose of Database Systems:-

Drawbacks of using file systems (cont.)

1) Atomicity of updates

• Failures may leave database in an inconsistent state with part
• Updates carried out

Example: Transfer of funds from one account to another should

either complete or not happen at all

2) Concurrent access by multiple users

• Concurrent accessed required for presentation
• Uncontrolled concurrent accesses can lead to inconsistency

Example: Two people reading a balance and updating it at the Similar time

3) Security problems

Hard to provide user access to some, but not all, data

Database systems offer solutions to the entire above problem

What is DBMS?

• DBMS contains information about a particular enterprise
• Collection of interrelated data
• Set of programs to access the data
• An environment that is both convenient and efficient to use

Database Applications:-

1. Banking: all transactions
2. Airlines: reservations, schedules
3. Universities: registration, grade
4. Sales: customers, products, purchases
5. Online retailers: order tracking, customized recommendation
6. Manufacturing: production, inventory, orders, supply chain
7. Human resources: employee records, salaries, tax deductions
8. Databases touch all aspects of our live