SG11201804544QA - Data query method and apparatus, and database system - Google Patents
Data query method and apparatus, and database systemInfo
- Publication number
- SG11201804544QA SG11201804544QA SG11201804544QA SG11201804544QA SG11201804544QA SG 11201804544Q A SG11201804544Q A SG 11201804544QA SG 11201804544Q A SG11201804544Q A SG 11201804544QA SG 11201804544Q A SG11201804544Q A SG 11201804544QA SG 11201804544Q A SG11201804544Q A SG 11201804544QA
- Authority
- SG
- Singapore
- Prior art keywords
- query plan
- query
- plan
- original
- database system
- Prior art date
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/24542—Plan optimisation
- G06F16/24544—Join order optimisation
-
- 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
-
- 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/24542—Plan optimisation
- G06F16/24545—Selectivity estimation or determination
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Operations Research (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
PCT/CN2015/095909 WO2017091925A1 (zh) | 2015-11-30 | 2015-11-30 | 数据查询的方法、装置和数据库系统 |
Publications (1)
Publication Number | Publication Date |
---|---|
SG11201804544QA true SG11201804544QA (en) | 2018-06-28 |
Family
ID=58796008
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
SG11201804544QA SG11201804544QA (en) | 2015-11-30 | 2015-11-30 | Data query method and apparatus, and database system |
Country Status (8)
Country | Link |
---|---|
US (1) | US10885034B2 (zh) |
EP (1) | EP3373154A4 (zh) |
JP (1) | JP6628455B2 (zh) |
KR (1) | KR102138627B1 (zh) |
CN (1) | CN107251013B (zh) |
BR (1) | BR112018010857B1 (zh) |
SG (1) | SG11201804544QA (zh) |
WO (1) | WO2017091925A1 (zh) |
Families Citing this family (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP6707797B2 (ja) * | 2017-03-29 | 2020-06-10 | 株式会社日立製作所 | データベース管理システム及びデータベース管理方法 |
CN108664516A (zh) * | 2017-03-31 | 2018-10-16 | 华为技术有限公司 | 查询优化方法及相关装置 |
US10885035B2 (en) * | 2019-04-26 | 2021-01-05 | Advanced New Technologies Co., Ltd. | Method and system for outer join of database tables |
CN111949686B (zh) * | 2019-05-14 | 2024-05-14 | 阿里巴巴集团控股有限公司 | 一种数据处理方法、装置及设备 |
US20200409948A1 (en) * | 2019-06-26 | 2020-12-31 | International Business Machines Corporation | Adaptive Query Optimization Using Machine Learning |
CN111104426B8 (zh) * | 2019-11-22 | 2024-04-23 | 北京傲速科技有限公司 | 一种数据查询方法及系统 |
CN111151858B (zh) * | 2020-01-13 | 2021-10-15 | 吉利汽车研究院(宁波)有限公司 | 一种点焊焊接参数应用系统及设置方法 |
KR102125010B1 (ko) * | 2020-03-17 | 2020-06-19 | 김명훈 | 데이터베이스 전환 분석 시스템 및 방법 |
CN114168620B (zh) * | 2022-02-11 | 2022-05-17 | 北京奥星贝斯科技有限公司 | 执行计划的处理方法及装置 |
Family Cites Families (17)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5819255A (en) | 1996-08-23 | 1998-10-06 | Tandem Computers, Inc. | System and method for database query optimization |
JP4552242B2 (ja) * | 1999-10-06 | 2010-09-29 | 株式会社日立製作所 | 仮想表インタフェースと該インタフェースを用いた問合せ処理システム及び方法 |
JP3515050B2 (ja) * | 2000-07-07 | 2004-04-05 | 三菱電機株式会社 | データベース演算処理装置 |
US6665663B2 (en) | 2001-03-15 | 2003-12-16 | International Business Machines Corporation | Outerjoin and antijoin reordering using extended eligibility lists |
US6598044B1 (en) * | 2002-06-25 | 2003-07-22 | Microsoft Corporation | Method for choosing optimal query execution plan for multiple defined equivalent query expressions |
US7617179B2 (en) * | 2002-06-29 | 2009-11-10 | Ianywhere Solutions, Inc. | System and methodology for cost-based subquery optimization using a left-deep tree join enumeration algorithm |
US8086598B1 (en) * | 2006-08-02 | 2011-12-27 | Hewlett-Packard Development Company, L.P. | Query optimizer with schema conversion |
US7546311B2 (en) * | 2006-11-30 | 2009-06-09 | Ianywhere Solutions, Inc. | Optimization of left and right outer join operations in database management systems |
CN101339551B (zh) | 2007-07-05 | 2013-01-30 | 日电(中国)有限公司 | 自然语言查询需求扩展设备及其方法 |
US8224806B2 (en) | 2009-07-31 | 2012-07-17 | Hewlett-Packard Development Company, L.P. | Selectivity-based optimized-query-plan caching |
US8589382B2 (en) * | 2011-12-29 | 2013-11-19 | International Business Machines Corporation | Multi-fact query processing in data processing system |
US20130297586A1 (en) * | 2012-05-07 | 2013-11-07 | International Business Machines Corporation | Optimizing queries using predicate mappers |
CN103714058B (zh) * | 2012-09-28 | 2017-05-17 | Sap欧洲公司 | 用于数据库查询优化的方法以及使用该方法的系统 |
CN104216891B (zh) * | 2013-05-30 | 2018-02-02 | 国际商业机器公司 | 关系型数据库中的查询语句的优化方法和设备 |
CN103678589B (zh) * | 2013-12-12 | 2017-02-01 | 用友网络科技股份有限公司 | 一种基于等价类的数据库内核查询优化方法 |
US9411806B2 (en) * | 2014-05-06 | 2016-08-09 | International Business Machines Corporation | Optimizing relational database queries with multi-table predicate expressions |
US10133778B2 (en) * | 2015-11-20 | 2018-11-20 | Sap Se | Query optimization using join cardinality |
-
2015
- 2015-11-30 EP EP15909443.2A patent/EP3373154A4/en not_active Ceased
- 2015-11-30 WO PCT/CN2015/095909 patent/WO2017091925A1/zh active Application Filing
- 2015-11-30 SG SG11201804544QA patent/SG11201804544QA/en unknown
- 2015-11-30 BR BR112018010857-0A patent/BR112018010857B1/pt active IP Right Grant
- 2015-11-30 CN CN201580005935.1A patent/CN107251013B/zh active Active
- 2015-11-30 JP JP2018527925A patent/JP6628455B2/ja active Active
- 2015-11-30 KR KR1020187017354A patent/KR102138627B1/ko active IP Right Grant
-
2018
- 2018-05-30 US US15/992,925 patent/US10885034B2/en active Active
Also Published As
Publication number | Publication date |
---|---|
US20180276277A1 (en) | 2018-09-27 |
EP3373154A1 (en) | 2018-09-12 |
KR102138627B1 (ko) | 2020-07-28 |
JP2019504390A (ja) | 2019-02-14 |
BR112018010857B1 (pt) | 2023-02-07 |
EP3373154A4 (en) | 2018-09-12 |
CN107251013A (zh) | 2017-10-13 |
JP6628455B2 (ja) | 2020-01-08 |
CN107251013B (zh) | 2020-02-14 |
BR112018010857A8 (pt) | 2022-11-29 |
BR112018010857A2 (zh) | 2018-11-21 |
KR20180083927A (ko) | 2018-07-23 |
WO2017091925A1 (zh) | 2017-06-08 |
US10885034B2 (en) | 2021-01-05 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
SG11201804544QA (en) | Data query method and apparatus, and database system | |
WO2015017787A3 (en) | Homomorphic database operations apparatuses, methods and systems | |
PH12018501058A1 (en) | Order clustering and malicious information combating method and apparatus | |
SG11201901760SA (en) | Method and system for accessing out-of-chain data based on consortium block chain | |
WO2014099234A3 (en) | Method for storage, querying, and analysis of time series data | |
WO2018000205A1 (zh) | 一种基于多意图的多技能包问答方法、系统和机器人 | |
WO2014035879A3 (en) | Operating a distributed database with foreign tables | |
CA2834864C (en) | Database system and method | |
IN2015DN00354A (zh) | ||
CA2836829C (en) | Systems and methods for in-memory database processing | |
IN2014MU00728A (zh) | ||
WO2012103191A3 (en) | Method of and system for error correction in multiple input modality search engines | |
IN2012CH04230A (zh) | ||
IN2012DE00309A (zh) | ||
EP3694143A3 (en) | Enabling access to data | |
WO2013177213A3 (en) | Enabling natural language processing | |
IN2013CH04496A (zh) | ||
PH12018501577A1 (en) | Risk control method and device | |
WO2008022313A3 (en) | Method and system for determining task scheduling probability | |
GB2565680A (en) | Client device and method for analysis of a predetermined set of parameters associated with radio coupling to a WLAN | |
WO2008127570A3 (en) | Enhanced database scheme to support advanced media production and distribution | |
MX345109B (es) | Manejo de identidades en dispositivos moviles. | |
GB201203233D0 (en) | Method and device for a meta data fragment from a metadata component associated with multimedia data | |
IL241640B (en) | Method for executing queries on streaming data using graphic processing units | |
GB201217507D0 (en) | Database management system |