Using Databases

 

Definition

A simple definition of a database: a structure that stores and organizes data in tables. For more details see the Wikipedia article on databases.

Relevance

  • They can be used to organize data that have complex relationships.
  • They can be constructed in ways that make data entry easy and data retrieval fast.
  • They can be set up to allow multiple users to enter/query data.
  • They can hold large amounts of data. In some cases, databases point to data rather than directly containing it.

Recommendations

  • The most important step in constructing a database is planning. Focus on understanding your data. What relationships exist between the elements? Develop a data model and apply the concepts of normalization to optimize it.
  • Evaluate your data model. Will it allow you to query the data and finds the kinds of answers you want from your database?
  • Determine if you will need to create forms or reports for data entry/query to use with the database.
  • Build a practice database and run test queries. Does it give you the information you expect?
  • Be sure to back up your database.

Options

  • Use a commercial database software, such as Access or Filemaker to create a database. These applications allow you to create query, report, and/or data entry forms. These applications may be suitable for your needs if relationships between your data elements are not very complex.
  • Build a database using an open source database engine such as MySQL or Postgres. These can accommodate data with complex relationships and support large database size. There are integrative applications available that help you build databases and queries within the MySQL or Postgres environment.

Resources

TopicResources
Data normalizationAn Introduction to Database Normalization a tutorial on Dev Shed

An Introduction to Database Normalization an article in the Developer forum of MySQL
Database engines and related toolsMySQL a free, open source environment for building databases and queries. Add-in applications include MySQL Workbench (for building databases) and Aqua Data Studio (for building queries) to name a few. There are also many online tutorials and books on using MySQL.
PostgresSQL is another free, open source environment for building databases and queries.
Commercial database softwareMicrosoft Access software and training
FileMaker Pro software and training

FileMaker users at the University of Wisconsin have a listserve for support and sharing experiences. To join send an email
Custom database developmentDoIT Academic Technology offers custom database design and development services (Call 262-5667 or email)