Custom Software · Web Applications · Database Design

Database Design and Development

Believe it or not, database design is likely the most misunderstood and neglected aspect of software development. And I mean by developers!

Most think that a database simply needs to hold data and there are no concerns as to HOW the data is stored.

But often ignored is the fact that more consideration needs to be taken:

  • Size:
    • How much space is required?
    • How much space will be required in the future?
    • How does the size of the database affect the speed of accessing the data?
  • Security:
    • How much security do I need?
    • How secure is the integrity of my data?
    • What happens if data is being written and the connection is broken?
    • How do I backup my data?
  • Speed:
    • Will my database slow down in the future?
    • How long does it take to process 1 million records?
    • Why does it take so long to run a report?
  • Scalability:
    • How hard will it be to add fields to my database?
    • How much will it cost?

And that is just a basic overview of the considerations that must be taken in order to design a proper database.

The database is the heart of any data driven software application. It is also the primary cause of most bottlenecks. Databases must be designed properly in order to serve data to the application in the most efficient manner possible.

Computer Icon Computer Icon Computer Icon

Our Specialties

.NET (VB & C#) · Visual Basic (including VBA and VBScript)

Java · C++ · SQL (Database Design, Stored Procedures, etc.)