CN110196875B - Method for realizing data interaction based on configuration - Google Patents
Method for realizing data interaction based on configuration Download PDFInfo
- Publication number
- CN110196875B CN110196875B CN201910476687.9A CN201910476687A CN110196875B CN 110196875 B CN110196875 B CN 110196875B CN 201910476687 A CN201910476687 A CN 201910476687A CN 110196875 B CN110196875 B CN 110196875B
- Authority
- CN
- China
- Prior art keywords
- service
- configuration
- data interaction
- interaction
- mode
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/54—Interprogram communication
- G06F9/541—Interprogram communication via adapters, e.g. between incompatible applications
-
- 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
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L69/00—Network arrangements, protocols or services independent of the application payload and not provided for in the other groups of this subclass
- H04L69/08—Protocols for interworking; Protocol conversion
-
- Y—GENERAL 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE 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/00—Energy 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 Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Computer Security & Cryptography (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for realizing data interaction based on configuration, which relates to the technical field of data interaction.
Description
Technical Field
The invention relates to data interaction, in particular to a method for realizing data interaction based on configuration.
Background
In recent years, information technology has been a supporting technology developed in various industries, and has penetrated into various aspects of life, work, management, e-commerce, learning and the like. While informationized construction achieves a favorite, more and more enterprises begin to develop more anxiety. Due to the heterogeneous and management diversity of enterprise information, the enterprise can not realize effective intercommunication of information due to independent application, and the complexity of information management is increased.
With the continuous deep information construction, the information island problem among systems is increasingly prominent, and the exchange and sharing of data information become a major problem to be solved in enterprise management. Different industries of enterprises, different management requirements, different database systems and the like have different effects on data interaction among the systems.
Based on the method, a method for realizing data interaction based on configuration is designed and developed, the method can perform unified processing on data, further realize data interaction between different systems and different databases, and provide powerful data information support for realizing management and control integration for clients.
Disclosure of Invention
Aiming at the needs and the shortcomings of the prior art development, the invention provides a method for realizing data interaction based on configuration, which uniformly processes data and realizes data interaction between different systems and different databases.
The invention discloses a method for realizing data interaction based on configuration, which solves the technical problems and adopts the following technical scheme:
a method for implementing data interaction based on configuration, the method comprising:
firstly, extracting a common flow and a processing mode of data interaction;
then, the extracted data is sent to a unified data processing platform for processing;
the unified data processing platform carries out configuration of rule parameters aiming at different systems and interaction modes, and finally data interaction between different systems and different databases is realized.
Optionally, after extracting the common flow and processing mode of data interaction, carrying out parameter configuration;
the configuration content comprises interface types, a database, a source table, an interaction mode, a receiving filtering condition SQL and a receiving filtering condition SQL in a withdrawal mode;
after the parameter configuration is completed, the parameters are sent to a unified data processing platform for processing.
Optionally, the related unified data processing platform comprises a service unit, a service program, a task table, configuration information and a platform interface;
the business unit refers to business records generated by actual business operation, the business unit can be extracted from different business systems, and the business unit can be business records such as a warehouse entry bill, a warehouse exit bill, a bill of lading and a contract;
classifying the service units by the service program;
the classified business units are stored in a business table in a form of table;
according to the configuration information, the service table sends the stored service units to the platform interface, and the platform interface outputs data of different interaction standards.
Optionally, the service table records not only the element information contained in the service unit in the form of a table, but also the association relationship of the element information contained in the service unit in the form of a table.
Optionally, the service table records the element information contained in the service unit and the association relation of the element information contained in the service unit in a two-dimensional matrix table manner;
the service table also records the description, type, primary key setting, and grouping condition setting of the element information in a two-dimensional matrix table.
Optionally, the related configuration information further includes task parameters of data interaction, a connection mode of the business unit account cover information, and a data interaction mode of the business unit.
Optionally, the connection mode of the business unit account cover information can be used for parameter configuration;
the configuration content comprises a database type, a database service name, a database login name and a database login password.
Optionally, the attributes of the data interaction criteria are:
interaction mode including send-back reading, automatic acquisition, and referencing;
whether to enable;
a transmission condition;
whether read back.
Compared with the prior art, the method for realizing data interaction based on configuration has the following beneficial effects:
1) The data interaction method comprises the steps of firstly extracting a common flow and a processing mode of data interaction, then sending extracted data to a unified data processing platform for processing, and configuring rule parameters by the unified data processing platform aiming at different systems and interaction modes to finally realize data interaction between different systems and different databases;
2) The unified data processing platform comprises a service unit, a service program, a task table, configuration information and a platform interface, wherein the service unit refers to service records generated by actual service operation, the service unit can be extracted from different service systems, the service program classifies the service units, the classified service units are stored in the service table in a form of a table, the service units stored in the service table are sent to the platform interface according to the configuration information, the platform interface outputs data of different interaction standards outwards, and the data of different interaction standards are output to different types of databases for storage, so that data interaction between different service systems and different databases is realized;
3) The data interaction method can reduce the complexity and development cost of data interaction of different systems, reduce the dependence of the data interaction on products and the influence of secondary development on projects, improve the flexibility and expandability of the system and meet the requirements of data transmission and sharing of different users;
4) The data interaction method is different from the data interaction mode realized by the traditional storage process or trigger, and improves the flexibility and interaction efficiency of data interaction.
Detailed Description
In order to make the technical solution, the technical problems to be solved and the technical effects of the present invention more apparent, the technical solution of the present invention will be clearly and completely described below in conjunction with specific embodiments, and it is apparent that the described embodiments are only some embodiments of the present invention, but not all embodiments. All embodiments obtained by a person skilled in the art without making any inventive effort are within the scope of the present invention based on the embodiments of the present invention.
Embodiment one:
the embodiment provides a method for realizing data interaction based on configuration, which comprises the following steps:
firstly, extracting a common flow and a processing mode of data interaction;
then, the extracted data is sent to a unified data processing platform for processing;
the unified data processing platform carries out configuration of rule parameters aiming at different systems and interaction modes, and finally data interaction between different systems and different databases is realized.
In this embodiment, after extracting the common flow and processing mode of data interaction, parameter configuration is performed;
the configuration content comprises interface types, a database, a source table, an interaction mode, a receiving filtering condition SQL and a receiving filtering condition SQL in a withdrawal mode;
after the parameter configuration is completed, the parameters are sent to a unified data processing platform for processing.
In this embodiment, the unified data processing platform includes a service unit, a service program, a task table, configuration information, and a platform interface;
the business unit refers to business records generated by actual business operation, the business unit can be extracted from different business systems, and the business unit can be business records such as a warehouse entry bill, a warehouse exit bill, a bill of lading and a contract;
classifying the service units by the service program;
the classified business units are stored in a business table in a form of table;
according to the configuration information, the service table sends the stored service units to the platform interface, and the platform interface outputs data of different interaction standards.
The service table records not only the element information contained in the service unit in the form of a table, but also the association relationship of the element information contained in the service unit in the form of a table. In this embodiment, the service table records the element information included in the service unit and the association relationship of the element information included in the service unit in a two-dimensional matrix table manner;
the service table also records the description, type, primary key setting, and grouping condition setting of the element information in a two-dimensional matrix table. The specific display format of the service table is shown in the following table:
table: information displayed when service units are stored in service table
In this embodiment, the configuration information further includes task parameters of data interaction, a connection mode of service unit account jacket information, and a data interaction mode of the service unit.
In this embodiment, the connection manner of the service unit account set information may perform parameter configuration;
the configuration content comprises a database type, a database service name, a database login name and a database login password.
In this embodiment, the attributes of the data interaction criteria are:
interaction mode including send-back reading, automatic acquisition, and referencing;
whether to enable;
a transmission condition;
whether read back.
The data interaction method extracts the common flow and the processing mode of data interaction, and concentrates the common flow and the processing mode on a unified data processing platform for processing, so that the data interaction between different systems and different databases is realized.
The data interaction method of the embodiment is different from the data interaction mode realized by the traditional storage process or the trigger, and improves the flexibility and interaction efficiency of data interaction.
In summary, by adopting the method for realizing data interaction based on configuration, the complexity and development cost of data interaction of different systems can be reduced, the dependence of the data interaction on products and the influence of secondary development on projects are reduced, the flexibility and expandability of the system are improved, and the requirements of data transmission and sharing of different users are met.
The foregoing describes the principles and embodiments of the present invention in detail using specific examples, which are only for aiding in understanding the core technical content of the present invention, and are not intended to limit the scope of the present invention, but the technical solutions of the present invention are not limited to the foregoing specific embodiments. Based on the above-mentioned embodiments of the present invention, any improvements and modifications made by those skilled in the art without departing from the principles of the present invention should fall within the scope of the present invention.
Claims (6)
1. A method for implementing data interaction based on configuration, the method comprising:
firstly, extracting a common flow and a processing mode of data interaction, and carrying out parameter configuration, wherein configuration content comprises interface types, a database, a source table, an interaction mode, a receiving filtering condition SQL and a receiving filtering condition SQL in a withdrawal mode;
after parameter configuration is completed, the parameters are sent to a unified data processing platform for processing, wherein the unified data processing platform comprises service units, service programs, task tables, configuration information and a platform interface, the service units refer to service records generated by actual service operation, the service programs classify the service units, the classified service units are stored in the service tables in form of tables, the service units stored in the service tables are sent to the platform interface according to the configuration information, and the platform interface outputs data of different interaction standards outwards;
the unified data processing platform carries out configuration of rule parameters aiming at different systems and interaction modes, and finally data interaction between different systems and different databases is realized.
2. The method for realizing data interaction based on configuration according to claim 1, wherein the service table records not only element information contained in the service unit in the form of a table, but also association relation of the element information contained in the service unit in the form of a table.
3. The method for realizing data interaction based on configuration according to claim 2, wherein the service table records the element information contained in the service unit and the association relation of the element information contained in the service unit in a two-dimensional matrix table manner;
the service table also records the description, type, primary key setting, and grouping condition setting of the element information in a two-dimensional matrix table.
4. The method for implementing data interaction based on configuration according to claim 1, wherein the configuration information further comprises task parameters of data interaction, a connection mode of service unit account jacket information, and a data interaction mode of service units.
5. The method for realizing data interaction based on configuration according to claim 4, wherein the connection mode of the business unit account cover information can carry out parameter configuration;
the configuration content comprises a database type, a database service name, a database login name and a database login password.
6. The method for implementing data interaction based on configuration according to claim 1, wherein the attributes of the data interaction criteria are:
interaction mode including send-back reading, automatic acquisition, and referencing;
whether to enable;
a transmission condition;
whether read back.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910476687.9A CN110196875B (en) | 2019-06-03 | 2019-06-03 | Method for realizing data interaction based on configuration |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910476687.9A CN110196875B (en) | 2019-06-03 | 2019-06-03 | Method for realizing data interaction based on configuration |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110196875A CN110196875A (en) | 2019-09-03 |
| CN110196875B true CN110196875B (en) | 2023-07-25 |
Family
ID=67753779
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910476687.9A Active CN110196875B (en) | 2019-06-03 | 2019-06-03 | Method for realizing data interaction based on configuration |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110196875B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111177632A (en) * | 2019-12-31 | 2020-05-19 | 上海商汤智能科技有限公司 | Data acquisition method and related equipment, system and storage device thereof |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102937965A (en) * | 2012-09-29 | 2013-02-20 | 山东浪潮齐鲁软件产业股份有限公司 | Meta-system design method based on data model |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8976955B2 (en) * | 2011-11-28 | 2015-03-10 | Nice-Systems Ltd. | System and method for tracking web interactions with real time analytics |
-
2019
- 2019-06-03 CN CN201910476687.9A patent/CN110196875B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102937965A (en) * | 2012-09-29 | 2013-02-20 | 山东浪潮齐鲁软件产业股份有限公司 | Meta-system design method based on data model |
Non-Patent Citations (1)
| Title |
|---|
| 用电信息采集系统多业务高效协同处理关键技术;武文广等;《智慧电力》;20171120(第11期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110196875A (en) | 2019-09-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11354314B2 (en) | Method for connecting a relational data store's meta data with hadoop | |
| CN106296378B (en) | XBRL-based intelligent financial cloud platform system, construction method and service implementation method | |
| US20190333025A1 (en) | Providing an opportunity for redundant meeting invitees to opt out | |
| US20080154927A1 (en) | Use of federation services and transformation services to perform extract, transform, and load (etl) of unstructured information and associated metadata | |
| CN108628607B (en) | Method, system and storage medium for assisting software development based on artificial intelligence | |
| CN104169914A (en) | Data storage method, data processing method, device and mobile terminal | |
| CN111723161A (en) | Data processing method, device and equipment | |
| AU2014229049A1 (en) | System and method for managing business partners and associated assets in favor of a plurality of enterprises | |
| CN110196875B (en) | Method for realizing data interaction based on configuration | |
| AU2014203425B2 (en) | Social workflow engine | |
| CN105677745B (en) | A kind of self-service data query system of Universal efficient and implementation method | |
| CN102103606A (en) | Technology for realizing advanced search of commodities on mobile phone client | |
| CN109145092B (en) | Database updating and intelligent question and answer management method, device and equipment | |
| CN116258469B (en) | Service data processing method, system, equipment and medium based on communication software | |
| CN107343111A (en) | A kind of cloud call center data management system | |
| CN202041990U (en) | Personal loan transaction platform for bank | |
| CN106557557A (en) | CMDB accord methods and device based on configuration item priority | |
| CN102855297A (en) | Method for controlling data transmission, and connector | |
| CN111368179B (en) | Method for realizing general operation prompt configuration and display control in cloud platform flow application business approval link | |
| CN105844388A (en) | Enterprise internal operation system | |
| CN114596046A (en) | Integrated platform based on unified digital model of business center station and data center station | |
| CN104915189A (en) | Customer service setting device and method and corresponding customer service system and method | |
| CN103873564A (en) | Method for realizing SignalR duplex communication under balanced load condition of multiple servers | |
| Jia | Research on the integration of marketing management and big data technology | |
| CN103176454A (en) | Clustering method and clustering system of multi-robot system |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230628 Address after: No. 1036, Shandong high tech Zone wave road, Ji'nan, Shandong Applicant after: Inspur Genersoft Co.,Ltd. Address before: 250100 No. 2877 Kehang Road, Sun Village Town, Jinan High-tech District, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |