摘要 |
Methods for calculating mass storage requirements for a relational database table including both data pages and index pages. The methods allow direct calculation of the data storage and index storage requirements for a data base table, the methods based in part on the page size, the record length, and the number of records. The database requirement can be increased by partial unavailability of pages and rows. The methods include methods for calculating the number of B-tree levels in the index or indexes. The methods avoid the need for interactive calculations of the required size for a database table starting from the number of records, record size, and page size.
|