Database Examples

• You really should read this section of the book. (P6 - 8)
• A Personal Database
  • Single user
  • Perhaps 1-2 tables
  • Perhaps 2,000 rows.
  • There is little problem with duplicate data in such a database
  • There are few problems with inaccurate data in such a database
  • Access speed in not a problem.
  • There is no need for concurrency control in such a database.
  • The need for careful design and maintenance are reduced in such a database.
  • This is probably fine in a personal database system like Microsoft Access.
    • A Small business database
      • 10 to 15 users.
      • 100,000 rows
      • 10 to 15 tables.
      • Data duplication becomes an problem here.
      • Need for table locking at least, if not records
      • Speed and storage are probably not problems in this database.
      • This might be ok on a personal database system like Microsoft Access.
      • But probably not.
    • A customer database for a larger company
      • 500 users
      • 10 million rows.
      • around 50 tables.
      • A major DBMS system is required in this case.
      • record locking, concurrency, rollback
      • Extremely careful database design and implementation.
    • Then things get huge.
      • Amazon is reported to track every query and the environment
        • Like background colors
        • And other books suggested.
        • If it resulted in a sale or not.
      • It is reported that amazon has
        • 59 million customers
        • 250,000 full text books on line
        • User comments on products
        • ...
      • Google
        • It is reported that google tracks every search
        • There are around 91 million searches per day
    • Digital Dashboards
      • Datamining tools for executives
      • Allow access to a database for someone without database experience.
      • Frequently provide analysis tools
        • Sum, average, aggregate, correlation
        • Visualizations of various sorts.
    • You might find this article interesting.