SEOMining SEOMining

Software Requirements  «Prev  Next»
Lesson 9

Database Solutions Conclusion

When working in Web site development, you should be knowledgeable about all the components of the process. Whether your interest is on the technical, business, or creative side, you should have some familiarity with what your options are for software purchase and deployment.
You should now be able to:
  1. List the functions of databases
  2. Describe the four basic database models
  3. Explain the characteristics and protocols of back-end Web databases
  4. Explain the importance of data modeling techniques
  5. Describe the functions of security software
  6. Explain the types and benefits of bundled solutions, giving common examples
In the next module, you will be looking at software planning from the perspective of the different Web models.

When creating database-driven web applications, you will need to do some of the following tasks:
  1. Tabular output: Listing query results in an easily readable format is one of the most commonplace tasks you will deal with when building database-driven applications. Understand how to programmatically create these listings.
  2. Sorting tabular output: Often, query results are ordered in a default fashion, by product name, for example. But what if the user would like to reorder the results using some other criteria, such as price? Provide table-sorting mechanisms that let the user search on any column.
  3. Subqueries: Even simple data-driven applications often require queries to work with multiple tables, typically using joins.
    Many of these operations can also be accomplished with the arguably much more intuitive subquery.
  4. Cursors: Operating in a fashion similar to an array pointer, a cursor (a feature new to MySQL 5.0) gives you the ability to swiftly navigate database result sets. Use cursors to streamline your code.
  5. Paged results: Database tables can consist of thousands, even millions, of records. When large result sets are retrieved, it often makes sense to separate these results across several pages and provide the user with a mechanism to navigate back and forth between these pages.