You’ve just launched your brand new database-driven Web site. You celebrate this milestone by logging into your database and adding a new row to the “articles” table, telling the world about how wonderful your new site is. You save, and voilà! The article immediately appears in the news section on your site.
You’re pretty pleased with yourself, and schedule a lunch meeting with your biggest clients to boast a little bit. You tell them all about it, and they smile and look impressed and then ask you, “Is your site e-commerce enabled? Can we buy your products online?”
It turns out that your competitors are one step ahead of you. They not only have database-driven sites, but they are using those databases to keep track of their products, customers and orders, and to sell online.
This Digital Web article covers queries, relationships, joins and indexes in the context of a very useful example: the database behind an online shop. Read full article »