CN116126958A - Multi-source data unified integrated operation intelligent contract system - Google Patents
Multi-source data unified integrated operation intelligent contract system Download PDFInfo
- Publication number
- CN116126958A CN116126958A CN202310116535.4A CN202310116535A CN116126958A CN 116126958 A CN116126958 A CN 116126958A CN 202310116535 A CN202310116535 A CN 202310116535A CN 116126958 A CN116126958 A CN 116126958A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- module
- intelligent contract
- multiparty
- 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
- 238000007405 data analysis Methods 0.000 claims abstract description 12
- 238000004364 calculation method Methods 0.000 claims abstract description 11
- 238000004458 analytical method Methods 0.000 claims abstract description 10
- 238000000034 method Methods 0.000 claims description 14
- 238000007726 management method Methods 0.000 claims description 13
- 238000013500 data storage Methods 0.000 claims description 8
- 230000008569 process Effects 0.000 claims description 8
- 238000006243 chemical reaction Methods 0.000 claims description 6
- 230000004927 fusion Effects 0.000 abstract description 6
- 238000011068 loading method Methods 0.000 description 7
- 239000003999 initiator Substances 0.000 description 4
- 230000007246 mechanism Effects 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- WGZDBVOTUVNQFP-UHFFFAOYSA-N N-(1-phthalazinylamino)carbamic acid ethyl ester Chemical compound C1=CC=C2C(NNC(=O)OCC)=NN=CC2=C1 WGZDBVOTUVNQFP-UHFFFAOYSA-N 0.000 description 2
- 238000013528 artificial neural network Methods 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 239000011159 matrix material Substances 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 230000002776 aggregation Effects 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000018109 developmental process Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 239000002096 quantum dot Substances 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 230000011218 segmentation Effects 0.000 description 1
- 238000012549 training Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
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
- G06F16/256—Integrating or interfacing systems involving database management systems in federated or virtual databases
-
- 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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- 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)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an intelligent contract system for unified integrated operation of multi-source data; comprising the following steps: the system comprises a database connection module, a data query acquisition module and a data analysis management module; the database connection module is used for connecting with the multiparty database; the data query acquisition module is used for querying and acquiring target data in the multiparty database through the database connection module; and the data analysis management module is used for carrying out combination calculation on the acquired target data to obtain an analysis result. The system can realize the fusion of the data of different databases and promote the interconnection and intercommunication of the data.
Description
Technical Field
The invention belongs to the technical field of integrated operation, and particularly relates to an intelligent contract system for unified integrated operation of multi-source data.
Background
The current large data enterprises face the problems of data integration, data analysis and the like in the environments of increasing enterprise data volume and increasing data patterns. In order to enable rapid development, enterprises often continuously start new databases and new compiling platforms for rapidly realizing short-term project achievements. This results in many data being present in different databases, different data platforms (e.g., mySQL, postgreSQL, oracle, SQL Server, etc.), which is difficult for enterprises to uniformly apply due to the cross-platform heterogeneity. Therefore, there is a need to propose a standardized data management intelligent contract that integrates target data from different database engines of an enterprise for analysis.
Patent CN114706919a discloses a storage compatible system of a distributed storage data storage compatible method, which comprises a management end container, a service end container and a CEPH/MINIO object storage, wherein the management end container and the service end container interact through an s1 protocol; the server container interacts with the CEPH/MINIO object store via the s2 protocol. But this patent addresses the problem of distributed storage of data and does not address the problem of data fusion of different databases.
Patent multiparty data processing method, system and electronic device; and storage media (CN 1142922 a) disclosing the acquisition of respective data sets and computation operators by the initiator and the participant, respectively; carrying out data segmentation on the data set according to a data cutting function in the computation operator to obtain a sub-data set, distributing the sub-data set to each computation slave node of the method, and executing corresponding computation logic according to the computation operator by each computation slave node; the initiator calculates the slave node and calculates the corresponding calculation data that the slave node provides according to each participant to obtain the calculation result, and send the calculation result to the initiator and calculate the master node; and the initiator computing master node performs data aggregation on the computing result according to the computing operator to obtain aggregated data, so that the problem of low multiparty computing efficiency is solved. However, the patent aims at carrying out distributed storage and collection on the data being generated, solves the problems of safety and integrity of the data, and does not relate to the fusion problem of different databases.
Patent "multiparty data comparison method based on blockchain, electronic device and storage medium (CN 114238510A)" discloses that by constructing a blockchain network with at least two identical participants, encrypted private data of any two participants are compared according to preset comparison rules to obtain the size relationship of the private data of the two participants; sharing the size relation of the two participants to other participants through corresponding intelligent contracts; after the other participants share the size relationship of the two participants, the encrypted private data of the other participants are sequentially compared with the large participant and the small participant, and the multiparty data comparison result of all the participants is determined according to the large participant and the small participant after the comparison is completed. The invention mainly aims to complete data comparison through a block chain and a preset comparison rule so as to solve the problem that data leakage is easy to cause in the data comparison process. However, the patent solves the problem of comparing the sizes of the data stored in the block chain after encryption, and does not solve the problem of comparing the data of different databases.
Patent "a multiparty data joint analysis system, method, apparatus and medium (CN 114707159 a)" discloses that a user node is configured to obtain a target task, determine first data and second data required for completing the target task, send the target task to a computing node, and send a request for obtaining the second data to a second mechanism of a plurality of other mechanisms; the data node is used for receiving a request for acquiring first data sent by the computing node, acquiring the first data from a local storage unit of the first mechanism, encrypting the first data to obtain first ciphertext data, and sending the first ciphertext data to the computing node; the computing node is used for receiving the first ciphertext data sent by the data node and the second ciphertext data sent by the second mechanism, and performing privacy computation on the first ciphertext data and the second ciphertext data to obtain a computing result. However, the patent mainly solves the data security problem of data encryption calculation, calculates the data step by step after dividing the data, and finally gathers the data into a final result, and also does not relate to the data operation problem of different databases.
Patent CN114615279A discloses that an access terminal stores a hash value of an access address where data is located into a standby chain, and the hash value is stored on the standby chain as an index of collaborative data; the standby chain returns a corresponding data address to the access terminal, and the access terminal stores the data, the hash value of the data and the data address on the standby chain; the access terminal and the client terminal mutually identify the access address and the access key, and the access terminal encrypts the password through the public key when the password is transmitted; and 3, performing cross-link data collaboration among the three parties to complete effective cross-link data collaboration and improve the collaboration of data information. The multi-party collaboration data communication method and device can achieve multi-party collaboration data communication, improve the integrity and safety of the data communication, and improve the management efficiency of multi-party collaboration. The patent relates to the problem of secure transfer and acquisition of data, ensures the security and integrity of the data through the use of data hash, and does not relate to the problem of data use of databases of different types.
Patent "a quantum data loading method, apparatus, device and readable storage medium (CN 11469288A)" discloses that when a data loading request is received, a data loading matrix is obtained according to data to be loaded; carrying out quantum gate disassembly according to the data loading matrix to obtain a basic quantum gate circuit; and accessing the basic quantum gate circuit into a quantum computing circuit to finish quantum data loading. By implementing the quantum data loading method disclosed by the invention, each quantum bit is mutually coupled through the combination of basic quantum gates, then the quantum data is connected into a quantum computing circuit, and the quantum bits are controlled from the bottom physical angle to keep the special coherence in the computing process; the quantum neural network is accessed, so that the training efficiency and the noise resistance of the quantum neural network can be improved. However, the patent belongs to a new data calculation way, and the data calculation result is obtained by loading data into quantum operators and performing quantum calculation, so that the data use of different types of databases is not involved.
The patent "method, apparatus, remote platform and electronic device for data synchronization service" (CN 115510166 a) discloses that when data interface information is obtained, data to be synchronized is identified, the location of the data field, the hash value of the data field and the data field are changed by sending a data change message to the remote platform, and the data information to be data synchronized is sent to the remote platform through a corresponding data synchronization interface. But the patent is mainly directed to data change and synchronization operations, and does not relate to the problem of data unification of different types of databases.
It can be seen that the prior art is directed to data manipulation of a single type of database, involving counterpart data, and also based on data correlation in the case where the data storage environment and the data type are identical. Many enterprises currently carry out digital transformation and construct industrial Internet, and a plurality of database systems are various and non-uniform before, and the problems of extracting and uniformly using data of different database platforms are faced in the process of accessing a uniform platform.
Therefore, how to realize the fusion of the data of different databases and promote the interconnection of the data becomes a key problem of the current research.
Disclosure of Invention
In view of the above problems, the present invention provides a multi-source data unified integrated operation intelligent contract system which at least solves some of the above technical problems, and the system can realize the fusion of data of different databases and promote the interconnection and intercommunication of the data.
The embodiment of the invention provides a multisource data unified integrated operation intelligent contract system, which comprises the following components: the system comprises a database connection module, a data query acquisition module and a data analysis management module;
the database connection module is used for connecting with a multiparty database;
the data query acquisition module is used for querying and acquiring target data in the multiparty database through the database connection module;
the data analysis management module is used for carrying out combination calculation on the obtained target data to obtain an analysis result.
Further, the system also comprises an address acquisition module;
the address acquisition module is used for acquiring the login address and the password of the multiparty database and sending the login address and the password to the database connection module.
Further, the data query acquisition module further comprises a data storage submodule and a data format conversion submodule;
the data storage sub-module is used for storing the target data to the position appointed by the intelligent contract and recording the stored process;
the data format conversion sub-module is used for converting the target data into an XML document format.
Further, the data analysis management module further comprises a result storage sub-module;
and the result storage module is used for storing the analysis result.
Further, the database connection module is connected with the multiparty database through JDBC.
Further, the multiparty database includes a MySql database, an Oracle database, an SqlServer database, and a PostgreSQL database.
Compared with the prior art, the intelligent contract system for unified integrated operation of the multi-source data has the following beneficial effects:
1. the invention promotes the interconnection and intercommunication of the data by fusing the data of different databases.
2. According to the invention, the requirements of the realization scene on the data are recorded in the related operation process, the tracing of the data is realized, the quality analysis is improved, and a foundation is provided for the subsequent data resource transaction.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims thereof as well as the appended drawings.
The technical scheme of the invention is further described in detail through the drawings and the embodiments.
Drawings
The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate the invention and together with the embodiments of the invention, serve to explain the invention. In the drawings:
fig. 1 is a schematic diagram of a multi-source data unified integrated operation intelligent contract system framework according to an embodiment of the present invention.
Detailed Description
Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
Referring to fig. 1, an embodiment of the present invention provides a multi-source data unified integrated operation intelligent contract system, including: the system comprises an address acquisition module, a database connection module, a data query acquisition module and a data analysis management module; wherein:
the address acquisition module is used for acquiring login addresses and passwords of the multiparty database, and the information can be provided by a database management party; the address acquisition module sends the login address and the password to the database connection module, so that the connection between the database connection module and the multiparty database is facilitated; the multiparty databases comprise a MySql database, an Oracle database, an SqlServer database, a PostgreSQL database and the like.
The database connection module is used for connecting with the multiparty database; in the embodiment of the invention, the driver programs of databases such as MySQL, postgreSQL, oracle and SQL Server are specifically configured and connected through JDBC (Java Data Base Connectivity, java database connection), and the connection modes are as follows:
(1) Connect MySql database: connection
conn DriverManager.getConnection("jdbc:mysql://host:port/database",
"user","password")；
(2) Connect Oracle database: connection
conn DriverManager.getConnection("jdbc:oracle:thin:@host:port:database",
"user","password")；
(3) Connecting an SqlServer database: connection
conn DriverManager.getConnection("jdbc:microsoft:sqlserver://host:port；D
atabaseName＝database","user","password")；
(4) Connect PostgreSQL database: connection
conn DriverManager.getConnection("jdbc:postgresql://host:port；DatabaseN
ame＝database","user","password")；
After the application requirement is met and the target data is determined, the data query acquisition module is used for querying and acquiring the target data in the multiparty database through the database connection module; specifically, the data query acquisition module configures data acquisition SQL according to storage information of the target data, and queries and acquires the target data through an interface correspondingly connected with a database; the data query acquisition module also comprises a data storage submodule and a data format conversion submodule; the data storage sub-module is used for storing target data to the position appointed by the intelligent contract, and recording the storage process, so that the follow-up check is facilitated; the data format conversion submodule is used for converting target data into an XML document format, and is convenient for a subsequent data analysis management module to calculate.
The data analysis management module is used for carrying out combination calculation on the acquired target data to obtain an analysis result, and recording the whole data use flow to realize data fusion of different database platforms.
The intelligent contract completes the unified data acquisition and analysis process, stores the recorded result, and waits for the next contract generation and execution after the contract execution is completed.
The embodiment of the invention provides a multisource data unified integrated operation intelligent contract system, which is used for obtaining needed data through connection of different databases, processing, combining and calculating the data through a unified XML document format and realizing unified use operation of the data from different sources. The data of different databases are fused through the intelligent contracts, and interconnection and intercommunication of the data are promoted.
It will be apparent to those skilled in the art that various modifications and variations can be made to the present invention without departing from the spirit or scope of the invention. Thus, it is intended that the present invention also include such modifications and alterations insofar as they come within the scope of the appended claims or the equivalents thereof.
Claims (6)
1. A multi-source data unified integrated operation intelligent contract system, comprising: the system comprises a database connection module, a data query acquisition module and a data analysis management module;
the database connection module is used for connecting with a multiparty database;
the data query acquisition module is used for querying and acquiring target data in the multiparty database through the database connection module;
the data analysis management module is used for carrying out combination calculation on the obtained target data to obtain an analysis result.
2. The multi-source data unified computing intelligent contract system according to claim 1 further comprising an address acquisition module;
the address acquisition module is used for acquiring the login address and the password of the multiparty database and sending the login address and the password to the database connection module.
3. The multi-source data unified computing intelligent contract system according to claim 1, wherein the data query acquisition module further comprises a data storage sub-module and a data format conversion sub-module;
the data storage sub-module is used for storing the target data to the position appointed by the intelligent contract and recording the stored process;
the data format conversion sub-module is used for converting the target data into an XML document format.
4. The multi-source data unified computing intelligent contract system according to claim 1 wherein said data analysis management module further comprises a result storage sub-module;
and the result storage module is used for storing the analysis result.
5. The system of claim 1, wherein the database connection module is configured to connect to the multi-party database via JDBC.
6. The multi-source data unified integrated computing intelligent contract system according to claim 1 wherein the multi-party databases comprise a MySql database, an Oracle database, a SqlServer database, and a PostgreSQL database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310116535.4A CN116126958A (en) | 2023-02-09 | 2023-02-09 | Multi-source data unified integrated operation intelligent contract system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310116535.4A CN116126958A (en) | 2023-02-09 | 2023-02-09 | Multi-source data unified integrated operation intelligent contract system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116126958A true CN116126958A (en) | 2023-05-16 |
Family
ID=86309870
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310116535.4A Pending CN116126958A (en) | 2023-02-09 | 2023-02-09 | Multi-source data unified integrated operation intelligent contract system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116126958A (en) |
-
2023
- 2023-02-09 CN CN202310116535.4A patent/CN116126958A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2020140679A1 (en) | Interface docking method and apparatus, computer device and storage medium | |
| CN106776780B (en) | Data exchange and sharing method and system in cloud environment | |
| CN112036886B (en) | Block chain-based power big data exchange method and system | |
| US20020035482A1 (en) | Business to business information environment with subscriber-publisher model | |
| CN112307501B (en) | Big data system based on block chain technology, storage method and using method | |
| WO2010139167A1 (en) | Expert support application system platform for government affair and business affair decision-making and its construction method | |
| CN112183765B (en) | Multi-source multi-modal data preprocessing method and system for shared learning | |
| KR20210014702A (en) | Method, device and computer program product for encryption key management in group-based communication system | |
| CN110322678B (en) | Block chain based four-table centralized reading system and method | |
| CN109377220B (en) | Block chain-based media data transaction method and system and computer storage medium | |
| Zhang et al. | Research on government information sharing model using blockchain technology | |
| CN106845075A (en) | One kind concentrates diagnosis report system | |
| CN107229872A (en) | It is a kind of to separate storage query logic and the private data guard method of segment data | |
| CN113129149A (en) | Transaction risk identification method and device based on block chain and safe multi-party calculation | |
| CN108734023B (en) | System and method for accessing and integrating ciphertext database system | |
| CN114244851B (en) | Block chain-based data distribution method | |
| CN114880715A (en) | Power data security sharing method and system based on homomorphic encryption intelligent contract | |
| CN114742239A (en) | Financial insurance claim risk model training method and device based on federal learning | |
| CN111476666B (en) | Asset interaction information tracing method and device based on block chain | |
| CN113315753A (en) | Block data credibility recovery method based on coding technology | |
| CN113011960A (en) | Block chain-based data access method, device, medium and electronic equipment | |
| CN116126958A (en) | Multi-source data unified integrated operation intelligent contract system | |
| Lu et al. | Research on agricultural internet of things data sharing system based on blockchain | |
| CN113537990A (en) | National house asset management system based on block chain | |
| CN115934832A (en) | Metering test detection data credible sharing method based on block chain |
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 | ||
| CB03 | Change of inventor or designer information | ||
| CB03 | Change of inventor or designer information |
Inventor after: Li Jiang Inventor after: Dong Jin Inventor after: Huang Jin Inventor after: Shi Xin Inventor after: Zheng Hongwei Inventor after: Ren Changrui Inventor before: Li Jiang Inventor before: Dong Jin Inventor before: Huang Jin Inventor before: Shi Xin Inventor before: Zheng Hongwei |