WO2019000984A1 - Data matching method and apparatus, server, and storage medium - Google Patents

Data matching method and apparatus, server, and storage medium Download PDF

Info

Publication number
WO2019000984A1
WO2019000984A1 PCT/CN2018/076990 CN2018076990W WO2019000984A1 WO 2019000984 A1 WO2019000984 A1 WO 2019000984A1 CN 2018076990 W CN2018076990 W CN 2018076990W WO 2019000984 A1 WO2019000984 A1 WO 2019000984A1
Authority
WO
WIPO (PCT)
Prior art keywords
original
field name
configuration table
data
docking
Prior art date
Application number
PCT/CN2018/076990
Other languages
French (fr)
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 WO2019000984A1 publication Critical patent/WO2019000984A1/en

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2477Temporal data queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems

Definitions

  • a data docking device comprising:
  • a receiving module configured to receive a data docking request sent by the first terminal, where the data docking request carries original data, where the original data includes multiple original field names;
  • An obtaining module configured to obtain a docking configuration table, where the service field name and the corresponding original field name are recorded in the docking configuration table;
  • a server comprising a memory and one or more processors, the memory storing computer readable instructions, the computer readable instructions being executed by the processor, causing the one or more processors to perform the following step:
  • the original data corresponding business field name is recorded into the service data table according to the original field name that is queried.
  • One or more computer readable non-volatile storage media storing computer readable instructions, when executed by one or more processors, cause one or more processors to perform the steps of:
  • the original data corresponding business field name is recorded into the service data table according to the original field name that is queried.
  • FIG. 1 is an application environment diagram of a data docking method in an embodiment
  • Figure 3 is a block diagram of a data docking device in one embodiment
  • Step 202 Receive a data docking request sent by the first terminal, where the data docking request carries original data, where the original data includes multiple original field names.
  • the business data table is a data structure table established by the insurance company according to its own business processing specifications or with reference to the business processing specifications of the business delivery system. For example, when processing the claims business, the claims data needs to be delivered to the SMIS (Human Resources Social Security Statistical Reporting System) for verification, and the business data table for the claims business is established with reference to the field names used by the SMIS.
  • the business data table can be one or multiple sheets, and each business data table includes multiple business field names.
  • the independent docking configuration table has a corresponding customer identification.
  • the independent docking configuration table records all the business field names in the business data table and all or part of the original field names provided by each customer. Each business field name corresponds to an original field name.
  • the server can obtain a separate docking configuration table based on the customer ID. For example, when customer A conducts claims business, it uses the original field names such as name, gender, ID number, mobile phone, and insured date; when customer B conducts claims business, it uses name, gender, ID number, and contact.
  • the original field name such as the mode and the time of the insurance.
  • the connection configuration table corresponding to customer A and customer B is shown in Table 2 and Table 3:
  • the server queries the original field name corresponding to the service field name in the service data table in the docking configuration table through a SQL statement (Structured Query Language), and uses the original field name to query the same original field name in the original data. .
  • the server can use the shared docking configuration table to query the original field name corresponding to each service field name in the service data table.
  • the server may also obtain an opposite docking configuration table according to the customer identifier, and query the original field name corresponding to each service field name in the service data table by using an independent docking configuration table.
  • the service field name since the service field name and the corresponding original field name are recorded in the docking configuration table, the service field name has a mapping relationship with the original field name.
  • the mapping relationship By using the mapping relationship, the original field name corresponding to the service field name can be queried in the original data, so that the original data corresponding business field name can be recorded into the service data table according to the original field name that is queried, thereby realizing the original data and
  • the accurate docking between the business data enables the docked data to facilitate the insurance company to conduct business processing.
  • steps in the flowchart of FIG. 2 are sequentially displayed as indicated by the arrows, these steps are not necessarily performed in the order indicated by the arrows. Except as explicitly stated herein, the execution of these steps is not strictly limited, and may be performed in other sequences. Moreover, at least some of the steps in FIG. 2 may include a plurality of sub-steps or stages, which are not necessarily performed at the same time, but may be executed at different times, and the order of execution thereof is not necessarily This may be performed in sequence, but may be performed alternately or alternately with other steps or at least a portion of the sub-steps or stages of the other steps.
  • the customer identification may be an organization code, an enterprise name, an identification (ID), a registered account, etc., which can uniquely identify the identity of the customer.
  • the docking configuration table includes multiple field names, and the docking configuration table identifier refers to one or more field names that can uniquely identify the docking configuration table, such as an enterprise name, an organization code, and the like.
  • the server In order to prevent the duplication configuration table identifier corresponding to the multiple docking configuration table from being duplicated, the server establishes a log table in the database.
  • the log configuration table identifies the docking configuration table identifier corresponding to the independent docking configuration table.
  • the server obtains the docking configuration table identifier corresponding to the docking configuration table established for the new client.
  • the docking configuration table identifier corresponding to the docking configuration table established for the new client may be referred to as the current docking configuration table identifier.
  • the server compares the current docking configuration table identifier with each docking configuration table identifier in the log table. If there is a docking configuration table identifier in the log table that is the same as the current docking configuration table identifier, the server marks the current docking configuration table identifier as a duplicate docking configuration table identifier, generates an error prompt, and sends an error prompt to the second terminal. In order to prompt the second terminal to reset the current docking configuration table identifier.
  • the server acquires the customer identifier of the new client, and associates the customer identifier with the current docking configuration table identifier, so that the server is independent according to the foregoing manner.
  • the docking configuration table docks the original data.
  • the method before receiving the data docking request sent by the first terminal, the method further includes: receiving a login request sent by the first terminal, the login request includes a client identifier, and receiving a login request sent by the first terminal, where the login request includes Customer identification; obtaining a corresponding entry configuration table according to the customer identifier, the entry configuration table includes multiple original field names; obtaining the entry page, the entry page includes multiple service field names; and using the correspondence between the original field name and the business field name Enter the page to adjust and return the adjusted entry page to the first terminal.
  • the second terminal can establish an independent entry configuration table for each customer. The second end sends a separate entry configuration table to the server.
  • the independent entry configuration table has a corresponding customer ID. Multiple original field names are recorded in a separate entry configuration table.
  • the original field name is the name of the field that the customer is accustomed to when handling different types of business.
  • the display requirements of the customer for the entry page are also recorded in the separate entry configuration table. For example, the customer enters the display position and display mode of the input page on the entry page for each original field name and its corresponding field value, as shown in Table 5:
  • the first terminal acquires a login request of the client, and sends the login request to the server.
  • the server obtains an independent entry configuration table according to the customer identifier carried in the login request.
  • the server queries the display location and display mode of each original field name and its corresponding field value input box provided by the client in the independent entry configuration table through the SQL statement.
  • the server obtains a corresponding docking configuration table according to the customer identifier.
  • the correspondence between the business field name and the original field name is recorded in the docking configuration table.
  • the server replaces the business field name in the entry page with the corresponding original field name, and adjusts the entry page according to the display mode and display position recorded in the independent entry configuration table.
  • the server returns the adjusted entry page to the first terminal for display.
  • the adjusted entry page displays the input boxes for multiple original field names and their corresponding field values that the customer is accustomed to use.
  • the customer can complete the entry of the original data by using the input method that he is accustomed to.
  • the server finally performs the docking process on the original data
  • the original field names that the customer is accustomed to use are displayed on the first terminal, and the input boxes of the respective original field names and their corresponding field values are used by the client.
  • the entry configuration rule further records an entry rule; after receiving the data docking request sent by the first terminal, the method further includes: performing, according to the entry rule recorded in the entry configuration table, each original field in the original data The field value corresponding to the name is checked; if the verification is passed, the original data is recorded into the pre-established original data table, and the original data table is sent to the first terminal, so that the first terminal confirms the original data.
  • a data docking apparatus including: a receiving module 302, an obtaining module 304, a query module 306, and a recording module 308, wherein:
  • the receiving module 302 is configured to receive a data docking request sent by the first terminal, where the data docking request carries original data, where the original data includes multiple original field names;
  • the querying module 306 is configured to query, in the original data, the corresponding original field name according to the service field name;
  • the data docking device further includes a comparison module and a prompt module.
  • the receiving module 302 is further configured to receive a docking configuration table sent by the second terminal, where the docking configuration table includes a docking configuration table identifier;
  • the obtaining module 304 is further configured to obtain a log table, where the log table includes multiple docking configuration table identifiers;
  • the current docking configuration table identifier is compared with the multiple docking configuration table identifiers in the log table.
  • the prompting module is configured to generate an error prompt if an existing docking configuration table identifier is the same as the current docking configuration table identifier, and an error message is generated. Send to the second terminal.
  • the data docking device further includes an adjustment module.
  • the receiving module 302 is further configured to receive a login request sent by the first terminal, where the login request includes a client identifier, and the obtaining module 304 is further configured to obtain a corresponding entry configuration table according to the client identifier, where the entry configuration table includes multiple original field names;
  • the 304 is further configured to obtain an entry page, where the entry page includes multiple service field names, and an adjustment module is configured to adjust the entry page by using the correspondence between the original field name and the service field name, and return the adjusted entry page to the first page. terminal.
  • a server is provided, as shown in Figure 4, which includes a processor, memory and network interface connected by a system bus.
  • the processor of the server is used to provide computing and control capabilities.
  • the memory of the server includes a non-volatile storage medium and an internal memory.
  • the non-volatile storage medium of the server stores an operating system, computer readable instructions, and a database, the computer readable instructions being executed by the processor to implement a data docking method.
  • the database stores business data tables, docking configuration tables, and raw data.
  • the internal memory of the server provides an environment for the operation of operating systems and computer readable instructions in a non-volatile storage medium.
  • the non-volatile storage medium can be a computer-readable non-volatile storage medium.
  • FIG. 4 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the server to which the solution of the present application is applied.
  • the specific server may include a ratio. More or fewer components are shown in the figures, or some components are combined, or have different component arrangements.
  • one or more computer readable non-volatile storage media having computer readable instructions, when executed by one or more processors, causing one or more processors.
  • the steps in the various method embodiments described above are implemented at the time of execution.

Landscapes

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

Abstract

The present application relates to a data matching method, comprising: receiving a data matching request sent by a first terminal, the data matching request carrying original data, the original data comprising a plurality of original field names; obtaining a matching configuration table, the matching configuration table recording service field names and the corresponding original field names; querying the corresponding original field names in the original data according to the service field names; and recording the service field names corresponding to the original data in a service data table according to the queried original field names.

Description

