CN114281795A - Data model construction method based on service data standard table - Google Patents

Data model construction method based on service data standard table Download PDF

Info

Publication number
CN114281795A
CN114281795A CN202111384691.6A CN202111384691A CN114281795A CN 114281795 A CN114281795 A CN 114281795A CN 202111384691 A CN202111384691 A CN 202111384691A CN 114281795 A CN114281795 A CN 114281795A
Authority
CN
China
Prior art keywords
service
data
business
standard
relation
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
Application number
CN202111384691.6A
Other languages
Chinese (zh)
Inventor
蔡敬东
王增志
刘明巍
宋志伟
陈广
张柯
贺绍鹏
张萌
李志�
陈今
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Corp of China SGCC
Anhui Jiyuan Software Co Ltd
State Grid Materials Co Ltd
Original Assignee
State Grid Corp of China SGCC
Anhui Jiyuan Software Co Ltd
State Grid Materials Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by State Grid Corp of China SGCC, Anhui Jiyuan Software Co Ltd, State Grid Materials Co Ltd filed Critical State Grid Corp of China SGCC
Priority to CN202111384691.6A priority Critical patent/CN114281795A/en
Publication of CN114281795A publication Critical patent/CN114281795A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention provides a data model construction method based on a service data standard table, which comprises the following steps: step (1) formulating a service data specification; step (2), constructing a service standard information base; step (3), identifying a service standard information-source system table data logic relation, and constructing a service and data consanguinity relation dictionary; step (4) a service data model is established through a service standard information base and a service and data consanguinity relation dictionary; and (5) quickly responding to various data services, and realizing quick response of front-end requirements by depending on a business data model. The invention generates a business data model based on the business data specification, extracts the data assets from the data resources, defines the data right relationship, and is convenient for business users, data management personnel and technical personnel to efficiently develop various business data management activities such as data application, data sharing, data asset transaction, data architecture management and control and the like.

Description

Data model construction method based on service data standard table
Technical Field
The invention relates to the technical field of informatization and big data, in particular to a data model construction method based on a service data standard table.
Background
The traditional data modeling work is mainly dominated by an informatization department, generally from the technical perspective, the third paradigm modeling method is followed, so that the data directory is strong in speciality, the data relation is complicated and complicated, the source tracing is difficult, the association relation between tables is unclear, and business personnel can not understand the data base table, the data source tracing is difficult and the logic compiling is difficult.
In order to overcome the defects, the invention provides a set of method for breaking through the third paradigm constraint from the service perspective, establishes a service standard information base by formulating the service data standard, constructs a service and data logic relation dictionary with the loose coupling characteristic, really realizes the data 'business' and 'assets' and supports the service side to rapidly model through the service language which is easier to understand, trace the source of the data and efficiently develop the service data asset management and the application scene construction.
Disclosure of Invention
The technical problem to be solved by the invention is to provide a data model construction method based on a service data standard table, wherein the service data model is in a long-handle star-shaped hierarchical summary structure and is composed of a service main table and a plurality of associated auxiliary tables, service differentiation fields are distinguished through the auxiliary tables, the upper-lower level relation of entities is standardized according to service data, and the service differentiation fields are associated with other service main tables through service main foreign key IDs (IDs), so that the problems in the background art are solved.
The technical problem solved by the invention is realized by adopting the following technical scheme: a data model construction method based on a service data standard table comprises the following steps:
step (1), making a service data standard, and accurately understanding and defining uniform service standard information;
step (2), a service standard information base is established, the relation between a core service entity, attributes and a service data model service standard information table is identified, and the relation between a core public standard code and a service data model service standard coding table is identified;
step (3), identifying a service standard information-source system table data logic relation, and constructing a service and data consanguinity relation dictionary;
step (4) a service data model is established through a service standard information base and a service and data consanguinity relation dictionary;
and (5) quickly responding to various data services, and realizing quick response of front-end requirements by depending on a business data model.
In the step (1), standardization, planning, purchasing, contract, storage, distribution, quality supervision, scrapped materials, supervision, experts, suppliers and emergency service domains related to the service are decomposed layer by layer according to the mode of service domain-service process-service object-service information, and service activities are decoupled and split into minimum units through the combing of the service process and the service activities, so that core service entities, service attributes and common standard codes are abstracted.
The service data standard information base in the step (2) is created in a mode of combining top-down and bottom-up, on one hand, service application scene requirements are used as driving, and service data elements such as service entities, service attributes and public standard codes related to various application scenes are identified; on one hand, a unified service standard coding table is constructed from the global angle, induction is carried out according to the service domain, a service standard information table which is deeply matched with the service application scene requirement is constructed by each service data element in a loose coupling free combination mode, and online management is carried out through the system.
The step (2) comprises the following specific steps:
s1, identifying service basic information and service codes related to a service core entity and attributes in a service flow;
s2, designing a service standard information table and a service standard coding table, extracting service information and service codes to construct the service standard coding table and the service standard information table, and forming a service standard information base;
and S3, establishing a service data model with a long-handle star-shaped structure in a service data model layer (a middle platform sharing layer) in a layered classification manner according to the service granularity and in a mode of a summary layer and a detailed layer, and perfecting a service standard information base.
The business and data consanguinity relation dictionary in the step (3) comprises a business-data mapping relation dictionary and a data-data association relation dictionary, the business data specification information is referred, a business flow analysis method is applied to extract key business information from the business process, and the business-data mapping relation is sorted by combining the front-end operation of the business system and the corresponding relation of a background database table; meanwhile, data-data association relation is extracted from the business information forward and backward transfer relation and the database main foreign key relation in the business flow to form a data link covering the whole life cycle of the data, main body responsibility is detailed and implemented to each link of the data link, and visual management is carried out through the system and is used for supporting business data traceability, analyzing data change influence and assisting data architecture management and control.
The step (3) comprises the following specific steps:
s1, identifying a data mapping relation between a service standard information table and a source system table, including a service-data mapping relation dictionary, and completing accurate source tracing of the service standard information table;
and S2, identifying the incidence relation and the limiting conditions between source end system tables related to the service standard information table, including a data-data incidence relation dictionary, and completing the construction of a table-table incidence relation map.
The method comprises the steps of establishing a business data model main table according to business data standard business entity definition and application scene data requirements through comprehensive analysis, expanding main table information in a correlation table attaching mode in order to meet personalized information processing requirements of the same business data model in different business processes, and simultaneously combing out related main table definitions by taking business data consanguinity as venation to gradually cover the whole business process.
The step (4) comprises the following specific steps:
s1, analyzing an application scene aiming at specific services, carrying out demand analysis, and identifying a core entity, an attribute and a common standard code related to the application scene;
s2, selecting a proper service entity, a proper service attribute and a proper public standard code on line through a management tool to complete construction of a service standard information model;
and S3, automatically generating a service data model according to the service standard information base and the service and data logic relation dictionary established in the step (2) and the step (3).
Compared with the prior art, the invention has the beneficial effects that: the invention generates a business data model based on the business data specification, extracts the data assets from the data resources, defines the data right relationship, and is convenient for business users, data management personnel and technical personnel to efficiently develop various business data management activities such as data application, data sharing, data asset transaction, data architecture management and control and the like.
Drawings
FIG. 1 is a schematic flow chart of the method of the present invention.
FIG. 2 is a schematic flow chart of step (3) of the present invention.
FIG. 3 is a flow chart of the business data model construction of the present invention.
FIG. 4 is a schematic diagram of an exemplary business data model construction according to the present invention.
FIG. 5 is a diagram of a business data model application architecture of the present invention.
Fig. 6 is an example of a service data specification of the present invention.
Fig. 7 is a schematic diagram of a service data specification management page according to the present invention.
Fig. 8 is a schematic diagram of a service standard information table according to the present invention.
Fig. 9 is a schematic view of a service standard table management page according to the present invention.
FIG. 10 is a diagram of a business and data context dictionary management page according to the present invention.
FIG. 11 is a business data model management diagram of the present invention.
FIG. 12 is a diagram of a business data model physical table management page according to the present invention.
Detailed Description
In order to make the technical means, the creation features, the achievement purposes and the effects of the invention easy to understand, the invention is further described below by combining the specific drawings.
As shown in fig. 1 to 12, a data model construction method based on a service data standard table includes the following steps:
step (1), making a service data standard, and accurately understanding and defining uniform service standard information; the standardization, planning, purchasing, contract, storage, distribution, quality supervision, scrapping material, supervision, expert, supplier and emergency business domains related to the business are decomposed layer by layer according to the mode of business domain-business process-business object-business information, the business activity is decoupled and split into minimum units through the combing of the business process and the business activity, and a core business entity, business attributes and a common standard code are abstracted. According to the principle of 'unified naming, unified definition, unified rule and unified source', establishing a service data standard, and carrying out structured management through a system;
step (2), a service standard information base is established, the relation between a core service entity, attributes and a service data model service standard information table is identified, and the relation between a core public standard code and a service data model service standard coding table is identified; the service data standard information base is created in a mode of combining top-down and bottom-up, on one hand, service application scene requirements are used as driving, and service data elements such as service entities, service attributes and public standard codes related to various application scenes are identified; on one hand, a unified service standard coding table is constructed from the global angle, induction is carried out according to service domains, a service standard information table which is deeply matched with the requirements of service application scenes is constructed by each service data element in a loose coupling free combination mode, and online management is carried out through a system;
1. step (3), identifying a service standard information-source system table data logic relation, and constructing a service and data consanguinity relation dictionary;
2. the business and data consanguinity relation dictionary in the step (3) comprises a business-data mapping relation dictionary and a data-data association relation dictionary, the business data specification information is referred, a business flow analysis method is applied to extract key business information from the business process, and the business-data mapping relation is sorted by combining the front-end operation of the business system and the corresponding relation of a background database table; meanwhile, data-data association relation is extracted from the business information forward and backward transfer relation and the database main foreign key relation in the business flow to form a data link covering the whole life cycle of the data, main body responsibility is detailed and implemented to each link of the data link, and visual management is carried out through the system and is used for supporting business data traceability, analyzing data change influence and assisting data architecture management and control.
Step (4) a service data model is established through a service standard information base and a service and data consanguinity relation dictionary; and establishing a business data model main table according to business entity definition of business data specification, and expanding the main table information in a correlation table attaching mode to meet the individualized information processing requirements of the same business entity in different business processes, such as purchasing a contract business entity, adding batch type contract attached table information when the contract type is a batch contract, and adding frame protocol type contract attached table information when the contract type is a frame protocol. Meanwhile, the business data blood relationship is used as the venation to sort out the definition of the related main table, and the whole business process is gradually covered.
And (5) quickly responding to various data services, and realizing quick response of front-end requirements by depending on a business data model.
The step (2) comprises the following specific steps:
s1, identifying service basic information and service codes related to a service core entity and attributes in a service bus matrix;
and S2, designing a service standard information table and a service standard coding table, extracting service information and service codes to construct the service standard coding table and the service standard information table, and forming a service standard information base.
The step (3) comprises the following specific steps:
s1, identifying a data mapping relation between a service standard information table and a source system table, wherein the data mapping relation comprises a service-data mapping relation dictionary and a data-data association relation dictionary;
and S2, identifying the incidence relation and the limiting condition between source end system tables related to the service standard information table, and finishing the accurate tracing of the service standard information table.
The step (4) comprises the following specific steps:
s1, analyzing an application scene aiming at specific services, carrying out demand analysis, and identifying a core entity, an attribute and a common standard code related to the application scene;
s2, selecting a proper service entity, a proper service attribute and a proper public standard code on line through a management tool to complete construction of a service standard information model;
and S3, automatically generating a service data model according to the service standard information base and the service and data logic relation dictionary established in the step (2) and the step (3).
The invention can realize the data business of the source end business system based on the business data model, extract the data assets from the data resources and really realize the data assets management. And a data responsibility matrix is constructed based on the service data model, a data authority relationship is defined, and an organization guarantee is provided for data application, data security management, data asset sharing and opening, data asset transaction and data security management, so that a management foundation is laid. The data sharing and application development are carried out based on the business data model, the analysis business requirements are reported based on the business data model, the data application analysis model is settled, a data blood relationship map is formed, the problems that a data base table cannot be understood, data source tracing is difficult, logic compiling is difficult and the like are thoroughly solved, and business personnel can rapidly complete business scene construction through business languages. Cross-level data uploading and issuing are carried out based on a business data model, a data link monitoring tool is developed, cross-level full link monitoring of data is achieved, and problems are found, located and managed in time. The source end system data architecture management and control is developed based on the business data model, factors influencing business development and transformation of the source end system are quickly positioned through blood relationship analysis and influence analysis of the business data model, the source end system data architecture is reversely promoted to develop adaptive adjustment and quick iteration, and the business digital transformation development requirement is met.
The service standard code is also called reference data, which is a set of a plurality of code value pairs for standardizing the allowable value range of certain specific attributes, the specific value is represented by using the code, and the service related public standard code is uniformly defined, maintained and used for further standardizing the data.
The main key is a key attribute capable of uniquely identifying a specific business entity in the entity, and in order to simplify the entity relationship and avoid multi-key association, an ID attribute without specific business significance is usually defined as the main key, such as a person ID, a contract ID, a material ID, and the like.
The foreign key is used to refer to the attribute of other entity information, usually the main key of other entity, for example, the purchasing contract entity associates the engineering project entity by the engineering project ID to avoid directly defining the project number, project name, project unit and other attributes related to the engineering project in the purchasing contract.
The theme-oriented data application model is a modeling expression of modern intelligent data application, comprises information such as model category, name, purpose description, release unit, release time, basic data and the like, and reflects the corresponding relation between data and data application.
Service standard information table: the form created according to the business data standard specification for structured management of the logical structure of the business information, including the business definition, the business annotation …, is the basis for the subsequent creation of the business standard information base.
And (3) service process: refers to the smallest unit of activity or transaction that occurs in a business, an event that cannot be re-split, such as creating an order, browsing a web page, and so on. The behavior details generated in the business process, such as paying an order and browsing a certain web page, are finally collected into the business standard information table, and in most cases, the business standard information table focuses on a certain specific business process.
A service standard information base: classifying according to actual services and professions, and performing standard carding on service data fields with statistical analysis values to gather the service data fields into a service standard table library. According to professional classification of the business, business data with statistical analysis value is normalized from the business angle, and a set of business standard tables and a basic library of fields thereof are formed.
Business-data consanguineous relationship dictionary: and according to the service standard table library, corresponding to the field of the source end system, establishing the correspondence and incidence relation between the service standard table and the bottom table of the source end system, extracting final application data and realizing quick and accurate positioning. The foregoing shows and describes the general principles and broad features of the present invention and advantages thereof. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are described in the specification and illustrated only to illustrate the principle of the present invention, but that various changes and modifications may be made therein without departing from the spirit and scope of the present invention, which fall within the scope of the invention as claimed. The scope of the invention is defined by the appended claims and equivalents thereof.

Claims (8)

1. A data model construction method based on a service data standard table is characterized in that: the method comprises the following steps:
step (1), making a service data standard, and accurately understanding and defining uniform service standard information;
step (2), a service standard information base is established, the relation between a core service entity, attributes and a service data model service standard information table is identified, the service standard information is established by combining the requirement information of a top-down application scene and the service data specification from bottom to top in a third normal form 'degeneration' mode, and the relation between a core public standard code and a service data model service standard coding table is identified;
step (3), identifying a service standard information-source system table data logic relation, and constructing a service and data consanguinity relation dictionary;
step (4), a service data model is established through a service standard information base and a service and data consanguinity relation dictionary;
and (5) quickly responding to various data services, and realizing quick response of front-end requirements by depending on a business data model.
2. The method for constructing a data model based on a service data standard table according to claim 1, wherein: in the step (1), standardization, planning, purchasing, contract, storage, distribution, quality supervision, scrapped materials, supervision, experts, suppliers and emergency service domains related to the service are decomposed layer by layer according to the mode of service domain-service process-service object-service information, and service activities are decoupled and split into minimum units through the combing of the service process and the service activities, so that core service entities, service attributes and common standard codes are abstracted.
3. The method for constructing a data model based on a service data standard table according to claim 1, wherein: the service data standard information base in the step (2) is created in a mode of combining top-down and bottom-up, on one hand, service application scene requirements are used as driving, and service data elements such as service entities, service attributes and public standard codes related to various application scenes are identified; on one hand, a unified service standard coding table is constructed from the global angle, induction is carried out according to the service domain, a service standard information table which is deeply matched with the service application scene requirement is constructed by each service data element in a loose coupling free combination mode, and online management is carried out through the system.
4. The method for constructing a data model based on a service data standard table according to claim 3, wherein: the step (2) comprises the following specific steps:
s1, identifying service basic information and service codes related to a service core entity and attributes in a service flow;
and S2, designing a service standard information table and a service standard coding table, extracting service information and service codes to construct the service standard coding table and the service standard information table, and forming a service standard information base.
5. The method for constructing a data model based on a service data standard table according to claim 1, wherein: the business and data consanguinity relation dictionary in the step (3) comprises a business-data mapping relation dictionary and a data-data association relation dictionary, the business data specification information is referred, a business flow analysis method is applied to extract key business information from the business process, and the business-data mapping relation is sorted by combining the front-end operation of the business system and the corresponding relation of a background database table; meanwhile, data-data association relation is extracted from the business information forward and backward transfer relation and the database main foreign key relation in the business flow to form a data link covering the whole life cycle of the data, main body responsibility is detailed and implemented to each link of the data link, and visual management is carried out through the system and is used for supporting business data traceability, analyzing data change influence and assisting data architecture management and control.
6. The method for constructing a data model based on a service data standard table according to claim 5, wherein: the step (3) comprises the following specific steps:
s1, identifying a data mapping relation between a service standard information table and a source system table, wherein the data mapping relation comprises a service-data mapping relation dictionary and a data-data association relation dictionary;
and S2, identifying the incidence relation and the limiting condition between source end system tables related to the service standard information table, and finishing the accurate tracing of the service standard information table.
7. The method for constructing a data model based on a service data standard table according to claim 1, wherein: and (4) comprehensively analyzing and creating a main table of the business data model according to business entity definition and application scene data requirements of business data specification, expanding main table information in a related attached table mode in order to meet individual information processing requirements of the same business data model in different business processes, and simultaneously combing out related main table definitions by taking the business data consanguinity relationship as a venation to gradually cover the whole business process.
8. The method according to claim 7, wherein the method comprises the following steps: the step (4) comprises the following specific steps:
s1, analyzing an application scene aiming at specific services, carrying out demand analysis, and identifying a core entity, an attribute and a common standard code related to the application scene;
s2, selecting a proper service entity, a proper service attribute and a proper public standard code on line through a management tool to complete construction of a service standard information model;
and S3, automatically generating a service data model according to the service standard information base and the service and data logic relation dictionary established in the step (2) and the step (3).
CN202111384691.6A 2021-11-19 2021-11-19 Data model construction method based on service data standard table Pending CN114281795A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111384691.6A CN114281795A (en) 2021-11-19 2021-11-19 Data model construction method based on service data standard table

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111384691.6A CN114281795A (en) 2021-11-19 2021-11-19 Data model construction method based on service data standard table

