CN110362613A - Data processing method and equipment - Google Patents

Data processing method and equipment Download PDF

Info

Publication number
CN110362613A
CN110362613A CN201910659756.XA CN201910659756A CN110362613A CN 110362613 A CN110362613 A CN 110362613A CN 201910659756 A CN201910659756 A CN 201910659756A CN 110362613 A CN110362613 A CN 110362613A
Authority
CN
China
Prior art keywords
data
checked
server
information
database
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
Application number
CN201910659756.XA
Other languages
Chinese (zh)
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.)
China United Network Communications Group Co Ltd
Original Assignee
China United Network Communications Group 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 China United Network Communications Group Co Ltd filed Critical China United Network Communications Group Co Ltd
Priority to CN201910659756.XA priority Critical patent/CN110362613A/en
Publication of CN110362613A publication Critical patent/CN110362613A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2471Distributed queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Probability & Statistics with Applications (AREA)
  • Fuzzy Systems (AREA)
  • Computing Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention provides a kind of data processing method and equipment, this method comprises: server receives the inquiry request that electronic equipment is sent, the inquiry request includes: the information of data to be checked;The server generates the query script of database according to the information of the data to be checked;The data to be checked are stored in the database;The server runs the query script according to the information of the data to be checked, to obtain the data to be checked from the database;The data to be checked are written under the corresponding secure file transportation protocol SFTP permission catalogue of the electronic equipment by the server.The method of the embodiment of the present invention improves the efficiency of data query distribution.

Description

