Algorithms to calculate mass storage requirements for NT sizer
US6687719B1 · kind B1 · utility
Assignee
Inventor
Key dates
| Filing date | Feb 29, 2000 |
| Grant date | Feb 3, 2004 |
| Priority date | — |
| Expiry date | Feb 29, 2020 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99956
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.