1 / 32

Technology Briefing

3. Technology Briefing. Database Management. “Modern organizations are said to be drowning in data but starving for information” p. 509. Learning Objectives. Learning Objectives. Database Management for Strategic Advantage. Database technology is vital to an organization’s success

mrios
Download Presentation

Technology Briefing

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. 3 Technology Briefing Database Management “Modern organizations are said to be drowning in data but starving for information” p. 509 Information Systems Today: Managing in the Digital World

  2. Learning Objectives Information Systems Today: Managing in the Digital World

  3. Learning Objectives Information Systems Today: Managing in the Digital World

  4. Database Management for Strategic Advantage • Database technology is vital to an organization’s success • Variety of information collected and stored • Stock prices • Potential customers • Credit ratings of wholesalers • Etc. Information Systems Today: Managing in the Digital World

  5. Database Management for Strategic Advantage (II) • Database technology used for: • Gathering and storing customer information • Custom-tailoring catalogs and mailings • Fueling electronic commerce • Etc. Information Systems Today: Managing in the Digital World

  6. Learning Objectives Information Systems Today: Managing in the Digital World

  7. Database Foundations • Then: • Card catalogs • File cabinets • Now: • DBMS • Create • Store • Organize • Retrieve data • E.g., Microsoft Access Information Systems Today: Managing in the Digital World

  8. Database • Database • Collection of related data organized in a way to facilitate searches • Entities • Something you collect data about • E.g.: people, books Information Systems Today: Managing in the Digital World

  9. Record • Contains data about a single entity • Similar to catalog card Information Systems Today: Managing in the Digital World

  10. Attributes • Specific characteristic describing the entities • E.g.: name and social security number are attributes of a person Information Systems Today: Managing in the Digital World

  11. Example: Entity Student • Entity represented as a table, with rows as records and columns as attributes Information Systems Today: Managing in the Digital World

  12. Advantages of the Database Approach • Program-data independence • Minimal data redundancy • Improved data consistency • Improved data sharing • Increased productivity of application development Information Systems Today: Managing in the Digital World

  13. Advantages of the Database Approach (II) • Enforcement of standards • Improved data quality • Improved data accessibility • Reduced program maintenance Information Systems Today: Managing in the Digital World

  14. Cost and Risks of the Database Approach • New, specialized personnel • Installation and management cost and complexity • Conversion costs • Need for explicit backup and recovery • Organizational conflict Information Systems Today: Managing in the Digital World

  15. Effective Management of Databases • Database Administrator (DBA) • Responsible for development and management of databases • Works with system analysts and programmers • Works with users and managers • Implements security features • Grants access rights • One of the key actors in creating a successful database Information Systems Today: Managing in the Digital World

  16. Entering Data • Forms • Enter data about a record • Field in a form corresponds to attribute in a record • Used to add, modify, or delete data Information Systems Today: Managing in the Digital World

  17. Example: Computer-Based Form Information Systems Today: Managing in the Digital World

  18. Querying Data • Query: used to retrieve information • Structured Query Language (SQL) • Example: Display students who earned an “A” • Writing SQL queries can become very complex Information Systems Today: Managing in the Digital World

  19. Query by Example • Simpler than SQL • Drag-and- drop features • Construct a sample of the data we would like to see Information Systems Today: Managing in the Digital World

  20. Creating Database Reports • Report • Compilation of data from the database • Report generators • Retrieve, manipulate, and display data • Example • Quarterly sales for a restaurant • Adding • Grouping Information Systems Today: Managing in the Digital World

  21. Database Design • Data need to be organized for retrieval and analysis • Key elements of a database • Data • Structure • Data model • A map or a diagram representing entities and their relationships Information Systems Today: Managing in the Digital World

  22. Example: Entities and Their Attributes Information Systems Today: Managing in the Digital World

  23. Identifying Records • Uniquely identifying records: • Primary Key • Unique identifier • E.g.: Student ID number, social security number • Combination primary key • Combination of two or more attributes • E.g.: identifying a student’s grade for a particular class for a particular term • Identifying records that share a common value • Secondary Key • Attribute not used as a primary key • E.g., Major Information Systems Today: Managing in the Digital World

  24. Associations • Used to relate information between tables • Needed to retrieve information • Example: Basketball league database Information Systems Today: Managing in the Digital World

  25. Example: Basketball League • Each table contains important data • No way to learn which team plays in a specific stadium • Need to make associations Information Systems Today: Managing in the Digital World

  26. Example: Basketball League • Foreign keys • Attributes used to link tables • Primary key in one table, foreign key in another • Need to create additional entity for many-to-many relationships Information Systems Today: Managing in the Digital World

  27. Entity-Relationship Diagram • Used to show associations between entities • Important when designing complex databases • Entities: represented by boxes • Relationships: represented by lines Associations Information Systems Today: Managing in the Digital World

  28. The Relational Model • Primary DBMS approach (RDBMS) • 3 dimensions • Entities represented as 2-dimensional tables • Rows = records • Columns = attributes • Tables joined based on common columns(3rd dimension) • Good design eliminates redundancy Information Systems Today: Managing in the Digital World

  29. Data Redundancy • Problematic if an attribute has to be changed • Need to change in multiple locations • E.g., instructor’s phone number Information Systems Today: Managing in the Digital World

  30. Normalization • Eliminate unnecessary redundancy • Create separate tables • Data only needs to be changed in a single location Information Systems Today: Managing in the Digital World

  31. Data Dictionary • Document that specifies what data needs to be entered • Attribute name • Key or not • Data type • Valid values • Can be used to enforce business rules Information Systems Today: Managing in the Digital World

  32. Linking Website Applications to Organizational Databases • Users can access a variety of data via a company’s web site • Web services help in integration of databases, regardless of physical location • Need for adequate systems performance • Get understanding of customer behavior Information Systems Today: Managing in the Digital World

More Related