Embarcadero Technologies, Inc.

Idera, Inc.

Bbs Technologies, Inc.

Brett Hawton

James B Pitts

Chandrashekhar Madhukar Vaidya

George Eddie Bailey, Jr

Barry John Searle

Lon Jones Cherryholmes

Daniel Aaron Hamilton

Russel Bruce McDonald

Methods and systems are disclosed improving run-time performance of a database. A development database comprising code is accessed, at a computer system. Code of the development database is tested against a data set. Data statistics are generated, at the computer system, based on performance metrics of how the development database would perform using the data set. The data statistics and at least one suggestion to implement into code of the development database to improve performance of the development database are displayed at the computer system.

Run-time performance of a database

Methods and systems are disclosed improving run-time performance of a database. A non-production database is accessed, at a computer system, during a design phase of the non-production database. Code of the non-production database is tested against a production database. Data statistics are generated, at the computer system, based on performance metrics of how the non-production database would perform as the production database. The data statistics and at least one suggestion to implement into code of the non-production database to improve performance of the non-production database are displayed at the computer system.

Methods and systems are disclosed improving run-time performance of a database. A non-production database is accessed, at a computer system, during a design phaseof the non-production database, wherein the non-production database will be converted to a production database after the design phase. Data statistics are generated, at the computer system, based on performance metrics of how the non-production database would perform as the production database. The data statistics are displayed, at the computer system, to a developer of the non-production database during the design phase. At least one suggestion is offered to the developer, at the computer system, to implement into the SQL of the non-production database to improve a performance of the non-production database.

A virtual database is attached to a server database management system ('DBMS') such that the DBMS believes it needs to recover the database to a last known point of consistency. In order to perform this recovery, the DBMS requests the transaction log file entries to be read from what it believes is the database's transaction log file. However, the requests are intercepted and translated into requests to read the transaction log portion of the backup file. The DBMS then uses the transaction log records to bring the database to a point of transactional consistency, unaware that the log records are actually being sourced from the backup file. All changes made to the data during the recovery phase and subsequent execution of any TSQL statements are routed into a cache file. Accordingly, a 'virtual' database is created and used by the server DBMS engine as if it were a real database.

System, method, and computer program product for creating a virtual database

A system and method for backing up a database, where the system has read threads running simultaneously, write threads, and data buffers. Each read thread repeats the following operations until all the data is backed up: read a block of data from the database, compress the data using a dynamic compression ratio which is initialized and adjusted after every compression, write the data to an available data buffer until the data buffer is full, write to the next available data buffer once the data buffer is full, and determine a new compression ratio. A controller determines the new compression ratio using either a method that monitors the timing of system components and/or a method that monitors CPU consumption.

System and method for high speed database backup using rapidly adjusted dynamic compression ratios controlled by a feedback loop

Some embodiments provide methods and apparatuses for performing a near-instantaneous restore of a database. During operation, the system intercepts a database management system restore request to restore a database from a backup file to a data file, wherein the backup file comprises a first number (e.g., N) of data pages. Next, in response to intercepting the database management system restore request, the system sends information to the database management system indicating that the backup file comprises a second number (e.g., N) of data pages, wherein the second number of data pages is less than the first number of data pages (e.g., N&#x3c;N). Once the database management system has copied the fewer number of data pages from the backup file to the data file, the database management system may indicate that the restore is complete, and continue processing database requests as if the database management system was back online.

Growing community of inventors

Alamo, CA, United States of America

Brett Hawton