|
Database management systems are the electronic filing cabinets that help individuals
and organizations to manage the mass of information they process each day. With a
well-designed database, information can be easily stored, updated, accessed, and collated.
For example, a freight company can use a database to record data associated with
each shipment, such as the sender and recipient, origin and destination, dispatch and
delivery time, current location, and shipping fee. Some of this information needs to be
updated as the shipment progresses. The current status of a shipment can be read off
the database at any time, and data on all shipments can also be summarized into regular
reports.
The Web has inspired a new generation of database use. It’s now very easy to develop
and publish multi-user applications that don’t require any custom software to be installed
on each user’s computer. Adding a database to a web application allows information
to be automatically collected and used. For example, a customer can visit an
online shopping site, see what’s in stock, place an order, submit payment information,
and track the order until the goods are delivered. He can also place advance orders for
goods that aren’t available, and submit reviews and participate in discussions on items
he has purchased. If all goes well, the site’s staff doesn’t need to intervene in any of
these actions; the less staff intervention required during normal operation, the more
scalable the application is to large numbers of users. The staff are then free to do more
productive tasks, such as monitoring sales and stock in real time, and designing special
promotions based on product sales.
Both authors of this book have always been interested in using computers as a tool to
make things faster, more efficient, and more effective. Over the past few years we’ve
repeatedly found that the MySQL database management system—and the PHP and
Perl programming languages—provide a perfect platform for serious applications such
as managing research records and marking student assignments, and not-so-serious
ones like running the office sweepstakes. On the way, we’ve learned a lot of lessons
that we’d like to pass on; this book contains the tips that we think most readers will
find useful on a daily basis.
|
|