08-17-2009Web siteAssessment:File-Based SystemsFile-Based Systems - DisadvantageFile-Based Systems: exampleDatabase SystemsAdvantages of Database SystemsCosts and Risks of the DatabasesEvolution of databasesOO versus RelationalORDB vs. ORDBMSRoles in a DB Environment3-Level ArchitectureSlide 153 Level Arch. - ExampleDatabase LanguagesFile-ServerFile Server ArchitectureDB ServerPopular DBMSEnd of LectureCS 8630 Database Administration, Dr. Guimaraes08-17-2009ClassWill Start Momentarily…CS8630 Database AdministrationDr. Mario GuimaraesIntroduction and Database EnvironmentCS 8630 Database Administration, Dr. GuimaraesWeb site•Class web-site – `http://science.kennesaw.edu/~mguimara/cs8630.htmSyllabus, Hw, project, etc. (use csmoodle for all hw)Hw. # 0a) Post a message in the Introduction Forum at csmoodle.kennesaw.edub) Download Oracle 10g Express and launch it get disk or see instructions from site Oracle 10g Express: download/Install, Launch or come by with your laptop Hw # 1 - Introduction & Relational Algebra Extra credit homework - evaluate Database CoursewareDO NOT start before Friday. I will give further instructionsADbC (adbc.kennesaw.edu)SQL (w3schools) 8888 SQL Tutorial (new lin) !CS 8630 Database Administration, Dr. GuimaraesAssessment:•Homework (10%) Homework problems assigned throughout the term. Homework grade will be binary: 5 (completed the assignment with 100% effort), 2 (partially completed), 0 (incomplete). Homework can be discussed with your colleagues, but should be turned in individually. Concepts of homework will frequently appear on the tests. No homework may be turned in after the solutions are posted.•Class Participation (10%)This is a subjective component. It includes participation in labs, in class and in discussion groups. Exams (30 %)2 exams, 15 points each. •Paper (25%) You will submit an Abstract and a list of references by October 1. Full paper is due November 1 Project (25%)88Your project grade will be composed of 1) Final Deliverables 15%, 2) Intermediate Deliverables 5%, 3) Oral Presentation graded by class, 5%CS 8630 Database Administration, Dr. GuimaraesFile-Based SystemsThree file processing systems (Ch.1)CS 8630 Database Administration, Dr. GuimaraesFile-Based Systems - Disadvantage Disadvantages of File Processing Systems•Data dependence–File structure is defined in the program code.•Incompatible file formats–Programs are written in different languages, and so cannot easily access each other’s files.•Fixed Queries/Proliferation of application programs–Programs are written to satisfy particular functions.–Any new requirement needs a new program.•Data Redundancy•Separation and isolation of data–Each program maintains its own set of data.–Users of one program may be unaware of potentially useful data held by other programsCS 8630 Database Administration, Dr. GuimaraesFile-Based Systems: exampleCS 8630 Database Administration, Dr. GuimaraesDatabase SystemsCS 8630 Database Administration, Dr. GuimaraesAdvantages of Database SystemsDBMS: software that administers one or more Databases. Facilitates implementation of:•Data Independence/Reduced Maintenance•Improved Data Sharing •Increased Application Development Productivity•Enforcement of Standards•Improved Data Quality (Constraints)•Better Data Accessibility/ Responsiveness•Security, Backup/Recovery, Concurrency•Reduce Redundancy, Reduce inconsistency•Increase Integrity•Use a high level query language•Views: each user views own sub-set of the databaseCS 8630 Database Administration, Dr. GuimaraesCosts and Risks of the Databases•New, Specialized Personnel•Installation Management Cost and Complexity•Conversion Costs•Need for Explicit Backup and Recovery•Organizational ConflictCS 8630 Database Administration, Dr. GuimaraesEvolution of databasesCS 8630 Database Administration, Dr. GuimaraesOO versus RelationalOO betterCOMPLEX DATA TYPES•Sub-types – Reusability•Multi-valued attributesMAPS better with OO Programming LanguageStandardEasy to UseMore people familiar withVendors did a better jobCS 8630 Database Administration, Dr. GuimaraesORDB vs. ORDBMS•Most Relational DBMS are also ORDBMS (to some extent).•Most DB are purely Relational (Not ORDB).CS 8630 Database Administration, Dr. GuimaraesRoles in a DB Environment•Data Administrator (DA)•Database Administrator (DBA)•Database Designers (Logical and Physical)•Application Programmers•End Users (naive and sophisticated)CS 8630 Database Administration, Dr. Guimaraes3-Level ArchitectureANSI-SPARC Three-Level Architecture (Ch.2)CS 8630 Database Administration, Dr. Guimaraes3-Level ArchitectureANSI-SPARC Three-Level Architecture•External Level–Users’ view of the database. –Describes that part of database that is relevant to a particular user.•Conceptual Level–Community view of the database. –Describes what data is stored in database and relationships among the data. •Internal Level–Physical representation of the database on the computer. –Describes how the data is stored in the database.CS 8630 Database Administration, Dr. Guimaraes3 Level Arch. - ExampleDifferences between Three Levels of ANSI-SPARC ArchitectureCS 8630 Database Administration, Dr. GuimaraesDatabase Languages•Fourth Generation Language (4GL)–Query Languages–Forms Generators–Report Generators–Graphics Generators–Application Generators.CS 8630 Database Administration, Dr. GuimaraesFile-Server•File-server is connected to several workstations across a network.•Database resides on file-server.•DBMS and applications run on each workstation.•Disadvantages include:–Significant network traffic.–Copy of DBMS on each workstation.–Concurrency, recovery and integrity control more complex.CS 8630 Database Administration, Dr. GuimaraesFile Server ArchitectureCS 8630 Database Administration, Dr. GuimaraesDB ServerDB server architecture (or Client Server)CS 8630 Database Administration, Dr. GuimaraesPopular DBMS•DBMS – software that manages database•Oracle •DB2 and Informix (IBM)•MS-SQL Server and MS-Access (Microsoft)•Sybase (also iAnywhere: mobile db solutions)•MySQL and POSTGRES (open source)•Filemaker PRO (apple, Ibm, web, 1 table)CS 8630 Database Administration, Dr. GuimaraesEnd of LectureEnd