Publications (1)

Publication Number Publication Date
CN114281795A true CN114281795A (en) 2022-04-05

Family

ID=80869554

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111384691.6A Pending CN114281795A (en) 2021-11-19 2021-11-19 Data model construction method based on service data standard table

Country Status (1)

Country Link
CN (1) CN114281795A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114840531A (en) * 2022-05-30 2022-08-02 中国平安财产保险股份有限公司 Data model reconstruction method, device, equipment and medium based on blood relationship
CN116383669A (en) * 2023-03-18 2023-07-04 宝钢工程技术集团有限公司 Method and system for generating factory object position number identification through data

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114840531A (en) * 2022-05-30 2022-08-02 中国平安财产保险股份有限公司 Data model reconstruction method, device, equipment and medium based on blood relationship
CN114840531B (en) * 2022-05-30 2024-05-28 中国平安财产保险股份有限公司 Data model reconstruction method, device, equipment and medium based on blood edge relation
CN116383669A (en) * 2023-03-18 2023-07-04 宝钢工程技术集团有限公司 Method and system for generating factory object position number identification through data
CN116383669B (en) * 2023-03-18 2024-04-16 宝钢工程技术集团有限公司 Method and system for generating factory object position number identification through data

Similar Documents

Publication Publication Date Title
Rosemann et al. Evaluation of workflow management systems-a meta model approach
Toval et al. Requirements reuse for improving information systems security: a practitioner’s approach
Haque et al. Towards the application of case based reasoning to decision-making in concurrent product development (concurrent engineering)
US7574379B2 (en) Method and system of using artifacts to identify elements of a component business model
WO2019096191A1 (en) Design method for xbrl standard-based master data management system
Cao et al. Flexible frameworks for actionable knowledge discovery
CN111190881A (en) Data management method and system
CN106296378A (en) Intelligence finance cloud platform system based on XBRL, construction method and service implementation method
CN101421725A (en) Method and system for linking business entities
CN110751361B (en) Bank demand entry level management method and system
CN114281795A (en) Data model construction method based on service data standard table
CN112651218A (en) Automatic generation method and management method of bidding document, medium and computer
CN111240648A (en) Intelligent management system and method for variables
CN112506892A (en) Index traceability management system based on metadata technology
Shahbaz Data mapping for data warehouse design
CN114911773B (en) Universal meta-model design method
CN111242779A (en) Financial data characteristic selection and prediction method, device, equipment and storage medium
CN115496337A (en) Data system for supporting brain of enterprise
Blanco et al. An MDA approach for developing secure OLAP applications: Metamodels and transformations
US20140149186A1 (en) Method and system of using artifacts to identify elements of a component business model
CN111427936B (en) Report generation method and device, computer equipment and storage medium
Ho et al. Applying data ming to develop a warning system of procurement in construction
CN101958893A (en) Pre-positioned business server and processing method thereof
Antonelli et al. Introducing collaborative practices in small medium enterprises
CN116701358B (en) Data processing method and system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination