Database Design and Implementation Issues

Database Design and Implementation Issues
SANUG Technical Discussion - 06/09/98

"The decision about tools and development model should be made at the same time."

Development Tools

Languages? C, C++, Visual Basic, FoxPro, Access

Compilers? Microsoft, Borland

Debuggers?

Run-time deployment? User Licensing

Database Design High volume?

Simultaneous multi-user access?

Scalability?

Continuous replication of data while maintaining transactional consistency?

Application Structure Where do you locate the most of the running code? Client, database, or separate server?

Query Design

Choice of Interface

Terms

ODBC Open Database Connectivity [Microsoft]
ADO Active Data Objects [Microsoft]
OLE DB Object Linking & Embedding DB [Microsoft]
SQL Search & Query Language [Microsoft, Oracle]

Click here to print This Page