Transcription

1 Databases Databases Data model Data access Advantages and disadvantages of DBMS Unit 1 Introduction DB M BG2 Information is recorded and exchanged in different forms D B M G4 Information is recorded and exchanged in different forms Forms of information organization and codification have been introduced over time D M B BNCLCU79M44A488D G5 Computer systems In computer systems information is represented by means of data the data are rough symbols which have to be interpreted and correlated to provide information example data: Mario Rossi and information: result of looking up a telephone number in your personal telephone directory (e.g., list of contacts) DB M BG Politecnico di Torino 1

2 Data characteristics Data are far more stable over time than the processes that manage them Example there have been no variations in the structure of bank applications data for decades the procedures that manage the data vary from year to year Data are an important resource of the organization that manages them DB M BG7 Databases Database (General definition) a database is a collection of data that represents information interesting for a computer system ( Technical definition) a database is a collection of data managed by a DBMS Data Base Management System - DBMS A DBMS (DataBase Management System) is a software system able to manage collections of data that are large shared persistent ensuring their reliability and privacy DB M BG9 DB M BG10 DBMS characteristics Far greater dimensions than the main memory available data management in secondary memory Data sharing between applications and users: a database is an integrated resource, shared by several company sectors reduction of data redundancy reduction of data inconsistency competing access control mechanism DBMS characteristics Data persistence lifetime not limited to execution of programmes that use them Data reliability in the case of hardware and software malfunction/failure backup and recovery functionality Data privacy authorization mechanisms to enable users DB M BG11 DB M BG Politecnico di Torino 2

4 Other data models Before the relational model, other models closer to the physical (not very abstract) structures of storing were used hierarchical model network model Since the relational model Object model XML Schema and instances Defined in the database are the schema, which describes the structure of the data. The schema is practically unvarying over time is represented by the heading of each table (table name and column names) Example schema of the database Courses Code Name TeacherID Teacher ID Name Department Phone# DB M BG19 DB M BG20 Schema and instances Defined in a database are the instance, composed of the content of each table, i.e. of the data effective values which are variable over time, also very rapidly represented by the rows in the tables Example instance of the Teacher table D101 Green Computer Engeneering D102 White Telecommunications D321 Black Computer Engeneering D B M G21 Model types Conceptual model It is possible to represent data independently from the logical describes real world concepts used in the designing phase example: entity-relationship model Logical model Describes the data structure in the DBMS used by the programmes accessing the data independent from the physical structures DB M B Example: relational model G22 Abstraction levels in a DBMS Standard three-level ANSI/SPARC architecture for DBMS Logical schema Internal schema Logical schema description of the database using the logical model of the DBMS Internal schema representation of the logical schema using physical storing structures description of parts of the database, called views, which reflect the point of view of particular users defined on the logical model DB M BG23 BD DB M BG Politecnico di Torino 4

5 guarantees that users and application programmes which utilize a database can ignore the designing details used in the construction of the database It is a consequence of the subdivision into levels of abstraction DB M BG26 Physical independence enables interaction with the DBMS independently from the physical structure of the data access to a (logical or external level) relationship always takes place in the same way, independently from the means of memorization it is possible to change the way the data is physically memorized without affecting the programmes utilizing the data Logical independence enables interaction with the external level independently from the logical level it is possible to change the logical level maintaining the external structures unaltered (as long as the correspondences are unaltered) it is possible to add new views or alter existing views without changing the logical schema DB M BG27 DB M BG28 Data access languages Data access User-friendly interfaces that enable specific queries without using a textual language Interactive languages (SQL) Commands similar to interactive commands introduced into traditional programming languages (C, C++, COBOL, Java, ), so-called host languages Commands similar to interactive commands introduced into ad hoc development languages, often with specific functionalities (generation of graphics, complex prints, screens) DB M BG Politecnico di Torino 5

6 Data access languages SQL language is divided into two categories Data Definition Languages (DDL) used to define the logical, external and physical schemas, and access authorizations Data Manipulation Languages (DML) used for querying and updating database instances Database administrator: in charge of (centralized) control and management of the database guarantees sufficient performance ensures system reliability manages authorizations and access to data DB M BG31 DB M BG32 Designers and programmers: they define and realize the structure of the database the programmes accessing the database : utilize the database for their activities end users: they use transactions, i.e. programmes that carry out predefined activities casual users: they formulate queries (or updates) which are not predefined by the interactive access languages of the database DB M BG33 Transactions Programmes that carry out frequent predefined activities Examples flight bookings bank transfers Generally realized by introducing SQL into a host language DB M BG34 DBMS advantages Data as a common resource of the whole organization reduction of redundancies and inconsistencies Unified and precise data model of facts of interest to the organization Possible centralized control of data standardization, economies of scale Advantages and disadvantages of DBMS DB M BG Politecnico di Torino 6

