עקרונות מערכות לניהול בסיס נתונים

  • Published on
    10-Jan-2016

  • View
    48

  • Download
    15

Embed Size (px)

DESCRIPTION

. . , , , : , , : , . . - PowerPoint PPT Presentation

Transcript

  • , , , : , , : ,

  • , . -

  • - File Management System : VSAM IBM

  • - File Management System ( , , )

  • - File Management System3 , -

  • - File Management System - : : -

  • : .

  • - -

  • RDBMS Relational Data Base Management System - 3 : (Data Definition) (Data Manipulation) (Data reliability)

  • Data Manipulation :

  • : :

  • Global Schema (Data Type) (Primary Key)

  • DDLData Definition Language : , , , (Triggers)

  • - (Sub Schema) / (View) (View) : , ,

  • Physical Schema : ( Hashing) (Block)

  • Data Dictionary : : ,

  • DML Data Manipulation Language SQL - : , , , Embedded SQL - SQL -

  • DML Data Manipulation Language - SQL CALL : Oracle : Cobol, Pascal, PL/1, Ada - API ( )

  • SQL

  • : * - SQL * - API : SQL Application Programming Interface - - CALL -

  • : * Sybase - SQL Server API * Informix Cobol, C, Ada

  • RDBMS

  • RDBMS

  • RDBMS SQL / DBMS

  • 3 - C, ADA, PASCAL, JAVA, COBOL PL/1 4 - MAGIC , DELPHI Insight, Visual Basic , Developer Oracle, Power Builder Sybase

  • 4 - -

  • /: Discoverer Oracle Business Objects Business Objects

  • WEB

  • - WEB (Browser) HTML WEB HTTP SQL SQL WEB HTML HTTP

  • Data Sharing - ( ) Data Integrity - , Data Availability - Standartization - .

  • (Flexibility to Changes) - (Data Security) - (Transaction Processing) - - (Concurrent Update) - - ( ).

  • - - , - , CPU, - - ,

  • 1. : - . - ? - , ? - RDBMS, . SQL - API?

    2. : - , . - . : .