|
data base unlimited data base unlimited |
|||||
|
|||||
|
Home Up Consulting Development Training Integration |
projectsWe have undertaken a surprisingly diverse range of assignments. Migration to SQL Server and OLAPWe have helped clients leverage existing processes by migrating data from legacy systems in DB2, Access and other database and text structures into robust SQL Server and OLAP solutions. Clients have benefited from:
Cluster and fault-tolerant installationsWe have implemented fault tolerant installations with
eCommercePayment flow automation -- the automatic handling of payments through encrypted, secure messaging technology -- required integrating Microsoft Exchange Server, Microsoft SQL Server and a variety of of other Microsoft Back Office and Office tools. This new system entirely automates a process capable of handling $1 billion every year for fulfilment houses. Because we have been involved in SQL Server 7 and 2000 since early betas, we were in a unique position to devise a fully automated solution, including currency rates updated in the database by email flows. The latest stage of the project integrates all flows with the current accounting system, generating automatic, error free invoicing. The next stage allows world-wide real-time secure credit card authorisation and clearance. SQL Server optimisation125 million row tables for 200,000 clients, 200,000 stock records can present a real problem, particularly when the data comes from a legacy mainframe system. We helped optimise procedures and structure; we also devised a binary search scheme to help resolve the most problematic "non-existence" searches. Sybase, with Access front-endOur client's development team was familiar with Access but not Sybase. We showed them how to harness Sybase's power using SQL pass through and stored procedures. Result: complex annual accounting rollups which had taken 30 minutes, often timing out, were reduced to 3 seconds and the client gained a large measure of new functionality. SQL Server redesignOur client had commissioned a full web-driven commodities trading solution to run on SQL, from developers on another continent. Unfortunately the original solution had been designed in Access and was crashing SQL Server when only a few users were on-line. Searches were also taking up to 30 seconds. We transparently altered the structure of the SQL database and increased concurrency by 100 while reducing the same searches to 3 seconds. The next stage is to redesign the entire back-end and create the stored procedures for use by a revised front-end. Initial tests show that this will reduce seek times to 15 milliseconds. Mailing lists, with SQL Server and VBOur client had previously been using a system which allowed them to create mailing lists; however, between making selections and starting the print run was a several hour gap, and even then the system administrator had to set up parameters. Now, from a 80000 record set a 2000 address mailing selection is ready to merge in 1.7 seconds. Windows 2000/2003 Problem SolvingApplications were not running correctly in a mixed Windows NT/2000, Novell NetWare and mainframe environment. We traced the problem using W32 troubleshooting techniques and an in-depth analysis of the event logs, reproducing the problems on our own test network. Exchange planning and migrationA client had been using a proprietary mainframe mail system and wanted to migrate to Exchange Server. We helped design a structure covering 200+ entities spread across all continents and 43 countries. Copyright DBU 2000.
|
Location Map
Updates
|
|||