✅ Expanded functions of data standard management tool
The data standard management tool consists of functions responsible for management of established enterprise data standard information, support for development and maintenance according to data standards, compliance with data standards, and impact evaluation.
Recently, a system having a query function for application information, data flow information, and meta information on various data, along with the data standard management function, has been introduced and used.
Recently, in addition to the data standard management function, a meta data system having a search function for application information, data flow information, and meta information for various data has been introduced and utilized.
 |
| Data standard management tool |
❎ Feature Description
– Data model management: A function to query and change management of concepts, outlines, logic, and physical models using data standard management tools
– Data standard management: Ability to manage standard-related dictionaries such as standard words and standard domains
– Data quality management: function to diagnose and analyze data quality and manage business rules
– OLAP information management: Function to manage in conjunction with meta information implemented in the OLAP system
– User permission management: permission management function for field and IT users
– Change impact analysis: A function to analyze the overall impact of standard and model changes
– ETL information management: Management of data flow and mapping information from account system to end user
– Standard request management: Procedures and approval management function according to new and changed standards
– JOB Management: A function to manage whether the ETL program is normal or not.
– DB Schema Management: A function to manage the correspondence between the data model and the actual DB
✅ Data standards management system features
A typical data standard management system consists of data standard management, data structure management, and process management functions.
❎ Data standard management function
When defining data standards, it is composed of a function to query previously defined standards and to manage compliance with already defined data standards.
– Word Management: Transcription word dictionary and prohibited words, word dictionary management from the perspective of transcription. Dictionary definition and management of prohibited words
– Terminology management: terminology dictionary, management of standard terms defined by business, and creation of business terms by combining basic words
– Domain Management: Domain management that defines in advance data types, lengths, and lengths after decimal points for domain dictionaries, representative and group properties, etc.
– Standard code management: After deriving and managing company-wide standard codes through a code integration process from company-wide standard codes and collected codes
– Code Conversion Mapping: Conversion mapping management between source code values and standard codes
– Multi-standard management: Multi-standard management for multi-standard codes, columns, tables, domains, etc. supports multiple standards that exist in the enterprise and is integrated into enterprise standards later
❎ Data structure management function
It consists of functions required to manage the structure of the data model or load the DB schema from the source system to the repository.
– ER model structure management: structure information of models and tables: ER model management, extracting and loading data structure information from the repository
– DB Schema Management : Various DBMS, support and DB schema loading Extract and load DB catalog from various DBMS
– Variable property management: Automatic creation of model user properties and easy addition of design properties in addition to basic model properties
– History management: data model change history, configuration management support
– Model comparison management: fidelity and conformity inspection, automatic standardization inspection in data structure information, automatic inspection of compliance with standards, comparison between data structure information
❎ Process management function
It consists of business process functions that request and approve new or changed data standards or new tables related to data models.
– Standard Registration: Supports standard request process support from user requests for codes, columns, tables, domains, etc. to data manager’s approval/rejection function
– Model Registration: Request for model registration
– Process Support: Registers user requests for data models such as entities, properties, tables, and columns, and supports manager approval/rejection functions
❎ Considerations when introducing a data standard management system
When introducing a data standard management system, sufficient review should be made in terms of scalability, flexibility, and convenience of the system.
🔘 Extensibility
Examine whether it is possible to extract various data structure information such as information collection from various systems and DBMS and OLAP tools.
🔘 Flexibility
Since it is difficult to apply data standards all at once throughout the company, review whether it is possible to manage multiple standards that can use multiple integrated standards for step-by-step application, how to express Korean and English names, and the ease of standard change.
🔘 Convenience
Review user convenience, such as automatic conversion of Korean names to English names, periodic work performance function for standard verification, and minimization of manual IMPORT when collecting meta information.
Source: Korea Data Industry Promotion Agency (https://dataonair.or.kr/)https://dataonair.or.kr/
