Thread Rating:
  • 21 Vote(s) - 2.62 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Management System (DBMS)
#1
Database Management System (DBMS)

[27435]

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:
Banking: all transactions
Airlines: reservations, schedules
Universities: registration, grades
Sales: customers, products, purchases
Online retailers: order tracking, customized recommendations
Manufacturing: production, inventory, orders, supply chain
Human resources: employee records, salaries, tax deductions
Databases touch all aspects of our lives


Purpose of Database Systems

In the early days, database applications were built directly on top of file systems
Drawbacks of using file systems to store data:
Data redundancy and inconsistency
Multiple file formats, duplication of information in different files
Difficulty in accessing data
Need to write a new program to carry out each new task
Data isolation — multiple files and formats
Integrity problems
Integrity constraints (e.g. account balance > 0) become “buried” in program code rather than being stated explicitly
Hard to add new constraints or change existing ones


Instances and Schemas


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 customers and accounts and the relationship 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 parts do not seriously influence others.


Data Manipulation Language (DML)


Language for accessing and manipulating the data organized by the appropriate data model
DML also known as query language
Two classes of languages
Procedural – user specifies what data is required and how to get those data
Declarative (nonprocedural) – user specifies what data is required without specifying how to get those data
SQL is the most widely used query language


Reply
#2
DATABASE MANAGEMENT SYSTEMS


[38262]

History

IBM Sequel language developed as part of System R projects at the IBM San Jose Research Laboratory
Renamed Structured Query Language (SQL)
ANSI and ISO standard SQL:
SQL-86
SQL-89
SQL-92
SQL:1999 (language name became Y2K compliant!)
SQL:2003
Commercial systems offer most, if not all, SQL-92 features, plus varying feature sets from later standards and special proprietary features.
Not all examples here may work on your particular system.

Data Definition Language

The schema for each relation, including attribute types.
Integrity constraints
Authorization information for each relation.
Non-standard SQL extensions also allow specification of
The set of indices to be maintained for each relations.
The physical storage structure of each relation on disk.

Domain Types in SQL

char(n). Fixed length character string, with user-specified length n.
varchar(n). Variable length character strings, with user-specified maximum length n.
int. Integer (a finite subset of the integers that is machine-dependent).
smallint. Small integer (a machine-dependent subset of the integer domain type).
numeric(p,d). Fixed point number, with user-specified precision of p digits, with n digits to the right of decimal point.
real, double precision. Floating point and double-precision floating point numbers, with machine-dependent precision.
float(n). Floating point number, with user-specified precision of at least n digits.
More are covered in Chapter 4.

Tuple Variables

Tuple variables are defined in the from clause via the use of the as clause.
Find the customer names and their loan numbers and amount for all customers having a loan at some branch.

Conceptual Evaluation Strategy

Semantics of an SQL query defined in terms of the following conceptual evaluation strategy:
Compute the cross-product of relation-list.
Discard resulting tuples if they fail qualifications.
Delete attributes that are not in target-list.
If DISTINCT is specified, eliminate duplicate rows.
This strategy is probably the least efficient way to compute a query! An optimizer will find more efficient strategies to compute the same answers.
Reply

Search Cloud: latest seminar topics on database management, seminar topic database management with sensor pdf file, seminar on data redundancy in dbms, seminar topics for database management system, seminar on overall structure of dbms, management system seminar topics, seminar topic on dbms, dbms seminar, pdf file for seminar topics on database management system, seminar topics in database management system, seminar topics on database management system, database research topics schemas types, database seminar topics, pharmacy dbms project chapter 4, presentation topics for dbms, data replication in dbms seminar topic, dbms topics for seminar presentation, seminar topics database management system, seminar topics on dbms, technical seminar topics names m tech cse data base management system,

[-]
Quick Reply
Message
Type your reply to this message here.

Image Verification
Please enter the text contained within the image into the text box below it. This process is used to prevent automated spam bots.
Image Verification
(case insensitive)

Possibly Related Threads...
Thread Author Replies Views Last Post
  Medical shop Management system academic expert 8 27,903 16-09-2014, 11:23 PM
Last Post: askguru100
  EXAMINATION MANAGEMENT SYSTEM academic expert 8 8,790 09-02-2014, 08:48 AM
Last Post: ravindrakedar22@gmail.com
  distributed database full report best project report maker 7 5,136 13-09-2013, 10:11 AM
Last Post: report maker
  TELEPHONE DIRECTORY MANAGEMENT project ideas 2 798 21-08-2013, 11:20 AM
Last Post: report maker
  Automated Examination Management System for Community Colleges ppt project source code cheker 2 1,256 12-03-2013, 09:39 PM
Last Post: Guest
  Transaction Management PPT engineering project helper 1 481 29-01-2013, 04:53 PM
Last Post: engineering project helper
  Principles of Distributed Database Systems project helper 0 396 25-01-2013, 02:48 PM
Last Post: project helper
  REAL ESTATE MANAGEMENT SYSTEM project source code cheker 1 1,103 25-01-2013, 09:57 AM
Last Post: project helper
  MULTINATIONAL MANAGEMENT IN A CHANGING WORLD engineering project helper 0 376 24-01-2013, 03:34 PM
Last Post: engineering project helper
  INTRODUCTION, DATABASE CONCEPTS AND ARCHITECTURE engineering project helper 0 381 23-01-2013, 10:19 AM
Last Post: engineering project helper



Users browsing this thread: 1 Guest(s)