数据对接方法、装置、服务器和存储介质Data docking method, device, server and storage medium
本申请要求于2017年6月26日提交中国专利局、申请号为2017104966626、发明名称为“数据对接方法、装置、服务器和存储介质”的中国专利申请的优先权,其全部内容通过引用结合在本申请中。The present application claims priority to Chinese Patent Application No. JP-A No. No. No. No. No. No. No. No. No. No. No. No. No. No. In this application.
技术领域Technical field
本申请涉及计算机技术领域,特别是涉及一种数据对接方法、装置、服务器和存储介质。The present application relates to the field of computer technologies, and in particular, to a data docking method, apparatus, server, and storage medium.
背景技术Background technique
目前,保险公司根据客户的委托进行保险、理赔等业务。在保险公司开展相关业务之前,客户从自己的业务系统提取业务数据提供给保险公司。客户提供的业务数据可以称为原始数据。保险公司将原始数据对接至自己的业务系统,以便进行业务处理。不同客户对原始数据的记录方式可以不同。保险公司需要将来自不同客户的采用不同方式记录的原始数据对接至自己的业务系统。如果原始数据的记录方式与保险公司进行业务处理所需的记录方式不同,保险公司无法直接使用原始数据进行业务处理。因此,如何针对不同客户提供的原始数据进行有效对接以使得对接后的数据能够便于进行业务处理成为目前需要解决的一个技术问题。At present, the insurance company conducts insurance, claims and other services according to the client's entrustment. Before the insurance company conducts related business, the customer extracts business data from his business system and provides it to the insurance company. The business data provided by the customer can be referred to as raw data. The insurance company docks the raw data to its own business system for business processing. Different customers can record the raw data differently. Insurers need to interface raw data from different customers in different ways to their business systems. If the original data is recorded in a different way than the insurance company needs to process the business, the insurance company cannot directly use the raw data for business processing. Therefore, how to effectively connect the original data provided by different customers so that the docked data can be easily processed is a technical problem that needs to be solved.
发明内容Summary of the invention
根据本申请公开的各种实施例,提供一种数据对接方法、装置、服务器和存储介质。According to various embodiments disclosed herein, a data docking method, apparatus, server, and storage medium are provided.
一种数据对接方法,包括:A data docking method includes:
接收第一终端发送的数据对接请求,所述数据对接请求携带了原始数据, 所述原始数据包括多个原始字段名;Receiving a data docking request sent by the first terminal, where the data docking request carries original data, where the original data includes multiple original field names;
获取对接配置表,所述对接配置表中记录了业务字段名和对应的原始字段名;Obtaining a docking configuration table, where the service field name and the corresponding original field name are recorded in the docking configuration table;
根据业务字段名在原始数据中查询对应的原始字段名;及Query the corresponding original field name in the original data according to the business field name; and
根据查询到的原始字段名将所述原始数据对应业务字段名记录至业务数据表中。The original data corresponding business field name is recorded into the service data table according to the original field name that is queried.
一种数据对接装置,包括:A data docking device comprising:
接收模块,用于接收第一终端发送的数据对接请求,所述数据对接请求携带了原始数据,所述原始数据包括多个原始字段名;a receiving module, configured to receive a data docking request sent by the first terminal, where the data docking request carries original data, where the original data includes multiple original field names;
获取模块,用于获取对接配置表,所述对接配置表中记录了业务字段名和对应的原始字段名;An obtaining module, configured to obtain a docking configuration table, where the service field name and the corresponding original field name are recorded in the docking configuration table;
查询模块,用于根据业务字段名在原始数据中查询对应的原始字段名;及a query module, configured to query a corresponding original field name in the original data according to the business field name; and
记录模块,用于根据查询到的原始字段名将所述原始数据对应业务字段名记录至业务数据表中。The recording module is configured to record the original data corresponding business field name into the service data table according to the original field name that is queried.
一种服务器,包括存储器和一个或多个处理器,所述存储器中储存有计算机可读指令,所述计算机可读指令被所述处理器执行时,使得所述一个或多个处理器执行以下步骤:A server comprising a memory and one or more processors, the memory storing computer readable instructions, the computer readable instructions being executed by the processor, causing the one or more processors to perform the following step:
接收第一终端发送的数据对接请求,所述数据对接请求携带了原始数据,所述原始数据包括多个原始字段名;Receiving a data docking request sent by the first terminal, where the data docking request carries original data, where the original data includes multiple original field names;
获取对接配置表,所述对接配置表中记录了业务字段名和对应的原始字段名;Obtaining a docking configuration table, where the service field name and the corresponding original field name are recorded in the docking configuration table;
根据业务字段名在原始数据中查询对应的原始字段名;及Query the corresponding original field name in the original data according to the business field name; and
根据查询到的原始字段名将所述原始数据对应业务字段名记录至业务数据表中。The original data corresponding business field name is recorded into the service data table according to the original field name that is queried.
一个或多个存储有计算机可读指令的计算机可读非易失性存储介质,计算机可读指令被一个或多个处理器执行时,使得一个或多个处理器执行以下 步骤:One or more computer readable non-volatile storage media storing computer readable instructions, when executed by one or more processors, cause one or more processors to perform the steps of:
接收第一终端发送的数据对接请求,所述数据对接请求携带了原始数据,所述原始数据包括多个原始字段名;Receiving a data docking request sent by the first terminal, where the data docking request carries original data, where the original data includes multiple original field names;
获取对接配置表,所述对接配置表中记录了业务字段名和对应的原始字段名;Obtaining a docking configuration table, where the service field name and the corresponding original field name are recorded in the docking configuration table;
根据业务字段名在原始数据中查询对应的原始字段名;及Query the corresponding original field name in the original data according to the business field name; and
根据查询到的原始字段名将所述原始数据对应业务字段名记录至业务数据表中。The original data corresponding business field name is recorded into the service data table according to the original field name that is queried.
本申请的一个或多个实施例的细节在下面的附图和描述中提出。本申请的其它特征、目的和优点将从说明书、附图以及权利要求书变得明显。Details of one or more embodiments of the present application are set forth in the accompanying drawings and description below. Other features, objects, and advantages of the invention will be apparent from the description and appended claims.
附图说明DRAWINGS
为了更清楚地说明本申请实施例或现有技术中的技术方案,下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍,显而易见地,下面描述中的附图仅仅是本申请的一些实施例,对于本领域普通技术人员来讲,在不付出创造性劳动的前提下,还可以根据这些附图获得其他的附图。In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the embodiments or the prior art description will be briefly described below. Obviously, the drawings in the following description are only It is a certain embodiment of the present application, and other drawings can be obtained according to the drawings without any creative work for those skilled in the art.
图1为一个实施例中的数据对接方法应用环境图;1 is an application environment diagram of a data docking method in an embodiment;
图2为一个实施例中数据对接方法的流程图;2 is a flow chart of a data docking method in an embodiment;
图3为一个实施例中数据对接装置的框图;Figure 3 is a block diagram of a data docking device in one embodiment;
图4为一个实施例中服务器的框图。Figure 4 is a block diagram of a server in one embodiment.
具体实施方式Detailed ways
为了使本申请的目的、技术方案及优点更加清楚明白,以下结合附图及实施例,对本申请进行进一步详细说明。应当理解,此处描述的具体实施例仅仅用以解释本申请,并不用于限定本申请。In order to make the objects, technical solutions, and advantages of the present application more comprehensible, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It is understood that the specific embodiments described herein are merely illustrative of the application and are not intended to be limiting.
可以理解,本申请所使用的术语“第一”、“第二”等可在本文中用于描述各种元件,但这些元件不受这些术语限制。这些术语仅用于将第一个元件 与另一个元件区分。举例来说,在不脱离本申请的范围的情况下,可以将第一客户端称为第二客户端,且类似地,可将第二客户端称为第一客户端。第一客户端和第二客户端两者都是客户端,但其不是同一客户端。It will be understood that the terms "first", "second" and the like, as used herein, may be used to describe various elements, but these elements are not limited by these terms. These terms are only used to distinguish one element from another. For example, a first client may be referred to as a second client, and similarly, a second client may be referred to as a first client, without departing from the scope of the present application. Both the first client and the second client are clients, but they are not the same client.
本申请实施例中所提供的数据对接方法可以应用于如图1所示的应用环境中。其中,多个第一终端102通过网络与服务器104连接。第二终端106通过网络与服务器104连接。客户通过第一终端102录入原始数据。原始数据包括多个原始字段名。第一终端102将原始数据发送至服务器104。服务器104接收到原始数据后,将原始数据进行对接处理。根据保险公司以及不同客户的业务规范,保险公司的管理人员通过第二终端106预先建立了业务数据表和对接配置表。第二终端106将业务数据表和对接配置表分别发送至服务器104。业务数据表包括多个业务字段名。对接配置表中记录了业务字段名与对应的原始字段名。服务器104在对接配置表中查询与业务数据表中的业务字段名对应的原始字段名,利用该原始字段名在原始数据中查询相同的原始字段名。服务器104在原始数据中查询到的原始字段名可以包括多个。服务器104根据查询到的多个原始字段名,将原始数据对应业务字段名记录至业务数据表中。由此针对不同客户提供的原始数据实现有效对接,以使得对接后的数据能够便于保险公司进行业务处理。The data docking method provided in the embodiment of the present application can be applied to an application environment as shown in FIG. 1. The plurality of first terminals 102 are connected to the server 104 via a network. The second terminal 106 is connected to the server 104 via a network. The customer enters the original data through the first terminal 102. The raw data includes multiple original field names. The first terminal 102 transmits the raw data to the server 104. After receiving the original data, the server 104 performs the docking process on the original data. According to the insurance company and the business specifications of different customers, the management personnel of the insurance company pre-established the service data table and the docking configuration table through the second terminal 106. The second terminal 106 transmits the service data table and the docking configuration table to the server 104, respectively. The business data table includes multiple business field names. The business field name and the corresponding original field name are recorded in the docking configuration table. The server 104 queries the original field name corresponding to the service field name in the service data table in the docking configuration table, and uses the original field name to query the same original field name in the original data. The original field name queried by the server 104 in the original data may include a plurality. The server 104 records the original data corresponding business field name into the service data table according to the plurality of original field names that are queried. Therefore, the original data provided by different customers is effectively docked, so that the docked data can facilitate the insurance company to conduct business processing.
在一个实施例中,如图2所示,提供了一种数据对接方法,以该方法应用于服务器为例进行说明,具体包括以下步骤:In an embodiment, as shown in FIG. 2, a data docking method is provided, which is applied to the server as an example, and specifically includes the following steps:
步骤202,接收第一终端发送的数据对接请求,数据对接请求携带了原始数据,原始数据包括多个原始字段名。Step 202: Receive a data docking request sent by the first terminal, where the data docking request carries original data, where the original data includes multiple original field names.
步骤204,获取对接配置表,对接配置表中记录了业务字段名和对应的原始字段名。Step 204: Obtain a docking configuration table, where the service field name and the corresponding original field name are recorded in the docking configuration table.
服务器上部署有数据库,在数据库中预先存储了对接配置表。对接配置表中记录了业务字段名和原始字段名。其中,业务字段名和一个或多个原始字段名之间具有映射关系。业务字段名可以是服务器从业务数据表中提取得到的。原始字段名可以是服务器从录入配置表中提取得到的。A database is deployed on the server, and a docking configuration table is pre-stored in the database. The business field name and the original field name are recorded in the docking configuration table. Wherein, there is a mapping relationship between the business field name and one or more original field names. The business field name can be obtained by the server from the business data table. The original field name can be extracted from the entry configuration table by the server.
业务数据表是保险公司根据自身的业务处理规范或者参考业务交付系统的业务处理规范建立的数据结构表。例如,在处理理赔业务时,理赔数据需要交付SMIS(人力资源社会保障统计报表系统)进行核实,则参考SMIS使用的字段名建立用于理赔业务的业务数据表。业务数据表可以是一张,也可以是多张,每张业务数据表包括多个业务字段名。The business data table is a data structure table established by the insurance company according to its own business processing specifications or with reference to the business processing specifications of the business delivery system. For example, when processing the claims business, the claims data needs to be delivered to the SMIS (Human Resources Social Security Statistical Reporting System) for verification, and the business data table for the claims business is established with reference to the field names used by the SMIS. The business data table can be one or multiple sheets, and each business data table includes multiple business field names.
录入配置表是保险公司根据不同客户的业务处理规范建立的数据结构表。录入配置表中记录了客户提供的多个原始字段名。其中,原始字段名是客户办理不同类型的业务时习惯使用的字段名。可以理解,原始字段名可以与业务字段名相同。第二终端可以将所有客户提供的多个原始字段名记录到一张共用的录入配置表中,也可以针对每一位客户建立一张独立的录入配置表。当录入配置表为一张时,录入配置表中还记录了所有客户的客户标识。每个客户的客户标识与该客户提供的原始字段名相对应。The entry configuration table is a data structure table established by the insurance company according to the business processing specifications of different customers. Multiple original field names provided by the customer are recorded in the entry configuration table. Among them, the original field name is the field name that the customer is accustomed to when dealing with different types of business. It can be understood that the original field name can be the same as the business field name. The second terminal may record multiple original field names provided by all customers into a common entry configuration table, or may establish a separate entry configuration table for each customer. When the entry configuration table is one, the customer identification of all customers is also recorded in the entry configuration table. Each customer's customer ID corresponds to the original field name provided by the customer.
对接配置表可以是一张共用的对接配置表,也可以是多张独立的对接配置表。共用的对接配置表中记录了业务数据表中全部的业务字段名和每位客户提供的全部或部分原始字段名,便于保险公司的管理人员对对接配置表进行管理。每个业务字段名与一个或多个原始字段名对应,如表一所示:The docking configuration table can be a shared docking configuration table or multiple independent docking configuration tables. The shared docking configuration table records all the service field names in the service data table and all or part of the original field names provided by each customer, so that the management personnel of the insurance company can manage the docking configuration table. Each business field name corresponds to one or more original field names, as shown in Table 1:
表一Table I
Figure PCTCN2018076990-appb-000001
Figure PCTCN2018076990-appb-000001
独立的对接配置表具有对应的客户标识。独立的对接配置表中记录了业务数据表中全部的业务字段名和每位客户提供的全部或部分原始字段名。每个业务字段名与一个原始字段名对应。服务器根据客户标识可以获取到独立 的对接配置表。例如,客户A在进行理赔业务时,使用名字、性别、身份证号、移动电话、参保日期等原始字段名;客户B在进行理赔业务时,使用姓名、Gender(性别)、证件号码、联系方式、参保时间等原始字段名。客户A和客户B分别对应的对接配置表如表二和表三所示:The independent docking configuration table has a corresponding customer identification. The independent docking configuration table records all the business field names in the business data table and all or part of the original field names provided by each customer. Each business field name corresponds to an original field name. The server can obtain a separate docking configuration table based on the customer ID. For example, when customer A conducts claims business, it uses the original field names such as name, gender, ID number, mobile phone, and insured date; when customer B conducts claims business, it uses name, gender, ID number, and contact. The original field name such as the mode and the time of the insurance. The connection configuration table corresponding to customer A and customer B is shown in Table 2 and Table 3:
表二Table II
Figure PCTCN2018076990-appb-000002
Figure PCTCN2018076990-appb-000002
表三Table 3
Figure PCTCN2018076990-appb-000003
Figure PCTCN2018076990-appb-000003
当客户需要进行数据对接时,第一终端获取客户输入的原始数据,利用原始数据生成数据对接请求,将数据对接请求发送至服务器。原始数据包括多个原始字段名及其对应的字段值。例如,上述客户A提供的原始数据如表四所示:When the client needs to perform data docking, the first terminal acquires the original data input by the client, generates a data docking request by using the original data, and sends the data docking request to the server. The raw data includes multiple original field names and their corresponding field values. For example, the raw data provided by Customer A above is shown in Table 4:
表四Table 4
名字first name 性别gender 身份证号identity number 婚姻状况marital status 移动电话mobile phone 参保日期Insured date 就诊时间Treatment time
王某Wang male 421625************421625************ 已婚married 186*****662186*****662 2014-3-12014-3-1 2016-7-92016-7-9
张某Zhang Female 371526************371526************ 未婚unmarried 137*****411137*****411 2015-6-52015-6-5 2017-3-42017-3-4
需要说明的是,有些情况下,客户提供的部分原始字段名不是保险公司进行业务处理所必需的。例如,上述客户A使用的原始字段名“婚姻状况”对于保险公司进行业务处理是不必要的。因而,并非客户提供的每一个原始字段名均需记录到对接配置表中,换句话说,对接配置表中记录了客户提供的全部或部分原始字段名。未记录在对接配置表中的原始字段名不需要进行对接处理。It should be noted that in some cases, some of the original field names provided by the customer are not necessary for the insurance company to conduct business processing. For example, the original field name "marital status" used by the above customer A is unnecessary for the insurance company to conduct business processing. Therefore, not every original field name provided by the customer needs to be recorded in the docking configuration table. In other words, all or part of the original field name provided by the client is recorded in the docking configuration table. The original field names not recorded in the docking configuration table do not need to be docked.
可以理解,为了保证语言的简要性,表一至表四仅示意性的给出部分业务字段名和对应的原始字段名,还可以包括其他业务字段名和原始字段名。表一至表四仅为了帮助对对接配置表和原始数据的理解,表格中具体内容的实际意义可以不作考究。It can be understood that, in order to ensure the simplicity of the language, Tables 1 to 4 only schematically indicate partial service field names and corresponding original field names, and may also include other business field names and original field names. Tables 1 to 4 are only for helping to understand the docking configuration table and the original data. The actual meaning of the specific content in the table may not be studied.
步骤206,根据业务字段名在原始数据中查询对应的原始字段名。Step 206: Query the original original field name in the original data according to the service field name.
步骤208,根据查询到的原始字段名将原始数据对应业务字段名记录至业务数据表中。Step 208: Record the original data corresponding business field name into the service data table according to the original field name that is queried.
服务器通过SQL语句(Structured Query Language,结构化查询语言)在对接配置表中查询与业务数据表中的业务字段名对应的原始字段名,利用该原始字段名在原始数据中查询相同的原始字段名。服务器可以利用共用的对接配置表查询业务数据表中每个业务字段名对应的原始字段名。服务器还可以根据客户标识获取对立的对接配置表,利用独立的对接配置表查询业务数据表中每个业务字段名对应的原始字段名。The server queries the original field name corresponding to the service field name in the service data table in the docking configuration table through a SQL statement (Structured Query Language), and uses the original field name to query the same original field name in the original data. . The server can use the shared docking configuration table to query the original field name corresponding to each service field name in the service data table. The server may also obtain an opposite docking configuration table according to the customer identifier, and query the original field name corresponding to each service field name in the service data table by using an independent docking configuration table.
例如,理赔业务中,保险公司需要用到三张业务数据表,包括参保人表、明细表和账单表。上述客户A需要进行理赔业务时,服务器可以在共用的对接配置表(即表一)中查询三张业务数据表中每个业务字段名对应的原始字段名。根据在表一中查询到的原始字段名,服务器在表四中查询相同的原始字段名,如在表一中查询到业务字段名“参保人姓名”对应的原始字段名为“参保人名字”,继而在表四中查询与“参保人名字”相同的原始字段名。表 四中原始字段名“参保人名字”对应两个字段值:王某和张某。服务器还可以根据客户标识获取独立的对接配置表(即表二),在表二中查询三张业务数据表中每个业务字段名对应的原始字段名。根据在表二中查询到的原始字段名,服务器在表四中查询相同的原始字段名。For example, in the claims business, the insurance company needs to use three business data sheets, including the insured person list, the schedule and the billing statement. When the client A needs to perform the claim service, the server may query the original field name corresponding to each service field name in the three service data tables in the shared docking configuration table (ie, Table 1). According to the original field name queried in Table 1, the server queries the same original field name in Table 4. For example, in Table 1, the original field name corresponding to the business field name "Insured Name" is named "Insured". The name", and then in Table 4, the original field name identical to the "insurance name" is queried. The original field name "insurance name" in Table 4 corresponds to two field values: Wang and Zhang. The server may also obtain an independent docking configuration table (ie, Table 2) according to the customer identifier, and query the original field name corresponding to each service field name in the three service data tables in Table 2. Based on the original field names queried in Table 2, the server queries the same original field name in Table 4.
根据查询到的原始字段名,服务器将原始数据中全部或部分原始字段名对应的字段值记录到对应业务字段名所在的业务数据表中。原始数据可以记录到一张业务数据表中,也可以记录到多张业务数据表中。According to the original field name that is queried, the server records the field value corresponding to all or part of the original field name in the original data to the service data table in which the corresponding service field name is located. Raw data can be recorded in a business data table or in multiple business data tables.
例如,将查询到的原始字段名“参保人名字”对应两个字段值“王某”和“张某”作为业务字段名“参保人姓名”对应的字段值记录到参保人表中;将查询到的原始字段名“就诊时间”对应两个字段值“2016-7-9”和“2017-3-4”作为业务字段名“就诊时间”对应的字段值记录到明细表中。表四中原始字段名“婚姻状况”未记录在对接配置表中,即没有业务字段名与之对应,该原始字段名对应的字段值无需对接到业务数据表中。For example, the original field name "insurance name" corresponding to the two field values "Wang" and "Zhang" are recorded in the insured table as the field value corresponding to the business field name "insurance name". The field value corresponding to the original field name "Visit Time" corresponding to the two field values "2016-7-9" and "2017-3-4" is recorded in the schedule as the field value corresponding to the business field name "Visit Time". The original field name "marital status" in Table 4 is not recorded in the docking configuration table, that is, no business field name corresponds to it, and the field value corresponding to the original field name does not need to be connected to the service data table.
本实施例中,由于对接配置表中记录了业务字段名和对应的原始字段名,由此使得业务字段名与原始字段名具有映射关系。利用该映射关系,可以在原始数据中查询与业务字段名对应的原始字段名,由此可以根据查询到的原始字段名将原始数据对应业务字段名记录至业务数据表中,从而实现了原始数据与业务数据之间的准确对接,能够使得对接后的数据便于保险公司进行业务处理。In this embodiment, since the service field name and the corresponding original field name are recorded in the docking configuration table, the service field name has a mapping relationship with the original field name. By using the mapping relationship, the original field name corresponding to the service field name can be queried in the original data, so that the original data corresponding business field name can be recorded into the service data table according to the original field name that is queried, thereby realizing the original data and The accurate docking between the business data enables the docked data to facilitate the insurance company to conduct business processing.
应该理解的是,虽然图2的流程图中的各个步骤按照箭头的指示依次显示,但是这些步骤并不是必然按照箭头指示的顺序依次执行。除非本文中有明确的说明,这些步骤的执行并没有严格的顺序限制,其可以以其他的顺序执行。而且,图2中的至少一部分步骤可以包括多个子步骤或者多个阶段,这些子步骤或者阶段并不必然是在同一时刻执行完成,而是可以在不同的时刻执行,其执行顺序也不必然是依次进行,而是可以与其他步骤或者其他步骤的子步骤或者阶段的至少一部分轮流或者交替地执行。It should be understood that although the various steps in the flowchart of FIG. 2 are sequentially displayed as indicated by the arrows, these steps are not necessarily performed in the order indicated by the arrows. Except as explicitly stated herein, the execution of these steps is not strictly limited, and may be performed in other sequences. Moreover, at least some of the steps in FIG. 2 may include a plurality of sub-steps or stages, which are not necessarily performed at the same time, but may be executed at different times, and the order of execution thereof is not necessarily This may be performed in sequence, but may be performed alternately or alternately with other steps or at least a portion of the sub-steps or stages of the other steps.
在一个实施例中,在接收第一终端发送的数据对接请求的步骤之前,还 包括:接收第二终端发送的对接配置表,对接配置表包括对接配置表标识;获取日志表,日志表包括多个对接配置表标识;将当前的对接配置表标识与日志表中的多个对接配置表标识进行比较;若存在与当前的对接配置表标识相同的对接配置表标识,则生成错误提示,将错误提示发送至第二终端。In an embodiment, before receiving the data docking request sent by the first terminal, the method further includes: receiving a docking configuration table sent by the second terminal, where the docking configuration table includes a docking configuration table identifier; obtaining a log table, where the log table includes multiple The connection configuration table identifier is compared with the multiple connection configuration table identifiers in the log table; if there is the same docking configuration table identifier as the current docking configuration table identifier, an error prompt is generated, and an error is generated. The prompt is sent to the second terminal.
第二终端可以针对每位客户建立独立的对接配置表。第二种端将独立的对接配置表发送至服务器。独立的对接配置表中记录了业务数据表中全部的业务字段名和每位客户提供的全部或部分原始字段名。每个业务字段名与一个原始字段名对应。独立的对接配置表具有对应的客户标识和对接配置表标识。服务器在客户标识和对接配置表标识之间建立关联,以使得针对每位客户可以查询到对应的对接配置表。可以理解,同一客户对应的客户标识和对接配置表标识可以相同。这里的客户可以是政府机关单位、企业或个人。客户标识可以是组织结构代码、企业名称、客户ID(identification,身份证)、注册账号等能够唯一标识客户身份的信息。对接配置表包括多个字段名,对接配置表标识是指其中一个或多个可以唯一标识该对接配置表的字段名,如企业名称、组织机构代码等。The second terminal can establish an independent docking configuration table for each customer. The second end sends a separate docking configuration table to the server. The independent docking configuration table records all the business field names in the business data table and all or part of the original field names provided by each customer. Each business field name corresponds to an original field name. The independent docking configuration table has a corresponding customer identifier and a docking configuration table identifier. The server establishes an association between the customer identification and the docking configuration table identifier so that the corresponding docking configuration table can be queried for each customer. It can be understood that the customer identifier and the docking configuration table identifier corresponding to the same customer can be the same. The clients here can be government agencies, companies or individuals. The customer identification may be an organization code, an enterprise name, an identification (ID), a registered account, etc., which can uniquely identify the identity of the customer. The docking configuration table includes multiple field names, and the docking configuration table identifier refers to one or more field names that can uniquely identify the docking configuration table, such as an enterprise name, an organization code, and the like.
为了防止多张对接配置表对应的对接配置表标识发生重复,服务器在数据库中建立了日志表。日志表中记录了独立的对接配置表对应的对接配置表标识。In order to prevent the duplication configuration table identifier corresponding to the multiple docking configuration table from being duplicated, the server establishes a log table in the database. The log configuration table identifies the docking configuration table identifier corresponding to the independent docking configuration table.
在新客户进行数据对接之前,服务器获取为新客户建立的对接配置表对应的对接配置表标识。为新客户建立的对接配置表对应的对接配置表标识可以称为当前的对接配置表标识。服务器将当前的对接配置表标识与日志表中每个对接配置表标识进行比较。若在日志表中存在与当前的对接配置表标识相同的对接配置表标识,则服务器将当前的对接配置表标识标记为重复的对接配置表标识,生成错误提示,将错误提示发送至第二终端,以提示第二终端重新设定当前的对接配置表标识。若当前的对接配置表标识与日志表中任意一个对接配置表标识不同,则服务器获取该新客户的客户标识,对客户标识和当前的对接配置表标识进行关联,以使得服务器按照上述方式根据独立 的对接配置表对原始数据进行对接处理。Before the new client performs data docking, the server obtains the docking configuration table identifier corresponding to the docking configuration table established for the new client. The docking configuration table identifier corresponding to the docking configuration table established for the new client may be referred to as the current docking configuration table identifier. The server compares the current docking configuration table identifier with each docking configuration table identifier in the log table. If there is a docking configuration table identifier in the log table that is the same as the current docking configuration table identifier, the server marks the current docking configuration table identifier as a duplicate docking configuration table identifier, generates an error prompt, and sends an error prompt to the second terminal. In order to prompt the second terminal to reset the current docking configuration table identifier. If the current connection configuration table identifier is different from any one of the connection configuration table identifiers in the log table, the server acquires the customer identifier of the new client, and associates the customer identifier with the current docking configuration table identifier, so that the server is independent according to the foregoing manner. The docking configuration table docks the original data.
在一个实施例中,在接收第一终端发送的数据对接请求的步骤之前,还包括:接收第一终端发送的登录请求,登录请求包括客户标识;接收第一终端发送的登录请求,登录请求包括客户标识;根据客户标识获取对应的录入配置表,录入配置表中包括多个原始字段名;获取录入页面,录入页面中包括多个业务字段名;利用原始字段名与业务字段名的对应关系对录入页面进行调整,将调整后的录入页面返回至第一终端。第二终端可以针对每位客户建立独立的录入配置表。第二种端将独立的录入配置表发送至服务器。独立的录入配置表具有对应的客户标识。独立的录入配置表中记录了多个原始字段名。原始字段名是客户办理不同类型业务时习惯使用的字段名。优选地,独立的录入配置表中还记录了客户针对录入页面的显示要求。例如,客户针对每个原始字段名及其对应字段值输入框在录入页面习惯的显示位置和显示方式等,如表五所示:In an embodiment, before receiving the data docking request sent by the first terminal, the method further includes: receiving a login request sent by the first terminal, the login request includes a client identifier, and receiving a login request sent by the first terminal, where the login request includes Customer identification; obtaining a corresponding entry configuration table according to the customer identifier, the entry configuration table includes multiple original field names; obtaining the entry page, the entry page includes multiple service field names; and using the correspondence between the original field name and the business field name Enter the page to adjust and return the adjusted entry page to the first terminal. The second terminal can establish an independent entry configuration table for each customer. The second end sends a separate entry configuration table to the server. The independent entry configuration table has a corresponding customer ID. Multiple original field names are recorded in a separate entry configuration table. The original field name is the name of the field that the customer is accustomed to when handling different types of business. Preferably, the display requirements of the customer for the entry page are also recorded in the separate entry configuration table. For example, the customer enters the display position and display mode of the input page on the entry page for each original field name and its corresponding field value, as shown in Table 5:
表五Table 5
Figure PCTCN2018076990-appb-000004
Figure PCTCN2018076990-appb-000004
多个原始字段名及对应字段值输入框按照预设次序排列在录入页面,如以矩阵形式排列。当多个原始字段名及对应字段值输入框以矩阵形式排列在录入页面时,可以采用行数和列数表示原始字段名及对应字段值输入框在录入页面的显示位置。输入框的显示方式包括文本输入框、下拉框、滚动条等。下拉框中给出多个可选的字段值,如“男”和“女”等。The input fields of the plurality of original field names and corresponding field values are arranged on the entry page in a preset order, such as in a matrix form. When a plurality of original field names and corresponding field value input boxes are arranged in a matrix form on the entry page, the number of rows and the number of columns may be used to indicate the display position of the original field name and the corresponding field value input box on the entry page. The input box is displayed in a text input box, a drop-down box, a scroll bar, and the like. The drop-down box gives multiple optional field values, such as "male" and "female".
当需要进行数据对接时,第一终端获取客户的登录请求,将登录请求发送至服务器。服务器根据登录请求中携带的客户标识获取独立的录入配置表。 服务器通过SQL语句在独立的录入配置表中查询客户提供的每个原始字段名及其对应字段值输入框的显示位置和显示方式。服务器根据客户标识获取对应的对接配置表。对接配置表中记录了业务字段名和原始字段名的对应关系。利用该对应关系,服务器将录入页面中的业务字段名替换为相应的原始字段名,并且按照独立的录入配置表中记录的显示方式和显示位置调整录入页面。服务器将调整后的录入页面返回至第一终端进行展示。调整后的录入页面显示了客户习惯使用的多个原始字段名及其对应字段值的输入框。When data connection is required, the first terminal acquires a login request of the client, and sends the login request to the server. The server obtains an independent entry configuration table according to the customer identifier carried in the login request. The server queries the display location and display mode of each original field name and its corresponding field value input box provided by the client in the independent entry configuration table through the SQL statement. The server obtains a corresponding docking configuration table according to the customer identifier. The correspondence between the business field name and the original field name is recorded in the docking configuration table. Using the correspondence, the server replaces the business field name in the entry page with the corresponding original field name, and adjusts the entry page according to the display mode and display position recorded in the independent entry configuration table. The server returns the adjusted entry page to the first terminal for display. The adjusted entry page displays the input boxes for multiple original field names and their corresponding field values that the customer is accustomed to use.
第一终端接收客户在录入界面录入的每个原始字段名对应的字段值,录入方式包括:文档上传和字段录入。字段录入是指在录入页面显示的输入框内填写。第一终端利用接收到的各个字段值生成数据对接请求,将数据对接请求发送至服务器。服务器按照上述方式对数据对接请求中携带的原始数据进行对接处理。The first terminal receives the field value corresponding to each original field name entered by the customer on the entry interface, and the entry manner includes: document uploading and field entry. Field entry refers to filling in the input box displayed on the entry page. The first terminal generates a data docking request by using the received field values, and sends a data docking request to the server. The server performs the docking process on the original data carried in the data docking request according to the foregoing manner.
本实施例中,客户可以采用自己习惯的录入方式完成原始数据的录入。无论服务器最终对原始数据进行怎样的对接处理,以客户的角度看来,显示在第一终端的均为客户习惯使用的原始字段名,且各个原始字段名及其对应字段值的输入框以客户习惯的位置和方式进行显示,使得录入页面可以进行个性定制,方便客户根据自己的习惯进行原始数据的录入。In this embodiment, the customer can complete the entry of the original data by using the input method that he is accustomed to. Regardless of how the server finally performs the docking process on the original data, from the customer's point of view, the original field names that the customer is accustomed to use are displayed on the first terminal, and the input boxes of the respective original field names and their corresponding field values are used by the client. Customize the location and mode of display, so that the entry page can be customized, so that customers can enter the original data according to their own habits.
在一个实施例中,录入配置表中还记录了录入规则;在接收第一终端发送的数据对接请求的步骤之后,还包括:根据录入配置表中记录的录入规则,对原始数据中各个原始字段名对应的字段值进行校验;若校验通过,则将原始数据记录到预先建立的原始数据表中,将原始数据表发送至第一终端,以使得第一终端对原始数据进行确认。In an embodiment, the entry configuration rule further records an entry rule; after receiving the data docking request sent by the first terminal, the method further includes: performing, according to the entry rule recorded in the entry configuration table, each original field in the original data The field value corresponding to the name is checked; if the verification is passed, the original data is recorded into the pre-established original data table, and the original data table is sent to the first terminal, so that the first terminal confirms the original data.
录入规则包括字段值的录入规则和上传文档的录入规则。其中,字段值的录入规则是对字段值是否必填、字段类型、字段长度等的属性要求,如字段值不能为空,字段类型为字符串,字段长度不超过100位等。上传文档的录入规则包括文档格式、文档大小等,如文档格式为doc、docx或xlsx,文档大小不超过500M等。服务器根据客户标识获取独立的录入配置表,进一 步获取独立的录入配置表中记录的录入规则,对原始数据中各个原始字段名对应的字段值进行校验。如果校验成功,则服务器将原始数据记录到预先建立的原始数据表中。如果校验失败,服务器生成错误提示,将错误提示发送至第一终端,以提示客户按照录入规则录入各个原始字段名对应的字段值。Entry rules include entry rules for field values and entry rules for uploaded documents. The entry rule of the field value is an attribute requirement for the field value, field type, field length, etc., for example, the field value cannot be null, the field type is a string, and the field length does not exceed 100 bits. The entry rules for uploading documents include document format, document size, etc. If the document format is doc, docx or xlsx, the document size does not exceed 500M. The server obtains an independent entry configuration table according to the customer identifier, and further obtains the entry rule recorded in the independent entry configuration table, and verifies the field value corresponding to each original field name in the original data. If the verification is successful, the server records the raw data into a pre-established raw data table. If the verification fails, the server generates an error prompt and sends an error prompt to the first terminal to prompt the customer to enter the field value corresponding to each original field name according to the entry rule.
服务器在数据库中预先存储了原始数据表。原始数据表中包括多个原始字段名。原始字段名是服务器从独立的录入配置表中提取得到的。如果校验通过,则服务器将客户提供的原始数据完整的不做任何转换的记录到原始数据表中,其中包括未记录在独立的对接配置表中的原始字段名及其对应的字段值。服务器将原始数据表发送至第一终端。第一终端对原始数据进行确认。服务器接收第一终端发送的确认结果,按照上述方式对原始数据进行对接处理。原始数据表的设置便于客户追溯原始数据,避免保险公司和客户之间因原始数据不一致产生分歧。The server pre-stores the original data table in the database. The original data table includes multiple original field names. The original field name is obtained by the server from a separate entry configuration table. If the check passes, the server records the original data provided by the client without any conversion into the original data table, including the original field name and its corresponding field value that are not recorded in the independent docking configuration table. The server sends the original data table to the first terminal. The first terminal confirms the original data. The server receives the confirmation result sent by the first terminal, and performs the docking process on the original data according to the foregoing manner. The setting of the original data table allows the customer to trace the original data, avoiding differences between the insurance company and the customer due to inconsistencies in the original data.
在一个实施例中,在根据业务字段名在原始数据中查询对应的原始字段名的步骤之后,还包括:若查询失败,则将查询失败的业务字段名记录至第一临时表中;根据对接配置表查询临时表中的业务字段名对应的原始字段名,将查询到的原始字段名记录至第二临时表中;将第二临时表发送至第一终端,以使得第一终端利用第二临时表补充提供与原始字段名对应的原始数据。In an embodiment, after the step of querying the corresponding original field name in the original data according to the service field name, the method further includes: if the query fails, recording the service field name that fails the query to the first temporary table; The configuration table queries the original field name corresponding to the service field name in the temporary table, records the original field name that is queried to the second temporary table, and sends the second temporary table to the first terminal, so that the first terminal uses the second The temporary table supplement provides raw data corresponding to the original field name.
如果业务数据表中的一个或多个业务字段名在原始数据中查询不到对应的原始字段名,则表示客户遗漏了一项或几项数据,而遗漏的这几项数据是保险公司进行业务处理所必需的。服务器将查询失败的业务字段名记录至第一临时表中。服务器在对接配置表中查询与第一临时表中的业务字段名对应的原始字段名,将查询到的原始字段名记录到第二临时表中。服务器将第二临时表发送至第一终端,以提示第一终端根据第二临时表及时补充遗漏的数据,即补充提供与第二临时表中记录的原始字段名对应的字段值,继而提高数据对接效率。If one or more business field names in the business data table cannot find the corresponding original field name in the original data, it means that the customer missed one or several items of data, and the missing items are the insurance company's business. Required for processing. The server records the business field name of the failed query to the first temporary table. The server queries the original field name corresponding to the service field name in the first temporary table in the docking configuration table, and records the original field name of the query into the second temporary table. The server sends the second temporary table to the first terminal, so that the first terminal promptly replenishes the missing data according to the second temporary table, that is, supplementally provides the field value corresponding to the original field name recorded in the second temporary table, and then increases the data. Docking efficiency.
在一个实施例中,如图3所示,提供了一种数据对接装置,包括:接收模块302、获取模块304、查询模块306和记录模块308,其中:In one embodiment, as shown in FIG. 3, a data docking apparatus is provided, including: a receiving module 302, an obtaining module 304, a query module 306, and a recording module 308, wherein:
接收模块302,用于接收第一终端发送的数据对接请求,数据对接请求携带了原始数据,原始数据包括多个原始字段名;The receiving module 302 is configured to receive a data docking request sent by the first terminal, where the data docking request carries original data, where the original data includes multiple original field names;
获取模块304,用于获取对接配置表,对接配置表中记录了业务字段名和对应的原始字段名;The obtaining module 304 is configured to obtain a docking configuration table, where the service field name and the corresponding original field name are recorded in the docking configuration table;
查询模块306,用于根据业务字段名在原始数据中查询对应的原始字段名;The querying module 306 is configured to query, in the original data, the corresponding original field name according to the service field name;
记录模块308,用于根据查询到的原始字段名将原始数据对应业务字段名记录至业务数据表中。The recording module 308 is configured to record the original data corresponding business field name into the service data table according to the original field name that is queried.
在一个实施例中,数据对接装置还包括比较模块和提示模块。接收模块302还用于接收第二终端发送的对接配置表,对接配置表包括对接配置表标识;获取模块304还用于获取日志表,日志表包括多个对接配置表标识;比较模块,用于将当前的对接配置表标识与日志表中的多个对接配置表标识进行比较;提示模块,用于若存在与当前的对接配置表标识相同的对接配置表标识,则生成错误提示,将错误提示发送至第二终端。In one embodiment, the data docking device further includes a comparison module and a prompt module. The receiving module 302 is further configured to receive a docking configuration table sent by the second terminal, where the docking configuration table includes a docking configuration table identifier; the obtaining module 304 is further configured to obtain a log table, where the log table includes multiple docking configuration table identifiers; The current docking configuration table identifier is compared with the multiple docking configuration table identifiers in the log table. The prompting module is configured to generate an error prompt if an existing docking configuration table identifier is the same as the current docking configuration table identifier, and an error message is generated. Send to the second terminal.
在一个实施例中,数据对接装置还包括调整模块。接收模块302还用于接收第一终端发送的登录请求,登录请求包括客户标识;获取模块304还用于根据客户标识获取对应的录入配置表,录入配置表中包括多个原始字段名;获取模块304还用于获取录入页面,录入页面中包括多个业务字段名;调整模块,用于利用原始字段名与业务字段名的对应关系对录入页面进行调整,将调整后的录入页面返回至第一终端。In one embodiment, the data docking device further includes an adjustment module. The receiving module 302 is further configured to receive a login request sent by the first terminal, where the login request includes a client identifier, and the obtaining module 304 is further configured to obtain a corresponding entry configuration table according to the client identifier, where the entry configuration table includes multiple original field names; The 304 is further configured to obtain an entry page, where the entry page includes multiple service field names, and an adjustment module is configured to adjust the entry page by using the correspondence between the original field name and the service field name, and return the adjusted entry page to the first page. terminal.
在一个实施例中,数据对接装置还包括发送模块。记录模块308还用于若查询失败,则将查询失败的业务字段名记录至第一临时表中;查询模块306还用于根据对接配置表查询临时表中的业务字段名对应的原始字段名;记录模块308还用于将查询到的原始字段名记录至第二临时表中;发送模块,用于将第二临时表发送至第一终端,以使得第一终端利用第二临时表补充提供与原始字段名对应的原始数据。In one embodiment, the data docking device further includes a transmitting module. The recording module 308 is further configured to: if the query fails, record the service field name that fails the query to the first temporary table; the query module 306 is further configured to query the original field name corresponding to the service field name in the temporary table according to the docking configuration table; The recording module 308 is further configured to record the queried original field name into the second temporary table, and send a module, configured to send the second temporary table to the first terminal, so that the first terminal supplements the provision by using the second temporary table. The raw data corresponding to the original field name.
在一个实施例中,提供了一种服务器,如图4所示,该服务器包括通过 系统总线连接的处理器、存储器和网络接口。其中,该服务器的处理器用于提供计算和控制能力。该服务器的存储器包括非易失性存储介质、内存储器。该服务器的非易失性存储介质存储有操作系统、计算机可读指令和数据库,该计算机可读指令被处理器执行时以实现一种数据对接方法。该数据库存储了业务数据表、对接配置表和原始数据。该服务器的内存储器为非易失性存储介质中的操作系统和计算机可读指令的运行提供环境。非易失性存储介质可以是计算机可读非易失性存储介质。该服务器的网络接口用于与外部的终端通过网络连接通信,比如,接收第一终端发送的原始数据以及第二终端发送的对接配置表和业务数据表等。处理器执行计算机可读指令时可以执行以下步骤:接收第一终端发送的数据对接请求,数据对接请求携带了原始数据,原始数据包括多个原始字段名;获取对接配置表,对接配置表中记录了业务字段名和对应的原始字段名;根据业务字段名在原始数据中查询对应的原始字段名;根据查询到的原始字段名将原始数据对应业务字段名记录至业务数据表中。In one embodiment, a server is provided, as shown in Figure 4, which includes a processor, memory and network interface connected by a system bus. The processor of the server is used to provide computing and control capabilities. The memory of the server includes a non-volatile storage medium and an internal memory. The non-volatile storage medium of the server stores an operating system, computer readable instructions, and a database, the computer readable instructions being executed by the processor to implement a data docking method. The database stores business data tables, docking configuration tables, and raw data. The internal memory of the server provides an environment for the operation of operating systems and computer readable instructions in a non-volatile storage medium. The non-volatile storage medium can be a computer-readable non-volatile storage medium. The network interface of the server is used for communicating with an external terminal through a network connection, for example, receiving original data sent by the first terminal, and a docking configuration table and a service data table sent by the second terminal. When the processor executes the computer readable instructions, the following steps may be performed: receiving a data docking request sent by the first terminal, the data docking request carrying the original data, the original data including multiple original field names, obtaining the docking configuration table, and the recording in the docking configuration table The business field name and the corresponding original field name; the corresponding original field name is queried in the original data according to the business field name; and the original data corresponding business field name is recorded in the service data table according to the original field name that is queried.
本领域技术人员可以理解,图4中示出的结构,仅仅是与本申请方案相关的部分结构的框图,并不构成对本申请方案所应用于其上的服务器的限定,具体的服务器可以包括比图中所示更多或更少的部件,或者组合某些部件,或者具有不同的部件布置。It will be understood by those skilled in the art that the structure shown in FIG. 4 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the server to which the solution of the present application is applied. The specific server may include a ratio. More or fewer components are shown in the figures, or some components are combined, or have different component arrangements.
在一个实施例中,提供了一种服务器,包括存储器和一个或多个处理器,存储器中储存有计算机可读指令,计算机可读指令被处理器执行时,使得一个或多个处理器执行时实现上述各个方法实施例中的步骤。In one embodiment, a server is provided comprising a memory and one or more processors having stored therein computer readable instructions that, when executed by a processor, cause one or more processors to execute The steps in the various method embodiments described above are implemented.
在一个实施例中,提供了一个或多个存储有计算机可读指令的计算机可读非易失性存储介质,计算机可读指令被一个或多个处理器执行时,使得一个或多个处理器执行时实现上述各个方法实施例中的步骤。In one embodiment, there is provided one or more computer readable non-volatile storage media having computer readable instructions, when executed by one or more processors, causing one or more processors The steps in the various method embodiments described above are implemented at the time of execution.
本领域普通技术人员可以理解实现上述实施例方法中的全部或部分流程,是可以通过计算机可读指令来指令相关的硬件来完成,计算机可读指令可存储于一非易失性计算机可读取存储介质中,该计算机可读指令在执行时, 可包括如上述各方法的实施例的流程。其中,存储介质可为磁碟、光盘、只读存储记忆体(Read-Only Memory,ROM)等。A person skilled in the art can understand that all or part of the process of implementing the above embodiment method can be completed by computer-readable instructions for instructing related hardware, and the computer readable instructions can be stored in a non-volatile computer readable. In the storage medium, the computer readable instructions, when executed, may include the flow of an embodiment of the methods as described above. The storage medium may be a magnetic disk, an optical disk, a read-only memory (ROM), or the like.
以上实施例的各技术特征可以进行任意的组合,为使描述简洁,未对上述实施例中的各个技术特征所有可能的组合都进行描述,然而,只要这些技术特征的组合不存在矛盾,都应当认为是本说明书记载的范围。The technical features of the above embodiments may be arbitrarily combined. For the sake of brevity of description, all possible combinations of the technical features in the above embodiments are not described. However, as long as there is no contradiction in the combination of these technical features, It is considered to be the range described in this specification.
以上实施例仅表达了本申请的几种实施方式,其描述较为具体和详细,但并不能因此而理解为对发明专利范围的限制。应当指出的是,对于本领域的普通技术人员来说,在不脱离本申请构思的前提下,还可以做出若干变形和改进,这些都属于本申请的保护范围。因此,本申请专利的保护范围应以所附权利要求为准。The above embodiments are merely illustrative of several embodiments of the present application, and the description thereof is more specific and detailed, but is not to be construed as limiting the scope of the invention. It should be noted that a number of variations and modifications may be made by those skilled in the art without departing from the spirit and scope of the present application. Therefore, the scope of the invention should be determined by the appended claims.

