WO2019024336A1 - Procédé et dispositif d'interrogation de données, et support de stockage lisible par ordinateur - Google Patents

Procédé et dispositif d'interrogation de données, et support de stockage lisible par ordinateur Download PDF

Info

Publication number
WO2019024336A1
WO2019024336A1 PCT/CN2017/112095 CN2017112095W WO2019024336A1 WO 2019024336 A1 WO2019024336 A1 WO 2019024336A1 CN 2017112095 W CN2017112095 W CN 2017112095W WO 2019024336 A1 WO2019024336 A1 WO 2019024336A1
Authority
WO
WIPO (PCT)
Prior art keywords
query
data
parameter
client
request
Prior art date
Application number
PCT/CN2017/112095
Other languages
English (en)
Chinese (zh)
Inventor
邵雷锋
谷峰
王红艳
杨东
夏延泉
程克喜
赵丽秋
Original Assignee
平安科技（深圳）有限公司
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 平安科技（深圳）有限公司 filed Critical 平安科技（深圳）有限公司
Publication of WO2019024336A1 publication Critical patent/WO2019024336A1/fr

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/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24553—Query execution of query operations
    • G06F16/24562—Pointer or reference processing operations
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24553—Query execution of query operations
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Definitions

  • the present application relates to the field of computer technologies, and in particular, to a data query method, apparatus, and computer readable storage medium.
  • database data query services such as HBase based (Hadoop).
  • Database distributed open source database
  • script program customization development that is, each time you execute the data query service, you need to call the data query
  • a service-specific script program is used to implement the data query service corresponding to the data query request.
  • the main purpose of the present application is to provide a data query method, device and computer readable storage medium, which are intended to solve the problem that the server performs a one-to-one script program customization process on the received data query request, which causes the data query service process to be complicated and complicated.
  • Technical problem is to provide a data query method, device and computer readable storage medium, which are intended to solve the problem that the server performs a one-to-one script program customization process on the received data query request, which causes the data query service process to be complicated and complicated.
  • the present application provides a data query method, and the data query method includes the following steps:
  • the present application further provides a data query device, where the data query device includes:
  • a first obtaining module configured to acquire a query parameter corresponding to the query request when receiving a query request sent by the client
  • a second acquiring module configured to acquire a script program corresponding to the query parameter in a preset database, where the query parameter has a many-to-one relationship with the script program;
  • a query module configured to run the script program based on the query parameter to obtain query data corresponding to the query parameter
  • a sending module configured to send the query data to the client.
  • the present application further provides a data query apparatus, including: a memory, a processor, and a data query program stored on the memory and operable on the processor, The step of implementing the data query method according to any of the above items when the data query program is executed by the processor.
  • the present application further provides a computer readable storage medium having a data query program stored thereon, the data query program being executed by a processor to implement any of the above The steps of the data query method.
  • This application enables the server to provide a data query service with a simple configuration, without having to customize and develop different script programs for different query requests, simplifying the process of providing data query services by the server, and ensuring a secure and reliable data query service. Under the premise, the server processing efficiency is improved.
  • FIG. 1 is a schematic structural diagram of a terminal to which a data query device belongs in a hardware operating environment according to an embodiment of the present application;
  • FIG. 2 is a schematic flowchart of a first embodiment of a data query method according to the present application
  • FIG. 3 is a schematic flowchart of a step of transmitting the query data to the client in the first embodiment of the data query method of the present application;
  • FIG. 4 is a schematic flowchart of a step of verifying the query parameter based on the preset authority information in the second embodiment of the data query method of the present application;
  • FIG. 5 is a schematic flowchart of a fourth embodiment of a data query method according to the present application.
  • FIG. 6 is a schematic flowchart of a step of transmitting the query data to the client in the first embodiment of the data query method of the present application
  • FIG. 7 is a schematic diagram of a refinement process of the step of running the script program based on the query parameters, where the query parameter includes multiple sets of different sub-query parameters in the first embodiment of the data query method of the present application;
  • FIG. 8 is a schematic flowchart of a step of acquiring a query parameter corresponding to the query request when receiving a query request sent by a client according to the first embodiment of the data query method of the present application.
  • FIG. 1 is a schematic structural diagram of a terminal to which a data query device belongs in a hardware operating environment according to an embodiment of the present application.
  • the terminal in this embodiment of the present application may be a PC.
  • the terminal may include a processor 1001, such as a CPU, a network interface 1004, a user interface 1003, a memory 1005, and a communication bus 1002.
  • the communication bus 1002 is used to implement connection communication between these components.
  • the user interface 1003 can include a display, an input unit such as a keyboard, and the optional user interface 1003 can also include a standard wired interface, a wireless interface.
  • the network interface 1004 can optionally include a standard wired interface, a wireless interface (such as a WI-FI interface).
  • the memory 1005 may be a high speed RAM memory or a stable memory (non-volatile) Memory), such as disk storage.
  • the memory 1005 can also optionally be a storage device independent of the aforementioned processor 1001.
  • the terminal may further include a camera, RF (Radio) Frequency, RF) circuits, sensors, audio circuits, WiFi modules, and more.
  • sensors such as light sensors, motion sensors, and other sensors.
  • the light sensor may include an ambient light sensor and a proximity sensor, wherein the ambient light sensor may adjust the brightness of the display according to the brightness of the ambient light, and the proximity sensor may turn off the display and/or when the mobile terminal moves to the ear. Backlighting.
  • the gravity acceleration sensor can detect the magnitude of acceleration in each direction (usually three axes), and can detect the magnitude and direction of gravity when stationary, and can be used to identify the posture of the mobile terminal (such as horizontal and vertical screen switching, Related games, magnetometer attitude calibration), vibration recognition related functions (such as pedometer, tapping), etc.; of course, the mobile terminal can also be equipped with other sensors such as gyroscope, barometer, hygrometer, thermometer, infrared sensor, etc. No longer.
  • terminal structure shown in FIG. 1 does not constitute a limitation to the terminal, and may include more or less components than those illustrated, or a combination of certain components, or different component arrangements.
  • an operating system may be included in the memory 1005 as a computer storage medium.
  • a network communication module may be included in the memory 1005 as a computer storage medium.
  • a user interface module may be included in the memory 1005 as a computer storage medium.
  • a data query program may be included in the memory 1005 as a computer storage medium.
  • the network interface 1004 is mainly used to connect to the background server and perform data communication with the background server;
  • the user interface 1003 is mainly used to connect the client (user end), and perform data communication with the client;
  • the processor 1001 can be used to invoke a data query program stored in memory 1005.
  • the data querying apparatus includes: a memory 1005, a processor 1001, and a data query program stored on the memory and operable on the processor, wherein:
  • the query authority corresponding to the query parameter is verified based on the preset permission information, where the query parameter verification is passed when the query authority verification is passed.
  • the verification failure information corresponding to the query parameter that fails the verification is obtained;
  • the verification failure information is fed back to the client.
  • the script program is sequentially executed based on the sub-query parameters corresponding to the current priority according to the obtained priority levels from high to low.
  • the query parameter corresponding to the query request is obtained.
  • FIG. 2 is a schematic flowchart of a first embodiment of a data query method according to the present application.
  • the data query method includes:
  • Step S100 Acquire a query parameter corresponding to the query request when receiving a query request sent by the client;
  • the query request is a query operation request that the query party sends to the server through the client to query a certain data or some data, wherein one query request may request to query one or more sets of query data, then
  • the query parameter corresponding to the query request may include only querying parameter information of one query data, and may also include parameter information for querying multiple sets of query data separately, that is, the query parameter may include multiple sub-query parameters; specifically, the querying party uses the client to Database such as HBase (Hadoop).
  • HBase Hadoop
  • the database corresponding to the database, the distributed open source database sends a query application instruction, and when the server receives the query application instruction sent by the client, generates a query editing interface corresponding to the query application instruction, and sends the query editing interface.
  • the querying party can edit and edit the query parameters based on the query editing interface; when the query parameter editing is completed, the querying party determines the editing of the query parameter by selecting the confirmation key of the query editing interface, and simultaneously triggers the query request, and the client receives the query.
  • the query request is triggered by the confirmation key, the query request is sent to the server; when the server receives the query request, the query parameter corresponding to the query request is obtained, and the query parameter is the query information edited by the querying party in the query editing interface.
  • the query parameter specifically includes: query information, feature information, target data format information, priority identifier information, and script program identification information.
  • Step S200 Obtain a script program corresponding to the query parameter in a preset database, where the query parameter and the script program have a many-to-one relationship;
  • the correspondence between the query parameter and the script program is a many-to-one relationship, that is, a plurality of different query parameters correspond to the same script program, wherein if some of the preset databases corresponding to the server are provided, If the specific query data is corresponding to the script program, when the client sends the query request to query the specific query data, the script program corresponding to the query parameter corresponding to the query request needs to be obtained; specifically, the corresponding query request is obtained. When the parameter is queried, the script corresponding to the query parameter is called in the preset database. If the query parameter includes multiple sets of different sub-query parameters, the script corresponding to the sub-query parameter is obtained, and in general, different sub-queries are obtained. The parameter can call the same script program.
  • the corresponding script program of the sub-query parameter is called, and then the query parameter is based on the query parameter. Run the script to get the query request corresponding to the query Inquiry data.
  • Step S300 running the script program based on the query parameter, to obtain query data corresponding to the query parameter;
  • the script program corresponding to the query parameter when the script program corresponding to the query parameter is obtained, the script program is executed based on the query parameter, where the script program includes an execution statement that invokes the query parameter, and when the script program is run, the execution is performed.
  • the statement invokes the query parameter to perform a query operation related to the query parameter, and runs a query execution statement corresponding to the query parameter during the running of the script program to obtain query data corresponding to the query parameter; if the server receives If the query parameter corresponding to the query request includes multiple sets of sub-query parameters, the script program is respectively executed based on the sub-query parameter; specifically, when the script program corresponding to the query parameter is obtained, according to the script program identification information in the query parameter, The script program corresponding to the script program identification information may be obtained, and the execution statement corresponding to the execution of the query request is written in the script program, that is, the execution statement corresponding to the query parameter, and the execution statement is specifically the feature information of the query data.
  • Corresponding query execution statement for example, in a car
  • the querying party Q requests to query the license plate number of the vehicle H, and the specific license plate number is 12345, the characteristic information of the query data in the query parameter is “the license plate number of the vehicle H”, and is written based on the script program.
  • the query execution statement of the feature information of the "vehicle number of the vehicle H” can obtain the license plate number 12345 of the vehicle H when the execution of the script program is completed.
  • Step S400 sending the query data to the client.
  • the server when the server obtains the query data corresponding to the query parameter, the query data needs to be sent to the corresponding client, and when the query parameter corresponding to the query request includes multiple sub-query parameters, based on the sub-query parameter Run the script program separately.
  • the script programs corresponding to the sub-query parameters When all the script programs corresponding to the sub-query parameters are completed, obtain the sub-query data corresponding to all the sub-query parameters, summarize all the sub-query data into the total query data, and feed back the total query data to Client.
  • the data query method proposed by the embodiment enables the server to provide a data query service by simply configuring, and does not need to customize and develop different script programs for different query requests, which simplifies the process of providing data query service by the server, and ensures the provision of the data. Under the premise of safe and reliable data query service, the server processing efficiency is improved.
  • step S400 includes:
  • Step S410 Obtain preset permission information corresponding to the query data.
  • Level in order to ensure the security of the data in the database. For example, for a database system, there are management level and user level permissions respectively in the database, wherein the query operation on a certain data only allows the permission of the management level.
  • the querying party performs the query operation on the data, and the querying party having the user-level authority is prohibited from performing the query operation on the data, so that if a querying party is granted only the user-level authority by the database, the calling party cannot
  • the data is queried; therefore, after obtaining the query data corresponding to the query parameter, the server needs to perform the verification operation on the query parameter, and verify whether the query party corresponding to the query parameter has the corresponding data query permission, that is, the query party can Obtain the query data queried by the server; specifically When the query parameter corresponding to the query request is obtained, the corresponding script program is run based on the query data feature information in the query parameter, and when the script program is completed, the query data corresponding to the query parameter may be obtained, thereby passing the query.
  • the data may obtain the preset permission information of the query data, where the preset permission information is a related permission preset by the server for the query data corresponding to the query request, such as query data corresponding to a query request in the server.
  • the query level can be queried only by the query level of the management level, and the management level is the preset permission information of the query data in the server, and the preset permission information of the query data corresponding to the query request can be obtained.
  • Step S420 verifying the query parameter based on the preset authority information
  • the query data may be obtained by running a script program corresponding to the query parameter, and then the preset permission information corresponding to the query data is obtained in the server, and when the preset permission information of the query data is obtained, the query is simultaneously parsed.
  • the parameter obtains the identifier information of the querying party, and obtains the query authority of the querying party corresponding to the query parameter according to the identifier information of the querying party; and determines the permission requirement corresponding to the preset permission information of the query data corresponding to the querying authority of the querying party Whether the matching is performed, the query parameter is verified, and if the querying right of the querying party meets the permission requirement corresponding to the preset permission information of the query data corresponding to the query parameter, the verification of the query parameter is passed; if the query of the querying party is If the permission does not meet the permission requirement corresponding to the preset permission information of the query parameter corresponding to the query parameter, the verification of the query parameter fails.
  • Step S430 Send the query data to the client when the query parameter verification is passed.
  • the query permission of the querying party meets the permission requirement corresponding to the preset permission information of the query data corresponding to the query parameter, it indicates that the verification of the query parameter corresponding to the query request received by the server is passed, that is, the query party can Obtain the data queried by the server (that is, query data); when the verification of the query parameter passes, the server sends the query data to the client.
  • the data query method proposed in this embodiment implements the verification of the query parameters, and filters the query party without relevant query permission to ensure that the server can provide a safe and reliable data query service.
  • step S420 includes:
  • Step S421 Acquire a query permission corresponding to the query parameter.
  • the query authority is the related authority information of the query data to the query data, that is, the specific permission level of the query data to the query data, and the query authority defines the query operation of the query party, such as a certain query party.
  • the data has preset query permissions of different levels.
  • the queryer identification information in the query parameter the query authority of the corresponding query party can be obtained, and the query party identification information is specific identification information of each query party, and different query policies.
  • the same query data may have the same or different identification information, and the query identifier information may be a number or other. If two different query parties have the query permission level of a certain query data as the user level, then the two queries
  • the query identification information of the query data may be the same, for example, the query identifier information is numbered 2, thereby identifying by the query
  • the information can be obtained from the query level of the two querying parties.
  • the query query parameter can obtain the identifier information corresponding to the query party. That is, the querying party identifies the information, so that the corresponding query authority can be obtained according to the query identifier information.
  • Step S422 the query authority corresponding to the query parameter is verified based on the preset authority information, where the query parameter verification is passed when the query authority verification is passed.
  • the query data may be obtained by running a script program corresponding to the query parameter, and the preset permission information corresponding to the query data may be obtained according to the query data, and the query parameter may be based on the preset permission information of the query data.
  • the query authority is verified; specifically, based on the preset authority information, it is verified whether the query party corresponding to the query parameter has the right to query the query data, for example, the employee system number is established in the database system in a certain company.
  • the database when the querying party B requests to query the employee A's job number, the query authority of the querying party B is verified, wherein the employee A's job number is 799, then the job number 799 is the query data, if the server is In the default, only the query party having the management level is allowed to query the job number 799, and the preset authority information corresponding to the job number 799 is the management level, and the preset authority information corresponding to the query data 799 is obtained, and the query is obtained at the same time.
  • the query permission of the party B wherein the query party B identification information number is 5, if the number is in the corresponding query permission level in the server
  • the query authority of the querying party B is the user level authority
  • the preset permission information corresponding to the query data is the management level, so that the query authority of the querying party B and the preset permission corresponding to the query data 799 are known. If the information does not match, it means that the query authority verification of the query party fails in this verification operation, that is, the query party B cannot obtain the employee number of the employee A that is queried by the server.
  • the verification of the query parameters is implemented, and the query party with no relevant query permission is filtered to ensure that the server can provide a reliable and secure query service, and the server processing efficiency is also improved.
  • the data query method includes:
  • Step S440 determining whether there is a query parameter that fails verification in the query parameter
  • a query request may correspond to multiple sets of query parameters, that is, for the same query request, the server may be requested to query multiple query data; when the server receives the query request sent by the client, obtain the corresponding query request.
  • Query parameters if the query request corresponding to the plurality of sets of query parameters, when all the query parameters corresponding to the query request are verified, it is necessary to determine whether there are query parameters for verifying failure in all the obtained query parameters, that is, judging
  • the querying party corresponding to the query request has the relevant query permission for the query data corresponding to the query parameter respectively.
  • the query data corresponding to the query parameter can be used to obtain the query data, and according to the query data, the corresponding data corresponding to the query data can be obtained.
  • the permission information is set, and the query permission of each query parameter is verified based on the preset permission information, so that the query party corresponding to the query has the relevant query permission for the query data corresponding to the query parameter, if the query party has certain If the query data does not have corresponding query permission, then It shows the presence of failed validation query parameters in all query parameters, query if the query data for all parties have permissions corresponding to the query, then the authentication fails query parameter does not exist,
  • Step S450 If there is a query parameter that fails verification, obtain verification failure information corresponding to the query parameter that fails the verification;
  • the verification failure information corresponding to the query parameter that fails the verification is obtained, and the verification failure information is fed back.
  • the verification failure information is the reason for the failure of the verification of the corresponding query parameter; specifically, the query parameters corresponding to the query request are parsed one by one, the query permission corresponding to all the query parameters is obtained, and then the preset based on the query data
  • the permission information is used to verify the obtained query permission, that is, the query right of the query data corresponding to the query parameter is verified, and if the query party queries the query data and the preset permission of the query data If the information requirements do not match, the verification fails.
  • the reason for the verification failure is that the query authority of the query party does not meet the requirements of the preset permission information of the query data.
  • the query authority level of the queryer C for the student S is the visitor level, and The student S's default permission information is only allowed for user level and management level query. If the query is performed, the query permission of the query party C does not meet the preset permission information requirement of the query data, and the score data of the student S cannot be obtained from the service; in addition, there may be corresponding to some query data.
  • the server parses a query parameter to obtain the query permission corresponding to the query parameter, the query parameter fails to be parsed, and the query permission of the corresponding query party cannot be obtained, and the corresponding verification failure reason
  • the default permission information of a certain query data is missing, and the corresponding query permission cannot be obtained when the query parameter fails to be parsed; then the feedback verification failure information (that is, the reason for the verification failure) is sent to the client.
  • Step S460 feeding back the verification failure information to the client.
  • the verification failure information when the verification failure information is obtained, the verification failure information is fed back to the client; specifically, the verification failure information includes: the query authority of the querying party does not match the preset permission information requirement of the query data, and the query data is If the default permission information is missing and the query parameters are parsed, the corresponding query permission cannot be obtained. According to the different conditions of the verification failure, the corresponding verification failure information is fed back to the client.
  • the data query method provided in this embodiment implements feedback on the verification failure information, so that the query party corresponding to the client can clearly understand the reason for the verification failure in time, and when the query party requests the query data again, the verification can be avoided.
  • the problem of failure also enables the relevant maintenance personnel of the server to timely understand the problems occurring inside the server, and then solve the problems of the server in time, so that the server can better provide the data query service.
  • step S400 further includes:
  • Step S470 when the running of the script program is completed, acquiring a target data format corresponding to the query parameter and a source data format of the query data;
  • the format of the data stored in the database corresponding to the server may be the same as or different from the format requested by the querying party. Therefore, when the query data is obtained, the query data needs to be specific to the query data.
  • the format requires to convert the source format of the query data, so that the querying party can obtain the query data that meets the format requirements; specifically, the target data format information is included in the query parameter corresponding to the query request, and the target data format can be obtained by parsing the query parameter.
  • the information may be obtained according to the target format information, and the target data format corresponding to the query parameter may be obtained, and the target data format is obtained when the script program corresponding to the query parameter is completed, and the query data is obtained based on the obtained query data.
  • Source data format is a data format.
  • Step S480 converting the source data format to the target data format, and sending the format conversion completed query data to the client.
  • the target data format when the target data format corresponding to the query parameter and the source data format of the query data are obtained, the target data format needs to be compared with the source data format. If the target data format is the same as the source data format, The source data format is not required to be converted to the target data format, and the server directly sends the obtained query data to the client; if the target data format is different from the source data format, the source data format needs to be converted into the target data format, so that the query data is The source data format is consistent with the target data format required by the querying party after the conversion. When the format conversion is completed, the server sends the formatted conversion query data to the client.
  • the data query method proposed in this embodiment implements the conversion of the query data format, so that the converted query data format can meet the format requirements of the querying party, and also enables the server to provide a better and more complete data query service for the querying party. .
  • step S300 includes:
  • Step S310 obtaining a priority of each subquery parameter of each group
  • the script program corresponding to the query parameter when the script program corresponding to the query parameter is obtained, if multiple query parameters are included in the query parameter, different sub-query parameters have different priority orders, and the query parameters and the script are used.
  • the relationship of the program is a many-to-one relationship.
  • the script program needs to be sequentially executed according to the priority order of each sub-query parameter.
  • the script program corresponding to the query parameter is obtained, the query parameter is obtained.
  • the priority identification information of the sub-query parameters of each group may be obtained by using the priority identifier information in the priority directory table of the server to obtain the priority of the corresponding sub-query parameter, where the priority identifier information may be a serial number or other identifier.
  • the priority order corresponding to the different priority identification information is set in detail; if the priority identification information is represented by natural numbers such as numbers 1, 2, 3, ...
  • the priority directory table in the server includes the priority order corresponding to each digital number, such as a number
  • the corresponding query order is the highest query priority, and the number 2 corresponds to the query priority.
  • the script When the query data corresponding to the sub-query parameter with the priority identifier information of 1 is obtained, the script is run based on the sub-query parameter whose priority identifier information is 2. Program; if the priority of different sub-query parameters is at the same level, the script is run simultaneously based on different sub-query parameters.
  • step S320 the script program is sequentially executed based on the sub-query parameters corresponding to the current priority according to the obtained priority levels from high to low.
  • the sub-query parameters are sequentially sorted from high to low, and then the scripts are sequentially executed based on the sub-query parameters corresponding to the current priority according to the order of the priorities from high to low.
  • the program that is, the script program is first run based on the highest priority sub-query parameter to obtain the query data corresponding to the highest priority sub-query parameter, and then the script program is run based on the sub-query parameter whose priority is lower than the highest priority.
  • the data query method proposed by the embodiment implements the processing of the sub-query parameters of different priorities in sequence when the query parameters have multiple sets of sub-query parameters, thereby improving the processing efficiency of the server and enabling the querying party to obtain the information in a timely manner.
  • step S100 includes:
  • Step S110 when receiving the query application instruction sent by the client, generate a query editing interface corresponding to the query request instruction, and send the query editing interface to the client;
  • the server when receiving the query application instruction sent by the client, the server generates a query editing interface corresponding to the query application instruction, and sends the query editing interface to the corresponding client, and the querying party can be based on the query. Edit the interface to edit the corresponding query parameters.
  • Step S120 Acquire a query parameter corresponding to the query request when receiving a query request triggered by the client based on the query editing interface.
  • the querying party edits the query parameter based on the query editing interface.
  • the querying party determines that the query parameter editing is completed by selecting the confirm key of the query editing interface, and triggers the query request, and the client will The query request is sent to the corresponding server.
  • the server receives the query request, the query parameter corresponding to the query request is obtained, where the query parameter is the query information edited by the querying party based on the query editing interface, and the query parameter specifically includes: Query information such as feature information of the target data, querying party identification information, target data format information, priority identification information, and script program identification information, wherein the server can find the corresponding query data by running the script program based on the feature information of the target data.
  • the querier identification information can be used to query the query permission of the party.
  • the target data format information can be used to obtain the format of the query data requested by the querying party.
  • the priority identification information can be used to find the priority of the query parameter, and the script is determined according to the priority. Cheng Run sequence based on query parameters, the identification information may be obtained query parameters corresponding to the script program by the script.
  • This embodiment enables the server to accurately receive the query request sent by the querying party based on the client query editing interface, and provides the querying party with the data query service corresponding to the query request better and more accurately.
  • the present application further provides a data query device, where the data query device includes:
  • a first obtaining module configured to acquire a query parameter corresponding to the query request when receiving a query request sent by the client
  • a second acquiring module configured to acquire a script program corresponding to the query parameter in a preset database, where the query parameter has a many-to-one relationship with the script program;
  • a query module configured to run the script program based on the query parameter to obtain query data corresponding to the query parameter
  • a sending module configured to send the query data to the client.
  • the query module includes:
  • a generating unit configured to generate a query editing interface corresponding to the query request instruction, and send the query editing interface to the client when receiving the query request instruction sent by the client;
  • the first obtaining unit is configured to acquire a query parameter corresponding to the query request when receiving a query request triggered by the client based on the query editing interface.
  • the sending module includes:
  • a second acquiring unit configured to acquire preset permission information corresponding to the query data
  • a verification unit configured to verify the query parameter based on the preset permission information
  • a sending unit configured to send the query data to the client when the query parameter verification is passed.
  • the verification unit comprises:
  • a verification subunit configured to verify the query authority based on the preset permission information, where the query parameter verification passes when the query authority verification is passed.
  • the sending module includes:
  • a third obtaining unit configured to acquire a target data format corresponding to the query parameter and a source data format of the query data when the script program is completed;
  • a converting unit configured to convert the source data format to the target data format, and send the format conversion completed query data to the client.
  • the query parameter includes multiple sets of different sub-query parameters
  • the query module includes:
  • a fourth obtaining unit configured to acquire a priority of each group of the subquery parameters
  • the running unit is configured to run the script program according to the sub-query parameter corresponding to the current priority according to the obtained priority in descending order.
  • the present application further provides a computer readable storage medium, where the data readable program is stored, and when the data query program is executed by the processor, the following operations are implemented:
  • the query authority corresponding to the query parameter is verified based on the preset permission information, where the query parameter verification is passed when the query authority verification is passed.
  • the verification failure information corresponding to the query parameter that fails the verification is obtained;
  • the verification failure information is fed back to the client.
  • the script program is sequentially executed based on the sub-query parameters corresponding to the current priority according to the obtained priority levels from high to low.
  • the query parameter corresponding to the query request is obtained.

Landscapes

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

Abstract

L'invention concerne un procédé d'interrogation de données, un dispositif d'exploitation de données et un support de stockage lisible par ordinateur. Le procédé consiste à : obtenir des paramètres d'interrogation correspondant à une demande d'interrogation lorsque la demande d'interrogation envoyée par un client est reçue (S100) ; obtenir un programme de script correspondant aux paramètres d'interrogation à partir d'une base de données prédéfinie, les paramètres d'interrogation ayant une relation univoque avec le programme de script (S200) ; exécuter le programme de script d'après les paramètres d'interrogation afin d'obtenir des données d'interrogation correspondant aux paramètres d'interrogation (S300) ; et envoyer les données d'interrogation au client (S400). Selon le procédé, un serveur peut fournir un service d'interrogation de données en effectuant uniquement une configuration simple. De plus, il n'est pas nécessaire de personnaliser ni de développer différents programmes de script pour différentes demandes d'interrogation, ce qui simplifie le processus de fourniture du service d'interrogation de données par le serveur et améliore l'efficacité de traitement du serveur dans l'optique de fournir un service d'interrogation de données sécurisé et fiable.
PCT/CN2017/112095 2017-07-31 2017-11-21 Procédé et dispositif d'interrogation de données, et support de stockage lisible par ordinateur WO2019024336A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201710645097.5A CN107679064A (zh) 2017-07-31 2017-07-31 数据查询方法、装置及计算机可读存储介质
CN201710645097.5 2017-07-31

Publications (1)

Publication Number Publication Date
WO2019024336A1 true WO2019024336A1 (fr) 2019-02-07

Family

ID=61134438

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2017/112095 WO2019024336A1 (fr) 2017-07-31 2017-11-21 Procédé et dispositif d'interrogation de données, et support de stockage lisible par ordinateur

Country Status (2)

Country Link
CN (1) CN107679064A (fr)
WO (1) WO2019024336A1 (fr)

Families Citing this family (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108932284B (zh) * 2018-05-22 2020-11-24 中国银行股份有限公司 通用逻辑调度方法、电子设备及可读存储介质
CN108984603A (zh) * 2018-06-05 2018-12-11 试金石信用服务有限公司 异构数据采集方法、设备、存储介质及系统
CN109344185A (zh) * 2018-08-21 2019-02-15 广州飞硕信息科技股份有限公司 一种数据获取方法及装置
CN109344177B (zh) * 2018-09-18 2020-04-03 图普科技（广州）有限公司 一种模型组合方法及装置
CN109683942B (zh) * 2018-11-13 2024-05-24 平安科技（深圳）有限公司 脚本管理方法、装置、介质及电子设备
CN111784337B (zh) * 2019-04-04 2023-08-22 华控清交信息科技(北京)有限公司 权限验证方法及系统
CN110413671A (zh) * 2019-06-28 2019-11-05 万翼科技有限公司 数据查询方法及装置
CN110472750A (zh) * 2019-07-05 2019-11-19 深圳市轱辘汽车维修技术有限公司 查询电路图的方法、装置、服务器及介质
CN112612802B (zh) * 2020-12-19 2024-05-28 飞算数智科技(深圳)有限公司 一种实时数据中台的处理方法、装置及平台
CN117176484B (zh) * 2023-11-03 2024-01-19 湖南华博信息技术有限公司 一种工控互联网数据通用权限验证方法

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104516908A (zh) * 2013-09-29 2015-04-15 华为技术有限公司 一种数据库访问方法和装置
CN105868225A (zh) * 2015-11-18 2016-08-17 乐视体育文化产业发展（北京）有限公司 数据查询的方法、客户端、服务器及系统
CN106802901A (zh) * 2015-11-26 2017-06-06 北京国双科技有限公司 数据库查询的方法及装置
CN106814997A (zh) * 2015-11-27 2017-06-09 阿里巴巴集团控股有限公司 数据库操作语言脚本优化方法、装置及系统

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107741937B (zh) * 2016-09-13 2020-04-28 腾讯科技（深圳）有限公司 一种数据查询方法及装置

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104516908A (zh) * 2013-09-29 2015-04-15 华为技术有限公司 一种数据库访问方法和装置
CN105868225A (zh) * 2015-11-18 2016-08-17 乐视体育文化产业发展（北京）有限公司 数据查询的方法、客户端、服务器及系统
CN106802901A (zh) * 2015-11-26 2017-06-06 北京国双科技有限公司 数据库查询的方法及装置
CN106814997A (zh) * 2015-11-27 2017-06-09 阿里巴巴集团控股有限公司 数据库操作语言脚本优化方法、装置及系统

Also Published As

Publication number Publication date
CN107679064A (zh) 2018-02-09

Similar Documents

Publication Publication Date Title
WO2019024336A1 (fr) Procédé et dispositif d'interrogation de données, et support de stockage lisible par ordinateur
WO2018082482A1 (fr) Procédé de partage de réseau et procédé et système d'accès à un réseau
WO2019019374A1 (fr) Procédé, appareil et système permettant de commander un appareil électroménager à l'aide d'un dispositif vocal intelligent
WO2018120457A1 (fr) Procédé de traitement de données, appareil, dispositif et support de stockage lisible par ordinateur
WO2019019493A1 (fr) Procédé et dispositif de partage de données et support d'informations lisible par ordinateur
WO2019231252A1 (fr) Dispositif électronique utilisé pour authentifier un utilisateur, et procédé de commande associé
WO2019051899A1 (fr) Procédé et dispositif de commande de terminaux, et support d'informations
WO2016089009A1 (fr) Procédé et serveur cloud pour dispositif de gestion
WO2018233367A1 (fr) Procédé et appareil d'enregistrement de cas, terminal et support de stockage lisible par ordinateur
WO2017054481A1 (fr) Procédé et appareil de vérification et de traitement d'informations, et système de traitement d'informations
WO2019019378A1 (fr) Procédé et appareil de traitement de service, adaptateur et support de stockage lisible par ordinateur
WO2018028135A1 (fr) Procédé de rétroaction d'informations de données de liaison descendante et dispositif pertinent
WO2020171672A1 (fr) Procédé d'interfonctionnement entre un processus de téléchargement de faisceau et un processus de téléchargement de profil esim par un terminal ssp
WO2014186986A1 (fr) Procédé, dispositif et système de retransmission de flux
WO2019114269A1 (fr) Procédé de reprise de la visualisation d'un programme, téléviseur et support d'informations lisible par ordinateur
WO2018176864A1 (fr) Procédé et système de gestion d'autorisation de base de données, dispositif, support d'informations lisible par ordinateur
WO2019037395A1 (fr) Procédé de gestion de clé, dispositif et support de stockage lisible
WO2018058919A1 (fr) Procédé, appareil, dispositif de génération d'informations d'identification, et support de stockage lisible par ordinateur
WO2018227887A1 (fr) Procédé de distribution de publicité vidéo, procédé de génération de publicité vidéo, dispositif, serveur et support d'informations lisible
WO2018166236A1 (fr) Procédé, appareil et dispositif de reconnaissance de facture de règlement de revendication, et support d'informations lisible par ordinateur
WO2017084337A1 (fr) Procédé, appareil et système de vérification d'identité
WO2019071762A1 (fr) Procédé et système de positionnement au sol, serveur et support d'enregistrement lisible par ordinateur
WO2018076875A1 (fr) Procédé de synchronisation de données de sauvegarde, appareil, support de stockage, dispositif électronique, et serveur
WO2020105892A1 (fr) Procédé par lequel un dispositif partage une clé numérique
WO2018000856A1 (fr) Procédé de mise en œuvre de transfert de message de réseau de recouvrement sdn, terminal, appareil et support d'informations lisible par ordinateur

Legal Events

Date Code Title Description
NENP Non-entry into the national phase

Ref country code: DE

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 06.08.2020)

121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 17920250

Country of ref document: EP

Kind code of ref document: A1

122 Ep: pct application non-entry in european phase

Ref document number: 17920250

Country of ref document: EP

Kind code of ref document: A1

122 Ep: pct application non-entry in european phase

Ref document number: 17920250

Country of ref document: EP

Kind code of ref document: A1