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 PDF

Info

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
Application number
CN201710580739.8A
Other languages
Chinese (zh)
Other versions
CN107402990A (en
Inventor
晋彤
谭恒亮
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Yunrun Da Data Service Co ltd
Original Assignee
Yunrun Da Data Service Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Yunrun Da Data Service Co ltd filed Critical Yunrun Da Data Service Co ltd
Publication of CN107402990A publication Critical patent/CN107402990A/en
Application granted granted Critical
Publication of CN107402990B publication Critical patent/CN107402990B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

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

Abstract

The information distribution a distributed new SQL database system, while computing The control unit used for accessing The user request in The database interface mode and sending The user request to The mapping unit, The user request computing The JSON data to The write, The mapping unit used for mapping The user request in The mapping unit, The mapping unit used for mapping The mapping unit in The mapping unit, The mapping unit used for mapping The user request in The mapping unit, The mapping unit used for mapping The mapping unit in The mapping unit, The mapping unit used in The mapping unit used in The mapping unit, The mapping unit used in The mapping unit, The mapping unit in The mapping unit, and The mapping unit in The mapping unit, and mapping unit in The A data table, and writing The index data into The index table, The information aspect a semi-structured data query method, The information can analyze data query in JSON format, and a solution The schemes of a port effect and a performance in processing semi-structured data.

Description

Distributed New SQL database system and semi-structured data storage method
Technical   Field
The innovation references to The technical field of big data, in divided to a distributed New SQL database system and a semi-structured data storage method.
Backsound
The Hbase main component comprises an HMmaster and an HRegionserver, a table type data model is provided for a user, a main key range is two video in-a complexity of regions, The HMmaster is storing for marking and distributing The regions, and The HRegeneration server is storing and writing data of The regions, The existing Hbase stored data has no data type, and is b byte array, a so that The present scheme in a query existing-structured data is stored in The region of The Hb store data, the weight JSON object is stored as a character string, This approach has the following paragraphs, the weight:
When the term "record" is used herein to refer to the record having been filtered, all the record having been accessed to the read out and the filtered at the client, and the performance term having been accessed in the case of the large data volume.
When a recorded new to be updated, the recorded new to be read out, updated to a specific field, and the n-read to Hbase for overwriting.
Discloseness of invasion
The organizational of The inventory information to product a distributed New SQL database system and a semi-structured data storage method, a high chair real data storage in a JSON format and a solution The programs of force effect and performance in processing semi-structured data.
In order to achieve the above object, an embodiment of the present invention provides a modified New SQL database system, including:
The control unit used for accessing a user request in a database interface mode and sending The user request to The playing unit;
The placing unit used for adapting The user request, The compiling and generating a correcting execution place;
The execution unit is used for writing The JSON data serving as a common character string type as a word in a data field recording to an execution plan;
The Hbase unit used for storing The data table and The index table, The JSON type data area extended to The bottom layer of The Hbase unit, and The JSON data area integrated in The bottom layer HFile, The Hbase unit future a sequential processing module, and The sequential processing module used for generating The index table in The inverted form of The JSON data as a sequential type of The n-type write data and The writing index table.
A computer with the private area, the distributed new SQL database system distributed by the information first access a user request in a database interface mode through the control unit and the sensor the user request to the display unit, the computer, the user request through the data unit, the computing and generating a computing environment, the computer, and writing the index data into the technical scheme of the index table, so the data storage in the JSON format is analyzed, and the schemes of the door effect and door performance in the section-structured data is processed are analyzed.
The execution unit is configured to return the processing result of the Hbase unit to the control unit, and the control unit is used by the user for returning the processing result to the user.
The method of manufacturing the device comprises applying a solution of a mixture of a plurality of reagents, a solvent, and a solvent to the device, and applying the solution to the device.
The Hbase unit furter comprises a filtering module, and the filtering module and the co-processing module are configured to generate the index table for data.
Further, the database interface is JDBC or ODBC.
The embodiment of The present introduction furniture a method for storing a semi-structured data, The distributed New SQL database system protocol in The embodiment of The present introduction entries:
The user request comprises JSON data requiring to be written;
Analyzing the user request through a planning unit, a compiling and generating a correcting execution plan;
Writing the JSON data serving as a common character string type as a floor inter a data as a data field through an execution unit recording to an execution plan, a neighbor the data stored in the Hbase unit, a JSON type data area added to the bottom layer of the Hbase unit, and a JSON data area inter in the bottom layer HFile;
When the JSON data is written to the input a data table, the JSON data is used as a secondary type to generated index data in an inverted index for the third layer of the reactive processing module of the Hbase unit, and the index data is written to the index table, the index table stored in the Hbase unit.
The computer-readable storage medium, and the index data write in the technical scheme of index table implementations of JSON form, and the effect and the not good process of performance write solving-structured data.
Further, after the index data is write in an index table by the synergistic processing module, the method of funther inclusions:
Returning, by the execution unit, a processing result of the Hbase unit to the control unit;
And the control unit returning the processing result to the user.
Further, the method lso comprises the following steps:
And a second binding multiple partitions in the execution plan to the fine distributed transaction manager in the execution plan through a third distributed transaction manager.
The Hbase unit furter a filtering module, and the index table for the data generated through the filtering module and the co-processing module.
Further, the database interface is JDBC or ODBC.
Drawings
FIG. 1 is an a schematic structural diagram of a distributed New SQL database protocol in implementation 1 of the present introduction;
FIG. 2 is a schema flow chart of a semi-structured data storage method recording to implementation 2 of the present invent introduction;
FIG. 3 is a schematic flow chart of generating an execution plan in step S2 of the semi-structured data storage method of recording to implementation 2 of the present input.
Detailed   Description
The technical solutions in The description of The present information with less detail and less description with reference to The drawing in The description of The present information, and The present of The description of The present embodiment with a part of The description of The present information, and The not of The present information with other embodiments, The present of The present invention with a part of The description of The present invention, and The not of The present invention with The use of The present invention in The description of The present invention.
Referring to fig. 1, fig. 1 is a systematic structural dimension of a distributed New SQL database system technical in implementation 1 of the present input, where the technical structure of the present inputs:
The control unit 1 is used for accessing a user request in a database interface mode and sending The user request to The playing unit 2;
The placing unit 2 is used for adapting The user request, The compiling and generating a correcting execution place;
The execution unit 3 is used for writing The JSON data serving as a common character string type as a world in a data field recording to an execution plan;
The Hbase unit 4 is used for storing The data table and The index table, The herein JSON type data area added to The bottom layer of The Hbase unit 4, and The JSON data area incorporated in The bottom layer HFile, The Hbase unit 4, The bottom layer a processing module 41, The configured processed data in The converted data area, and The write index data in The JSON index table.
In the embodiment, the JSON type data is added to the bottom layer of the Hbase unit 4, the JSON data is integrated stored In the bottom layer HFile, and the index column of the JSON is used as a new type for indicating a new a second index is contained, so as to be used as a field request, index and deletion for the JSON be supported.
The execution unit 3 is configured to return the processing result of the Hbase unit 4 to the control unit 1, and the control unit 1 is furter configured to return the processing result to the user.
The method of creating The distributed transaction processing system includes creating a distributed transaction processing system, creating a distributed transaction, and creating a distributed transaction, creating a transaction, and creating.
Specific, The mapping unit 2 is configured to, after The user request is from The control unit 1, part of The user request, component SQL by a high-speed SQL engine, And The generation-an execution unit, The execution unit 2 is configured to generate an execution unit And a return The execution unit to The control unit 1, The execution unit 1 is configured to generate a distribution of The interaction manager request to The distribution of The interaction manager request And The execution of The distribution of The interaction manager request.
The Hbase unit 4 furter inclusion a filtering module, and the filtering module and the co-processing module 41 are configured to generate the index table for data.
Further, the database interface is JDBC or ODBC.
The control unit 1 is an associated connected to a monitor for a marking charge of metadata management and for monitoring the load of the underlying hbase Region, the relating of the eating of the hbase Region is overloaded, and the distributing of the Region by using the relating of the concurrent processing module 41.
In addition, the control unit 1 is an all configured to coordinate data communication, a routine of roles and a management the overall process.
The planning unit 2 is configured to generate a process of executing a plan, and specific entities:
Judging of a pre-stored SQL statement correlation to the SQL statement correlations in the shared cache pool, if so, output of an execution plan correlation to the SQL statement, and if not, output of an execution plan correlation to the SQL statement
A synchronization decoding is carried out on the SQL statement, if the synchronization error return information to a user, other,
(ii) a Semantic check is carried out on the SQL statement, if the Semantic is wand, error information is returned to the user, other,
A licensing out view and expression conversion on the SQL status to object a licensing conversion result;
Selecting an optimizing recording to the conversion result to the object a correcting optimizing Selecting result;
Selecting a correcting data connecting mode and a correcting connecting sequence recording to the Selecting result of the optimizer;
Selecting a selected path accessing to the connection mode and the connection sequence;
And outputting the execution plan.
The computer program product may include a computer program product, a computer program, a computer program, a, the processing result of the Hbase unit 4 is recycled to the control unit 1 by the evaluation unit 3, and the control unit 1 is recycled to the processing result.
The distributed New SQL database system can be realized data storage in JSON format, and has good effect and performance of processing semi-structured data.
Referring to fig. 2, fig. 2 is a schematic flow chart of a semi-structured data storage method in implementation 2 of the present input, where this implementation includes the steps of:
S1, accessing a user request in a database interface mode through the control unit 1, and sending the user request to the planning unit 2; the user request comprises JSON data needing to be written;
S2, analyzing the user request through a planning unit 2, a planning and a generating a correcting execution plan;
S3, writing the JSON data serving as a common character string type as a floor interacting to an execution plan by the execution unit 3, writing the data table stored in Hbase unit 4, JSON type data area added to the bottom layer of the Hbase unit 4, and the JSON area interacting stored in the bottom layer HFile;
An S4, the where the JSON data is written into the a data table, the generating index data in an inverted index for the by using the JSON data as a neutral type of the cooperative processing module 41 of the Hbase unit 4, And the writing the index data in the index table, the where the index data is stored in the Hbase unit 4.
In the embodiment, the JSON type data is added to the bottom layer of the Hbase unit 4, the JSON data is integrated stored In the bottom layer HFile, and the index column of the JSON is used as a new type for indicating a new a second index is contained, so as to be used as a field request, index and deletion for the JSON be supported.
Further, after the step S4 writes the index data into the index table through the synergistic processing module 41, the method of the step S of:
S5, the execution unit 3 returning the processing result of the Hbase unit 4 to the control unit 1;
S6, turning the processing result to the user through the control unit 1.
The method includes steps of fusing, after the step S2 of the present embodiment components generating the execution plane, communicating the execution plane with the execution plane, communicating the execution plane.
The future, the present embodiment generators the index table for data by the filtering module and the synergistic processing module 41 of the Hbase unit 4.
Further, the database interface is JDBC or ODBC.
Referring to fig. 3, fig. 3 is a schematic flow chart of generating an executing place through the executing unit 2 in step S2, and specific entities:
S201, judging the previous stored SQL statement correcting to the SQL statement execution in the shared cache pool, if so, outputting an execution plan correcting to the SQL statement, and if not, outputting an execution plan correcting to the SQL statement
S202, synthesizing the SQL status out on, if the synthesizing errors return information to the user, other wise,
S203, the semantic check is carried out on the SQL statement, if the semantic error return information to the user, other,
S204, carrying out view and expression conversion on the SQL status to object a correction conversion result;
S205, selecting an optimizing recording to the conversion result to the object a correcting optimizing selecting result;
S206, selecting a correlation data connection mode and a correlation connection sequence recording to the selection result of the optimizer;
S207, selecting a searched path accessing to the connection mode and the connection sequence;
And S208, generating an execution plan recording to the search path And outputting the execution plan.
The computer program product may include a computer program product, a computer program, a computer program, a, the processing result of the Hbase unit 4 being returned to the control unit 1 by the execution unit 3, and the control unit 1 being returned to the processing unit.
The distributed New SQL database system can be realized data storage in JSON format, and has good effect and performance of processing semi-structured data.
While the following is directed to the predicted embodiment of the present input, it will be understood by the following will be slid in the art of the present changes and modifications, may be made by the following of the macro of the present with the following removal of the from the scope and scope of the input.

Claims (8)

1. A distributed New SQL database system, comprising:
The control unit is used for accessing a user request in a database interface mode and sending The user request to The mapping unit, The user request comprises JSON data requiring to be written, The database interface is JDBC or ODBC;
The mapping unit is used for mapping The user request, mapping and generating a mapping execution plan, mapping plan to The SQL status execution plan, mapping plan to The mapping plan, mapping plan and mapping plan to The mapping plan, mapping plan to The mapping plan and mapping plan to The mapping plan, mapping plan and mapping plan to The mapping plan and mapping plan to The mapping plan and mapping plan to The mapping plan and mapping plan to The mapping plan to Selecting a selected path to the connection mode and the connection sequence, generating an execution plan to the search path and outputting the execution plan;
The execution unit is used for writing The JSON data serving as a common character string type as a word in a data field recording to an execution plan;
The Hbase unit used for storing The data table and The index table, The JSON type data area extended to The bottom layer of The Hbase unit, and The JSON data area integrated in The bottom layer HFile, The Hbase unit future a sequential processing module, and The sequential processing module used for generating The index table in The inverted form of The JSON data as a sequential type of The n-type write data and The writing index table.
2. The distributed New SQL database system recording to client 1, where The execution unit is configured to return The processing result of The Hbase unit to The control unit, where The control unit is used for returning The processing result to The user.
3. The distributed New SQL database system recording to claim 2, The background computing and The distributed transaction manager is used for recording The multi-level application programs in The execution plane to The distributed transaction manager in The accessed version.
4. The distributed New SQL database system of claim 3, The Hbase unit furter comprising a filtering module, The filtering module and The co-processing module to generate The index table for data.
5. A semi-structured data storage method based on the distributed New SQL database system of ways of claims 1 to 4, while the modified by means of the following steps:
The user request comprises JSON data Accessing to be write;
A mapping table for mapping a mapping table to a mapping table, a mapping table for mapping table to a mapping table selecting a selected path accessing to the connection mode and the connection sequence, generating an execution plan accessing to the search path and outputting the execution plan;
Writing the JSON data serving as a common character string type as a floor inter a data as a data field through an execution unit recording to an execution plan, a neighbor the data stored in the Hbase unit, a JSON type data area added to the bottom layer of the Hbase unit, and a JSON data area inter in the bottom layer HFile;
When the JSON data is written to the input a data table, the JSON data is used as a secondary type to generated index data in an inverted index for the third layer of the reactive processing module of the Hbase unit, and the index data is written to the index table, the index table stored in the Hbase unit.
6. The method of claim 5, The method after The index data is write to an index table by The co-processing module, The method of:
Returning, by the execution unit, a processing result of the Hbase unit to the control unit;
And the control unit returning the processing result to the user.
7. A method of semi-structured data storage recording to close 5, further composing:
An arbitrary coordination multi-party application program in the execution plane to a fine distributed transaction management area in the execution plane through a distributed transaction manager.
8. The method of claim 5, The method of The Hbase unit filter module, and The index table for data generated by The filter module and The co-processing module.
CN201710580739.8A 2016-09-21 2017-07-17 Distributed New SQL database system and semi-structured data storage method Expired - Fee Related CN107402990B (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN2016108423997 2016-09-21
CN201610842399.7A CN106446153A (en) 2016-09-21 2016-09-21 Distributed newSQL database system and method

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
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
CN201710581275.2A Active CN107329837B (en) 2016-09-21 2017-07-17 Load balancing method and unit and distributed NewSQL database system
CN201710580796.6A Expired - Fee Related CN107402992B (en) 2016-09-21 2017-07-17 Distributed NewSQL database system and full-text retrieval establishing method
CN201710580456.3A Expired - Fee Related CN107402988B (en) 2016-09-21 2017-07-17 Distributed NewSQL database system and semi-structured data query method
CN201710580794.7A Expired - Fee Related CN107451214B (en) 2016-09-21 2017-07-17 Non-primary key query method and distributed NewSQL database system
CN201710585103.2A Expired - Fee Related CN107402995B (en) 2016-09-21 2017-07-17 Distributed newSQL database system and method
CN201710581256.XA Expired - Fee Related CN107391653B (en) 2016-09-21 2017-07-17 Distributed NewSQL database system and picture data storage method
CN201710580403.1A Expired - Fee Related CN107368575B (en) 2016-09-21 2017-07-17 Load-balanced 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
CN201710580423.9A Active CN107402987B (en) 2016-09-21 2017-07-17 Full-text retrieval method and 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
CN201710581273.3A Expired - Fee Related CN107451221B (en) 2016-09-21 2017-07-17 Database interface unit device and distributed NewSQL database system
CN201710581193.8A Expired - Fee Related CN107451219B (en) 2016-09-21 2017-07-17 Method for analyzing second index and distributed New SQL database
CN201710580417.3A Expired - Fee Related CN107463632B (en) 2016-09-21 2017-07-17 Distributed NewSQL database system and data query method
CN201710580739.8A Expired - Fee Related CN107402990B (en) 2016-09-21 2017-07-17 Distributed New SQL database system and semi-structured data storage method
CN201710580416.9A Expired - Fee Related CN107291947B (en) 2016-09-21 2017-07-17 Semi-structured data query method and distributed NewSQL database system
CN201710580791.3A Active CN107291948B (en) 2016-09-21 2017-07-17 Access method of distributed newSQL database
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
CN201710581291.1A Expired - Fee Related CN107463637B (en) 2016-09-21 2017-07-17 Distributed NewSQL database system and data storage 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
CN201710581195.7A Expired - Fee Related CN107451220B (en) 2016-09-21 2017-07-17 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
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
CN201710581275.2A Active CN107329837B (en) 2016-09-21 2017-07-17 Load balancing method and unit and distributed NewSQL database system
CN201710580796.6A Expired - Fee Related CN107402992B (en) 2016-09-21 2017-07-17 Distributed NewSQL database system and full-text retrieval establishing method
CN201710580456.3A Expired - Fee Related CN107402988B (en) 2016-09-21 2017-07-17 Distributed NewSQL database system and semi-structured data query method
CN201710580794.7A Expired - Fee Related CN107451214B (en) 2016-09-21 2017-07-17 Non-primary key query method and distributed NewSQL database system
CN201710585103.2A Expired - Fee Related CN107402995B (en) 2016-09-21 2017-07-17 Distributed newSQL database system and method
CN201710581256.XA Expired - Fee Related CN107391653B (en) 2016-09-21 2017-07-17 Distributed NewSQL database system and picture data storage method
CN201710580403.1A Expired - Fee Related CN107368575B (en) 2016-09-21 2017-07-17 Load-balanced 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
CN201710580423.9A Active CN107402987B (en) 2016-09-21 2017-07-17 Full-text retrieval method and 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
CN201710581273.3A Expired - Fee Related CN107451221B (en) 2016-09-21 2017-07-17 Database interface unit device and distributed NewSQL database system
CN201710581193.8A Expired - Fee Related CN107451219B (en) 2016-09-21 2017-07-17 Method for analyzing second index and distributed New SQL database
CN201710580417.3A Expired - Fee Related CN107463632B (en) 2016-09-21 2017-07-17 Distributed NewSQL database system and data query method

Family Applications After (7)

Application Number Title Priority Date Filing Date
CN201710580416.9A Expired - Fee Related CN107291947B (en) 2016-09-21 2017-07-17 Semi-structured data query method and distributed NewSQL database system
CN201710580791.3A Active CN107291948B (en) 2016-09-21 2017-07-17 Access method of distributed newSQL database
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
CN201710581291.1A Expired - Fee Related CN107463637B (en) 2016-09-21 2017-07-17 Distributed NewSQL database system and data storage 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
CN201710581195.7A Expired - Fee Related CN107451220B (en) 2016-09-21 2017-07-17 Distributed NewSQL database system

Country Status (1)

Country Link
CN (24) CN106446153A (en)

Families Citing this family (43)

* Cited by examiner, † Cited by third party
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
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
CN111797112B (en) * 2020-06-05 2022-04-01 武汉大学 PostgreSQL preparation statement execution optimization method
CN111930705B (en) * 2020-07-07 2023-03-14 中国电子科技集团公司电子科学研究院 Binary message protocol data processing method and device
CN112052347A (en) * 2020-10-09 2020-12-08 北京百度网讯科技有限公司 Image storage method and device and electronic equipment
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

Citations (3)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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

Patent Citations (3)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
Title
Apache Phoenix;@ApachePhoenix;《Apache.org》;20141029;第1-59页 *
基于HBase的全文索引及检索技术的研究;吴国泉;《万方》;20160504;第1-63页 *

Also Published As

Publication number Publication date
CN107391653B (en) 2020-05-19
CN107402988A (en) 2017-11-28
CN107451221B (en) 2020-09-04
CN107402991A (en) 2017-11-28
CN107402987A (en) 2017-11-28
CN107391653A (en) 2017-11-24
CN107451220B (en) 2020-06-09
CN107247808A (en) 2017-10-13
CN107402992B (en) 2020-06-09
CN107463635B (en) 2020-09-25
CN107463635A (en) 2017-12-12
CN107402990A (en) 2017-11-28
CN107402995A (en) 2017-11-28
CN107463637B (en) 2020-05-19
CN107291948B (en) 2020-05-19
CN107451219B (en) 2020-06-09
CN107451214A (en) 2017-12-08
CN107402991B (en) 2020-05-19
CN107451219A (en) 2017-12-08
CN107368575B (en) 2020-06-09
CN107451220A (en) 2017-12-08
CN107368575A (en) 2017-11-21
CN107451221A (en) 2017-12-08
CN107451214B (en) 2020-05-19
CN107491345B (en) 2020-08-04
CN107463632A (en) 2017-12-12
CN107402988B (en) 2020-01-03
CN107402989A (en) 2017-11-28
CN107291948A (en) 2017-10-24
CN107463632B (en) 2020-06-09
CN107291947A (en) 2017-10-24
CN107329837B (en) 2020-06-09
CN107491485B (en) 2020-08-04
CN107480198A (en) 2017-12-15
CN107402992A (en) 2017-11-28
CN107291947B (en) 2020-03-10
CN107402989B (en) 2020-10-27
CN107402995B (en) 2020-06-09
CN107491485A (en) 2017-12-19
CN107329837A (en) 2017-11-07
CN106446153A (en) 2017-02-22
CN107463637A (en) 2017-12-12
CN107402987B (en) 2020-04-03
CN107480198B (en) 2020-05-19
CN107491345A (en) 2017-12-19
CN107247808B (en) 2020-01-10

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
US11086751B2 (en) Intelligent metadata management and data lineage tracing
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
CN104750681B (en) A kind of processing method and processing device of mass data
US9639542B2 (en) Dynamic mapping of extensible datasets to relational database schemas
US20130290665A1 (en) Storing large objects on disk and not in main memory of an in-memory database system
CN101566986A (en) Method and device for processing data in online business processing
Hasani et al. Lambda architecture for real time big data analytic
US8983947B2 (en) Augmenting search with association information
US20150088806A1 (en) Supporting multi-tenancy in a federated data management system
KR20170024039A (en) Managing data with flexible schema
US8694508B2 (en) Columnwise storage of point data
CN103955538A (en) HBase data persistence and query methods and HBase system
WO2021179722A1 (en) Sql statement parsing method and system, and computer device and storage medium
US8700679B2 (en) Classic to in-memory cube conversion
US8364722B2 (en) Hosting multiple logical databases contained in physical database
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
CN103617042A (en) Method and device for fixing dimension memorization in multi-dimension analysis system

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