Stored procedures convert data, and SQL Server tasks schedule data download and replication to other servers. The gateway thus simplified and stabilized the replication process. It allows for web server and SQL server load-balancing because branch Wolf servers support employee web browsers. It maintains local data access when there is a network communication failure between a branch and the central office. Data Flow Back to the Central Server Bank employees access the corporate intranet with Internet Explorer 3.0x on Microsoft Windows 95 or Windows NT Workstation systems.
Employees generally query replicated data stored in their own branch server.
Branch SQL Servers temporarily store new data entered into the system, and then record it directly into the central SQL Server. To maintain security, the bank required that the legacy database system stay intact and unaltered. It checks any data passed from the central SQL Server for inner-data consistency, and if accepted, writes the data to its tables. The central SQL Server database stores data associated with new system functionality, such as customer data modification log and signature pictures. The front-end web interface, developed by Hypermedia, consolidates all of the new banking functionality as well former capabilities, such as accessing account information, in a web site.