Interaction event details using search services
US-2024184779-A1 · Jun 6, 2024 · US
Using join dependencies for refresh
US8996502B2 · US · B2
| Field | Value |
|---|---|
| Publication number | US-8996502-B2 |
| Application number | US-8383005-A |
| Country | US |
| Kind code | B2 |
| Filing date | Mar 18, 2005 |
| Priority date | May 17, 2004 |
| Publication date | Mar 31, 2015 |
| Grant date | Mar 31, 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.
In an embodiment, Partition Change Tracking (PCT) refresh is performed by using join dependencies on partitioning columns to derive and fill in identifiers of rows and/or partitions containing the rows in the refresh expressions. In an embodiment, the join dependencies that form the Materialized View's (MV's) query definition and the partitioning predicate of the table are used to automatically generate a statement which is run in order to derive and fill in identifiers of the rows and/or partitions that are being changed. The identifiers are then plugged into the refresh expression, and the refresh expression is run. Running the refresh expression causes the rows identified to be refreshed.
First claim
Opening claim text (preview).
The invention claimed is: 1. A machine-implemented method, comprising: evaluating a definition of a materialized view based on a base table, wherein the base table is partitioned into a plurality of partitions based on a partition key; wherein the step of evaluating includes determining that the definition is based on a join dependency of the partition key of said base table; and based on the evaluating, generating a refresh expression that includes a restriction based on sai…
Assignees
Inventors
Classifications
- G06F16/24539Primary
Physics · mapped topic
Physics · mapped topic
Physics · mapped topic
- G06F17/30457Primary
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 US8996502B2 cover?
- In an embodiment, Partition Change Tracking (PCT) refresh is performed by using join dependencies on partitioning columns to derive and fill in identifiers of rows and/or partitions containing the rows in the refresh expressions. In an embodiment, the join dependencies that form the Materialized View's (MV's) query definition and the partitioning predicate of the table are used to automatically…
- Who is the assignee on this patent?
- Folkert Nathaniel Keith, Gupta Abhinav, Witkowski Andrew, and 1 more
- What technology area does this patent fall under?
- Primary CPC classification G06F16/24539. Mapped technology areas include Physics.
- When was this patent published?
- Publication date Tue Mar 31 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).