1 / 17

Comprehensive Guide to Data Management and Database Systems

This guide delves into essential concepts of data management and databases, covering file processing problems, selection criteria, the hierarchy of data elements (bit, byte, field, record, file, database), and the organization of data access methods. It explores various database types, structures, and models, including relational and object-oriented databases, as well as the significance of normalization. Key topics include data definition languages, database creation, and conceptual design through ER diagrams. The guide also addresses practical questions on database effectiveness and normalization importance.

margie
Télécharger la présentation

Comprehensive Guide to Data Management and Database Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Technology Guide 3 Data & Database

  2. Agenda • Definition • File processing problems • Database • Selection criteria

  3. Definition • Element • Bit, byte, field, record, file, database • Entity, attribute, key field • Organization & access method • Sequential file • Indexed sequential file • Direct or random file

  4. Agenda • Definition • File processing problems • Database • Selection criteria

  5. File Processing Problems • Redundancy • Inconsistency • Isolation • Security • Integrity • Data/program independence

  6. Agenda • Definition • File processing problems • Database • Selection criteria

  7. Database • Types • Structure • Models • Creation • Topology

  8. Database Types • Business database • Geographical information database • Knowledge database / deductive database • Multimedia database • Data warehouse • Data marts • Multimedia and hypermedia database • Object-oriented database

  9. Database Structure • Data definition language • Schema & subschema • Data Manipulation language • Structured Query Language (SQL) • Query By Example (QBE) • Data dictionary

  10. Database Models • Hierarchical • One to many • Usage • Network • Many to many • Usage • Relational • Normalization • Usage • Object-oriented • Usage

  11. Database Creation • Conceptual design • Logical view • Entity-relationship (ER) diagram • Entity, entity classes, instance, attributes, identifier • Relationships, binary relationships • Normalization

  12. Database Creation • Physical design • Physical view • Data topology (organization) • Centralized • Distributed database • Replicated database • Partitioned • Access method • Security

  13. Agenda • Definition • File processing problems • Database • Selection criteria

  14. Selection Criteria • User’ needs (type of application) • Compatibility • Portability • Reliability • Cost • Feature • Performance • Vendor’s support • Others?

  15. Points to Remember • Definition • File processing problems • Database • Selection criteria

  16. Discussion Question • How can a database help an organization? • Why normalization is very important for building a database? • What kind of database model(s) is most suitable for E-bay? • Do you see any problem(s) of the database in your organization?

  17. Assignment • Review technology guides 1-3 • Read technology guide 4, chapter 1 • Group Assignment • Research paper

More Related