DB3NF Overview

DB3NF is a Rapid Web Application Development platform (RAD) designed for fast and easy creation of high performance, maintainable and scalable Web applications of virtually any kind. It also dramatically reduces development and QA time and provides a consistent look and feel throughout the application.

DB3NF is based on the core Microsoft technologies:

DB3NF consists of six main parts ordered as they appear in the development process (from bottom up in the picture):

• DB3NF Administration console. It allows creating and maintaining application schema and business rules. It also provides application administration and deployment.

• "Schema" database. Schema database structure is fixed and the data is manipulated by the Administration Console. It defines and stores application structure, business rules and basic presentation rules. This database contains a set of deployment stored procedures. They read data from the Schema database and automatically create in the target ("Data") database a third normal form table structure with all necessary tables, primary, check and foreign key constraints, indexes and stored procedures.

• "Data" database. This database is created automatically and its structure depends on the application schema.

• Stored procedures are created automatically by the "Schema" database procedures. No development work is required to create and modify them when application schema changes. DB3NF component "talks" to the "Data" database exclusively through these optimized stored procedures, which provides for high performance of the DB3NF platform.

• DB3NF component. The component is completely generic and integrates seamlessly with both databases. No design work is required after application schema is created and deployed. DB3NF automatically "learns" application schema and rules when application starts. The component employs various caching techniques and is extremely fast and efficient.

• The ASP code in DB3NF is very simple and straightforward. It is easy to write and maintain.