KR-20260063052-A - DATA PREPARATION AND ANALYSIS SYSTEM HAVING WORK STEP TRACKING FUNCTION

KR20260063052AKR 20260063052 AKR20260063052 AKR 20260063052AKR-20260063052-A

Abstract

The present invention relates to a data preprocessing and analysis system equipped with a work step tracking function. In a Self Service Data Preparation (SDP) system that integrally performs the processes of data acquisition, preprocessing, and analysis, the system comprises: a dataset module that receives and stores data and distributes processed and analyzed data; a processing module that provides data in a spreadsheet type so that a user can process the data stored in the dataset module; and an analysis module that analyzes and visualizes the data processed through the processing module. The processing module is characterized by providing a work step tracking function that records work steps for each minimum processing unit of data and returns to a data processing state corresponding to the work step upon a user's request. According to the present invention, a work step tracking function is provided that returns to a data processing state corresponding to a work step upon a user's request, thereby significantly increasing the user's convenience in editing and processing data.

Inventors

안성일
이동영
이선우

Assignees

주식회사 도로시

Dates

Publication Date: 20260507
Application Date: 20241030

Claims (9)

In a Self Service Data Preparation (SDP) system that integrates the processes of data acquisition, preprocessing, and analysis, A dataset module that receives and stores data, and distributes processed and analyzed data; A processing module that provides data in a spreadsheet type so that a user can process the data stored in the above dataset module; and It includes an analysis module that analyzes and visualizes data processed through the above processing module, The above processing module is, A data preprocessing and analysis system equipped with a work step tracking function, characterized by recording work steps for each minimum processing unit of data and providing a work step tracking function that returns to a data processing state corresponding to the work step upon a user's request.
In claim 1, The above dataset module is, A data preprocessing and analysis system equipped with a work step tracking function characterized by receiving data from one or more sources among local data, DBMS (Database Management System), and ERP (Enterprise Resource Planning).
In claim 1, The above dataset module is, A data preprocessing and analysis system equipped with a task step tracking function characterized by clustering the data to divide it into multiple parts and then transmitting the data in parallel when receiving or distributing data.
In claim 1, The above processing module is, A data preprocessing and analysis system having a work step tracking function characterized by providing a display window that cumulatively displays a plurality of the above-mentioned work steps.
In claim 1, The above processing module is, A data preprocessing and analysis system equipped with a task step tracking function characterized by providing a storage function that saves the task status according to a user's request.
In claim 6, The above processing module is, A data preprocessing and analysis system having a work step tracking function characterized by providing a display window that cumulatively displays a plurality of the above-mentioned work statuses.
In claim 7, The above processing module is, A data preprocessing and analysis system having a work step tracking function characterized by providing the work step tracking function according to the above work status.
In claim 1, The above processing module is, A data preprocessing and analysis system having a task step tracking function, characterized by displaying some preprocessed data in advance during the process of preprocessing data stored in the above dataset module in the background, and, when the preprocessing in the background is completed, mapping the completed data to the pre-displayed data.
In claim 1, The above analysis module is, A data preprocessing and analysis system having a work step tracking function, characterized by generating a graph based on data stored in the above dataset module, and reflecting the updated data when generating the graph when the selected data is updated.

Description

Data Preprocessing and Analysis System Having Work Step Tracking Function The present invention relates to a data preprocessing and analysis system equipped with a work step tracking function. With the rise of big data and artificial intelligence technologies, the need for users to integrate and manage files and data is increasing. Consequently, as there is a necessity to handle various forms of data, such as legacy data, unstructured data, and social data, the importance of data preprocessing is also rising. Traditionally, when an end user has a need for data analysis, they request it from the IT department, which then performs the ETL (Extract, Transform, Load) process. However, this process is highly inefficient, as it takes anywhere from a few days to, in some cases, several months. In particular, most companies invest a massive amount of time in data collection and processing, with the reality that building data warehouses and data marts, as well as handling changes in requirements, takes several months. Consequently, data for analysis is not supplied in a timely manner, leading to problems such as delays in decision-making. Under the circumstances described above, Self Service Data Preparation (SDP) systems have emerged to enable end users to directly perform data preprocessing without the assistance of the IT department, by integrating the processes of data acquisition, preprocessing, and analysis. However, these SSDP systems are utilized only to a limited extent due to many shortcomings in terms of various convenience features. FIG. 1 illustrates a computing system for operating a data preprocessing and analysis system having a work step tracking function according to an embodiment of the present invention, and FIG. 2 illustrates the overall configuration of a data preprocessing and analysis system having a work step tracking function according to an embodiment of the present invention, and FIG. 3 illustrates an example of a data input screen provided in a data preprocessing and analysis system having a work step tracking function according to an embodiment of the present invention, and FIG. 4 illustrates datasets stored in a dataset module of a data preprocessing and analysis system having a work step tracking function according to an embodiment of the present invention, and FIG. 5 illustrates a spreadsheet-type screen of data provided by a data preprocessing and analysis system equipped with a work step tracking function according to an embodiment of the present invention, and FIGS. 6 to 8 illustrate examples of a work step tracking function provided in a data preprocessing and analysis system having a work step tracking function according to an embodiment of the present invention, and FIGS. 9 and 10 illustrate examples of visualization screens provided in a data preprocessing and analysis system having a work step tracking function according to an embodiment of the present invention. Hereinafter, some embodiments of the present invention will be described in detail with reference to exemplary drawings. It should be noted that in assigning reference numerals to the components of each drawing, the same components are given the same reference numeral whenever possible, even if they are shown in different drawings. Furthermore, in describing embodiments of the present invention, if it is determined that a detailed description of related known configurations or functions would hinder understanding of the embodiments of the present invention, such detailed description is omitted. In addition, terms such as first, second, A, B, (a), (b), etc., may be used when describing the components of the embodiments of the present invention. These terms are used merely to distinguish the components from other components, and the essence, order, or sequence of the components is not limited by the terms used. Referring to FIG. 1, a computing system (10) for operating a data preprocessing and analysis system having a task step tracking function may include at least one processor (11) and a memory (12) that stores instructions that instruct at least one processor to perform at least one step. Here, at least one processor (11) may mean a central processing unit (CPU), a graphics processing unit (GPU), or a dedicated processor on which methods according to embodiments of the present invention are performed. Each of the memory (12) and the storage device (16) may be composed of at least one of a volatile storage medium and a non-volatile storage medium. For example, the memory (12) may be composed of at least one of a read-only memory (ROM) and a random access memory (RAM). Additionally, the computing system (10) may include a transceiver (13) that performs communication via a wireless network. Additionally, the computing system (10) may further include an input interface device (14), an output interface device (15), and a storage device (16), etc. Each component included in the computing system (10) may be connected by a