CN111611230A - Method and device for establishing main data system, computer equipment and storage medium - Google Patents
Method and device for establishing main data system, computer equipment and storage medium Download PDFInfo
- Publication number
- CN111611230A CN111611230A CN202010620847.5A CN202010620847A CN111611230A CN 111611230 A CN111611230 A CN 111611230A CN 202010620847 A CN202010620847 A CN 202010620847A CN 111611230 A CN111611230 A CN 111611230A
- Authority
- CN
- China
- Prior art keywords
- main data
- data
- management system
- master data
- master
- 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/21—Design, administration or maintenance of databases
- G06F16/219—Managing data history or versioning
-
- 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/23—Updating
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a method and a device for establishing a main data system, computer equipment and a storage medium, wherein the method comprises the following steps: acquiring metadata of target main data, wherein the metadata is used for describing data attributes of the target main data; generating a main data model of the target main data according to the metadata; and establishing a master data management system according to the master data model. The metadata can be used for supporting functions such as storage position indication, historical data, resource searching, file recording and the like, a main data model is generated by using the metadata of the target main data, and then a main data management system is generated through the main data model, so that the main data is managed from the source, the complete life cycle of the data is managed, and the effectiveness of main data management is improved.
Description
Technical Field
The present invention relates to the field of data management technologies, and in particular, to a method and an apparatus for establishing a master data system, a computer device, and a storage medium.
Background
Primary data is data that is shared among computer systems. Sharing is a key word, and an example of the classic master data is a client, and the client is a project center of MDM (master data management), while it is understood that there are other various master data, such as product data, location, asset, employee, etc., which are related to each other, for example, a company sells a product, the client purchases a product, the product may be sold by a retailer, a product is sold from a specific retailer, or a wholesaler may sell the product, and the client continues to resell the product as a new retailer, so that not only the data of the client, the data of the product, but also the data of the location, and other related data are managed. From a reporting or dimensional modeling perspective, primary data refers to a dimension or hierarchy based on its organizational or configuration metrics, rather than the actual situation or its own measurements. For example, revenue, cost, and profit are real situations, while time, location, customers, and suppliers are dimensions.
The traditional main data management system focuses on maintenance and sharing of main data, and the main data establishment process and the main data management function are insufficient, for example, in ERP (enterprise resource planning), main data management generally imports the main data into the system through excel through a basic dictionary management mode, and does not have the function of the main data establishment process.
Disclosure of Invention
The embodiment of the invention can provide a method and a device for establishing a main data system for effectively establishing main data, computer equipment and a storage medium.
In order to solve the above technical problem, the embodiment of the present invention adopts a technical solution that: a method for establishing a master data system is provided, which comprises the following steps:
acquiring metadata of target main data, wherein the metadata is used for describing data attributes of the target main data;
generating a main data model of the target main data according to the metadata;
and establishing a master data management system according to the master data model.
Optionally, after the master data management system is built according to the master data model, the method includes:
acquiring a coding rule of target main data;
generating a main data code according to the coding rule;
and recording the main data codes into the main data management system.
Optionally, after the master data management system is built according to the master data model, the method includes:
comparing the target main data to generate a comparison result;
generating mapping relation data of the target main data according to the comparison result;
and recording the mapping relation data into the main data management system.
Optionally, after the master data management system is built according to the master data model, the method includes:
acquiring maintenance operation information of the main data management system;
generating updating record information according to the maintenance operation information;
and inputting the updating record information into the main data management system, and updating the main data version in the main data management system.
Optionally, after the entering of the update record information into the master data management system and the updating of the master data version in the master data management system, the method includes:
acquiring a version returning operation of the main data management system;
and returning the main data version according to the version returning operation and the updating record information.
Optionally, after the entering of the update record information into the master data management system and the updating of the master data version in the master data management system, the method includes:
acquiring push subscription information, wherein the push subscription information comprises interface information of an application system for receiving update information;
and sending the updated record information to the application system according to the pushed subscription information and a preset time interval.
Optionally, after the master data management system is built according to the master data model, the method includes:
acquiring non-standard main data, wherein the non-standard main data is main data generated by a system other than the main data management system;
checking and screening the non-standard main data to generate screened main data;
and importing the screened main data into the main data management system.
In order to solve the foregoing technical problem, an embodiment of the present invention further provides an apparatus for establishing a master data system, including:
the system comprises an acquisition module, a storage module and a processing module, wherein the acquisition module is used for acquiring metadata of target main data, and the metadata is used for describing data attributes of the target main data;
the processing module is used for generating a main data model of the target main data according to the metadata;
and the execution module is used for establishing a master data management system according to the master data model.
Optionally, the apparatus for establishing a master data system further includes:
the first obtaining submodule is used for obtaining the coding rule of the target main data;
the first generation submodule is used for generating a main data code according to the coding rule;
and the first entry submodule is used for entering the main data code into the main data management system.
Optionally, the apparatus for establishing a master data system further includes:
the first comparison submodule is used for comparing the target main data to generate a comparison result;
the second generation submodule is used for generating mapping relation data of the target main data according to the comparison result;
and the second recording submodule is used for recording the mapping relation data into the main data management system.
Optionally, the apparatus for establishing a master data system further includes:
the second acquisition submodule is used for acquiring the maintenance operation information of the main data management system;
the third generation submodule is used for generating updating record information according to the maintenance operation information;
and the first execution submodule is used for inputting the updating record information into the main data management system and updating the main data version in the main data management system.
Optionally, the apparatus for establishing a master data system further includes:
a third obtaining submodule, configured to obtain a version rollback operation of the master data management system;
and the second execution submodule is used for retreating the main data version according to the version retreating operation and the updating record information.
Optionally, the apparatus for establishing a master data system further includes:
the fourth obtaining submodule is used for obtaining push subscription information, wherein the push subscription information comprises interface information of an application system used for receiving update information;
and the first sending submodule is used for sending the updated record information to the application system according to the pushed subscription information and a preset time interval.
Optionally, the apparatus for establishing a master data system further includes:
a fifth obtaining sub-module, configured to obtain non-standard main data, where the non-standard main data is main data generated by a system other than the main data management system;
the first screening submodule is used for checking and screening the non-standard main data to generate screened main data;
and the first import submodule is used for importing the screened main data into the main data management system.
In order to solve the above technical problem, an embodiment of the present invention further provides a computer device, including a memory and a processor, where the memory stores computer readable instructions, and the computer readable instructions, when executed by the processor, cause the processor to execute the steps of the method for establishing the master data system.
To solve the above technical problem, an embodiment of the present invention further provides a storage medium storing computer-readable instructions, which, when executed by one or more processors, cause the one or more processors to execute the steps of the method for establishing a master data system.
The embodiment of the invention has the beneficial effects that: the metadata can be used for supporting functions such as storage position indication, historical data, resource searching, file recording and the like, a main data model is generated by using the metadata of the target main data, and then a main data management system is generated through the main data model, so that the main data is managed from the source, the complete life cycle of the data is managed, and the effectiveness of main data management is improved.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
FIG. 1 is a schematic diagram of a basic flow chart of a method for establishing a master data system according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of generating and entering main data codes according to an embodiment of the present invention;
FIG. 3 is a schematic flow chart illustrating a process of generating and entering a mapping relationship according to an embodiment of the present invention;
FIG. 4 is a flowchart illustrating a process of updating a primary data version according to an embodiment of the present invention;
FIG. 5 is a flowchart illustrating a version rollback according to an embodiment of the present invention;
FIG. 6 is a flowchart illustrating a process of pushing update information according to an embodiment of the present invention;
FIG. 7 is a flowchart illustrating an embodiment of importing master data from other systems;
FIG. 8 is a block diagram of the basic structure of the setup device of the main data system according to the embodiment of the present invention;
FIG. 9 is a block diagram of the basic structure of a computer device according to an embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, 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.
In some of the flows described in the present specification and claims and in the above figures, a number of operations are included that occur in a particular order, but it should be clearly understood that these operations may be performed out of order or in parallel as they occur herein, with the order of the operations being indicated as 101, 102, etc. merely to distinguish between the various operations, and the order of the operations by themselves does not represent any order of performance. Additionally, the flows may include more or fewer operations, and the operations may be performed sequentially or in parallel. It should be noted that, the descriptions of "first", "second", etc. in this document are used for distinguishing different messages, devices, modules, etc., and do not represent a sequential order, nor limit the types of "first" and "second" to be different.
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 any inventive step, are within the scope of the present invention.
As will be appreciated by those skilled in the art, "terminal" as used herein includes both devices that are wireless signal receivers, devices that have only wireless signal receivers without transmit capability, and devices that include receive and transmit hardware, devices that have receive and transmit hardware capable of performing two-way communication over a two-way communication link. Such a device may include: a cellular or other communication device having a single line display or a multi-line display or a cellular or other communication device without a multi-line display; PCS (personal communications service), which may combine voice, data processing, facsimile and/or data communications capabilities; a PDA (personal digital assistant), which may include a radio frequency receiver, a pager, internet/intranet access, web browser, notepad, calendar and/or GPS (global positioning system) receiver; a conventional laptop and/or palmtop computer or other device having and/or including a radio frequency receiver. As used herein, a "terminal" or "terminal device" may be portable, transportable, installed in a vehicle (aeronautical, maritime, and/or land-based), or situated and/or configured to operate locally and/or in a distributed fashion at any other location(s) on earth and/or in space. As used herein, a "terminal device" may also be a communication terminal, a web terminal, a music/video playing terminal, such as a PDA, an MID (mobile internet device), and/or a mobile phone with music/video playing function, and may also be a smart tv, a set-top box, and the like.
Specifically, referring to fig. 1, fig. 1 is a basic flow chart illustrating a method for establishing a master data system according to the present embodiment.
As shown in fig. 1, a method for establishing a master data system includes:
s1100, acquiring metadata of target main data, wherein the metadata is used for describing data attributes of the target main data;
the target master data is data required for establishing a master data management system, such as, but not limited to, key facts of customers, products, employees, regions, etc. for describing core business entities, and data relationships between the facts. The metadata can be used for supporting functions such as indicating storage positions, historical data, resource searching, file recording and the like, when a master data management system needs to be established, the metadata of a physical storage structure of target master data is defined and identified, and service metadata of a service view angle of the target master data is defined and maintained, for example, a value range of a service field in the master data, setting of other quoted master data and the like, so that the metadata of the target master data is obtained.
S1200, generating a main data model of the target main data according to the metadata;
and generating a target main data model according to the main data represented by the metadata and the relationship between the main data, wherein the main data model is used for intuitively expressing the relationship between the main data, such as three relationships of independence, tree cards and data tables, but not limited to the three relationships. In some embodiments, a set of master data model templates may be defined, and other users may initialize or establish their own master data models according to the templates, thereby achieving the effect of quickly establishing the master data models. The other users may be users other than the user who establishes the master data management system, for example, after the master data management system is established, when a subsequently added provider or a partner needs to generate the master data model and add the master data model to the master data management system, the added provider or partner is the other users; other users can also be other users needing to establish the master data management system, and the template can be used for quickly establishing a corresponding master data model, so that the own master data management system is established.
S1300, establishing a master data management system according to the master data model;
after the master data model is established, data inspection is performed on the target master data, including but not limited to deduplication inspection, similarity contrast scheme setting, similarity calculation and inspection, for example, duplicate master data is deleted or merged, master data with higher similarity is merged, and the like, automatic matching is performed according to rules, and manual audit can be performed if necessary. And then establishing a relation between main data according to the main data model to form a main data management system, displaying the data in a service model manner, and performing various maintenance operations.
As shown in fig. 2, step S1300 is followed by:
s1410, obtaining a coding rule of the target main data;
the system is provided with a main data encoding rule, after the main data management system is generated, or when new main data needs to be entered into the main data management system, the encoding rule of the main data is acquired, the encoding rule is a rule for sequentially generating corresponding codes for different types of main data, for example, the client 1 is encoded as a1, the client 2 is encoded as a2, the product 1 is encoded as B1, the product 2 is encoded as B2, and the like, but is not limited thereto. Different encoding modes can be set for different main data types, or the same set of encoding modes is used, and a set of encoding modes corresponding to all types of main data contained in the target main data is used as an encoding rule.
S1420, generating a main data code according to the coding rule;
after the coding rule is obtained, all the main data in the main data management system and the main data needing to be recorded into the main data management system are coded, and corresponding main data codes are generated. In some embodiments, the code is checked when the main data code is generated, whether the generated code is used in the system is determined, when the newly generated code is used, a new code is generated according to the coding rule, and the checking process is repeated until the generated code is not used, and the generated code is used as the main data code corresponding to the main data.
S1430, the main data codes are recorded into the main data management system;
and inputting the generated main data codes into a main data management system, and matching the main data codes with corresponding main data.
By setting the main data code, the data query basis can be provided when the main data management and maintenance are carried out, and the information such as the type of the main data can be visually embodied through the code, so that the efficiency of the main data management and maintenance is improved.
As shown in fig. 3, step S1300 is followed by:
s1510, comparing the target main data to generate a comparison result;
comparing each data contained in the target main data to generate a comparison result, wherein the comparison result includes but is not limited to similar data, identical data, associated data, upper and lower data and the like, when other main data need to be recorded into the main data management system, the main data which need to be recorded also need to be compared, or the main data which need to be recorded is compared with the main data in the system to generate the comparison result.
S1520, generating mapping relation data of the target main data according to the comparison result;
and determining the incidence relation between the target main data according to the comparison result to generate the mapping relation of the target main data, and integrating all the mapping relations to form mapping relation data. The mapping relationship is used to describe the mapping relationship between the main data, including but not limited to the same, similar, related, and upper and lower bit relationships, etc.
S1530, recording the mapping relation data into the main data management system;
and inputting the generated mapping relation data into the master data management system, linking corresponding data in the master data management system, and expressing the relation between the master data, for example, the employee a is an employee of the enterprise B, the enterprise B produces a product C, and the like, but not limited thereto.
By establishing the mapping relation between the main data, the main data in the system forms a network, more associated information can be provided when the main data is managed, maintained or shared, the effectiveness of main data entry is ensured, and the efficiency of main data management is improved.
As shown in fig. 4, step S1300 is followed by:
s1610, obtaining maintenance operation information of the main data management system;
the system user can make master data queries, modify settings and controls. When a user performs operations such as modification setting on main data in the system, corresponding maintenance operation information is generated, for example, field modification, mapping relationship modification or other attribute modification is performed on the main data X. In some embodiments, queries may be controlled to the primary data specific field level and modifications may be controlled to the button level.
S1620, generating updating record information according to the maintenance operation information;
after the maintenance operation information of the user on the main data is obtained, corresponding update record information is generated according to the maintenance operation information, for example, the maintenance operation information of the user includes that the name of the main data X is changed from a to B, that is, the update record information records the modification process, that is, the name of X is changed from a to B. In some embodiments, the update record information may include information of an operation user, time information of the operation, and the like, so as to facilitate tracing the maintenance operation. In some embodiments, the modification and maintenance of the main data can be performed only after the approval of the workflow, and the main data update record information is regenerated after the approval.
S1630, recording the updating record information into the main data management system, and updating the main data version in the main data management system;
and inputting the updating record information into the main data management system to record the data maintenance history in the system, and updating the main data content in the main data management system according to the maintenance operation, thereby updating the main data version. In some embodiments, a storage area for storing the update record is provided in the system, and the update record information in the system is written to the storage area in time series.
As shown in fig. 5, step S1630 is followed by:
s1631, obtaining a version returning operation of the main data management system;
the system user can perform a rollback operation on the main data version according to the update record information in the main data management system, for example, the user can search the update record of each main data content, each update record has a plurality of update versions, the user can select a version to rollback according to the update record, and when the user selects the version to rollback, the record is the version rollback operation including the selected version information, the rollback time, the operation user and the like.
S1632, returning the main data version according to the version returning operation and the updating record information;
and obtaining the update record information of the corresponding version according to the version return information of the user, returning the version of the main data according to the update content in the update record information, and returning the corresponding main data to the version before the corresponding update record information. In some embodiments, the rollback operation requires an audit, which passes before the version rollback occurs.
Through setting the function that the version was returned, the user can be convenient for operate when carrying out the mistake update to the master data or the master data need be traced back, need not update once more to the master data, makes the master data management more convenient.
As shown in fig. 6, step S1630 is followed by:
s1633, acquiring push subscription information, wherein the push subscription information includes interface information of an application system for receiving update information;
the system is provided with an application system for receiving the update information, the application system can comprise an application program and can also be a specified terminal, such as a mobile phone, the application system is used for receiving and managing the information of data update in the main data management system, and the interface information in the application system is input into the main data management system and is used as push subscription information.
S1634, sending the updated record information to the application system according to the pushed subscription information and a preset time interval;
the system is provided with a certain push rule, which may be to send update record information to the application system at regular time intervals (e.g., 1 hour), in some embodiments, different time intervals may be set for different application systems, for example, a terminal that needs to pay attention to data update frequently may set a shorter time interval to find update information of data in time, and an application system that monitors and maintains main data for a long time may set a longer time interval to reduce the sending frequency of information. And pushing the information to a corresponding application system according to the interface information when the update record information needs to be pushed according to the push subscription information.
By setting the pushing mode of the update information, the management party can effectively acquire the update condition of the main data in the system, so that the update of the main data is monitored, and the management and maintenance efficiency of the main data is improved.
As shown in fig. 7, step S1300 is followed by:
s1710, acquiring non-standard main data, wherein the non-standard main data is main data generated by a system except the main data management system;
when the master data generated by a system other than the master data management system needs to be entered into the master data management system, the corresponding master data is acquired and used as non-standard master data, for example, an excle import, a webservice mode upload, a data etl tool import, a restfullhttp write, or the like, but is not limited thereto.
S1720, checking and screening the non-standard main data to generate screened main data;
and comparing the acquired non-standard main data with the main data in the main data management system, checking, removing the content which is the same as, similar to or conflicted with the main data in the main data management system, screening the main data, and obtaining the screened main data.
S1730, importing the screened main data into the main data management system;
and importing the screened main data into a main data management system, and establishing a mapping relation with the main data in the system.
In order to solve the above technical problem, an embodiment of the present invention further provides an apparatus for establishing a master data system. Referring to fig. 8, fig. 8 is a block diagram of a basic structure of a setup device for implementing a main data system.
As shown in fig. 8, the apparatus for establishing a master data system includes: an acquisition module 2100, a processing module 2200, and an execution module 2300. The acquisition module is used for acquiring metadata of target main data, wherein the metadata is used for describing data attributes of the target main data; the processing module is used for generating a main data model of the target main data according to the metadata; and the execution module is used for establishing a main data management system according to the main data model.
The metadata can be used for supporting functions such as storage position indication, historical data, resource searching, file recording and the like, a main data model is generated by using the metadata of the target main data, and then a main data management system is generated through the main data model, so that the main data is managed from the source, the complete life cycle of the data is managed, and the effectiveness of main data management is improved.
In some embodiments, the establishing means of the master data system further comprises: the system comprises a first acquisition sub-module, a first generation sub-module and a first entry sub-module. The first obtaining submodule is used for obtaining the coding rule of the target main data; the first generation submodule is used for generating a main data code according to the coding rule; the first entry submodule is used for entering the main data code into the main data management system.
In some embodiments, the establishing means of the master data system further comprises: the system comprises a first comparison submodule, a second generation submodule and a second entry submodule. The first comparison submodule is used for comparing the target main data to generate a comparison result; the second generation submodule is used for generating mapping relation data of the target main data according to the comparison result; and the second recording submodule is used for recording the mapping relation data into the main data management system.
In some embodiments, the establishing means of the master data system further comprises: the device comprises a second acquisition submodule, a third generation submodule and a first execution submodule. The second obtaining submodule is used for obtaining maintenance operation information of the main data management system; the third generation submodule is used for generating updating record information according to the maintenance operation information; and the first execution submodule is used for inputting the updating record information into the main data management system and updating the main data version in the main data management system.
In some embodiments, the establishing means of the master data system further comprises: a third obtaining submodule and a second executing submodule. The third obtaining submodule is used for obtaining the version returning operation of the main data management system; and the second execution submodule is used for returning the main data version according to the version returning operation and the updating record information.
In some embodiments, the establishing means of the master data system further comprises: a fourth obtaining submodule and a first sending submodule. The fourth obtaining submodule is used for obtaining push subscription information, wherein the push subscription information comprises interface information of an application system used for receiving update information; and the first sending submodule is used for sending the updated record information to the application system according to the pushed subscription information and a preset time interval.
In some embodiments, the establishing means of the master data system further comprises: the device comprises a fifth obtaining submodule, a first screening submodule and a first leading-in submodule. The fifth obtaining submodule is used for obtaining non-standard main data, wherein the non-standard main data is main data generated by a system except the main data management system; the first screening submodule is used for checking and screening the non-standard main data to generate screened main data; the first import submodule is used for importing the screened main data into the main data management system.
In order to solve the above technical problem, an embodiment of the present invention further provides a computer device. Referring to fig. 9, fig. 9 is a block diagram of a basic structure of a computer device according to the present embodiment.
As shown in fig. 9, the internal structure of the computer device is schematically illustrated. As shown in fig. 9, the computer apparatus includes a processor, a nonvolatile storage medium, a memory, and a network interface connected through a system bus. The non-volatile storage medium of the computer device stores an operating system, a database and computer readable instructions, the database can store control information sequences, and the computer readable instructions can enable the processor to realize the establishment method of the main data system when being executed by the processor. The processor of the computer device is used for providing calculation and control capability and supporting the operation of the whole computer device. The memory of the computer device may have stored therein computer readable instructions that, when executed by the processor, cause the processor to perform a method of establishing a master data system. The network interface of the computer device is used for connecting and communicating with the terminal. It will be appreciated by those skilled in the art that the configurations shown in the figures are block diagrams of only some of the configurations relevant to the present application, and do not constitute a limitation on the computing devices to which the present application may be applied, and that a particular computing device may include more or less components than those shown in the figures, or may combine certain components, or have a different arrangement of components.
In this embodiment, the processor is configured to execute specific functions of the obtaining module 2100, the processing module 2200, and the executing module 2300 in fig. 8, and the memory stores program codes and various data required for executing the modules. The network interface is used for data transmission to and from a user terminal or a server. The memory in this embodiment stores program codes and data necessary for executing all the submodules in the setup device of the main data system, and the server can call the program codes and data of the server to execute the functions of all the submodules.
The present invention also provides a storage medium storing computer-readable instructions, which when executed by one or more processors, cause the one or more processors to perform the steps of the method for establishing a master data system according to any of the above embodiments.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a computer-readable storage medium, and can include the processes of the embodiments of the methods described above when the computer program is executed. The storage medium may be a non-volatile storage medium such as a magnetic disk, an optical disk, a Read-only memory (ROM), or a Random Access Memory (RAM).
It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and may be performed in other orders unless explicitly stated herein. Moreover, at least a portion of the steps in the flow chart of the figure may include multiple sub-steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, which are not necessarily performed in sequence, but may be performed alternately or alternately with other steps or at least a portion of the sub-steps or stages of other steps.
The technical features of the embodiments described above may be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the embodiments described above are not described, but should be considered as being within the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A method for establishing a master data system, comprising:
acquiring metadata of target main data, wherein the metadata is used for describing data attributes of the target main data;
generating a main data model of the target main data according to the metadata;
and establishing a master data management system according to the master data model.
2. The method of building a master data system according to claim 1, wherein after building a master data management system according to the master data model, comprising:
acquiring a coding rule of target main data;
generating a main data code according to the coding rule;
and recording the main data codes into the main data management system.
3. The method of building a master data system according to claim 1, wherein after building a master data management system according to the master data model, comprising:
comparing the target main data to generate a comparison result;
generating mapping relation data of the target main data according to the comparison result;
and recording the mapping relation data into the main data management system.
4. The method of building a master data system according to claim 1, wherein after building a master data management system according to the master data model, comprising:
acquiring maintenance operation information of the main data management system;
generating updating record information according to the maintenance operation information;
and inputting the updating record information into the main data management system, and updating the main data version in the main data management system.
5. The method for establishing a master data system according to claim 4, wherein after entering the update record information into the master data management system and updating the master data version in the master data management system, the method comprises:
acquiring a version returning operation of the main data management system;
and returning the main data version according to the version returning operation and the updating record information.
6. The method for establishing a master data system according to claim 4, wherein after entering the update record information into the master data management system and updating the master data version in the master data management system, the method comprises:
acquiring push subscription information, wherein the push subscription information comprises interface information of an application system for receiving update information;
and sending the updated record information to the application system according to the pushed subscription information and a preset time interval.
7. The method of building a master data system according to claim 1, wherein after building a master data management system according to the master data model, comprising:
acquiring non-standard main data, wherein the non-standard main data is main data generated by a system other than the main data management system;
checking and screening the non-standard main data to generate screened main data;
and importing the screened main data into the main data management system.
8. An apparatus for establishing a master data system, comprising:
the system comprises an acquisition module, a storage module and a processing module, wherein the acquisition module is used for acquiring metadata of target main data, and the metadata is used for describing data attributes of the target main data;
the processing module is used for generating a main data model of the target main data according to the metadata;
and the execution module is used for establishing a master data management system according to the master data model.
9. A computer device, comprising:
a processor;
a memory for storing processor-executable instructions;
wherein the processor is configured to perform the method of establishing a master data system of any of the preceding claims 1-7.
10. A non-transitory computer readable storage medium having instructions which, when executed by a processor of a mobile terminal, enable the mobile terminal to perform a method of establishing a master data system, the method comprising the method of establishing a master data system according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010620847.5A CN111611230A (en) | 2020-06-30 | 2020-06-30 | Method and device for establishing main data system, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010620847.5A CN111611230A (en) | 2020-06-30 | 2020-06-30 | Method and device for establishing main data system, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111611230A true CN111611230A (en) | 2020-09-01 |
Family
ID=72204792
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010620847.5A Pending CN111611230A (en) | 2020-06-30 | 2020-06-30 | Method and device for establishing main data system, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111611230A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112506916A (en) * | 2020-10-29 | 2021-03-16 | 望海康信(北京)科技股份公司 | Main data processing method and system, corresponding computer equipment and storage medium |
| CN112667603A (en) * | 2020-12-31 | 2021-04-16 | 萨孚凯信息系统(无锡)有限公司 | Data management system and management method for data and service fusion |
Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH06168173A (en) * | 1992-11-27 | 1994-06-14 | Hitachi Ltd | Data base managing method and network system |
| US20020169777A1 (en) * | 2001-03-15 | 2002-11-14 | Liviu Balajel | Database architecture and method |
| US20040117377A1 (en) * | 2002-10-16 | 2004-06-17 | Gerd Moser | Master data access |
| WO2007081666A2 (en) * | 2006-01-03 | 2007-07-19 | Siperian, Inc. | Relationship data management |
| US20100088334A1 (en) * | 2008-10-06 | 2010-04-08 | Teradata Us, Inc. | Hierarchy manager for master data management |
| US20120246110A1 (en) * | 2011-03-22 | 2012-09-27 | Sap Ag | Master Data Management in a Data Warehouse/Data Mart |
| CN103729742A (en) * | 2014-01-06 | 2014-04-16 | 中国南方电网有限责任公司 | Data resource management system based on SOA framework and model drive framework |
| CN103729460A (en) * | 2014-01-10 | 2014-04-16 | 中国南方电网有限责任公司 | Graphical data model managing method and system based on metadata |
| US20150317297A1 (en) * | 2014-05-05 | 2015-11-05 | Prasath Nayanar Chandrasekaran | System and method for managing data and data models |
| CN106126634A (en) * | 2016-06-22 | 2016-11-16 | 武汉斗鱼网络科技有限公司 | A kind of master data duplicate removal treatment method based on live industry and system |
| WO2017021186A1 (en) * | 2015-08-03 | 2017-02-09 | Philip Morris Products S.A. | A computerized database management system |
| US20170344618A1 (en) * | 2010-12-23 | 2017-11-30 | Eliot Horowitz | Systems and methods for managing distributed database deployments |
| US20180032434A1 (en) * | 2016-07-27 | 2018-02-01 | Sap Se | Master database synchronization for multiple applications |
| US20180113843A1 (en) * | 2016-10-21 | 2018-04-26 | Sap Se | Visual preview based on analytical metadata |
| CN108829746A (en) * | 2018-05-24 | 2018-11-16 | 青岛海信网络科技股份有限公司 | A kind of master data management system and device of database based on memory |
| CN110888878A (en) * | 2019-11-15 | 2020-03-17 | 国家电投集团科学技术研究院有限公司 | Service-oriented main data management method and system |
-
2020
- 2020-06-30 CN CN202010620847.5A patent/CN111611230A/en active Pending
Patent Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH06168173A (en) * | 1992-11-27 | 1994-06-14 | Hitachi Ltd | Data base managing method and network system |
| US20020169777A1 (en) * | 2001-03-15 | 2002-11-14 | Liviu Balajel | Database architecture and method |
| US20040117377A1 (en) * | 2002-10-16 | 2004-06-17 | Gerd Moser | Master data access |
| WO2007081666A2 (en) * | 2006-01-03 | 2007-07-19 | Siperian, Inc. | Relationship data management |
| US20100088334A1 (en) * | 2008-10-06 | 2010-04-08 | Teradata Us, Inc. | Hierarchy manager for master data management |
| US20170344618A1 (en) * | 2010-12-23 | 2017-11-30 | Eliot Horowitz | Systems and methods for managing distributed database deployments |
| US20120246110A1 (en) * | 2011-03-22 | 2012-09-27 | Sap Ag | Master Data Management in a Data Warehouse/Data Mart |
| CN103729742A (en) * | 2014-01-06 | 2014-04-16 | 中国南方电网有限责任公司 | Data resource management system based on SOA framework and model drive framework |
| CN103729460A (en) * | 2014-01-10 | 2014-04-16 | 中国南方电网有限责任公司 | Graphical data model managing method and system based on metadata |
| US20150317297A1 (en) * | 2014-05-05 | 2015-11-05 | Prasath Nayanar Chandrasekaran | System and method for managing data and data models |
| WO2017021186A1 (en) * | 2015-08-03 | 2017-02-09 | Philip Morris Products S.A. | A computerized database management system |
| CN106126634A (en) * | 2016-06-22 | 2016-11-16 | 武汉斗鱼网络科技有限公司 | A kind of master data duplicate removal treatment method based on live industry and system |
| US20180032434A1 (en) * | 2016-07-27 | 2018-02-01 | Sap Se | Master database synchronization for multiple applications |
| US20180113843A1 (en) * | 2016-10-21 | 2018-04-26 | Sap Se | Visual preview based on analytical metadata |
| CN108829746A (en) * | 2018-05-24 | 2018-11-16 | 青岛海信网络科技股份有限公司 | A kind of master data management system and device of database based on memory |
| CN110888878A (en) * | 2019-11-15 | 2020-03-17 | 国家电投集团科学技术研究院有限公司 | Service-oriented main data management method and system |
Non-Patent Citations (1)
| Title |
|---|
| LEN SILVERSTON，PAUL AGNEW: "《数据模型资源手册 卷3 数据模型通用模式》", 北京：知识产权出版社 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112506916A (en) * | 2020-10-29 | 2021-03-16 | 望海康信(北京)科技股份公司 | Main data processing method and system, corresponding computer equipment and storage medium |
| CN112506916B (en) * | 2020-10-29 | 2024-04-09 | 望海康信(北京)科技股份公司 | Main data processing method, system, corresponding computer equipment and storage medium |
| CN112667603A (en) * | 2020-12-31 | 2021-04-16 | 萨孚凯信息系统(无锡)有限公司 | Data management system and management method for data and service fusion |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112199433A (en) | Data management system for city-level data middling station | |
| CN102541998A (en) | Business intelligence and report storyboarding | |
| US11281568B2 (en) | Automation of enterprise software inventory and testing | |
| CN111611230A (en) | Method and device for establishing main data system, computer equipment and storage medium | |
| CN113868498A (en) | Data storage method, electronic device, device and readable storage medium | |
| CN113408668A (en) | Decision tree construction method and device based on federated learning system and electronic equipment | |
| CN110879808B (en) | Information processing method and device | |
| CN117035687A (en) | Power grid business fixed asset process configuration method, system and computer storage medium | |
| CN106156904B (en) | Cross-platform virtual asset tracing method based on eID | |
| CN117493333A (en) | Data archiving method and device, electronic equipment and storage medium | |
| CN116303628A (en) | Alarm data query method, system and equipment based on elastic search | |
| CN116719799A (en) | Environment-friendly data management method, device, computer equipment and storage medium | |
| CN116414854A (en) | Data asset query method, device, computer equipment and storage medium | |
| CN108073624B (en) | Service data processing system and method | |
| CN113934729A (en) | Data management method based on knowledge graph, related equipment and medium | |
| CN114860819A (en) | Method, device, equipment and storage medium for constructing business intelligent system | |
| CN114356945A (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN114791968A (en) | Processing method, device and system for graph calculation and computer readable medium | |
| CN114168581A (en) | Data cleaning method and device, computer equipment and storage medium | |
| CN114564621A (en) | Method, device and equipment for associating data and readable storage medium | |
| CN115017185A (en) | Data processing method, device and storage medium | |
| CN112685557A (en) | Visualized information resource management method and device | |
| CN112860725A (en) | SQL automatic generation method and device, storage medium and electronic equipment | |
| CN112817938A (en) | General data service construction method and system based on data productization | |
| CN111582799B (en) | Method and device for constructing object portrait |
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 |