WO2019062191A1 - Dispositif électronique, procédé et système d'extraction de données dans une table de données, et support de stockage - Google Patents

Dispositif électronique, procédé et système d'extraction de données dans une table de données, et support de stockage Download PDF

Info

Publication number
WO2019062191A1
WO2019062191A1 PCT/CN2018/089874 CN2018089874W WO2019062191A1 WO 2019062191 A1 WO2019062191 A1 WO 2019062191A1 CN 2018089874 W CN2018089874 W CN 2018089874W WO 2019062191 A1 WO2019062191 A1 WO 2019062191A1
Authority
WO
WIPO (PCT)
Prior art keywords
extracted
field
data table
excel
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Ceased
Application number
PCT/CN2018/089874
Other languages
English (en)
Chinese (zh)
Inventor
王政
邹学森
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An Technology Shenzhen Co Ltd
Original Assignee
Ping An Technology Shenzhen Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ping An Technology Shenzhen Co Ltd filed Critical Ping An Technology Shenzhen Co Ltd
Publication of WO2019062191A1 publication Critical patent/WO2019062191A1/fr
Anticipated expiration legal-status Critical
Ceased legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G06F16/258—Data format conversion from or to a database

Definitions

  • the present application relates to the field of database technologies, and in particular, to an electronic device, a method, a system, and a storage medium for extracting data of a data table.
  • the purpose of the present application is to provide an electronic device, a method, a system and a storage medium for extracting data of a data table, which are intended to automatically parse and extract data of an Excel data table imported into a financial auxiliary system, saving time and effort, and facilitating the later stage. maintain.
  • the present application provides an electronic device including a memory and a processor coupled to the memory, the memory storing a processing system operable on the processor, the processing The system implements the following steps when executed by the processor:
  • the service type corresponding to the Excel data table is identified based on the file name of the Excel data table, and the Excel data table is determined according to the relationship between the stored service type and the field to be extracted.
  • the field to be extracted associated with the corresponding service type
  • the present application further provides a method for extracting data of a data table, where the method for extracting data of the data table includes:
  • the service type corresponding to the Excel data table is identified based on the file name of the Excel data table, and the Excel data table is determined according to the relationship between the stored service type and the field to be extracted.
  • the field to be extracted associated with the corresponding service type
  • the present application further provides a system for extracting data of a data table, the system for extracting data of the data table includes:
  • a configuration module configured to pre-define a service type corresponding to each Excel data table, and for each service type, configure a to-be-extracted field associated with the service type, and store an association relationship between the service type and the corresponding to-be-extracted field;
  • a determining module configured to identify a service type corresponding to the Excel data table based on a file name of the Excel data table when the Excel data table is imported into the financial assistance system, and determine the relationship according to the stored service type and the relationship to be extracted The field to be extracted associated with the service type corresponding to the Excel data table;
  • An extracting module configured to extract a data object in the Excel data table based on the determined field to be extracted
  • the display module is configured to display the determined to-be-extracted field and the extracted data object for confirmation by the user.
  • the present application also provides a computer readable storage medium having stored thereon a processing system that, when executed by a processor, implements the steps of the method of extracting data of a data table as described above.
  • the utility model has the beneficial effects that the present application can identify the service type of the Excel data table when the Excel data table is imported into the financial assistance system, determine the field to be extracted associated with the service type corresponding to the Excel data table, and extract the to-be-extracted field.
  • the corresponding data object under the field displays the determined to-be-extracted field and the extracted data object.
  • the present application can automatically parse and extract the data of the Excel data table imported into the financial auxiliary system, saving time and effort. There is no need to write various code to analyze and extract data, to avoid differences, and to facilitate later maintenance.
  • FIG. 1 is a schematic diagram of an optional application environment of each embodiment of the present application.
  • FIG. 2 is a schematic flowchart of a method for extracting data of a data table according to an embodiment of the present application
  • FIG. 3 is a schematic diagram of the refinement process of step S3 shown in FIG. 2.
  • first, second and the like in the present application are for the purpose of description only, and are not to be construed as indicating or implying their relative importance or implicitly indicating the number of technical features indicated. .
  • features defining “first” and “second” may include at least one of the features, either explicitly or implicitly.
  • the technical solutions between the various embodiments may be combined with each other, but must be based on the realization of those skilled in the art, and when the combination of the technical solutions is contradictory or impossible to implement, it should be considered that the combination of the technical solutions does not exist. Nor is it within the scope of protection required by this application.
  • FIG. 1 it is a schematic diagram of an application environment of a preferred embodiment of a method for extracting data of a data table.
  • the application environment diagram includes an electronic device 1 and a terminal device 2.
  • the electronic device 1 can perform data interaction with the terminal device 2 through a suitable technology such as a network or a near field communication technology.
  • the terminal device 2 includes, but is not limited to, any electronic product that can interact with a user through a keyboard, a mouse, a remote controller, a touch panel, or a voice control device, for example, a personal computer, a tablet computer, or a smart phone. , Personal Digital Assistant (PDA), game consoles, Internet Protocol Television (IPTV), smart wearable devices, navigation devices, etc., or mobile devices such as digital TVs, desktop computers, Fixed terminal for notebooks, servers, etc.
  • the terminal device 2 is configured to receive an instruction of the user (for example, an instruction to configure a field to be extracted associated with various service types) and send it to the electronic device 1, and display information fed back by the electronic device 1 and the like.
  • the software and/or hardware components of the terminal device 2 for receiving the user's instructions and transmitting them to the electronic device 1 and displaying the information fed back by the electronic device 1 may be integrated into the electronic device 1 without A special terminal device 2 is required.
  • the electronic device 1 is an apparatus capable of automatically performing numerical calculation and/or information processing in accordance with an instruction set or stored in advance.
  • the electronic device 1 may be a computer, a single network server, a server group composed of multiple network servers, or a cloud-based cloud composed of a large number of hosts or network servers, where cloud computing is a type of distributed computing.
  • a super virtual computer consisting of a group of loosely coupled computers.
  • the electronic device 1 may include, but is not limited to, a memory 11 communicably connected to each other through a system bus, a processor 12, and a network interface 13, and the memory 11 stores a processing system operable on the processor 12. It should be noted that FIG. 1 only shows the electronic device 1 having the components 11-13, but it should be understood that not all illustrated components may be implemented, and more or fewer components may be implemented instead.
  • the memory 11 includes a memory and at least one type of readable storage medium.
  • the memory provides a cache for the operation of the electronic device 1;
  • the readable storage medium may be, for example, a flash memory, a hard disk, a multimedia card, a card type memory (eg, SD or DX memory, etc.), a random access memory (RAM), a static random access memory (SRAM).
  • a non-volatile storage medium such as a read only memory (ROM), an electrically erasable programmable read only memory (EEPROM), a programmable read only memory (PROM), a magnetic memory, a magnetic disk, an optical disk, or the like.
  • the readable storage medium may be an internal storage unit of the electronic device 1, such as a hard disk of the electronic device 1; in other embodiments, the non-volatile storage medium may also be external to the electronic device 1.
  • a storage device such as a plug-in hard disk equipped with an electronic device 1, a smart memory card (SMC), a Secure Digital (SD) card, a flash card, or the like.
  • the readable storage medium of the memory 11 is generally used to store an operating system installed in the electronic device 1 and various types of application software, such as program codes of the processing system in an embodiment of the present application. Further, the memory 11 can also be used to temporarily store various types of data that have been output or are to be output.
  • the processor 12 may be a Central Processing Unit (CPU), controller, microcontroller, microprocessor, or other data processing chip in some embodiments.
  • the processor 12 is typically used to control the overall operation of the electronic device 1, such as performing control and processing related to data interaction or communication with the terminal device 2.
  • the processor 12 is configured to run program code or process data stored in the memory 11, such as running a processing system or the like.
  • the network interface 13 may comprise a wireless network interface or a wired network interface, which is typically used to establish a communication connection between the electronic device 1 and other electronic devices.
  • the network interface 13 is mainly used to connect the electronic device 1 with one or more terminal devices 2, and establish a data transmission channel and a communication connection between the electronic device 1 and one or more terminal devices 2.
  • the processing system is stored in the memory 11 and includes at least one computer readable instruction stored in the memory 11, the at least one computer readable instruction being executable by the processor 12 to implement the methods of various embodiments of the present application;
  • the at least one computer readable instruction can be classified into different logic modules depending on the functions implemented by its various parts.
  • Step S1 pre-defining the service type corresponding to each Excel data table, and configuring, for each service type, a field to be extracted associated with the service type, and storing an association relationship between the service type and the corresponding field to be extracted;
  • an automatic parsing and extracting component of the Excel data table content is developed.
  • the business type corresponding to each Excel data table can be defined in advance, for example, for an Excel data table.
  • the “travel expense reimbursement template”, the corresponding business type is the reimbursement type.
  • the Excel data table “entry line upload template”, the corresponding business type is the financial system accounting line record type.
  • the field to be extracted associated with the configuration For each type of service, configure the field to be extracted associated with the service type. For example, for the type of reimbursement, the field to be extracted associated with the configuration includes “employee name or employee ID, department, reimbursement, reimbursement amount and Reimbursement time” and so on. For the financial system accounting line record type, the fields to be extracted associated with the configuration include “ticket type, reimbursement category, output tax rate, accounting processing type, detail type, description and flexfield information”.
  • the relationship between the service types of the various Excel data tables and the corresponding fields to be extracted is stored, for example, in the form of an association mapping table. storage.
  • Step S2 when the Excel data table is imported into the financial auxiliary system, the service type corresponding to the Excel data table is identified based on the file name of the Excel data table, and the Excel data is determined according to the relationship between the stored service type and the field to be extracted.
  • the field to be extracted associated with the service type corresponding to the table;
  • one or more Excel data tables containing different contents may be imported at one time.
  • the service type corresponding to the Excel data table is identified based on the file name of the Excel data table. As described above, if the file name of the Excel data table is “travel expense reimbursement template”, then The business type of the Excel data table is identified as a reimbursement order type. If the file name of the Excel data table is “entry line upload template”, the business type of the Excel data table is identified as a financial system accounting line record type.
  • the association relationship between the service type and the field to be extracted determines the field to be extracted associated with the service type corresponding to the Excel data table.
  • Step S3 extracting a data object in the Excel data table based on the determined field to be extracted;
  • step S4 the determined field to be extracted and the extracted data object are displayed for confirmation by the user.
  • the fields to be extracted are the employee name or employee ID, the department, the reimbursement reason, the reimbursement time and the reimbursement amount.
  • the corresponding data objects under the fields to be extracted are “Zhang San, Sales Department, Beijing Business Travel, 2017.07.20,
  • the train ticket fee is 500 yuan
  • the air ticket fee is 1,500 yuan
  • the accommodation fee is 500 yuan.”
  • the field to be extracted and the extracted data object are displayed for the user to confirm and confirm. If the user confirms that the displayed content has no errors, it is put into the library for subsequent execution of corresponding data operations, such as data encapsulation, warehousing, and the like.
  • the embodiment identifies the service type of the Excel data table, determines the to-be-extracted field associated with the service type corresponding to the Excel data table, and extracts the to-be-extracted field.
  • the corresponding data object under the field, the determined to-be-extracted field and the extracted data object are displayed.
  • the data of the Excel data table imported into the financial auxiliary system can be automatically parsed and extracted, saving time. Labor-saving, no need to write a variety of code to analyze and extract data, to avoid differences, and to facilitate later maintenance.
  • the step S3 includes:
  • the first determined field to be extracted is compared with each fixed field in the Excel data table. If the fixed field in the Excel data table is the same as the first determined field to be extracted, The second determined field to be extracted is continuously compared with each fixed field in the Excel data table until all the determined fields to be extracted are compared.
  • the determined to-be-extracted field is in one-to-one correspondence with each fixed field, it is analyzed whether there is a corresponding data object under each fixed field. If each fixed field has a corresponding data object, the fixed field may be directly extracted. The corresponding data object.
  • the fields to be extracted include: employee name or employee ID, department, reimbursement reason, reimbursement time and reimbursement amount details, and the fixed fields in Table 1 are: employee name, The department, reimbursement reason, reimbursement time and reimbursement amount details, if the two are corresponding and identical, you can analyze whether there are corresponding data objects in each fixed field in Table 1, if any, you can extract.
  • step S3 further includes: if the determined to-be-extracted field does not correspond to each fixed field, or if there is no corresponding data object in the fixed field, the generating includes the determined to be extracted.
  • a prompt message for the field to prompt the user to manually check the Excel data table.
  • the following steps are further implemented: according to a predetermined conversion rule before displaying the extracted data object. Convert the extracted data object to the corresponding data format.
  • the user may set a plurality of conversion rules in advance, and set one or more of the conversion rules to be the predetermined conversion rule, or the user corresponding to the Excel data table after setting a plurality of conversion rules in advance.
  • the type automatically selects the corresponding conversion rule.
  • the extracted data object Before displaying the extracted data object, converting the extracted data object into a corresponding data format according to a predetermined conversion rule, for example, for the amount of money, uniformly converting it into data in units of yuan and two decimal places, for Time is unified into the form of "****-**-**", and so on.
  • the data object is converted into a corresponding data format, which is convenient for the user to confirm, and facilitates subsequent execution of corresponding data operations, such as data encapsulation, storage, and the like.
  • FIG. 2 is a schematic flowchart of a method for extracting data of a data table according to an embodiment of the present application.
  • the method for extracting data of a data table includes the following steps:
  • Step S1 pre-defining the service type corresponding to each Excel data table, and configuring, for each service type, a field to be extracted associated with the service type, and storing an association relationship between the service type and the corresponding field to be extracted;
  • an automatic parsing and extracting component of the Excel data table content is developed.
  • the business type corresponding to each Excel data table can be defined in advance, for example, for an Excel data table.
  • the “travel expense reimbursement template”, the corresponding business type is the reimbursement type.
  • the Excel data table “entry line upload template”, the corresponding business type is the financial system accounting line record type.
  • the field to be extracted associated with the configuration For each type of service, configure the field to be extracted associated with the service type. For example, for the type of reimbursement, the field to be extracted associated with the configuration includes “employee name or employee ID, department, reimbursement, reimbursement amount and Reimbursement time” and so on. For the financial system accounting line record type, the fields to be extracted associated with the configuration include “ticket type, reimbursement category, output tax rate, accounting processing type, detail type, description and flexfield information”.
  • the relationship between the service types of the various Excel data tables and the corresponding fields to be extracted is stored, for example, in the form of an association mapping table. storage.
  • Step S2 when the Excel data table is imported into the financial auxiliary system, the service type corresponding to the Excel data table is identified based on the file name of the Excel data table, and the Excel data is determined according to the relationship between the stored service type and the field to be extracted.
  • the field to be extracted associated with the service type corresponding to the table;
  • one or more Excel data tables containing different contents may be imported at one time.
  • the service type corresponding to the Excel data table is identified based on the file name of the Excel data table. As described above, if the file name of the Excel data table is “travel expense reimbursement template”, then The business type of the Excel data table is identified as a reimbursement order type. If the file name of the Excel data table is “entry line upload template”, the business type of the Excel data table is identified as a financial system accounting line record type.
  • the association relationship between the service type and the field to be extracted determines the field to be extracted associated with the service type corresponding to the Excel data table.
  • Step S3 extracting a data object in the Excel data table based on the determined field to be extracted;
  • step S4 the determined field to be extracted and the extracted data object are displayed for confirmation by the user.
  • the Excel data table is a "travel expense reimbursement template"
  • the data therein is as shown in Table 1 above.
  • the fields to be extracted are the employee name or employee ID, the department, the reimbursement reason, the reimbursement time and the reimbursement amount.
  • the corresponding data objects under the fields to be extracted are “Zhang San, Sales Department, Beijing Business Travel, 2017.07.20,
  • the train ticket fee is 500 yuan
  • the air ticket fee is 1,500 yuan
  • the accommodation fee is 500 yuan.”
  • the field to be extracted and the extracted data object are displayed for the user to confirm and confirm. If the user confirms that the displayed content has no errors, it is put into the library for subsequent execution of corresponding data operations, such as data encapsulation, warehousing, and the like.
  • the embodiment identifies the service type of the Excel data table, determines the to-be-extracted field associated with the service type corresponding to the Excel data table, and extracts the to-be-extracted field.
  • the corresponding data object under the field, the determined to-be-extracted field and the extracted data object are displayed.
  • the data of the Excel data table imported into the financial auxiliary system can be automatically parsed and extracted, saving time. Labor-saving, no need to write a variety of code to analyze and extract data, to avoid differences, and to facilitate later maintenance.
  • the step S3 includes:
  • the first determined field to be extracted is compared with each fixed field in the Excel data table. If the fixed field in the Excel data table is the same as the first determined field to be extracted, The second determined field to be extracted is continuously compared with each fixed field in the Excel data table until all the determined fields to be extracted are compared.
  • the determined to-be-extracted field is in one-to-one correspondence with each fixed field, it is analyzed whether there is a corresponding data object under each fixed field. If each fixed field has a corresponding data object, the fixed field may be directly extracted. The corresponding data object.
  • the fields to be extracted include: employee name or employee ID, department, reimbursement reason, reimbursement time and reimbursement amount details, and the fixed fields in Table 1 are: employee name, The department, reimbursement reason, reimbursement time and reimbursement amount details, if the two are corresponding and identical, you can analyze whether there are corresponding data objects in each fixed field in Table 1, if any, you can extract.
  • step S3 further includes: if the determined to-be-extracted field does not correspond to each fixed field, or if there is no corresponding data object in the fixed field, the generating includes the determined to be extracted.
  • a prompt message for the field to prompt the user to manually check the Excel data table.
  • the method further comprises: converting the extracted data object into a corresponding data format according to a predetermined conversion rule before displaying the extracted data object.
  • the user may set a plurality of conversion rules in advance, and set one or more of the conversion rules to be the predetermined conversion rule, or the user corresponding to the Excel data table after setting a plurality of conversion rules in advance.
  • the type automatically selects the corresponding conversion rule.
  • the extracted data object Before displaying the extracted data object, converting the extracted data object into a corresponding data format according to a predetermined conversion rule, for example, for the amount of money, uniformly converting it into data in units of yuan and two decimal places, for Time is unified into the form of "****-**-**", and so on.
  • the data object is converted into a corresponding data format, which is convenient for the user to confirm, and facilitates subsequent execution of corresponding data operations, such as data encapsulation, storage, and the like.
  • the present application also provides a computer readable storage medium having stored thereon a processing system that, when executed by a processor, implements the steps of the method of extracting data of a data table as described above.
  • the foregoing embodiment method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be through hardware, but in many cases, the former is better.
  • Implementation Based on such understanding, the technical solution of the present application, which is essential or contributes to the prior art, may be embodied in the form of a software product stored in a storage medium (such as ROM/RAM, disk,
  • the optical disc includes a number of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the methods described in various embodiments of the present application.

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

La présente invention concerne un dispositif électronique, un procédé et un système d'extraction de données dans une table de données, ainsi qu'un support de stockage. Le procédé consiste à : prédéfinir des types de service correspondant à diverses tables de données Excel, concernant chaque type de service, configurer un champ à extraire associé au type de service, et stocker une relation d'association entre le type de service et le champ correspondant à extraire; lorsqu'une table de données Excel est importée dans un système d'assistance financière, identifier, sur la base d'un nom de fichier de la table de données Excel, un type de service correspondant à la table de données Excel, et déterminer un champ à extraire associé au type de service correspondant à la table de données Excel selon la relation d'association stockée entre le type de service et le champ à extraire; sur la base du champ déterminé à extraire, extraire un objet de données dans la table de données Excel; et afficher le champ déterminé à extraire et l'objet de données extrait en vue d'une confirmation par un utilisateur. La présente invention peut analyser et extraire automatiquement des données d'une table de données Excel qui est importée dans un système d'assistance financière, ce qui permet d'économiser en temps et en main-d'œuvre, et de faciliter une maintenance ultérieure.
PCT/CN2018/089874 2017-09-30 2018-06-05 Dispositif électronique, procédé et système d'extraction de données dans une table de données, et support de stockage Ceased WO2019062191A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201710914884.5 2017-09-30
CN201710914884.5A CN107870979A (zh) 2017-09-30 2017-09-30 电子装置、提取数据表的数据的方法及存储介质

Publications (1)

Publication Number Publication Date
WO2019062191A1 true WO2019062191A1 (fr) 2019-04-04

Family

ID=61753006

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/089874 Ceased WO2019062191A1 (fr) 2017-09-30 2018-06-05 Dispositif électronique, procédé et système d'extraction de données dans une table de données, et support de stockage

Country Status (2)

Country Link
CN (1) CN107870979A (fr)
WO (1) WO2019062191A1 (fr)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110517740A (zh) * 2019-07-03 2019-11-29 平安科技（深圳）有限公司 医疗数据处理方法、系统、计算机设备及存储介质
CN115827734A (zh) * 2022-11-30 2023-03-21 杭州海康威视数字技术股份有限公司 一种关联键关系确定、数据表关联关系构建方法及装置
CN117421379A (zh) * 2023-11-08 2024-01-19 中国工商银行股份有限公司 字段关系的确定方法、装置及设备

Families Citing this family (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107870979A (zh) * 2017-09-30 2018-04-03 平安科技（深圳）有限公司 电子装置、提取数据表的数据的方法及存储介质
CN110222104A (zh) * 2019-04-30 2019-09-10 中国人民财产保险股份有限公司 数据提取方法、设备及存储介质
CN111400135A (zh) * 2020-03-13 2020-07-10 普信恒业科技发展（北京）有限公司 一种业务数据的提取方法及装置
CN111462845B (zh) * 2020-03-17 2025-05-02 深圳平安智慧医健科技有限公司 动态表单生成方法、装置、计算机设备和存储介质
CN111625586A (zh) * 2020-05-27 2020-09-04 北京思特奇信息技术股份有限公司 一种通用业务数据的导入方法和系统
CN111694867A (zh) * 2020-06-16 2020-09-22 北京同邦卓益科技有限公司 数据管理方法、装置、电子设备及存储介质
CN112882630B (zh) * 2021-03-19 2022-07-29 腾讯科技（深圳）有限公司 一种信息配置方法及相关产品
CN113505580A (zh) * 2021-07-26 2021-10-15 京东科技控股股份有限公司 表格文件的解析方法和装置
CN114037304B (zh) * 2021-11-16 2025-04-22 浪潮通用软件有限公司 一种成本资料的数据归集方法、设备及介质
CN114547040A (zh) * 2022-02-25 2022-05-27 北京北信源软件股份有限公司 数据处理方法、装置、设备及介质
CN114722109B (zh) * 2022-04-13 2024-02-06 中国电信股份有限公司 数据导入方法、系统、设备及存储介质
CN117009422B (zh) * 2023-05-09 2024-04-12 三峡高科信息技术有限责任公司 便利业务人员进行数据导入的实现方法
CN117235079A (zh) * 2023-11-16 2023-12-15 中国人民财产保险股份有限公司 数据处理方法、装置及设备

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103246651A (zh) * 2012-02-02 2013-08-14 金蝶软件（中国）有限公司 一种数据导入方法及系统
CN103744982A (zh) * 2014-01-15 2014-04-23 北京神州普惠科技股份有限公司 一种将Excel数据导入数据库的方法
US20150339285A1 (en) * 2014-04-22 2015-11-26 Aman Safaei Methods and Systems for Batch Generation and Delivery of Customized Documents
CN105138497A (zh) * 2015-07-13 2015-12-09 深圳市永兴元科技有限公司 报表系统中的报表上报方法及报表系统
CN107193788A (zh) * 2017-06-13 2017-09-22 广东中建普联科技股份有限公司 建设行业工程项目Excel文件数据格式化存储方法及系统
CN107870979A (zh) * 2017-09-30 2018-04-03 平安科技（深圳）有限公司 电子装置、提取数据表的数据的方法及存储介质

Family Cites Families (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101251809B (zh) * 2008-03-11 2011-03-16 浪潮集团山东通用软件有限公司 一种数据接口的实现方法
CN105376220B (zh) * 2011-11-30 2019-09-17 阿里巴巴集团控股有限公司 一种业务实现方法、系统以及服务器
CN102542038A (zh) * 2011-12-27 2012-07-04 浪潮通信信息系统有限公司 一种通用可配置的标准局数据入库方法
CN103970758A (zh) * 2013-01-29 2014-08-06 鸿富锦精密工业（深圳）有限公司 数据库访问系统及方法
CN103995908A (zh) * 2014-06-17 2014-08-20 山东中创软件工程股份有限公司 一种数据导入方法及装置
CN105117431A (zh) * 2015-08-07 2015-12-02 北京思特奇信息技术股份有限公司 一种动态配置外部导入数据的方法及系统
CN105243117B (zh) * 2015-09-28 2019-03-12 四川长虹电器股份有限公司 一种数据处理系统和方法
CN105912698A (zh) * 2016-04-25 2016-08-31 乐视控股（北京）有限公司 磁盘中数据文件的删除方法及系统
CN106503457B (zh) * 2016-10-26 2018-12-11 清华大学 基于转化医学分析平台的临床数据集成技术数据导入方法
CN106682150B (zh) * 2016-12-22 2020-12-01 北京锐安科技有限公司 一种信息处理的方法及装置
CN107463661B (zh) * 2017-07-31 2021-04-27 绿湾网络科技有限公司 数据的导入方法及装置

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103246651A (zh) * 2012-02-02 2013-08-14 金蝶软件（中国）有限公司 一种数据导入方法及系统
CN103744982A (zh) * 2014-01-15 2014-04-23 北京神州普惠科技股份有限公司 一种将Excel数据导入数据库的方法
US20150339285A1 (en) * 2014-04-22 2015-11-26 Aman Safaei Methods and Systems for Batch Generation and Delivery of Customized Documents
CN105138497A (zh) * 2015-07-13 2015-12-09 深圳市永兴元科技有限公司 报表系统中的报表上报方法及报表系统
CN107193788A (zh) * 2017-06-13 2017-09-22 广东中建普联科技股份有限公司 建设行业工程项目Excel文件数据格式化存储方法及系统
CN107870979A (zh) * 2017-09-30 2018-04-03 平安科技（深圳）有限公司 电子装置、提取数据表的数据的方法及存储介质

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110517740A (zh) * 2019-07-03 2019-11-29 平安科技（深圳）有限公司 医疗数据处理方法、系统、计算机设备及存储介质
CN110517740B (zh) * 2019-07-03 2023-08-11 平安科技（深圳）有限公司 医疗数据处理方法、系统、计算机设备及存储介质
CN115827734A (zh) * 2022-11-30 2023-03-21 杭州海康威视数字技术股份有限公司 一种关联键关系确定、数据表关联关系构建方法及装置
CN117421379A (zh) * 2023-11-08 2024-01-19 中国工商银行股份有限公司 字段关系的确定方法、装置及设备

Also Published As

Publication number Publication date
CN107870979A (zh) 2018-04-03

Similar Documents

Publication Publication Date Title
WO2019062191A1 (fr) Dispositif électronique, procédé et système d'extraction de données dans une table de données, et support de stockage
US20210109934A1 (en) Configurable and incremental database migration framework for heterogeneous databases
CN111598122B (zh) 数据校验方法、装置、电子设备和存储介质
US10552439B2 (en) Grid format data viewing and editing environment
CN110750654A (zh) 知识图谱获取方法、装置、设备和介质
CN107392655B (zh) 优惠券推送方法、系统、存储介质、电子设备及分流方法
WO2019134340A1 (fr) Procédé de calcul scalaire, serveur d'application et support de stockage lisible par ordinateur
CN115587575B (zh) 数据表创建方法、目标数据查询方法、装置及设备
WO2019153598A1 (fr) Procédé de gestion du niveau de risque de clients, serveur et support de stockage lisible par ordinateur
CN110597511A (zh) 一种页面自动生成方法、系统、终端设备及存储介质
WO2019062189A1 (fr) Dispositif électronique, procédé et système pour effectuer un traitement de classement sur une table de données, et support de stockage
CN114281803A (zh) 数据迁移方法、装置、设备、介质和程序产品
CN113706249B (zh) 数据推荐方法、装置、电子设备及存储介质
WO2019100619A1 (fr) Appareil électronique, procédé et système pour interrogation corrélée multi-tables, et support de stockage
CN108536715B (zh) 一种预览页面生成方法、装置、设备以及存储介质
WO2019136812A1 (fr) Dispositif électronique, procédé de génération et de consultation de journal d'appels de données, et support de stockage
CN110443690A (zh) 一种差异数据对账的方法、装置、服务器和存储介质
CN110362630A (zh) 数据管理方法、装置、设备与计算机可读存储介质
WO2019169763A1 (fr) Appareil électronique, procédé de contrôle de risque de système de service et support de stockage
CN113515510A (zh) 数据处理方法、数据处理系统、电子设备及可读存储介质
WO2019071907A1 (fr) Procédé d'identification d'informations d'aide d'après une page d'opération, et serveur d'applications
CN113111051A (zh) 一种数据迁移方法和装置
CN107729768B (zh) 一种页面显示方法、装置、智能平板和存储介质
WO2019071968A1 (fr) Procédé de calcul de salaire, serveur d'application et support de stockage lisible par ordinateur
CN110032513B (zh) 一种数据校验的方法、装置及电子设备

Legal Events

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

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 18860143

Country of ref document: EP

Kind code of ref document: A1