Uri Shaft

6681222, Jan 20, 2004

Jul 16, 2001

09/906502

Navin Kabra - Pune, IN
Raghu Ramakrishnan - Madison WI
Uri Shaft - San Leandro CA
Vuk Ercegovac - San Francisco CA

Quip Incorporated - Madison WI

G06F 1730

707 5, 707 2, 707 3, 707 4

A unified database/text retrieval system converts exact database type queries into text inclusion type queries suitable for text retrieval systems through the use of pseudo keywords. Boolean combination of the text inclusion type query elements may be readily manipulated for optimization and applied to a unified index for rapid search results. Absolute relevance values and relevance multiplier values may be added to the query elements to provide a relevance-based sorting not only of text but also of exact match type search results. Relevance values may be deduced automatically from a variety of sources.

7603339, Oct 13, 2009

Apr 25, 2007

11/796110

Thierry Cruanes - Foster City CA, US
Uri Shaft - Castro Valley CA, US
Hong Su - Foster City CA, US
Benoit Dageville - Foster City CA, US
Sunil P. Chakkappen - Foster City CA, US
Mohamed Zait - San Jose CA, US

Oracle International Corporation - Redwood Shores CA

G06F 7/00
G06F 17/30
G06F 17/00

707 1, 707102, 7071041

A method and apparatus for merging synopses to determine a database statistic, e. g. , a number of distinct values (NDV), is disclosed. The merging can be used to determine an initial database statistic or to perform incremental statistics maintenance. For example, each synopsis can pertain to a different partition, such that merging the synopses generates a global statistic. When performing incremental maintenance, only those synopses whose partitions have changed need to be updated. Each synopsis contains domain values that summarize the statistic. However, the synopses may initially contain domain values that are not compatible with each other. Prior to merging the synopses the domain values in each synopsis is made compatible with the domain values in the other synopses. The adjustment is made such that each synopsis represents the same range of domain values, in one embodiment. After “compatible synopses” are formed, the synopses are merged by taking the union of the compatible synopses.

7636731, Dec 22, 2009

Apr 25, 2007

11/796102

Thierry Cruanes - Foster City CA, US
Uri Shaft - Castro Valley CA, US
Hong Su - Foster City CA, US
Benoit Dageville - Foster City CA, US
Sunil P. Chakkappen - Foster City CA, US
Mohamed Zait - San Jose CA, US

Oracle International Corporation - Redwood Shores CA

G06F 7/00
G06F 17/30
G06F 17/00

707102, 707 2

A method and apparatus for approximating a database statistic, such as the number of distinct values (NDV) is provided. To approximate the NDV for a portion of a table, a synopsis of distinct values is constructed. Each value in the portion is mapped to a domain of values. The mapping function is implemented with a uniform hash function, in one embodiment. If the resultant domain value does not exist in the synopsis, the domain value is added to the synopsis. If the synopsis reaches its capacity, a portion of the domain values are discarded from the synopsis. The statistic is approximated based on the number (N) of domain values in the synopsis and the portion of the domain that is represented in the synopsis relative to the size of the domain.

7673291, Mar 2, 2010

Feb 9, 2004

10/775531

Karl Dias - Foster City CA, US
Shivani Gupta - Los Altos CA, US
Mark Ramacher - San Carlos CA, US
Uri Shaft - Castro Valley CA, US
Venkateshwaran Venkataramani - Foster City CA, US
Graham S. Wood - El Granada CA, US
Juan Loaiza - Redwood City CA, US

Oracle International Corporation - Redwood Shores CA

G06F 9/44
G06F 12/00
G06F 11/00

717127, 717124, 707200, 714 38

Techniques for self-diagnosing performance problems in a database are provided. The techniques include classifying one or more performance problems in a database system. One or more values for quantifying an impact of the one or more performance problems on the database system are then determined. The quantified values are determined based on the performance of operations in the database system. A performance problem based on the one or more quantified values is then determined. A solution for the performance problem is generated and may be outputted.