Claims (20)

  1. 一种数据对接方法,包括:A data docking method includes:
    接收第一终端发送的数据对接请求,所述数据对接请求携带了原始数据,所述原始数据包括多个原始字段名;Receiving a data docking request sent by the first terminal, where the data docking request carries original data, where the original data includes multiple original field names;
    获取对接配置表,所述对接配置表中记录了业务字段名和对应的原始字段名;Obtaining a docking configuration table, where the service field name and the corresponding original field name are recorded in the docking configuration table;
    根据业务字段名在原始数据中查询对应的原始字段名;及Query the corresponding original field name in the original data according to the business field name; and
    根据查询到的原始字段名将所述原始数据对应业务字段名记录至业务数据表中。The original data corresponding business field name is recorded into the service data table according to the original field name that is queried.
  2. 根据权利要求1所述的方法,其特征在于,在所述接收第一终端发送的数据对接请求的步骤之前,还包括:The method according to claim 1, wherein before the step of receiving the data docking request sent by the first terminal, the method further includes:
    接收第二终端发送的对接配置表,所述对接配置表包括对接配置表标识;Receiving, by the second terminal, a docking configuration table, where the docking configuration table includes a docking configuration table identifier;
    获取日志表,所述日志表包括多个对接配置表标识;Obtaining a log table, where the log table includes multiple docking configuration table identifiers;
    将当前的对接配置表标识与日志表中的多个对接配置表标识进行比较;及Comparing the current docking configuration table identifier with a plurality of docking configuration table identifiers in the log table; and
    若存在与当前的对接配置表标识相同的对接配置表标识,则生成错误提示,将所述错误提示发送至所述第二终端。If there is a docking configuration table identifier that is the same as the current docking configuration table identifier, an error prompt is generated, and the error prompt is sent to the second terminal.
  3. 根据权利要求1所述的方法,其特征在于,在所述接收第一终端发送的数据对接请求的步骤之前,还包括:The method according to claim 1, wherein before the step of receiving the data docking request sent by the first terminal, the method further includes:
    接收所述第一终端发送的登录请求,所述登录请求包括客户标识;Receiving a login request sent by the first terminal, where the login request includes a customer identifier;
    根据客户标识获取对应的录入配置表,所述录入配置表中包括多个原始字段名;Obtaining, according to the customer identifier, a corresponding entry configuration table, where the entry configuration table includes multiple original field names;
    获取录入页面,所述录入页面中包括多个业务字段名;及Obtaining an entry page, the entry page includes a plurality of business field names; and
    利用原始字段名与业务字段名的对应关系对所述录入页面进行调整,将调整后的录入页面返回至第一终端。The input page is adjusted by using the correspondence between the original field name and the business field name, and the adjusted entry page is returned to the first terminal.
  4. 根据权利要求3所述的方法,其特征在于,所述录入配置表中还记录了录入规则;在所述接收第一终端发送的数据对接请求的步骤之后,还包括:The method according to claim 3, wherein the entry configuration table further records an entry rule; after the step of receiving the data docking request sent by the first terminal, the method further includes:
    根据所述录入配置表中记录的录入规则,对所述原始数据中各个原始字段名对应的字段值进行校验;Performing, according to the entry rule recorded in the entry configuration table, a field value corresponding to each original field name in the original data;
    若校验通过,则将所述原始数据记录到预先建立的原始数据表中;及If the verification passes, the raw data is recorded into a pre-established original data table; and
    将所述原始数据表发送至第一终端,以使得第一终端对所述原始数据进行确认。Sending the original data table to the first terminal, so that the first terminal confirms the original data.
  5. 根据权利要求1所述的方法,其特征在于,在所述根据业务字段名在原始数据中查询对应的原始字段名的步骤之后,还包括:The method according to claim 1, wherein after the step of querying the corresponding original field name in the original data according to the service field name, the method further comprises:
    若查询失败,则将查询失败的业务字段名记录至第一临时表中;If the query fails, the business field name that failed the query is recorded in the first temporary table;
    根据对接配置表查询临时表中的业务字段名对应的原始字段名,将查询到的原始字段名记录至第二临时表中;及Querying the original field name corresponding to the service field name in the temporary table according to the docking configuration table, and recording the original field name of the query into the second temporary table;
    将所述第二临时表发送至所述第一终端,以使得所述第一终端利用第二临时表补充提供与所述原始字段名对应的原始数据。And transmitting the second temporary table to the first terminal, so that the first terminal supplements the original data corresponding to the original field name by using the second temporary table.
  6. 一种数据对接装置,其特征在于,所述装置包括:A data docking device, characterized in that the device comprises:
    接收模块,用于接收第一终端发送的数据对接请求,所述数据对接请求携带了原始数据,所述原始数据包括多个原始字段名;a receiving module, configured to receive a data docking request sent by the first terminal, where the data docking request carries original data, where the original data includes multiple original field names;
    获取模块,用于获取对接配置表,所述对接配置表中记录了业务字段名和对应的原始字段名;An obtaining module, configured to obtain a docking configuration table, where the service field name and the corresponding original field name are recorded in the docking configuration table;
    查询模块,用于根据业务字段名在原始数据中查询对应的原始字段名;及a query module, configured to query a corresponding original field name in the original data according to the business field name; and
    记录模块,用于根据查询到的原始字段名将所述原始数据对应业务字段名记录至业务数据表中。The recording module is configured to record the original data corresponding business field name into the service data table according to the original field name that is queried.
  7. 根据权利要求6所述的装置,其特征在于,所述装置还包括比较模块和提示模块;所述接收模块还用于接收第二终端发送的对接配置表,所述对接配置表包括对接配置表标识;所述获取模块还用于获取日志表,所述日志表包括多个对接配置表标识;所述比较模块,用于将当前的对接配置表标识与日志表中的多个对接配置表标识进行比较;及所述提示模块,用于若存在与当前的对接配置表标识相同的对接配置表标识,则生成错误提示,将所述 错误提示发送至所述第二终端。The device according to claim 6, wherein the device further comprises a comparison module and a prompting module; the receiving module is further configured to receive a docking configuration table sent by the second terminal, where the docking configuration table includes a docking configuration table The obtaining module is further configured to obtain a log table, where the log table includes multiple docking configuration table identifiers, and the comparing module is configured to identify the current docking configuration table identifier and multiple docking configuration table identifiers in the log table. And performing the comparison; and the prompting module is configured to generate an error prompt if the same docking configuration table identifier is the same as the current docking configuration table identifier, and send the error prompt to the second terminal.
  8. 根据权利要求6所述的装置,其特征在于,所述装置还包括调整模块;所述接收模块还用于接收所述第一终端发送的登录请求,所述登录请求包括客户标识;所述获取模块还用于根据客户标识获取对应的录入配置表,所述录入配置表中包括多个原始字段名;所述获取模块还用于获取录入页面,所述录入页面中包括多个业务字段名;及所述调整模块,用于利用原始字段名与业务字段名的对应关系对所述录入页面进行调整,将调整后的录入页面返回至第一终端。The device according to claim 6, wherein the device further comprises an adjustment module; the receiving module is further configured to receive a login request sent by the first terminal, where the login request includes a client identifier; The module is further configured to obtain a corresponding entry configuration table according to the customer identifier, where the entry configuration table includes a plurality of original field names; the obtaining module is further configured to obtain an entry page, where the entry page includes multiple service field names; And the adjusting module is configured to adjust the input page by using a correspondence between the original field name and the service field name, and return the adjusted entry page to the first terminal.
  9. 根据权利要求8所述的装置,其特征在于,所述录入配置表中还记录了录入规则;所述装置还包括:The device according to claim 8, wherein the entry configuration table further records an entry rule; the device further includes:
    校验模块,用于根据所述录入配置表中记录的录入规则,对所述原始数据中各个原始字段名对应的字段值进行校验;若校验通过,则将所述原始数据记录到预先建立的原始数据表中;及a verification module, configured to check, according to the entry rule recorded in the entry configuration table, a field value corresponding to each original field name in the original data; if the verification passes, the original data is recorded to a pre- Established in the original data table; and
    发送模块,用于将所述原始数据表发送至第一终端,以使得第一终端对所述原始数据进行确认。And a sending module, configured to send the original data table to the first terminal, so that the first terminal confirms the original data.
  10. 根据权利要求6所述的装置,其特征在于,所述装置还包括发送模块;所述记录模块还用于若查询失败,则将查询失败的业务字段名记录至第一临时表中;所述查询模块还用于根据对接配置表查询临时表中的业务字段名对应的原始字段名;所述记录模块还用于将查询到的原始字段名记录至第二临时表中;及所述发送模块,用于将所述第二临时表发送至所述第一终端,以使得所述第一终端利用第二临时表补充提供与所述原始字段名对应的原始数据。The device according to claim 6, wherein the device further comprises a sending module; the recording module is further configured to: if the query fails, record the service field name that fails the query to the first temporary table; The query module is further configured to query, according to the docking configuration table, an original field name corresponding to the service field name in the temporary table; the recording module is further configured to record the queried original field name into the second temporary table; and the sending module And sending the second temporary table to the first terminal, so that the first terminal supplements the original data corresponding to the original field name by using the second temporary table.
  11. 一种服务器,包括存储器和一个或多个处理器,所述存储器中储存有计算机可读指令,所述计算机可读指令被所述处理器执行时,使得所述一个或多个处理器执行以下步骤:A server comprising a memory and one or more processors, the memory storing computer readable instructions, the computer readable instructions being executed by the processor, causing the one or more processors to perform the following step:
    接收第一终端发送的数据对接请求,所述数据对接请求携带了原始数据,所述原始数据包括多个原始字段名;Receiving a data docking request sent by the first terminal, where the data docking request carries original data, where the original data includes multiple original field names;
    获取对接配置表,所述对接配置表中记录了业务字段名和对应的原始字段名;Obtaining a docking configuration table, where the service field name and the corresponding original field name are recorded in the docking configuration table;
    根据业务字段名在原始数据中查询对应的原始字段名;及Query the corresponding original field name in the original data according to the business field name; and
    根据查询到的原始字段名将所述原始数据对应业务字段名记录至业务数据表中。The original data corresponding business field name is recorded into the service data table according to the original field name that is queried.
  12. 根据权利要求11所述的服务器,其特征在于,所述计算机可读指令被所述处理器执行时,使得所述一个或多个处理器还执行以下步骤:The server of claim 11 wherein said computer readable instructions are executed by said processor such that said one or more processors further perform the following steps:
    接收第二终端发送的对接配置表,所述对接配置表包括对接配置表标识;Receiving, by the second terminal, a docking configuration table, where the docking configuration table includes a docking configuration table identifier;
    获取日志表,所述日志表包括多个对接配置表标识;Obtaining a log table, where the log table includes multiple docking configuration table identifiers;
    将当前的对接配置表标识与日志表中的多个对接配置表标识进行比较;及Comparing the current docking configuration table identifier with a plurality of docking configuration table identifiers in the log table; and
    若存在与当前的对接配置表标识相同的对接配置表标识,则生成错误提示,将所述错误提示发送至所述第二终端。If there is a docking configuration table identifier that is the same as the current docking configuration table identifier, an error prompt is generated, and the error prompt is sent to the second terminal.
  13. 根据权利要求11所述的服务器,其特征在于,所述计算机可读指令被所述处理器执行时,使得所述一个或多个处理器还执行以下步骤:The server of claim 11 wherein said computer readable instructions are executed by said processor such that said one or more processors further perform the following steps:
    接收所述第一终端发送的登录请求,所述登录请求包括客户标识;Receiving a login request sent by the first terminal, where the login request includes a customer identifier;
    根据客户标识获取对应的录入配置表,所述录入配置表中包括多个原始字段名;Obtaining, according to the customer identifier, a corresponding entry configuration table, where the entry configuration table includes multiple original field names;
    获取录入页面,所述录入页面中包括多个业务字段名;及Obtaining an entry page, the entry page includes a plurality of business field names; and
    利用原始字段名与业务字段名的对应关系对所述录入页面进行调整,将调整后的录入页面返回至第一终端。The input page is adjusted by using the correspondence between the original field name and the business field name, and the adjusted entry page is returned to the first terminal.
  14. 根据权利要求13所述的服务器,其特征在于,所述计算机可读指令被所述处理器执行时,使得所述一个或多个处理器还执行以下步骤:The server of claim 13 wherein said computer readable instructions are executed by said processor such that said one or more processors further perform the steps of:
    根据所述录入配置表中记录的录入规则,对所述原始数据中各个原始字段名对应的字段值进行校验;Performing, according to the entry rule recorded in the entry configuration table, a field value corresponding to each original field name in the original data;
    若校验通过,则将所述原始数据记录到预先建立的原始数据表中;及If the verification passes, the raw data is recorded into a pre-established original data table; and
    将所述原始数据表发送至第一终端,以使得第一终端对所述原始数据进 行确认。The raw data table is sent to the first terminal such that the first terminal confirms the original data.
  15. 根据权利要求11-14任一项所述的服务器,其特征在于,所述计算机可读指令被所述处理器执行时,使得所述一个或多个处理器还执行以下步骤:A server according to any of claims 11-14, wherein the computer readable instructions are executed by the processor such that the one or more processors further perform the following steps:
    若查询失败,则将查询失败的业务字段名记录至第一临时表中;If the query fails, the business field name that failed the query is recorded in the first temporary table;
    根据对接配置表查询临时表中的业务字段名对应的原始字段名,将查询到的原始字段名记录至第二临时表中;及Querying the original field name corresponding to the service field name in the temporary table according to the docking configuration table, and recording the original field name of the query into the second temporary table;
    将所述第二临时表发送至所述第一终端,以使得所述第一终端利用第二临时表补充提供与所述原始字段名对应的原始数据。And transmitting the second temporary table to the first terminal, so that the first terminal supplements the original data corresponding to the original field name by using the second temporary table.
  16. 一个或多个存储有计算机可读指令的计算机可读非易失性存储介质,所述计算机可读指令被一个或多个处理器执行时,使得一个或多个处理器执行以下步骤:One or more computer readable non-volatile storage media storing computer readable instructions, when executed by one or more processors, cause one or more processors to perform the steps of:
    接收第一终端发送的数据对接请求,所述数据对接请求携带了原始数据,所述原始数据包括多个原始字段名;Receiving a data docking request sent by the first terminal, where the data docking request carries original data, where the original data includes multiple original field names;
    获取对接配置表,所述对接配置表中记录了业务字段名和对应的原始字段名;Obtaining a docking configuration table, where the service field name and the corresponding original field name are recorded in the docking configuration table;
    根据业务字段名在原始数据中查询对应的原始字段名;及Query the corresponding original field name in the original data according to the business field name; and
    根据查询到的原始字段名将所述原始数据对应业务字段名记录至业务数据表中。The original data corresponding business field name is recorded into the service data table according to the original field name that is queried.
  17. 根据权利要求16所述的存储介质,其特征在于,所述计算机可读指令被一个或多个处理器执行时,使得一个或多个处理器还执行以下步骤:The storage medium of claim 16 wherein the computer readable instructions are executed by one or more processors such that the one or more processors further perform the steps of:
    接收第二终端发送的对接配置表,所述对接配置表包括对接配置表标识;Receiving, by the second terminal, a docking configuration table, where the docking configuration table includes a docking configuration table identifier;
    获取日志表,所述日志表包括多个对接配置表标识;Obtaining a log table, where the log table includes multiple docking configuration table identifiers;
    将当前的对接配置表标识与日志表中的多个对接配置表标识进行比较;及Comparing the current docking configuration table identifier with a plurality of docking configuration table identifiers in the log table; and
    若存在与当前的对接配置表标识相同的对接配置表标识,则生成错误提示,将所述错误提示发送至所述第二终端。If there is a docking configuration table identifier that is the same as the current docking configuration table identifier, an error prompt is generated, and the error prompt is sent to the second terminal.
  18. 根据权利要求16所述的存储介质,其特征在于,所述计算机可读指令被一个或多个处理器执行时,使得一个或多个处理器还执行以下步骤:The storage medium of claim 16 wherein the computer readable instructions are executed by one or more processors such that the one or more processors further perform the steps of:
    接收所述第一终端发送的登录请求,所述登录请求包括客户标识;Receiving a login request sent by the first terminal, where the login request includes a customer identifier;
    根据客户标识获取对应的录入配置表,所述录入配置表中包括多个原始字段名;Obtaining, according to the customer identifier, a corresponding entry configuration table, where the entry configuration table includes multiple original field names;
    获取录入页面,所述录入页面中包括多个业务字段名;及Obtaining an entry page, the entry page includes a plurality of business field names; and
    利用原始字段名与业务字段名的对应关系对所述录入页面进行调整,将调整后的录入页面返回至第一终端。The input page is adjusted by using the correspondence between the original field name and the business field name, and the adjusted entry page is returned to the first terminal.
  19. 根据权利要求18所述的存储介质,其特征在于,所述计算机可读指令被一个或多个处理器执行时,使得一个或多个处理器还执行以下步骤:The storage medium of claim 18, wherein the computer readable instructions are executed by one or more processors such that the one or more processors further perform the following steps:
    根据所述录入配置表中记录的录入规则,对所述原始数据中各个原始字段名对应的字段值进行校验;Performing, according to the entry rule recorded in the entry configuration table, a field value corresponding to each original field name in the original data;
    若校验通过,则将所述原始数据记录到预先建立的原始数据表中;及If the verification passes, the raw data is recorded into a pre-established original data table; and
    将所述原始数据表发送至第一终端,以使得第一终端对所述原始数据进行确认。Sending the original data table to the first terminal, so that the first terminal confirms the original data.
  20. 根据权利要求16-19任一项所述的存储介质,其特征在于,所述计算机可读指令被一个或多个处理器执行时,使得一个或多个处理器还执行以下步骤:A storage medium according to any one of claims 16 to 19, wherein the computer readable instructions are executed by one or more processors such that the one or more processors further perform the following steps:
    若查询失败,则将查询失败的业务字段名记录至第一临时表中;If the query fails, the business field name that failed the query is recorded in the first temporary table;
    根据对接配置表查询临时表中的业务字段名对应的原始字段名,将查询到的原始字段名记录至第二临时表中;及Querying the original field name corresponding to the service field name in the temporary table according to the docking configuration table, and recording the original field name of the query into the second temporary table;
    将所述第二临时表发送至所述第一终端,以使得所述第一终端利用第二临时表补充提供与所述原始字段名对应的原始数据。And transmitting the second temporary table to the first terminal, so that the first terminal supplements the original data corresponding to the original field name by using the second temporary table.
PCT/CN2018/076990 2017-06-26 2018-02-23 Data matching method and apparatus, server, and storage medium WO2019000984A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201710496662.6A CN107679057B (en) 2017-06-26 2017-06-26 Data interconnection method, device, server and storage medium
CN201710496662.6 2017-06-26

Publications (1)

Publication Number Publication Date
WO2019000984A1 true WO2019000984A1 (en) 2019-01-03

Family

ID=61133318

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/076990 WO2019000984A1 (en) 2017-06-26 2018-02-23 Data matching method and apparatus, server, and storage medium

Country Status (2)

Country Link
CN (1) CN107679057B (en)
WO (1) WO2019000984A1 (en)

Families Citing this family (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107679057B (en) * 2017-06-26 2019-11-05 平安科技(深圳)有限公司 Data interconnection method, device, server and storage medium
CN108399574B (en) * 2018-02-28 2021-09-28 泰康保险集团股份有限公司 Claim data acquisition method, butt-joint claim subsystem, medium and electronic equipment
CN108647279A (en) * 2018-05-03 2018-10-12 山东浪潮通软信息科技有限公司 Sheet disposal method, apparatus, medium and storage control based on field multiplexing
CN108629050B (en) * 2018-05-16 2023-06-30 中国平安人寿保险股份有限公司 Service data adjustment method, device, computer equipment and storage medium
CN109086360A (en) * 2018-07-19 2018-12-25 北京合思信息技术有限公司 Data interconnection method between support enterprise in multiple heterogeneous system platforms
CN109189394B (en) * 2018-08-02 2021-11-16 浪潮通用软件有限公司 Method for self-adapting to grain situation data structure of domestic mainstream manufacturer
CN109325041B (en) * 2018-08-14 2023-11-21 中国平安人寿保险股份有限公司 Service data processing method, device, computer equipment and storage medium
CN109814856B (en) * 2019-01-17 2022-04-15 平安科技(深圳)有限公司 Data entry method, device, terminal and computer readable storage medium
CN110297823A (en) * 2019-05-22 2019-10-01 深圳壹账通智能科技有限公司 Field management method, device, computer equipment and storage medium
CN110569298B (en) * 2019-09-12 2023-03-24 成都中科大旗软件股份有限公司 Data docking and visualization method and system
CN111104191B (en) * 2019-12-17 2024-04-02 深圳前海环融联易信息科技服务有限公司 Interface docking method, device, computer equipment and storage medium
CN111274300B (en) * 2020-01-19 2021-10-08 上海申昆混凝土集团有限公司 Production and detection data docking method, system and computer-readable storage medium

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103092996A (en) * 2013-02-21 2013-05-08 用友软件股份有限公司 Document data acquisition device and document data acquisition method
CN103927353A (en) * 2014-04-10 2014-07-16 北京网秦天下科技有限公司 Method and device for generating service tables
CN106326352A (en) * 2016-08-08 2017-01-11 歌尔股份有限公司 Universal interface design method and system in butt joint with plurality of service systems
CN106528831A (en) * 2016-11-22 2017-03-22 泰康保险集团股份有限公司 Data pushing method and system
CN107679057A (en) * 2017-06-26 2018-02-09 平安科技(深圳)有限公司 Data docking calculation, device, server and storage medium

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103092996A (en) * 2013-02-21 2013-05-08 用友软件股份有限公司 Document data acquisition device and document data acquisition method
CN103927353A (en) * 2014-04-10 2014-07-16 北京网秦天下科技有限公司 Method and device for generating service tables
CN106326352A (en) * 2016-08-08 2017-01-11 歌尔股份有限公司 Universal interface design method and system in butt joint with plurality of service systems
CN106528831A (en) * 2016-11-22 2017-03-22 泰康保险集团股份有限公司 Data pushing method and system
CN107679057A (en) * 2017-06-26 2018-02-09 平安科技(深圳)有限公司 Data docking calculation, device, server and storage medium

Also Published As

Publication number Publication date
CN107679057B (en) 2019-11-05
CN107679057A (en) 2018-02-09

Similar Documents

Publication Publication Date Title
WO2019000984A1 (en) Data matching method and apparatus, server, and storage medium
WO2019200756A1 (en) Data examination and approval method and apparatus, computer device and storage medium
WO2019214080A1 (en) Approval information processing method and apparatus, computer device, and storage medium
WO2019134340A1 (en) Salary calculation method, application server, and computer readable storage medium
US20220319719A1 (en) Managed medical information exchange
WO2019019744A1 (en) Method and apparatus for recognizing claim settlement flow, server and storage medium
US9053112B2 (en) Automated data validation
US9998450B2 (en) Automatically generating certification documents
CN110692070A (en) System and method for automated batch user registration across both content management systems and any software applications embedded therein
WO2016144680A1 (en) Methods and systems for common key services
US11934778B2 (en) Generating sentiment analysis of content
US11269856B2 (en) Methods, apparatuses, and systems for ingesting and consuming data utilizing a trading partner manager
US20140122734A1 (en) Method and apparatus for flexibly converting and routing data between disparate systems
US20200126007A1 (en) Core process framework for integrating disparate applications
US11062239B2 (en) Structuring computer-mediated communication and determining relevant case type
US20180358116A1 (en) Dynamic data exchange platform for emergency medical services
WO2020215542A1 (en) Information notification method and device, computer apparatus, and storage medium
US9906536B1 (en) Data reporting - process integration tool
CA3073199A1 (en) Computer based learning system for analyzing agreements
CN111681745B (en) Data processing method and device
EP3208758A1 (en) Systems and methods for electronic mail communication based data management
CN114003414B (en) Service return visit processing method and device, computer equipment and storage medium
WO2021057695A1 (en) Information importing method and apparatus
US11368452B2 (en) Job analytics aggregation tool
US10515341B2 (en) Computer communication network for routing communications based on identified information clusters

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: 18824794

Country of ref document: EP

Kind code of ref document: A1