Using the new database design offers 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. Our free dating service, JumpDates.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 makes use of this technology and is able to offer features that are not available in comparable 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 (Figure 1) and requests pages such as .html, .asp, .php pages and also may require information from the database.
Figure 1. Typical web-based client/server-based applications
Traditional architecture uses a three-tier model for the client/server configuration. The application layer shown in Figure 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 regard to the database design, which may lead to non-optimized queries.
Figure 2. Current object technology, showing application logic
separated from the database
Microsoft's hugely popular platform using ASP and IIS is shown in Figure 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.
Figure 3. The Microsoft solution
The central theme of the design requires that all applications communicate via the database. Figure 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 through 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 the above concepts, we can use instances of SQL Server on each server, which scale with capacity requirements (Figure 4). By making the database central to all business applications, the benefits of scalability, reliability and reduced maintenance can be realized.
Figure 4. Scalable database solution for building business applications