The University of Arizona
  Dashboard > Web Application Best Practices > Web Application Best Practices > Databases
Web Application Best Practices Log In   View a printable version of the current page.
Databases

Added by Ed Murphy , last edited by Brett Bendickson on Apr 11, 2007  (view change)
Labels: 
(None)

Database best practices


Top recommendations:

  • Follow vendor recommendations regarding security and the database.
  • Ensure data table structure is normalized. It is recommended to have data in 3rd normal form, where possible.
  • Use appropriate data typing in all tables.
  • Pay special attention to SQL Injection issues
  • Include robust auditing, so that all data modifications done throug the application can be traced to specific users.

More content can go over here, as well.

Powered by Atlassian Confluence 2.7.2, the Enterprise Wiki. Bug/feature request - Atlassian news - Contact administrators