CN102402555A - Dynamic data reading and storing information processing method based on remote database - Google Patents
Dynamic data reading and storing information processing method based on remote database Download PDFInfo
- Publication number
- CN102402555A CN102402555A CN2010102868627A CN201010286862A CN102402555A CN 102402555 A CN102402555 A CN 102402555A CN 2010102868627 A CN2010102868627 A CN 2010102868627A CN 201010286862 A CN201010286862 A CN 201010286862A CN 102402555 A CN102402555 A CN 102402555A
- Authority
- CN
- China
- Prior art keywords
- data
- data structure
- return results
- remote database
- sql statement
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a dynamic data reading and storing information processing method based on a remote database. The method comprises the following steps: 1) inputting an SQL (structured query language) sentence into a PC (personal computer); 2) utilizing the PC to analyze the structure of the input SQL sentence and send the SQL sentence into a remote database server; 3) utilizing the remote database server to execute the SQL sentence and return the result to the PC; 4) utilizing the PC to analyze the returned result, judging whether the current data structure is consistent with the data structure in the returned result or not, if yes, directly storing the returned result data and executing a step 6), if not, executing a step 5); 5) utilizing the PC to automatically define a new data structure serving as the current data structure, then locally storing the returned result data and executing the step 6); and 6), outputting the result by use of the returned result data according to the current data structure. Compared with the prior art, the method has the advantages of more simplicity, conciseness and the like.
Description
Technical field
The present invention relates to a kind of data and read the canned data disposal route, especially relate to a kind of dynamic data and read the canned data disposal route based on remote data base.
Background technology
Development along with infotech; Various industries are for the requirement of data specialty, more and more widely more and more, and the information consultation company of specialty is being engaged in groundworks such as data aggregation, screening, filtration, offer again need these data industry-by-industry or company; And there is consulting firm to be responsible for giving the client with data distribution; That these data have is in extensive range, data volume is huge, characteristics such as promptness height, and these data in industries such as security, consulting, futures by extensively utilization.
Securities broker company is an example; Securities broker company can buy the data that a cover or a few cover third party consulting firm provide; In case the project of disposing need read these advisory data, just can read these data, these systems can adopt in integrated these data usually; Data in synchronous long-range several storehouses are reading from this locality to local data base then earlier.
The data of well-known database storing all are to exist to be mutually related usually; Particularly like this in securities industry; Therefore be easy to generate data association in this locality less than problems such as, data sequencing are inconsistent reading teledata, and each need read the system of teledata, all need set up relevant data structure according to the business of self; These work disposal need need labor intensive, material resources and time, and complexity also increases accordingly.
Summary of the invention
The object of the invention is exactly to provide a kind of simpler, succinct dynamic data based on remote data base to read the canned data disposal route for the defective that overcomes above-mentioned prior art existence.
The object of the invention can be realized through following technical scheme:
A kind of dynamic data based on remote data base reads the canned data disposal route, it is characterized in that, may further comprise the steps:
1) the input SQL statement is in PC;
2) PC is resolved the structure of input SQL statement, and SQL statement is sent in the remote database server;
3) remote database server is carried out SQL statement, and the result is returned to PC;
4) PC is analyzed return results, judge the current data structure whether with return results in data structure consistent, as for being, the return results data are directly stored, and execution in step 6), if not, execution in step 5);
5) PC defines new data structure automatically as the current data structure, again the return results data storage is arrived this locality, and execution in step 6);
6) the return results data are exported the result according to the current data structure.
The structure of the SQL statement described step 2) comprises possessing a key column at least, and the title of row is to repeat, and the data structure after the parsing comprises data name, data type, data order.
New data structure in the described step 5) is the data structure in the return results.
Compared with prior art, the present invention adopts simpler, succinct method to realize that the dynamic data of remote data base reads storage, has solved reading teledata and has been easy to generate data association in this locality less than problems such as, data sequencing are inconsistent.
Description of drawings
Fig. 1 is a process flow diagram of the present invention;
Fig. 2 is a hardware configuration synoptic diagram of the present invention.
Embodiment
Below in conjunction with accompanying drawing and specific embodiment the present invention is elaborated.
Embodiment
Like Fig. 1, shown in Figure 2, a kind of dynamic data based on remote data base reads the canned data disposal route, may further comprise the steps:
1) the input SQL statement is in PC 1;
2) structure of 1 pair of input of PC SQL statement is resolved, and SQL statement is sent in the remote database server 2;
3) remote database server 2 is carried out SQL statement, and the result is returned to PC 1;
4) 1 pair of return results of PC is analyzed, judge the current data structure whether with return results in data structure consistent, as for being, the return results data are directly stored, and execution in step 6), if not, execution in step 5);
5) PC 1 defines new data structure automatically as the current data structure, again the return results data storage is arrived this locality, and execution in step 6);
6) the return results data are exported the result according to the current data structure.
The structure of the SQL statement described step 2) comprises possessing a key column at least, and the title of row is to repeat, and the data structure after the parsing comprises data name, data type, data order.
New data structure in the described step 5) is the data structure in the return results.
Claims (3)
1. the dynamic data based on remote data base reads the canned data disposal route, it is characterized in that, may further comprise the steps:
1) the input SQL statement is in PC;
2) PC is resolved the structure of input SQL statement, and SQL statement is sent in the remote database server;
3) remote database server is carried out SQL statement, and the result is returned to PC;
4) PC is analyzed return results, judge the current data structure whether with return results in data structure consistent, as for being, the return results data are directly stored, and execution in step 6), if not, execution in step 5);
5) PC defines new data structure automatically as the current data structure, again the return results data storage is arrived this locality, and execution in step 6);
6) the return results data are exported the result according to the current data structure.
2. a kind of dynamic data based on remote data base according to claim 1 reads the canned data disposal route; It is characterized in that; The structure of the SQL statement described step 2) comprises possessing a key column at least; And the title of row is to repeat, and the data structure after the parsing comprises data name, data type, data order.
3. a kind of dynamic data based on remote data base according to claim 1 reads the canned data disposal route, it is characterized in that, the new data structure in the described step 5) is the data structure in the return results.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102868627A CN102402555A (en) | 2010-09-19 | 2010-09-19 | Dynamic data reading and storing information processing method based on remote database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102868627A CN102402555A (en) | 2010-09-19 | 2010-09-19 | Dynamic data reading and storing information processing method based on remote database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102402555A true CN102402555A (en) | 2012-04-04 |
Family
ID=45884768
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010102868627A Pending CN102402555A (en) | 2010-09-19 | 2010-09-19 | Dynamic data reading and storing information processing method based on remote database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102402555A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111143369A (en) * | 2019-12-27 | 2020-05-12 | 合肥美的智能科技有限公司 | Cloud service data unloading method and device, local server and electronic equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1439131A (en) * | 2000-04-27 | 2003-08-27 | 网上技术公司 | Method and system for retrieving search results from multiple disparate databases |
| CN1751307A (en) * | 2002-01-18 | 2006-03-22 | 伊迪蒂克公司 | A design for storage and retrieval of arbitrary content and application data |
| CN101488148A (en) * | 2009-02-25 | 2009-07-22 | 浪潮集团山东通用软件有限公司 | Data compilation method in multiple databases |
| CN101799807A (en) * | 2009-02-10 | 2010-08-11 | 中国移动通信集团公司 | Heterogeneous data table merging method and system thereof |
-
2010
- 2010-09-19 CN CN2010102868627A patent/CN102402555A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1439131A (en) * | 2000-04-27 | 2003-08-27 | 网上技术公司 | Method and system for retrieving search results from multiple disparate databases |
| CN1751307A (en) * | 2002-01-18 | 2006-03-22 | 伊迪蒂克公司 | A design for storage and retrieval of arbitrary content and application data |
| CN101799807A (en) * | 2009-02-10 | 2010-08-11 | 中国移动通信集团公司 | Heterogeneous data table merging method and system thereof |
| CN101488148A (en) * | 2009-02-25 | 2009-07-22 | 浪潮集团山东通用软件有限公司 | Data compilation method in multiple databases |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111143369A (en) * | 2019-12-27 | 2020-05-12 | 合肥美的智能科技有限公司 | Cloud service data unloading method and device, local server and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11106906B2 (en) | Systems and methods for information extraction from text documents with spatial context | |
| CN109508352B (en) | Report data output method, device, equipment and storage medium | |
| US8316006B2 (en) | Creating an ontology using an online encyclopedia and tag cloud | |
| US20070088743A1 (en) | Information processing device and information processing method | |
| CN110543571A (en) | knowledge graph construction method and device for water conservancy informatization | |
| CN104281702A (en) | Power keyword segmentation based data retrieval method and device | |
| US20210319039A1 (en) | Extraction of a nested hierarchical structure from text data in an unstructured version of a document | |
| CN110399448B (en) | Chinese place name address searching and matching method, terminal and computer readable storage medium | |
| KR102074578B1 (en) | Text mining based construction document analysis method and system | |
| KR101780377B1 (en) | Method of automatically extracting food safety event in real time from news and social networking service data | |
| WO2016093839A1 (en) | Structuring of semi-structured log messages | |
| CN108804685B (en) | Asset hosting and monitoring task processing method and device | |
| CN116127047B (en) | Method and device for establishing enterprise information base | |
| KR102532216B1 (en) | Method for establishing ESG database with structured ESG data using ESG auxiliary tool and ESG service providing system performing the same | |
| CN103164491B (en) | The method and apparatus of a kind of data processing and retrieval | |
| CN116521729A (en) | Information classification searching method and device based on elastic search | |
| CN102402555A (en) | Dynamic data reading and storing information processing method based on remote database | |
| CN112767933B (en) | Voice interaction method, device, equipment and medium of highway maintenance management system | |
| Beetz et al. | Towards the long-term preservation of building information models | |
| CN114218347A (en) | Method for quickly searching index of multiple file contents | |
| CN113407803A (en) | Method for acquiring internet data in one step | |
| CN113407678A (en) | Knowledge graph construction method, device and equipment | |
| CN112395291A (en) | Method and system for dynamically generating wide table according to data assets | |
| CN113407495A (en) | SIMHASH-based file similarity determination method and system | |
| CN114385794A (en) | Method, device, equipment and storage medium for generating enterprise knowledge graph |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| AD01 | Patent right deemed abandoned |
Effective date of abandoning: 20120404 |
|
| C20 | Patent right or utility model deemed to be abandoned or is abandoned |