WO2001093105A3 - System and method for automatically generating database queries - Google Patents
System and method for automatically generating database queries Download PDFInfo
- Publication number
- WO2001093105A3 WO2001093105A3 PCT/US2001/017171 US0117171W WO0193105A3 WO 2001093105 A3 WO2001093105 A3 WO 2001093105A3 US 0117171 W US0117171 W US 0117171W WO 0193105 A3 WO0193105 A3 WO 0193105A3
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- database query
- automatically generating
- database queries
- generating database
- tuning
- Prior art date
Links
- 238000000034 method Methods 0.000 title abstract 2
- 238000005457 optimization Methods 0.000 abstract 3
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
-
- 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/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
Abstract
Priority Applications (8)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
EP01939541.7A EP1350184B1 (en) | 2000-05-26 | 2001-05-25 | System and method for automatically generating database queries |
AU6504801A AU6504801A (en) | 2000-05-26 | 2001-05-25 | System and method for automatically generating database queries |
AU2001265048A AU2001265048B2 (en) | 2000-05-26 | 2001-05-25 | System and method for automatically generating database queries |
CA002409276A CA2409276A1 (en) | 2000-05-26 | 2001-05-25 | System and method for automatically generating database queries |
BR0111192-2A BR0111192A (en) | 2000-05-26 | 2001-05-25 | System and method for automatically generating database queries |
JP2002500250A JP2004509382A (en) | 2000-05-26 | 2001-05-25 | System and method for automatically generating database queries |
IL15298701A IL152987A0 (en) | 2000-05-26 | 2001-05-25 | System and method for automatically generating database queries |
IL152987A IL152987A (en) | 2000-05-26 | 2002-11-20 | System and method for automatically generating database queries |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US20737900P | 2000-05-26 | 2000-05-26 | |
US60/207,379 | 2000-05-26 |
Publications (2)
Publication Number | Publication Date |
---|---|
WO2001093105A2 WO2001093105A2 (en) | 2001-12-06 |
WO2001093105A3 true WO2001093105A3 (en) | 2003-07-31 |
Family
ID=22770299
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/US2001/017171 WO2001093105A2 (en) | 2000-05-26 | 2001-05-25 | System and method for automatically generating database queries |
Country Status (10)
Country | Link |
---|---|
US (1) | US8019750B2 (en) |
EP (1) | EP1350184B1 (en) |
JP (1) | JP2004509382A (en) |
KR (1) | KR20030047889A (en) |
CN (1) | CN1592905A (en) |
AU (2) | AU6504801A (en) |
BR (1) | BR0111192A (en) |
CA (1) | CA2409276A1 (en) |
IL (2) | IL152987A0 (en) |
WO (1) | WO2001093105A2 (en) |
Families Citing this family (66)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8910241B2 (en) * | 2002-04-25 | 2014-12-09 | Citrix Systems, Inc. | Computer security system |
US7805411B2 (en) | 2003-09-06 | 2010-09-28 | Oracle International Corporation | Auto-tuning SQL statements |
US7587394B2 (en) * | 2003-09-23 | 2009-09-08 | International Business Machines Corporation | Methods and apparatus for query rewrite with auxiliary attributes in query processing operations |
US7132796B2 (en) | 2003-12-30 | 2006-11-07 | Lg.Philips Lcd Co., Ltd | Organic electroluminescent device and method of fabricating the same |
US7343367B2 (en) * | 2005-05-12 | 2008-03-11 | International Business Machines Corporation | Optimizing a database query that returns a predetermined number of rows using a generated optimized access plan |
US20070143246A1 (en) * | 2005-12-15 | 2007-06-21 | International Business Machines Corporation | Method and apparatus for analyzing the effect of different execution parameters on the performance of a database query |
US7882121B2 (en) * | 2006-01-27 | 2011-02-01 | Microsoft Corporation | Generating queries using cardinality constraints |
US7702658B2 (en) * | 2006-01-27 | 2010-04-20 | International Business Machines Corporation | Method for optimistic locking using SQL select, update, delete, and insert statements |
US8903763B2 (en) | 2006-02-21 | 2014-12-02 | International Business Machines Corporation | Method, system, and program product for transferring document attributes |
CN100403314C (en) * | 2006-04-19 | 2008-07-16 | 华为技术有限公司 | Data inquiry method |
CN101093493B (en) * | 2006-06-23 | 2011-08-31 | 国际商业机器公司 | Speech conversion method for database inquiry and converter |
US20080040334A1 (en) * | 2006-08-09 | 2008-02-14 | Gad Haber | Operation of Relational Database Optimizers by Inserting Redundant Sub-Queries in Complex Queries |
US8694524B1 (en) * | 2006-08-28 | 2014-04-08 | Teradata Us, Inc. | Parsing a query |
US20080126393A1 (en) * | 2006-11-29 | 2008-05-29 | Bossman Patrick D | Computer program product and system for annotating a problem sql statement for improved understanding |
US8019771B2 (en) * | 2006-11-30 | 2011-09-13 | International Business Machines Corporation | Method for dynamically finding relations between database tables |
US10255583B2 (en) * | 2007-05-01 | 2019-04-09 | Oracle International Corporation | Nested hierarchical rollups by level using a normalized table |
CN100498793C (en) * | 2007-06-08 | 2009-06-10 | 北京神舟航天软件技术有限公司 | Method for realizing two-dimensional predicate selectivity estimation by using wavelet-based compressed histogram |
US8065329B2 (en) * | 2007-06-18 | 2011-11-22 | Oracle International Corporation | Query optimization on VPD protected columns |
US8112421B2 (en) | 2007-07-20 | 2012-02-07 | Microsoft Corporation | Query selection for effectively learning ranking functions |
US7774318B2 (en) | 2007-07-30 | 2010-08-10 | Sap Ag | Method and system for fast deletion of database information |
US9009181B2 (en) | 2007-08-23 | 2015-04-14 | International Business Machines Corporation | Accessing objects in a service registry and repository |
US7783656B2 (en) * | 2007-09-24 | 2010-08-24 | International Business Machines Corporation | Accessing objects in a service registry and repository using a treat as function |
US8903801B2 (en) * | 2007-09-14 | 2014-12-02 | Oracle International Corporation | Fully automated SQL tuning |
US9189522B2 (en) | 2007-10-17 | 2015-11-17 | Oracle International Corporation | SQL execution plan baselines |
US8516539B2 (en) * | 2007-11-09 | 2013-08-20 | Citrix Systems, Inc | System and method for inferring access policies from access event records |
US8990910B2 (en) * | 2007-11-13 | 2015-03-24 | Citrix Systems, Inc. | System and method using globally unique identities |
CN101436192B (en) * | 2007-11-16 | 2011-03-16 | 国际商业机器公司 | Method and apparatus for optimizing inquiry aiming at vertical storage type database |
US7827153B2 (en) * | 2007-12-19 | 2010-11-02 | Sap Ag | System and method to perform bulk operation database cleanup |
US9240945B2 (en) * | 2008-03-19 | 2016-01-19 | Citrix Systems, Inc. | Access, priority and bandwidth management based on application identity |
US8943575B2 (en) * | 2008-04-30 | 2015-01-27 | Citrix Systems, Inc. | Method and system for policy simulation |
US8150865B2 (en) * | 2008-07-29 | 2012-04-03 | Oracle International Corporation | Techniques for coalescing subqueries |
US8990573B2 (en) * | 2008-11-10 | 2015-03-24 | Citrix Systems, Inc. | System and method for using variable security tag location in network communications |
US8065323B2 (en) * | 2009-02-23 | 2011-11-22 | Oracle International Corporation | Offline validation of data in a database system for foreign key constraints |
US8452754B2 (en) * | 2009-05-08 | 2013-05-28 | Microsoft Corporation | Static analysis framework for database applications |
US8555263B2 (en) * | 2010-01-20 | 2013-10-08 | Aetna Inc. | System and method for code automation |
US10311105B2 (en) * | 2010-12-28 | 2019-06-04 | Microsoft Technology Licensing, Llc | Filtering queried data on data stores |
US8880508B2 (en) * | 2010-12-30 | 2014-11-04 | Sap Se | Processing database queries using format conversion |
US8694525B2 (en) * | 2011-06-24 | 2014-04-08 | Sas Institute Inc. | Systems and methods for performing index joins using auto generative queries |
CN102968420B (en) * | 2011-08-31 | 2016-05-04 | 国际商业机器公司 | The method and system of data base querying |
GB2505183A (en) * | 2012-08-21 | 2014-02-26 | Ibm | Discovering composite keys |
US10726010B2 (en) * | 2012-09-04 | 2020-07-28 | Oracle International Corporation | Optimization technique of generalized disjunctive semi/anti join |
KR101432700B1 (en) * | 2012-10-10 | 2014-08-25 | (주)티베로 | Method for optimizing query |
US10592506B1 (en) * | 2013-02-13 | 2020-03-17 | Amazon Technologies, Inc. | Query hint specification |
US9146984B1 (en) * | 2013-03-15 | 2015-09-29 | Google Inc. | Enhancing queries for data tables with nested fields |
US20150039555A1 (en) * | 2013-08-02 | 2015-02-05 | International Business Machines Corporation | Heuristically modifying dbms environments using performance analytics |
US10394807B2 (en) * | 2013-11-27 | 2019-08-27 | Paraccel Llc | Rewrite constraints for database queries |
US10621064B2 (en) | 2014-07-07 | 2020-04-14 | Oracle International Corporation | Proactive impact measurement of database changes on production systems |
US9779136B2 (en) * | 2014-09-30 | 2017-10-03 | Linkedin Corporation | Rearranging search operators |
CN104881460A (en) * | 2015-05-22 | 2015-09-02 | 国云科技股份有限公司 | Method for achieving multi-line data combing to one line to display based on Oracle database |
US10229358B2 (en) * | 2015-08-07 | 2019-03-12 | International Business Machines Corporation | Optimizer problem determination |
CN106598963B (en) * | 2015-10-14 | 2021-08-10 | 五八同城信息技术有限公司 | Query statement optimization method and device |
US10210223B2 (en) | 2015-10-27 | 2019-02-19 | International Business Machines Corporation | Executing conditions with negation operators in analytical databases |
US10558458B2 (en) * | 2016-06-06 | 2020-02-11 | Microsoft Technology Licensing, Llc | Query optimizer for CPU utilization and code refactoring |
KR101797483B1 (en) | 2016-07-19 | 2017-11-15 | 주식회사 티맥스데이터 | Technique for processing query in database management system |
CN106919678A (en) * | 2017-02-27 | 2017-07-04 | 武汉珞佳伟业科技有限公司 | A kind of database inquiry optimization system and method |
US11386058B2 (en) | 2017-09-29 | 2022-07-12 | Oracle International Corporation | Rule-based autonomous database cloud service framework |
US11327932B2 (en) | 2017-09-30 | 2022-05-10 | Oracle International Corporation | Autonomous multitenant database cloud service framework |
US10354203B1 (en) * | 2018-01-31 | 2019-07-16 | Sentio Software, Llc | Systems and methods for continuous active machine learning with document review quality monitoring |
US10733187B2 (en) * | 2018-02-09 | 2020-08-04 | International Business Machines Corporation | Transforming a scalar subquery |
JP7044086B2 (en) | 2019-03-15 | 2022-03-30 | オムロン株式会社 | Control systems, control methods, and control programs |
US11100104B2 (en) * | 2019-04-09 | 2021-08-24 | Accenture Global Solutions Limited | Query tuning utilizing optimizer hints |
US11151131B2 (en) | 2019-07-19 | 2021-10-19 | Bank Of America Corporation | Query generation from a natural language input |
US11409744B2 (en) * | 2019-08-01 | 2022-08-09 | Thoughtspot, Inc. | Query generation based on merger of subqueries |
CN111209305B (en) * | 2019-11-19 | 2023-07-18 | 华为云计算技术有限公司 | Method for querying data, data node, distributed database and computing device |
US11755579B2 (en) * | 2021-08-04 | 2023-09-12 | Cysiv, Inc. | Database system with run-time query mode selection |
US11847121B2 (en) | 2021-08-27 | 2023-12-19 | International Business Machines Corporation | Compound predicate query statement transformation |
Family Cites Families (21)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH022459A (en) | 1987-12-11 | 1990-01-08 | Hewlett Packard Co <Hp> | Inquiry processing |
US5555409A (en) | 1990-12-04 | 1996-09-10 | Applied Technical Sysytem, Inc. | Data management systems and methods including creation of composite views of data |
US5347653A (en) | 1991-06-28 | 1994-09-13 | Digital Equipment Corporation | System for reconstructing prior versions of indexes using records indicating changes between successive versions of the indexes |
US5421008A (en) * | 1991-11-08 | 1995-05-30 | International Business Machines Corporation | System for interactive graphical construction of a data base query and storing of the query object links as an object |
US5404510A (en) | 1992-05-21 | 1995-04-04 | Oracle Corporation | Database index design based upon request importance and the reuse and modification of similar existing indexes |
US6259896B1 (en) * | 1994-02-15 | 2001-07-10 | Nokia Mobile Phones Limited | Device for radio communication |
US5560007A (en) | 1993-06-30 | 1996-09-24 | Borland International, Inc. | B-tree key-range bit map index optimization of database queries |
US5675785A (en) | 1994-10-04 | 1997-10-07 | Hewlett-Packard Company | Data warehouse which is accessed by a user using a schema of virtual tables |
US5758145A (en) | 1995-02-24 | 1998-05-26 | International Business Machines Corporation | Method and apparatus for generating dynamic and hybrid sparse indices for workfiles used in SQL queries |
US5806062A (en) * | 1995-10-17 | 1998-09-08 | Lucent Technologies Inc. | Data analysis system using virtual databases |
US5745904A (en) | 1996-01-12 | 1998-04-28 | Microsoft Corporation | Buffered table user index |
US6061676A (en) * | 1996-05-29 | 2000-05-09 | Lucent Technologies Inc. | Effecting constraint magic rewriting on a query with the multiset version of the relational algebric theta-semijoin operator |
US5761654A (en) * | 1996-06-05 | 1998-06-02 | Oracle Corporation | Memory structure and method for tuning a database statement using a join-tree data structure representation, including selectivity factors, of a master table and detail table |
US5765168A (en) | 1996-08-09 | 1998-06-09 | Digital Equipment Corporation | Method for maintaining an index |
US5765147A (en) | 1996-11-21 | 1998-06-09 | International Business Machines Corportion | Query rewrite for extended search capabilities |
US5956707A (en) * | 1997-02-13 | 1999-09-21 | Chu; Wesley W. | Database system with query relaxation using type abstraction hierarchy (TAH) as query condition relaxation structure |
US6363377B1 (en) * | 1998-07-30 | 2002-03-26 | Sarnoff Corporation | Search data processor |
US6434545B1 (en) * | 1998-12-16 | 2002-08-13 | Microsoft Corporation | Graphical query analyzer |
US6205441B1 (en) * | 1999-03-31 | 2001-03-20 | Compaq Computer Corporation | System and method for reducing compile time in a top down rule based system using rule heuristics based upon the predicted resulting data flow |
EP1109117A1 (en) * | 1999-12-14 | 2001-06-20 | Sun Microsystems, Inc. | Method for converting table data between a database representation and a representation in tag language |
US7805411B2 (en) * | 2003-09-06 | 2010-09-28 | Oracle International Corporation | Auto-tuning SQL statements |
-
2001
- 2001-05-25 KR KR1020027016062A patent/KR20030047889A/en not_active Application Discontinuation
- 2001-05-25 CN CNA018118208A patent/CN1592905A/en active Pending
- 2001-05-25 AU AU6504801A patent/AU6504801A/en active Pending
- 2001-05-25 AU AU2001265048A patent/AU2001265048B2/en not_active Ceased
- 2001-05-25 BR BR0111192-2A patent/BR0111192A/en not_active IP Right Cessation
- 2001-05-25 EP EP01939541.7A patent/EP1350184B1/en not_active Expired - Lifetime
- 2001-05-25 WO PCT/US2001/017171 patent/WO2001093105A2/en active Application Filing
- 2001-05-25 JP JP2002500250A patent/JP2004509382A/en active Pending
- 2001-05-25 IL IL15298701A patent/IL152987A0/en unknown
- 2001-05-25 CA CA002409276A patent/CA2409276A1/en not_active Abandoned
-
2002
- 2002-11-20 IL IL152987A patent/IL152987A/en not_active IP Right Cessation
-
2006
- 2006-01-09 US US11/327,945 patent/US8019750B2/en not_active Expired - Fee Related
Non-Patent Citations (3)
Title |
---|
DON BURLESON: "Platinum Plan Analyzer", DBMS, March 1996 (1996-03-01), XP002229597, Retrieved from the Internet <URL:http://web.archive.org/web/20000229044247/http://dbmsmag.com/9603d08.html> [retrieved on 20030128] * |
ORACLE: "Oracle Enterprise Manager Concepts Guide 2.1", ORACLE, 18 November 1999 (1999-11-18), pages 5.10 - 5.13, XP002229596, Retrieved from the Internet <URL:http://download-east.oracle.com/docs/pdf/A75684_01.pdf> [retrieved on 20030128] * |
ORACLE: "Oracle8i Designing and Tuning for Performance", ORACLE, December 1999 (1999-12-01), pages 4.1 - 4.94, XP002229598, Retrieved from the Internet <URL:http://otn.oracle.com/doc/oracle8i_816/server.816/a76992.pdf> [retrieved on 20030128] * |
Also Published As
Publication number | Publication date |
---|---|
JP2004509382A (en) | 2004-03-25 |
BR0111192A (en) | 2005-05-10 |
KR20030047889A (en) | 2003-06-18 |
US20070038618A1 (en) | 2007-02-15 |
EP1350184B1 (en) | 2014-11-19 |
WO2001093105A2 (en) | 2001-12-06 |
IL152987A0 (en) | 2003-06-24 |
CA2409276A1 (en) | 2001-12-06 |
IL152987A (en) | 2009-05-04 |
CN1592905A (en) | 2005-03-09 |
US8019750B2 (en) | 2011-09-13 |
AU6504801A (en) | 2001-12-11 |
EP1350184A2 (en) | 2003-10-08 |
AU2001265048B2 (en) | 2007-10-18 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2001093105A3 (en) | System and method for automatically generating database queries | |
WO2002067146A3 (en) | Query resolution system | |
CA2410798A1 (en) | System and method allowing advertisers to manage search listings in a pay for placement search system using grouping | |
EP2562663A3 (en) | Parent-child query indexing for XML databases | |
WO2001001288A3 (en) | System and method for creating and titling reports using an integrated title bar and navigator | |
WO2004097671A3 (en) | A system and method for generating refinement categories for a set of search results | |
AU2001239784A1 (en) | System and method for automatic loading of an xml document defined by a document-type definition into a relational database including the generation of a relational schema therefor | |
WO2004104729A3 (en) | System and method for query result caching | |
WO2008057181A3 (en) | A computer-implemented method and system for enabling communication between networked users based on common characteristics | |
WO2001073591A3 (en) | Systems and methods for providing distributed cross-enterprise portals | |
AU2002368176A1 (en) | System, method and apparatus for conducting a keyterm search | |
WO2001009754A3 (en) | Modular method and system for performing database queries | |
WO2003107127A3 (en) | System and method for personalized information retrieval based on user expertise | |
WO2002006999A3 (en) | Performing spreadsheet-like calculations in a database system | |
AU2001257232A1 (en) | Generic attribute database system | |
WO2005098681A3 (en) | Method and apparatus for virtual content access systems built on a content routing network | |
WO2001069400A3 (en) | Mobile navigation of network-based electronic information using spoken input | |
WO2002061622A3 (en) | Technique for encapsulating a query definition | |
WO2005029356A3 (en) | Method, system and program for data synchronization | |
WO2002077873A3 (en) | System, method and apparatus for conducting a phrase search | |
EP1050830A3 (en) | System and method for collaborative ranking of search results employing user and group profiles | |
WO2005062210A8 (en) | Methods and systems for personalized network searching | |
WO2005062746A3 (en) | System and method for customizing search results based on searcher’s actual geographic location | |
WO2003030031A3 (en) | Mechanism for mapping xml schemas to object-relational database systems | |
WO2003060649A3 (en) | Method and apparatus for consuming information based on a geographic location profile of a user |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AK | Designated states |
Kind code of ref document: A2 Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG UZ VN YU ZA ZW |
|
AL | Designated countries for regional patents |
Kind code of ref document: A2 Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE TR BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application | ||
DFPE | Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101) | ||
REG | Reference to national code |
Ref country code: DE Ref legal event code: 8642 |
|
WWE | Wipo information: entry into national phase |
Ref document number: 2001939541 Country of ref document: EP |
|
WWE | Wipo information: entry into national phase |
Ref document number: 2409276 Country of ref document: CA Ref document number: 200209355 Country of ref document: ZA |
|
WWE | Wipo information: entry into national phase |
Ref document number: 152987 Country of ref document: IL Ref document number: IN/PCT/2002/01650/MU Country of ref document: IN |
|
WWE | Wipo information: entry into national phase |
Ref document number: 2001265048 Country of ref document: AU Ref document number: 1020027016062 Country of ref document: KR |
|
WWE | Wipo information: entry into national phase |
Ref document number: 018118208 Country of ref document: CN |
|
WWP | Wipo information: published in national office |
Ref document number: 1020027016062 Country of ref document: KR |
|
WWP | Wipo information: published in national office |
Ref document number: 2001939541 Country of ref document: EP |