Company Filing History:
2 out of 14 
1 out of 448 
Years Active: 2000-2003
Title: Innovations by Hilton M Pereira
Introduction
Hilton M Pereira is an accomplished inventor based in Thousand Oaks, CA (US). He has made significant contributions to the field of database management systems, holding a total of 3 patents. His work focuses on enhancing the efficiency and effectiveness of database operations.
Latest Patents
One of his latest patents is titled "Method and apparatus for fast and comprehensive DBMS analysis." This invention allows for a rapid and thorough analysis of a database table by reading a header block that describes the location of data blocks. The data blocks are accessed using direct asynchronous I/O, enabling a detailed assessment of the database table's health. The analysis is conducted by spawning separate processes, each responsible for analyzing an equivalent number of data blocks. The results from each process are then summarized to provide comprehensive insights to database administrators.
Another notable patent is "Method and apparatus for reorganizing an active DBMS table." This innovation allows for the reorganization of database tables while they remain available for normal online transaction processing (OLTP) activities. A trigger records OLTP activity on the source table, which is temporarily locked to establish a checkpoint. A new table is created, and unmodified data blocks are transferred from the source table to the new table. Transactions occurring during this process are performed on the new table until all transactions are accounted for. Finally, the new table is switched with the source table, ensuring minimal disruption to ongoing operations.
Career Highlights
Hilton M Pereira has worked with several notable companies throughout his career. He has been associated with Platinum Technology, Inc. and Computer Associates Think, Inc. These experiences have contributed to his expertise in database management and innovation.
Conclusion
Hilton M Pereira's contributions to database management systems through his patents demonstrate his commitment to innovation in the field. His work not only enhances the efficiency of database operations but also provides valuable tools for database administrators.