CN107402990B - Distributed New SQL database system and semi-structured data storage method - Google Patents
Distributed New SQL database system and semi-structured data storage method Download PDFInfo
- Publication number
- CN107402990B CN107402990B CN201710580739.8A CN201710580739A CN107402990B CN 107402990 B CN107402990 B CN 107402990B CN 201710580739 A CN201710580739 A CN 201710580739A CN 107402990 B CN107402990 B CN 107402990B
- Authority
- CN
- China
- Prior art keywords
- mapping
- data
- plan
- unit
- execution
- 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
- 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/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/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/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
- 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/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/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 Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Fuzzy Systems (AREA)
- Probability & Statistics with Applications (AREA)
- Operations Research (AREA)
- Computing Systems (AREA)
- Library & Information Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Computer And Data Communications (AREA)
- Devices For Executing Special Programs (AREA)
Abstract
Description
Claims (8)
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610842399.7A CN106446153A (en) | 2016-09-21 | 2016-09-21 | Distributed newSQL database system and method |
CN2016108423997 | 2016-09-21 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107402990A CN107402990A (en) | 2017-11-28 |
CN107402990B true CN107402990B (en) | 2020-06-09 |
Family
ID=58166840
Family Applications (24)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610842399.7A Pending CN106446153A (en) | 2016-09-21 | 2016-09-21 | Distributed newSQL database system and method |
CN201710581193.8A Expired - Fee Related CN107451219B (en) | 2016-09-21 | 2017-07-17 | Method for analyzing second index and distributed New SQL database |
CN201710580403.1A Expired - Fee Related CN107368575B (en) | 2016-09-21 | 2017-07-17 | Load-balanced distributed NewSQL database system |
CN201710580794.7A Expired - Fee Related CN107451214B (en) | 2016-09-21 | 2017-07-17 | Non-primary key query method and distributed NewSQL database system |
CN201710581275.2A Active CN107329837B (en) | 2016-09-21 | 2017-07-17 | Load balancing method and unit and distributed NewSQL database system |
CN201710581237.7A Expired - Fee Related CN107463635B (en) | 2016-09-21 | 2017-07-17 | Method for inquiring picture data and distributed NewSQL database system |
CN201710580417.3A Expired - Fee Related CN107463632B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system and data query method |
CN201710581229.2A Expired - Fee Related CN107491345B (en) | 2016-09-21 | 2017-07-17 | Method for writing picture data and distributed NewSQ L database system |
CN201710580752.3A Expired - Fee Related CN107247808B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system and picture data query method |
CN201710580754.2A Expired - Fee Related CN107402991B (en) | 2016-09-21 | 2017-07-17 | Method for writing semi-structured data and distributed NewSQL database system |
CN201710580435.1A Expired - Fee Related CN107480198B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system and full-text retrieval method |
CN201710580431.3A Active CN107491485B (en) | 2016-09-21 | 2017-07-17 | Method for generating execution plan, plan unit device and distributed NewSQ L database system |
CN201710585103.2A Expired - Fee Related CN107402995B (en) | 2016-09-21 | 2017-07-17 | Distributed newSQL database system and method |
CN201710581273.3A Expired - Fee Related CN107451221B (en) | 2016-09-21 | 2017-07-17 | Database interface unit device and distributed NewSQL database system |
CN201710581195.7A Expired - Fee Related CN107451220B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system |
CN201710580720.3A Expired - Fee Related CN107402989B (en) | 2016-09-21 | 2017-07-17 | Full-text retrieval establishing method and distributed NewSQL database system |
CN201710580739.8A Expired - Fee Related CN107402990B (en) | 2016-09-21 | 2017-07-17 | Distributed New SQL database system and semi-structured data storage method |
CN201710580456.3A Expired - Fee Related CN107402988B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system and semi-structured data query method |
CN201710581291.1A Expired - Fee Related CN107463637B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system and data storage method |
CN201710580796.6A Expired - Fee Related CN107402992B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system and full-text retrieval establishing method |
CN201710581256.XA Expired - Fee Related CN107391653B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system and picture data storage method |
CN201710580791.3A Active CN107291948B (en) | 2016-09-21 | 2017-07-17 | Access method of distributed newSQL database |
CN201710580416.9A Expired - Fee Related CN107291947B (en) | 2016-09-21 | 2017-07-17 | Semi-structured data query method and distributed NewSQL database system |
CN201710580423.9A Active CN107402987B (en) | 2016-09-21 | 2017-07-17 | Full-text retrieval method and distributed NewSQL database system |
Family Applications Before (16)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610842399.7A Pending CN106446153A (en) | 2016-09-21 | 2016-09-21 | Distributed newSQL database system and method |
CN201710581193.8A Expired - Fee Related CN107451219B (en) | 2016-09-21 | 2017-07-17 | Method for analyzing second index and distributed New SQL database |
CN201710580403.1A Expired - Fee Related CN107368575B (en) | 2016-09-21 | 2017-07-17 | Load-balanced distributed NewSQL database system |
CN201710580794.7A Expired - Fee Related CN107451214B (en) | 2016-09-21 | 2017-07-17 | Non-primary key query method and distributed NewSQL database system |
CN201710581275.2A Active CN107329837B (en) | 2016-09-21 | 2017-07-17 | Load balancing method and unit and distributed NewSQL database system |
CN201710581237.7A Expired - Fee Related CN107463635B (en) | 2016-09-21 | 2017-07-17 | Method for inquiring picture data and distributed NewSQL database system |
CN201710580417.3A Expired - Fee Related CN107463632B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system and data query method |
CN201710581229.2A Expired - Fee Related CN107491345B (en) | 2016-09-21 | 2017-07-17 | Method for writing picture data and distributed NewSQ L database system |
CN201710580752.3A Expired - Fee Related CN107247808B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system and picture data query method |
CN201710580754.2A Expired - Fee Related CN107402991B (en) | 2016-09-21 | 2017-07-17 | Method for writing semi-structured data and distributed NewSQL database system |
CN201710580435.1A Expired - Fee Related CN107480198B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system and full-text retrieval method |
CN201710580431.3A Active CN107491485B (en) | 2016-09-21 | 2017-07-17 | Method for generating execution plan, plan unit device and distributed NewSQ L database system |
CN201710585103.2A Expired - Fee Related CN107402995B (en) | 2016-09-21 | 2017-07-17 | Distributed newSQL database system and method |
CN201710581273.3A Expired - Fee Related CN107451221B (en) | 2016-09-21 | 2017-07-17 | Database interface unit device and distributed NewSQL database system |
CN201710581195.7A Expired - Fee Related CN107451220B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system |
CN201710580720.3A Expired - Fee Related CN107402989B (en) | 2016-09-21 | 2017-07-17 | Full-text retrieval establishing method and distributed NewSQL database system |
Family Applications After (7)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710580456.3A Expired - Fee Related CN107402988B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system and semi-structured data query method |
CN201710581291.1A Expired - Fee Related CN107463637B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system and data storage method |
CN201710580796.6A Expired - Fee Related CN107402992B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system and full-text retrieval establishing method |
CN201710581256.XA Expired - Fee Related CN107391653B (en) | 2016-09-21 | 2017-07-17 | Distributed NewSQL database system and picture data storage method |
CN201710580791.3A Active CN107291948B (en) | 2016-09-21 | 2017-07-17 | Access method of distributed newSQL database |
CN201710580416.9A Expired - Fee Related CN107291947B (en) | 2016-09-21 | 2017-07-17 | Semi-structured data query method and distributed NewSQL database system |
CN201710580423.9A Active CN107402987B (en) | 2016-09-21 | 2017-07-17 | Full-text retrieval method and distributed NewSQL database system |
Country Status (1)
Country | Link |
---|---|
CN (24) | CN106446153A (en) |
Families Citing this family (49)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107391744B (en) * | 2017-08-10 | 2020-06-16 | 东软集团股份有限公司 | Data storage method, data reading method, data storage device, data reading device and equipment |
CN107480260B (en) * | 2017-08-16 | 2021-02-23 | 北京奇虎科技有限公司 | Big data real-time analysis method and device, computing equipment and computer storage medium |
CN107688660B (en) * | 2017-09-08 | 2020-03-13 | 上海达梦数据库有限公司 | Parallel execution plan execution method and device |
CN107766572A (en) * | 2017-11-13 | 2018-03-06 | 北京国信宏数科技有限责任公司 | Distributed extraction and visual analysis method and system based on economic field data |
CN108228750A (en) * | 2017-12-21 | 2018-06-29 | 浪潮软件股份有限公司 | A kind of distributed data base and its method that data are managed |
CN108038215A (en) * | 2017-12-22 | 2018-05-15 | 上海达梦数据库有限公司 | Data processing method and system |
CN109992409B (en) * | 2018-01-02 | 2021-07-30 | 中国移动通信有限公司研究院 | Method, device and system for segmenting data storage area, electronic equipment and medium |
CN108829507B (en) * | 2018-03-30 | 2019-07-26 | 北京百度网讯科技有限公司 | The resource isolation method, apparatus and server of distributed data base system |
CN110362624A (en) * | 2018-04-02 | 2019-10-22 | 蓝盾信息安全技术有限公司 | A kind of heterogeneous database synchronization method based on safety isolation network gate system |
CN108664616A (en) * | 2018-05-14 | 2018-10-16 | 浪潮软件集团有限公司 | ROWID-based Oracle data batch acquisition method |
CN108846044A (en) * | 2018-05-30 | 2018-11-20 | 浪潮软件股份有限公司 | A kind of map application dispositions method and device |
CN108920519A (en) * | 2018-06-04 | 2018-11-30 | 贵州数据宝网络科技有限公司 | One-to-many data supply system and method |
CN109033209B (en) * | 2018-06-29 | 2021-12-31 | 新华三大数据技术有限公司 | Spark storage process processing method and device |
CN109241076A (en) * | 2018-08-01 | 2019-01-18 | 上海依图网络科技有限公司 | A kind of data query method and device |
CN109271428A (en) * | 2018-09-11 | 2019-01-25 | 北京市计算中心 | Data pick-up method and method for exhibiting data based on geography information |
CN109408591B (en) * | 2018-10-12 | 2021-11-09 | 北京聚云位智信息科技有限公司 | Decision-making distributed database system supporting SQL (structured query language) driven AI (Artificial Intelligence) and feature engineering |
CN109298976B (en) * | 2018-10-17 | 2022-04-12 | 成都索贝数码科技股份有限公司 | Heterogeneous database cluster backup system and method |
CN109408515A (en) * | 2018-11-01 | 2019-03-01 | 郑州云海信息技术有限公司 | A kind of index execution method and apparatus |
CN109684412A (en) * | 2018-12-25 | 2019-04-26 | 成都虚谷伟业科技有限公司 | A kind of distributed data base system |
CN109726250B (en) * | 2018-12-27 | 2020-01-17 | 星环信息科技(上海)有限公司 | Data storage system, metadata database synchronization method and data cross-domain calculation method |
CN111488340B (en) * | 2019-01-29 | 2023-09-12 | 菜鸟智能物流控股有限公司 | Data processing method and device and electronic equipment |
CN110046161A (en) * | 2019-03-18 | 2019-07-23 | 平安普惠企业管理有限公司 | Method for writing data and device, storage medium, electronic equipment |
CN110086602B (en) * | 2019-04-16 | 2022-02-11 | 上海交通大学 | Rapid implementation method of SM3 password hash algorithm based on GPU |
CN110110234B (en) * | 2019-05-13 | 2020-10-16 | 重庆天蓬网络有限公司 | Big data real-time searching system and method |
CN110275901B (en) * | 2019-06-25 | 2021-08-24 | 北京创鑫旅程网络技术有限公司 | Cache data calling method and device |
CN110457363B (en) * | 2019-07-05 | 2023-11-21 | 中国平安人寿保险股份有限公司 | Query method, device and storage medium based on distributed database |
CN110413642B (en) * | 2019-08-02 | 2022-05-27 | 北京快立方科技有限公司 | Application-unaware fragmentation database parsing and optimizing method |
CN110569257B (en) * | 2019-09-16 | 2022-04-01 | 上海达梦数据库有限公司 | Data processing method, corresponding device, equipment and storage medium |
CN110704437B (en) * | 2019-09-26 | 2022-05-20 | 上海达梦数据库有限公司 | Method, device, equipment and storage medium for modifying database query statement |
CN112688976A (en) * | 2019-10-17 | 2021-04-20 | 广州迈安信息科技有限公司 | Data processing transmission service system adopting JDBC/HTTP standard |
CN110888919B (en) * | 2019-12-04 | 2023-06-30 | 阳光电源股份有限公司 | HBase-based method and device for statistical analysis of big data |
CN113032479A (en) * | 2019-12-24 | 2021-06-25 | 上海昂创信息技术有限公司 | HBase non-primary key indexing method and HBase system |
CN111309581B (en) * | 2020-02-28 | 2023-09-12 | 中国工商银行股份有限公司 | Application performance detection method and device in database upgrading scene |
CN111651453B (en) * | 2020-04-30 | 2024-02-06 | 中国平安财产保险股份有限公司 | User history behavior query method and device, electronic equipment and storage medium |
CN113760960A (en) * | 2020-06-01 | 2021-12-07 | 北京搜狗科技发展有限公司 | Information generation method and device for generating information |
CN111797112B (en) * | 2020-06-05 | 2022-04-01 | 武汉大学 | PostgreSQL preparation statement execution optimization method |
CN113806611A (en) * | 2020-06-17 | 2021-12-17 | 海信集团有限公司 | Method and equipment for storing search engine results |
CN111930705B (en) * | 2020-07-07 | 2023-03-14 | 中国电子科技集团公司电子科学研究院 | Binary message protocol data processing method and device |
CN112148792B (en) * | 2020-09-16 | 2024-04-12 | 鹏城实验室 | Partition data adjustment method, system and terminal based on HBase |
CN112052347B (en) * | 2020-10-09 | 2024-06-04 | 北京百度网讯科技有限公司 | Image storage method and device and electronic equipment |
CN112416925B (en) * | 2020-11-02 | 2024-04-09 | 浙商银行股份有限公司 | Query method based on ordered distributed index structure and distributed database system |
CN112364033B (en) * | 2021-01-13 | 2021-04-13 | 北京云真信科技有限公司 | Data retrieval system |
CN113760900A (en) * | 2021-02-19 | 2021-12-07 | 西安京迅递供应链科技有限公司 | Method and device for real-time data summarization and interval summarization |
CN112905615B (en) * | 2021-03-02 | 2023-03-24 | 浪潮云信息技术股份公司 | Distributed consistency protocol submission method and system based on sequence verification |
CN112925841B (en) * | 2021-03-26 | 2022-11-08 | 瀚高基础软件股份有限公司 | Distributed JDBC implementation method, device and computer-readable storage medium |
CN113407662B (en) * | 2021-08-19 | 2021-12-14 | 深圳市明源云客电子商务有限公司 | Sensitive word recognition method, system and computer readable storage medium |
CN113742370B (en) * | 2021-11-02 | 2022-04-19 | 阿里云计算有限公司 | Data query method and statistical information ciphertext generation method of full-encryption database |
CN115129724A (en) * | 2022-08-29 | 2022-09-30 | 畅捷通信息技术股份有限公司 | Statistical report paging method, system, equipment and medium |
CN116861455B (en) * | 2023-06-25 | 2024-04-26 | 上海数禾信息科技有限公司 | Event data processing method, system, electronic device and storage medium |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103377292A (en) * | 2013-07-02 | 2013-10-30 | 华为技术有限公司 | Database result set caching method and device |
CN103577407A (en) * | 2012-07-19 | 2014-02-12 | 国际商业机器公司 | Query method and query device for distributed database |
CN103984726A (en) * | 2014-05-16 | 2014-08-13 | 上海新炬网络技术有限公司 | Local revision method for database execution plan |
Family Cites Families (22)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101477568A (en) * | 2009-02-12 | 2009-07-08 | 清华大学 | Integrated retrieval method for structured data and non-structured data |
CN101567006B (en) * | 2009-05-25 | 2012-07-04 | 中兴通讯股份有限公司 | Database system and distributed SQL statement execution plan reuse method |
CN102163195B (en) * | 2010-02-22 | 2013-04-24 | 北京东方通科技股份有限公司 | Query optimization method based on unified view of distributed heterogeneous database |
CN102375853A (en) * | 2010-08-24 | 2012-03-14 | 中国移动通信集团公司 | Distributed database system, method for building index therein and query method |
CN102201010A (en) * | 2011-06-23 | 2011-09-28 | 清华大学 | Distributed database system without sharing structure and realizing method thereof |
CN102289482A (en) * | 2011-08-02 | 2011-12-21 | 北京航空航天大学 | Unstructured data query method |
CN103150304B (en) * | 2011-12-06 | 2016-11-23 | 郑红云 | Cloud Database Systems |
US20140074860A1 (en) * | 2012-09-12 | 2014-03-13 | Pingar Holdings Limited | Disambiguator |
CN102902932B (en) * | 2012-09-18 | 2015-12-02 | 武汉华工安鼎信息技术有限责任公司 | The using method of the outside encrypting and deciphering system of the database based on SQL rewrite |
CN103092970A (en) * | 2013-01-24 | 2013-05-08 | 华为技术有限公司 | Database operation method and device |
US9773021B2 (en) * | 2013-01-30 | 2017-09-26 | Hewlett-Packard Development Company, L.P. | Corrected optical property value-based search query |
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 (en) * | 2013-09-12 | 2013-12-25 | 华为技术有限公司 | Database management method and system |
CN104794123B (en) * | 2014-01-20 | 2018-07-27 | 阿里巴巴集团控股有限公司 | A kind of method and device building NoSQL database indexes for semi-structured data |
CN104133858B (en) * | 2014-07-15 | 2017-08-01 | 武汉邮电科学研究院 | Intelligence analysis system with double engines and method based on row storage |
CN104503985A (en) * | 2014-12-03 | 2015-04-08 | 浪潮电子信息产业股份有限公司 | Method for automatically creating Solr index file by Hbase data |
CN104572895B (en) * | 2014-12-24 | 2018-02-23 | 天津南大通用数据技术股份有限公司 | MPP databases and Hadoop company-datas interoperability methods, instrument and implementation method |
CN104731922A (en) * | 2015-03-26 | 2015-06-24 | 江苏物联网研究发展中心 | System and method for rapidly retrieving structural data based on distributed type database HBase |
CN104750815B (en) * | 2015-03-30 | 2017-11-03 | 浪潮集团有限公司 | The storage method and device of a kind of Lob data based on HBase |
CN104731945B (en) * | 2015-03-31 | 2018-04-06 | 浪潮集团有限公司 | A kind of text searching method and device based on HBase |
CN105389375B (en) * | 2015-11-18 | 2018-10-02 | 福建师范大学 | A kind of image index setting method, system and search method based on visible range |
CN105740410A (en) * | 2016-01-29 | 2016-07-06 | 浪潮电子信息产业股份有限公司 | Data statistics method based on Hbase secondary index |
-
2016
- 2016-09-21 CN CN201610842399.7A patent/CN106446153A/en active Pending
-
2017
- 2017-07-17 CN CN201710581193.8A patent/CN107451219B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710580403.1A patent/CN107368575B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710580794.7A patent/CN107451214B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710581275.2A patent/CN107329837B/en active Active
- 2017-07-17 CN CN201710581237.7A patent/CN107463635B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710580417.3A patent/CN107463632B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710581229.2A patent/CN107491345B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710580752.3A patent/CN107247808B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710580754.2A patent/CN107402991B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710580435.1A patent/CN107480198B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710580431.3A patent/CN107491485B/en active Active
- 2017-07-17 CN CN201710585103.2A patent/CN107402995B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710581273.3A patent/CN107451221B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710581195.7A patent/CN107451220B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710580720.3A patent/CN107402989B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710580739.8A patent/CN107402990B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710580456.3A patent/CN107402988B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710581291.1A patent/CN107463637B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710580796.6A patent/CN107402992B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710581256.XA patent/CN107391653B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710580791.3A patent/CN107291948B/en active Active
- 2017-07-17 CN CN201710580416.9A patent/CN107291947B/en not_active Expired - Fee Related
- 2017-07-17 CN CN201710580423.9A patent/CN107402987B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103577407A (en) * | 2012-07-19 | 2014-02-12 | 国际商业机器公司 | Query method and query device for distributed database |
CN103377292A (en) * | 2013-07-02 | 2013-10-30 | 华为技术有限公司 | Database result set caching method and device |
CN103984726A (en) * | 2014-05-16 | 2014-08-13 | 上海新炬网络技术有限公司 | Local revision method for database execution plan |
Non-Patent Citations (2)
Title |
---|
Apache Phoenix;@ApachePhoenix;《Apache.org》;20141029;第1-59页 * |
基于HBase的全文索引及检索技术的研究;吴国泉;《万方》;20160504;第1-63页 * |
Also Published As
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107402990B (en) | Distributed New SQL database system and semi-structured data storage method | |
US20230376487A1 (en) | Processing database queries using format conversion | |
Li | Transforming relational database into HBase: A case study | |
CN103177055B (en) | It is stored as row storage and row stores the hybrid database table of the two | |
CN103177056B (en) | It is stored as row storage and row stores the hybrid database table of the two | |
US20170270022A1 (en) | Intelligent Metadata Management and Data Lineage Tracing | |
CN104750681A (en) | Method and device for processing mass data | |
CN104765731B (en) | Database inquiry optimization method and apparatus | |
US9483513B2 (en) | Storing large objects on disk and not in main memory of an in-memory database system | |
US10970300B2 (en) | Supporting multi-tenancy in a federated data management system | |
WO2021179722A1 (en) | Sql statement parsing method and system, and computer device and storage medium | |
US8983947B2 (en) | Augmenting search with association information | |
Hasani et al. | Lambda architecture for real time big data analytic | |
CN101566986A (en) | Method and device for processing data in online business processing | |
KR20170024039A (en) | Managing data with flexible schema | |
CN103955538A (en) | HBase data persistence and query methods and HBase system | |
US20130325874A1 (en) | Columnwise Storage of Point Data | |
US8700679B2 (en) | Classic to in-memory cube conversion | |
US8364722B2 (en) | Hosting multiple logical databases contained in physical database | |
KR100865481B1 (en) | Method for distributing and managing data using 3d strutured data model | |
KR100984976B1 (en) | The integrating and searching method of alien 2-dimension table | |
Grund et al. | Dynamic partitioning for enterprise applications | |
CN115934679A (en) | Warehouse and table dividing method and device, electronic equipment and storage medium | |
Habich et al. | Next Generation Database Programming and Execution Environment. | |
Gunawardena | Efficient access to hibernate through JSP powered by a new tag library |
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 | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20200429 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. |
|
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CF01 | Termination of patent right due to non-payment of annual fee | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20200609 |