Other concerns you must examine include performance requirements, capacity, cost, and platform availability. You must also consider any existing data that you want to Web enable. If your new Web database needs to contain a copy of existing data, further analysis is called for because issues such as replication and data synchronization come into play. It's a good idea to consult with the administrator of your existing database before you make your decision. Choosing Your Level of Technology Before choosing a database, you'll need a general idea of what you want it to do.
Databases come with a variety of functionality.
Let's start with a few of the important features that databases can support. Automatic Queries Stored procedures are precompiled SQL statements that run against the database. Because stored procedures are precompiled and because they reside on the database server itself, they execute much more quickly than standard SQL queries from a Web server. If you are planning to execute a query a great number of times, this speed difference becomes very important. Triggers are stored procedures that run automatically and are initiated by other database queries or stored procedures.