CN116628079A - Data synchronization method, device, storage medium and computer equipment of business system - Google Patents

Data synchronization method, device, storage medium and computer equipment of business system Download PDF

Info

Publication number
CN116628079A
CN116628079A CN202310298942.1A CN202310298942A CN116628079A CN 116628079 A CN116628079 A CN 116628079A CN 202310298942 A CN202310298942 A CN 202310298942A CN 116628079 A CN116628079 A CN 116628079A
Authority
CN
China
Prior art keywords
data
business
field value
source
value
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310298942.1A
Other languages
Chinese (zh)
Inventor
阮丽丽
张宏伟
刘火荣
冷志辉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Yuanguang Software Co Ltd
Original Assignee
Yuanguang Software Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Yuanguang Software Co Ltd filed Critical Yuanguang Software Co Ltd
Priority to CN202310298942.1A priority Critical patent/CN116628079A/en
Publication of CN116628079A publication Critical patent/CN116628079A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; 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/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; 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/242Query formulation
    • G06F16/2428Query predicate definition using graphical user interfaces, including menus and forms
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/95Retrieval from the web
    • G06F16/953Querying, e.g. by the use of web search engines
    • G06F16/9535Search customisation based on user profiles and personalisation
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00Network arrangements or protocols for supporting network services or applications
    • H04L67/50Network services
    • H04L67/55Push-based network services
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Computing Systems (AREA)
  • Software Systems (AREA)
  • Human Computer Interaction (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Signal Processing (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The embodiment of the application discloses a data synchronization method and device of a service system, a storage medium and computer equipment, and relates to the field of finance. The application filters at least one piece of source service data to be synchronized in the source service system based on the synchronization page, then queries the matched target service field value in the target service system according to the source service field value in the source service data, maps the target service field value by the source service parameter value related to the source service field value if the source service field value is queried, fills the source service data and the target service data into the data table of the synchronization page after mapping, and then executes the data synchronization operation, thereby improving the efficiency and the flexibility of the data synchronization.

Description

业务系统的数据同步方法、装置、存储介质及计算机设备Data synchronization method, device, storage medium and computer equipment of business system

技术领域technical field

本申请涉及财务领域,尤其涉及一种业务系统的数据同步方法、装置、存储介质及计算机设备。The present application relates to the financial field, in particular to a data synchronization method, device, storage medium and computer equipment for a business system.

背景技术Background technique

随着企业信息化程度的提升,通常会部署多个不同的业务系统,以实现不同的业务管理需求。在实际应用过程中经常会涉及两个业务系统之间的数据同步,例如:对两个财务系统中的财务报表进行数据同步,目前对两个业务系统进行数据同步的方法一般为:将业务系统中的数据报表采用复制粘贴的方式进行手动同步,操作效率不高;或采用固定的运算公式对固定的字段进行数据同步,灵活程度不高,无法满足各种不同的应用场景。With the improvement of enterprise informatization, multiple different business systems are usually deployed to meet different business management requirements. In the actual application process, data synchronization between two business systems is often involved. For example: data synchronization of financial statements in two financial systems. At present, the method of data synchronization between two business systems is generally: the business system The data reports in the report are manually synchronized by copying and pasting, and the operation efficiency is not high; or the fixed calculation formula is used to synchronize the data of the fixed fields, which is not flexible enough to meet various application scenarios.

发明内容Contents of the invention

本申请实施例提供了业务系统的数据同步方法、装置、存储介质及计算机设备,可以解决现有技术中业务系统的数据同步效率不高和灵活性较差的问题。所述技术方案如下:The embodiment of the present application provides a data synchronization method, device, storage medium and computer equipment of a business system, which can solve the problems of low efficiency and poor flexibility of data synchronization of a business system in the prior art. Described technical scheme is as follows:

第一方面,本申请实施例提供了一种业务系统的数据同步方法,所述方法包括:In the first aspect, the embodiment of the present application provides a data synchronization method of a business system, the method comprising:

通过显示单元显示同步页面;其中,所述同步页面设置数据筛选控件和数据表;A synchronous page is displayed by the display unit; wherein, the synchronous page is set with a data filtering control and a data table;

根据用户对所述数据筛选控件的输入操作确定数据筛选条件;determining the data filtering condition according to the user's input operation on the data filtering control;

根据所述数据筛选条件在源业务系统中过滤出至少一条源业务数据,以及过滤出的至少一条源业务数据填充到所述数据表的第一区域;其中,所述源业务数据由源业务字段值和源业务参数值组成;Filter out at least one piece of source business data in the source business system according to the data filtering conditions, and fill the filtered at least one piece of source business data into the first area of the data table; wherein, the source business data consists of the source business field Value and source business parameter value;

若根据所述源业务字段值在目标业务系统匹配到对应的目标业务字段值,将所述源业务字段值关联的源业务参数值与所述目标业务字段值进行映射,映射后作为所述目标业务字段值的目标业务参数值;If the corresponding target business field value is matched in the target business system according to the source business field value, map the source business parameter value associated with the source business field value with the target business field value, and use the mapping as the target The target business parameter value of the business field value;

将映射成功的目标业务数据填充到所述数据表的第二区域,以及将目标业务参数值同步到所述目标业务系统中;其中,所述目标业务数据由目标业务字段值和目标业务参数值组成。Filling successfully mapped target business data into the second area of the data table, and synchronizing target business parameter values into the target business system; wherein, the target business data consists of target business field values and target business parameter values composition.

第二方面,本申请实施例提供了一种业务系统的数据同步装置,所述装置包括:In the second aspect, the embodiment of the present application provides a data synchronization device for a business system, the device comprising:

推送单元,用于通过显示单元显示同步页面;其中,所述同步页面设置数据筛选控件和数据表;A push unit, configured to display a synchronization page through a display unit; wherein, the synchronization page is provided with a data filtering control and a data table;

确定单元,用于根据用户对所述数据筛选控件的输入操作确定数据筛选条件;A determining unit, configured to determine data filtering conditions according to user input operations on the data filtering control;

过滤单元,用于根据所述数据筛选条件在源业务系统中过滤出至少一条源业务数据,以及过滤出的至少一条源业务数据填充到所述数据表的第一区域;其中,所述源业务数据由源业务字段值和源业务参数值组成;A filtering unit, configured to filter out at least one piece of source business data in the source business system according to the data filtering condition, and fill the filtered at least one piece of source business data into the first area of the data table; wherein, the source business Data consists of source business field values and source business parameter values;

映射单元,用于若根据所述源业务字段值在目标业务系统匹配到对应的目标业务字段值,将所述源业务字段值关联的源业务参数值与所述目标业务字段值进行映射,映射后作为所述目标业务字段值的目标业务参数值;The mapping unit is configured to map the source business parameter value associated with the source business field value with the target business field value if the target business field value is matched to the corresponding target business field value according to the source business field value, and map Then as the target business parameter value of the target business field value;

同步单元,用于将映射成功的目标业务数据填充到所述数据表的第二区域,以及将目标业务参数值同步到所述目标业务系统中;其中,所述目标业务数据由目标业务字段值和目标业务参数值组成。A synchronization unit, configured to fill the successfully mapped target business data into the second area of the data table, and synchronize target business parameter values into the target business system; wherein, the target business data is determined by the target business field value and target business parameter values.

第三方面,本申请实施例提供一种计算机存储介质,所述计算机存储介质存储有多条指令,所述指令适于由处理器加载并执行上述的方法步骤。In a third aspect, an embodiment of the present application provides a computer storage medium, where a plurality of instructions are stored in the computer storage medium, and the instructions are adapted to be loaded by a processor and execute the above method steps.

第四方面,本申请实施例提供一种计算机设备,可包括:处理器和存储器;其中,所述存储器存储有计算机程序,所述计算机程序适于由所述处理器加载并执行上述的方法步骤。In a fourth aspect, an embodiment of the present application provides a computer device, which may include: a processor and a memory; wherein, the memory stores a computer program, and the computer program is adapted to be loaded by the processor and execute the above-mentioned method steps .

本申请一些实施例提供的技术方案带来的有益效果至少包括:The beneficial effects brought by the technical solutions provided by some embodiments of the present application at least include:

基于同步页面在源业务系统中过滤出待同步的至少一条源业务数据,然后根据源业务数据中的源业务字段值在目标业务系统中查询匹配的目标业务字段值,若查询到,将源业务字段值关联的源业务参数值对该目标业务字段值进行映射,映射后将源业务数据和目标业务数据填充到同步页面的数据表中,然后执行数据同步操作。这样用户可以根据实际需求灵活的选择待同步的源业务数据,提升数据同步的灵活性,同步页面上展示待同步的字段值和映射关系,便于用户准确掌握同步的字段值和映射关系是否准确。通过自动匹配的方式查询在目标业务系统中查询对应的目标业务字段值,减少手动操作的步骤,提升数据同步的效率。Based on the synchronization page, at least one piece of source business data to be synchronized is filtered out in the source business system, and then the matching target business field value is queried in the target business system according to the source business field value in the source business data. If found, the source business The source business parameter value associated with the field value is mapped to the target business field value. After mapping, the source business data and target business data are filled into the data table on the synchronization page, and then the data synchronization operation is performed. In this way, users can flexibly select the source business data to be synchronized according to actual needs, improving the flexibility of data synchronization, and displaying the field values and mapping relationships to be synchronized on the synchronization page, so that users can accurately grasp whether the field values and mapping relationships to be synchronized are accurate. Query the corresponding target business field value in the target business system through automatic matching, reduce the steps of manual operation, and improve the efficiency of data synchronization.

附图说明Description of drawings

为了更清楚地说明本申请实施例或现有技术中的技术方案,下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍,显而易见地,下面描述中的附图仅仅是本申请的一些实施例,对于本领域普通技术人员来讲,在不付出创造性劳动的前提下,还可以根据这些附图获得其它的附图。In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only These are some embodiments of the present application. Those skilled in the art can also obtain other drawings based on these drawings without creative work.

图1是本申请实施例提供的网络架构示意图;FIG. 1 is a schematic diagram of a network architecture provided by an embodiment of the present application;

图2是本申请实施例提供的业务系统的数据同步方法的流程示意图;Fig. 2 is a schematic flow chart of the data synchronization method of the business system provided by the embodiment of the present application;

图3是本申请实施例提供的同步页面的示意图;FIG. 3 is a schematic diagram of a synchronization page provided by an embodiment of the present application;

图4是本申请实施例提供的配置页面的示意图;Fig. 4 is a schematic diagram of a configuration page provided by an embodiment of the present application;

图5是本申请提供的一种业务系统的数据同步装置的结构示意图;Fig. 5 is a schematic structural diagram of a data synchronization device of a service system provided by the present application;

图6是本申请提供的一种计算机设备的结构示意图。Fig. 6 is a schematic structural diagram of a computer device provided by the present application.

具体实施方式Detailed ways

为使本申请的目的、技术方案和优点更加清楚,下面将结合附图对本申请实施例方式作进一步地详细描述。In order to make the purpose, technical solution and advantages of the present application clearer, the embodiments of the present application will be further described in detail below in conjunction with the accompanying drawings.

需要说明的是,本申请提供的业务系统的数据同步方法一般由计算机设备执行,相应的,业务系统的数据同步装置一般设置于计算机设备中。It should be noted that the data synchronization method of the business system provided in this application is generally executed by computer equipment, and correspondingly, the data synchronization device of the business system is generally set in the computer equipment.

图1示出了可以应用于本申请的业务系统的数据同步方法或业务系统的数据同步装置的示例性系统架构。Fig. 1 shows an exemplary system architecture that can be applied to the data synchronization method of the business system or the data synchronization device of the business system of the present application.

如图1所示,系统架构可以包括:计算机设备101和服务器102。计算机设备101和服务器102之间可以通过网络进行通信,网络用于上述各个单元之间提供通信链路的介质。网络可以包括各种类型的有线通信链路或无线通信链路,例如:有线通信链路包括光纤、双绞线或同轴电缆等,无线通信链路包括蓝牙通信链路、无线保真(WIreless-FIdelity,Wi-Fi)通信链路或微波通信链路等。As shown in FIG. 1 , the system architecture may include: a computer device 101 and a server 102 . The computer device 101 and the server 102 can communicate through a network, and the network is used as a medium for providing communication links between the above-mentioned units. The network can include various types of wired communication links or wireless communication links, for example: wired communication links include optical fiber, twisted pair or coaxial cables, etc., wireless communication links include Bluetooth communication links, wireless fidelity (WIreless -FIdelity, Wi-Fi) communication link or microwave communication link, etc.

其中,服务器102为银行部署有至少两个业务系统,例如:源业务系统和目标业务系统,业务系统可以是财务系统、仓储管理系统或销售系统等,进一步的,不同的业务系统也可以部署在不同的服务器上,本申请不作限制。用户通过计算机设备101与服务器102中部署的各个业务系统进行交互,将一个业务系统中的数据同步到另一个业务系统,例如:将一个财务系统中的成本报表同步到另一个业务系统的成本报表。Wherein, the server 102 deploys at least two business systems for the bank, for example: a source business system and a target business system, and the business systems can be financial systems, warehouse management systems or sales systems, etc. Further, different business systems can also be deployed in On different servers, this application is not limited. The user interacts with each business system deployed in the server 102 through the computer device 101, and synchronizes the data in one business system to another business system, for example: synchronizing the cost report in one financial system to the cost report of another business system .

需要说明的是,计算机设备101和服务器102可以是硬件,也可以是软件。当计算机设备101和服务器102为硬件时,可以实现成多个服务器组成的分布式服务器集群,也可以实现成单个服务器。当计算机设备101和服务器102为软件时,可以实现成多个软件或软件模块(例如用来提供分布式服务),也可以实现成单个软件或软件模块,在此不做具体限定。It should be noted that the computer device 101 and the server 102 may be hardware or software. When the computer device 101 and the server 102 are hardware, they can be implemented as a distributed server cluster composed of multiple servers, or as a single server. When the computer device 101 and the server 102 are software, they can be implemented as multiple software or software modules (for example, for providing distributed services), or can be implemented as a single software or software module, which is not specifically limited here.

本申请的计算机设备上可以安装有各种通信客户端应用,例如:视频录制应用、视频播放应用、语音交互应用、搜索类应用、即时通信工具、邮箱客户端、社交平台软件等。Various communication client applications can be installed on the computer equipment of this application, such as: video recording applications, video playback applications, voice interaction applications, search applications, instant messaging tools, email clients, social platform software, etc.

计算机设备可以是硬件,也可以是软件。当计算机设备为硬件时,可以是具有显示屏的各种计算机设备,包括但不限于智能手机、平板电脑、膝上型便携式计算机和台式计算机等等。当计算机设备为软件时,可以是安装上述所列举的计算机设备中。其可以实现呈多个软件或软件模块(例如:用来提供分布式服务),也可以实现成单个软件或软件模块,在此不作具体限定。Computer equipment can be either hardware or software. When the computer device is hardware, it can be various computer devices with display screens, including but not limited to smartphones, tablets, laptops, and desktops, among others. When the computer equipment is software, it can be installed in the computer equipment listed above. It can be implemented as multiple software or software modules (for example: for providing distributed services), or as a single software or software module, which is not specifically limited here.

当计算机设备为硬件时,其上还可以安装有显示设备和摄像头,显示设备显示可以是各种能实现显示功能的设备,摄像头用于采集视频流;例如:显示设备可以是阴极射线管显示器(cathoderaytubedisplay,简称CR)、发光二极管显示器(light-emittingdiodedisplay,简称LED)、电子墨水屏、液晶显示屏(liquidcrystaldisplay,简称LCD)、等离子显示面板(plasmadisplaypanel,简称PDP)等。用户可以利用计算机设备上的显示设备,来查看显示的文字、图片、视频等信息。When the computer device is hardware, a display device and a camera can also be installed on it, and the display device display can be various devices that can realize display functions, and the camera is used to collect video streams; for example: the display device can be a cathode ray tube display ( Cathoderaytubedisplay, referred to as CR), light-emitting diode display (light-emittingdiodedisplay, referred to as LED), electronic ink screen, liquid crystal display (liquid crystal display, referred to as LCD), plasma display panel (plasmadisplaypanel, referred to as PDP) and so on. The user can use the display device on the computer device to view displayed text, pictures, video and other information.

应理解,图1中的计算机设备、网络和服务器的数目仅是示意性的。根据实现需要,可以是任意数量的计算机设备、网络和服务器。It should be understood that the number of computer devices, networks, and servers in Figure 1 is illustrative only. There can be any number of computer devices, networks and servers depending on the needs of the implementation.

下面将结合附图2,对本申请实施例提供的业务系统的数据同步方法进行详细介绍。其中,本申请实施例中的业务系统的数据同步装置可以是图1所示的计算机设备。The data synchronization method of the service system provided by the embodiment of the present application will be described in detail below with reference to FIG. 2 . Wherein, the data synchronization device of the business system in the embodiment of the present application may be the computer equipment shown in FIG. 1 .

请参见图2,为本申请实施例提供了一种业务系统的数据同步方法的流程示意图。如图2所示,本申请实施例的所述方法可以包括以下步骤:Please refer to FIG. 2 , which provides a schematic flowchart of a data synchronization method for a business system according to an embodiment of the present application. As shown in Figure 2, the method in the embodiment of the present application may include the following steps:

S201、通过显示单元显示同步页面。S201. Display a synchronization page through a display unit.

其中,同步页面为图形化页面,用户基于同步页面对源业务系统和目标业务系统之间进行数据同步,同步页面设置数据筛选控件和数据表,数据筛选控件为图形控件,数据表用于展示用户过滤出的源业务数据和对应的目标业务数据。Among them, the synchronization page is a graphical page, and the user performs data synchronization between the source business system and the target business system based on the synchronization page. The data filtering control and the data table are set on the synchronization page. The data filtering control is a graphical control, and the data table is used to display the user Filtered source business data and corresponding target business data.

S202、根据用户对数据筛选控件的输入操作确定数据筛选条件。S202. Determine the data filtering condition according to the user's input operation on the data filtering control.

其中,输入操作包括但不限于鼠标操作、键盘操作或触控操作,数据筛选条件包括但不限于:预算任务、预算时间、关键词中的一种或多种。Wherein, the input operation includes but not limited to mouse operation, keyboard operation or touch operation, and the data filtering condition includes but not limited to: one or more of budget tasks, budget time, and keywords.

举例来说,参见图3所示的同步页面的示意图,同步页面设置有数据筛选控件:预算任务筛选下拉框、预算时间筛选下拉框和关键词输入框。用户通过输入装置触发预算任务筛选下拉控件后显示候选的多个预算任务,然后在多个预算任务中选择一个预算任务;用户通过输入装置触发预算时间下拉框后显示多个候选的预算时间,然后在多个预算时间中选择一个预算时间;用户通过输入装置在关键词输入框中输入关键词。计算机设备根据上述控件确定预算任务:2019年预算编制,预算时间:2019。For example, referring to the schematic diagram of the synchronization page shown in FIG. 3 , the synchronization page is provided with data filtering controls: a budget task filtering drop-down box, a budget time filtering drop-down box and a keyword input box. After the user triggers the budget task filtering drop-down control through the input device, multiple candidate budget tasks are displayed, and then selects a budget task among the multiple budget tasks; after the user triggers the budget time drop-down box through the input device, multiple candidate budget times are displayed, and then Select a budget time among multiple budget times; the user inputs keywords in the keyword input box through the input device. Computer equipment to determine the budget task according to the above controls: 2019 budget preparation, budget time: 2019.

S203、根据数据筛选条件在源业务系统中过滤出至少一条源业务数据,以及过滤出的至少一条源业务数据填充到数据表的第一区域。S203. Filter out at least one piece of source business data in the source business system according to the data filtering condition, and fill the filtered at least one piece of source business data into the first area of the data table.

其中,计算机设备根据S202中确定的数据筛选条件在源业务系统中过滤出至少一条源业务数据,源业务数据由源业务字段值和源业务参数值组成,将过滤出的至少一条源业务数据填充到数据表的第一区域中,各个源业务数据位于不同的行。Wherein, the computer device filters out at least one piece of source business data in the source business system according to the data filtering conditions determined in S202, the source business data is composed of source business field values and source business parameter values, and fills the filtered at least one piece of source business data In the first area of the data table, each source business data is located in a different row.

举例来说,参见图3所示的同步页面,一条源业务数据由定额标准名称的值和定额标准值的值组成,根据数据筛选条件(2019年预算任务、2019年)在源业务系统中筛选出12条源业务数据,然后填充到数据表的第2列和第4列,不同的源业务数据位于不同的行,共计12行。For example, see the synchronization page shown in Figure 3. A piece of source business data consists of the value of the quota standard name and the value of the quota standard value, and is filtered in the source business system according to the data filtering conditions (2019 budget task, 2019) Output 12 pieces of source business data, and then fill them into the 2nd and 4th columns of the data table. Different source business data are located in different rows, totaling 12 rows.

S204、若根据源业务字段值在目标业务系统匹配到对应的目标业务字段值,将源业务字段值关联的源业务参数值与目标业务字段值进行映射,映射后作为目标业务字段值的目标业务参数值。S204. If the corresponding target business field value is matched in the target business system according to the source business field value, map the source business parameter value associated with the source business field value with the target business field value, and use the target business field value after mapping parameter value.

其中,针对查询到的每条源业务数据,根据源业务字段值在目标业务系统中进行查询,若在目标业务系统中查询到匹配的目标业务字段值,将该源业务字段值关联的源业务参数值与该目标业务字段值进行映射,映射后作为该目标业务字段值的目标业务参数值。进一步,若目标业务字段值和源业务字段值的文本相似度大于阈值,则两个字段值是匹配的,否则两个字段值是不匹配的。计算文本相似度的方法可以是:利用人工神经网络对目标业务字段值和源业务字段值进行编码,得到两个文本的表征向量,然后计算两个表征向量的余弦相似度,比较余弦相似度和阈值的大小,阈值可以根据实际需求而定,例如:阈值为0.8,若余弦相似度大于0.8则两个文本是匹配,否则两个文本是不匹配的。Among them, for each piece of source business data that is queried, the query is performed in the target business system according to the value of the source business field. If a matching target business field value is found in the target business system, the source business associated with the source business field value The parameter value is mapped with the target business field value, and the mapped value is used as the target business parameter value of the target business field value. Further, if the text similarity between the target business field value and the source business field value is greater than a threshold, the two field values match, otherwise the two field values do not match. The method of calculating the text similarity can be: use the artificial neural network to encode the value of the target business field and the value of the source business field to obtain the representation vector of the two texts, then calculate the cosine similarity of the two representation vectors, and compare the cosine similarity and The size of the threshold, the threshold can be determined according to actual needs, for example: the threshold is 0.8, if the cosine similarity is greater than 0.8, the two texts match, otherwise the two texts do not match.

例如:参见图3所示的同步页面,同步页面设置有映射控件,例如:映射控件为“自动对应”控件,计算机设备检测到映射控件上的触发动作时,执行源业务字段值在自动匹配和映射。以数据表中的位于第1行的源业务数据为例,第1行的源业务数据的定额标准名称的值为1000kV-GIS站,根据“1000kV-GIS站”在目标业务系统中查询匹配的目标业务字段值,查询结果为存在匹配的目标业务字段值(成本标准类别名称的值)“1000kV-GIS站”,然后将定额标准值的值“1490545.56”与成本标准类别名称的值“1000kV-GIS站”进行绑定,作为第1行的测算结果的值。For example: see the synchronization page shown in Figure 3, the synchronization page is set with a mapping control, for example: the mapping control is an "auto-corresponding" control, when the computer device detects the trigger action on the mapping control, the value of the execution source business field is automatically matched and map. Take the source business data in the first row of the data table as an example, the value of the rating standard name of the source business data in the first row is 1000kV-GIS station, and query the matching in the target business system according to "1000kV-GIS station". The target business field value, the query result shows that there is a matching target business field value (the value of the cost standard category name) "1000kV-GIS station", and then the value of the quota standard value "1490545.56" and the value of the cost standard category name "1000kV- GIS station" as the value of the calculation result in line 1.

又例如:第2行的定额标准名称的值为“±800kV-换流站”,根据“±800kV-换流站”在目标业务系统中查询匹配的目标业务字段值,查询结果为存在匹配的成本标准类别名称的值“±800kV-换流站”,将定额标准值的值“200001.00”与成本标准类别名称的值“±800kV-换流站”进行映射,作为第1行的测算结果的值。Another example: the value of the rating standard name in line 2 is "±800kV-converter station", and the matching target business field value is queried in the target business system according to "±800kV-converter station", and the query result is that there is a matching The value of the cost standard category name "±800kV-converter station" is mapped to the value of the rated standard value "200001.00" and the value of the cost standard category name "±800kV-converter station" as the calculation result of the first line value.

进一步的,在本申请的一些实施例中,对于某个源业务数据来说,若未在目标系统中查询到匹配的目标业务字段值,那么可以由于用户手动进行匹配,匹配的方法包括:数据表中用于存放目标业务字段值的各个单元格中设置有映射配置控件,例如:图3的单元格中映射配置控件为单元格后面设置的省略号“…”,计算机设备响应于用于对映射配置控件的触发动作,通过显示单元显示配置页面,配置页面中设置有字段值筛选控件,例如:图4中的配置页面中,字段值筛选控件为预算定额分类下拉框和关键词输入框,根据字段值筛选控件确定字段值筛选条件,然后根据字段值筛选条件在目标业务系统中过滤出符合要求的目标业务字段值,然后基于用户的选择指令在过滤出的目标业务字段值中选择一个作为最终的目标业务字段值。例如:参见图4所示的配置页面,在为某个源业务字段进行匹配时,根据字段值筛选条件在目标业务系统中过滤出的候选的7个目标业务字段值,然后用户使用输入装置某个候选的目标业务字段值后,该目标业务字段值显示为高亮状态,用户使用输入装置点击配置页面的确认按钮后,选中的目标业务字段值填充到数据表中指定的单元格中。通过上述配置方法可以手动为没有自动匹配的源目标字段进行映射,提高数据同步操作的完整性。Furthermore, in some embodiments of the present application, for a certain source business data, if no matching target business field value is found in the target system, then the user can manually perform the matching. The matching method includes: data Each cell in the table used to store the value of the target business field is provided with a mapping configuration control, for example: the mapping configuration control in the cell in Figure 3 is the ellipsis "..." set behind the cell, and the computer device responds to the The trigger action of the configuration control is to display the configuration page through the display unit, and the field value filtering control is set in the configuration page, for example: in the configuration page in Fig. The field value filtering control determines the field value filtering conditions, and then filters out the target business field values that meet the requirements in the target business system according to the field value filtering conditions, and then selects one of the filtered target business field values based on the user's selection instruction as the final The target business field value for . For example: referring to the configuration page shown in Figure 4, when matching a certain source business field, 7 candidate target business field values are filtered out in the target business system according to the field value filtering conditions, and then the user uses an input device After a candidate target business field value is selected, the target business field value is displayed in a highlighted state. After the user clicks the confirmation button on the configuration page with the input device, the selected target business field value is filled into the specified cell in the data table. Through the above configuration method, you can manually map the source and target fields without automatic matching, so as to improve the integrity of the data synchronization operation.

在本申请的一些实施例中,对于自动匹配的源业务字段值来说,用户也可以对其映射关系进行检查,若发现映射关系不合格,也可以采用上述方式手动调整源业务字段值和目标业务字段值的映射关系,从而提高映射的准确率。In some embodiments of this application, for the automatically matched source business field value, the user can also check its mapping relationship, and if the mapping relationship is found to be unqualified, the above method can also be used to manually adjust the source business field value and target The mapping relationship of business field values, thereby improving the accuracy of mapping.

S205、将映射成功的目标业务数据填充到数据表的第二区域,以及将目标业务参数值同步到目标业务系统中。S205. Fill the successfully mapped target business data into the second area of the data table, and synchronize target business parameter values to the target business system.

其中,目标业务数据由目标业务字段值和目标业务参数值组成,例如:目标业务字段值表示成本标准类别名称的值,目标业务参数值表示测算结果的值,参见图3所示的数据表,将映射成功的目标业务数据填充到数据表的第3行和第5行,不同的目标业务数据位于不同的行,计算机设备在映射后自动进行数据同步,或计算机设备响应于同步页面上同步按钮的触发动作,执行数据同步操作,即将源业务系统中源业务参数值同步到对应的目标业务参数值,使目标业务参数值和源业务参数值保持一致。Among them, the target business data is composed of the target business field value and the target business parameter value, for example: the target business field value represents the value of the cost standard category name, and the target business parameter value represents the value of the measurement result, see the data table shown in Figure 3, Fill the successfully mapped target business data into the third and fifth rows of the data table. Different target business data are located in different rows. The computer device automatically performs data synchronization after mapping, or the computer device responds to the synchronization button on the synchronization page The trigger action is to execute the data synchronization operation, that is, to synchronize the source business parameter value in the source business system to the corresponding target business parameter value, so that the target business parameter value is consistent with the source business parameter value.

在本申请的一些实施例中,数据表具有编辑功能,单元格中的数值可以进行手动修改,若数据表的某行中源业务字段值和目标业务字段值不相等,进行提示。例如:数据表的第1行中定额标准值的值和测算结果的值不相等,对单元格中的数值进行高亮显示,以提示用户进行关注。进一步的,计算机设备可以在执行数据同步操作后,对数据表进行锁定,锁定后数据表中各个单元格的数据不可修改,只可读,避免出错。In some embodiments of the present application, the data table has an editing function, and the value in the cell can be manually modified. If the value of the source business field and the value of the target business field in a row of the data table are not equal, a prompt will be given. For example: the value of the standard value in the first row of the data table is not equal to the value of the measurement result, and the value in the cell is highlighted to prompt the user to pay attention. Further, the computer device can lock the data table after performing the data synchronization operation, and after locking, the data of each cell in the data table cannot be modified, but can only be read, so as to avoid errors.

进一步的,在数据表进行非锁定状态时,用户可以对数据表中的数据行进行删除,具体包括:响应于用户对所述数据表中的行选择操作选中至少一个数据行;基于用户的删除操作对选中的至少一个数据行进行删除,以及在所述源业务系统和所述目标业务系统中删除对应的源业务数据和目标业务数据。Further, when the data table is in an unlocked state, the user can delete data rows in the data table, specifically including: selecting at least one data row in response to the user's row selection operation in the data table; user-based deletion The operation is to delete at least one selected data row, and delete corresponding source business data and target business data in the source business system and the target business system.

例如:参见图3所示的同步页面,同步页面设置有删除控件“清楚对应”,用户基于输入装置在数据表中选择至少一个数据行,选中的数据行采用高亮显示,然后用户触发删除控件后对选中的数据行进行删除,然后对源业务系统和目标业务系统中对应的源业务数据和目标业务数据进行删除,通过可视化的编辑方式提升业务系统数据编辑的效率。For example: see the synchronization page shown in Figure 3, the synchronization page is set with a delete control "clear correspondence", the user selects at least one data row in the data table based on the input device, the selected data row is highlighted, and then the user triggers the delete control Then delete the selected data row, and then delete the corresponding source business data and target business data in the source business system and target business system, and improve the efficiency of business system data editing through visual editing.

本申请的实施例在执行两个业务系统的数据同步时,基于同步页面在源业务系统中过滤出待同步的至少一条源业务数据,然后根据源业务数据中的源业务字段值在目标业务系统中查询匹配的目标业务字段值,若查询到,将源业务字段值关联的源业务参数值对该目标业务字段值进行映射,映射后将源业务数据和目标业务数据填充到同步页面的数据表中,然后执行数据同步操作。这样用户可以根据实际需求灵活的选择待同步的源业务数据,提升数据同步的灵活性,同步页面上展示待同步的字段值和映射关系,便于用户准确掌握同步的字段值和映射关系是否准确。通过自动匹配的方式查询在目标业务系统中查询对应的目标业务字段值,减少手动操作的步骤,提升数据同步的效率。In the embodiment of the present application, when performing data synchronization of two business systems, at least one piece of source business data to be synchronized is filtered out in the source business system based on the synchronization page, and then in the target business system according to the value of the source business field in the source business data Query the matching target business field value in , if found, map the source business parameter value associated with the source business field value to the target business field value, and fill the source business data and target business data into the data table of the synchronization page after mapping , and then perform a data synchronization operation. In this way, users can flexibly select the source business data to be synchronized according to actual needs, improving the flexibility of data synchronization, and displaying the field values and mapping relationships to be synchronized on the synchronization page, so that users can accurately grasp whether the field values and mapping relationships to be synchronized are accurate. Query the corresponding target business field value in the target business system through automatic matching, reduce the steps of manual operation, and improve the efficiency of data synchronization.

下述为本申请装置实施例,可以用于执行本申请方法实施例。对于本申请装置实施例中未披露的细节,请参照本申请方法实施例。The following are device embodiments of the present application, which can be used to implement the method embodiments of the present application. For details not disclosed in the device embodiments of the present application, please refer to the method embodiments of the present application.

请参见图5,其示出了本申请一个示例性实施例提供的业务系统的数据同步装置的结构示意图,以下简称装置5。该装置5可以通过软件、硬件或者两者的结合实现成为计算机设备的全部或一部分。装置5包括:推送单元501、确定单元502、过滤单元503、映射单元504、同步单元505。Please refer to FIG. 5 , which shows a schematic structural diagram of a data synchronization device of a service system provided by an exemplary embodiment of the present application, referred to as device 5 hereinafter. The device 5 can be implemented as all or a part of computer equipment through software, hardware or a combination of the two. The device 5 includes: a pushing unit 501 , a determining unit 502 , a filtering unit 503 , a mapping unit 504 , and a synchronizing unit 505 .

推送单元501,用于通过显示单元显示同步页面;其中,所述同步页面设置数据筛选控件和数据表;A push unit 501, configured to display a synchronization page through a display unit; wherein, the synchronization page is provided with a data screening control and a data table;

确定单元502,用于根据用户对所述数据筛选控件的输入操作确定数据筛选条件;A determining unit 502, configured to determine the data filtering condition according to the user's input operation on the data filtering control;

过滤单元503,用于根据所述数据筛选条件在源业务系统中过滤出至少一条源业务数据,以及过滤出的至少一条源业务数据填充到所述数据表的第一区域;其中,所述源业务数据由源业务字段值和源业务参数值组成;The filtering unit 503 is configured to filter out at least one piece of source business data in the source business system according to the data filtering condition, and fill the filtered at least one piece of source business data into the first area of the data table; wherein, the source Business data consists of source business field values and source business parameter values;

映射单元504,用于若根据所述源业务字段值在目标业务系统匹配到对应的目标业务字段值,将所述源业务字段值关联的源业务参数值与所述目标业务字段值进行映射,映射后作为所述目标业务字段值的目标业务参数值;The mapping unit 504 is configured to map the source business parameter value associated with the source business field value with the target business field value if a corresponding target business field value is matched in the target business system according to the source business field value, The target service parameter value as the target service field value after mapping;

同步单元505,用于将映射成功的目标业务数据填充到所述数据表的第二区域,以及将目标业务参数值同步到所述目标业务系统中;其中,所述目标业务数据由目标业务字段值和目标业务参数值组成。Synchronization unit 505, configured to fill the successfully mapped target business data into the second area of the data table, and synchronize target business parameter values into the target business system; wherein, the target business data is represented by the target business field value and target business parameter value.

在一个或多个可能的实施例中,源业务字段值为定额标准名称的值,源业务参数值为定额标准值的值;目标业务字段值为成本标准类别名称的值,目标业务参数值为测算结果的值。In one or more possible embodiments, the source business field value is the value of the quota standard name, the source business parameter value is the value of the quota standard value; the target business field value is the value of the cost standard category name, and the target business parameter value is The value of the result of the calculation.

在一个或多个可能的实施例中,所述数据筛选条件包括:预算任务、预算时间、关键词中的一种或多种。In one or more possible embodiments, the data filtering conditions include: one or more of budgeted tasks, budgeted time, and keywords.

在一个或多个可能的实施例中,当源业务字段值和目标业务字段值的文本相似度大于预设阈值时,则二者是匹配的。In one or more possible embodiments, when the text similarity between the source business field value and the target business field value is greater than a preset threshold, the two are matched.

在一个或多个可能的实施例中,还包括:In one or more possible embodiments, it also includes:

提示单元,用于若数据表中位于同一行的源业务参数值和目标业务参数值不相等,则进行提示操作。The prompting unit is used to perform a prompting operation if the source business parameter value and the target business parameter value in the same row in the data table are not equal.

在一个或多个可能的实施例中,还包括:In one or more possible embodiments, it also includes:

编辑单元,用于响应于用户对所述数据表中的行选择操作选中至少一个数据行;An editing unit, configured to select at least one data row in response to a user's row selection operation in the data table;

基于用户的删除操作对选中的至少一个数据行进行删除,以及在所述源业务系统和所述目标业务系统中删除对应的源业务数据和目标业务数据。Deleting at least one selected data row based on a user's deletion operation, and deleting corresponding source service data and target service data in the source service system and the target service system.

在一个或多个可能的实施例中,存放目标业务字段值的各个单元格中设置有映射配置控件;In one or more possible embodiments, each cell storing the value of the target business field is provided with a mapping configuration control;

其中,还包括:Among them, also include:

配置单元,用于若根据所述源业务字段值在目标业务系统匹配到对应的目标业务字段值,响应于用户对所述配置控件的触发动作,通过显示单元显示配置页面;其中,所述配置页面设置有字段值筛选控件;The configuration unit is configured to display a configuration page through a display unit in response to a user’s trigger action on the configuration control if the corresponding target business field value is matched in the target business system according to the source business field value; wherein, the configuration Page settings have field value filter controls;

根据用户对所述字段值筛选控件的输入操作确定字段值筛选条件,以及根据所述字段值筛选条件在所述目标业务系统中过滤出候选的目标业务字段值;Determine the field value filter condition according to the user's input operation on the field value filter control, and filter out candidate target business field values in the target business system according to the field value filter condition;

基于用户的选择指令在候选的目标业务字段值中选择一个目标业务字段值与所述源业务字段值进行匹配。Selecting a target business field value from the candidate target business field values to match the source business field value based on the user's selection instruction.

需要说明的是,上述实施例提供的装置5在执行业务系统的数据同步方法时,仅以上述各功能模块的划分进行举例说明,实际应用中,可以根据需要而将上述功能分配由不同的功能模块完成,即将设备的内部结构划分成不同的功能模块,以完成上述的全部或者部分功能。另外,上述实施例提供的业务系统的数据同步装置与业务系统的数据同步方法实施例属于同一构思,其体现实现过程详见方法实施例,这里不再赘述。It should be noted that when the device 5 provided in the above-mentioned embodiment executes the data synchronization method of the business system, the division of the above-mentioned functional modules is used as an example for illustration. In practical applications, the above-mentioned functions can be assigned to different function Module completion means that the internal structure of the device is divided into different functional modules to complete all or part of the above functions. In addition, the data synchronization device of the business system provided by the above embodiment and the data synchronization method embodiment of the business system belong to the same idea, and the implementation process thereof is detailed in the method embodiment, and will not be repeated here.

上述本申请实施例序号仅仅为了描述,不代表实施例的优劣。The serial numbers of the above embodiments of the present application are for description only, and do not represent the advantages and disadvantages of the embodiments.

本申请实施例还提供了一种计算机存储介质,所述计算机存储介质可以存储有多条指令,所述指令适于由处理器加载并执行如上述图2所示实施例的方法步骤,具体执行过程可以参见图2所示实施例的具体说明,在此不进行赘述。The embodiment of the present application also provides a computer storage medium, the computer storage medium can store a plurality of instructions, and the instructions are suitable for being loaded by a processor and executing the method steps in the embodiment shown in Figure 2 above, specifically executing For the process, reference may be made to the specific description of the embodiment shown in FIG. 2 , and details are not repeated here.

本申请还提供了一种计算机程序产品,该计算机程序产品存储有至少一条指令,所述至少一条指令由所述处理器加载并执行以实现如上各个实施例所述的业务系统的数据同步方法。The present application also provides a computer program product, the computer program product stores at least one instruction, and the at least one instruction is loaded and executed by the processor to implement the data synchronization method of the business system as described in the above embodiments.

请参见图6,为本申请实施例提供了一种计算机设备的结构示意图。如图6所示,所述计算机设备600可以包括:至少一个处理器601,至少一个网络接口604,用户接口603,存储器605,至少一个通信总线602。Please refer to FIG. 6 , which provides a schematic structural diagram of a computer device according to an embodiment of the present application. As shown in FIG. 6 , the computer device 600 may include: at least one processor 601 , at least one network interface 604 , a user interface 603 , a memory 605 , and at least one communication bus 602 .

其中,通信总线602用于实现这些组件之间的连接通信。Wherein, the communication bus 602 is used to realize connection and communication between these components.

其中,用户接口603可以包括显示屏(Display)、摄像头(Camera),可选用户接口603还可以包括标准的有线接口、无线接口。Wherein, the user interface 603 may include a display screen (Display) and a camera (Camera), and the optional user interface 603 may also include a standard wired interface and a wireless interface.

其中,网络接口604可选的可以包括标准的有线接口、无线接口(如WI-FI接口)。Wherein, the network interface 604 may optionally include a standard wired interface and a wireless interface (such as a WI-FI interface).

其中,处理器601可以包括一个或者多个处理核心。处理器601利用各种接口和线路连接整个计算机设备600内的各个部分,通过运行或执行存储在存储器605内的指令、程序、代码集或指令集,以及调用存储在存储器605内的数据,执行计算机设备600的各种功能和处理数据。可选的,处理器601可以采用数字信号处理(DigitalSignalProcessing,DSP)、现场可编程门阵列(Field-ProgrammableGateArray,FPGA)、可编程逻辑阵列(Programmable LogicArray,PLA)中的至少一种硬件形式来实现。处理器601可集成中央处理器(Central ProcessingUnit,CPU)、图像处理器(GraphicsProcessingUnit,GPU)和调制解调器等中的一种或几种的组合。其中,CPU主要处理操作系统、用户界面和应用程序等;GPU用于负责显示屏所需要显示的内容的渲染和绘制;调制解调器用于处理无线通信。可以理解的是,上述调制解调器也可以不集成到处理器601中,单独通过一块芯片进行实现。Wherein, the processor 601 may include one or more processing cores. The processor 601 uses various interfaces and lines to connect various parts of the entire computer device 600, and executes by running or executing instructions, programs, code sets or instruction sets stored in the memory 605, and calling data stored in the memory 605. Various functions of the computer device 600 and processing data. Optionally, the processor 601 may be implemented in at least one hardware form of Digital Signal Processing (Digital Signal Processing, DSP), Field-Programmable Gate Array (Field-Programmable Gate Array, FPGA), and Programmable Logic Array (Programmable Logic Array, PLA). . The processor 601 may integrate one or a combination of a central processing unit (Central Processing Unit, CPU), an image processor (Graphics Processing Unit, GPU), a modem, and the like. Among them, the CPU mainly handles the operating system, user interface and application programs, etc.; the GPU is used to render and draw the content that needs to be displayed on the display screen; the modem is used to handle wireless communication. It can be understood that the foregoing modem may also not be integrated into the processor 601, but implemented by a single chip.

其中,存储器605可以包括随机存储器(RandomAccessMemory,RAM),也可以包括只读存储器(Read-OnlyMemory)。可选的,该存储器605包括非瞬时性计算机可读介质(non-transitorycomputer-readablestoragemedium)。存储器605可用于存储指令、程序、代码、代码集或指令集。存储器605可包括存储程序区和存储数据区,其中,存储程序区可存储用于实现操作系统的指令、用于至少一个功能的指令(比如触控功能、声音播放功能、图像播放功能等)、用于实现上述各个方法实施例的指令等;存储数据区可存储上面各个方法实施例中涉及到的数据等。存储器605可选的还可以是至少一个位于远离前述处理器601的存储装置。如图6所示,作为一种计算机存储介质的存储器605中可以包括操作系统、网络通信模块、用户接口模块以及应用程序。Wherein, the memory 605 may include a random access memory (Random Access Memory, RAM), or may include a read-only memory (Read-Only Memory). Optionally, the storage 605 includes a non-transitory computer-readable storage medium (non-transitory computer-readable storage medium). Memory 605 may be used to store instructions, programs, codes, sets of codes, or sets of instructions. The memory 605 may include a program storage area and a data storage area, wherein the program storage area may store instructions for implementing an operating system, instructions for at least one function (such as a touch function, a sound playback function, an image playback function, etc.), Instructions, etc. used to implement the above method embodiments; the storage data area can store data, etc. involved in the above method embodiments. Optionally, the memory 605 may also be at least one storage device located away from the aforementioned processor 601 . As shown in FIG. 6 , the memory 605 as a computer storage medium may include an operating system, a network communication module, a user interface module and application programs.

在图6所示的计算机设备600中,用户接口603主要用于为用户提供输入的接口,获取用户输入的数据;而处理器601可以用于调用存储器605中存储的应用程序,并具体执行如图2所示的方法,具体过程可参照图2所示,此处不再赘述。In the computer device 600 shown in FIG. 6 , the user interface 603 is mainly used to provide the user with an input interface to obtain the data input by the user; and the processor 601 can be used to call the application program stored in the memory 605, and specifically execute such as For the method shown in FIG. 2 , the specific process may refer to that shown in FIG. 2 , which will not be repeated here.

本领域普通技术人员可以理解实现上述实施例方法中的全部或部分流程,是可以通过计算机程序来指令相关的硬件来完成,所述的程序可存储于一计算机可读取存储介质中,该程序在执行时,可包括如上述各方法的实施例的流程。其中,所述的存储介质可为磁碟、光盘、只读存储记忆体或随机存储记忆体等。Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be implemented through computer programs to instruct related hardware, and the programs can be stored in a computer-readable storage medium. During execution, it may include the processes of the embodiments of the above-mentioned methods. Wherein, the storage medium may be a magnetic disk, an optical disk, a read-only memory or a random access memory, and the like.

以上所揭露的仅为本申请较佳实施例而已,当然不能以此来限定本申请之权利范围,因此依本申请权利要求所作的等同变化,仍属本申请所涵盖的范围。The above disclosures are only preferred embodiments of the present application, which certainly cannot limit the scope of the present application. Therefore, equivalent changes made according to the claims of the present application still fall within the scope of the present application.

Claims (10)

1.一种业务系统的数据同步方法,其特征在于,包括:1. A data synchronization method for a business system, comprising: 通过显示单元显示同步页面;其中,所述同步页面设置数据筛选控件和数据表;A synchronous page is displayed by the display unit; wherein, the synchronous page is set with a data filtering control and a data table; 根据用户对所述数据筛选控件的输入操作确定数据筛选条件;determining the data filtering condition according to the user's input operation on the data filtering control; 根据所述数据筛选条件在源业务系统中过滤出至少一条源业务数据,以及过滤出的至少一条源业务数据填充到所述数据表的第一区域;其中,所述源业务数据由源业务字段值和源业务参数值组成;Filter out at least one piece of source business data in the source business system according to the data filtering conditions, and fill the filtered at least one piece of source business data into the first area of the data table; wherein, the source business data consists of the source business field Value and source business parameter value; 若根据所述源业务字段值在目标业务系统匹配到对应的目标业务字段值,将所述源业务字段值关联的源业务参数值与所述目标业务字段值进行映射,映射后作为所述目标业务字段值的目标业务参数值;If the corresponding target business field value is matched in the target business system according to the source business field value, map the source business parameter value associated with the source business field value with the target business field value, and use the mapping as the target The target business parameter value of the business field value; 将映射成功的目标业务数据填充到所述数据表的第二区域,以及将目标业务参数值同步到所述目标业务系统中;其中,所述目标业务数据由目标业务字段值和目标业务参数值组成。Filling successfully mapped target business data into the second area of the data table, and synchronizing target business parameter values into the target business system; wherein, the target business data consists of target business field values and target business parameter values composition. 2.根据权利要求1所述的方法,其特征在于,源业务字段值为定额标准名称的值,源业务参数值为定额标准值的值;目标业务字段值为成本标准类别名称的值,目标业务参数值为测算结果的值。2. The method according to claim 1, wherein the source business field value is the value of the quota standard name, and the source business parameter value is the value of the quota standard value; the target business field value is the value of the cost standard category name, and the target business field value is The business parameter value is the value of the measurement result. 3.根据权利要求1或2所述的方法,其特征在于,所述数据筛选条件包括:预算任务、预算时间、关键词中的一种或多种。3. The method according to claim 1 or 2, wherein the data filtering conditions include: one or more of budgetary tasks, budgetary time, and keywords. 4.根据权利要求3所述的方法,其特征在于,当源业务字段值和目标业务字段值的文本相似度大于预设阈值时,则二者是匹配的。4. The method according to claim 3, wherein when the text similarity between the source business field value and the target business field value is greater than a preset threshold, the two are matched. 5.根据权利要求1或2或4所述的方法,其特征在于,还包括:5. The method according to claim 1, 2 or 4, further comprising: 若数据表中位于同一行的源业务参数值和目标业务参数值不相等,则进行提示操作。If the value of the source business parameter and the value of the target business parameter in the same row in the data table are not equal, a prompt operation is performed. 6.根据权利要求5所述的方法,其特征在于,还包括:6. The method according to claim 5, further comprising: 响应于用户对所述数据表中的行选择操作选中至少一个数据行;Selecting at least one data row in response to a user's row selection operation in the data table; 基于用户的删除操作对选中的至少一个数据行进行删除,以及在所述源业务系统和所述目标业务系统中删除对应的源业务数据和目标业务数据。Deleting at least one selected data row based on a user's deletion operation, and deleting corresponding source service data and target service data in the source service system and the target service system. 7.根据权利要求1或2或4或6所述的方法,其特征在于,存放目标业务字段值的各个单元格中设置有映射配置控件;7. according to the method described in claim 1 or 2 or 4 or 6, it is characterized in that, each cell that deposits target business field value is provided with mapping configuration control; 其中,所述方法还包括:Wherein, the method also includes: 若根据所述源业务字段值在目标业务系统匹配到对应的目标业务字段值,响应于用户对所述配置控件的触发动作,通过显示单元显示配置页面;其中,所述配置页面设置有字段值筛选控件;If the corresponding target business field value is matched in the target business system according to the source business field value, in response to the trigger action of the configuration control by the user, the configuration page is displayed through the display unit; wherein, the configuration page is set with a field value filter controls; 根据用户对所述字段值筛选控件的输入操作确定字段值筛选条件,以及根据所述字段值筛选条件在所述目标业务系统中过滤出候选的目标业务字段值;Determine the field value filter condition according to the user's input operation on the field value filter control, and filter out candidate target business field values in the target business system according to the field value filter condition; 基于用户的选择指令在候选的目标业务字段值中选择一个目标业务字段值与所述源业务字段值进行匹配。Selecting a target business field value from the candidate target business field values to match the source business field value based on the user's selection instruction. 8.一种业务系统的数据同步装置,其特征在于,包括:8. A data synchronization device for a business system, comprising: 推送单元,用于通过显示单元显示同步页面;其中,所述同步页面设置数据筛选控件和数据表;A push unit, configured to display a synchronization page through a display unit; wherein, the synchronization page is provided with a data filtering control and a data table; 确定单元,用于根据用户对所述数据筛选控件的输入操作确定数据筛选条件;A determining unit, configured to determine data filtering conditions according to user input operations on the data filtering control; 过滤单元,用于根据所述数据筛选条件在源业务系统中过滤出至少一条源业务数据,以及过滤出的至少一条源业务数据填充到所述数据表的第一区域;其中,所述源业务数据由源业务字段值和源业务参数值组成;A filtering unit, configured to filter out at least one piece of source business data in the source business system according to the data filtering condition, and fill the filtered at least one piece of source business data into the first area of the data table; wherein, the source business Data consists of source business field values and source business parameter values; 映射单元,用于若根据所述源业务字段值在目标业务系统匹配到对应的目标业务字段值,将所述源业务字段值关联的源业务参数值与所述目标业务字段值进行映射,映射后作为所述目标业务字段值的目标业务参数值;The mapping unit is configured to map the source business parameter value associated with the source business field value with the target business field value if the target business field value is matched to the corresponding target business field value according to the source business field value, and map Then as the target business parameter value of the target business field value; 同步单元,用于将映射成功的目标业务数据填充到所述数据表的第二区域,以及将目标业务参数值同步到所述目标业务系统中;其中,所述目标业务数据由目标业务字段值和目标业务参数值组成。A synchronization unit, configured to fill the successfully mapped target business data into the second area of the data table, and synchronize target business parameter values into the target business system; wherein, the target business data is determined by the target business field value and target business parameter values. 9.一种计算机存储介质,其特征在于,所述计算机存储介质存储有多条指令,所述指令适于由处理器加载并执行如权利要求1~7任意一项的方法步骤。9. A computer storage medium, characterized in that the computer storage medium stores a plurality of instructions, and the instructions are suitable for being loaded by a processor and executing the method steps according to any one of claims 1-7. 10.一种计算机设备,其特征在于,包括:处理器和存储器;其中,所述存储器存储有计算机程序,所述计算机程序适于由所述处理器加载并执行如权利要求1~7任意一项的方法步骤。10. A computer device, characterized in that it comprises: a processor and a memory; wherein, the memory stores a computer program, and the computer program is suitable for being loaded by the processor and executing any one of claims 1-7. method steps for the item.
CN202310298942.1A 2023-03-24 2023-03-24 Data synchronization method, device, storage medium and computer equipment of business system Pending CN116628079A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310298942.1A CN116628079A (en) 2023-03-24 2023-03-24 Data synchronization method, device, storage medium and computer equipment of business system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310298942.1A CN116628079A (en) 2023-03-24 2023-03-24 Data synchronization method, device, storage medium and computer equipment of business system

Publications (1)

Publication Number Publication Date
CN116628079A true CN116628079A (en) 2023-08-22

Family

ID=87612263

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310298942.1A Pending CN116628079A (en) 2023-03-24 2023-03-24 Data synchronization method, device, storage medium and computer equipment of business system

Country Status (1)

Country Link
CN (1) CN116628079A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117390119A (en) * 2023-10-24 2024-01-12 中国平安财产保险股份有限公司 Task processing methods, devices, computer equipment and storage media

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102270084A (en) * 2010-06-04 2011-12-07 英华达(上海)电子有限公司 Electronic book reader and data processing method thereof
US20120185432A1 (en) * 2009-10-23 2012-07-19 Zte Corporation Method, device and system for implementing data synchronization between source database and target database
CN110321227A (en) * 2018-03-29 2019-10-11 腾讯科技(深圳)有限公司 Page data synchronous method, electronic device and computer readable storage medium
CN114691779A (en) * 2022-03-29 2022-07-01 京东方科技集团股份有限公司 Data synchronization method and system, computer readable storage medium

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120185432A1 (en) * 2009-10-23 2012-07-19 Zte Corporation Method, device and system for implementing data synchronization between source database and target database
CN102270084A (en) * 2010-06-04 2011-12-07 英华达(上海)电子有限公司 Electronic book reader and data processing method thereof
CN110321227A (en) * 2018-03-29 2019-10-11 腾讯科技(深圳)有限公司 Page data synchronous method, electronic device and computer readable storage medium
CN114691779A (en) * 2022-03-29 2022-07-01 京东方科技集团股份有限公司 Data synchronization method and system, computer readable storage medium

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117390119A (en) * 2023-10-24 2024-01-12 中国平安财产保险股份有限公司 Task processing methods, devices, computer equipment and storage media

Similar Documents

Publication Publication Date Title
CN113485781B (en) Report generation method, device, electronic device and computer readable medium
US10713066B2 (en) Generating content objects using an integrated development environment
CN111708779A (en) Data management method, system, management equipment and storage medium
US20110209042A1 (en) Information Technology Standard Inventory Utility
US8959475B2 (en) Generating a semantic graph that allows a user to intelligently and efficiently connect with people and assets involved in projects
CN113157947A (en) Knowledge graph construction method, tool, device and server
WO2011091163A1 (en) Metadata-configurable systems and methods for network services
CN115147049B (en) Order batch loading method and device, storage medium and computer equipment
CN111143408B (en) Event processing method and device based on business rule
CN113779313B (en) A knowledge management method and system based on graph database
CN109033157B (en) Complex data retrieval method and system based on user-defined search condition tree
CN116992092A (en) Method and device for establishing flow model, storage medium and terminal equipment
WO2025045002A1 (en) Method and apparatus for processing data table, and device and storage medium
CN115130442A (en) Report generation method and device, storage medium and computer equipment
CN112783887A (en) Data processing method and device based on data warehouse
US20130297368A1 (en) Updating customer relationship management systems through sales playbook activities
CN116628079A (en) Data synchronization method, device, storage medium and computer equipment of business system
CN115936302A (en) Cost allocation method, device, storage medium and computer equipment
CN119048294A (en) Contract numbering method and device, storage medium and terminal equipment
US9355376B2 (en) Rules library for sales playbooks
US20240289544A1 (en) Graphical cell creation preview before structure update
CN113888118A (en) Configuration method, device, storage medium and terminal device of rule service
CN116011955A (en) A method, device, equipment and storage medium for realizing robot process automation requirements
CN115222500A (en) Fund monitoring method, device, storage medium and computer equipment
CN114358725A (en) Identification method, device, storage medium and computer equipment of enterprise nature

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination