CN105354324A - HC-SQL-based tree structure system and implementation method thereof - Google Patents
HC-SQL-based tree structure system and implementation method thereof Download PDFInfo
- Publication number
- CN105354324A CN105354324A CN201510788633.8A CN201510788633A CN105354324A CN 105354324 A CN105354324 A CN 105354324A CN 201510788633 A CN201510788633 A CN 201510788633A CN 105354324 A CN105354324 A CN 105354324A
- Authority
- CN
- China
- Prior art keywords
- sql
- tree
- unit
- extraction unit
- configuration
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention relates to the technical field of computer application, in particular to an HC-SQL-based tree structure system and an implementation method thereof. The system provided by the invention comprises two parts, namely an HC-SQL and a linked tree, and is externally connected with an HC-SQL configuration assembly. The HC-SQL particularly refers to a high configurable structured query language, and can be configured and assembled through the HC-SQL configuration assembly. The HC-SQL configuration assembly provides a basic unit configuration function and a connector module; a basic unit forms a minimum element of the HC-SQL, includes three types, namely a display unit, an extraction unit and a filter unit, and is used for assembling the HC-SQL; the connector module adds a matching relationship between the HC-SQL and the linked tree; the linked tree exists as a container of the HC-SQL, is divided into two types, namely a main linked tree and sub-linked trees, and is in a one-to-many relationship; one-to-one, one-to-many or many-to-many fusion query operations can be carried out among the sub-linked trees; and the positions of the trees are variable. According to the HC-SQL-based tree structure system, customization processing is carried out on an actual business scene query; management is carried out by the tree structure; and the HC-SQL-based tree structure system has the characteristics of good expansibility, wide application range and the like, and can be effectively applied to multiple business systems.
Description
Technical field
The present invention relates to Computer Applied Technology field, particularly a kind of tree structure system based on HC-SQL and its implementation.
Background technology
Along with the development of Computer Applied Technology, user uses the demand of operation system more to trend towards variation.Along with the complicated of business demand and uncertain factor, the framework of business function changes and secondary development can waste a large amount of time.In traditional business system, the definition of type of service is one-sided or scope is narrower often, and have certain limitation, it is unpractiaca for once defining the viewpoint of benefiting from for a long time.At this time more need a kind of method that flexibility ratio is high and applied widely, when business occurs to change, impact can be controlled to lower level.Therefore, the invention provides a kind of tree structure system based on HC-SQL and method thereof, really meet this requirement.
Summary of the invention
One of technical matters that the present invention solves is the problem of mixing for operation system type of service, uncertain factor is many, provides a kind of tree structure system based on HC-SQL; Achieve business ZOOM analysis, logical instance, greatly reduce the extra manpower and time overhead that cause because of business change, meanwhile, deposit self-defined business with tree structure, can self assemble, coupling, ensure that diversification and the extensibility of system.
Two of the technical matters that the present invention solves are the problem of mixing for operation system type of service, uncertain factor is many to provide a kind of implementation method of the tree structure system based on HC-SQL.
The technical scheme that the present invention one of solves the problems of the technologies described above is:
Described method is total to two parts by HC-SQL and link tree and forms, external HC-SQL configuration component, and provides corresponding exploitation and integrated interface;
Described HC-SQL, is the Structured Query Language (SQL) that height can be joined, is configured by HC-SQL configuration component;
Described HC-SQL configuration component, provides base unit configuration feature and connector modules, for assembled HC-SQL, and generates the unique identification of HC-SQL according to assembling duration; Described base unit, is the least member forming HC-SQL, comprises display unit, extraction unit and filter element three types; Display unit refers in particular to the element of user by can intuitively see after link tree query; Extraction unit is for representing extraction storehouse and the table of the actual use of HC-SQL; Filter element refers on the basis that configured at extraction and the display unit of HC-SQL, to the configuration that this statement filters; Described connector modules, to be set with sublink by the unique identification of HC-SQL and associate one to one, this incidence relation can be removed;
Described link tree, the container as HC-SQL exists, is divided into main chain to connect tree and sublink sets two types, the relation in one-to-many, and main tree can comprise N (N >=0) stalk and link and set; Can carry out one to one between sublink tree, the Fusion query operation of one-to-many or multi-to-multi, under the position of subtree can move to any main tree, as its branch; Each stalk tree can associate a complete HC-SQL statement.
Described HC-SQL configuration component provides CRUD access interface, for inquiring about and safeguard the configuration information of base unit, connector modules.
The present invention solve the problems of the technologies described above two technical scheme be:
The coupling specifically comprising configure base unit, configuration HC-SQL and connector modules is mated with releasing;
Described configure base unit step is:
The first step, adds extraction unit and unit title;
Second step, selects the extraction database of needs and extracts table.
3rd step, log recording, preserves extraction unit;
4th step, adds display unit and unit title;
5th step, selective extraction unit, selective extraction unit optionally shows row;
6th step, whether the displaying row of configurable number Value Types, comprise and suing for peace and whether averaging;
Whether the 7th step, configure all displayings row, comprise whether positive and negative sequence and sort by permanent order;
8th step, log recording, preserves display unit;
9th step, adds filter element and unit title;
Tenth step, selective extraction unit, selective extraction unit optionally filters row;
11 step, adds the condition of filtering item and correspondence, and condition restriction comprises: comprise, do not comprise, equal, be greater than, be more than or equal to, be less than, be less than or equal to and be not equal to totally eight;
12 step, log recording, preserves filter element;
The step of described configuration HC-SQL is:
The first step, newly-built HC-SQL title;
Second step, selects the extraction unit configured;
3rd step, any one display unit of selective extraction unit association and filter element;
4th step, generates unique HC-SQL mark according to current time;
5th step, assembling unique identification, extraction unit, display unit and filter element;
6th step, log recording, completes;
The coupling flow process of connector modules is:
The first step, newly-built main chain connects tree;
Second step, newly-built sublink tree under main chain connects tree;
3rd step, selects the HC-SQL configured, and is associated with sublink tree;
4th step, preserves tree node, adds tree another name for HC-SQL title;
5th step, log recording, completes;
The releasing coupling flow process of connector modules is:
The first step, selects main chain to connect tree;
Second step, selects main chain to connect the lower already present sublink tree of tree;
3rd step, deletes the HC-SQL mapping relations of the lower association of sublink tree;
4th step, preserves tree node, adds tree another name " coupling ";
5th step, log recording, completes.
The present invention is directed to the complicated of business demand and the many problem of uncertain factor, practical business carried out decompose by HC-SQL, refinement and assembling, utilize link tree to carry out depositing displaying, data and actual demand be closely linked.HC-SQL configuration component unified management base unit configures, and realizes service decomposition and ZOOM analysis, and by logical instance; Connector provides coupling and removes matched interfaces, ensure that the combination diversity of link tree; Tree structure ensure that the extensibility of system.
Accompanying drawing explanation
Below in conjunction with accompanying drawing, the present invention is further described:
Fig. 1 is overall construction drawing of the present invention;
Fig. 2 is the configuration sequence figure of base unit;
Fig. 3 is the operant activity figure of link tree.
Embodiment
The present invention is directed to the problem that operation system type of service is mixed, uncertain factor is many, provide a kind of tree structure system based on HC-SQL and its implementation.Achieve business ZOOM analysis, logical instance, greatly reduce the extra manpower and time overhead that cause because of business change.
Fig. 1 illustrates overall construction drawing of the present invention, is total to two parts and forms, external HC-SQL configuration component by HC-SQL and link tree.
HC-SQL: be the Structured Query Language (SQL) that height can be joined, be configured assembling by HC-SQL configuration component.
HC-SQL configuration component: provide base unit configuration feature and connector modules, for assembled HC-SQL, and generates the unique identification of HC-SQL according to assembling duration.
Described link tree: be divided into main chain to connect tree and two types are set in sublink, relation in one-to-many, the unrestricted number of main tree, can have M (M >=0), and a main tree can comprise N (N >=0) stalk link tree.
Fig. 2 illustrates the configuration sequence figure of base unit, and detailed configuration flow is:
The first step, adds extraction unit and unit title;
Second step, selects the extraction database of needs and extracts table.
3rd step, log recording, preserves extraction unit;
4th step, adds display unit and unit title;
5th step, selective extraction unit, selective extraction unit optionally shows row;
6th step, whether the displaying row of configurable number Value Types, comprise and suing for peace and whether averaging;
Whether the 7th step, configure all displayings row, comprise whether positive and negative sequence and sort by permanent order;
8th step, log recording, preserves display unit;
9th step, adds filter element and unit title;
Tenth step, selective extraction unit, selective extraction unit optionally filters row;
11 step, adds the condition of filtering item and correspondence, and condition restriction comprises: comprise, do not comprise, equal, be greater than, be more than or equal to, be less than, be less than or equal to and be not equal to totally eight;
12 step, log recording, preserves filter element;
Fig. 3 illustrates the operant activity figure of link tree, and the coupling flow process of connector modules is:
The first step, newly-built main chain connects tree;
Second step, newly-built sublink tree under main chain connects tree;
3rd step, selects the HC-SQL configured, and is associated with sublink tree;
4th step, preserves tree node, adds tree another name for HC-SQL title;
5th step, log recording, completes.
Claims (3)
1. based on a tree structure system of HC-SQL, it is characterized in that: described method is total to two parts by HC-SQL and link tree and forms, external HC-SQL configuration component, and provides corresponding exploitation and integrated interface;
Described HC-SQL, is the Structured Query Language (SQL) that height can be joined, is configured by HC-SQL configuration component;
Described HC-SQL configuration component, provides base unit configuration feature and connector modules, for assembled HC-SQL, and generates the unique identification of HC-SQL according to assembling duration; Described base unit, is the least member forming HC-SQL, comprises display unit, extraction unit and filter element three types; Display unit refers in particular to the element of user by can intuitively see after link tree query; Extraction unit is for representing extraction storehouse and the table of the actual use of HC-SQL; Filter element refers on the basis that configured at extraction and the display unit of HC-SQL, to the configuration that this statement filters; Described connector modules, to be set with sublink by the unique identification of HC-SQL and associate one to one, this incidence relation can be removed;
Described link tree, the container as HC-SQL exists, is divided into main chain to connect tree and sublink sets two types, the relation in one-to-many, and main tree can comprise N (N>=0) stalk and link and set; Can carry out one to one between sublink tree, the Fusion query operation of one-to-many or multi-to-multi, under the position of subtree can move to any main tree, as its branch; Each stalk tree can associate a complete HC-SQL statement.
2. a kind of tree structure system based on HC-SQL according to claim 1 is characterized in that: described HC-SQL configuration component provides CRUD access interface, for inquiring about and safeguard the configuration information of base unit, connector modules.
3. an implementation method for the tree structure system based on HC-SQL described in claim 1 or 2, is characterized in that: the coupling specifically comprising configure base unit, configuration HC-SQL and connector modules is mated with releasing;
Described configure base unit step is:
The first step, adds extraction unit and unit title;
Second step, selects the extraction database of needs and extracts table.
3rd step, log recording, preserves extraction unit;
4th step, adds display unit and unit title;
5th step, selective extraction unit, selective extraction unit optionally shows row;
6th step, whether the displaying row of configurable number Value Types, comprise and suing for peace and whether averaging;
Whether the 7th step, configure all displayings row, comprise whether positive and negative sequence and sort by permanent order;
8th step, log recording, preserves display unit;
9th step, adds filter element and unit title;
Tenth step, selective extraction unit, selective extraction unit optionally filters row;
11 step, adds the condition of filtering item and correspondence, and condition restriction comprises: comprise, do not comprise, equal, be greater than, be more than or equal to, be less than, be less than or equal to and be not equal to totally eight;
12 step, log recording, preserves filter element;
The step of described configuration HC-SQL is:
The first step, newly-built HC-SQL title;
Second step, selects the extraction unit configured;
3rd step, any one display unit of selective extraction unit association and filter element;
4th step, generates unique HC-SQL mark according to current time;
5th step, assembling unique identification, extraction unit, display unit and filter element;
6th step, log recording, completes;
The coupling flow process of connector modules is:
The first step, newly-built main chain connects tree;
Second step, newly-built sublink tree under main chain connects tree;
3rd step, selects the HC-SQL configured, and is associated with sublink tree;
4th step, preserves tree node, adds tree another name for HC-SQL title;
5th step, log recording, completes;
The releasing coupling flow process of connector modules is:
The first step, selects main chain to connect tree;
Second step, selects main chain to connect the lower already present sublink tree of tree;
3rd step, deletes the HC-SQL mapping relations of the lower association of sublink tree;
4th step, preserves tree node, adds tree another name " coupling ";
5th step, log recording, completes.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510788633.8A CN105354324B (en) | 2015-11-17 | 2015-11-17 | A kind of tree system and its implementation based on HC-SQL |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510788633.8A CN105354324B (en) | 2015-11-17 | 2015-11-17 | A kind of tree system and its implementation based on HC-SQL |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105354324A true CN105354324A (en) | 2016-02-24 |
| CN105354324B CN105354324B (en) | 2018-06-08 |
Family
ID=55330296
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510788633.8A Active CN105354324B (en) | 2015-11-17 | 2015-11-17 | A kind of tree system and its implementation based on HC-SQL |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105354324B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106503118A (en) * | 2016-10-18 | 2017-03-15 | 国云科技股份有限公司 | A kind of data acquisition system and its implementation based on HC TABLE |
| CN108073692A (en) * | 2017-12-06 | 2018-05-25 | 国云科技股份有限公司 | A kind of enterprise's ranking system and its implementation |
| CN108345658A (en) * | 2018-01-30 | 2018-07-31 | 中国平安人寿保险股份有限公司 | Algorithm calculates decomposing process, server and the storage medium of track |
| CN109814856A (en) * | 2019-01-17 | 2019-05-28 | 平安科技（深圳）有限公司 | Data entry method, device, terminal and computer readable storage medium |
| CN110347573A (en) * | 2018-04-03 | 2019-10-18 | 北京京东尚科信息技术有限公司 | Application program analysis method, device, electronic equipment and computer-readable medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101676910A (en) * | 2008-09-19 | 2010-03-24 | 北京大学 | A page generation method facing to Web application system |
| CN102521411A (en) * | 2011-12-28 | 2012-06-27 | 畅捷通信息技术股份有限公司 | Formula and formula data processing device and formula and formula data processing method |
| CN102521416A (en) * | 2011-12-28 | 2012-06-27 | 用友软件股份有限公司 | Data correlation query method and data correlation query device |
| US8229966B2 (en) * | 2007-09-07 | 2012-07-24 | Teradata Us, Inc. | System to generate a structured query language query by using a dimensional hierarchy |
| CN102646111A (en) * | 2012-02-16 | 2012-08-22 | 中国测绘科学研究院 | Knowledge base-based fast construction method of common correlation information query tree |
-
2015
- 2015-11-17 CN CN201510788633.8A patent/CN105354324B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8229966B2 (en) * | 2007-09-07 | 2012-07-24 | Teradata Us, Inc. | System to generate a structured query language query by using a dimensional hierarchy |
| CN101676910A (en) * | 2008-09-19 | 2010-03-24 | 北京大学 | A page generation method facing to Web application system |
| CN102521411A (en) * | 2011-12-28 | 2012-06-27 | 畅捷通信息技术股份有限公司 | Formula and formula data processing device and formula and formula data processing method |
| CN102521416A (en) * | 2011-12-28 | 2012-06-27 | 用友软件股份有限公司 | Data correlation query method and data correlation query device |
| CN102646111A (en) * | 2012-02-16 | 2012-08-22 | 中国测绘科学研究院 | Knowledge base-based fast construction method of common correlation information query tree |
Non-Patent Citations (1)
| Title |
|---|
| 陈宏宇: ""一元四体"产品模型信息存储设计与实现研究", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106503118A (en) * | 2016-10-18 | 2017-03-15 | 国云科技股份有限公司 | A kind of data acquisition system and its implementation based on HC TABLE |
| CN106503118B (en) * | 2016-10-18 | 2019-06-21 | 国云科技股份有限公司 | A kind of data acquisition system and its implementation based on HC-TABLE |
| CN108073692A (en) * | 2017-12-06 | 2018-05-25 | 国云科技股份有限公司 | A kind of enterprise's ranking system and its implementation |
| CN108073692B (en) * | 2017-12-06 | 2021-09-21 | 国云科技股份有限公司 | Method for implementing enterprise ranking system |
| CN108345658A (en) * | 2018-01-30 | 2018-07-31 | 中国平安人寿保险股份有限公司 | Algorithm calculates decomposing process, server and the storage medium of track |
| CN108345658B (en) * | 2018-01-30 | 2020-12-01 | 中国平安人寿保险股份有限公司 | Decomposition processing method of algorithm calculation track, server and storage medium |
| CN110347573A (en) * | 2018-04-03 | 2019-10-18 | 北京京东尚科信息技术有限公司 | Application program analysis method, device, electronic equipment and computer-readable medium |
| CN110347573B (en) * | 2018-04-03 | 2024-05-17 | 北京京东尚科信息技术有限公司 | Application program analysis method, device, electronic equipment and computer readable medium |
| CN109814856A (en) * | 2019-01-17 | 2019-05-28 | 平安科技（深圳）有限公司 | Data entry method, device, terminal and computer readable storage medium |
| WO2020147385A1 (en) * | 2019-01-17 | 2020-07-23 | 平安科技（深圳）有限公司 | Data entry method and apparatus, terminal and computer-readable storage medium |
| CN109814856B (en) * | 2019-01-17 | 2022-04-15 | 平安科技（深圳）有限公司 | Data entry method, device, terminal and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105354324B (en) | 2018-06-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105354324A (en) | HC-SQL-based tree structure system and implementation method thereof | |
| CN1984170B (en) | Method for processing network alerting information | |
| CN103516551B (en) | Utilize passive pair of RFID tag to optical fiber physical port intelligent management system | |
| CN105068809A (en) | PyQt-based platform for implementing automation project management and case execution | |
| CN102857838B (en) | The again configuration processing method of OLT end to the failure of ONU end parameter configuration | |
| CN104991975A (en) | Data query method and system of electric power business systems | |
| CN107066243A (en) | A kind of parsing of general airborne-bus interface control document and packaging method | |
| CN102055687A (en) | Internet of things (IOT) access gateway | |
| CN103870274A (en) | Visual development assembly for realizing data interaction between heterogeneous systems based on web service technology | |
| CN103500297A (en) | Fine grit authority management method in information system | |
| CN102708213A (en) | Method for realizing BOM (Bill of Material) information transmission between PDM (Product Data Management) system and ERP (Enterprise Resource Planning) system | |
| CN107705017B (en) | Weak configuration method for virtual secondary circuit of intelligent equipment of transformer substation | |
| CN109948938A (en) | The bill of materials configuration method and device and equipment of a kind of enterprise resource planning | |
| CN102540983B (en) | Acquiring method and acquiring device for process data and equipment control system | |
| CN107193245A (en) | The method that coal production industry net information is merged with office internet information | |
| US6944832B2 (en) | System design using part roles | |
| CN104935444A (en) | Heterogeneous log system management configuration device and method | |
| CN105224629A (en) | The implementation method of a kind of XBRL application platform operation flow integration | |
| CN103812735A (en) | Expandable ethernet ring topology network and communication method thereof | |
| CN106161651A (en) | A kind of data screening method based on BlueDrama | |
| CN107807884B (en) | Method for modular management of error codes | |
| CN110209722A (en) | A kind of data-interface for data exchange | |
| CN202385127U (en) | Internet of things access gateway | |
| CN103795727A (en) | Data distribution method based on arborescence structure | |
| CN103139943A (en) | Access gateway of internet of things |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP02 | Change in the address of a patent holder | ||
| CP02 | Change in the address of a patent holder |
Address after: 523808 19th Floor, Cloud Computing Center, Chinese Academy of Sciences, No. 1 Kehui Road, Songshan Lake Hi-tech Industrial Development Zone, Dongguan City, Guangdong Province Patentee after: G-Cloud Technology Co., Ltd. Address before: 523808 No. 14 Building, Songke Garden, Songshan Lake Science and Technology Industrial Park, Dongguan City, Guangdong Province Patentee before: G-Cloud Technology Co., Ltd. |