KR20180072889A

KR20180072889A - Method for generating user-defined Enterprise Resource Planning function and computing system performing the same

Info

Publication number: KR20180072889A
Application number: KR1020160156721A
Authority: KR
Inventors: 김용우
Original assignee: (주) 더존비즈온
Priority date: 2016-11-23
Filing date: 2016-11-23
Publication date: 2018-07-02
Also published as: WO2018097361A1

Abstract

Disclosed is a method for allowing a user using an ERP software, such as a company, to easily implement an ERP function suitable for his / her business process through an integrated development environment, and a computing system performing the method. According to an aspect of the present invention, there is provided a method of generating a user-defined ERP (Enterprise Resource Planning) function performed by a predetermined computing system, the UI creating method comprising: a UI object corresponding to an ERD file; Providing a container UI including a UI object corresponding to an object and a design file, wherein the ERD file is a file that stores information modeling the attributes of a table stored in a database and relationships between the tables, Is a file for storing a SQL (Structured Query Language) query for manipulating the database, and the design file is a file for storing information on attributes of at least one control configuring a screen of the user-defined ERP function, At least a part of the controls constituting the screen of the user-defined ERP function Providing an ERD file editing function for editing the ERD file when a UI object corresponding to the ERD file is selected, the at least one SQL being a control mapped to a specific query included in one SQL file; Providing an SQL file editing function for editing an SQL file corresponding to a selected UI object when a UI object corresponding to any one of the files is selected; if the UI object corresponding to the design file is selected, Providing a design file editing function for editing a file; and providing the user defined ERP function based on the ERD file, the at least one SQL file, and the design file. / RTI >

Description

[0001] The present invention relates to a method of generating a user-defined ERP function and a computing system performing the same,

The present invention relates to a user-defined ERP function generation method and a computing system for performing the same. More particularly, the present invention relates to a method for enabling a user who uses ERP software such as a company to easily implement an ERP function suitable for his / her business process through an integrated development environment, and a computing system performing the method.

Enterprise Resource Planning (ERP) is a computer system for business management and management, or package software installed in such systems. Representative companies that handle ERP are SAP and Oracle. In Korea, . Meanwhile, in order for an enterprise to receive an ERP service, a database must be established in which not only ERP software should be installed in a user terminal in the enterprise, but also various information of the company is stored.

Through the ERP system, companies can efficiently manage accounting, personnel, salary, sales, trade, purchasing, materials, production, outsourcing, service and management information. Also, by introducing ERP system, companies can maximize productivity by reducing inefficiency caused by different information system between management departments and leading to smooth company resource management. In addition, ERP can provide the advantage of systematically identifying and managing various information of the company.

Since each company has its own business process and has different corporate management strategies, ERP software needs to be customized to suit the characteristics of the enterprise, business process, and workflow to be applied, unlike general package software. Traditionally, in order to build a customized ERP system for various companies, it has been necessary to analyze the requirements and business processes of each company, and to develop customized ERP software to be applied to the companies based on the analysis. Accordingly, It took a lot of time and money to build an ERP system. In addition, companies that are not large in size due to high costs are very difficult to introduce ERP systems.

An object of the present invention is to provide an integrated development environment capable of integrally developing database modeling, SQL query and UI for manipulating the database, and to create customized ERP individual functions suitable for a company And to provide a computing system for performing the method.

According to an aspect of the present invention, there is provided a method of generating a user-defined ERP (Enterprise Resource Planning) function performed by a predetermined computing system, the UI creating method comprising: a UI object corresponding to an ERD file; Providing a container UI including a UI object corresponding to an object and a design file, wherein the ERD file is a file that stores information modeling the attributes of a table stored in a database and relationships between the tables, Is a file for storing a SQL (Structured Query Language) query for manipulating the database, and the design file is a file for storing information on attributes of at least one control configuring a screen of the user-defined ERP function, At least a part of the controls constituting the screen of the user-defined ERP function Providing an ERD file editing function for editing the ERD file when a UI object corresponding to the ERD file is selected, the at least one SQL being a control mapped to a specific query included in one SQL file; Providing an SQL file editing function for editing an SQL file corresponding to a selected UI object when a UI object corresponding to any one of the files is selected; if the UI object corresponding to the design file is selected, Providing a design file editing function for editing a file; and providing the user defined ERP function based on the ERD file, the at least one SQL file, and the design file. / RTI >

In one embodiment, the step of providing the ERD file editing function includes providing the ERD file editing UI based on the ERD file, wherein the ERD file editing UI includes a table structure UI object And a relationship UI object representing a relationship between the table and the ERD file editing UI. The ERD file editing method includes a step of changing a relation between a table schema and a table schema according to a user's input on the ERD file editing UI, And reflecting it.

In one embodiment, the step of providing the SQL file editing function may include providing a SQL edit UI displaying an SQL query stored in the SQL file, changing an SQL query based on a user's input on the SQL edit UI, And reflecting the changed SQL query to the SQL file.

In one embodiment, at least some of the controls included in the design file are mapped to a predetermined parameter variable name, and at least one SQL query included in the at least one SQL file is created including the parameter variable name, The data input to the control mapped to the parameter variable name can be input to the SQL query.

In one embodiment, the step of providing the design file editing UI may include providing a function screen editing UI for editing a screen of the user defined ERP function based on the design file, Changing at least one of the controls constituting the screen of the user-defined ERP function and the properties of each control according to the input; mapping at least a part of the controls displayed in the function screen editing UI to a specific query included in the at least one SQL file Mapping at least a part of the controls displayed in the control edit UI to a specific query included in the at least one SQL file according to a user's input on the SQL mapping UI, The controls that make up the screen of the function, the properties of each changed control, Between the mapping information may comprise reflected in the design file.

In one embodiment, the present invention provides an SQL mapping UI for mapping at least a part of the controls displayed in the function screen editing UI to a specific query included in the at least one SQL file, The step of mapping at least some of the controls displayed in the control edit UI with a particular query included in the at least one SQL file may include displaying each SQL query contained in the at least one SQL file, Displaying a parameter variable name included in the selected SQL query, mapping each displayed parameter parameter name to a control displayed in the function screen editing UI, and selecting the SQL query And mapping to any one grid control displayed in the UI.

In one embodiment, the design file further includes a script of a method to be executed when a specific event occurs in a control constituting a screen of the user-defined ERP function, and the step of providing the design file editing UI includes: Providing a script editing UI for editing a script of a method specified in a control displayed on the function screen editing UI, and changing a script assigned to one of the controls displayed on the function screen editing UI according to a user's input on the script editing UI And reflecting the changed script in the design file.

In one embodiment, the container UI further comprises a UI object corresponding to the report file, wherein the report file contains information about properties of the plurality of controls constituting the report electronic document, The method comprising the steps of: providing a report edit UI for editing the report electronic document based on the report file when a UI object corresponding to the report file is selected; A control for configuring the report electronic document according to a user's input on the report editing UI, an attribute of each control and data bound to each control, a control for configuring the changed report electronic document, And reflecting the data bound to each control in the report file, And generating a report document based on the preliminary report file.

According to another aspect of the present invention, a computer program installed in a data processing apparatus and stored in a recording medium for performing the above-described method is provided.

According to another aspect of the present invention, there is provided a computer program product comprising at least one processor, a memory for storing a computer program executed by the processor, the computer program comprising, when executed by the processor, Wherein the user-defined ERP function generation method comprises: providing a container UI including a UI object corresponding to an ERD file, a UI object corresponding to at least one SQL file, and a UI object corresponding to a design file, , The ERD file is a file that stores information that models the attributes of the tables stored in the database and the relationships between the tables, the SQL file is a file that stores an SQL query for manipulating the database, Wherein at least one of the user-defined ERP functions Wherein at least some of the controls constituting the screen of the user defined ERP function are controls for executing a specific query included in the at least one SQL file, Providing an ERD file editing function for editing the ERD file when a corresponding UI object is selected; if a UI object corresponding to one of the at least one SQL file is selected, Providing a SQL file editing function for editing an SQL file, providing a design file editing function for editing the design file when a UI object corresponding to the design file is selected, Providing a user-defined ERP function based on one SQL file and the design file A computing system is provided that includes the steps of:

According to an embodiment of the present invention, an integrated development environment for integrally developing database modeling, SQL query and UI for manipulating the database is provided, and an ERP individual function customized for the enterprise is created And a computing system for performing the method.

BRIEF DESCRIPTION OF THE DRAWINGS A brief description of each drawing is provided to more fully understand the drawings recited in the description of the invention.
FIG. 1 is a diagram schematically illustrating a computing apparatus for performing a user-defined ERP function generation method according to an embodiment of the present invention.
FIG. 2 is a view illustrating a process of generating a user-defined ERP function by a computing system according to an exemplary embodiment of the present invention. Referring to FIG.
3 is a diagram illustrating an example of a UI of an integrated development environment provided by a computing system according to an embodiment of the present invention.
4 is a diagram showing an example of a project window.
5 is a diagram showing an example of a database search window.
6 is a flowchart schematically illustrating a process of the ERD file editing function of the computing system according to an embodiment of the present invention.
7 is a diagram showing an example of an ERD file editing UI.
FIG. 8 is a flowchart schematically illustrating a process in which a computing system performs an SQL file editing function according to an embodiment of the present invention.
9 is a diagram showing an example of an SQL file editing UI.
10 is a flowchart schematically illustrating a process of the designing file editing function of the computing system according to an embodiment of the present invention.
11 is a diagram showing an example of a design file editing UI.
12 is a view showing an example of a tool box window.
13 is a diagram showing an example of an attribute window.
14 is a diagram showing an example of a script window.
15A to 15E are views showing an example of the SQL mapping UI.
16 is a flowchart schematically showing a mapping process between SQL and control.

BRIEF DESCRIPTION OF THE DRAWINGS The present invention is capable of various modifications and various embodiments, and specific embodiments are illustrated in the drawings and described in detail in the detailed description. It is to be understood, however, that the invention is not to be limited to the specific embodiments, but includes all modifications, equivalents, and alternatives falling within the spirit and scope of the invention. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, the present invention will be described in detail with reference to the accompanying drawings.

The terms first, second, etc. may be used to describe various components, but the components should not be limited by the terms. The terms are used only for the purpose of distinguishing one component from another.

The terminology used in this application is used only to describe a specific embodiment and is not intended to limit the invention. The singular expressions include plural expressions unless the context clearly dictates otherwise.

In this specification, the terms "comprises" or "having" and the like refer to the presence of stated features, integers, steps, operations, elements, components, or combinations thereof, But do not preclude the presence or addition of features, numbers, steps, operations, components, parts, or combinations thereof.

Also, in this specification, when any one element 'transmits' data to another element, the element may transmit the data directly to the other element, or may be transmitted through at least one other element And may transmit the data to the other component. Conversely, when one element 'directly transmits' data to another element, it means that the data is transmitted to the other element without passing through another element in the element.

Hereinafter, the present invention will be described in detail with reference to the embodiments of the present invention with reference to the accompanying drawings. Like reference symbols in the drawings denote like elements.

FIG. 1 is a diagram illustrating an execution environment of a user-defined ERP function generation method according to an embodiment of the present invention.

Referring to FIG. 1, a method of generating a user-defined ERP function may be performed by a predetermined computing system 100.

The computing system 100 may be a handheld device such as a mobile phone, a satellite phone, a wireless telephone, a Session Initiation Protocol (SIP), a Wireless Local Loop (WLL) station, a smart phone, a tablet PC, a PDA It may include a tower or a laptop.

The computing system 100 may include hardware resources and / or software necessary to implement the technical idea of the present invention, and does not necessarily mean one physical component or a single device . That is, the computing system 100 may mean a logical combination of hardware and / or software provided to implement the technical idea of the present invention. If necessary, the computing system 100 may be installed in a separate apparatus to perform respective functions And may be embodied as a set of logical structures for realizing the technical idea of the present invention. Also, the computing system 100 may mean a set of configurations separately implemented for each function or role for implementing the technical idea of the present invention.

The computing system 100 may be implemented in the form of a plurality of modules. For example, the computing system 100 may include at least one communication module capable of communicating with an external system (e.g., 200) and / or with a variety of user terminals (e.g., 300) over a network, A control module capable of performing the main functions of the computer system 100 and controlling functions and / or resources of other components included in the computing system 100, a storage module capable of storing various information, And an input / output module having an I / O module. The various modules included in the computing system 100 may be located in different physical devices or may be located in the same physical device. In some cases, the computing system 100 may further include a DB 130 for storing various kinds of data and company information necessary for implementing the technical idea of the present invention.

Although FIG. 1 illustrates an example in which the DB 130 is included in the computing system 100, in another embodiment, the DB 130 may be separate from the computing system 100 Or may be implemented in the form of a system. In this case, the computing system 100 and the DB 130 can be connected to each other via a network to transmit and receive various data and information. Also, according to an embodiment, the computing system 100 may operate in conjunction with a plurality of DBs included in the computing system or connected through a network.

In this specification, a DB (DataBase) may be implemented by at least one table, and may further include a separate DBMS (Database Management System) for searching, storing, and managing information stored in the DB It is possible. In addition, it may be implemented in various ways such as a linked-list, a tree, a relational DB, etc., and includes all data storage media and data structures capable of storing information to be stored in the DB 130 Can be used to mean.

Herein, a module may mean a functional and structural combination of hardware for carrying out the technical idea of the present invention and software for driving the hardware. For example, the module may mean a logical unit of a predetermined code and a hardware resource for executing the predetermined code, and it does not necessarily mean a physically connected code or a kind of hardware. Can be easily deduced to the average expert in the field of < / RTI >

1, the computing system 100 includes a user-defined ERP function generation module 110 (hereinafter, referred to as a 'generation module') and the user-defined ERP function function module 120 ).

The generation module 110 may generate a user-defined ERP function or edit a previously created user-defined ERP function. The driving module 120 may drive the user defined ERP function generated by the generating module 110 to provide the user with the user defined ERP function.

The generation module 110 and the driving module 120 may be implemented as independent physical devices. Or both systems 110 and 120 may be implemented as a single physical device, according to an implementation. In the latter case, the two systems 110 and 120 may be configured as separate logically separate software, or may be implemented in the form of a single integrated software.

Hereinafter, for the sake of convenience, the function of generating the user-defined ERP function according to the technical idea of the present invention is performed by the generation module 110, and the function of driving the generated ERP function is performed by the driving module 120 However, according to an embodiment, unlike FIG. 1, the computing system 100 performs a combined operation of a user-defined ERP function generation function and a generated user-defined ERP function execution function according to the technical idea of the present invention Lt; / RTI >

The user-defined ERP function can be integrated into the ERP system and can be a unit function that has its own meaning. The user-defined ERP function can manage, manipulate, use, and analyze enterprise information stored in the DB 130. A user interface (UI) customized to allow the user to perform such functions can be provided. That is, the user can manage, manipulate, use and analyze the enterprise information stored in the DB 130 through the UI provided by the user-defined ERP function.

Examples of user-defined ERP functions are: input of documents, bookkeeping, account change management, bond age analysis / management, settlement management, statement of accounts, fund / budget management, budget use analysis, fixed asset management, , Personnel management, time and attendance management, salary management, social insurance management, year-end settlement management, retirement settlement management, tax report management, income slip processing, daily staff management, domestic sales planning establishment / management, Sales management, sales / settlement management, sales tax settlement, electronic tax bill processing, collection / bond management, bond age analysis, export planning establishment / management, order management, It is also possible to calculate the amount of goods to be delivered to the buyer through the process of sales settlement, shipment management, goods / order processing, shipment / receipt management, import cost processing, Accounting, Payments / Debt Management, Inventory Control (LOT) , Production planning / management, own production management, mixed process management, byproduct / disassembly management, production control of production, input instruction management, outsourced production management, service reception / processing, service bond management, financial / profit analysis, profit / profit analysis , Analysis of major funds, analysis of logistics / fish, analysis of sales by characteristics, analysis of seasonal and quarterly production results, analysis of characteristics by characteristics, salary / bonus simulation, contract management, field management, It is also possible to have a variety of other functions, such as unpaid management, labor equipment management, finishing settlement management, labor report management, outsourced management, and cost benefit management.

1, the computing system 100 is connected to a predetermined shared system 200 via a network, and transmits / receives various information, data, signals, and / or messages necessary for implementing the technical idea of the present invention .

The computing system 100 can transmit the result created through the user-defined ERP function generation function to the sharing system 200, and the sharing system 200 can provide (transmit) . That is, the sharing system 200 can share the user-defined ERP function uploaded by each user with another user.

The result generated through the ERP function generation function may include an ERP file, at least one SQL file, and a design file, and may further include a report file according to an embodiment.

The ERD file may be a file that stores information on attributes of a table stored in the DB 130 and information on modeling relationships between the tables.

ERD (Entity Relationship Diagram) is the most data modeling technique. It uses simple shapes (rectangle, ellipse, diamond type, etc.) to express the structure and relationship of data. It is most commonly used as a tool. The user can visually understand the relationship of the database by using the ERD. The components of an ERD are Entity, Relationship, and Attribute. An entity is a representation of a separate entity as the subject or object of information to be stored in the database. In database modeling, a table stored in a database can be an object. A relationship indicates how two or more entities are related to each other. An attribute is a data item describing a characteristic of an entity or a relation. An attribute that uniquely identifies each entity is called a key property.

The SQL file may be a file storing Structured Query Language (SQL) queries for manipulating the DB 130. Each SQL file can store one or more SQL queries.

SQL is a special purpose programming language designed to manage data in a database management system (DBMS). It is used to create queries for searching and managing data stored in a database, creating and modifying database schemas, and managing database object access Can be used. SQL commands can be classified into three types according to their functions: data manipulation (DML), data definition (DDL), and data control (DCL). Data manipulation (DML) is a command used to transform or retrieve data in a database, such as INSERT (add data), UPDATE (update data), DELETE (delete data), SELECT (retrieve data). Data Definition (DDL) is a command that is used to transform a structure such as a table that contains data, such as CREATE (Create Table), DROP (Remove Table), and ALTER (Change Table, etc.). Data control (DCL) is a command that grants or revokes the authority to access the database, such as GRANT (user authorization) and REVOKE (user revocation).

