CN107463632B - 一种分布式NewSQL数据库***和数据查询方法 - Google Patents
一种分布式NewSQL数据库***和数据查询方法 Download PDFInfo
- Publication number
- CN107463632B CN107463632B CN201710580417.3A CN201710580417A CN107463632B CN 107463632 B CN107463632 B CN 107463632B CN 201710580417 A CN201710580417 A CN 201710580417A CN 107463632 B CN107463632 B CN 107463632B
- Authority
- CN
- China
- Prior art keywords
- execution plan
- unit
- query
- data
- result
- 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.)
- Expired - Fee Related
Links
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/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
- G06F16/9017—Indexing; Data structures therefor; Storage structures using directory or table look-up
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
- G06F9/5083—Techniques for rebalancing the load in a distributed system
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/3331—Query processing
- G06F16/334—Query execution
-
- 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/25—Integrating or interfacing systems involving database management systems
-
- 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/2379—Updates performed during online database operations; commit processing
-
- 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/21—Design, administration or maintenance of databases
-
- 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/2219—Large Object storage; Management thereof
-
- 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
- G06F16/2272—Management thereof
-
- 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/2282—Tablespace storage structures; Management thereof
-
- 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
-
- 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/242—Query formulation
- G06F16/2433—Query languages
-
- 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/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
-
- 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
-
- 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/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed queries
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- 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
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/31—Indexing; Data structures therefor; Storage structures
- G06F16/316—Indexing structures
- G06F16/319—Inverted lists
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
- G06F16/58—Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/951—Indexing; Web crawling techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/466—Transaction processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/50—Allocation of resources, e.g. of the central processing unit [CPU]
- G06F9/5083—Techniques for rebalancing the load in a distributed system
- G06F9/5088—Techniques for rebalancing the load in a distributed system involving task migration
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2209/00—Indexing scheme relating to G06F9/00
- G06F2209/50—Indexing scheme relating to G06F9/50
- G06F2209/5022—Workload threshold
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- Library & Information Science (AREA)
- Computing Systems (AREA)
- Operations Research (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Computer And Data Communications (AREA)
- Devices For Executing Special Programs (AREA)
Abstract
Description
Claims (6)
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2016108423997 | 2016-09-21 | ||
CN201610842399.7A CN106446153A (zh) | 2016-09-21 | 2016-09-21 | 一种分布式newSQL数据库***及方法 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107463632A CN107463632A (zh) | 2017-12-12 |
CN107463632B true CN107463632B (zh) | 2020-06-09 |
Family
ID=58166840
Family Applications (24)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610842399.7A Pending CN106446153A (zh) | 2016-09-21 | 2016-09-21 | 一种分布式newSQL数据库***及方法 |
CN201710585103.2A Expired - Fee Related CN107402995B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式newSQL数据库***及方法 |
CN201710580431.3A Active CN107491485B (zh) | 2016-09-21 | 2017-07-17 | 生成执行计划的方法、计划单元装置和分布式NewSQL数据库*** |
CN201710580791.3A Active CN107291948B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式newSQL数据库的访问方法 |
CN201710580416.9A Expired - Fee Related CN107291947B (zh) | 2016-09-21 | 2017-07-17 | 一种半结构化数据查询的方法和分布式NewSQL数据库*** |
CN201710580456.3A Expired - Fee Related CN107402988B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库***和半结构化数据查询方法 |
CN201710580403.1A Expired - Fee Related CN107368575B (zh) | 2016-09-21 | 2017-07-17 | 一种负载均衡的分布式NewSQL数据库*** |
CN201710581275.2A Active CN107329837B (zh) | 2016-09-21 | 2017-07-17 | 一种负载均衡的方法和单元、分布式NewSQL数据库*** |
CN201710581193.8A Expired - Fee Related CN107451219B (zh) | 2016-09-21 | 2017-07-17 | 一种建立二级索引的方法和分布式NewSQL数据库 |
CN201710581273.3A Expired - Fee Related CN107451221B (zh) | 2016-09-21 | 2017-07-17 | 一种数据库接口单元装置和分布式NewSQL数据库*** |
CN201710580435.1A Expired - Fee Related CN107480198B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库***和全文检索方法 |
CN201710580796.6A Expired - Fee Related CN107402992B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库***和全文检索建立方法 |
CN201710580423.9A Active CN107402987B (zh) | 2016-09-21 | 2017-07-17 | 一种全文检索的方法和分布式NewSQL数据库*** |
CN201710580417.3A Expired - Fee Related CN107463632B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库***和数据查询方法 |
CN201710580739.8A Expired - Fee Related CN107402990B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库***和半结构化数据储存方法 |
CN201710580720.3A Expired - Fee Related CN107402989B (zh) | 2016-09-21 | 2017-07-17 | 一种全文检索建立的方法和分布式NewSQL数据库*** |
CN201710580794.7A Expired - Fee Related CN107451214B (zh) | 2016-09-21 | 2017-07-17 | 一种非主键查询方法和分布式NewSQL数据库*** |
CN201710581291.1A Expired - Fee Related CN107463637B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库***和数据储存方法 |
CN201710581229.2A Expired - Fee Related CN107491345B (zh) | 2016-09-21 | 2017-07-17 | 一种写入图片数据方法和分布式NewSQL数据库*** |
CN201710581256.XA Expired - Fee Related CN107391653B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库***及图片数据储存方法 |
CN201710581237.7A Expired - Fee Related CN107463635B (zh) | 2016-09-21 | 2017-07-17 | 一种图片数据查询的方法和分布式NewSQL数据库*** |
CN201710580754.2A Expired - Fee Related CN107402991B (zh) | 2016-09-21 | 2017-07-17 | 一种写入半结构化数据的方法和分布式NewSQL数据库*** |
CN201710580752.3A Expired - Fee Related CN107247808B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库***及图片数据查询方法 |
CN201710581195.7A Expired - Fee Related CN107451220B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库*** |
Family Applications Before (13)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610842399.7A Pending CN106446153A (zh) | 2016-09-21 | 2016-09-21 | 一种分布式newSQL数据库***及方法 |
CN201710585103.2A Expired - Fee Related CN107402995B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式newSQL数据库***及方法 |
CN201710580431.3A Active CN107491485B (zh) | 2016-09-21 | 2017-07-17 | 生成执行计划的方法、计划单元装置和分布式NewSQL数据库*** |
CN201710580791.3A Active CN107291948B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式newSQL数据库的访问方法 |
CN201710580416.9A Expired - Fee Related CN107291947B (zh) | 2016-09-21 | 2017-07-17 | 一种半结构化数据查询的方法和分布式NewSQL数据库*** |
CN201710580456.3A Expired - Fee Related CN107402988B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库***和半结构化数据查询方法 |
CN201710580403.1A Expired - Fee Related CN107368575B (zh) | 2016-09-21 | 2017-07-17 | 一种负载均衡的分布式NewSQL数据库*** |
CN201710581275.2A Active CN107329837B (zh) | 2016-09-21 | 2017-07-17 | 一种负载均衡的方法和单元、分布式NewSQL数据库*** |
CN201710581193.8A Expired - Fee Related CN107451219B (zh) | 2016-09-21 | 2017-07-17 | 一种建立二级索引的方法和分布式NewSQL数据库 |
CN201710581273.3A Expired - Fee Related CN107451221B (zh) | 2016-09-21 | 2017-07-17 | 一种数据库接口单元装置和分布式NewSQL数据库*** |
CN201710580435.1A Expired - Fee Related CN107480198B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库***和全文检索方法 |
CN201710580796.6A Expired - Fee Related CN107402992B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库***和全文检索建立方法 |
CN201710580423.9A Active CN107402987B (zh) | 2016-09-21 | 2017-07-17 | 一种全文检索的方法和分布式NewSQL数据库*** |
Family Applications After (10)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710580739.8A Expired - Fee Related CN107402990B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库***和半结构化数据储存方法 |
CN201710580720.3A Expired - Fee Related CN107402989B (zh) | 2016-09-21 | 2017-07-17 | 一种全文检索建立的方法和分布式NewSQL数据库*** |
CN201710580794.7A Expired - Fee Related CN107451214B (zh) | 2016-09-21 | 2017-07-17 | 一种非主键查询方法和分布式NewSQL数据库*** |
CN201710581291.1A Expired - Fee Related CN107463637B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库***和数据储存方法 |
CN201710581229.2A Expired - Fee Related CN107491345B (zh) | 2016-09-21 | 2017-07-17 | 一种写入图片数据方法和分布式NewSQL数据库*** |
CN201710581256.XA Expired - Fee Related CN107391653B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库***及图片数据储存方法 |
CN201710581237.7A Expired - Fee Related CN107463635B (zh) | 2016-09-21 | 2017-07-17 | 一种图片数据查询的方法和分布式NewSQL数据库*** |
CN201710580754.2A Expired - Fee Related CN107402991B (zh) | 2016-09-21 | 2017-07-17 | 一种写入半结构化数据的方法和分布式NewSQL数据库*** |
CN201710580752.3A Expired - Fee Related CN107247808B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库***及图片数据查询方法 |
CN201710581195.7A Expired - Fee Related CN107451220B (zh) | 2016-09-21 | 2017-07-17 | 一种分布式NewSQL数据库*** |
Country Status (1)
Country | Link |
---|---|
CN (24) | CN106446153A (zh) |
Families Citing this family (48)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107391744B (zh) * | 2017-08-10 | 2020-06-16 | 东软集团股份有限公司 | 数据存储、读取方法、装置及其设备 |
CN107480260B (zh) * | 2017-08-16 | 2021-02-23 | 北京奇虎科技有限公司 | 大数据实时分析方法、装置、计算设备及计算机存储介质 |
CN107688660B (zh) * | 2017-09-08 | 2020-03-13 | 上海达梦数据库有限公司 | 并行执行计划的执行方法及装置 |
CN107766572A (zh) * | 2017-11-13 | 2018-03-06 | 北京国信宏数科技有限责任公司 | 基于经济领域数据的分布式提取及可视化分析方法和*** |
CN108228750A (zh) * | 2017-12-21 | 2018-06-29 | 浪潮软件股份有限公司 | 一种分布式数据库及其对数据进行管理的方法 |
CN108038215A (zh) * | 2017-12-22 | 2018-05-15 | 上海达梦数据库有限公司 | 数据处理方法及*** |
CN109992409B (zh) * | 2018-01-02 | 2021-07-30 | ***通信有限公司研究院 | 数据存储区域的切分方法、装置、***、电子设备和介质 |
CN108829507B (zh) * | 2018-03-30 | 2019-07-26 | 北京百度网讯科技有限公司 | 分布式数据库***的资源隔离方法、装置和服务器 |
CN108664616A (zh) * | 2018-05-14 | 2018-10-16 | 浪潮软件集团有限公司 | 一种基于ROWID的Oracle数据批量采集方法 |
CN108846044A (zh) * | 2018-05-30 | 2018-11-20 | 浪潮软件股份有限公司 | 一种地图应用部署方法及装置 |
CN108920519A (zh) * | 2018-06-04 | 2018-11-30 | 贵州数据宝网络科技有限公司 | 一对多数据供应***及方法 |
CN109033209B (zh) * | 2018-06-29 | 2021-12-31 | 新华三大数据技术有限公司 | Spark存储过程处理方法及装置 |
CN109241076A (zh) * | 2018-08-01 | 2019-01-18 | 上海依图网络科技有限公司 | 一种数据查询方法及装置 |
CN109271428A (zh) * | 2018-09-11 | 2019-01-25 | 北京市计算中心 | 数据抽取方法及基于地理信息的数据展示方法 |
CN109408591B (zh) * | 2018-10-12 | 2021-11-09 | 北京聚云位智信息科技有限公司 | 支持sql驱动的ai与特征工程的决策型分布式数据库*** |
CN109298976B (zh) * | 2018-10-17 | 2022-04-12 | 成都索贝数码科技股份有限公司 | 一种异构数据库集群备份***及方法 |
CN109408515A (zh) * | 2018-11-01 | 2019-03-01 | 郑州云海信息技术有限公司 | 一种索引执行方法与装置 |
CN109684412A (zh) * | 2018-12-25 | 2019-04-26 | 成都虚谷伟业科技有限公司 | 一种分布式数据库*** |
CN109726250B (zh) * | 2018-12-27 | 2020-01-17 | 星环信息科技(上海)有限公司 | 数据存储***、元数据库同步及数据跨域计算方法 |
CN111488340B (zh) * | 2019-01-29 | 2023-09-12 | 菜鸟智能物流控股有限公司 | 数据处理方法、装置及电子设备 |
CN110046161A (zh) * | 2019-03-18 | 2019-07-23 | 平安普惠企业管理有限公司 | 数据写入方法及装置、存储介质、电子设备 |
CN110086602B (zh) * | 2019-04-16 | 2022-02-11 | 上海交通大学 | 基于gpu的sm3密码散列算法的快速实现方法 |
CN110110234B (zh) * | 2019-05-13 | 2020-10-16 | 重庆天蓬网络有限公司 | 一种大数据实时搜索***和方法 |
CN110275901B (zh) * | 2019-06-25 | 2021-08-24 | 北京创鑫旅程网络技术有限公司 | 一种缓存数据调取方法及装置 |
CN110457363B (zh) * | 2019-07-05 | 2023-11-21 | 中国平安人寿保险股份有限公司 | 基于分布式数据库的查询方法、装置及存储介质 |
CN110413642B (zh) * | 2019-08-02 | 2022-05-27 | 北京快立方科技有限公司 | 一种应用无感知的分片数据库解析及优化方法 |
CN110569257B (zh) * | 2019-09-16 | 2022-04-01 | 上海达梦数据库有限公司 | 数据处理方法、相应装置、设备及存储介质 |
CN110704437B (zh) * | 2019-09-26 | 2022-05-20 | 上海达梦数据库有限公司 | 数据库查询语句的修改方法、装置、设备和存储介质 |
CN112688976A (zh) * | 2019-10-17 | 2021-04-20 | 广州迈安信息科技有限公司 | 一种采用jdbc/http标准的数据处理传输服务*** |
CN110888919B (zh) * | 2019-12-04 | 2023-06-30 | 阳光电源股份有限公司 | 基于HBase的对大数据统计分析的方法及装置 |
CN113032479A (zh) * | 2019-12-24 | 2021-06-25 | 上海昂创信息技术有限公司 | 一种HBase非主键索引的方法及HBase*** |
CN111309581B (zh) * | 2020-02-28 | 2023-09-12 | 中国工商银行股份有限公司 | 一种数据库升级场景下的应用性能检测方法及装置 |
CN111651453B (zh) * | 2020-04-30 | 2024-02-06 | 中国平安财产保险股份有限公司 | 用户历史行为查询方法、装置、电子设备及存储介质 |
CN113760960A (zh) * | 2020-06-01 | 2021-12-07 | 北京搜狗科技发展有限公司 | 一种信息生成方法、装置和用于生成信息的装置 |
CN111797112B (zh) * | 2020-06-05 | 2022-04-01 | 武汉大学 | 一种PostgreSQL预备语句执行优化方法 |
CN113806611A (zh) * | 2020-06-17 | 2021-12-17 | 海信集团有限公司 | 一种存储搜索引擎结果的方法及设备 |
CN111930705B (zh) * | 2020-07-07 | 2023-03-14 | 中国电子科技集团公司电子科学研究院 | 二进制消息协议数据处理方法及装置 |
CN112148792B (zh) * | 2020-09-16 | 2024-04-12 | 鹏城实验室 | 一种基于HBase的分区数据调整方法、***及终端 |
CN112052347B (zh) * | 2020-10-09 | 2024-06-04 | 北京百度网讯科技有限公司 | 图像存储方法、装置以及电子设备 |
CN112416925B (zh) * | 2020-11-02 | 2024-04-09 | 浙商银行股份有限公司 | 基于有序分布式索引结构的查询方法和分布式数据库*** |
CN112364033B (zh) * | 2021-01-13 | 2021-04-13 | 北京云真信科技有限公司 | 一种数据检索*** |
CN113760900A (zh) * | 2021-02-19 | 2021-12-07 | 西安京迅递供应链科技有限公司 | 数据的实时汇总以及区间汇总的方法和装置 |
CN112905615B (zh) * | 2021-03-02 | 2023-03-24 | 浪潮云信息技术股份公司 | 一种基于顺序校验的分布式一致性协议提交方法及*** |
CN112925841B (zh) * | 2021-03-26 | 2022-11-08 | 瀚高基础软件股份有限公司 | 分布式jdbc实现方法、设备及计算机可读存储介质 |
CN113407662B (zh) * | 2021-08-19 | 2021-12-14 | 深圳市明源云客电子商务有限公司 | 敏感词识别方法、***及计算机可读存储介质 |
CN113742370B (zh) * | 2021-11-02 | 2022-04-19 | 阿里云计算有限公司 | 全加密数据库的数据查询方法、统计信息密文生成方法 |
CN115129724A (zh) * | 2022-08-29 | 2022-09-30 | 畅捷通信息技术股份有限公司 | 一种统计型报表分页方法、***、设备及介质 |
CN116861455B (zh) * | 2023-06-25 | 2024-04-26 | 上海数禾信息科技有限公司 | 事件数据处理方法、***、电子设备及存储介质 |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101567006A (zh) * | 2009-05-25 | 2009-10-28 | 中兴通讯股份有限公司 | 一种数据库***及分布式sql语句执行计划重用方法 |
CN102375853A (zh) * | 2010-08-24 | 2012-03-14 | ***通信集团公司 | 分布式数据库***、在其中建立索引的方法和查询方法 |
CN103577407A (zh) * | 2012-07-19 | 2014-02-12 | 国际商业机器公司 | 用于分布式数据库的查询方法及查询装置 |
Family Cites Families (22)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101477568A (zh) * | 2009-02-12 | 2009-07-08 | 清华大学 | 一种结构化数据和非结构化数据综合检索的方法 |
CN102163195B (zh) * | 2010-02-22 | 2013-04-24 | 北京东方通科技股份有限公司 | 一种基于分布式、异构数据库统一视图的查询优化方法 |
CN102201010A (zh) * | 2011-06-23 | 2011-09-28 | 清华大学 | 无共享架构的分布式数据库***及其实现方法 |
CN102289482A (zh) * | 2011-08-02 | 2011-12-21 | 北京航空航天大学 | 一种非结构化数据查询方法 |
CN103150304B (zh) * | 2011-12-06 | 2016-11-23 | 郑红云 | 云数据库*** |
US20140074860A1 (en) * | 2012-09-12 | 2014-03-13 | Pingar Holdings Limited | Disambiguator |
CN102902932B (zh) * | 2012-09-18 | 2015-12-02 | 武汉华工安鼎信息技术有限责任公司 | 基于sql重写的数据库外部加解密***的使用方法 |
CN103092970A (zh) * | 2013-01-24 | 2013-05-08 | 华为技术有限公司 | 一种数据库操作方法及设备 |
US9773021B2 (en) * | 2013-01-30 | 2017-09-26 | Hewlett-Packard Development Company, L.P. | Corrected optical property value-based search query |
CN103377292B (zh) * | 2013-07-02 | 2017-02-15 | 华为技术有限公司 | 数据库结果集缓存方法及设备 |
US20150039587A1 (en) * | 2013-07-31 | 2015-02-05 | Oracle International Corporation | Generic sql enhancement to query any semi-structured data and techniques to efficiently support such enhancements |
CN103473321A (zh) * | 2013-09-12 | 2013-12-25 | 华为技术有限公司 | 数据库管理方法与*** |
CN104794123B (zh) * | 2014-01-20 | 2018-07-27 | 阿里巴巴集团控股有限公司 | 一种为半结构化数据构建NoSQL数据库索引的方法及装置 |
CN103984726B (zh) * | 2014-05-16 | 2017-03-29 | 上海新炬网络信息技术有限公司 | 一种数据库执行计划的局部修正方法 |
CN104133858B (zh) * | 2014-07-15 | 2017-08-01 | 武汉邮电科学研究院 | 基于列存储的智能双引擎分析***及方法 |
CN104503985A (zh) * | 2014-12-03 | 2015-04-08 | 浪潮电子信息产业股份有限公司 | 一种Hbase数据自动化创建Solr索引文件的方法 |
CN104572895B (zh) * | 2014-12-24 | 2018-02-23 | 天津南大通用数据技术股份有限公司 | MPP数据库与Hadoop集群数据互通方法、工具及实现方法 |
CN104731922A (zh) * | 2015-03-26 | 2015-06-24 | 江苏物联网研究发展中心 | 基于分布式数据库HBase的结构化数据的快速检索***及方法 |
CN104750815B (zh) * | 2015-03-30 | 2017-11-03 | 浪潮集团有限公司 | 一种基于HBase的Lob数据的存储方法及装置 |
CN104731945B (zh) * | 2015-03-31 | 2018-04-06 | 浪潮集团有限公司 | 一种基于HBase的全文检索方法及装置 |
CN105389375B (zh) * | 2015-11-18 | 2018-10-02 | 福建师范大学 | 一种基于可视域的图像索引设置方法、***及检索方法 |
CN105740410A (zh) * | 2016-01-29 | 2016-07-06 | 浪潮电子信息产业股份有限公司 | 一种基于Hbase二级索引的数据统计方法 |
-
2016
- 2016-09-21 CN CN201610842399.7A patent/CN106446153A/zh active Pending
-
2017
- 2017-07-17 CN CN201710585103.2A patent/CN107402995B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710580431.3A patent/CN107491485B/zh active Active
- 2017-07-17 CN CN201710580791.3A patent/CN107291948B/zh active Active
- 2017-07-17 CN CN201710580416.9A patent/CN107291947B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710580456.3A patent/CN107402988B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710580403.1A patent/CN107368575B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710581275.2A patent/CN107329837B/zh active Active
- 2017-07-17 CN CN201710581193.8A patent/CN107451219B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710581273.3A patent/CN107451221B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710580435.1A patent/CN107480198B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710580796.6A patent/CN107402992B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710580423.9A patent/CN107402987B/zh active Active
- 2017-07-17 CN CN201710580417.3A patent/CN107463632B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710580739.8A patent/CN107402990B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710580720.3A patent/CN107402989B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710580794.7A patent/CN107451214B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710581291.1A patent/CN107463637B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710581229.2A patent/CN107491345B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710581256.XA patent/CN107391653B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710581237.7A patent/CN107463635B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710580754.2A patent/CN107402991B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710580752.3A patent/CN107247808B/zh not_active Expired - Fee Related
- 2017-07-17 CN CN201710581195.7A patent/CN107451220B/zh not_active Expired - Fee Related
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101567006A (zh) * | 2009-05-25 | 2009-10-28 | 中兴通讯股份有限公司 | 一种数据库***及分布式sql语句执行计划重用方法 |
CN102375853A (zh) * | 2010-08-24 | 2012-03-14 | ***通信集团公司 | 分布式数据库***、在其中建立索引的方法和查询方法 |
CN103577407A (zh) * | 2012-07-19 | 2014-02-12 | 国际商业机器公司 | 用于分布式数据库的查询方法及查询装置 |
Non-Patent Citations (2)
Title |
---|
Apache Phoenix;@ApachePhoenix;《Apache.org》;20141029;第1-59页 * |
Phoenix;James Taylor;《Apache.org》;20141029;第1-108页 * |
Also Published As
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107463632B (zh) | 一种分布式NewSQL数据库***和数据查询方法 | |
US20220035815A1 (en) | Processing database queries using format conversion | |
US11567956B2 (en) | Background format optimization for enhanced queries in a distributed computing cluster | |
CN109299102B (zh) | 一种基于Elastcisearch的HBase二级索引***及方法 | |
US8122008B2 (en) | Joining tables in multiple heterogeneous distributed databases | |
KR102157925B1 (ko) | 데이터 질의 방법 및 장치 | |
US11514039B2 (en) | Global dictionary for database management systems | |
US11556534B2 (en) | Subquery predicate generation to reduce processing in a multi-table join | |
US20170068703A1 (en) | Local database cache | |
US7185004B1 (en) | System and method for reverse routing materialized query tables in a database | |
CN112818010B (zh) | 数据库查询方法及装置 | |
CN113742346A (zh) | 资产大数据平台架构优化方法 | |
CN112416966A (zh) | 即席查询方法、装置、计算机设备和存储介质 | |
CN116860390A (zh) | 一种基于数据虚拟化的数据分组方法、装置、设备及介质 | |
JP2021174079A (ja) | データ管理システムおよびデータ管理方法 |
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 | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20200430 Address after: Room 5303, 1023 Gaopu Road, Tianhe Software Park, Tianhe District, Guangzhou City, Guangdong 510000 Applicant after: Yunrun Da Data Service Co.,Ltd. Address before: 510000 Yuexiu District, Guangzhou Province, north of the text of the text of the North Road, No. 68, the east wing of the text of the building on the ground floor, No. six, No. 602, No. Applicant before: GUANGZHOU TEDAO INFORMATION TECHNOLOGY Co.,Ltd. |
|
TA01 | Transfer of patent application right | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20200609 Termination date: 20210717 |
|
CF01 | Termination of patent right due to non-payment of annual fee |