Search

Supiti Buranawatanachoke Phones & Addresses

  • San Mateo, CA
  • Belmont, CA
  • Menlo Park, CA
  • Redwood City, CA
  • Pittsburgh, PA

Publications

Us Patents

Transactionally Consistent Database Replay In An Environment With Connection Pooling

View page
US Patent:
8438144, May 7, 2013
Filed:
Aug 27, 2010
Appl. No.:
12/870736
Inventors:
Romain Colle - San Francisco CA, US
Karl Dias - Foster City CA, US
Leonidas Galanis - San Jose CA, US
Supiti Buranawatanachoke - San Mateo CA, US
Jonathan Giloni - Foster City CA, US
Efstratios Papadomanolakis - San Francisco CA, US
Yujun Wang - Cupertino CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 17/30
US Classification:
707705
Abstract:
A method, apparatus, and computer-readable medium is provided for replaying captured workload data in a database environment with connection pools. A replay system includes a dispatcher that manages a connection pool. In one aspect, the dispatcher selects available connections for sending database commands that are ready to be executed against a database, but prevents from being sent, or holds, commands that are not ready to be executed against the database. Commands may be stored at the dispatcher until the database advances to a state that allows the commands to be executed. In another aspect, the dispatcher may use an available connection to send a command to a database instance even though the command is not ready to be executed, as long as at least a threshold number or percentage of connections remains available.

Fine Grain Synchronization For Database Replay

View page
US Patent:
20110276550, Nov 10, 2011
Filed:
May 6, 2010
Appl. No.:
12/775322
Inventors:
Romain Colle - San Francisco CA, US
Benoit Dageville - Foster City CA, US
Karl Dias - Foster City CA, US
Leonidas Galanis - San Jose CA, US
Supiti Buranawatanachoke - San Mateo CA, US
Jonathan Klein - Redwood City CA, US
Efstratios Papadomanolakis - San Francisco CA, US
Yujun Wang - Los Gatos CA, US
International Classification:
G06F 17/30
US Classification:
707705, 707802, 707E17005
Abstract:
A method, apparatus, and computer readable medium for preserving data dependency during replay of database commands without strictly preserving a global ordering of the database commands is provided. A capture process captures a workload of database commands executed by a production system. The captured workload includes object identifiers that identify database objects that were referenced directly or indirectly during execution of the database commands by the production system. The captured workload also includes an indication of whether the database objects were potentially read or written during execution of the commands. The workload is processed to determine that an object accessed during execution of a command was previously modified during execution of one or more other commands. A replay process on a test database system prevents the command from being replayed until after the one or more other commands have been replayed to modify the object.
Supiti Buranawatanachoke from San Mateo, CA, age ~42 Get Report