Data processing method and equipment
Technical field
The present invention relates to technical field of data processing more particularly to a kind of data processing methods and equipment.
Background technique
With the propulsion of national telecommunication user data centralized management, national telecommunication user data all collects general headquarters Data center in, required according to national relevant ministries and commissions, various regions pipe office can periodically randomly select provider customer's networking system of real name Etc. data, including certificate front and back sides photo, user's scene photograph, dynamic detection video etc..
In order to avoid storage resource waste, these data are all centrally stored in the distributed data base of data center at present In, and the telecommunications subsystem in various regions province need irregularly/regularly to general headquarters submit data application, it is desirable that exported according to specification The files such as system of real name data.It is general at present to export data from data center by the way of artificial treatment and be distributed to various regions Telecommunications subsystem, efficiency are lower.
Summary of the invention
The present invention provides a kind of data processing method and equipment, to improve data query distribution efficiency.
In a first aspect, the present invention provides a kind of data processing method, comprising:
Server receives the inquiry request that electronic equipment is sent, and the inquiry request includes: the information of data to be checked;
The server generates the query script of database according to the information of the data to be checked;In the database Store the data to be checked;
The server runs the query script, according to the information of the data to be checked with from the database Obtain the data to be checked;
The data to be checked are written to the corresponding secure file transportation protocol of the electronic equipment by the server Under SFTP permission catalogue.
Second aspect, the present invention provide a kind of data processing method, comprising:
Electronic equipment generates inquiry request according to the information of data to be checked;
The electronic equipment sends inquiry request to server, and the inquiry request is looked into according to for the server The information for asking the data to be checked that request includes, generates the query script of database, and according to the information of the data to be checked, The query script is run, to obtain the data to be checked from the database;Number to be checked is stored in the database According to;
The electronic equipment obtains institute under the catalogue that the electronic equipment corresponds to secure file transportation protocol SFTP permission State the data to be checked of server write-in.
The third aspect, the embodiment of the present invention provide a kind of computer readable storage medium, are stored thereon with computer program, Method described in any one of first aspect is realized when the computer program is executed by processor.
Fourth aspect, the embodiment of the present invention provide a kind of server, comprising:
Processor;And
Memory, for storing the executable instruction of the processor;
Wherein, the processor is configured to execute described in any one of first aspect via the executable instruction is executed Method.
Fourth aspect, the embodiment of the present invention provide a kind of electronic equipment, comprising:
Processor;And
Memory, for storing the executable instruction of the processor;
Wherein, the processor is configured to execute described in any one of second aspect via the executable instruction is executed Method.
Data processing method and equipment provided in an embodiment of the present invention, server receive the inquiry that electronic equipment is sent and ask It asks, the inquiry request includes: the information of data to be checked;The server is generated according to the information of the data to be checked The query script of database;The data to be checked are stored in the database;The server is according to the data to be checked Information, the query script is run, to obtain the data to be checked from the database;The server will it is described to Inquiry data are written under the corresponding secure file transportation protocol SFTP permission catalogue of the electronic equipment.It is run by server The query script of database realizes data query distribution, improves the efficiency of data query distribution.
Detailed description of the invention
The drawings herein are incorporated into the specification and forms part of this specification, and shows the implementation for meeting the disclosure Example, and together with specification for explaining the principles of this disclosure.
Fig. 1 is the application scenario diagram that one embodiment of the invention provides;
Fig. 2 is the flow diagram of one embodiment of data processing method provided by the invention;
Fig. 3 is the schematic illustration of one embodiment of data processing method provided by the invention;
Fig. 4 is the flow diagram of another embodiment of data processing method provided by the invention;
Fig. 5 is the structural schematic diagram of one embodiment of data processing equipment provided by the invention;
Fig. 6 is the structural schematic diagram of another embodiment of data processing equipment provided by the invention;
Fig. 7 is the structural schematic diagram of one embodiment of server provided by the invention;
Fig. 8 is the structural schematic diagram of electronic equipment embodiment provided by the invention.
Through the above attached drawings, it has been shown that the specific embodiment of the disclosure will be hereinafter described in more detail.These attached drawings It is not intended to limit the scope of this disclosure concept by any means with verbal description, but is by referring to specific embodiments Those skilled in the art illustrate the concept of the disclosure.
Specific embodiment
Example embodiments are described in detail here, and the example is illustrated in the accompanying drawings.Following description is related to When attached drawing, unless otherwise indicated, the same numbers in different drawings indicate the same or similar elements.Following exemplary embodiment Described in embodiment do not represent all implementations consistent with this disclosure.On the contrary, they be only with it is such as appended The example of the consistent device and method of some aspects be described in detail in claims, the disclosure.
Term " includes " in description and claims of this specification and the attached drawing and " having " and they appoint What is deformed, it is intended that is covered and non-exclusive is included.Such as contain the process, method, system, production of a series of steps or units Product or equipment are not limited to listed step or unit, but optionally further comprising the step of not listing or unit, or Optionally further comprising the other step or units intrinsic for these process, methods, product or equipment.
Application scenarios according to the present invention are introduced first:
Data processing method provided in an embodiment of the present invention, be applied to following scene: the storage of data center, general headquarters is to be checked Data, such as user-network access system of real name data, including certificate front and back sides photo, user's scene photograph, dynamic detection video etc. become More account information data, data such as change set meal etc..Subsystem needs in various regions are periodically or non-periodically obtained from data center Data.
Fig. 1 is the application scenario diagram that one embodiment of the invention provides, optionally, as shown in Figure 1, including in the application scenarios Server 11, data center database 12 and electronic equipment 13;The electronic equipment 13 can be the electricity of various regions telecommunications subsystem Sub- equipment, such as computer.Wherein, database is, for example, distributed relation database (Distributed Relational Database Service, abbreviation DRDS).
Wherein, electronic equipment 13 and server 11 can be logical by network connection, such as 3G, 4G, 5G or cable network etc. Communication network.Electronic equipment 13 can be realized by server 11 obtains data from divided data library 12.
The method of the embodiment of the present invention receives the inquiry request that electronic equipment is sent by server, and inquiry request includes: The information of data to be checked, and then according to the query script of the information of data to be checked generation database, and run the inquiry foot This, realizes data query distribution, improves the efficiency of data query distribution.
Technical solution of the present invention is described in detail with specific embodiment below.These specific implementations below Example can be combined with each other, and the same or similar concept or process may be repeated no more in some embodiments.
Fig. 2 is the flow diagram of one embodiment of data processing method provided by the invention.As shown in Figure 2 and Figure 3, this reality The method that example offer is provided, comprising:
Step 201, server receive the inquiry request that electronic equipment is sent, and inquiry request includes: the letter of data to be checked Breath.
Specifically, can realize the data processing side of the embodiment of the present invention by a data distribution engine in server Case, the data distribution engine can be the application program for inquiring data.
Electronic equipment, that is, request of data method, apparatus generates inquiry request, and be sent to clothes according to the information of data to be checked Business device, server receive the inquiry request that electronic equipment is sent, and execute the process of inquiry data.Such as request of data method, apparatus The letter of data to be checked is inputted by the operation interface of the data query client by one data query client of load Breath generates inquiry request.
Wherein, the information of the data to be checked includes at least one of the following: period belonging to data to be checked, affiliated Province, the system coding of the electronic equipment, the corresponding order type of data to be checked, polling cycle, inquiry enabling time.
Wherein, order type is, for example, the types such as order, modification information order of opening an account, those order types can correspond to one A little user data, such as user certificate photo, user's scene photograph etc..Polling cycle can indicate that the electronic equipment inquires data Period, inquiry enabling time indicate when start log-on data inquiry.Such as from of that month which, every two weeks or one Month inquiry is once opened an account the data of order, and the period belonging to the data is for example from * month No. * to * month No. *.
Step 202, server generate the query script of database according to the information of data to be checked;It is stored in database Data to be checked.
Specifically, server can generate the query statement of database, such as SQL is looked into according to the information of data to be checked Sentence is ask, query script is generated;The database is for storing data, comprising: data to be checked.The database can be distribution Database, for example, DRDS.
Wherein, distributed data base can be connected the multiple Database Unit physically dispersed by computer network Come form one unified database in logic.Distributed data base can link up one unified data base administration of concept stock System is managed.Distributed data base overcomes the weakness of data base organization, physical centre.Firstly, reducing data transmission Cost, because mostly to the access operation of database both for local data bank;Secondly, the reliability of system improves It is very much, because when a network fails, still allow for the operation to local data bank, and the failure of a position not shadow The processing work of other positions is rung, it is just impacted to a certain extent only when accessing the data of failure position;The Three, convenient for the expansion of system, increase a new local data bank, or expand a small-sized calculating appropriate in some position Machine is all easily achieved.
Step 203, server run query script according to the information of data to be checked, to be checked to obtain from database Ask data.
Specifically, information of the server according to data to be checked, such as polling cycle, inquiry enabling time, operation inquiry Script obtains data to be checked to realize from database.
Further, the server can be drawn according to the inquiry enabling time and polling cycle by data distribution The timed task held up runs the query script, to obtain data to be checked from the database.
Wherein, timed task can be for example pre-generated application program, can execute related behaviour in the time of setting Make, such as operation query script.
Query script can regard the set of query sentence of database as, and the effect of data access can be improved using query script Rate realizes data query processing.
The forms such as table can be saved as by the data to be checked that query script obtains.
Data to be checked are written to the corresponding secure file transportation protocol SFTP of electronic equipment and weighed by step 204, server It limits under catalogue.
Specifically, server can be pre-configured with the SFTP account information of multiple electronic equipments, the SFTP account information It include: the SFTP permission catalogue of the electronic equipment access.
The data to be checked that server will acquire are written under the corresponding SFTP permission catalogue of electronic equipment, electronic equipment Periodically data are obtained from the SFTP permission catalogue.
Wherein, server can receive the inquiry request that multiple electronic equipments are sent, and can be directed to different inquiry requests, Query script is generated, and establishes timed task and runs corresponding query script, the data that finally will acquire are written to each electricity Under the corresponding SFTP permission catalogue of sub- equipment.
The inquiry request that server is sent for different electronic equipments can run corresponding inquiry in different times Script.
Further, corresponding query script can also be run by establishing different threads, to obtain inquiry data.
The method of the present embodiment, server receive the inquiry request that electronic equipment is sent, and the inquiry request includes: to be checked Ask the information of data;The server generates the query script of database according to the information of the data to be checked;The data The data to be checked are stored in library;The server runs the query script according to the information of the data to be checked, with The data to be checked are obtained from the database;The data to be checked are written to the electronic equipment by the server Under corresponding secure file transportation protocol SFTP permission catalogue.By the query script in server operation data library, number is realized It is investigated that asking distribution, the efficiency of data query distribution is improved.
Fig. 4 is the flow diagram of another embodiment of data processing method provided by the invention.As shown in figure 4, this implementation The method that example provides, comprising:
Step 401, electronic equipment generate inquiry request according to the information of data to be checked;
Step 402, electronic equipment send inquiry request to server, and inquiry request is for server according to inquiry request packet The information of the data to be checked included generates the query script of database, and according to the information of data to be checked, operation inquiry foot This, to obtain data to be checked from database;Data to be checked are stored in database;
Step 403, electronic equipment are corresponded to from the electronic equipment obtains clothes under secure file transportation protocol SFTP permission catalogue The data to be checked of business device write-in.
Further, before step 401, can also include:
The electronic equipment obtains the SFTP account information of the server configuration, and the SFTP account information includes: institute State the SFTP permission catalogue of electronic equipment access.
Specifically, can realize the data processing side of the embodiment of the present invention by a data distribution engine in server Case, the data distribution engine can be the application program for inquiring data.
Electronic equipment, that is, request of data method, apparatus generates inquiry request, and be sent to clothes according to the information of data to be checked Business device, server receive the inquiry request that electronic equipment is sent, and execute the process of inquiry data.Such as request of data method, apparatus The letter of data to be checked is inputted by the operation interface of the data query client by one data query client of load Breath generates inquiry request.
Wherein, the information of the data to be checked includes at least one of the following: period belonging to data to be checked, affiliated Province, the system coding of the electronic equipment, the corresponding order type of data to be checked, polling cycle, inquiry enabling time.
Wherein, order type is, for example, the types such as order, modification information order of opening an account, those order types can correspond to one A little user data, such as user certificate photo, user's scene photograph etc..Polling cycle can indicate that the electronic equipment inquires data Period, inquiry enabling time indicate when start log-on data inquiry.Such as from of that month which, every two weeks or one Month inquiry is once opened an account the data of order, and the period belonging to the data is for example from * month No. * to * month No. *.
Server can generate the query statement of database, such as SQL query statement according to the information of data to be checked, Generate query script;The database is for storing data, comprising: data to be checked.The database is, for example, DRDS.
Server runs query script according to the information of data to be checked, such as polling cycle, inquiry enabling time, from And it realizes and obtains data to be checked from database.
Further, the server can be drawn according to the inquiry enabling time and polling cycle by data distribution The timed task held up runs the query script, to obtain data to be checked from the database.
Server can be pre-configured with the SFTP account information of multiple electronic equipments, and the SFTP account information includes: institute State the SFTP permission catalogue of electronic equipment access.
The data to be checked that server will acquire are written under the corresponding SFTP permission catalogue of electronic equipment, electronic equipment Periodically data are obtained from the SFTP permission catalogue.
The method of the present embodiment, electronic equipment generate inquiry request according to the information of data to be checked;Electronic equipment is to clothes Business device sends inquiry request, and the information for the data to be checked that inquiry request includes according to inquiry request for server generates number According to the query script in library, and according to the information of data to be checked, query script is run, to obtain number to be checked from database According to;Data to be checked are stored in database;Electronic equipment corresponds to secure file transportation protocol SFTP permission mesh from the electronic equipment The lower data to be checked for obtaining server write-in of record pass through the query script in server operation data library, realize data query point Hair improves the efficiency of data query distribution.
Fig. 5 is the structure chart of one embodiment of data processing equipment provided by the invention, as shown in figure 5, the number of the present embodiment It can be set in the server according to processing unit, which includes:
Receiving module 501, for receiving the inquiry request of electronic equipment transmission, the inquiry request includes: number to be checked According to information;
Processing module 502 generates the query script of database for the information according to the data to be checked;The number According to storing the data to be checked in library;
Processing module 502 is also used to run the query script according to the information of the data to be checked, with from described The data to be checked are obtained in database;
Processing module 502 is also used to for the data to be checked being written to the corresponding secure file of the electronic equipment and passes It send under agreement SFTP permission catalogue.
In one possible implementation, the information of the data to be checked includes: polling cycle, processing module 502, It is specifically used for:
According to the polling cycle, timed task is generated;
The query script is run by the timed task, to obtain the data to be checked from the database; The database is distributed relation database DRDS.
In one possible implementation, processing module 502 are specifically used for:
The SFTP account information of multiple electronic equipments is configured, the SFTP account information includes: the electronic equipment access SFTP permission catalogue.
In one possible implementation, the information of the data to be checked includes at least one of the following: number to be checked According to affiliated period, affiliated province, the system coding of the electronic equipment, the corresponding order type of data to be checked, inquiry Period, inquiry enabling time.
The device of the present embodiment can be used for executing the technical solution of above method embodiment, realization principle and technology Effect is similar, and details are not described herein again.
Fig. 6 is the structure chart of another embodiment of data processing equipment provided by the invention, as shown in fig. 6, the present embodiment Data processing equipment can be set in the electronic device, which includes:
Preprocessing module 601 generates inquiry request for the information according to data to be checked;
Sending module 602, for sending inquiry request to server, the inquiry request is for the server according to institute The information for stating the data to be checked that inquiry request includes generates the query script of database, and according to the data to be checked Information runs the query script, to obtain the data to be checked from the database;It is stored in the database to be checked Ask data;
Module 603 is obtained, for obtaining under the catalogue that the electronic equipment corresponds to secure file transportation protocol SFTP permission Take the data to be checked of the server write-in.
In one possible implementation, module 603 is obtained to be also used to:
The SFTP account information of the server configuration is obtained, the SFTP account information includes: that the electronic equipment is visited The SFTP permission catalogue asked.
In one possible implementation, the information of the data to be checked includes at least one of the following: number to be checked According to affiliated period, affiliated province, the system coding of the electronic equipment, the corresponding order type of data to be checked, inquiry Period, inquiry enabling time.
Fig. 7 is the structure chart of one embodiment of server provided by the invention, as shown in fig. 7, the server includes:
Processor 701, and, the memory 702 of the executable instruction for storage processor 701.
It optionally, can also include: communication interface 703, for realizing the communication with other equipment.
Above-mentioned component can be communicated by one or more bus.
Wherein, processor 701 is configured to execute via the executable instruction is executed:
The inquiry request that electronic equipment is sent is received, the inquiry request includes: the information of data to be checked;
According to the information of the data to be checked, the query script of database is generated;Stored in the database it is described to Inquire data;
According to the information of the data to be checked, run the query script, with obtain from the database it is described to Inquire data;
The data to be checked are written to the corresponding secure file transportation protocol SFTP permission catalogue of the electronic equipment Under.
In one possible implementation, the information of the data to be checked includes: polling cycle, the processor 701 are configured that
According to the polling cycle, timed task is generated;
The query script is run by the timed task, to obtain the data to be checked from the database; The database is distributed relation database DRDS.
In one possible implementation, the processor 701 is configured that
The SFTP account information of multiple electronic equipments is configured, the SFTP account information includes: the electronic equipment access SFTP permission catalogue.
In one possible implementation, the information of the data to be checked includes at least one of the following: number to be checked According to affiliated period, affiliated province, the system coding of the electronic equipment, the corresponding order type of data to be checked, inquiry Period, inquiry enabling time.
For the server of the present embodiment for executing corresponding method in preceding method embodiment, specific implementation process can be with Referring to preceding method embodiment, details are not described herein again.
Fig. 8 is the structure chart of electronic equipment embodiment provided by the invention, as shown in figure 8, the electronic equipment includes:
Processor 801, and, the memory 802 of the executable instruction for storage processor 801.
It optionally, can also include: communication interface 803, for realizing the communication with other equipment.
Above-mentioned component can be communicated by one or more bus.
Wherein, processor 801 is configured to execute via the executable instruction is executed:
According to the information of data to be checked, inquiry request is generated;
Inquiry request is sent to server, the inquiry request includes according to the inquiry request for the server The information of data to be checked generates the query script of database, and according to the information of the data to be checked, runs the inquiry Script, to obtain the data to be checked from the database;Data to be checked are stored in the database;
The server write-in is obtained under the catalogue that the electronic equipment corresponds to secure file transportation protocol SFTP permission The data to be checked.
In one possible implementation, the processor 801 is configured that
The SFTP account information of the server configuration is obtained, the SFTP account information includes: that the electronic equipment is visited The SFTP permission catalogue asked.
In one possible implementation, the information of the data to be checked includes at least one of the following: number to be checked According to affiliated period, affiliated province, the system coding of the electronic equipment, the corresponding order type of data to be checked, inquiry Period, inquiry enabling time.
The electronic equipment of the present embodiment can join for corresponding method in preceding method embodiment, specific implementation process See preceding method embodiment, details are not described herein again.
A kind of computer readable storage medium is also provided in the embodiment of the present invention, is stored thereon with computer program, it is described Realize that corresponding method in preceding method embodiment, specific implementation process may refer to when computer program is executed by processor Preceding method embodiment, it is similar that the realization principle and technical effect are similar, and details are not described herein again.
Those skilled in the art after considering the specification and implementing the invention disclosed here, will readily occur to its of the disclosure Its embodiment.The present invention is directed to cover any variations, uses, or adaptations of the disclosure, these modifications, purposes or Person's adaptive change follows the general principles of this disclosure and including the undocumented common knowledge in the art of the disclosure Or conventional techniques.The description and examples are only to be considered as illustrative, and the true scope and spirit of the disclosure are by following Claims are pointed out.
It should be understood that the present disclosure is not limited to the precise structures that have been described above and shown in the drawings, and And various modifications and changes may be made without departing from the scope thereof.The scope of the present disclosure is only limited by appended claims System.

Claims (10)

1. a kind of data processing method characterized by comprising
Server receives the inquiry request that electronic equipment is sent, and the inquiry request includes: the information of data to be checked;
The server generates the query script of database according to the information of the data to be checked;It is stored in the database The data to be checked;
The server runs the query script according to the information of the data to be checked, to obtain from the database The data to be checked;
The data to be checked are written to the corresponding secure file transportation protocol SFTP of the electronic equipment and weighed by the server It limits under catalogue.
2. the method according to claim 1, wherein the information of the data to be checked includes: polling cycle, institute Server is stated according to the information of the data to be checked, runs the query script, with obtain from the database it is described to Inquire data, comprising:
The server generates timed task according to the polling cycle;
The server runs the query script by the timed task, described to be checked to obtain from the database Data;The database is distributed relation database DRDS.
3. method according to claim 1 or 2, which is characterized in that the server receives the inquiry that electronic equipment is sent Before request, further includes:
The server configures the SFTP account information of multiple electronic equipments, and the SFTP account information includes: that the electronics is set The SFTP permission catalogue of standby access.
4. method according to claim 1 or 2, which is characterized in that the information of the data to be checked include it is following at least One: period belonging to data to be checked, affiliated province, the system coding of the electronic equipment, data to be checked are corresponding Order type, polling cycle, inquiry enabling time.
5. a kind of data processing method characterized by comprising
Electronic equipment generates inquiry request according to the information of data to be checked;
The electronic equipment sends inquiry request to server, and the inquiry request is asked for the server according to the inquiry Ask including data to be checked information, generate the query script of database, and according to the information of the data to be checked, operation The query script, to obtain the data to be checked from the database;Data to be checked are stored in the database;
The electronic equipment obtains the clothes under the catalogue that the electronic equipment corresponds to secure file transportation protocol SFTP permission The data to be checked of business device write-in.
6. according to the method described in claim 5, it is characterized by further comprising:
The electronic equipment obtains the SFTP account information of the server configuration, and the SFTP account information includes: the electricity The SFTP permission catalogue of sub- equipment access.
7. method according to claim 5 or 6, which is characterized in that the information of the data to be checked include it is following at least One: period belonging to data to be checked, affiliated province, the system coding of the electronic equipment, data to be checked are corresponding Order type, polling cycle, inquiry enabling time.
8. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program quilt Claim 1-4 and 5-7 described in any item methods are realized when processor executes.
9. a kind of server characterized by comprising
Processor;And
Memory, for storing the executable instruction of the processor;
Wherein, the processor is configured to require 1-4 described in any item via executing the executable instruction and carry out perform claim Method.
10. a kind of electronic equipment characterized by comprising
Processor;And
Memory, for storing the executable instruction of the processor;
Wherein, the processor is configured to require 5-7 described in any item via executing the executable instruction and carry out perform claim Method.
CN201910659756.XA 2019-07-22 2019-07-22 Data processing method and equipment Pending CN110362613A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910659756.XA CN110362613A (en) 2019-07-22 2019-07-22 Data processing method and equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910659756.XA CN110362613A (en) 2019-07-22 2019-07-22 Data processing method and equipment

Publications (1)

Publication Number Publication Date
CN110362613A true CN110362613A (en) 2019-10-22

Family

ID=68221400

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910659756.XA Pending CN110362613A (en) 2019-07-22 2019-07-22 Data processing method and equipment

Country Status (1)

Country Link
CN (1) CN110362613A (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101093454A (en) * 2007-08-14 2007-12-26 金蝶软件(中国)有限公司 Method and device for executing SQL script file in distributed system
CN106201672A (en) * 2016-06-22 2016-12-07 武汉斗鱼网络科技有限公司 A kind of timed task arranges system and timed task operation method thereof
US20160381121A1 (en) * 2015-06-26 2016-12-29 Mcafee, Inc. Query engine for remote endpoint information retrieval
WO2018035799A1 (en) * 2016-08-25 2018-03-01 阿里巴巴集团控股有限公司 Data query method, application and database servers, middleware, and system

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101093454A (en) * 2007-08-14 2007-12-26 金蝶软件(中国)有限公司 Method and device for executing SQL script file in distributed system
US20160381121A1 (en) * 2015-06-26 2016-12-29 Mcafee, Inc. Query engine for remote endpoint information retrieval
CN106201672A (en) * 2016-06-22 2016-12-07 武汉斗鱼网络科技有限公司 A kind of timed task arranges system and timed task operation method thereof
WO2018035799A1 (en) * 2016-08-25 2018-03-01 阿里巴巴集团控股有限公司 Data query method, application and database servers, middleware, and system

Similar Documents

Publication Publication Date Title
CN102880503B (en) Data analysis system and data analysis method
CN109413032A (en) A kind of single-point logging method, computer readable storage medium and gateway
CN110049048B (en) Data access method, equipment and readable medium for government affair public service
CN112612629B (en) Method and system for realizing component type data interface
TWI678909B (en) Safety authentication method, device and system
CN105119966A (en) Official account management method and device
CN110851278A (en) Distribution network automation master station mobile application service management method and system based on micro-service architecture
CN109379336A (en) A kind of uniform authentication method, distributed system and computer readable storage medium
CN113590576A (en) Database parameter adjusting method and device, storage medium and electronic equipment
CN106254121A (en) Method for automatically deploying and managing big data cluster
CN101808051A (en) Application integration gateway and control method thereof
CN114240409A (en) Cross-chain asset interaction method based on improved Hash time lock
CN111861481A (en) Block chain account checking method and system
CN109474706B (en) data security centralized service method and system
CN109725930A (en) SVN right management method and its device based on web platform
CN103561113B (en) The generation method and device of Web Service interface
CN110362613A (en) Data processing method and equipment
CN114003384B (en) Task management method, device and equipment
CN114221971B (en) Data synchronization method, device, server, storage medium and product
CN112380040B (en) Message processing method and device, electronic equipment and storage medium
CN111381921B (en) Front-end and back-end separation system and method based on Ambari
CN111783076A (en) Multi-scenario normalization processing model for construction, right establishment, authorization and verification of authority resources
CN110290205A (en) Service interface management method and device
CN115102749B (en) Resource interaction method, device, equipment and storage medium
CN108449396A (en) Distributed Hadoop cluster management methods, main control end and controlled end

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

Application publication date: 20191022

RJ01 Rejection of invention patent application after publication