CN108090215A - A kind of data pick-up method that picture can configure - Google Patents
A kind of data pick-up method that picture can configure Download PDFInfo
- Publication number
- CN108090215A CN108090215A CN201711479223.0A CN201711479223A CN108090215A CN 108090215 A CN108090215 A CN 108090215A CN 201711479223 A CN201711479223 A CN 201711479223A CN 108090215 A CN108090215 A CN 108090215A
- Authority
- CN
- China
- Prior art keywords
- data
- sql
- picture
- pick
- data pick
- 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.)
- Pending
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/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/84—Mapping; Conversion
-
- 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
Abstract
The invention discloses a kind of data pick-up methods that picture can configure, and are as follows：It is configured by picture, completes data pick-up configuration information；According to the configuration information of step (1), data pick-up engine is run, completes SQL syntax parsing and data retrieval and the data organization of hierarchical structure.It can be realized using this method and be configured by picture, the data pick-up computing of finish relation database and XML file and the data organization of hierarchical structure, the data-interface for greatly improving application system research and develop demand response speed.
Description
Technical field
The present invention relates to Data Extraction Technology field, a kind of data pick-up method that specifically picture can configure.
Background technology
Data pick-up is the process that data are extracted from data source, and in practical application, data source is more using relation
Database.
On Data Extraction Technology, usually by program customized development in software application field, for relation data
Storehouse data extract according to application demand and are organized as bivariate table data mode, are called convenient for application system as data-interface, but
Since the demand data of application system is without specific rule, and often data-interface has business hierarchical structure requirement, and program is caused to be determined
Inhibition and generation work is significantly increased, and also just further the efficiency of research and development to application system and demand response speed have a huge impact.
The content of the invention
Be directed to the application system present in the prior art efficiency of research and development is low and the slow-footed defect of demand response, provide
A kind of data pick-up method that picture can configure can realize using this method and be configured by picture, finish relation database and
The data pick-up computing of XML file and the data organization of hierarchical structure greatly improve the data-interface research and development demand of application system
Response speed.
To achieve the above object, the technical solution adopted by the present invention is：A kind of data pick-up method that picture can configure, tool
Body step is as follows：
(1), configured by picture, complete data pick-up configuration information；
(2), the configuration information according to step (1) runs data pick-up engine, completes SQL syntax parsing and data retrieval
And the data organization of hierarchical structure.
Preferably, in the step (1), it is as follows：
(1.1), data source registration management is extracted, supports relational database and XML file share and access；
(1.2), multi-layer query task relation is set by business demand；
(1.3), the business realizing of SQL is extracted, the Annotations containing incoming parameter is write；
(1.4), the incoming parameter attribute information setting of SQL is extracted；
(1.5), the data processing of information setting that SQL performs retrieval set, the data of the back end containing XML file are extracted
Processing.
Preferably, the engine-operated specific method of data pick-up in the step (2) comprises the following steps：
(2.1), syntactic analysis is performed to the SQL statement of setting, SQL parsings is completed according to ginseng grammer is passed；
(2.2), SQL retrievals are performed；
(2.3), according to the design of common data structure, to the hierarchy structure of more SQL retrieval results completion data.
The present invention has the following advantages compared with prior art：
The data pick-up method that a kind of picture of the present invention can configure is can configure using picture in data pick-up field
Data pick-up design and based on search grammer extraction engine, variation demand of the business demand for data can be tackled, greatly
The big workload for reducing customized development interface, promotes the research and development of application system and demand response efficiency.
Description of the drawings
Fig. 1 is the execution flow chart of the data pick-up engine in embodiment 1.
Specific embodiment
The effect of to make to structure feature of the invention and being reached, has a better understanding and awareness, to preferable
Embodiment and attached drawing cooperation detailed description, are described as follows：
The invention discloses a kind of data pick-up methods that picture can configure, and are as follows：
(1), configured by picture, data pick-up configuration information is completed, containing relational database and XML file；
(2), the configuration information according to step (1) runs data pick-up engine, completes SQL syntax parsing and data retrieval
And the data organization of hierarchical structure.
Preferably, in the step (1), it is as follows：
(1.1), data source registration management is extracted, supports relational database and XML file share and access；
(1.2), multi-layer query task relation is set by business demand；
(1.3), the business realizing of SQL is extracted, the Annotations containing incoming parameter is write；
(1.4), the incoming parameter attribute information setting of SQL is extracted；
(1.5), the data processing of information setting that SQL performs retrieval set, the data of the back end containing XML file are extracted
Processing.
Preferably, the data pick-up in the step (2) is engine-operated, following steps are specifically included：
(2.1), syntactic analysis is performed to the SQL statement of setting, SQL parsings is completed according to ginseng grammer is passed；
(2.2), SQL retrievals are performed；
(2.3), according to the design of common data structure, to the hierarchy structure of more SQL retrieval results completion data.
Embodiment 1
As shown in Figure 1, the engine-operated specific method of data pick-up of the present invention comprises the following steps：
(1), configuration information is set according to picture, creates data source and access connection；
(2), the SQL statement of configuration is read, by grammar parser, identifies the annotation information of incoming parameter, resolving to can
Perform SQL statement；
(3), SQL retrievals are performed；
(4), the configuration information set according to picture, is handled and is integrated to SQL retrieval sets, is turned including data
It changes, the reading parsing of XML data node and the object assembling of result set；
(5), the query task hierarchical relationship set according to business demand builds the business number of levels of more SQL query results
According to structure, and return to calling system.
Basic principle, main feature and the advantages of the present invention of the present invention has been shown and described above.The technology of the industry
Personnel are it should be appreciated that the present invention is not limited to the above embodiments, and what is described in the above embodiment and the description is only the present invention
Principle, various changes and modifications of the present invention are possible without departing from the spirit and scope of the present invention, these variation and
Improvement is both fallen in the range of claimed invention.The present invention claims protection domain by appended claims and its
Equivalent defines.
Claims (3)
1. a kind of data pick-up method that picture can configure, it is characterised in that：It is as follows：
(1), configured by picture, complete data pick-up configuration information；
(2), according to step (1) configuration information, run data pick-up engine, complete SQL syntax parsing and data retrieval and
The data organization of hierarchical structure.
2. the data pick-up method that a kind of picture according to claim 1 can configure, it is characterised in that：The step
(1) in, it is as follows：
(1.1), data source registration management is extracted, supports relational database and XML file share and access；
(1.2), multi-layer query task relation is set by business demand；
(1.3), the business realizing of SQL is extracted, the Annotations containing incoming parameter is write；
(1.4), the incoming parameter attribute information setting of SQL is extracted；
(1.5), the data processing of information for extracting SQL execution retrieval sets is set, at the data of the back end containing XML file
Reason.
3. the data pick-up method that a kind of picture according to claim 1 can configure, it is characterised in that：The step
(2) the engine-operated specific method of data pick-up in comprises the following steps：
(2.1), syntactic analysis is performed to the SQL statement of setting, SQL parsings is completed according to ginseng grammer is passed；
(2.2), SQL retrievals are performed；
(2.3), according to the design of common data structure, to the hierarchy structure of more SQL retrieval results completion data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711479223.0A CN108090215A (en) | 2017-12-29 | 2017-12-29 | A kind of data pick-up method that picture can configure |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711479223.0A CN108090215A (en) | 2017-12-29 | 2017-12-29 | A kind of data pick-up method that picture can configure |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108090215A true CN108090215A (en) | 2018-05-29 |
Family
ID=62180797
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711479223.0A Pending CN108090215A (en) | 2017-12-29 | 2017-12-29 | A kind of data pick-up method that picture can configure |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108090215A (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105069142A (en) * | 2015-08-18 | 2015-11-18 | 山大地纬软件股份有限公司 | System and method for extraction, transformation and distribution of data increments |
| CN105138864A (en) * | 2015-09-24 | 2015-12-09 | 大连理工大学 | Protein interaction relationship data base construction method based on biomedical science literature |
-
2017
- 2017-12-29 CN CN201711479223.0A patent/CN108090215A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105069142A (en) * | 2015-08-18 | 2015-11-18 | 山大地纬软件股份有限公司 | System and method for extraction, transformation and distribution of data increments |
| CN105138864A (en) * | 2015-09-24 | 2015-12-09 | 大连理工大学 | Protein interaction relationship data base construction method based on biomedical science literature |
Non-Patent Citations (1)
| Title |
|---|
| JUEDREAM: "kettle详解（数据抽取、转换、装载）", 《CSDN》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109614432B (en) | System and method for acquiring data blood relationship based on syntactic analysis | |
| CN104424269A (en) | Data linage analysis method and device | |
| CN104899295B (en) | A kind of heterogeneous data source data relation analysis method | |
| US8862636B2 (en) | Scalable algorithms for mapping-based XML transformation | |
| CN103186639B (en) | Data creation method and system | |
| CN106611044B (en) | SQL optimization method and equipment | |
| US20140344817A1 (en) | Converting a hybrid flow | |
| CN110716749B (en) | Code searching method based on functional similarity matching | |
| CN107203640B (en) | Method and system for establishing physical model through database operation record | |
| CN110674229A (en) | AST-based relational database SQL table relational analysis and display method | |
| CN111008020B (en) | Method for analyzing logic expression into general query statement | |
| CN103744651A (en) | Method for automatically generating business processing model oriented to business requirements | |
| CN114625732A (en) | Query method and system based on Structured Query Language (SQL) | |
| CN111078702A (en) | SQL sentence classification management and unified query method and device | |
| WO2021253641A1 (en) | Shading language translation method | |
| CN102902778A (en) | Query sentence optimization device and query sentence optimization method | |
| CN115221143A (en) | Cross-type migration operator-based multi-source big data processing method | |
| CN103927402A (en) | Control logic diagram modular design management system implementation method | |
| CN113934750A (en) | Data blood relationship analysis method based on compiling mode | |
| US20070282804A1 (en) | Apparatus and method for extracting database information from a report | |
| He-ping et al. | Research and implementation of ontology automatic construction based on relational database | |
| CN108090215A (en) | A kind of data pick-up method that picture can configure | |
| CN111914028A (en) | Method and device for synchronizing data relation of heterogeneous data sources based on graph increment | |
| CN112445867A (en) | Intelligent analysis method and system for data relationship | |
| CN116303359A (en) | Method for realizing multi-type document export of database structure |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180529 |