The design file may be a file that stores information about attributes of at least one control that constitutes a screen of a user-defined ERP function. Here, the control may be a UI object capable of performing an interaction with a user such as displaying information or receiving information from a user.

At least a part of the controls constituting the screen of the user-defined ERP function may be a control mapped to a specific query included in the at least one SQL file. Hereinafter, such a control will be referred to as a grid control.

The report file may include information on attributes of a plurality of controls constituting a report electronic document and information on data bound to each control.

FIG. 2 is a view illustrating a process of generating a user-defined ERP function by the generation module 110 according to an exemplary embodiment of the present invention.

2, the generation module 110 may provide a container UI including a UI object corresponding to an ERD file, a UI object corresponding to at least one SQL file, and a UI object corresponding to a design file, (S110), the user can select any of the UI objects included in the container UI (S120).

If a UI object corresponding to the ERD file is selected, the generation module 110 may provide an ERD file editing function for editing the ERD file (S130).

If a UI object corresponding to the SQL file is selected, the generation module 110 may provide an SQL file editing function for editing the SQL file (S140).

If a UI object corresponding to the design file is selected, the generation module 110 may provide an ERD file editing function for editing the design file (S150).

Meanwhile, the generation module 110 may provide an integrated development environment so that a user can create and customize a user-specified ERP function. Using the provided integrated development environment, users can create or edit ERD files, SQL files, design files, and report files necessary for running user-specified ERP functions.

A user can create a plurality of user-specified ERP functions through the creation module 110, wherein a plurality of user-specified ERP functions can be managed as one corresponding project, respectively. Each project can be a package or a container that contains at least one SQL file and a design file.

Even if there are multiple projects, there can be only one ERD file. In this case, a plurality of user-specified ERP functions generated by the plurality of projects can use one common ERD file.

Hereinafter, a method for a user to create / edit a custom ERP function through an integrated development environment will be described in detail.

3 is a diagram illustrating an example of a UI of an integrated development environment provided by the generation module.

3, the integrated development environment UI 1000 includes a menu 1100, a project window 1200, a database search window 1300, an editor window 1400, a toolbox window 1500, an attribute window 1600 ), And a script window 1700.

The menu 1100 may include a plurality of icons, and each icon may be a UI object for executing functions frequently used by the user including creating a new project, opening a file, saving a file, copying and pasting.

The project window 1200 may be a container UI including a UI object (e.g., an icon) corresponding to the ERD file, a UI object corresponding to at least one SQL file, and a UI object corresponding to the design file.

