Objectives of Todays
Access and combine data from a variety of data
Perform complex data analysis across these date
Create multidimensional views of data and its
Easily summarize and rol
CHAPTER 5 TRANSACTION MANAGEMENT
A transaction is a series of actions carried out by a single user or application program,
which must be treated as a single logical unit of work (i.e. its a unit program execution
that accesses and possibly updates various
Transactions Management deals with the problem of
always keeping the database in a consistent state even
when concurrent accesses and failures occur
The database c
Describe types various of database security features
provided by DBMS
Database security can be defined as the
protection of the database against
What to Cover
Motivation: Why data mining?
What is data mining?
Data Mining: On what kind of data?
Data mining functionality
Are all the patterns interesting?
Classification of data mining systems
Major issues in data mining
Mini Lecture - Session 7
Selecting Data From A Table
The select statement is used to query the
database and retrieve selected data that
match the criteria that you specify.
Here is the format of a simple select
select "column1" [,"
Multiple Tables - Joins
Sometimes we have to select data from two or more
tables to make our result complete. We have to
perform a join.
Tables in a database can be related to each other
with keys. A primary key is a column with a unique
Mini Lecture- Session 10
A stored procedure is a group of Transact-SQL
statements compiled into a single execution plan.
Stored procedures assist in achieving a consistent
implementation of logic across a
Database Recovery is the process of restoring
the database to a correct state in the event of
Causes of Failures
Transaction-Local - The failure of an individual
transaction can be caused in several ways:
The sample database Northwind has
some views installed by default. The
view "Current Product List" lists all active
products (products that are not
discontinued) from the Products table.
1. Create the SQL statement that gives the
Consider the following (part of a) report:
Quant Methods 00002
CHAPTER 3: CONCEPTUAL DATA MODEL
3.1 Type of data models hierarchical, network and relational
A Data Model is a set of concepts to describe the structure of a database, the operations
for manipulating these structures, and certain constraints that the da