Brett A Hawton

US Patent:

8566286, Oct 22, 2013

Filed:

Feb 5, 2010

Appl. No.:

12/700799

Inventors:

Brett Derek Hawton - Alamo CA, US
Barry John Searle - Randburg, ZA
Daniel Aaron Hamilton - Pearland TX, US

Assignee:

Idera, Inc. - Houston TX

International Classification:

G06F 17/30

US Classification:

707654

Abstract:

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.

US Patent:

20110004586, Jan 6, 2011

Filed:

Jun 7, 2010

Appl. No.:

12/795135

Inventors:

Lon Jones Cherryholmes - Plano TX, US
Chandrashekhar M. Vaidya - Sugar Land TX, US
Brett Hawton - Alamo CA, US

International Classification:

G06F 17/30

US Classification:

707682, 707E17007

Abstract:

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 (unbeknownst to the DBMS) instead 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 transaction log portion of the backup file. All changes made to the data during the recovery phase and later during the execution of any TSQL statements which insert, update, or delete data 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.

US Patent:

20120117033, May 10, 2012

Filed:

Dec 21, 2010

Appl. No.:

12/975035

Inventors:

Chandrashekhar Madhukar Vaidya - Sugar Land TX, US
Russel Bruce McDonald - Pflugerville TX, US
Brett Derek Hawton - Alamo CA, US

Assignee:

BBS TECHNOLOGIES, INC. - Houston TX

International Classification:

G06F 17/30

US Classification:

707679, 707E17007

Abstract:

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

US Patent:

20130262412, Oct 3, 2013

Filed:

Mar 14, 2013

Appl. No.:

13/831175

Inventors:

Brett Derek Hawton - Alamo CA, US
Marius F. du Toit - Ocoee FL, US
Mark David Wright - Austin TX, US

International Classification:

G06F 17/30

US Classification:

707693

Abstract:

The present invention provides a method and system for providing database transaction log compression, where the transaction log data that is written to the transaction log file is compressed independently from the database data. In accordance with the present invention, the method and system provide for obtaining data to be written to the database transaction log file, compressing the data to be written to the database transaction log file and writing the compressed transaction log data to the database transaction log file.

US Patent:

20130325828, Dec 5, 2013

Filed:

Mar 15, 2013

Appl. No.:

13/837630

Inventors:

Brett Derek Hawton - Alamo CA, US

Assignee:

Confio Corporation - Boulder CO

International Classification:

G06F 17/30

US Classification:

707703

Abstract:

The present invention provides a method and system for using an operating system level I/O filter driver for providing transparent database transaction log file redundancy. In accordance with the method, the I/O filter driver intercepts a database management system request to write data to the database transaction log file. The I/O filter driver writes the data to at least two transaction log files.

US Patent:

20140067776, Mar 6, 2014

Filed:

Aug 26, 2013

Appl. No.:

14/010385

Inventors:

Brett Derek Hawton - Alamo CA, US

International Classification:

G06F 17/30

US Classification:

707692

Abstract:

When one considers all of the servers at an organization, the exact same operating system and application files will appear on many of them. Thus, there is an opportunity for saving an enormous amount of disk space for the organization as a whole by de-duplicating stored files. The present invention addresses the above needs by providing a method and system for saving at least one copy of a duplicate file in a location on a common storage system accessible to all relevant server computers and then removing the duplicates from the storage allocated to each server. Whenever the operating system on a server whose duplicate file has been removed requires access to the file, then the method redirects the operating system to access the file from the common storage system file location.