Database Design Buyer's Guide

Database Programs

As a part of the project, you will need to choose the database program software on which your application will be developed. Selecting the right database programs for your business depends on several factors: the amount of information you need to store, the functionality you want, and the level of customer service you need.

For most small companies, desktop database solutions such as Microsoft Access, FileMaker's FileMakerPro, or Lotus Approach are often the right choice. They cost only a few hundred dollars and are easy to use. In addition, these database programs offer the advantage of having built-in interfaces that allow a developer to create a custom application using just the software.

For businesses with significant database needs that require hundreds of thousands of records to be tracked, enterprise-level databases such as Oracle, Sybase, or Microsoft SQL are the most powerful database programs. You can even download an open source database like MySql which has the benefit of being free, you will still need to pay extra for product support. The complex enterprise-level systems can handle billions of pieces of data, support multiple users at once, and offer increased security and reliability. They can get very expensive with prices starting in the thousands of dollars, but you do end up with a database program that fits all of your needs.

In addition to affecting functionality, your software decision also determines who you can tap to create your database. While the basic technique of designing database tables is shared across all programs, database developers typically have an expertise in actually developing on a more limited set of platforms. When choosing a developer, it's critical that they have extensive experience in the database programs that you use whether it's Access or Oracle.

Code ownership
Regardless of which platform is used, it's important to clarify any potential issues around ownership of the custom code that gets written using the software. Unless specified otherwise, the code is typically the intellectual property of the design firm. Make sure you agree who owns the code before the project starts and learn what you're allowed to do with it when the database is complete. For example, clarify what your options are if you want to make changes to the functionality and want to use another developer. It may not cost extra to own the code, but if you establish who the owner is early on, it can save you tremendous headaches down the line.

Search by State

Mentioned In...

See Also...

Advice & Tips