Join factorization of union/union all queries

United States of America Patent

Stats

Jan 5, 2010
Grant Date
Sep 20, 2007
app pub date
Mar 8, 2007
filing date
Mar 15, 2006

priority date (Note)
In Force

status (Latency Note)

Importance

Loading Importance Indicators... loading....

Abstract

are three tables. A given query may be rewritten in many alternate ways using join factorization. Evaluating each alternative can be expensive. Therefore, the alternatives are generated and evaluated in a way that minimizes the cost of evaluating the alternatives.

Loading the Abstract Image... loading....

First Claim

See full text

loading....

all claims.. loading....

Family

Loading Family data... loading....

Patent Owner(s)

Patent Owner	Address
ORACLE INTERNATIONAL CORPORATION	500 ORACLE PARKWAY REDWOOD CITY CA 94065

International Classification(s)

G06F:ELECTRIC DIGITAL DATA PROCESSING

[Classification Symbol]

[Patents Count]

Inventor(s)

Inventor Name	Address	# of filed Patents	Total Citations
Ahmed, Rafi	Fremont, US	74	1716
Cruanes, Thierry	Foster City, US	314	2298
Lee, Allison	Sunnyvale, US	15	239
Su, Hong	Foster City, US	40	684
Zait, Mohamed	San Jose, US	61	2422

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation

Maintenance Fees

Fee	Large entity fee	small entity fee	micro entity fee	due date

Fee	Large entity fee	small entity fee	micro entity fee
Surcharge after expiration - Late payment is unavoidable	$700.00	$350.00	$175.00
Surcharge after expiration - Late payment is unintentional	$1,640.00	$820.00	$410.00

Patent Searching
Technology Searching
Owner and Inventor Searching
Patent Analytics
Owner Analytics
Attorney Analytics
Inventor Analytics
Technology Analytics
Mobile Searching
Tagging
Advanced Patent Analytics
Advanced Owner Analytics
Mobile Portfolio/Analytics
Detailed Attorney Information
Prosecution analytics
Pre-publication Data
Monthly PAIR Information and Watches
Number of patents in all portfolios	100 (maximum)	1000 (maximum)	2000 (maximum)	Unlimited
Follows in all categories (Watch)	10 (maximum)	50 (maximum)	500 (maximum)	Unlimited
Maximum number of portfolios	5 (maximum)	10 (maximum)	100 (maximum)	Unlimited
Maximum number of comparisons	1 (maximum)	5 (maximum)	20 (maximum)	Unlimited

FREE	$9.95/mo		$39.95/mo	$99.95/mo

PAIR Watch Weekly Update		$2.75/mo/patent		$2.65/mo/patent
PAIR Watch Daily Update		$5.75/mo/patent		$5.55/mo/patent
Upgrade Now	Upgrade Now		Upgrade Now	Upgrade Now

Patent Searching
Technology Searching
Owner and Inventor Searching
Patent Analytics
Owner Analytics
Attorney Analytics
Inventor Analytics
Technology Analytics
Mobile Searching
Tagging
Advanced Patent Analytics
Advanced Owner Analytics
Mobile Portfolio/Analytics
Detailed Attorney Information
Prosecution analytics
Pre-publication Data
Monthly PAIR Information and Watches
Number of patents in all portfolios	100 (maximum)	1000 (maximum)	2000 (maximum)	Unlimited
Watches in all categories (Watch)	10 (maximum)	50 (maximum)	500 (maximum)	Unlimited
Maximum number of portfolios	5 (maximum)	10 (maximum)	100 (maximum)	Unlimited
Maximum number of comparisons	1 (maximum)	5 (maximum)	20 (maximum)	Unlimited

FREE	$9.95/mo		$39.95/mo	$99.95/mo

PAIR Watch Weekly Update		$2.75/mo/patent		$2.65/mo/patent
PAIR Watch Daily Update		$5.75/mo/patent		$5.55/mo/patent
Upgrade Now	Upgrade Now		Upgrade Now	Upgrade Now

Patent Searching
Technology Searching
Owner and Inventor Searching
Patent Analytics
Owner Analytics
Attorney Analytics
Inventor Analytics
Technology Analytics
Mobile Searching
Tagging
Advanced Patent Analytics
Advanced Owner Analytics
Mobile Portfolio/Analytics
Detailed Attorney Information
Prosecution analytics
Pre-publication Data
Monthly PAIR Information and Watches
Number of patents in all portfolios	100 (maximum)	1000 (maximum)	2000 (maximum)	Unlimited
Follows in all categories (Watch)	10 (maximum)	50 (maximum)	500 (maximum)	Unlimited
Maximum number of portfolios	5 (maximum)	10 (maximum)	100 (maximum)	Unlimited
Maximum number of comparisons	1 (maximum)	5 (maximum)	20 (maximum)	Unlimited

Join factorization of union/union all queries

Number of patents in Portfolio can not be more than 2000

United States of America Patent

11716010

Stats

Importance

Abstract

First Claim

Family

Patent Owner(s)

International Classification(s)

Inventor(s)

Cited Art Landscape

Patent Citation Ranking

Forward Cite Landscape

Maintenance Fees

Full Text

Legal Events

Matter Detail

Renewals Detail

Load PAIR data

Payment Failure

Cancel Scheduled Update

Remove Watch on PAIR

Update PAIR data

PAIR load has been initiated

File History PDF

Add Patents to Portfolio

PATENT NO	7644062
APP PUB NO	20070219969A1
SERIAL NO	11716010
DOCKET NO

US Family Size	Non-US Coverage
Patent Longevity	Forward Citations

DATE PUBLISHED	PUBLICATION/PATENT NO.	PUBLICATION TYPE
January 05, 2010	US,7644062,B2 US7644062B2	GRANTED PATENT AS SECOND PUBLICATION
September 20, 2007	US,20070219969,A1 US20070219969A1	FIRST PUBLISHED PATENT APPLICATION

Free

Premium

Professional

Enterprise

FREE

$9.95/mo

$39.95/mo

$99.95/mo

Free

Premium

Professional

Enterprise

FREE

$9.95/mo

$39.95/mo

$99.95/mo

Please Confirm Your Upgraded Plan Purchase By Selecting Upgrade Button

Free

Premium

Professional

Enterprise

FREE

$9.95/mo

$39.95/mo

$99.95/mo

Please Confirm Your Upgraded Plan Purchase By Selecting Upgrade Button

11716010

Stats

Importance

Abstract

First Claim

Family

Patent Owner(s)

International Classification(s)

Inventor(s)

Cited Art Landscape

Patent Citation Ranking

Forward Cite Landscape

Maintenance Fees

Full Text

Legal Events

Matter Detail

Renewals Detail

Load PAIR data

Payment Failure

Cancel Scheduled Update

Remove Watch on PAIR

Update PAIR data

PAIR load has been initiated

File History PDF

Add to Portfolio(s)

Important Notes on Latency of Status data

Important Note on Priority Date data