Meta Thinking, Meta Working
This is the appendix of the data standard inspection tool. You can check the processing of the number suffix of the property name, standard word dictionary simulation method, reference information of properties subject to standard inspection, license, and VBA code. This is a continuation of the previous article. Data standard inspection tool_3.Standard inspection results by case 4. Data standard inspection tool Attachment 4.1. property name...
The results of the data standard check are divided into cases and reviewed in detail. This is a continuation of the previous article. Data standard inspection tool_2.3.Configuration of standard data dictionary 3. Results of data standard inspection If the property name of the input data matches the standard term, if there is no standard term but some or all words are combined with standard words, non-standard words Regarding the attribute names used...
This is a continuation of the previous article. Let's take a look at the data standard dictionary configuration. Data standard inspection tool_2.1. Screen composition, 2.2. Standard inspection function 2.3. Composition of data standard dictionary Data standard dictionary is the input and standard of standard inspection. A standard dictionary consists of three categories: standard words, standard terms, and standard domains. Examine each component of the standard dictionary and its relationship. 2.3.1. data...
Examine the standard data inspection tool screen composition, standard inspection function, and option input/output items. You can check the overall function of the data standard check tool. 2. Standard inspection function and standard dictionary configuration 2.1. Standard Check Tool Screen Composition The data standard check tool uses Excel VBA (Reference: Excel VBA Lecture (1): Excel VBA Overview)...
Introducing a data standard inspection tool that can be helpful to DAs (Data Architects) in the field who suffer from repetitive manual work in data standardization work. By reducing manual time, you can focus on more productive tasks and eliminate or reduce overtime. This tool was created with Excel VBA. (See: Excel VBA...
DA# Organize and upload the table of contents of the Macro description. Clicking on each table of contents will take you to that article. 1. DA# Macro Overview 1.1. Data Modeling Tool DA# 1.2. DA# API 1.2.1. Why Data Modeling Tools Need APIs 1.2.2. DA# API Concept and Object Model 1.3....
DA# Macro function demonstration video (YouTube) was created. It was not enough to explain the functions of the DA# Macro only with images and text, so a separate video was produced and simple subtitles were attached to the function to be executed. This video is a video recording the entire screen of a laptop with a resolution of 1920 × 1080. It is better to enlarge it to full screen. subtitles...
This article examines the DA# Modeler API Object Model used in DA# Macro, VBA code composition, and source code examples. 5. DA# Modeler API 5.1. DA# Modeler API Object Model In the previous article (DA# Macro(1): Overview of DA#, DA# API, DA# Macro), the DA# API Object Model...
In this article, we look at the precautions/notes for using the DA# Macro, downloads, functions to be added in the future, and notes. This is a continuation of the previous article. DA# Macro(4): DA# Macro function(3)-Reverse 3. Precautions/References for using DA# Macro 3.1. DA# Precautions for Using Macro Before executing the Set Macro for Entity/Attribute, the target...
Let's take a look at the DA# Macro Reverse function. This is a continuation of the previous article. DA# Macro(3): DA# Macro function(2)-Attribute Get/Set 2.4. DA# Macro Reverse Function 2.4.1. The reason why the DA# Macro Reverse function was created The Reverse function of the data modeling tool uses the reverse engineering technique to convert ERD form...
English 
한국어 
简体中文 
日本語 
Deutsch 
Español