 |
|
|
|
We designed and developed a high performance, large-scale database to store information for 50 million customers. We wrote several database programs for data processing and manipulation. Since the database was very large, we used several optimization and performance tuning techniques.
We also created a web site extranet with which customers can setup an account, run custom queries and counts for mailing lists and place orders online. The system automatically schedules large orders for processing and runs them based on server load.
We also developed a web site management system that allows the administrator to create and update client accounts, create sub lists (mailing lists) from the database, assign sublist access privileges to accounts, view & fulfill orders, process mailing list generation and create a wide variety of custom reports.
The entire system was developed on the Microsoft.NET platform and the SQL Server 2000 database. The system was deployed across several load balanced servers.
Some screenshots from the application:
