CN113239010A - Data model management and control system based on DDM - Google Patents
Data model management and control system based on DDM Download PDFInfo
- Publication number
- CN113239010A CN113239010A CN202110481442.2A CN202110481442A CN113239010A CN 113239010 A CN113239010 A CN 113239010A CN 202110481442 A CN202110481442 A CN 202110481442A CN 113239010 A CN113239010 A CN 113239010A
- Authority
- CN
- China
- Prior art keywords
- model
- database
- data
- client
- management module
- 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/21—Design, administration or maintenance of 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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
-
- 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/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- 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
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)
- Computing Systems (AREA)
- Computer And Data Communications (AREA)
Abstract
The invention relates to a data model management and control system based on DDM (distributed data model), which comprises a client, a model server, a data management module and a database, wherein the model server is used for storing data; the client is electrically connected with the model server and the data management module in a bidirectional mode, the model server is electrically connected with the data management module in a bidirectional mode, and the output end of the model server and the output end of the data management module are electrically connected with the input end of the database. The model server and the data management module are communicated with each other at the background of the DDM, the client and the model server are interacted with each other at the foreground and the background, the data management module provides the browsing and displaying functions of the client and the management of a data standard platform and a metadata platform, the model server builds a bridge for the data management module and the client and is responsible for exchanging data of the data management module and the client and the storage and the management of model data, and the client is responsible for connecting the model server to sign in and sign out the data model and synchronously operate the data standard in the DDM.
Description
Technical Field
The invention relates to the field of data models, in particular to a data model management and control system based on DDM.
Background
DDM (Datablau Data modeler) is used as a Data modeling design tool, and helps enterprises to understand and manage Data islands by automatically extracting Data models of relational, NoSQL and ERP Data sources. The database is designed by visually drawing an ER graph. Applying data criteria to the database design. Data modeling supporting multi-person collaboration shares data models across departments. Meanwhile, the consistency between the actual database and the data model is periodically monitored, the brand new design of the Chinese interface of the management database is more suitable for the current situation and the use habit of domestic enterprises, the current client cannot be completely responsible for exchanging the data of the actual database and the data of the model, the model server cannot sign in and sign out the data model, and cannot perform synchronous operation of the data standard.
In the prior art, chinese patent CN106850848A discloses "a clone code semantic detection method based on deep learning", which is published as 2017, 06, and 13 days, and discloses a data management implementation method and a data management platform based on a data management platform, wherein the method includes: the data management platform receives task distribution information sent by the task distribution terminal; distributing the tasks to be processed to task receiving terminal users according to the user information; receiving a task receiving terminal user to receive a task to be processed; receiving a task processing result returned by a task receiving terminal corresponding to a task receiving terminal user; the task processing result is sent to a task distribution terminal user corresponding to the task distribution terminal for auditing, and an auditing result obtained by auditing the task processing result returned by the task distribution terminal is received; and when the audit result of the task processing result is determined to be qualified, recording the task processing result into a database for storage. In the scheme, the data management mode is to issue tasks to the terminal users, then the terminal users return the tasks and store the tasks in the database, data model systematization processing is not established, and data standards cannot be formed.
Disclosure of Invention
The invention provides a data model control system based on DDM (distributed data model) for solving the technical defect that a model server cannot perform synchronous signing-in and signing-out operation of a data model.
In order to realize the purpose, the technical scheme is as follows:
a data model management and control system based on DDM comprises a client, a model server, a data management module and a database; the client is electrically connected with the model server and the data management module in a bidirectional mode, the model server is electrically connected with the data management module in a bidirectional mode, and the output end of the model server and the output end of the data management module are electrically connected with the input end of the database.
In the scheme, the model server and the data management module are communicated in the background of the DDM, the client and the model server perform foreground and background interaction, the data management module provides browsing and display functions of the client, and management of a data standard platform and a metadata platform, the model server builds a bridge for the data management module and the client and is responsible for exchanging data of the data management module and the client and storing and managing model data, and the client is responsible for connecting the model server to perform sign-in and sign-out of a data model and synchronous operation of a data standard in the DDM.
The data model is a better data dictionary, which supports service semantics upwards and implements physical data downwards, and it contains not only the data dictionary, but also the topic of the service, the main object of the service, the data relationship, and the mapping of the data standard. Therefore, the application of the model and the tool thereof is not only an important mark for judging whether the enterprise data management is mature, but also an important support for data standard target falling.
Preferably, the client comprises a data modeling client and a model management client, and both the data modeling client and the model management client are electrically connected with the model server in a bidirectional mode.
Preferably, the client further comprises a web end, and the web end is electrically connected with the model server and the data management module in a bidirectional manner.
Preferably, the database comprises a development database and a production database, the output end of the model server is electrically connected with the input end of the development database and the input end of the production database, and the output end of the data management module is electrically connected with the input end of the production database.
Preferably, the development database comprises a development sub-database and a test sub-database, and the output end of the model server is electrically connected with the input end of the development sub-database and the input end of the test sub-database.
Preferably, the production database includes a model database, a platform database, an OLTP database and an OLAP database, the output end of the model server is electrically connected to the input end of the model database, and the output end of the data management module is electrically connected to the input end of the platform database, the input end of the OLTP database and the input end of the OLAP database.
Preferably, the model database is an Oracle Mysql model database.
Preferably, the platform database is an Oracle Mysql platform database.
Preferably, the model server and the data management module are electrically connected in a bidirectional manner through a network port.
Preferably, the network port is provided with a firewall.
In the scheme, the data management module is used for providing enterprise-level data standards, standard codes and naming specifications; obtaining a model file on a model server and providing a web browsing model function; and acquiring application information of a data standard in the model on the model server and displaying the model label-falling statistical condition through a web.
The model server is used for sharing the data model stored on the model base to the data management platform and providing the web-side browsing of the model; providing the application condition of the data standard in the data model for the standard application statistics in the statistical model of the data management platform; and acquiring a public data standard, a standard code and a naming standard of the data management platform and synchronizing the public data standard, the standard code and the naming standard by the client.
The client is used for realizing sign-in and sign-out of the data model after being connected with the model library; applications that implement data standards, code, and naming conventions.
Compared with the prior art, the invention has the beneficial effects that:
the invention provides a data model management and control system based on DDM (distributed data management), wherein a model server and a data management module are communicated at the background, and a client and the model server are interacted at the foreground and the background, wherein the data management module provides the browsing and display functions of the client and the management of a data standard platform and a metadata platform, the model server is a bridge built between the data management module and the client and is responsible for exchanging data of the data management module and the client and storing and managing the model data, and the client is responsible for connecting the model server to sign in and sign out a data model and synchronously operate the data standard.
Drawings
FIG. 1 is a block diagram of the present invention.
Detailed Description
The drawings are for illustrative purposes only and are not to be construed as limiting the patent;
the invention is further illustrated below with reference to the figures and examples.
Example 1
As shown in fig. 1, a data model management and control system based on DDM includes a client, a model server, a data management module, and a database; the client is electrically connected with the model server and the data management module in a bidirectional mode, the model server is electrically connected with the data management module in a bidirectional mode, and the output end of the model server and the output end of the data management module are electrically connected with the input end of the database.
In the scheme, the model server and the data management module are communicated at the background, the client and the model server are interacted at the foreground and the background, the data management module provides the browsing and displaying functions of the client, the management of the data standard platform and the metadata platform, the model server builds a bridge for the data management module and the client and is responsible for exchanging data of the data management module and the client and storing and managing the model data, and the client is responsible for connecting the model server to sign in and sign out the data model and synchronously operating the data standard.
Preferably, the client comprises a data modeling client and a model management client, and both the data modeling client and the model management client are electrically connected with the model server in a bidirectional mode.
Preferably, the client further comprises a web end, and the web end is electrically connected with the model server and the data management module in a bidirectional manner.
Preferably, the database comprises a development database and a production database, the output end of the model server is electrically connected with the input end of the development database and the input end of the production database, and the output end of the data management module is electrically connected with the input end of the production database.
Preferably, the development database comprises a development sub-database and a test sub-database, and the output end of the model server is electrically connected with the input end of the development sub-database and the input end of the test sub-database.
Preferably, the production database includes a model database, a platform database, an OLTP database and an OLAP database, the output end of the model server is electrically connected to the input end of the model database, and the output end of the data management module is electrically connected to the input end of the platform database, the input end of the OLTP database and the input end of the OLAP database.
Preferably, the model database is an Oracle Mysql model database.
Preferably, the platform database is an Oracle Mysql platform database.
Preferably, the model server and the data management module are electrically connected in a bidirectional manner through a network port.
Preferably, the network port is provided with a firewall.
Example 2
The data management module is used for providing enterprise-level data standards, standard codes and naming specifications; obtaining a model file on a model server and providing a web browsing model function; and acquiring application information of a data standard in the model on the model server and displaying the model label-falling statistical condition through a web.
The model server is used for sharing the data model stored on the model base to the data management platform and providing the web-side browsing of the model; providing the application condition of the data standard in the data model for the standard application statistics in the statistical model of the data management platform; and acquiring a public data standard, a standard code and a naming standard of the data management platform and synchronizing the public data standard, the standard code and the naming standard by the client.
The client is used for realizing sign-in and sign-out of the data model after being connected with the model library; applications that implement data standards, code, and naming conventions.
It should be understood that the above-described embodiments of the present invention are merely examples for clearly illustrating the present invention, and are not intended to limit the embodiments of the present invention. Other variations and modifications will be apparent to persons skilled in the art in light of the above description. And are neither required nor exhaustive of all embodiments. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the claims of the present invention.
Claims (10)
1. A data model management and control system based on DDM is characterized by comprising a client, a model server, a data management module and a database; the client is electrically connected with the model server and the data management module in a bidirectional mode, the model server is electrically connected with the data management module in a bidirectional mode, and the output end of the model server and the output end of the data management module are electrically connected with the input end of the database.
2. A DDM-based data model management and control system according to claim 1, wherein said client comprises a data modeling client and a model management client, both of which are bidirectionally electrically connected to said model server.
3. A DDM-based data model management and control system according to claim 2, wherein said client further comprises a web client, said web client being electrically connected to both said model server and said data management module.
4. A DDM-based data model management and control system according to claim 2, wherein said database comprises a development database and a production database, an output of said model server is electrically connected to an input of said development database and an input of said production database, and an output of said data management module is electrically connected to an input of said production database.
5. The DDM-based data model management and control system of claim 3, wherein the development database comprises a development sub-database and a test sub-database, and the output of the model server is electrically connected to both the input of the development sub-database and the input of the test sub-database.
6. A DDM-based data model management and control system as defined in claim 4, wherein said production database comprises a model database, a platform database, an OLTP database and an OLAP database, an output of said model server is electrically connected to an input of said model database, and an output of said data management module is electrically connected to an input of said platform database, an input of said OLTP database and an input of said OLAP database.
7. A DDM-based data model management and control system as defined in claim 5, wherein the model database is an Oracle Mysql model database.
8. A DDM-based data model management and control system as defined in claim 5, wherein the platform database is an Oracle Mysql platform database.
9. A DDM-based data model management and control system as defined in claim 5, wherein said model server is bi-directionally electrically connected to said data management module through a network port.
10. A DDM-based data model management and control system as defined in claim 8, wherein said network port is provided with a firewall.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110481442.2A CN113239010A (en) | 2021-04-30 | 2021-04-30 | Data model management and control system based on DDM |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110481442.2A CN113239010A (en) | 2021-04-30 | 2021-04-30 | Data model management and control system based on DDM |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113239010A true CN113239010A (en) | 2021-08-10 |
Family
ID=77131753
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110481442.2A Pending CN113239010A (en) | 2021-04-30 | 2021-04-30 | Data model management and control system based on DDM |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113239010A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170222916A1 (en) * | 2016-01-29 | 2017-08-03 | Cisco Technology, Inc. | Link Health Forecast - Predictive Ethernet Link Monitoring using DOM with ELOAM |
| CN109858926A (en) * | 2019-01-09 | 2019-06-07 | 湖北凌晖信息科技有限公司 | A kind of software Design, Inc.'s client management system |
| CN111291025A (en) * | 2020-03-10 | 2020-06-16 | 北京东方金信科技有限公司 | Method for supporting multi-physical model conversion by logic model and storage device |
-
2021
- 2021-04-30 CN CN202110481442.2A patent/CN113239010A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170222916A1 (en) * | 2016-01-29 | 2017-08-03 | Cisco Technology, Inc. | Link Health Forecast - Predictive Ethernet Link Monitoring using DOM with ELOAM |
| CN109858926A (en) * | 2019-01-09 | 2019-06-07 | 湖北凌晖信息科技有限公司 | A kind of software Design, Inc.'s client management system |
| CN111291025A (en) * | 2020-03-10 | 2020-06-16 | 北京东方金信科技有限公司 | Method for supporting multi-physical model conversion by logic model and storage device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105183860B (en) | Method of data synchronization and system | |
| CN106599104A (en) | Mass data association method based on redis cluster | |
| CN103699638A (en) | Method for realizing cross-database type synchronous data based on configuration parameters | |
| CN104599032A (en) | Distributed memory power grid construction method and system for resource management | |
| CN106294741B (en) | A kind of automated data inquiry synchronization storage system | |
| CN103092906A (en) | Multi-client generic persistence for extension nodes | |
| CN110032594B (en) | Customizable data extraction method and device for multi-source database and storage medium | |
| US8751543B2 (en) | Database view modeling using existing data model | |
| US11226982B2 (en) | Synchronization of offline instances | |
| CN108416043A (en) | Multi-platform spatial data fusion and synchronous method | |
| CN112818048A (en) | Hierarchical construction method and device of data warehouse, electronic equipment and storage medium | |
| CN101141754A (en) | Value-added service analysis and method thereof | |
| CN114218218A (en) | Data processing method, device and equipment based on data warehouse and storage medium | |
| AU2011247915A1 (en) | Enhancing an inquiry for a search of a database | |
| CN111125284A (en) | Integrated space-time big data and geographic information public service cloud platform | |
| CN109360106A (en) | Portrait construction method, system, medium and computer system | |
| CN105701220B (en) | A kind of intra-enterprise business data system and processing method | |
| CN114218291A (en) | Portrait generation method, apparatus, device and storage medium based on target object | |
| CN114595972A (en) | Smart city management method applying virtual digital people | |
| CN111680087B (en) | Main data model management platform and method | |
| CN113157795A (en) | Power grid regulation and control operation multi-source data modeling and management system suitable for mobile application | |
| CN113239010A (en) | Data model management and control system based on DDM | |
| CN108549722B (en) | Multi-platform data publishing method, system and medium | |
| CN103092841B (en) | A kind of data processing method and device | |
| CN115237924A (en) | Data processing method, system, device, medium, and program product |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210810 |
|
| RJ01 | Rejection of invention patent application after publication |