CN112199424A - Method for pulling communication information island through RPA, readable storage medium and RPA robot - Google Patents
Method for pulling communication information island through RPA, readable storage medium and RPA robot Download PDFInfo
- Publication number
- CN112199424A CN112199424A CN202010928254.5A CN202010928254A CN112199424A CN 112199424 A CN112199424 A CN 112199424A CN 202010928254 A CN202010928254 A CN 202010928254A CN 112199424 A CN112199424 A CN 112199424A
- Authority
- CN
- China
- Prior art keywords
- data
- island
- rpa
- pulling
- information
- 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
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/31—Indexing; Data structures therefor; Storage structures
- G06F16/313—Selection or weighting of terms for indexing
Abstract
The invention relates to a method for pulling an information island through an RPA (resilient packet access), a readable storage medium and an RPA robot, wherein the method for pulling the information island through the RPA comprises the following steps: the RPA reads island data of a plurality of different information systems; the RPA carries out merging processing on the read island data; the RPA calculates the processed data; and the RPA outputs a calculation result. By implementing the technical scheme of the invention, the RPA replaces manual data processing, so that the safety, accuracy and efficiency are greatly improved.
Description
Technical Field
The invention relates to the field of office automation, in particular to a method for pulling an isolated island through RPA (resilient packet access), a readable storage medium and an RPA robot.
Background
Information islanding, also called data islanding, is an information isolation phenomenon widely existing in each enterprise. With the rapid development of enterprise informatization construction, enterprise management functions are finely divided, information systems are developed around different management stages and management functions, such as a customer management system, a production system, a sales system, a purchase system, an order system, a storage system, a financial system and the like, all data are sealed in each system, and an integral business chain is set up in an isolated island. The sharing and feedback of information are difficult, so that enterprises cannot adapt to the current fast, changeable and global competitive market environment, and the survival and development of the enterprises face great challenges.
Nowadays, more and more enterprises have realized that information islands must be opened to achieve process optimization upgrades, reduce operating costs, and gain more valuable insight from information and data. The traditional mode of solving information island problem is mostly: the data maintenance across systems and applications is manually operated, but the mode needs manpower to manually process a large amount of data, so that the safety, the accuracy and the efficiency are not high.
Disclosure of Invention
The invention aims to solve the technical problem of providing a method for pulling an isolated island through RPA (resilient packet access), a readable storage medium and an RPA robot aiming at the defects of low safety, accuracy and efficiency caused by data maintenance of manual operation and cross-system and cross-application in the prior art.
The technical scheme adopted by the invention for solving the technical problems is as follows: a method for pulling an information island through RPA comprises the following steps:
the RPA reads island data of a plurality of different information systems;
the RPA carries out merging processing on the read island data;
the RPA calculates the processed data;
and the RPA outputs a calculation result.
Preferably, the RPA reads island data of a plurality of different information systems, including:
judging whether the read island data of the current information system is structured data or not;
if the data is structured data, directly exporting island data of the current information system;
and if the data is not structured data, analyzing and exporting the island data of the current information system according to a pre-configured data template.
Preferably, the data template is configured in advance by:
according to the type of the island data of the information system, determining a storage structure of the island data and a mapping rule from the island data to target data to generate a data template.
Preferably, the RPA performs merging processing on the read islanding data, including:
and associating different island data according to different dimensions to obtain combined data.
Preferably, after the RPA performs merging processing on the read islanding data, the method further includes:
and removing island data which are not associated.
Preferably, outputting the calculation result comprises:
and visually outputting the calculation result according to a preset report form format.
The invention also constitutes a readable storage medium storing a computer program, characterized in that the computer program, when executed by a processor, implements the above-described method of pulling a message island by an RPA.
The invention also provides an RPA robot, comprising a processor and a memory storing a computer program, wherein the processor implements the above method for pulling a message island by RPA when executing the computer program.
The invention also constructs an RPA robot which is used for pulling a communication information island and comprises:
the reading module is used for reading island data of a plurality of different information systems;
the merging module is used for merging the read island data;
the computing module is used for computing the processed data;
and the output module is used for outputting the calculation result.
Preferably, the reading module includes:
the judging unit is used for judging whether the read island data of the current information system is structured data;
the direct derivation unit is used for directly deriving island data of the current information system when the island data is structured data;
and the analysis and derivation unit is used for analyzing and deriving the island data of the current information system according to a pre-configured data template when the island data is not structured data.
According to the technical scheme provided by the invention, when cross-system and cross-application data maintenance needs to be operated, island data of a plurality of different information systems can be read through the RPA, the read island data are merged, the processed data are calculated, and a calculation result is output.
Drawings
In order to illustrate the embodiments of the invention more clearly, the drawings that are needed in the description of the embodiments will be briefly described below, it being apparent that the drawings in the following description are only some embodiments of the invention, and that other drawings may be derived from those drawings by a person skilled in the art without inventive effort. In the drawings:
FIG. 1 is a flow chart of a first embodiment of a method for pulling an isolated message island through an RPA according to the present invention;
FIG. 2 is a flowchart illustrating a first embodiment of step S10 in FIG. 1;
fig. 3 is a logical structure diagram of an RPA robot according to a first embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
First, RPA (robot Process Automation, also called digital labor) refers to a way of using software Automation technology to replace manual operation to complete computer operation, that is, by simulating the operation of manual work on a computer, workers are freed from complicated and repeated processes, and are put into the work of creating more value.
The working principle of the RPA is based on the working desktop of the computer operating system. The UI may be automatically recognized to complete a preset workflow. It has the ability to launch and use a variety of applications, including opening emails and attachments, logging applications, moving files and folders, and even crawling data from the network (including social media). RPA is based on existing user interface operations, is fast to deploy, and is not tied to the underlying IT infrastructure. The RPA may perform all data processing, including copying and pasting of data, merging data from multiple sources, extracting data from documents, inputting data to forms, operations, extracting and reformatting data into reports or dashboards. The integration with the original tools of the enterprise is realized, the database is read and written, and the API is connected to the system.
How to use the RPA to pull an isolated island to ensure good operation of an enterprise business process? The invention constructs a method for pulling an information island through an RPA, and the method of the embodiment is applied to an RPA robot and specifically comprises the following steps:
s10, reading island data of a plurality of different information systems by the RPA;
step S20. the RPA carries out merging processing on the read island data;
s30, calculating the processed data by the RPA;
and S40, outputting a calculation result by the RPA.
Further, in conjunction with fig. 2, step S10 includes:
step S11, determining whether the read island data of the current information system is structured data, for example, determining whether the island data is data in a database format, if yes, executing step S12; if not, go to step S13;
s12, directly deriving island data of the current information system;
and S13, analyzing and exporting the island data of the current information system according to a pre-configured data template.
In an alternative embodiment, the data templates may be pre-configured by: according to the type of the island data of the information system, determining a storage structure of the island data and a mapping rule from the island data to target data to generate a data template. In this embodiment, if the islanding data is Excel-type data, the tables sheet and title may be configured, for example, a certain column of data is taken and then mapped to the target database; if the island data is text type data, keywords of the island data can be extracted and mapped to a target database after analysis.
Further, step S20 includes: and associating different island data according to different dimensions to obtain combined data. In this embodiment, after reading different islanding data, each islanding data may be de-correlated by dimension. In a specific example, an employee may have different employee IDs in different island data, and when association is combined, the association is not performed according to a common key by, but performed according to multiple IDs, for example, employee data is combined according to employee ID association, and financial data is combined according to financial ID association. In another specific example, assuming that employee a has two employee IDs of ID1 and ID2 in the first data source, employee B has two employee IDs of ID2 and ID3 in the second data source, and employee C has two employee IDs of ID1 and ID3 in the third data source, the data of A, B, C three employees should be merged into one piece when merging different island data (data of data sources).
Further, after step S20, the method further includes: and removing island data which are not associated. For example, in one particular example, an E employee has two employee IDs, ID4, ID5, in a first data source, but no data related to ID4 or ID5 exists in the other data source, so the E employee's data read from the first data source may be deleted.
Further, in step S30, the merged data may be calculated according to the actual demand of the user, so as to implement merging and reusing of the island data. After the calculation result is acquired, step S40 is: and visually outputting the calculation result according to a preset report form format.
The present invention also constitutes a readable storage medium storing a computer program which, when executed by a processor, implements the above-described method of pulling a message island by an RPA.
The invention also provides an RPA robot, which comprises a processor and a memory stored with a computer program, wherein the processor realizes the method for pulling the message island through the RPA when executing the computer program.
Fig. 3 is a logical structure diagram of an RPA robot according to a first embodiment of the present invention, the RPA robot is used for pulling a communication information island, and includes the following components connected in sequence: the device comprises a reading module 10, a merging module 20, a calculating module 30 and an output module 40, wherein the reading module 10 is used for reading island data of a plurality of different information systems; the merging module 20 is configured to merge the read islanding data; the calculation module 30 is used for calculating the processed data; the output module 40 is used for outputting the calculation result.
Further, the reading module 10 includes: the system comprises a judging unit 11, a direct deriving unit 12 and an analysis deriving unit 13, wherein the judging unit 11 is used for judging whether the read island data of the current information system is structured data; the direct derivation unit 12 is configured to directly derive island data of the current information system when the data is structured data; the analysis derivation unit 13 is configured to, when the data is not structured data, analyze and derive island data of the current information system according to a pre-configured data template.
Further, the merging module 20 is configured to associate different island data according to different dimensions to obtain merged data, and is further configured to remove island data that is not associated.
Further, the output module 40 outputs the calculation result visually according to a preset report format.
The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the scope of the claims of the present invention.
Claims (10)
1. A method for pulling an island of information through an RPA, comprising:
the RPA reads island data of a plurality of different information systems;
the RPA carries out merging processing on the read island data;
the RPA calculates the processed data;
and the RPA outputs a calculation result.
2. A method for pulling an island of information by an RPA according to claim 1, wherein the RPA reads island data of a plurality of different information systems, comprising:
judging whether the read island data of the current information system is structured data or not;
if the data is structured data, directly exporting island data of the current information system;
and if the data is not structured data, analyzing and exporting the island data of the current information system according to a pre-configured data template.
3. A method for pulling an islanding message by an RPA according to claim 2, wherein the data template is configured in advance by:
according to the type of the island data of the information system, determining a storage structure of the island data and a mapping rule from the island data to target data to generate a data template.
4. The method for pulling an island of information through an RPA according to claim 1, wherein the RPA performs merging processing on the read island data, and the merging processing includes:
and associating different island data according to different dimensions to obtain combined data.
5. A method for pulling an island of information by an RPA according to claim 4, wherein after the RPA performs merge processing on the read island data, the method further comprises:
and removing island data which are not associated.
6. The method for pulling an isolated island of messages by an RPA according to claim 1, wherein outputting the calculation result includes:
and visually outputting the calculation result according to a preset report form format.
7. A readable storage medium storing a computer program, wherein the computer program, when executed by a processor, implements the method of pulling an islanding of information by an RPA according to any of claims 1 to 5.
8. An RPA robot comprising a processor and a memory storing a computer program, wherein the processor, when executing the computer program, implements the method of pulling an islanding on an information string by an RPA according to any of claims 1-5.
9. An RPA robot for pulling an island of interest, comprising:
the reading module is used for reading island data of a plurality of different information systems;
the merging module is used for merging the read island data;
the computing module is used for computing the processed data;
and the output module is used for outputting the calculation result.
10. The RPA robot of claim 9, wherein the reading module comprises:
the judging unit is used for judging whether the read island data of the current information system is structured data;
the direct derivation unit is used for directly deriving island data of the current information system when the island data is structured data;
and the analysis and derivation unit is used for analyzing and deriving the island data of the current information system according to a pre-configured data template when the island data is not structured data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010928254.5A CN112199424A (en) | 2020-09-07 | 2020-09-07 | Method for pulling communication information island through RPA, readable storage medium and RPA robot |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010928254.5A CN112199424A (en) | 2020-09-07 | 2020-09-07 | Method for pulling communication information island through RPA, readable storage medium and RPA robot |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112199424A true CN112199424A (en) | 2021-01-08 |
Family
ID=74005784
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010928254.5A Pending CN112199424A (en) | 2020-09-07 | 2020-09-07 | Method for pulling communication information island through RPA, readable storage medium and RPA robot |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112199424A (en) |
Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110282508A1 (en) * | 2010-05-12 | 2011-11-17 | Alstom Grid | Generalized grid security framework |
| CN102521686A (en) * | 2011-11-30 | 2012-06-27 | 陕西东显永益机电技术有限公司 | Examining and approving management system for administrative information |
| CN107169862A (en) * | 2017-05-25 | 2017-09-15 | 中国建设银行股份有限公司辽宁省分行 | A kind of bad customer deposit automatic tracking system of bank |
| CN108279036A (en) * | 2017-12-12 | 2018-07-13 | 北京卫星制造厂 | A kind of integrated detection system |
| CN109684400A (en) * | 2018-12-29 | 2019-04-26 | 国网江苏省电力有限公司 | A method of the master data management automation based on RPA finance robot |
| US20190155225A1 (en) * | 2017-11-21 | 2019-05-23 | Accenture Global Solutions Limited | Bot management framework for robotic process automation systems |
| CN110060479A (en) * | 2019-05-10 | 2019-07-26 | 厦门路桥信息股份有限公司 | Traffic integrated cloud platform system and information processing method |
| CN110096553A (en) * | 2019-03-28 | 2019-08-06 | 北京华成智云软件股份有限公司 | A kind of the big data analysis system and analysis method of integration across database |
| CN110458350A (en) * | 2019-08-06 | 2019-11-15 | 中国铁道科学研究院集团有限公司电子计算技术研究所 | Infrastructure service platform construction method, device and the electronic equipment of railway traffic system |
| CN210006201U (en) * | 2019-05-10 | 2020-01-31 | 厦门路桥信息股份有限公司 | Traffic cloud platform system |
| CN110956510A (en) * | 2019-12-30 | 2020-04-03 | 深圳爱莫科技有限公司 | Automatic tobacco marketing RPA method and system |
| CN110995870A (en) * | 2019-12-23 | 2020-04-10 | 江苏电力信息技术有限公司 | Unstructured data management method based on RPA robot |
| CN111324440A (en) * | 2020-02-17 | 2020-06-23 | 深圳前海微众银行股份有限公司 | Method, device and equipment for executing automation process and readable storage medium |
-
2020
- 2020-09-07 CN CN202010928254.5A patent/CN112199424A/en active Pending
Patent Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110282508A1 (en) * | 2010-05-12 | 2011-11-17 | Alstom Grid | Generalized grid security framework |
| CN102521686A (en) * | 2011-11-30 | 2012-06-27 | 陕西东显永益机电技术有限公司 | Examining and approving management system for administrative information |
| CN107169862A (en) * | 2017-05-25 | 2017-09-15 | 中国建设银行股份有限公司辽宁省分行 | A kind of bad customer deposit automatic tracking system of bank |
| US20190155225A1 (en) * | 2017-11-21 | 2019-05-23 | Accenture Global Solutions Limited | Bot management framework for robotic process automation systems |
| CN108279036A (en) * | 2017-12-12 | 2018-07-13 | 北京卫星制造厂 | A kind of integrated detection system |
| CN109684400A (en) * | 2018-12-29 | 2019-04-26 | 国网江苏省电力有限公司 | A method of the master data management automation based on RPA finance robot |
| CN110096553A (en) * | 2019-03-28 | 2019-08-06 | 北京华成智云软件股份有限公司 | A kind of the big data analysis system and analysis method of integration across database |
| CN110060479A (en) * | 2019-05-10 | 2019-07-26 | 厦门路桥信息股份有限公司 | Traffic integrated cloud platform system and information processing method |
| CN210006201U (en) * | 2019-05-10 | 2020-01-31 | 厦门路桥信息股份有限公司 | Traffic cloud platform system |
| CN110458350A (en) * | 2019-08-06 | 2019-11-15 | 中国铁道科学研究院集团有限公司电子计算技术研究所 | Infrastructure service platform construction method, device and the electronic equipment of railway traffic system |
| CN110995870A (en) * | 2019-12-23 | 2020-04-10 | 江苏电力信息技术有限公司 | Unstructured data management method based on RPA robot |
| CN110956510A (en) * | 2019-12-30 | 2020-04-03 | 深圳爱莫科技有限公司 | Automatic tobacco marketing RPA method and system |
| CN111324440A (en) * | 2020-02-17 | 2020-06-23 | 深圳前海微众银行股份有限公司 | Method, device and equipment for executing automation process and readable storage medium |
Non-Patent Citations (4)
| Title |
|---|
| 张 琳: "基于RPA 状态流转的规建维优基站健康自评估系统", 《通信电源技术》, vol. 37, no. 9 * |
| 王吉伟: "数据孤岛成数字化转型最大拦路虎，看RPA如何让企业数据流转自如", pages 3, Retrieved from the Internet <URL:https://zhuanlan.zhihu.com/p/59034887?utm_oi=786717341600858112&utm_id=0> * |
| 琰珉: "阿里云RPA（机器人流程自动化）干货系列之一：认识RPA（上）", Retrieved from the Internet <URL:https://zhuanlan.zhihu.com/p/92336643> * |
| 琰珉: "阿里云RPA（机器人流程自动化）干货系列之三：阿里云RPA介绍", Retrieved from the Internet <URL:https://zhuanlan.zhihu.com/p/59257772> * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20130007749A1 (en) | Method and apparatus for managing a working task based on a communication message | |
| CN114036183A (en) | Data ETL processing method, device, equipment and medium | |
| CN114443854A (en) | Processing method and device of multi-source heterogeneous data, computer equipment and storage medium | |
| CN114556317A (en) | Document tracking through version hash link graphs | |
| US11113267B2 (en) | Enforcing path consistency in graph database path query evaluation | |
| WO2023123182A1 (en) | Multi-source heterogeneous data processing method and apparatus, computer device and storage medium | |
| US10885013B2 (en) | Automated application lifecycle tracking using batch processing | |
| CN107122961A (en) | Excel nested report data processing methods based on SAP system | |
| US10360208B2 (en) | Method and system of process reconstruction | |
| CN104268194A (en) | Method for dynamically generating public opinion brief report | |
| JP2018018323A (en) | Distributed processing management method, distributed processing management program, and distributed processing management device | |
| CN110704635B (en) | Method and device for converting triplet data in knowledge graph | |
| CN117055859A (en) | Low-code development system based on data flow analysis | |
| CN112199424A (en) | Method for pulling communication information island through RPA, readable storage medium and RPA robot | |
| CN114895875B (en) | Zero-code visual information system metadata production application method and system | |
| CN115169891B (en) | Method for realizing workflow engine comprising multi-start-point multi-branch flow | |
| CN116010380A (en) | Data warehouse automatic management method based on visual modeling | |
| CN104731597A (en) | Method for applying SQL statements to engineering software compiling platform | |
| JP3994854B2 (en) | Data mapping rule reuse device, method, and program in electronic catalog conversion system | |
| Iftekhar et al. | Reverse engineering of relational database schema to UML Model | |
| CN113569543A (en) | Implementation method of nuclear power engineering automatic report generation technology | |
| CN116126873B (en) | Data summarization method and device based on nonstandard data table and storage medium | |
| US20220101238A1 (en) | Computer implemented method of capturing and processing data from user activities in business processes and a computer program to implement this method | |
| CN110515913B (en) | Log processing method and device | |
| CN115983736B (en) | Master-slave relation-based master data modeling method |
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 |