WO2019019361A1 - Procédé et appareil de traitement de données de base de données, dispositif informatique et support de stockage - Google Patents

Procédé et appareil de traitement de données de base de données, dispositif informatique et support de stockage Download PDF

Info

Publication number
WO2019019361A1
WO2019019361A1 PCT/CN2017/104253 CN2017104253W WO2019019361A1 WO 2019019361 A1 WO2019019361 A1 WO 2019019361A1 CN 2017104253 W CN2017104253 W CN 2017104253W WO 2019019361 A1 WO2019019361 A1 WO 2019019361A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
task
processing
instruction
data processing
Prior art date
Application number
PCT/CN2017/104253
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 WO2019019361A1 publication Critical patent/WO2019019361A1/fr

Links

Images

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/24561—Intermediate data storage techniques for performance improvement

Definitions

  • the present application relates to the field of data processing technologies, and in particular, to a database data processing method, apparatus, computer device, and storage medium.
  • a database data processing method, apparatus, computer device, and storage medium are provided.
  • a database data processing method comprising:
  • a database data processing device comprising:
  • An instruction acquisition module configured to acquire a data processing task execution instruction
  • An identifier extraction module configured to extract a task identifier in the data processing task execution instruction
  • a script obtaining module configured to acquire a task script corresponding to the task identifier
  • a script parsing module configured to extract data processing instructions and data acquisition conditions in the task script
  • a data acquisition module configured to acquire target data from a database corresponding to each database type according to the data acquisition condition
  • a data table creating module configured to respectively create a temporary data table according to the target data corresponding to each database type
  • a data processing module configured to process the target data in the temporary data table according to the data processing instruction.
  • a computer device comprising a memory and a processor, wherein the memory stores computer executable instructions that, when executed by the processor, cause the processor to perform the following steps:
  • One or more storage media storing computer executable instructions that, when executed by one or more processors, cause the one or more processors to perform the following steps:
  • FIG. 1 is an application environment diagram of a database data processing method in an embodiment
  • FIG. 2 is a structural block diagram of a server in a database data processing system in an embodiment
  • FIG. 3 is a schematic flow chart of a database data processing method in an embodiment
  • FIG. 4 is a schematic flowchart of a step of reading a task identifier according to a task dependency relationship in an embodiment
  • FIG. 5 is a schematic flow chart of steps of obtaining a custom function in an embodiment
  • FIG. 6 is a flow chart showing the steps of storing a processing result in an embodiment
  • Figure 7 is a block diagram showing the structure of a database data processing apparatus in an embodiment
  • FIG. 8 is a structural block diagram of a data processing module in an embodiment
  • Figure 9 is a block diagram showing the structure of a database data processing apparatus in another embodiment.
  • FIG. 1 is an application environment diagram of a database data processing method.
  • the database data processing method is applied to a database data processing system.
  • the database data processing system includes a terminal 110 and a server 120, wherein the terminal 110 is connected to the server 120 via a network.
  • the terminal 110 may be a fixed terminal or a mobile terminal, and the fixed terminal may specifically be at least one of a printer, a scanner, and a monitor, and the mobile terminal may specifically be at least one of a tablet computer, a smart phone, a personal data assistant, and a digital camera. .
  • FIG. 2 is a schematic diagram showing the internal structure of the server 120 in the database data processing system of FIG. 1 in an embodiment.
  • the server 120 includes a processor, a non-volatile storage medium, an internal memory, and a network interface connected by a system bus.
  • the processor of server 120 is used to provide computing and control capabilities to support the operation of the entire server 120, the memory for storing data, code instructions, etc., and the network interface for network communication with terminal 110.
  • At least one computer executable instruction is stored on the memory, and the computer executable instructions are executable by the processor to implement the database data processing method applicable to the server 120 provided in the embodiment of the present application.
  • the memory may include a non-volatile storage medium such as a magnetic disk, an optical disk, or a read-only memory (ROM).
  • the memory includes a non-volatile storage medium and an internal memory; the non-volatile storage medium stores a processing system, a database, and computer-executable instructions, and the database includes a plurality of databases corresponding to the plurality of database types respectively
  • the target data is stored in the database, and the computer executable instructions are executable by the processor to implement the database data processing method described above; the internal memory provides a cache operation for the processing system and the computer executable instructions in the non-volatile storage medium. surroundings.
  • FIG. 2 is only related to the solution of the present application.
  • the schematic diagram of the partial structure does not constitute a limitation on the server to which the solution of the present application is applied, and the specific server may include more or less components than those shown in FIG. 2, or combine some components, or have Different parts are arranged.
  • a database data processing method is provided. This embodiment is exemplified by the method applied to the server 120 in FIG. 1, and the method specifically includes the following content:
  • the terminal 110 acquires a user account input by the user, generates a page data acquisition request according to the obtained user account, and sends a page data acquisition request to the server 120.
  • the server 120 parses the page data acquisition request, and extracts the user account in the page data acquisition request by parsing.
  • the server 120 performs rights verification on the extracted user account, and returns the data processing page data to the terminal 110 according to the page data acquisition request when verifying that the extracted user account has access rights to access the data processing page.
  • the terminal 110 displays the data processing page according to the data processing page data.
  • the terminal 110 acquires a task identifier selected by the user in the displayed data processing page, and generates a data processing task execution instruction according to the selected task identifier.
  • the terminal 110 transmits a data processing task execution instruction to the server 120.
  • the server 120 receives the data processing task execution instruction sent by the terminal 110, parses the data processing task execution instruction, and extracts the task identifier in the task execution instruction by parsing.
  • the task ID is a unique identifier for the task.
  • the terminal 110 acquires a task identifier corresponding to the task identifier and the task identifier input by the user in the displayed data processing page, and sends the obtained task identifier and task script to the server 120.
  • the server 120 stores the received task identifier and the task script correspondingly.
  • a task script is a script that is executed when a data processing task is executed. After extracting the task identifier, the server 120 queries the task script corresponding to the extracted task identifier in the stored task script, and obtains the query result. Task script.
  • the server 120 parses the task script and extracts data processing instructions and data acquisition conditions from the task script through parsing.
  • the data processing instruction is an instruction for processing data.
  • the server 120 parses the task script, analyzes and identifies the data processing instruction, the data acquisition condition, and the operation resource configuration parameter in the task script, and configures the computing resource for the data processing instruction according to the computing resource configuration parameter.
  • server 120 may access databases corresponding to multiple database types.
  • the databases corresponding to the plurality of database types may be set on the server 120 or may be set on other servers.
  • the server 120 acquires the access data interface of the database corresponding to the various database types, and obtains the target data that meets the data acquisition condition from the corresponding database by accessing the data access interface.
  • the server 120 extracts the database identifier in the data acquisition condition, identifies the database type corresponding to the database identifier, acquires the database access interface of the database type, and obtains the data acquisition condition according to the database access interface from the database corresponding to the database identifier.
  • Target data the database identifier in the data acquisition condition.
  • the server 120 extracts the database type in the data acquisition condition, acquires the database access interface of the database type and the database corresponding to the query database type, and obtains the target data that meets the data acquisition condition from the queryed database according to the database access interface.
  • the server 120 after obtaining the target data corresponding to each database type, the server 120 separately creates a temporary data table in a preset format according to the target data corresponding to each database type, and obtains a temporary data table corresponding to each database type, and a temporary data table.
  • the target data is stored in it.
  • S312 specifically includes the following: acquiring a temporary table creation instruction corresponding to each database type; and respectively corresponding to the corresponding database type according to the temporary table creation instruction According to the creation of a temporary data table.
  • the server 120 acquires target data corresponding to each database type, acquires a temporary table creation instruction corresponding to each database type, and creates a data temporary table corresponding to each database type according to the temporary table creation instruction, and corresponding each database type.
  • the data format of the target data is converted into a data format that matches the temporary data table, and the target data after the data format conversion is stored in the corresponding temporary data table.
  • S314 Process the target data in the temporary data table according to the data processing instruction.
  • the server 120 creates the temporary data table corresponding to each database type
  • the data processing is performed on the target data in the temporary data table corresponding to each database type according to the data processing, and the target in each temporary data table is adopted. The processing of the data is processed.
  • the edited task script is acquired according to the data processing task execution instruction, the data processing task is parsed by the task script, and the data processing instruction and the data acquisition condition in the data processing task are extracted, and the data acquisition condition is corresponding to each database type according to the data acquisition condition.
  • Get target data in the database The temporary data table is respectively created according to the target data corresponding to each database type, and the temporary data table corresponding to each database type is established, and the target data in the temporary data table corresponding to each database type is processed according to the data processing instruction. It is not necessary to separately perform the separate operation on the target data corresponding to each database type, which improves the processing efficiency of the data corresponding to each database type.
  • S306 specifically includes the step of reading the task identifier according to the task dependency, and the step specifically includes the following content:
  • the data processing task execution instruction includes a plurality of task identifiers and task dependencies corresponding to the plurality of task identifiers.
  • the server 120 parses the data processing task execution instruction, extracts the task dependency relationship and the task identifier in the data processing task execution instruction, and reads the task identifier according to the task dependency relationship.
  • the task identification in the data processing task execution instructions is a task flow identifier arranged in accordance with a task dependency.
  • the server 120 reads the task identification from the task flow identifier based on the task dependency.
  • the task flow identifier in the data processing task execution instruction is “1, 2
  • ",” indicates that the task has a dependency, first execute the task corresponding to the task ID before ",” and then execute the task corresponding to the task identifier after ",”;
  • " indicates that the task identifier before and after the "
  • 4, 5" is to execute task 1 first, and after task 1 is executed, perform task 2, task 3, and task 4 in parallel, and parallel in task 2, task 3, and task 4. After the execution is completed, perform task 5.
  • the server 120 after the server 120 reads the task identifier from the task execution instruction according to the task dependency, the server 120 queries the task script corresponding to the task identifier in the stored task script to obtain the queried task script.
  • the data processing task execution instruction includes a plurality of task identifiers and a task dependency relationship corresponding to the plurality of task identifiers, and the task identifier is read according to the task dependency relationship, and the task script is obtained according to the read task identifier.
  • the task corresponding to each task identifier is executed according to the task dependency relationship, the operation steps of executing the task are simplified, the task execution efficiency is improved, and multiple data processing tasks can be executed according to a data processing task execution instruction, thereby improving data processing efficiency.
  • S314 specifically includes the step of acquiring a custom function, and the step specifically includes the following:
  • server 120 parses the data processing instructions by parsing the custom function identifiers in the data processing instructions.
  • the custom function identifier is a unique identifier of the user-defined function.
  • S504 Obtain a data processing function from the custom function library according to the custom function identifier.
  • the terminal 110 acquires a data processing function input by the user in the data processing page, and sends the acquired data processing function to the server 120.
  • the server 120 extracts the custom function identifier in the data processing function, and stores the received data processing function and the extracted custom function identifier in the custom function library.
  • Server After extracting the custom function identifier from the data processing instruction, querying the data processing function in the custom function library according to the extracted custom function identifier, and obtaining the data processing function of the query.
  • S506 Process the target data in the temporary data table according to the acquired data processing function.
  • the server 120 processes the target data in the temporary data table according to the acquired data processing function, and processes the target data according to the data processing function to obtain a processing result.
  • the server 120 can transmit the obtained processing result to the terminal 110 to cause the terminal 110 to display in the data processing page.
  • the target data in the temporary data table of each database type can be processed according to the user-defined data processing function, so that the processing of the target data is more flexible, and the accuracy and efficiency of the data processing are improved.
  • the step S314 further includes a step of storing a processing result, where the step further includes the following content:
  • the terminal 110 displays the processing result obtained by the server 120 in the data processing page, and when detecting that the result saving button in the data processing page is clicked, triggers the processing result storage instruction, and sends the triggered processing result storage instruction. To the server 120.
  • the server 120 receives the processing result storage instruction transmitted by the terminal 110.
  • the server 120 can detect if the data processing process is complete, and upon detecting the end of the data processing process, trigger the processing result storage instruction.
  • the server 120 parses the processing result storage instructions by parsing the database types in the processing result storage instructions.
  • the extracted database type is the database type corresponding to the database in which the result is stored.
  • the server 120 obtains a processing result obtained by processing the target data, determines a data format that the extracted database type matches, and performs a data format conversion on the processing result. Convert the processing result to the data format that the extracted database type matches.
  • the server 120 queries the database corresponding to the extracted database type, extracts the data identifier of the processing result, and stores the extracted data identifier and the processing result in the queried database.
  • the server 120 extracts the database identifier in the processing result storage instruction, and identifies the database type to which the database corresponding to the extracted database identifier belongs.
  • the server 120 determines the data format corresponding to the identified database type, converts the data format of the processing result into a determined data format, and stores the processed result after the converted format into the database corresponding to the extracted database identifier.
  • the database type in the processing result storage instruction is extracted, the processing result is converted into a data format, the data format of the processing result is matched with the database type, and the processing result after the conversion format is stored to the processing.
  • the database corresponding to the database type in the result storage instruction the correctness of the data format of the processing result is ensured.
  • the user enters a user account and a user password through a browser page and a data processing application page.
  • the terminal 110 acquires the input user account and the user password, generates a page data request according to the obtained user account and the user password, and the terminal 110 sends the page data request to the server 120.
  • the server 120 After receiving the page data request, the server 120 extracts the user account and the user password in the page data request, and verifies whether the user corresponding to the user account has the access right according to the user account and the user password. The server 120 returns the data processing page data to the terminal 110 after verifying that the user corresponding to the user account has the access right.
  • the terminal 110 displays the data processing page based on the data processing page data.
  • the user selects the task identifier in the data processing page, and clicks the data task execution button through the input device of the terminal 110.
  • the terminal 110 When detecting that the data task execution button in the data processing page is clicked, the terminal 110 generates a data processing task execution instruction according to the selected task identifier and the task dependency relationship corresponding to the selected task identifier, The data processing task execution instructions are sent to the server 120.
  • the server 120 extracts the task identifier corresponding to the task identifier and the task identifier in the data processing task execution instruction, and splits the plurality of data processing tasks according to the task dependency relationship and the task identifier.
  • the server 120 extracts a task script according to the task identifiers in each data processing task, and extracts data processing instructions and data acquisition conditions in the task script.
  • the server 120 queries the target data from the database corresponding to each database type that can be accessed according to the data acquisition condition, and acquires the target data corresponding to each database type.
  • the server 120 acquires a temporary table creation instruction corresponding to each database type, creates a temporary data table corresponding to the database type according to the temporary table creation instruction, and stores the corresponding target data to the temporary data table corresponding to the database type.
  • the temporary data tables corresponding to each database type can be interacted with before.
  • the server 120 processes the target data in the temporary data table corresponding to each database type according to the data processing instruction to obtain a processing result.
  • the server 120 acquires at least one of a user account, a data processing time, a data processing type, a database type, and a data acquisition condition registered by the terminal 110, according to the obtained user account, data processing time, data processing type, database type, and data acquisition. At least one of the conditions generates a data processing log.
  • a database data processing apparatus 700 is provided.
  • the apparatus specifically includes the following: an instruction acquisition module 702, an identifier extraction module 704, a script acquisition module 706, a script parsing module 708, and data acquisition.
  • the instruction acquisition module 702 is configured to acquire a data processing task execution instruction.
  • the identifier extraction module 704 is configured to extract a task identifier in the data processing task execution instruction.
  • the script obtaining module 706 is configured to obtain a task script corresponding to the task identifier.
  • the script parsing module 708 is configured to extract data processing instructions and data acquisition conditions in the task script.
  • the data obtaining module 710 is configured to use data corresponding to each database type according to the data acquisition condition. Get target data in the library.
  • the data table creating module 712 is configured to separately create a temporary data table according to the target data corresponding to each database type.
  • the data processing module 714 is configured to process the target data in the temporary data table according to the data processing instruction.
  • the data table creation module 712 is further configured to acquire a temporary table creation instruction corresponding to each database type; and create a temporary data table for the target data corresponding to the corresponding database type according to the temporary table creation instruction.
  • the edited task script is acquired according to the data processing task execution instruction, the data processing task is parsed by the task script, and the data processing instruction and the data acquisition condition in the data processing task are extracted, and the data acquisition condition is corresponding to each database type according to the data acquisition condition.
  • Get target data in the database The temporary data table is respectively created according to the target data corresponding to each database type, and the temporary data table corresponding to each database type is established, and the target data in the temporary data table corresponding to each database type is processed according to the data processing instruction. It is not necessary to separately perform the separate operation on the target data corresponding to each database type, which improves the processing efficiency of the data corresponding to each database type.
  • the script obtaining module 706 is further configured to: read each task identifier according to the task dependency in the data processing task execution instruction; and acquire a task script corresponding to the read task identifier.
  • the data processing task execution instruction includes a plurality of task identifiers and a task dependency relationship corresponding to the plurality of task identifiers, and the task identifier is read according to the task dependency relationship, and the task script is obtained according to the read task identifier.
  • the task corresponding to each task identifier is executed according to the task dependency relationship, the operation steps of executing the task are simplified, the task execution efficiency is improved, and multiple data processing tasks can be executed according to a data processing task execution instruction, thereby improving data processing efficiency.
  • the data processing module 714 specifically includes the following: a function identifier extraction module 714a, a processing function acquisition module 714b, and a processing result obtaining module 714c.
  • the function identifier extraction module 714a is configured to extract a custom function identifier in the data processing instruction.
  • the processing function obtaining module 714b is configured to obtain the custom function library according to the custom function identifier Take the data processing function.
  • the processing result obtaining module 714c is configured to process the target data in the temporary data table according to the acquired data processing function.
  • the target data in the temporary data table of each database type can be processed according to the user-defined data processing function, so that the processing of the target data is more flexible, and the accuracy and efficiency of the data processing are improved.
  • the database data processing apparatus 700 specifically includes the following: an instruction acquisition module 716, a type extraction module 718, a format conversion module 720, and a data storage module 722.
  • the instruction acquisition module 716 is configured to acquire a processing result storage instruction.
  • the type extraction module 718 is configured to extract a database type in the processing result storage instruction.
  • the format conversion module 720 is configured to convert the processing result obtained by processing the target data into a data format that matches the extracted database type.
  • the data storage module 722 is configured to store the processed result after the conversion format to a database corresponding to the extracted database type.
  • the database type in the processing result storage instruction is extracted, the processing result is converted into a data format, the data format of the processing result is matched with the database type, and the processing result after the conversion format is stored to the processing.
  • the database corresponding to the database type in the result storage instruction the correctness of the data format of the processing result is ensured.
  • the various modules in the database data processing apparatus described above may be implemented in whole or in part by software, hardware, and combinations thereof.
  • the network interface may be an Ethernet or a wireless network card.
  • Each of the above modules may be embedded in a hardware form or independent of a processor in the server, or may be stored in a memory of the server in a software form, so that the processor calls to perform operations corresponding to the above modules.
  • the processor can be a central processing unit (CPU), a microprocessor, a microcontroller, or the like.
  • a computer device comprising a memory and a processor, wherein the memory stores computer executable instructions that, when executed by the processor, cause the processor Performing the following steps: acquiring a data processing task execution instruction; extracting a task identifier in the data processing task execution instruction; acquiring a task script corresponding to the task identifier; extracting a data processing instruction and a data acquisition condition in the task script; and obtaining data from each database according to the data acquisition condition
  • the target data is obtained in the database corresponding to the type; the temporary data table is separately created according to the target data corresponding to each database type; and the target data in the temporary data table is processed according to the data processing instruction.
  • the task script corresponding to the task identifier is obtained, including: reading each task identifier according to the task dependency relationship in the data processing task execution instruction; and acquiring a task script corresponding to the read task identifier.
  • the temporary data table is separately created according to the target data corresponding to each database type, including: obtaining a temporary table creation instruction corresponding to each database type; and temporarily creating a temporary data corresponding to the corresponding database type according to the temporary table creation instruction. data sheet.
  • processing the target data in the temporary data table according to the data processing instruction comprises: extracting a custom function identifier in the data processing instruction; and acquiring a data processing function from the custom function library according to the custom function identifier; The target data in the temporary data table is processed according to the obtained data processing function.
  • the processor after processing the target data in the temporary data table according to the data processing instruction, the processor further performs the steps of: acquiring a processing result storage instruction; extracting a database type in the processing result storage instruction; performing the target data
  • the processed processing result is converted into a data format that matches the extracted database type; the processed result after the converted format is stored in the database corresponding to the extracted database type.
  • the edited task script is acquired according to the data processing task execution instruction, the data processing task is parsed by the task script, and the data processing instruction and the data acquisition condition in the data processing task are extracted, and the data acquisition condition is corresponding to each database type according to the data acquisition condition.
  • Get target data in the database The temporary data table is respectively created according to the target data corresponding to each database type, and the temporary data table corresponding to each database type is established, and the target data in the temporary data table corresponding to each database type is processed according to the data processing instruction. It is not necessary to separately perform the separate operation on the target data corresponding to each database type, which improves the processing efficiency of the data corresponding to each database type.
  • One or more storage media storing computer executable instructions that, when executed by one or more processors, cause one or more processors to perform the steps of: acquiring data processing task execution instructions; extracting data processing tasks Executing the task identifier in the instruction; acquiring the task script corresponding to the task identifier; extracting the data processing instruction and the data acquisition condition in the task script; acquiring the target data from the database corresponding to each database type according to the data acquisition condition; corresponding to each database type The target data respectively creates a temporary data table; the target data in the temporary data table is processed according to the data processing instruction.
  • the task script corresponding to the task identifier is obtained, including: reading each task identifier according to the task dependency relationship in the data processing task execution instruction; and acquiring a task script corresponding to the read task identifier.
  • the temporary data table is separately created according to the target data corresponding to each database type, including: obtaining a temporary table creation instruction corresponding to each database type; and temporarily creating a temporary data corresponding to the corresponding database type according to the temporary table creation instruction. data sheet.
  • processing the target data in the temporary data table according to the data processing instruction comprises: extracting a custom function identifier in the data processing instruction; and acquiring a data processing function from the custom function library according to the custom function identifier; The target data in the temporary data table is processed according to the obtained data processing function.
  • the processor after processing the target data in the temporary data table according to the data processing instruction, the processor further performs the steps of: acquiring a processing result storage instruction; extracting a database type in the processing result storage instruction; performing the target data
  • the processed processing result is converted into a data format that matches the extracted database type; the processed result after the converted format is stored in the database corresponding to the extracted database type.
  • the edited task script is acquired according to the data processing task execution instruction, the data processing task is parsed by the task script, and the data processing instruction and the data acquisition condition in the data processing task are extracted, and the data acquisition condition is corresponding to each database type according to the data acquisition condition.
  • Get target data in the database Create a temporary data table according to the target data corresponding to each database type, and establish each database by The temporary data table corresponding to the type is processed by the target data in the temporary data table corresponding to each database type according to the data processing instruction. It is not necessary to separately perform the separate operation on the target data corresponding to each database type, which improves the processing efficiency of the data corresponding to each database type.
  • the storage medium may be a magnetic disk, an optical disk, a read-only memory (ROM), or the like.

Landscapes

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

Abstract

L'invention concerne un procédé de traitement de données d'une base de données. Le procédé consiste à : acquérir une instruction d'exécution de tâche de traitement de données (S302) ; extraire un identifiant de tâche dans l'instruction d'exécution de tâche de traitement de données (S304) ; acquérir un script de tâche correspondant à l'identifiant de tâche (S306) ; extraire une instruction de traitement de données et une condition d'acquisition de données dans le script de tâche (S308) ; acquérir des données cibles auprès d'une base de données correspondant à chaque type de base de données selon la condition d'acquisition de données (S310) ; créer séparément une table de données temporaire selon les données cibles correspondant à chaque type de base de données (S312) ; et traiter les données cibles dans la table de données temporaire selon l'instruction de traitement de données (S314).
PCT/CN2017/104253 2017-07-24 2017-09-29 Procédé et appareil de traitement de données de base de données, dispositif informatique et support de stockage WO2019019361A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201710608523.8 2017-07-24
CN201710608523.8A CN107665233B (zh) 2017-07-24 2017-07-24 数据库数据处理方法、装置、计算机设备和存储介质

Publications (1)

Publication Number Publication Date
WO2019019361A1 true WO2019019361A1 (fr) 2019-01-31

Family

ID=61122580

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2017/104253 WO2019019361A1 (fr) 2017-07-24 2017-09-29 Procédé et appareil de traitement de données de base de données, dispositif informatique et support de stockage

