CN111104426A - 一种数据查询方法及系统 - Google Patents
一种数据查询方法及系统 Download PDFInfo
- Publication number
- CN111104426A CN111104426A CN201911152931.2A CN201911152931A CN111104426A CN 111104426 A CN111104426 A CN 111104426A CN 201911152931 A CN201911152931 A CN 201911152931A CN 111104426 A CN111104426 A CN 111104426A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- query
- determining
- acquiring
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 55
- 238000004590 computer program Methods 0.000 claims description 27
- 238000003860 storage Methods 0.000 claims description 14
- 238000012216 screening Methods 0.000 claims description 6
- 238000012545 processing Methods 0.000 abstract description 7
- 238000010586 diagram Methods 0.000 description 8
- 230000006870 function Effects 0.000 description 7
- 230000008569 process Effects 0.000 description 5
- 230000004044 response Effects 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000003190 augmentative effect Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
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/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24554—Unary operations; Data partitioning operations
- G06F16/24556—Aggregation; Duplicate elimination
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computing Systems (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911152931.2A CN111104426B8 (zh) | 2019-11-22 | 2019-11-22 | 一种数据查询方法及系统 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911152931.2A CN111104426B8 (zh) | 2019-11-22 | 2019-11-22 | 一种数据查询方法及系统 |
Publications (3)
Publication Number | Publication Date |
---|---|
CN111104426A true CN111104426A (zh) | 2020-05-05 |
CN111104426B CN111104426B (zh) | 2024-04-05 |
CN111104426B8 CN111104426B8 (zh) | 2024-04-23 |
Family
ID=70420942
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201911152931.2A Active CN111104426B8 (zh) | 2019-11-22 | 2019-11-22 | 一种数据查询方法及系统 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN111104426B8 (zh) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112069174A (zh) * | 2020-08-25 | 2020-12-11 | 北京锐安科技有限公司 | 一种数据提取方法、装置、设备及存储介质 |
CN112199393A (zh) * | 2020-09-18 | 2021-01-08 | 深圳希施玛数据科技有限公司 | 基于跨表查询的数据表生成方法、装置、设备及存储介质 |
CN113515543A (zh) * | 2021-03-23 | 2021-10-19 | 广东便捷神科技股份有限公司 | 一种无人售货机自动提货方法及系统 |
CN112199393B (zh) * | 2020-09-18 | 2024-05-10 | 深圳希施玛数据科技有限公司 | 基于跨表查询的数据表生成方法、装置、设备及存储介质 |
Citations (17)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101963977A (zh) * | 2010-09-19 | 2011-02-02 | 北京腾瑞万里科技有限公司 | 无城市搜索方法及移动终端 |
EP2453370A1 (en) * | 2010-11-12 | 2012-05-16 | Business Objects Software Limited | Method and system for specifying, preparing and using parameterized database queries |
GB201309877D0 (en) * | 2013-06-03 | 2013-07-17 | Ibm | Information retrieval from a database system |
US20150254294A1 (en) * | 2014-03-04 | 2015-09-10 | International Business Machines Corporation | Dynamic result set caching with a database accelerator |
US20160328445A1 (en) * | 2015-02-28 | 2016-11-10 | Huawei Technologies Co., Ltd. | Data Query Method and Apparatus |
WO2017091925A1 (zh) * | 2015-11-30 | 2017-06-08 | 华为技术有限公司 | 数据查询的方法、装置和数据库系统 |
CN107133362A (zh) * | 2017-06-01 | 2017-09-05 | 北京凤凰理理它信息技术有限公司 | 商品信息搜索方法、系统、计算机程序及电子设备 |
CN107615277A (zh) * | 2015-03-26 | 2018-01-19 | 卡斯维尔公司 | 用于查询数据源的系统和方法 |
CN107783980A (zh) * | 2016-08-24 | 2018-03-09 | 阿里巴巴集团控股有限公司 | 索引数据生成及数据查询方法及装置、存储和查询系统 |
CN108090154A (zh) * | 2017-12-08 | 2018-05-29 | 广州市申迪计算机系统有限公司 | 一种异构多源数据融合查询方法及装置 |
CN108630287A (zh) * | 2017-03-15 | 2018-10-09 | 长庚医疗财团法人林口长庚纪念医院 | 数据整合方法 |
WO2019105420A1 (zh) * | 2017-11-30 | 2019-06-06 | 新华三大数据技术有限公司 | 数据查询 |
CN109902089A (zh) * | 2019-02-19 | 2019-06-18 | Oppo广东移动通信有限公司 | 利用异构索引的查询方法、装置、电子设备及介质 |
CN110019213A (zh) * | 2017-12-04 | 2019-07-16 | 北京京东尚科信息技术有限公司 | 数据管理方法、装置、电子设备及存储介质 |
CN110109948A (zh) * | 2019-04-25 | 2019-08-09 | 数译(成都)信息技术有限公司 | 数据查询方法、计算机设备及计算机可读存储介质 |
CN110162544A (zh) * | 2019-05-30 | 2019-08-23 | 口碑(上海)信息技术有限公司 | 异构数据源数据获取方法及装置 |
CN110427437A (zh) * | 2019-07-31 | 2019-11-08 | 南京邮电大学 | 一种面向大数据的关系型数据库混合异构查询模型与方法 |
-
2019
- 2019-11-22 CN CN201911152931.2A patent/CN111104426B8/zh active Active
Patent Citations (17)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101963977A (zh) * | 2010-09-19 | 2011-02-02 | 北京腾瑞万里科技有限公司 | 无城市搜索方法及移动终端 |
EP2453370A1 (en) * | 2010-11-12 | 2012-05-16 | Business Objects Software Limited | Method and system for specifying, preparing and using parameterized database queries |
GB201309877D0 (en) * | 2013-06-03 | 2013-07-17 | Ibm | Information retrieval from a database system |
US20150254294A1 (en) * | 2014-03-04 | 2015-09-10 | International Business Machines Corporation | Dynamic result set caching with a database accelerator |
US20160328445A1 (en) * | 2015-02-28 | 2016-11-10 | Huawei Technologies Co., Ltd. | Data Query Method and Apparatus |
CN107615277A (zh) * | 2015-03-26 | 2018-01-19 | 卡斯维尔公司 | 用于查询数据源的系统和方法 |
WO2017091925A1 (zh) * | 2015-11-30 | 2017-06-08 | 华为技术有限公司 | 数据查询的方法、装置和数据库系统 |
CN107783980A (zh) * | 2016-08-24 | 2018-03-09 | 阿里巴巴集团控股有限公司 | 索引数据生成及数据查询方法及装置、存储和查询系统 |
CN108630287A (zh) * | 2017-03-15 | 2018-10-09 | 长庚医疗财团法人林口长庚纪念医院 | 数据整合方法 |
CN107133362A (zh) * | 2017-06-01 | 2017-09-05 | 北京凤凰理理它信息技术有限公司 | 商品信息搜索方法、系统、计算机程序及电子设备 |
WO2019105420A1 (zh) * | 2017-11-30 | 2019-06-06 | 新华三大数据技术有限公司 | 数据查询 |
CN110019213A (zh) * | 2017-12-04 | 2019-07-16 | 北京京东尚科信息技术有限公司 | 数据管理方法、装置、电子设备及存储介质 |
CN108090154A (zh) * | 2017-12-08 | 2018-05-29 | 广州市申迪计算机系统有限公司 | 一种异构多源数据融合查询方法及装置 |
CN109902089A (zh) * | 2019-02-19 | 2019-06-18 | Oppo广东移动通信有限公司 | 利用异构索引的查询方法、装置、电子设备及介质 |
CN110109948A (zh) * | 2019-04-25 | 2019-08-09 | 数译(成都)信息技术有限公司 | 数据查询方法、计算机设备及计算机可读存储介质 |
CN110162544A (zh) * | 2019-05-30 | 2019-08-23 | 口碑(上海)信息技术有限公司 | 异构数据源数据获取方法及装置 |
CN110427437A (zh) * | 2019-07-31 | 2019-11-08 | 南京邮电大学 | 一种面向大数据的关系型数据库混合异构查询模型与方法 |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112069174A (zh) * | 2020-08-25 | 2020-12-11 | 北京锐安科技有限公司 | 一种数据提取方法、装置、设备及存储介质 |
CN112199393A (zh) * | 2020-09-18 | 2021-01-08 | 深圳希施玛数据科技有限公司 | 基于跨表查询的数据表生成方法、装置、设备及存储介质 |
CN112199393B (zh) * | 2020-09-18 | 2024-05-10 | 深圳希施玛数据科技有限公司 | 基于跨表查询的数据表生成方法、装置、设备及存储介质 |
CN113515543A (zh) * | 2021-03-23 | 2021-10-19 | 广东便捷神科技股份有限公司 | 一种无人售货机自动提货方法及系统 |
CN113515543B (zh) * | 2021-03-23 | 2024-02-13 | 广东便捷神科技股份有限公司 | 一种无人售货机自动提货方法及系统 |
Also Published As
Publication number | Publication date |
---|---|
CN111104426B (zh) | 2024-04-05 |
CN111104426B8 (zh) | 2024-04-23 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US9418101B2 (en) | Query optimization | |
CN111352902A (zh) | 日志处理方法、装置、终端设备及存储介质 | |
US8924373B2 (en) | Query plans with parameter markers in place of object identifiers | |
US8812489B2 (en) | Swapping expected and candidate affinities in a query plan cache | |
MX2013014800A (es) | Recomendacion de enriquecimientos de datos. | |
US9600559B2 (en) | Data processing for database aggregation operation | |
CN113704243A (zh) | 数据分析方法、装置、计算机装置及存储介质 | |
CN112434015B (zh) | 数据存储的方法、装置、电子设备及介质 | |
CN112395322B (zh) | 一种基于分级缓存的列表数据显示方法、装置及终端设备 | |
WO2020047840A1 (zh) | 账单信息缓存方法、账单信息查询方法和终端设备 | |
CN113704307A (zh) | 数据查询方法、装置、服务器及计算机可读存储介质 | |
CN111104426B (zh) | 一种数据查询方法及系统 | |
CN113129150A (zh) | 交易数据的处理方法、装置、终端设备及可读存储介质 | |
CN110598993B (zh) | 数据加工方法及装置 | |
CN109815241B (zh) | 数据查询方法、装置、设备和存储介质 | |
CN113010542B (zh) | 业务数据处理方法、装置、计算机设备及存储介质 | |
CN113625967B (zh) | 数据存储方法、数据查询方法及服务器 | |
CN116303820A (zh) | 标签生成方法、装置、计算机设备及介质 | |
CN113609128A (zh) | 生成数据库实体类的方法、装置、终端设备及存储介质 | |
CN115168462A (zh) | 确定目标对象的方法、数据存储方法及对应装置 | |
CN111309988B (zh) | 基于编码的字符串检索方法、装置及电子设备 | |
CN113722296A (zh) | 一种农业信息处理方法、装置、电子设备及存储介质 | |
CN113419792A (zh) | 一种事件处理方法、装置、终端设备和存储介质 | |
CN112131257A (zh) | 数据查询方法和装置 | |
CN111611056A (zh) | 数据处理方法、装置、计算机设备及存储介质 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20240403 Address after: 1712, 14th Floor, Building 2, No. 26 Jiuxianqiao Middle Road, Chaoyang District, Beijing, 100020 Applicant after: Beijing Aosu Technology Co.,Ltd. Country or region after: China Address before: 518000 Guangdong Shenzhen Baoan District Xin'an Street Xingdong community 67 District COFCO experience Museum (1) 203A Applicant before: SHENZHEN ZHILIAN IOT TECHNOLOGY Co.,Ltd. Country or region before: China |
|
CI03 | Correction of invention patent | ||
CI03 | Correction of invention patent |
Correction item: Patentee|Address|Patent agency|Patent Agent Correct: Beijing Aosu Technology Co., Ltd.|1712, 14th Floor, Building 2, No. 26 Jiuxianqiao Middle Road, Chaoyang District, Beijing, 100020|Beijing Tianxia Innovation Intellectual Property Agency (General Partnership) 16044|Li Wei False: Shenzhen Zhilian IoT Technology Co., Ltd.|518000 Guangdong Shenzhen Baoan District Xin'an Street Xingdong community 67 District COFCO experience Museum (1) 203A|Shenzhen Zhongyi United Intellectual Property Agency Co., Ltd. 44414|Zuo Tinglan Number: 14-02 Page: The title page Volume: 40 Correction item: Patentee|Address|Patent agency|Patent Agent Correct: Beijing Aosu Technology Co., Ltd.|1712, 14th Floor, Building 2, No. 26 Jiuxianqiao Middle Road, Chaoyang District, Beijing, 100020|Beijing Tianxia Innovation Intellectual Property Agency (General Partnership) 16044|Li Wei False: Shenzhen Zhilian IoT Technology Co., Ltd.|518000 Guangdong Shenzhen Baoan District Xin'an Street Xingdong community 67 District COFCO experience Museum (1) 203A|Shenzhen Zhongyi United Intellectual Property Agency Co., Ltd. 44414|Zuo Tinglan Number: 14-02 Volume: 40 |
|
OR01 | Other related matters | ||
OR01 | Other related matters |