7937623, May 3, 2011

Oct 15, 2008

12/252056

Mark Ramacher - San Carlos CA, US
Gary Ngai - Saratoga CA, US
Benoit Dageville - Foster City CA, US
Karl Dias - Foster City CA, US
Yair Sarig - San Mateo CA, US
Marcus Fallen - Belmont CA, US
John Beresniewicz - San Mateo CA, US
Mike Feng - San Mateo CA, US
Jonathan Klein - Redwood City CA, US
Hailing Yu - Sunnyvale CA, US
Leng Tan - Sunnyvale CA, US
Balasubrahmanya Kuchibhotla - San Ramon CA, US
Uri Shaft - Castro Valley CA, US
Venkateshwaran Venkataramani - Sunnyvale CA, US
Amir Valiani - San Jose CA, US

Oracle International Corporation - Redwood Shores CA

G06F 11/00

714 37

A diagnosability system for automatically collecting, storing, communicating, and analyzing diagnostic data for one or more monitored systems. The diagnosability system comprises several components configured for the collection, storage, communication, and analysis of diagnostic data for a condition detected in monitored system. The diagnosability system enables targeted dumping of diagnostic data so that only diagnostic data that is relevant for diagnosing the condition detected in the monitored system is collected and stored. This in turn enables first failure analysis thereby reducing the time needed to resolve the condition detected in the monitored system.

8024301, Sep 20, 2011

Aug 11, 2004

10/916695

Karl Dias - Foster City CA, US
Graham S. Wood - El Granada CA, US
Shivani Gupta - Los Altos CA, US
Sushil Kumar - San Jose CA, US
Mark Ramacher - San Carlos CA, US
Uri Shaft - Castro Valley CA, US
Leng Leng Tan - Sunnyvale CA, US
Venkateshwaran Venkataramani - Redwood City CA, US

Oracle International Corporation - Redwood Shores CA

G06F 7/00

707688, 707792

One or more usage models are provided for a database. Each usage model includes a set of rules that are used to analyze database performance. A usage model in one or more usage models is determined. Database information is determined based on the usage model. The database information is then analyzed based on rules associated with the usage model. One or more performance problems are determined based on the analysis.

8161323, Apr 17, 2012

Oct 15, 2008

12/252128

Balasubrahmanya Kuchibhotla - San Ramon CA, US
Jonathan Klein - Redwood City CA, US
Karl Dias - Foster City CA, US
Uri Shaft - Castro Valley CA, US

Oracle International Corporation - Redwood Shores CA

G06F 11/00

714 25, 714 471, 714 472, 714 48

Techniques for proactively and reactively running diagnostic functions. These diagnostic functions help to improve diagnostics of conditions detected in a monitored system and to limit/quarantine the damages caused by the detected conditions. In one embodiment, a health monitor infrastructure is provided that is configured to perform one or more health checks in a monitored system for diagnosing and/or gathering information related to the system. The one or more health checks may be invoked pro-actively on a scheduled basis, reactively in response to a condition detected in the system, or may even be invoked manually by a user such as a system administrator.

8392406, Mar 5, 2013

Aug 13, 2008

12/190885

Fatih Emekci - San Mateo CA, US
Sunil P. Chakkappen - Foster City CA, US
Uri Shaft - Castro Valley CA, US

Oracle International Corporation - Redwood Shores CA

G06F 7/00

707719, 707688, 707798

A table-level histogram is maintained incrementally without requiring rescanning of the entire table when new data values are added to the table. A table has multiple partitions of data values. A histogram for data values of the partitions is generated. When a new partition of data values is added to the table, a histogram for only the new partition is generated. To generate a histogram for the entire table, the histograms for the previously generated and newly added partitions are used without needing to refer to the underlying data. A similar approach is applicable when modifying data values in a partition.