• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Appendix C. Example Database Tables

Appendix C. Example Database Tables

The examples used throughout this book reference several database tables. The schemas and data for these tables are listed in this appendix. Because of its low cost, wide availability, and ease of use, all tables were designed using Microsoft Access. Because Access is a desktop database, I don't recommend using it in production environments, especially where many concurrent users are expected to use the database. Access isn't designed for heavy concurrent use and may experience scalability and performance issues if placed under load. Additionally, there are limits on the amount of data that can reliably be stored in an Access database.

For production applications, I recommend you use an enterprise-level database, such as MS SQL Server, Oracle, DB2, Informix, or Sybase. These databases provide advanced features and functionality, such as stored procedures and triggers, and are specially tuned for handling multiple concurrent requests and massive amounts of data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint