Choose a DBMS to build a database for a new website that handles requests for ai
ID: 3713010 • Letter: C
Question
Choose a DBMS to build a database for a new website that handles requests for airline travel and finds customers the best deals across all airlines and carriers. The goal is to simulate the process of researching, analyzing, and preparing a solid business case for making major database decisions.
The database requirements are as follows:
•Close to 24/7 uptime (99.5%)
•Minimum of 10,000 queries per day (with options to scale)
•< 1 ms response time for customer queries
•Enhanced security (FAA regulations)
•Disaster and recovery components
Explanation / Answer
SOLUTION:- We will choose IBM DB2 version 9 to build a database for a new website that handles requests for airline travel and finds customers the best deals across all airlines and carriers in order to handle complex workload like online transaction & analytical processing along with data mining & datawarehouse support. On IBM server machines it can perform upto 4,033,378 transactions per minute along with implementation of MySAP enterprise edition. It can fullfill all database requirements mentioned above.
====================================================================================