Unisys Corporation

Mark G Hazzard

John M Quernemoen

Barry F Ruzek

James R Dew

A method for calculating and recalculating hardware requirements for a database management system computer. One method includes establishing default values for hardware utilization limits such as percent utilization of processors or network interface cards. Working copies of the hardware utilization limits can be initialized to the default utilization limits. Workload requirements can be obtained from a human user. In one method, the workload requirements are obtained as transactions per second value. In another embodiment, the workload requirements are obtained as a detailed list of transactions, expected execution rate of those transactions, and the composition of those transactions, including SQL statement type and parameters upon which those statements operate. The hardware requirements are then calculated so as to be within the hardware utilization limits, and can include discrete numbers of required hardware components such as processors and network interface cards.

Built in headroom for a preemptive multitasking operating system sizer

A system and methodology for implementing user assistance functions concerning interoperability of diverse applications, whether hosted on the same computer platform or hosted on different, and possibly heterogeneous computer platforms. The user is assisted by being offered information, tools and/or automation as appropriate to the problem presented. As appropriate, graphics or animation is utilized to permit complete and full understanding by the user of the assistance being provided.

User assistance for heterogeneous data processing systems

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.

Growing community of inventors

Forest Lake, MN, United States of America

Mark G Hazzard