IN2013MN00390A - - Google Patents
Info
- Publication number
- IN2013MN00390A IN2013MN00390A IN390MUN2013A IN2013MN00390A IN 2013MN00390 A IN2013MN00390 A IN 2013MN00390A IN 390MUN2013 A IN390MUN2013 A IN 390MUN2013A IN 2013MN00390 A IN2013MN00390 A IN 2013MN00390A
- Authority
- IN
- India
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24539—Query rewriting; Transformation using cached or materialised query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2393—Updating materialised views
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24561—Intermediate data storage techniques for performance improvement
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US37141310P | 2010-08-06 | 2010-08-06 | |
US12/973,811 US8306959B2 (en) | 2010-08-06 | 2010-12-20 | Incremental maintenance of immediate materialized views with outerjoins |
PCT/US2011/046600 WO2012019008A1 (en) | 2010-08-06 | 2011-08-04 | Incremental maintenance of immediate materialized views with outerjoins |
Publications (1)
Publication Number | Publication Date |
---|---|
IN2013MN00390A true IN2013MN00390A (en) | 2015-06-12 |
Family
ID=45559825
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
IN390MUN2013 IN2013MN00390A (en) | 2010-08-06 | 2013-02-26 |
Country Status (5)
Country | Link |
---|---|
US (1) | US8306959B2 (en) |
EP (1) | EP2601600B1 (en) |
CN (1) | CN103168300B (en) |
IN (1) | IN2013MN00390A (en) |
WO (1) | WO2012019008A1 (en) |
Families Citing this family (17)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8799271B2 (en) * | 2011-01-25 | 2014-08-05 | Hewlett-Packard Development Company, L.P. | Range predicate canonization for translating a query |
US9396284B2 (en) * | 2011-05-18 | 2016-07-19 | Oracle International Corporation | Method and system for implementing efficient updatable relational views over XML data |
US9177026B2 (en) * | 2012-09-27 | 2015-11-03 | LogicBlox, Inc. | Leapfrog tree-join |
US9424304B2 (en) * | 2012-12-20 | 2016-08-23 | LogicBlox, Inc. | Maintenance of active database queries |
US9330276B2 (en) * | 2012-12-28 | 2016-05-03 | Sybase, Inc. | Conditional role activation in a database |
US9430543B2 (en) * | 2013-03-15 | 2016-08-30 | Wal-Mart Stores, Inc. | Incrementally updating a large key-value store |
US9703825B2 (en) | 2013-10-17 | 2017-07-11 | Sybase, Inc. | Maintenance of a pre-computed result set |
US10769149B2 (en) * | 2013-12-06 | 2020-09-08 | Micro Focus Llc | Transitive local predicated across multiple joins |
US9690832B2 (en) * | 2014-10-06 | 2017-06-27 | Netapp, Inc. | Enterprise reporting capabilities in storage management systems |
EP3274867A1 (en) | 2015-03-27 | 2018-01-31 | Entit Software LLC | Optimize query based on unique attribute |
CN106855862B (en) * | 2015-12-08 | 2020-09-08 | 中国移动通信集团湖南有限公司 | Rapid comparison method and device |
WO2020057471A1 (en) * | 2018-09-21 | 2020-03-26 | Huawei Technologies Co., Ltd. | Materialized views for database query optimization |
US10795888B2 (en) * | 2018-12-21 | 2020-10-06 | Tableau Software, Inc. | Elimination of query fragment duplication in complex database queries |
CN110175202B (en) * | 2019-04-26 | 2021-09-10 | 蚂蚁金服(杭州)网络技术有限公司 | Method and system for external connection of tables of a database |
US10885035B2 (en) | 2019-04-26 | 2021-01-05 | Advanced New Technologies Co., Ltd. | Method and system for outer join of database tables |
CN112818010B (en) * | 2019-11-15 | 2022-06-07 | 华为技术有限公司 | Database query method and device |
CN113204568A (en) * | 2021-05-26 | 2021-08-03 | 上海达梦数据库有限公司 | Method, device, equipment and storage medium for optimizing structured query statement |
Family Cites Families (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6763352B2 (en) | 1999-05-21 | 2004-07-13 | International Business Machines Corporation | Incremental maintenance of summary tables with complex grouping expressions |
US6882993B1 (en) * | 2002-01-28 | 2005-04-19 | Oracle International Corporation | Incremental refresh of materialized views with joins and aggregates after arbitrary DML operations to multiple tables |
US7184998B2 (en) | 2002-06-29 | 2007-02-27 | Sybase, Inc. | System and methodology for generating bushy trees using a left-deep tree join enumeration algorithm |
US7020649B2 (en) * | 2002-12-30 | 2006-03-28 | International Business Machines Corporation | System and method for incrementally maintaining non-distributive aggregate functions in a relational database |
CN1763744A (en) * | 2004-08-24 | 2006-04-26 | 微软公司 | Partially materialized views |
US7467128B2 (en) | 2006-02-15 | 2008-12-16 | Microsoft Corporation | Maintenance of materialized outer-join views |
US7555502B2 (en) | 2006-03-10 | 2009-06-30 | Oracle International Corporation | Detecting database events using recovery logs |
US7546311B2 (en) | 2006-11-30 | 2009-06-09 | Ianywhere Solutions, Inc. | Optimization of left and right outer join operations in database management systems |
US7606827B2 (en) | 2006-12-14 | 2009-10-20 | Ianywhere Solutions, Inc. | Query optimization using materialized views in database management systems |
US20090064160A1 (en) | 2007-08-31 | 2009-03-05 | Microsoft Corporation | Transparent lazy maintenance of indexes and materialized views |
CN101127045B (en) * | 2007-09-25 | 2010-04-21 | 中兴通讯股份有限公司 | Database repeatable reading implement method, device and database management system |
CN101241503B (en) * | 2008-01-03 | 2011-09-07 | 彭智勇 | Database personalized method |
US8065269B2 (en) | 2008-12-19 | 2011-11-22 | Ianywhere Solutions, Inc. | Immediate maintenance of materialized views |
-
2010
- 2010-12-20 US US12/973,811 patent/US8306959B2/en active Active
-
2011
- 2011-08-04 EP EP11815322.0A patent/EP2601600B1/en active Active
- 2011-08-04 WO PCT/US2011/046600 patent/WO2012019008A1/en active Application Filing
- 2011-08-04 CN CN201180038929.8A patent/CN103168300B/en active Active
-
2013
- 2013-02-26 IN IN390MUN2013 patent/IN2013MN00390A/en unknown
Also Published As
Publication number | Publication date |
---|---|
EP2601600B1 (en) | 2023-10-04 |
US8306959B2 (en) | 2012-11-06 |
EP2601600A4 (en) | 2017-08-30 |
US20120047117A1 (en) | 2012-02-23 |
CN103168300B (en) | 2016-06-01 |
EP2601600A1 (en) | 2013-06-12 |
WO2012019008A1 (en) | 2012-02-09 |
CN103168300A (en) | 2013-06-19 |