Country Status (2)

Country Link
CN (1) CN107665233B (fr)
WO (1) WO2019019361A1 (fr)

Families Citing this family (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108446175A (zh) * 2018-03-12 2018-08-24 平安普惠企业管理有限公司 任务处理方法、装置、计算机设备和存储介质
CN108446371B (zh) * 2018-03-15 2020-10-27 平安科技（深圳）有限公司 数据回导方法、装置、计算机设备及存储介质
CN110309214B (zh) * 2018-04-10 2023-06-23 腾讯科技（深圳）有限公司 一种指令执行方法及其设备、存储介质、服务器
CN110489213B (zh) 2018-05-15 2022-04-05 华为技术有限公司 一种任务处理方法及处理装置、计算机系统
CN110750597A (zh) * 2018-07-23 2020-02-04 北京国双科技有限公司 数据处理方法及装置、存储介质和处理器
CN110019434A (zh) * 2018-08-23 2019-07-16 深圳市信锐网科技术有限公司 物联网数据处理方法、装置、平台及存储介质
CN109284097B (zh) * 2018-09-07 2022-02-15 武汉轻工大学 实现复杂数据分析的方法、设备、系统及存储介质
CN111339170A (zh) * 2018-12-19 2020-06-26 深圳市优必选科技有限公司 数据处理方法、装置、计算机设备及存储介质
CN110020773A (zh) * 2019-01-30 2019-07-16 阿里巴巴集团控股有限公司 一种数据处理方法、设备及计算机可读介质
CN110750308B (zh) * 2019-09-11 2024-03-01 东软集团股份有限公司 任务处理方法、装置、存储介质及电子设备
CN111078733B (zh) * 2019-11-26 2024-02-09 金蝶软件（中国）有限公司 批量任务处理方法、装置、计算机设备和存储介质
CN112988806A (zh) * 2019-12-17 2021-06-18 北京沃东天骏信息技术有限公司 一种数据处理的方法及装置
CN111813783B (zh) * 2020-07-27 2024-03-26 南方电网数字电网研究院有限公司 数据处理方法、装置、计算机设备和存储介质
CN112000644B (zh) * 2020-08-21 2022-08-02 北京浪潮数据技术有限公司 一种数据处理方法、系统及电子设备和存储介质
CN113269547B (zh) * 2021-05-31 2024-05-31 中国农业银行股份有限公司 数据处理方法、装置、电子设备和存储介质
CN113778999A (zh) * 2021-09-29 2021-12-10 平安资产管理有限责任公司 数据模块化处理方法、装置、计算机设备和存储介质
CN114238286B (zh) * 2022-02-28 2022-08-05 连连（杭州）信息技术有限公司 一种数据仓库数据处理方法、装置、电子设备及存储介质
CN115952172B (zh) * 2023-03-08 2023-05-26 畅捷通信息技术股份有限公司 一种基于数据库临时表的数据匹配方法及装置

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101944128A (zh) * 2010-09-25 2011-01-12 中兴通讯股份有限公司 数据导出、导入的方法和装置
US20160246824A1 (en) * 2011-11-10 2016-08-25 Treasure Data, Inc. System and method for operating a big-data platform
CN105930389A (zh) * 2016-04-14 2016-09-07 北京京东尚科信息技术有限公司 数据结转的方法和系统
CN106815353A (zh) * 2017-01-20 2017-06-09 星环信息科技（上海）有限公司 一种数据查询的方法及设备

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102346775A (zh) * 2011-09-26 2012-02-08 苏州博远容天信息科技有限公司 一种基于日志的异构多源数据库同步方法
CN105989142A (zh) * 2015-02-28 2016-10-05 华为技术有限公司 一种数据查询方法及装置
CN106649355A (zh) * 2015-10-30 2017-05-10 北京国双科技有限公司 一种数据处理方法及装置

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101944128A (zh) * 2010-09-25 2011-01-12 中兴通讯股份有限公司 数据导出、导入的方法和装置
US20160246824A1 (en) * 2011-11-10 2016-08-25 Treasure Data, Inc. System and method for operating a big-data platform
CN105930389A (zh) * 2016-04-14 2016-09-07 北京京东尚科信息技术有限公司 数据结转的方法和系统
CN106815353A (zh) * 2017-01-20 2017-06-09 星环信息科技（上海）有限公司 一种数据查询的方法及设备

Also Published As

Publication number Publication date
CN107665233A (zh) 2018-02-06
CN107665233B (zh) 2020-07-31

Similar Documents

Publication Publication Date Title
WO2019019361A1 (fr) Procédé et appareil de traitement de données de base de données, dispositif informatique et support de stockage
WO2019085073A1 (fr) Procédé et appareil de test d'interface, dispositif informatique et support d'informations
WO2020220638A1 (fr) Procédé et appareil d'association d'un système de liaison à un système de journalisation, et support de stockage
WO2019085079A1 (fr) Procédé et appareil de test d'interface, dispositif informatique et support d'informations
US20140033262A1 (en) Parsing Single Source Content for Multi-Channel Publishing
WO2019227715A1 (fr) Procédé et appareil de traitement d'images et support de stockage lisible par ordinateur
TW201331779A (zh) 提供程式解析驗證服務系統及其控制方法、控制程式、使電腦發揮作用之控制程式、程式解析驗證裝置、程式解析驗證工具管理裝置
CN107506256B (zh) 一种崩溃数据监控的方法和装置
WO2019019645A1 (fr) Procédé et appareil d'exécution de tâche de poussée d'informations, dispositif informatique et support de stockage
US11080322B2 (en) Search methods, servers, and systems
US20150193832A1 (en) Method, apparatus, and system for communicating and presenting product information
WO2020015170A1 (fr) Appareil et procédé d'invocation d'interface, et support d'informations lisible par ordinateur
WO2019019670A1 (fr) Procédé et dispositif d'accès à une application, appareil informatique et support d'informations
WO2019196260A1 (fr) Procédé et dispositif de recherche automatique d'informations logistiques, dispositif terminal et support de stockage lisible
CN115208951A (zh) 请求处理方法、装置、电子设备及计算机可读存储介质
US11514240B2 (en) Techniques for document marker tracking
CN114237890A (zh) 应用的协同展示方法、装置、服务器、终端和程序产品
WO2019000697A1 (fr) Procédé, système, serveur de recherche d'informations, et support de stockage lisible
US9537928B2 (en) Remote computing device use of unsupported local computing device components
US20160224553A1 (en) Search methods and terminals
CN112487218B (zh) 内容处理方法、系统、装置、计算设备和存储介质
WO2018233365A1 (fr) Procédé d'interrogation d'informations, terminal, dispositif et support d'informations
CN104407846B (zh) 一种信息处理方法及装置
WO2019114133A1 (fr) Procédé et appareil de modification de couleur de contenu de page d'édition, terminal et support de stockage
CN112380828A (zh) Pdf文档生成方法和装置、存储介质和电子设备

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 28.05.2020)

122 Ep: pct application non-entry in european phase

Ref document number: 17919334

Country of ref document: EP

Kind code of ref document: A1