DataBase Coding System:
The purpose of this document is to come up with standards to be followed for databases in product development. The document mainly focuses on the data types and SQL syntax to be followed in developing products that are database independent. Designers and developers can use this document as a reference during product development.
1.1 Scope:
The document describes standards specific to database while developing products that are database independent. It is meant for use by the designers and developers. Presently the document is in the initial stage and will undergo a lot of improvements. This document is the outcome of the experience while developing the database independent version of 2ndLook product. Since HSS will be developing products for Internet/Intranet and that Java is one of the languages used for development, the document also covers Java Database Connectivity (JDBC). The document mainly refers to two leading databases – Oracle and Microsoft SQL Server but it could be extended to any other standard Relational Database.
DataBase-SQL1 Database-SQL2
|