4 is a diagram showing an example of a project window 1200. [

4, a UI object 1211 corresponding to an ERD file may be displayed in the project window 1200. When a UI object 1211 corresponding to the ERD file is selected by the user For example, when the UI object is clicked, double-clicked, or touched, the creation module 110 may provide an ERD file editing function for editing the ERD file. The creation module 110 may display a UI for editing the ERD file in the editor window 1400 to provide an ERD file editing function and the user may edit the ERD file on the UI displayed in the editor window 1400 .

The UI object 1211 corresponding to the ERD file may be displayed at a lower level of the ERD container UI object 1210. The user can interact with the ERD container UI object 1210 in a predetermined manner to generate a new ERD file and the UI object corresponding to the newly created ERD file is added to the lower level of the ERD container UI object 1210 . At this time, the newly created ERD file may be a blank file that contains no information.

In the project window 1200, UI objects 1201, 1202, and 1203 corresponding to at least one project may be displayed, and each project may correspond to a different user-defined ERP function.

As described above, each project may be a container including at least one SQL file and a design file, at least one report file, and the project window 1200 may include at least one project (for example, UI objects 1221 and 1222 corresponding to the respective SQL files of the report file, a UI object 1231 corresponding to each of at least one report file, and a UI object 1241 corresponding to the design file.

UI objects 1221 and 1222 corresponding to at least one SQL file may be displayed at a lower level of the SQL container UI object 1220. [ The user can interact with the SQL container UI object 1220 in a predetermined manner to generate a new SQL file and the UI object corresponding to the newly generated SQL file is added to the lower level of the SQL container UI object 1220 . At this time, the newly created SQL file may be an empty file containing no information.

A UI object 1231 corresponding to each of at least one report file may be displayed at a lower level of the report container UI object 1230. [ The user can interact with the report container UI object 1230 in a predetermined manner to generate a new report file and the UI object corresponding to the newly generated report file is added to the lower level of the report container UI object 1230 . At this time, the newly created report file may be an empty file containing no information.

Meanwhile, when a UI object (for example, 1221) corresponding to any one of the at least one SQL file is selected by the user, the generation module 110 generates an SQL file corresponding to the selected UI object 1221 You can provide SQL file editing functions for editing. The creation module 110 may display a UI for editing an SQL file in the editor window 1400 to provide an SQL file editing function and the user may edit the SQL file on the UI displayed in the editor window 1400 .

Also, when a UI object corresponding to one of the at least one report files (for example, 1231) is selected by the user, the generating module 110 may provide a report editing UI for editing a report electronic document have. The creation module 110 may display a UI for editing a report file in the editor window 1400 to provide a report file editing function and the user may edit the report file on the UI displayed in the editor window 1400 .

Also, when a UI object 1241 corresponding to a design file is selected by the user, the creation module 110 may provide a design file editing function for editing the design file. The creation module 110 may display a UI for editing a design file in the editor window 1400 to provide a design file editing function and the user may edit the design file on the UI displayed in the editor window 1400 .

Meanwhile, the user can interact with the UI object corresponding to the specific project (for example, 1202) in a predetermined manner to generate a new design file, and the UI object corresponding to the newly created design file corresponds to the project The UI object 1202 may be added at a lower level. At this time, the newly created design file may be an empty file containing no information.

Although the above description has been made with respect to an example in which the creation module 110 provides each file editing function on the editor window 1400 included in the integrated development environment UI 1000, May execute separate applications corresponding to their respective file editing functions, in which case the user may edit each file on the executed application.

5 is a diagram showing an example of the database search window 1300. In FIG.

As shown in FIG. 5, the database search window 1300 may include UI objects 1310 and 1320 corresponding to the computing system 100 or the DB 130 connected to the generation module 110.

The UI object (e.g., 1310) may have UI objects (1311 to 1313) indicating at least one schema at a lower level. A schema can be a container that contains objects such as tables, stored procedures, and the like in a database, a structure that defines the structure of data, a method of expressing data, a structure that defines the relationship between data in a format language, or a namespace. Therefore, a UI object corresponding to each object such as a table or a stored procedure included in the corresponding schema at a lower level of the UI object indicating a specific schema can be provided.

A table means a collection of data composed of fields that are items for storing each data, and one database can be composed of several tables. A stored procedure or a stored procedure is a set of queries for executing a series of queries as if they were a single function. It stores the procedures for organizing a series of operations on the database in a database management system. Also called a module (Persistent Storage Module).

In the editor window 1400, an edit UI corresponding to the type of the file selected by the user can be displayed.

FIG. 6 is a flowchart schematically illustrating a process of the ERD file editing function of the generating module 110. Referring to FIG.

Referring to FIG. 6, if the user selects an object corresponding to the ERD file, the creation module 110 may provide an ERD file editing UI (S131). In one embodiment, the creation module 110 may display an ERD file editing UI in the editor window 1400. At this time, the ERD file editing UI may include a table structure UI object indicating the structure of the database table and a relation UI object indicating the relationship between the tables.

Then, the creation module 110 can change the relationship between the table schema and the table schema according to the user's input on the ERD file editing UI (S132). When the change is completed, the changed table structure and the relationship between the tables can be reflected in the ERD file (S133)

Hereinafter, the process of FIG. 6 will be described in more detail with reference to FIG.

The creation module 110 may provide the ERD file editing UI 2000 through the editor window 1400 based on the content of the ERD file corresponding to the ERD file object selected by the user.

7 is a diagram showing an example of the ERD file editing UI 2000. As shown in FIG.

7, the ERD file editing UI 2000 includes a toolbar UI 2100 including a button for creating a new table, a button for creating a new relationship, and a button for reflecting changes to the DB 130 . The ERD file editing UI 2000 also includes a table structure UI object 2210, 2220, 2230 indicating the structure of the database table, and a relationship UI object 2310, 2320 indicating the relationship between tables, for example. .

The table structure UI objects 2210, 2220, and 2230 may display the respective column information included in the table.

The relationship UI objects 2310 and 2320 may be in the form of a line connecting two table structure UI objects. Relational UI objects may be represented in different forms (e.g., solid or dashed lines) depending on whether the relationship between the two tables is an identity relationship or a non-identity relationship.

The generation module 110 may change the relationship between the table structure and the table structure according to the user's input on the ERD file editing UI.

The user can create a new table UI object on the ERD file editing UI 2000.

The user can create a UI object corresponding to the table created in the DB 130. [ For this purpose, the user can select a UI object corresponding to the specific table displayed in the database search window 1300 or input commands such as dragging and dropping onto the ERD file editing UI 2000, In response, the creation module 110 may create a new table UI object corresponding to the corresponding table in the ERD file editing UI 2000. Alternatively, the user may select a new table creation UI provided by the ERD file editing UI 2000 to create a UI object corresponding to the new table.

Meanwhile, the user deletes the table UI object existing on the ERD file editing UI 2000 or changes the structure of the table through the corresponding table UI object (for example, adding / deleting / changing the column or changing the attribute of the table) You may.

The user can also create a new relationship UI object that indicates the relationship between the table UI objects existing on the ERD file editing UI 2000. For example, the user selects a button for creating a new relation provided by the ERD file editing UI 2000, and then creates a new relation UI object indicating a relationship between the two tables selected by selecting two tables to be related to each other .

On the other hand, the user can delete the related UI object existing on the ERD file editing UI 2000 or change the related information through the related UI object.

After the database modeling is changed through the above process, for example, when the user presses a predetermined storage button, the generation module 110 may reflect the relationship between the changed table schema and the table schema in the ERD file.

In addition, the generation module 110 may change the table structure of the DB 130, add a new table, or delete an existing table by reflecting it in the relationship DB 130 between the changed table schema and the table schema.

FIG. 8 is a flowchart schematically illustrating a process of the SQL module 110 executing the SQL file editing function.

Referring to FIG. 8, if the user selects an object corresponding to the SQL file, the generation module 110 may provide a SQL editing UI (S141). In one embodiment, the creation module 110 may display a SQL edit UI in the editor window 1400.

Then, the creation module 110 can change the SQL query according to the user's input on the SQL edit UI (S142). When the change is completed, the changed query can be reflected in the SQL file (S143)

Hereinafter, the process of FIG. 8 will be described in more detail with reference to FIG.

If the user selects an object corresponding to the SQL file, the SQL file editing UI 3000 may be displayed in the editor window 1400. That is, the creation module 110 may provide the SQL file edit UI 3000 displaying the contents of the SQL file corresponding to the SQL file object selected by the user through the editor window 1400.

9 is a diagram showing an example of the SQL file editing UI 3000. As shown in FIG.

9, the SQL file editing UI 3000 includes a UI for selecting a DB to be connected, a button for performing a connection with the DB, a button for disconnecting a connection, And a toolbar UI 3100 including a UI for selection.

In addition, the SQL file editing UI 3000 may include an editing UI 3200 for creating a query, and a user may create or edit an SQL query on the editing UI 3200. The user can include the parameter variable name when creating the query. For example, the parameter variable name can be in the form of '@ variable name'. The parameter variable name can be used to link the query with the control on the function screen edit UI described below. To do so, at least some of the controls contained in the design file may be mapped to the parameter variable names. On the other hand, when the SQL query is executed later, data input to the control mapped to the parameter variable name may be input to the SQL query. More precisely, the data inputted to the control mapped to the parameter variable name may be assigned to the parameter variable name of the SQL query.

The toolbar UI 3100 may include a button for executing a created query, and the SQL file editing UI 3000 may include a result display UI 3300 for displaying the execution result. On the result display UI 3300, the structure of the table and the data inquired by the query can be displayed.

Meanwhile, when the SQL query is changed through the above process, for example, when the user presses a predetermined storage button, the generation module 110 may reflect the changed SQL query in the SQL file.

10 is a flowchart schematically illustrating a process of the design module 110 performing a design file editing function.

Referring to FIG. 10, when the user selects an object corresponding to the design file, the creation module 110 may provide a function screen editing UI (S151). In one embodiment, the creation module 110 may display the function edit UI in the editor window 1400. [

In step S152, the creation module 110 may change the attributes of the control and the controls for configuring the screen of the user-defined ERP function according to the user's input on the function screen editing UI.

In step S153, the creation module 110 may reflect the control on the screen of the changed user-defined ERP function, the attributes of the changed control, and the mapping information between the changed control and the query in the design file.

Hereinafter, the process of FIG. 10 will be described in more detail with reference to FIGS. 11 to 14. FIG.

If the user selects an object corresponding to the design file, a design file editing UI may be displayed in the editor window 1400. That is, the creation module 110 may provide a design file edit UI through the editor window 1400 based on a design file corresponding to a design file object selected by the user.

11 is a diagram showing an example of the design file editing UI 4000. In FIG.

Various controls (for example, 4010 to 4040) previously defined in the design file can be displayed in the design file edit UI 4000. [

The user can delete the controls displayed in the design file editing UI 4000, change the layout, or modify the external elements such as the size.

The user may also add a new control to the design file edit UI 4000. To this end, the creation module 110 may provide a toolbox window 1500 for selecting various controls. 12 is a view showing an example of the tool box window 1500. Fig.

As shown in FIG. 12, the tool box window 1500 may include various types of controls, and the user may select a desired control or drag and drop the control to the design file editing UI 4000, (4000).

Meanwhile, in the tool box window 1500, various controls may be classified into specific categories according to predetermined classification criteria. Common controls 1510 commonly used in GUIs, business controls 1520 specifically used in the ERP field, data controls 1530, as shown in Figure 2F, for example, A layout control 1550, a pop-up control 1570, and the like, which serve as a container for the user.

In particular, a control belonging to the data control category 1530 (hereinafter, referred to as a 'data control') can perform a function of displaying data inquired by an SQL query. A data control can have a Flex Grid that displays in the form of a data grid that is queried by an SQL query, a Pivot Grid that displays it in a pivot table format, and a chart grid (Chard Grid) that displays in the form of a chart. have. In addition, there are various types of data controls. An example of a flex grid is the data control 4040 of FIG.

On the other hand, when the user selects (for example, clicks) a control placed in the design file editing UI 4000 in a predetermined manner, the property value of the selected control may be displayed in the property window 1600, It is possible to change the value of the property of the control shown in (1600). Fig. 13 is a diagram showing an example of the attribute window 1600. Fig.

Also, when the user selects (for example, double-clicks) a control disposed in the design file editing UI 4000 in a predetermined manner, the script window 1700 displays a method indicating an action to be performed when a specific event occurs The script may be displayed and the user may create / edit the method script displayed in the script window 1700. Fig. 14 is a diagram showing an example of the script window 1700. Fig.

14, the script window 1700 includes a UI 1710 for selecting any one of the controls arranged in the design file editing UI 4000, a UI 1720 for selecting an event that can occur in the control, And a UI 1730 for creating a method script to be executed when a selected event occurs in the selected control.

If the control for configuring the screen of the user-defined ERP function, the properties of each control, and / or the method script are changed through the above process, for example, when the user presses a predetermined storage button, ) May reflect changes to the design file.

Meanwhile, the generation module 110 may perform a mapping process so that the content displayed on the screen of the user-defined ERP function is associated with the SQL query. That is, the generation module 110 generates a SQL mapping UI for mapping at least a part (for example, 4040) of the data controls displayed in the design file editing UI 4000 to a specific query included in the at least one SQL file And map at least a part of the controls displayed in the control edit UI to a specific query included in the at least one SQL file according to a user's input on the SQL mapping UI. 15A to 15E are views showing an example of the SQL mapping UI.

15A is a diagram showing a current SQL mapping state. The SQL mapping UI 5000 shown in FIG. 15A may include a UI 5010 that displays a list of queries defined in at least one SQL file corresponding to a user-defined ERP function. In the example of FIG. 15A, a query named SQL may be mapped to a predetermined data control. Through the SQL mapping UI (5000), the user can map the parameters described in the SQL query and the input control (the control that can receive data from the user) and map the SQL query and the data control to display the result by the query can do. In addition, a separate query can be set up when the user changes the value displayed on the data control or adds / deletes the column, which will be described in more detail below.

In FIG. 15A, when the 'query setting' 5020 of the SQL query is selected, the UI 5100 shown in FIG. 15B may be displayed. On the UI 5100 as shown in FIG. 15B, the user can map each parameter variable name included in the SQL statement to specific controls (for example, 4010 and / or 4030) included in the design file edit UI 4000 have. The control mapped to the parameter variable name may be a control (input control) performing the function of receiving data from the user. As shown in FIG. 15B, the UI 5100 may include a list 5110 that lists each parameter variable name included in the SQL statement. The UI 5100 may include a parameter variable name and a UI for selecting a control to be mapped For example, 5101 to 5103).

In the example of FIG. 15B, @multiModule is mapped to bpComboBox1 (4010) and @keyword is mapped to textBoxExt1 (4030). As described above, when the parameter variable name in the SQL query is mapped to the specific control included in the design file editing UI 4000, the data input to the control mapped to the parameter variable name at the execution time of the pepper SQL query is Can be input to the SQL query.

When selecting 'control setting' 5030 in FIG. 15A, the UI 5200 shown in FIG. 15C may be displayed. The UI 5200 may include a UI 5210 for selecting a data control displayed on the design file editing UI 4000. This allows the user to select a data control (for example, 4040) to be mapped to the SQL query.

The UI 5200 also includes a UI 5220 for performing customization such as selecting a column to be used / output among the columns included in the DB table to be inquired through the SQL query, adjusting the display order, setting the display format of each field, ).

When selecting the 'Binding configuration' 5040 in FIG. 15A, the UI 5300 shown in FIG. 15D may be displayed. On the UI 5300 as shown in FIG. 15D, the user can map the column included in the DB table to be inquired through the SQL query with the specific control included in the design file edit UI 4000.

In the case of selecting the 'storage setting' 5050 in FIG. 15A, the UI 5400 shown in FIG. 15E can be displayed. UI 5400 shown in FIG. 15E includes a UI 5410 for selecting an SQL query for inserting a record inserted through data control into a database, a UI 5420 for selecting a query for updating data changed on data control ), And a UI 5430 for selecting a query to perform deletion of records.

16 is a flowchart schematically showing the mapping process described above.

In one embodiment, the generation module 110 may display each SQL query included in the at least one SQL file (S210)

When the user selects one of the displayed SQL queries, the selected parameter may be analyzed to obtain the parameter variable name included in the SQL query (S220), and the obtained parameter variable name may be displayed.

Then, according to the input of the user, the generation module 110 may map each displayed parameter parameter name to the control (for example, 4010 or 4030) displayed in the design file edit UI 4000 (S240) .

The generation module 110 may map the SQL query selected by the user's input to any data control (e.g., 4040) displayed in the design file edit UI 4000 (S240, S250).

Referring again to FIG. 1, the driving module 120 may drive the user-defined ERP function generated by the generation module 110 to provide the user with the user-defined ERP function.

As described above, the generating module 110 may generate at least one SQL file and a design file corresponding to the user-defined ERP function, and the driving module 120 may interpret the same to drive a user-defined ERP function have. The driving module 120 may be a kind of engine that receives a kind of meta data or a script and performs a corresponding operation.

For example, the driving module 120 may configure a screen of a user-defined ERP function using information on various controls included in the design file, and display the screen. In addition, when the user inputs a command or data specific to the control, the driving module 120 may perform a corresponding method, script, or built-in function. The driving module 120 may execute the SQL query mapped to the data control and reflect the execution result to the data control or the DB 130. In addition, the drive module 120 may perform various instructions to enable the user-defined ERP function to operate correctly.

Meanwhile, the user-defined ERP function generation method according to the embodiment of the present invention may be implemented in the form of computer-readable program instructions and stored in a computer-readable recording medium. A computer-readable recording medium includes all kinds of recording apparatuses in which data that can be read by a computer system is stored.

Program instructions to be recorded on a recording medium may be those specially designed and constructed for the present invention or may be available to those skilled in the art of software.

Examples of the computer-readable recording medium include magnetic media such as a hard disk, a floppy disk and a magnetic tape, optical media such as CD-ROM and DVD, a floptical disk, And hardware devices that are specially configured to store and execute program instructions such as magneto-optical media and ROM, RAM, flash memory, and the like. The computer readable recording medium may also be distributed over a networked computer system so that computer readable code can be stored and executed in a distributed manner.

Examples of program instructions include machine language code such as those produced by a compiler, as well as devices for processing information electronically using an interpreter or the like, for example, a high-level language code that can be executed by a computer.

The hardware devices described above may be configured to operate as one or more software modules to perform the operations of the present invention, and vice versa.

It will be understood by those skilled in the art that the foregoing description of the present invention is for illustrative purposes only and that those of ordinary skill in the art can readily understand that various changes and modifications may be made without departing from the spirit or essential characteristics of the present invention. will be. It is therefore to be understood that the above-described embodiments are illustrative in all aspects and not restrictive. For example, each component described as a single entity may be distributed and implemented, and components described as being distributed may also be implemented in a combined form.

It is intended that the present invention covers the modifications and variations of this invention provided they come within the scope of the appended claims and their equivalents. .

Claims

1. A method for creating a user defined ERP (Enterprise Resource Planning) function performed by a given computing system,
Providing a container UI including a UI object corresponding to an ERD file, a UI object corresponding to each of at least one SQL file, and a UI object corresponding to a design file, wherein the ERD file includes attributes And a file storing information modeling a relationship between the tables, wherein the SQL file is a file storing a Structured Query Language (SQL) query for manipulating the database, and the design file is a file of the user-defined ERP function Wherein at least some of the controls constituting the screen of the user defined ERP function are mapped to a specific query included in the at least one SQL file, ;
Providing an ERD file editing function for editing the ERD file when a UI object corresponding to the ERD file is selected;
Providing an SQL file editing function for editing an SQL file corresponding to a selected UI object when a UI object corresponding to one of the at least one SQL file is selected;
Providing a design file editing function for editing the design file when a UI object corresponding to the design file is selected; And
Providing the user-defined ERP function based on the ERD file, the at least one SQL file, and the design file.

The method according to claim 1,
The step of providing the ERD file editing function includes:
Providing ERD file editing UI based on the ERD file, wherein the ERD file editing UI includes a table structure UI object indicating a structure of a database table and a relation UI object indicating a relationship between tables;
Changing a relationship between a table structure and a table according to a user's input on the ERD file editing UI; And
And reflecting the changed table structure and the relationship between the tables in the ERD file.

The method according to claim 1,
The step of providing the SQL file editing function includes:
Providing a SQL edit UI displaying an SQL query stored in the SQL file;
Changing an SQL query according to a user's input on the SQL edit UI; And
And reflecting the changed SQL query to the SQL file.

The method according to claim 1,
At least some of the controls included in the design file are mapped to a predetermined parameter variable name,
Wherein at least one SQL query included in the at least one SQL file is created including the parameter variable name and data input to the control mapped to the parameter variable name at execution time is input to the SQL query, Generation method.

The method according to claim 1,
The step of providing the design file editing UI includes:
Providing a function screen editing UI for editing a screen of the user defined ERP function based on the design file;
Changing an attribute of the control and each control constituting the screen of the user-defined ERP function according to a user's input on the function screen editing UI; And
A control for configuring a screen of the changed user-defined ERP function, and an attribute of each changed control in the design file.

6. The method of claim 5, wherein the user-
A SQL mapping UI for mapping at least a part of the controls displayed in the function screen editing UI to a specific query included in the at least one SQL file; And mapping at least some of the controls to a particular query included in the at least one SQL file.

The method according to claim 6,
A SQL mapping UI for mapping at least a part of the controls displayed in the function screen editing UI to a specific query included in the at least one SQL file; Mapping at least some of the controls to a particular query included in the at least one SQL file,
Displaying each SQL query included in the at least one SQL file;
Displaying a parameter variable name included in the selected SQL query when the user selects one of the displayed SQL queries;
Mapping each parameter variable name displayed with the control displayed on the function screen editing UI; And
And mapping the selected SQL query to a grid control displayed in the function screen editing UI.

6. The method of claim 5,
The design file further includes a script of a method to be executed when a specific event occurs in a control constituting a screen of the user-defined ERP function,
The step of providing the design file editing UI includes:
Providing a script editing UI for editing a script of a method specified in a control displayed on the function screen editing UI;
Changing a script assigned to one of the controls displayed on the function screen editing UI according to a user's input on the script editing UI;
And reflecting the changed script to the design file.

The method according to claim 1,
Wherein the container UI further comprises a UI object corresponding to a report file, wherein the report file contains information about properties of a plurality of controls constituting a report electronic document, and information about data bound to each control being;
To create a custom ERP function,
Providing a report editing UI for editing the report electronic document based on the report file when a UI object corresponding to the report file is selected;
Changing a control for configuring the report electronic document, an attribute of each control, and data bound to each control according to a user's input on the report editing UI;
Reflecting the control constituting the changed report electronic document, the attributes of each control and the data bound to each control in the report file; And
And generating a report document based on the report file.

A computer program installed in a data processing apparatus and stored in a recording medium for performing the method according to any one of claims 1 to 9.

At least one processor;
A memory for storing a computer program executed by the processor,
The computer program, when executed by the processor, performs a method of generating a user defined ERP function,
The user-defined ERP function generation method includes:
Providing a container UI including a UI object corresponding to an ERD file, a UI object corresponding to each of at least one SQL file, and a UI object corresponding to a design file, wherein the ERD file includes attributes Wherein the SQL file is a file for storing an SQL query for manipulating the database, and the design file is a file for storing at least one Wherein at least some of the controls constituting the screen of the user-defined ERP function are controls for executing a specific query included in the at least one SQL file;
Providing an ERD file editing function for editing the ERD file when a UI object corresponding to the ERD file is selected;
Providing an SQL file editing function for editing an SQL file corresponding to a selected UI object when a UI object corresponding to one of the at least one SQL file is selected;
Providing a design file editing function for editing the design file when a UI object corresponding to the design file is selected; And
Providing the user defined ERP function based on the ERD file, the at least one SQL file, and the design file.

12. The method of claim 11,
The step of providing the ERD file editing function includes:
Providing ERD file editing UI based on the ERD file, wherein the ERD file editing UI includes a table structure UI object indicating a schema of a database table and a relation UI object indicating a relationship between tables;
Changing a relationship between a table schema and a table schema according to a user's input on the ERD file editing UI; And
And reflecting the relationship between the changed table schema and the table schema in the ERD file.

12. The method of claim 11,
The step of providing the SQL file editing function includes:
Providing a SQL edit UI displaying an SQL query stored in the SQL file;
Changing SQL curie according to a user's input on the SQL edit UI; And
And reflecting the changed SQL query to the SQL file.

12. The method of claim 11,
At least some of the controls included in the design file are mapped to a predetermined parameter variable name,
Wherein at least one SQL query included in the at least one SQL file is created including the parameter variable name and the data input to the control mapped to the parameter variable name is input to the SQL query at execution time.

12. The method of claim 11,
The step of providing the design file editing UI includes:
Providing a function screen editing UI for editing a screen of the user defined ERP function based on the design file;
Changing an attribute of the control and each control constituting the screen of the user-defined ERP function according to a user's input on the function screen editing UI; And
A control for configuring a screen of the changed user-defined ERP function, and an attribute of each changed control in the design file.

16. The method of claim 15, wherein the user-
A SQL mapping UI for mapping at least a part of the controls displayed in the function screen editing UI to a specific query included in the at least one SQL file; And mapping at least some of the controls to a particular query contained in the at least one SQL file.

17. The method of claim 16,
A SQL mapping UI for mapping at least a part of the controls displayed in the function screen editing UI to a specific query included in the at least one SQL file; Mapping at least some of the controls to a particular query included in the at least one SQL file,
Displaying each SQL query included in the at least one SQL file;
Displaying a parameter variable name included in the selected SQL query when the user selects one of the displayed SQL queries;
Mapping each parameter variable name displayed with the control displayed on the function screen editing UI; And
And mapping the selected SQL query to one of the grid controls displayed in the function screen editing UI.

16. The method of claim 15,
The design file further includes a script of a method to be executed when a specific event occurs in a control constituting a screen of the user-defined ERP function,
The step of providing the design file editing UI includes:
Providing a script editing UI for editing a script of a method specified in a control displayed on the function screen editing UI;
Changing a script assigned to one of the controls displayed on the function screen editing UI according to a user's input on the script editing UI;
And reflecting the changed script to the design file.

12. The method of claim 11,
Wherein the container UI further comprises a UI object corresponding to a report file, wherein the report file contains information about properties of a plurality of controls constituting a report electronic document, and information about data bound to each control being;
To create a custom ERP function,
Providing a report editing UI for editing the report electronic document based on the report file when a UI object corresponding to the report file is selected;
Changing a control for configuring the report electronic document, an attribute of each control, and data bound to each control according to a user's input on the report editing UI;
Reflecting the control constituting the changed report electronic document, the attributes of each control and the data bound to each control in the report file; And
And generating a report document based on the report file.