7 DBMS disadvantages These are expensive, complex products that require direct investment purchase of the product indirect investments purchase of the necessary hardware and software resources conversion of the applications training of personnel They provide a set of services in an integrated form it is not possible to separate out unused services DB M BG that cause a reduction in performance G Politecnico di Torino 7

UNIT-1 Ques 1. Define dbms and file management system? Ans- Database management system (DBMS) is a collection of interrelated data and a set of programs to access those data. Some of the very well known

COMP 378 Database Systems Notes for Chapter 1 of Database System Concepts Introduction A database management system (DBMS) is a collection of data and an integrated set of programs that access that data.

COMPONENTS in a database environment DATA data is integrated and shared by many users. a database is a representation of a collection of related data. underlying principles: hierarchical, network, relational

Introduction to Database Systems A database is a collection of related data. It is a collection of information that exists over a long period of time, often many years. The common use of the term database

COSC 304 Introduction to Systems Introduction Dr. Ramon Lawrence University of British Columbia Okanagan ramon.lawrence@ubc.ca What is a database? A database is a collection of logically related data for

Core Syllabus B BUILD KNOWLEDGE AREA: DEVELOPMENT AND IMPLEMENTATION OF INFORMATION SYSTEMS Version 2.6 June 2006 EUCIP CORE Version 2.6 Syllabus. The following is the Syllabus for EUCIP CORE Version 2.6,

Chapter 7 Data Structures for Computer Graphics (This chapter was written for programmers - option in lecture course) Any computer model of an Object must comprise three different types of entities: 1.

Files What s it all about? Information being stored about anything important to the business/individual keeping the files. The simple concepts used in the operation of manual files are often a good guide

14 Databases 14.1 Source: Foundations of Computer Science Cengage Learning Objectives After studying this chapter, the student should be able to: Define a database and a database management system (DBMS)

Week 1 Part 1: An Introduction to Database Systems Databases and DBMSs Data Models and Data Independence Concurrency Control and Database Transactions Structure of a DBMS DBMS Languages Databases and DBMSs

CHAPTER 2 DATABASE MANAGEMENT SYSTEM AND SECURITY 2.1 Introduction In this chapter, I am going to introduce Database Management Systems (DBMS) and the Structured Query Language (SQL), its syntax and usage.

Database Systems I (Compulsory) INTRODUCTION This is one of the 4 modules designed for Semester 2 of Bachelor of Information Technology Degree program. CREDITS: 04 LEARNING OUTCOMES On completion of this

About the Presentations The presentations cover the objectives found in the opening of each chapter. All chapter objectives are listed in the beginning of each presentation. You may customize the presentations

Databases What the Specification Says Describe flat files and relational databases, explaining the differences between them; Design a simple relational database to the third normal form (3NF), using entityrelationship

Chapter 2 Data Model Database Systems: Design, Implementation, and Management, Sixth Edition, Rob and Coronel 1 In this chapter, you will learn: Why data models are important About the basic data-modeling

Oracle University Contact Us: 1.800.529.0165 Oracle Database 10g: Introduction to SQL Duration: 5 Days What you will learn This course offers students an introduction to Oracle Database 10g database technology.

Chapter 6 FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT Learning Objectives Describe how the problems of managing data resources in a traditional file environment are solved

Definition Database Administrator [DBA] Centralized control of the database is exerted by a person or group of persons under the supervision of a highlevel administrator. This person or group is referred

Chapter 1 Objectives: to learn The difference between data and information What a database is, the various types of databases, and why they are valuable assets for decision making The importance of database

1 Database Systems Alice: Vittorio: Sergio: Riccardo: I thought this was a theory book. Yes, but good theory needs the big picture. Besides, what will you tell your grandfather when he asks what you study?

2 chapter Database System Concepts and Architecture The architecture of DBMS packages has evolved from the early monolithic systems, where the whole DBMS software package was one tightly integrated system,

(PGDIT 01) Paper - I : BASICS OF INFORMATION TECHNOLOGY 1) What is an information technology? Why you need to know about IT. 2) What is the structure of an organization? Explain how IT support at different

Database as a Service (DaaS) Version 1.02 Table of Contents Database as a Service (DaaS) Overview... 4 Database as a Service (DaaS) Benefit... 4 Feature Description... 4 Database Types / Supported Versions...