EP 1066574 A4 20060913 - PROCESSING PRECOMPUTED VIEWS
Title (en)
PROCESSING PRECOMPUTED VIEWS
Title (de)
VERARBEITUNG VON PRECOMPUTERISIERTER SICHT
Title (fr)
TRAITEMENT DE VUES PRECALCULEES
Publication
Application
Priority
- US 9906297 W 19990325
- US 7967998 P 19980327
- US 7967198 P 19980327
- US 7967098 P 19980327
- US 4978498 A 19980327
Abstract (en)
[origin: WO9950762A1] A user database query (90) on precomputation strategy effectivenes is responded to by defining, based upon user database query history, an analysis space consisting of a subset of all possible views for the database (104), and by characterizing the views in the analysis space. A structure is imposed on an analysis space consisting of a subset of all possible views for the database based upon the capabilities of a query rewriting facility (92), and the views in the analysis space is characterized. A cost formula is applied to the analysis space based upon a user-defined subset of the data contained in the database. The analysis space includes a candidate view composed of a combination of two or more constituent views is defined. A user query on the database is analyzed, and a candidate view based upon the user query is generated. A system for answering user queries on a database stored on a server includes a query processing system (18) integrated into the server and configured to respond to user queries, and a query processing system integrated into the server and configured to process precomputed results (38) of user queries on the database.
IPC 1-7
IPC 8 full level
G06F 17/30 (2006.01)
CPC (source: EP US)
G06F 16/22 (2018.12 - EP US); G06F 16/24539 (2018.12 - EP US); G06F 16/24556 (2018.12 - EP US); Y10S 707/99932 (2013.01 - US); Y10S 707/99933 (2013.01 - US); Y10S 707/99934 (2013.01 - US); Y10S 707/99943 (2013.01 - US); Y10S 707/99952 (2013.01 - US)
Citation (search report)
- [A] US 5276870 A 19940104 - SHAN MING-CHIEN [US], et al
- [A] WO 9809238 A1 19980305 - AT & T CORP [US]
- [X] COLBY L S ET AL: "Red Brick Vista<TM>: aggregate computation and management", DATA ENGINEERING, 1998. PROCEEDINGS., 14TH INTERNATIONAL CONFERENCE ON ORLANDO, FL, USA 23-27 FEB. 1998, LOS ALAMITOS, CA, USA,IEEE COMPUT. SOC, US, 23 February 1998 (1998-02-23), pages 174 - 177, XP010268314, ISBN: 0-8186-8289-2
- [X] BARALIS E ET AL: "Materialized view selection in a multidimensional database", PROCEEDINGS OF THE TWENTY-THIRD INTERNATIONAL CONFERENCE ON VERY LARGE DATABASES MORGAN KAUFMANN PUBLISHERS SAN FRANCISCO, CA, USA, 1997, pages 156 - 165, XP002391985, ISBN: 1-55860-470-7
- [X] SOUTYRINA E ET AL: "Optimal view selection for multidimensional database systems", DATABASE ENGINEERING AND APPLICATIONS SYMPOSIUM, 1997. IDEAS '97. PROCEEDINGS., INTERNATIONAL MONTREAL, QUE., CANADA 25-27 AUG. 1997, LOS ALAMITOS, CA, USA,IEEE COMPUT. SOC, US, 25 August 1997 (1997-08-25), pages 45 - 52, XP010250126, ISBN: 0-8186-8114-4
- [A] JIM GRAY ET AL: "Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals", JOURNAL OF DATA MINING AND KNOWLEDGE DISCOVERY, NORWELL, MA, US, 1997, pages 29 - 53, XP002901286, ISSN: 1384-5810
- See references of WO 9950762A1
Designated contracting state (EPC)
DE ES FR GB IE IT SE
DOCDB simple family (publication)
WO 9950762 A1 19991007; AU 3198599 A 19991018; AU 761900 B2 20030612; BR 9909896 A 20010911; CA 2326513 A1 19991007; CA 2326513 C 20090616; EP 1066574 A1 20010110; EP 1066574 A4 20060913; JP 2002510088 A 20020402; US 2001013030 A1 20010809; US 2002077997 A1 20020620; US 6480836 B1 20021112; US 6493699 B2 20021210; US 6594653 B2 20030715
DOCDB simple family (application)
US 9906297 W 19990325; AU 3198599 A 19990325; BR 9909896 A 19990325; CA 2326513 A 19990325; EP 99914054 A 19990325; JP 2000541606 A 19990325; US 27703499 A 19990325; US 27704099 A 19990325; US 27704199 A 19990325