Database sizer for preemptive multitasking operating system
US6542893B1 · kind B1 · utility
Assignee
Inventor
Key dates
| Filing date | Feb 29, 2000 |
| Grant date | Apr 1, 2003 |
| Priority date | — |
| Expiry date | Feb 29, 2020 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99953
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods for calculating total mass storage requirements for a relational database table including database storage requirements, application and software requirements, system table requirements, scratch and sort requirements, log file requirements, and growth requirements. One method utilizes detailed inputs for each table and table index. Another method produces and utilizes estimates for the database and index requirements for all tables together. Methods can use input parameters including the page size, a fill factor, the log file space, the temporary space, the operating system and application software space, the system database space, the growth percent space, and the page file space. Some methods also take into account inputs such as the number of table, the amount of data, the average number of columns per row, the average row size, the percent of variable length columns, and the average variable length column size per table.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.