Summary of a New Client/Server Database Architecture (Patent Pending)

The benefits of using the new database design have many potential advantages to growing and developing companies who are seeking efficient and low maintenance business solutions. The design has been fully tested, developed and demonstrated. DatingStage.com(*) utilizes some of these techniques where a single dating platform offers unparalleled level of scalability and low maintenance due to its tight integration to the database. Similarly Probesmart.com(*) also makes use of this technology and is able to offer features which are not available in other similar sites. For more detailed information on this architecture please see our complete application of the patent filed.


The client pc connects through the internet to the server (Fig. 1) and requests pages such as .html, .asp, .php pages and also may require information from the database.


Fig. 1. Typical web based client/server based applications.

Traditional architectures uses a three tier model for the client/server configuration. The application layer shown in Fig. 2 is separated from the database to form the object layer where the application code resides. This often has the disadvantage that the code in the object layer is written in isolation without regards to the database design, which may lead to non-optimized queries.


Fig. 2. Current object technology, showing application logic separated from the database.

Microsoft's hugely popular platform using ASP and IIS is shown in Fig. 3. Here the code in an ASP page may consist of calls to the database or any other components in the server. This allows the possibility of building advanced 'sites' such as web based applications.


Fig. 3. The microsoft solution.

The central theme of the design requires that all application communicates via the database. Fig. 3 shows how two business applications pass pertinent information such as state and variable information to the database. This has the advantage that any application can now reliably communicate with other applications by the database and all data relevant to each application is now held in the shared database. This leads to scalable and rapid development of business applications. Extending on the above concepts we can use instances of SQL Server on each server which scales with capacity requirements (Fig. 4). By making the database central to all business applications the benefits of scalability, reliability and reduced maintenance can be realized.


Fig. 4. Scalable database solution for building business applications.





(*) Internet connection required to access this page.