Yu Fei Gong

7873628, Jan 18, 2011

Mar 23, 2006

11/388680

Yu Gong - Half Moon Bay CA, US
Ron Gonzalez - San Mateo CA, US

Oracle International Corporation - Redwood Shores CA

G06F 7/00
G06F 17/30

707714, 707713

To discover functional dependencies in a large relation, a sample of tuples from the relation is collected. The sample is examined to determine whether one or more candidate functional dependencies exist just within the sample as a nominal dependency. When a nominal dependency is found in the sample, than all the tuples in the relation are examined to verify whether the nominal dependency holds for the whole relation. Candidate functional dependencies are disqualified when either a nominal dependency is found or when it is verified as functional dependency that holds for the entire relation.

8032493, Oct 4, 2011

Sep 26, 2008

12/239034

Yu Gong - Half Moon Bay CA, US

Hewlett-Packard Development Company, L.P. - Houston TX

G06F 7/00

707661, 707694

A system and method are provided for obtaining interrelated data for a database. The method can include the operation of calculating a data row set for a driving table in the database using at least one archive policy. A further operation is obtaining explicit and implicit application relationships between a second level table and the driving table. The driving table can be linked to the second level table to identify data rows eligible for archiving in the second level table. In addition, partition identifiers can be copied from the driving table rows to the second level table data rows in order to enable merging of application partitions as needed. Additional data rows can be found in the driving table based on the application relationship between the second level table and the driving table. The data rows collected from the tables can be archived.

8311974, Nov 13, 2012

Feb 20, 2004

10/783779

Yu Gong - Half Moon Bay CA, US

Oracle International Corporation - Redwood Shores CA

G06F 7/00

707602

Techniques exporting data and metadata from a source database environment to a target database environment are provided. The techniques include the steps of analyzing metadata that describes one or more items, the data for which is in a source database, where the one or more items include at least one of a view, a sequence, a dimension, a cube, an ETL mapping, and any database object for which the metadata is stored outside of the source and target databases. The data for each item resides in a data file associated with the source database. The data for each item is incorporated into the target database based on the metadata by providing the target database access to an incorporated data file, where the incorporated data file is the data file or a copy thereof. Techniques are also provided for exporting database data from the source database. The techniques include extracting metadata that describes one or more items, the data for which is in the source database, where the one or more items include at least one of the structures described above.

8515916, Aug 20, 2013

Sep 28, 2011

13/247716

Yu Gong - Half Moon Bay CA, US

Hewlett-Packard Development Company, L.P. - Houston TX

G06F 17/00

707661, 707665

Data archiving methods and data archiving apparatus are disclosed. An example method includes storing a first relational data structure generated in connection with a first iteration of an archiving process; determining a status of the first relational data structure; and when the status is valid, using the first relational data structure in a second iteration of the archiving process.

20130018847, Jan 17, 2013

Jul 12, 2011

13/181014

Yu Gong - Half Moon Bay CA, US

G06F 17/30

707661, 707E17002

A database archiving performance benefit determination system may include a data reduction module to ascertain a reduction value of data stored on a database, and a database setup module to ascertain a setup of the database. A performance modeling module may calculate a performance increase for a database application using the database based on the reduction value, the setup of the database, and at least one parameter representing the database application.

20130047196, Feb 21, 2013

Aug 18, 2011

13/212371

Yu Gong - Half Moon Bay CA, US
Robert Brown Thyne - San Jose CA, US

G06F 21/00

726 1

In one implementation, a plurality of records included in a transitive closure of a driving record is identified, and a record from the plurality of records or the driving record is determined to satisfy a security rule. The security rule is then applied to the driving record and the plurality of records.

20130110788, May 2, 2013

Jul 13, 2010

13/704344

Yu Gong - Half Moon Bay CA, US

G06F 17/30

707667

Methods, apparatus and articles of manufacture to archive data are disclosed. An example method to archive data disclosed herein comprises determining an initial data model representing functional dependencies among attributes of the data, the initial data model having fully interdependent functional dependencies among all attributes of the data, pruning one or more functional dependencies from the initial data model to determine a verified data model, and archiving a transaction included in the data to memory according to the verified data model.

55124305, Apr 30, 1996

Jul 13, 1993

8/091234

Yu Gong - Concord CA

HRI Research, Inc. - Concord CA

C12Q 170
C12Q 168
C12P 1934
C07H 1700

435 5

The use of nucleic acid to diagnose disease is disclosed. The use of nucleic acid from at least one hair follicle to diagnose the presence of a human immunodeficiency virus infection is demonstrated.