Dynamic valuation system using object relationships and composite object data
US-2024427780-A1 · Dec 26, 2024 · US
Optimizing a query to a partitioned database table using a virtual maintained temporary index that spans multiple database partitions
US8935231B2 · US · B2
| Field | Value |
|---|---|
| Publication number | US-8935231-B2 |
| Application number | US-12058208-A |
| Country | US |
| Kind code | B2 |
| Filing date | May 14, 2008 |
| Priority date | Mar 23, 2006 |
| Publication date | Jan 13, 2015 |
| Grant date | Jan 13, 2015 |
How to read this patent
A practical reading order for non-experts. Skip the full description unless you need deep technical detail.
- Title
What the patent document calls the invention.
- Abstract
A short plain-language summary of the technical disclosure.
- Assignees and inventors
Who owns or filed the patent and who is credited as inventor.
- Key dates
Filing, priority, publication, and grant dates set the timeline.
- First independent claim
The legal scope of protection — read this for what is actually claimed.
- CPC / IPC classifications
Technology tags used to group this patent with similar filings.
- Citations and related patents
Prior art links and similar publications in this corpus.
Abstract
Official abstract text for this publication.
A query optimizer optimizes a query to a partitioned database table by determining common characteristics of the partitions and generating a virtual maintained temporary index that spans multiple partitions. Using the virtual maintained temporary index allows the query optimizer to generate an access plan based on the virtual maintained temporary index, which relieves the optimizer from having to individually optimize access to each partition for partitions that share common characteristics.
First claim
Opening claim text (preview).
The invention claimed is: 1. An apparatus comprising: at least one processor; a memory coupled to the at least one processor; and a query optimizer residing in the memory and executed by the at least one processor, the query optimizer generating a virtual maintained temporary index that spans a plurality of partitions in a partitioned database table, wherein the query optimizer creates an access plan for a query that references the partitioned database table, wherein the acces…
Assignees
Inventors
Classifications
- G06F16/2246Primary
Physics · mapped topic
- G06F17/30327Primary
Physics · mapped topic
Patent family
Related publications grouped by family.
External sources
Next steps
Free tools are coming soon. Tell us what you want to track and we'll notify you.
Frequently asked questions
Answers are generated from the same data shown on this page.
- What does patent US8935231B2 cover?
- A query optimizer optimizes a query to a partitioned database table by determining common characteristics of the partitions and generating a virtual maintained temporary index that spans multiple partitions. Using the virtual maintained temporary index allows the query optimizer to generate an access plan based on the virtual maintained temporary index, which relieves the optimizer from having …
- Who is the assignee on this patent?
- Bestgen Robert Joseph, Downer Robert Victor, Kethireddy Shantan, and 1 more
- What technology area does this patent fall under?
- Primary CPC classification G06F16/2246. Mapped technology areas include Physics.
- When was this patent published?
- Publication date Tue Jan 13 2015 00:00:00 GMT+0000 (Coordinated Universal Time) (B2). Legal status and post-grant events are not shown on this page.
- What related patents are in patentsdb?
- We list 8 related publications on this page (citations in our corpus or others sharing the same primary CPC).