Category: DA(Data Architecture) Tools

Public Data Common Standard Terminology Excel File (2020.12.10)

In this article, you can download the public data common standard term Excel file. This is data converted from the Hangul (hwp) file provided by the Ministry of Public Administration and Security into an Excel file. Data standard inspection tool v1.33 (2021-06-06) was uploaded to github and its usage was summarized on the blog. Data Standards Check Tool Description Table of Contents , Download Words, Domains, Terms If the dictionary is empty...

Data Standard Check Tool Description Contents , Download

Organize the table of contents of the description of the data standard inspection tool and upload it separately. Clicking on each table of contents will take you to that article. 1. Overview of data standard inspection tool 2. Standard inspection function and standard dictionary configuration 2.1. Standard Inspection Tool Screen Composition 2.2. Standard inspection function and option, input/output items 2.2.1. Standard check function 2.2.2. standard...

Data standard check tool_4.Attachment

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...

Data Standard Check Tool_3. Standard Check Case Results

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...

Data standard inspection tool_2.3. Data standard dictionary composition

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...

Data standard inspection tool_2.1. Screen composition, 2.2. Standard inspection function

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)...

Data standard inspection tool_1.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# Macro Description Contents , Download

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)

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...

DA# Macro(6): DA# Modeler API

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...

en_USEnglish