Francisco M Sanchez

US Patent:

7526508, Apr 28, 2009

Filed:

Sep 3, 2004

Appl. No.:

10/934076

Inventors:

Leng Leng Tan - Sunnyvale CA, US
Gianfranco Putzolu - San Francisco CA, US
Richard Sarwal - Portola Valley CA, US
Alex Tsukerman - Foster City CA, US
Gary C. Ngai - Saratoga CA, US
Graham Stephen Wood - El Granada CA, US
Karl Dias - Foster City CA, US
Mark Ramacher - San Carlos CA, US
Benoit Dageville - Foster City CA, US
Mohamed Ziauddin - Pleasanton CA, US
Tirthankar Lahiri - Santa Clara CA, US
Sujatha Muthulingam - Mountain View CA, US
Vishwanath Karra - San Jose CA, US
Francisco Sanchez - San Carlos CA, US
Hsiao-Te Su - Milpitas CA, US
Wanli Yang - San Mateo CA, US
Vasudha Krishnaswamy - Fremont CA, US
Sushil Kumar - San Jose CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707200, 707 2

Abstract:

An intelligent database infrastructure wherein the management of all database components is performed by and within the database itself by integrating management of various components with a central management control. Each individual database component, as well as the central management control, is self-managing. A central management control module integrates and interacts with the various database components. The database is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.

US Patent:

7571173, Aug 4, 2009

Filed:

Oct 15, 2004

Appl. No.:

10/966961

Inventors:

Wanli Yang - San Mateo CA, US
Bipul Sinha - Foster City CA, US
Amit Ganesh - San Jose CA, US
Wei Hu - Palo Alto CA, US
Alok Pareek - Brisbane CA, US
Alexander H. Hwang - Orinda CA, US
Steven Charles Wertheimer - Kentfield CA, US
Francisco M. Sanchez - San Carlos CA, US
Dmitry Mikhailovich Potapov - Emerald Hills CA, US
Juan R. Loaiza - Redwood City CA, US
William H. Bridge - Alameda CA, US
J. William Lee - Redwood Shores CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 7/00

US Classification:

707101

Abstract:

A method and apparatus for creating a target database on a target platform based on a source database on a source platform is provided. A target database is created on the target platform based on data, metadata (for example, data in the system tablespace and control files), and external objects (for example, password files and externally stored tables) comprised within the source database. Data and metadata stored in tablespaces of the source database are converted to the format compatible with the target platform. The conversion of the data and metadata may be performed either at the source database or the target database. Redo information and undo information of the source database are not copied from the source database to the target database. Certain files, e. g. , a password files, and links to externally stored object may be recreated on the target database.

US Patent:

7610314, Oct 27, 2009

Filed:

Oct 7, 2005

Appl. No.:

11/245589

Inventors:

Benny Souder - Belmont CA, US
James Stamos - Saratoga CA, US
Hung Tran - Sunnyvale CA, US
Francisco Sanchez - San Carlos CA, US
Lik Wong - Union City CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 12/00
G06F 17/30

US Classification:

707200, 707 1, 707 10, 707204, 711162

Abstract:

To export source tablespaces, an auxiliary database system is created and started with a minimum configuration. Copies of versions of the source tablespaces are restored from database backups to the auxiliary database system. A copy of a version of a tablespace is referred to herein as a tablespace instance. The tablespace instances restored from database backups are recovered to a particular point-in-time. A script is then generated. The script can be executed by a database server of the destination database to import the tablespace instances.

US Patent:

8554806, Oct 8, 2013

Filed:

Oct 14, 2004

Appl. No.:

10/966679

Inventors:

Wei Hu - Palo Alto CA, US
Alexander Hwang - Orinda CA, US
Alok Pareek - Brisbane CA, US
Dmitry Potapov - Emerald Hills CA, US
Francisco Sanchez - San Carlos CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 7/00
G06F 17/30

US Classification:

707809, 707803, 707802, 707790

Abstract:

Stored data are transported between different systems having different platforms by converting the format of the stored data into a common format either before or after transmitting the stored data from the source database system to the target database system. The common format may be a format that is universal in that the common format is not machine dependent. The stored data may be kept in the common format at the target database system and never converted to another format. Optionally, the stored data may be converted from the common format to a format associated with the target database system, thereby facilitating backward compatibility. A tool may be provided for performing the conversion.