Combination of mass storage sizer, comparator, OLTP user defined workload sizer, and design

摘要

A computerized method enabling a user to specify and select a server for a database management system. The computerized method can include software modules for specifying the hardware required to handle the database and the transaction processing. The hardware required to handle the database such as the mass storage and memory can be estimated using either estimated or detailed inputs. When using the detailed inputs, the database composition of each table can be described in great detail, including details about the columns and rows. The hardware required to handle the transaction processing such as the number of processors and the LAN speed can be estimated using either the required transactions per second or the detailed SQL composition for each transaction. A comparator function can allow comparison between two systems in terms of performance ratios and price to performance ratios.