EP 1645977 A3 20061108 - Partially materialized views
Title (en)
Partially materialized views
Title (de)
Teilweise verwirklichte Ansichten
Title (fr)
Vues partiellement matérialisées
Publication
Application
Priority
- US 60440104 P 20040824
- US 97160004 A 20041021
Abstract (en)
[origin: US2006047696A1] Partially materialized views in the field of database systems are described herein. A method of partially materializing a view computed from one or more source tables comprises generating a view definition including a query expression and at least one control predicate referencing at least one control table. The query expression specifies the maximal content of the view, that is, the complete set of records that could be materialized. One or more control predicates and the contents of one or more control tables restrict what records are actually materialized and stored in the view. This allows the content of the partially materialized view to be adjusted simply by updating one or more control tables.
IPC 8 full level
G06F 17/30 (2006.01)
CPC (source: EP KR US)
G06F 16/2393 (2018.12 - EP US); G06F 16/24539 (2018.12 - EP US); G06F 16/24552 (2018.12 - EP US); G06F 17/40 (2013.01 - KR)
Citation (search report)
- [A] US 2004034616 A1 20040219 - WITKOWSKI ANDREW [US], et al
- [X] LARSON P-A ET AL: "MTCache: Mid-Tier Database Caching for SQL Server", IEEE DATA ENG. BULL. [JOURNAL], vol. 27, no. 2, June 2004 (2004-06-01), pages 35 - 40, XP002399988, Retrieved from the Internet <URL:http://sites.computer.org/debull/A04JUN-CD.pdf#search=%22MTCache%20control%20OR%20table%20%22Guo%22%22> [retrieved on 20060921]
- [X] LARSON P-A ET AL: "MTCache: transparent mid-tier database caching in SQL server", DATA ENGINEERING, 2004. PROCEEDINGS. 20TH INTERNATIONAL CONFERENCE ON BOSTON, MA, USA 30 MARCH - 2 APRIL 2004, PISCATAWAY, NJ, USA,IEEE, 30 March 2004 (2004-03-30), pages 177 - 188, XP010713763, ISBN: 0-7695-2065-0
Designated contracting state (EPC)
AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IS IT LI LT LU LV MC NL PL PT RO SE SI SK TR
Designated extension state (EPC)
AL BA HR MK YU
DOCDB simple family (publication)
US 2006047696 A1 20060302; EP 1645977 A2 20060412; EP 1645977 A3 20061108; JP 2006065846 A 20060309; KR 20060049851 A 20060519
DOCDB simple family (application)
US 97160004 A 20041021; EP 05107182 A 20050804; JP 2005213191 A 20050722; KR 20050060259 A 20050705