Data base System Concepts & Data Modeling - PowerPoint PPT Presentation

data base system concepts data modeling n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Data base System Concepts & Data Modeling PowerPoint Presentation
Download Presentation
Data base System Concepts & Data Modeling

Loading in 2 Seconds...

play fullscreen
1 / 26
Download Presentation
Data base System Concepts & Data Modeling
1 Views
Download Presentation

Data base System Concepts & Data Modeling

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Data base System Concepts & Data Modeling Chapter 1

  2. Data

  3. File Systems

  4. Data Base Management System • DBMS is a collection of interrelated data and set of programs to access those data.

  5. Various Data Base Mgt Systems

  6. Disadvantages of File Systems • Data Redundancy and Inconsistency • Data Isolation • Integrity Problems • No Transaction support • No data sharing • Security Problems

  7. Front End

  8. Back End

  9. Data Abstraction

  10. Data Abstraction(Physical Level)

  11. Data Abstraction(Logical Level)

  12. Data Abstraction(View Level)

  13. Instance • Data base changes over time as information is deleted and inserted.The collection of information stored in the database at a particular moment is called an Instance of Database. • Insert into student values(1,’misha’,99)

  14. Schema • The overall design of the database is called as the database schema.

  15. Schema

  16. Database Languages SQL DDL DML CREATE INSERT DELETE DROP ALTER UPDATE SELECT TRUNCATE RENAME

  17. Data Defination Language • Create Table • Alter Table • Truncate • Rename table • Drop table

  18. Data Manipulation Language • Insert • Select • Update • Delete

  19. DataBASE USER’S • Application Programmer’s

  20. Naïve User’s

  21. Sophisticated User’s

  22. Specialized User’s

  23. Functions of DBA • Schema Definition • Storage Structure and access method definition • Granting of Authorization for data access • Routine Maintenance. • Performance Tuning

  24. Two Tier Architecture

  25. Three Tier Architecture

  26. Non Client Server