Lec1- Introduction to Database – Part 2 (2).ppt - Chapter 1 Introduction Databases and Database Users Copyright © 2007 Ramez Elmasri and Shamkant B

Lec1- Introduction to Database – Part 2 (2).ppt - Chapter...

This preview shows page 1 - 10 out of 41 pages.

Introduction: Databases and Database Users Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Chapter 1
Image of page 1

Subscribe to view the full document.

Outline Slide 1- 2 Basic Definitions Typical DBMS Functionality Main Characteristics of the Database Approach Database Users Advantages of Using the Database Approach When Not to Use Databases
Image of page 2
Database Definition. Slide 1- 3 Database: is a collection of related data. Table (Student) ↓col1 ↓col2 ↓col3 ↓col4 ↓col5 ↓col6 Col name S-ID SName Nationa lity colleg e birth_dat e phone Col type numbe r char char char date numbe r row1 → 1 Lamar Yemen IT 1-7-2012 11111 1 row2 → 2 mohamme d KSA MIS 1-1-1985 22222 2 row3 → 3 Omran Jordan IT 1-1-1990 33333 3
Image of page 3

Subscribe to view the full document.

Remember Traditional database applications Store textual or numeric information Multimedia databases Store images, audio clips, and video streams digitally Geographic information systems (GIS) Store and analyze maps, weather data, and satellite images Data warehouses and online analytical processing (OLAP) systems Extract and analyze useful business information from very large databases Support decision making Real-time and active database technology Control industrial and manufacturing processes
Image of page 4
Basic Definitions Slide 1- 5 Database: A collection of related data. Data: Known facts that can be recorded and have an implicit meaning. Mini-world: Some part of the real world about which data is stored in a database. For example, student grades and transcripts at a university. Database Management System (DBMS): A software package/ system to facilitate the creation and maintenance of a computerized database. Database System: The DBMS software together with the data itself. Sometimes, the applications are also included.
Image of page 5

Subscribe to view the full document.

Simplified database system environment Slide 1- 6
Image of page 6
Why Use a DBMS? Slide 1- 7 • Data independence. • Efficient access. • Reduced application development time. • Uniform data administration. • Data integrity and security. • Concurrent access, recovery from crashes.
Image of page 7

Subscribe to view the full document.

Typical DBMS Functionality Slide 1- 8 Define a particular database in terms of its data types, structures, and constraints Construct or Load the initial database contents on a secondary storage medium Manipulating the database: Retrieval: Querying, generating reports Modification: Insertions, deletions and updates to its content Accessing the database through Web applications Processing and Sharing by a set of concurrent users and application programs – yet, keeping all data valid and consistent
Image of page 8
Main Characteristics of Database Approach Slide 1- 9 Self-describing nature of a database system: Self-describing nature of a database system: A DBMS catalog stores the description of a particular database (e.g. data structures, types, and constraints) The description is called meta-data .
Image of page 9

Subscribe to view the full document.

Image of page 10
  • Fall '19

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes