WO2018097361A1 - Procédé de création de fonctions erp définies par l'utilisateur et système informatique d'exécution associé - Google Patents

Procédé de création de fonctions erp définies par l'utilisateur et système informatique d'exécution associé Download PDF

Info

Publication number
WO2018097361A1
WO2018097361A1 PCT/KR2016/013693 KR2016013693W WO2018097361A1 WO 2018097361 A1 WO2018097361 A1 WO 2018097361A1 KR 2016013693 W KR2016013693 W KR 2016013693W WO 2018097361 A1 WO2018097361 A1 WO 2018097361A1
Authority
WO
WIPO (PCT)
Prior art keywords
file
sql
editing
user
function
Prior art date
Application number
PCT/KR2016/013693
Other languages
English (en)
Korean (ko)
Inventor
이강수
Original Assignee
(주) 더존비즈온
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by (주) 더존비즈온 filed Critical (주) 더존비즈온
Publication of WO2018097361A1 publication Critical patent/WO2018097361A1/fr

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28—Databases characterised by their database models, e.g. relational or object models
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
    • G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
    • G06F3/048—Interaction techniques based on graphical user interfaces [GUI]

Definitions

  • the present invention relates to a method for generating a user-defined ERP function and a computing system performing the same. More specifically, the present invention relates to a method for enabling a user who uses ERP software, such as an enterprise, to easily implement an ERP function appropriate to his or her business process through an integrated development environment, and a computing system performing the method.
  • ERP software such as an enterprise
  • Enterprise Resource Planning is a computer system for enterprise management and management or packaged software installed in such systems. Representative companies dealing with ERP are SAP, Oracle, etc. Can be mentioned. Meanwhile, in order for an enterprise to be provided with an ERP service, not only ERP software should be installed in a user terminal in the enterprise, but also a database for storing various information of the corresponding enterprise must be established.
  • the ERP system enables companies to efficiently manage accounting, personnel, payroll, sales, trade, purchasing, materials, production, outsourcing, services, and management information.
  • companies can maximize productivity by introducing ERP system and reducing inefficiency caused by different information systems between management departments.
  • ERP can provide the advantage of systematically identifying and managing a variety of corporate information.
  • ERP software needs to be customized to suit the characteristics, business processes, and workflows of the enterprise, unlike typical packaged software.
  • each company had to analyze the requirements and business processes of each company and develop customized ERP software to be applied to the company. It took a lot of time and money to build an ERP system. In addition, due to the high cost, it is very difficult for a small company to adopt an ERP system.
  • the technical problem to be solved by the present invention is to provide an integrated development environment to enable the integrated development of database modeling, SQL query and UI for manipulating the database, thereby creating a customized ERP individual function suitable for the enterprise To provide a method and a computing system for performing the same.
  • a method for generating a user-defined enterprise resource planning (ERP) function performed by a predetermined computing system, the UI object corresponding to the ERD file, the UI corresponding to each of the at least one SQL file Providing a container UI including a UI object corresponding to the object and the design file, wherein the ERD file is a file that stores information modeling the attributes of the tables stored in the database and the relationship between each table, the SQL file Is a file that stores a Structured Query Language (SQL) query for manipulating the database, and the design file is a file that stores information about attributes of at least one control constituting a screen of the user-defined ERP function.
  • ERP enterprise resource planning
  • Write down at least some of the controls that make up the screen for the user-defined ERP function A control mapped to a specific query included in one SQL file; providing an editing of the ERD file for editing the ERD file when a UI object corresponding to the ERD file is selected; and the at least one SQL If a UI object corresponding to any one of the files is selected, providing an SQL file editing function for editing an SQL file corresponding to the selected UI object; if the UI object corresponding to the design file is selected, the design 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. Is provided.
  • providing the ERD file editing function comprises: providing the ERD file editing UI based on the ERD file, wherein the ERD file editing UI is a table structure UI object representing a schema of a database table. And a relationship UI object indicating a relationship between tables; changing a relationship between a table schema and a table schema according to a user input on the ERD file editing UI, and changing the relationship between the changed table schema and the table schema to the ERD file. And reflecting.
  • the providing of the SQL file editing function may include providing an SQL editing UI displaying an SQL query stored in the SQL file, and changing an SQL query according to a user input on the SQL editing UI. And reflecting the changed SQL query in the SQL file.
  • At least some of the controls included in the design file are mapped to predetermined parameter variable names, and at least one SQL query included in the at least one SQL file is created and executed including the parameter variable names.
  • the data input to the control mapped to the parameter variable name may be input to the SQL query.
  • the providing of 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 a control constituting the screen of the user-defined ERP function and properties of each control according to an input, and mapping at least a portion of the control displayed on the function screen editing UI to a specific query included in the at least one SQL file Providing a SQL mapping UI for the at least one control, mapping at least some of the controls displayed in the control editing UI to a specific query included in the at least one SQL file according to a user input on the SQL mapping UI, and changing the user-defined ERP 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.
  • a SQL mapping UI for mapping at least a portion of the controls displayed on the function screen editing UI with a specific query included in the at least one SQL file, and in accordance with the user input on the SQL mapping UI Mapping at least a portion of the controls displayed in the control editing UI with a specific query included in the at least one SQL file comprises displaying each SQL query included in the at least one SQL file, and a user displayed SQL query. Selecting one of the following: displaying a parameter variable name included in the selected SQL query, mapping each displayed parameter variable name to a control displayed in the function screen editing UI, and editing the selected SQL query in the function screen editing Mapping with any one grid control displayed in the UI.
  • the design file further includes a script of a method to be executed when a specific event occurs in a control constituting the screen of the user-defined ERP function
  • providing the design file editing UI includes: Providing a script editing UI for editing a script of a method assigned to a control displayed on a function screen editing UI, and changing a script assigned to any one of the controls displayed on the function screen editing UI according to a user input on the script editing UI
  • the method may further include reflecting the changed script in the design file.
  • the container UI further comprises a UI object corresponding to a report file, wherein the report file relates to information about properties of a plurality of controls constituting a report electronic document and to data bound to each control.
  • a file including information wherein the user-defined ERP function generating method comprises: 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 constituting the report electronic document, properties of each control, and data bound to each control according to a user input on the report editing UI; controls constituting the changed report electronic document; properties of each control And reflecting data bound to each control in the report file.
  • the method may include 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 above-described method.
  • At least one processor including a memory for storing a computer program executed by the processor, wherein the computer program, when executed by the processor, a method for generating a user-defined ERP function
  • the method may further include providing a container UI including a UI object corresponding to an ERD file, a UI object corresponding to each of the at least one SQL file, and a UI object corresponding to the design file.
  • the ERD file is a file for storing information modeling the attributes of the tables stored in a database and the relationship between the tables.
  • the SQL file is a file for storing an SQL query for operating the database.
  • At least one of the screens of the user-defined ERP function A file that stores information about properties of a control, 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 the user-defined ERP function based on one SQL file and the design file A computing system is provided that includes a step.
  • providing the ERD file editing function comprises: providing the ERD file editing UI based on the ERD file, wherein the ERD file editing UI is a table structure UI object representing a schema of a database table. And a relationship UI object indicating a relationship between tables; changing a relationship between a table schema and a table schema according to a user input on the ERD file editing UI, and changing the relationship between the changed table schema and the table schema to the ERD file. And reflecting.
  • the providing of the SQL file editing function may include providing an SQL editing UI displaying an SQL query stored in the SQL file, and changing an SQL query according to a user input on the SQL editing UI. And reflecting the changed SQL query in the SQL file.
  • At least some of the controls included in the design file are mapped to predetermined parameter variable names, and at least one SQL query included in the at least one SQL file is created and executed including the parameter variable names.
  • the data input to the control mapped to the parameter variable name may be input to the SQL query.
  • the providing of 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 a control constituting the screen of the user-defined ERP function and properties of each control according to an input, and mapping at least a portion of the control displayed on the function screen editing UI to a specific query included in the at least one SQL file Providing a SQL mapping UI for the at least one control, mapping at least some of the controls displayed in the control editing UI to a specific query included in the at least one SQL file according to a user input on the SQL mapping UI, and changing the user-defined ERP 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.
  • a SQL mapping UI for mapping at least a portion of the controls displayed on the function screen editing UI with a specific query included in the at least one SQL file, and in accordance with the user input on the SQL mapping UI Mapping at least a portion of the controls displayed in the control editing UI with a specific query included in the at least one SQL file comprises displaying each SQL query included in the at least one SQL file, and a user displayed SQL query. Selecting one of the following: displaying a parameter variable name included in the selected SQL query, mapping each displayed parameter variable name to a control displayed in the function screen editing UI, and editing the selected SQL query in the function screen editing Mapping with any one grid control displayed in the UI.
  • the design file further includes a script of a method to be executed when a specific event occurs in a control constituting the screen of the user-defined ERP function
  • providing the design file editing UI includes: Providing a script editing UI for editing a script of a method assigned to a control displayed on a function screen editing UI, and changing a script assigned to any one of the controls displayed on the function screen editing UI according to a user input on the script editing UI And reflecting the changed script in the design file.
  • the container UI further comprises a UI object corresponding to a report file, wherein the report file relates to information about properties of a plurality of controls constituting a report electronic document and to data bound to each control.
  • a file including information wherein the user-defined ERP function generating method comprises: 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 constituting the report electronic document, properties of each control, and data bound to each control according to a user input on the report editing UI; controls constituting the changed report electronic document; properties of each control And reflecting data bound to each control in the report file.
  • the method may include generating a report document based on the report file.
  • an integrated development environment for integrating database modeling, SQL query and UI for manipulating the database can be provided, and through this, an ERP individual function customized for an enterprise can be created. And a computing system performing the same.
  • FIG. 1 is a schematic diagram of a computing device for performing a method for generating a user-defined ERP function according to an embodiment of the present invention.
  • FIG. 2 is a diagram schematically illustrating a process of generating a user-defined ERP function by a computing system according to an embodiment of the present invention.
  • 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.
  • FIG. 4 is a diagram illustrating an example of a project window.
  • FIG. 5 is a diagram illustrating an example of a database search window.
  • FIG. 6 is a flowchart schematically illustrating a process of performing an ERD file editing function by a computing system according to an embodiment of the present invention.
  • FIG. 7 is a diagram illustrating an example of an ERD file editing UI.
  • FIG. 8 is a flowchart schematically illustrating a process of performing a SQL file editing function by a computing system according to an embodiment of the present invention.
  • FIG. 9 is a diagram illustrating an example of an SQL file editing UI.
  • FIG. 10 is a flowchart schematically illustrating a process of performing a design file editing function by a computing system according to an embodiment of the present invention.
  • FIG. 11 is a diagram illustrating an example of a design file editing UI.
  • FIG. 12 is a diagram illustrating an example of a toolbox window.
  • 13 is a diagram illustrating an example of an attribute window.
  • FIG. 14 is a diagram illustrating an example of a script window.
  • 15A to 15E illustrate an example of the SQL mapping UI.
  • 16 is a flowchart schematically illustrating a mapping process between SQL and a control.
  • first and second 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 component when one component 'transmits' data to another component, the component may directly transmit the data to the other component, or through at least one other component. Means that the data may be transmitted to the other component.
  • the component when one component 'directly transmits' data to another component, it means that the data is transmitted from the component to the other component without passing through the other component.
  • FIG. 1 is a diagram illustrating an execution environment of a method for generating a user-defined ERP function according to an embodiment of the present invention.
  • a method for 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 phone, a session initiation protocol (SIP), a wireless local loop (WLL) station, a smartphone, a tablet PC, a personal digital assistant (PDA), or a desk. It can include a tower or laptop.
  • a handheld device such as a mobile phone, a satellite phone, a wireless phone, a session initiation protocol (SIP), a wireless local loop (WLL) station, a smartphone, a tablet PC, a personal digital assistant (PDA), or a desk. It can include a tower or laptop.
  • SIP session initiation protocol
  • WLL wireless local loop
  • PDA personal digital assistant
  • 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 one 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 devices spaced apart from each other to perform respective functions. As a result, it may be implemented as a set of logical configurations for implementing the technical idea of the present invention. In addition, the computing system 100 may refer to a set of components that are 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.
  • the computing system 100 is at least one communication module or computing system capable of communicating with an external system (eg, 200) and / or various user terminals (eg, 300) via a network.
  • a control module that performs the main functions of 100 and controls and functions and / or resources of other components included in the computing system 100
  • a storage module that can store various information, and can interface with a user.
  • I / O module and the like can be included.
  • Various modules included in the computing system 100 may be located in different physical devices or may be located in the same physical device.
  • the computing system 100 may further include a DB 130 for storing various data necessary for implementing the technical idea of the present invention and various information of an enterprise.
  • the DB 130 is included in the computing system 100, but in another embodiment, the DB 130 is physically separated from the computing system 100. It may be implemented in the form of a system. In this case, the computing system 100 and the DB 130 may be connected through a network to transmit and receive various data or information. In addition, according to an implementation example, the computing system 100 may operate in conjunction with a plurality of DBs included in the computing system or connected through a network.
  • DB DataBase
  • DBMS Database Management System
  • DB database Management System
  • it may be implemented in various ways such as a linked-list, a tree, a relational DB, and includes all data storage media and data structures capable of storing information to be stored in the DB 130. It can be used to mean.
  • the module may mean a functional and structural combination of hardware for performing the technical idea of the present invention and software for driving the hardware.
  • the module may mean a logical unit of a predetermined code and a hardware resource for performing the predetermined code, and means a physically connected code or does not necessarily mean one kind of hardware. It can be easily inferred by the average expert in the art.
  • 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 drive module 120 (hereinafter, referred to as a “drive module”). ) May be included.
  • a generation module hereinafter, referred to as a “generation module”
  • the user-defined ERP function drive module 120 hereinafter, referred to as a “drive module”.
  • the generation module 110 may perform a function of generating a user-defined ERP function or editing a previously generated user-defined ERP function.
  • the driving module 120 may drive the user-defined ERP function generated by the generation module 110 to provide the user-defined ERP function.
  • the generation module 110 and the driving module 120 may be implemented in the form of independent physical devices, respectively.
  • the two systems 110 and 120 may be implemented as one physical device according to an embodiment.
  • the two systems 110 and 120 may be configured as separate software logically separated from each other, or may be implemented in the form of one integrated software.
  • a function of generating a user-defined ERP function according to the spirit of the present invention is performed by the generation module 110, and a function of driving the generated ERP function is performed by the driving module 120.
  • the computing system 100 performs a combination of a user-defined ERP function generating function and a generated user-defined ERP function driving function according to the technical spirit of the present invention. It may be implemented in one system.
  • User-defined ERP functions can be integrated into an ERP system and can be unit functions with their own meaning.
  • the user-defined ERP function may perform a function of managing, manipulating, using, and analyzing enterprise information stored in the DB 130.
  • a customized user interface can be provided for the user to perform these functions. That is, the user may manage, manipulate, use, and analyze enterprise information stored in the DB 130 through a UI provided by a user-defined ERP function.
  • Examples of user-defined ERP functions include document entry, book management, account increase management, bond age analysis / management, settlement of accounts, financial statements, fund / budget management, budget / use analysis, fixed asset management, tax return management, financial account management, etc. , Personnel management, attendance management, payroll management, social insurance management, year-end settlement management, retirement settlement management, tax return management, income-specific slip processing, daily work management, domestic sales plan establishment / management, quotation / order processing, request / inspection management , Issue / return processing, sales contribution analysis, delivery / delivery management, temporary issue / consignment management, sales settlement, electronic tax invoice processing, collection / debt management, bond age analysis, export plan establishment / management, order management, issue processing, Sales Settlement, Shipment Management, Goods / Order Processing, Shipment / Receipt Management, Import Cost Processing, Non-Settlement Processing, Import Cost Allocation, MPS, Required Materials Calculation, Invoice / Order, Goods Receipt / Inspection, Temporary Goods Receipt Management
  • the computing system 100 may be connected to a predetermined sharing system 200 through a network to transmit and receive various information, data, signals, and / or messages necessary to implement the technical idea of the present invention. Can be.
  • the computing system 100 may transmit a result generated through a user-defined ERP function generation function to the sharing system 200, and the sharing system 200 may provide (transmit) it if desired by other users. . That is, the sharing system 200 may play a role of allowing each user to share a user-defined uploaded ERP function with other users.
  • the result generated by the ERP function generation function may include an ERP file, at least one SQL file, and a design file.
  • the result file may further include a report file.
  • the ERD file may be a file that stores information modeling the attributes of the tables stored in the DB 130 and the relationships between the tables.
  • An entity relationship diagram is the most data-modeling technique that uses simple shapes (squares, ellipses, diamonds, etc.) to describe the structure and relationships of data, and to form relationships and properties between data entities. Most commonly used as a tool. Users can visually understand this easily by using ERD to graphically represent the relationship of the database.
  • Components of an ERD include an entity, a relationship, and an attribute.
  • An entity represents an object that is separated into the subject or object of information to be stored in the database. In database modeling, one table stored in the database may be an object.
  • a relationship represents how two or more entities are related to each other. Attributes are data items that describe the characteristics of an entity or relationship. Attributes that uniquely identify each entity are called key attributes.
  • the SQL file may be a file that stores a structured query language (SQL) query for manipulating the DB 130.
  • SQL structured query language
  • 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 write queries to retrieve and manage data stored in a database, create and modify database schemas, and manage database object access coordination. Can be used. SQL commands can be classified into three categories: data manipulation (DML), data definition (DDL), and data control (DCL). Data manipulation (DML) is a command used to modify or retrieve data in a database, such as INSERT (add data), UPDATE (update data), DELETE (delete data), and SELECT (data search).
  • DML data manipulation
  • INSERT add data
  • UPDATE update data
  • DELETE delete data
  • SELECT data search
  • Data definition is a command used to modify the structure of a table or the like that contains data, such as CREATE (create a table, etc.), DROP (remove a table, etc.), ALTER (change a table, etc.).
  • Data control is a command that grants or revokes access to the database. It includes GRANT and REVOKE.
  • the design file may be a file that stores information about attributes of at least one control constituting the screen of the user-defined ERP function.
  • the control may be a UI object that can perform interaction with the user such as displaying information or receiving information from the user.
  • At least some of the controls constituting the screen of the user-defined ERP function may be controls mapped to a specific query included in the at least one SQL file, which will be referred to as a grid control hereinafter.
  • the report file may include information about properties of a plurality of controls constituting a report electronic document and information about data bound to each control.
  • FIG. 2 is a diagram briefly illustrating a process of generating a user-defined ERP function by the generation module 110 according to an embodiment of the present invention.
  • the generation module 110 may provide 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.
  • the user may select any one of the UI objects included in the container UI in operation S120.
  • the generation module 110 may provide an ERD file editing function for editing the ERD file (S130).
  • the generation module 110 may provide an SQL file editing function for editing the SQL file (S140).
  • the generation module 110 may provide an ERD file editing function for editing the design file (S150).
  • the generation module 110 may provide an integrated development environment for the user to create and customize a user-defined ERP function.
  • users can create or edit ERD files, SQL files, design files, and report files required to run custom ERP functions.
  • a user may generate a plurality of user-specified ERP functions through the generation module 110, in which case the plurality of user-specified ERP functions may be managed as a single project corresponding thereto.
  • Each project can be a package or container that contains at least one SQL file and a design file.
  • ERD file Even if multiple projects exist, there may be one ERD file. In this case, a plurality of user-specified ERP functions generated by the plurality of projects may use one common ERD file.
  • 3 is a diagram illustrating an example of a UI of an integrated development environment provided by the generation module.
  • 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, and a property window 1600. ), May include a script window 1700.
  • the menu 1100 may include a plurality of icons, and each icon may be a UI object for executing a function frequently used by a 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 (eg, an icon) 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.
  • a UI object eg, an icon
  • FIG. 4 is a diagram illustrating an example of the project window 1200.
  • a UI object 1211 corresponding to an ERD file may be displayed, and when a UI object 1211 corresponding to the ERD file is selected by a user ( For example, when a corresponding UI object is clicked, double-clicked, or touched), the generation module 110 may provide an ERD file editing function for editing the ERD file.
  • the generation module 110 may display a UI for editing an 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. Can be.
  • 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 may 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 may be added as a lower level of the ERD container UI object 1210. Can be.
  • the newly generated ERD file may be a blank file including no information.
  • UI objects 1201, 1202, and 1203 corresponding to each of at least one project may be displayed, and each project may correspond to a different user-defined ERP function.
  • each project may be a container including at least one SQL file, a design file, and at least one report file
  • the project window 1200 may include at least one belonging to each project (eg, 1202).
  • UI objects 1221 and 1222 corresponding to each of the SQL files of the UI object
  • UI objects 1231 corresponding to each of the at least one report file
  • the UI objects 1241 corresponding to the design file may be displayed.
  • the UI objects 1221 and 1222 corresponding to each of the 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 some way to generate a new SQL file, and the UI object corresponding to the newly created SQL file is added to the lower level of the SQL container UI object 1220.
  • the newly created SQL file may be an empty file including no information.
  • the UI object 1231 corresponding to each of the at least one report file may be displayed at a lower level of the report container UI object 1230.
  • the user may 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 may be added as a lower level of the report container UI object 1230.
  • the newly generated report file may be an empty file including no information.
  • the generation module 110 may generate an SQL file corresponding to the selected UI object 1221.
  • SQL file editing function can be provided for editing.
  • the generation 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. Can be.
  • the generation module 110 may provide a report editing UI for editing a report electronic document.
  • the generation 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 a report file on the UI displayed in the editor window 1400. Can be.
  • the generation module 110 may provide a design file editing function for editing the design file.
  • the generation module 110 may display a UI for editing the 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. Can be.
  • a user may generate a new design file by interacting with a UI object (eg, 1202) corresponding to a specific project in a predetermined manner, and the UI object corresponding to the newly created design file corresponds to the project. It can be added as a lower level of the UI object 1202.
  • the newly created design file may be an empty file including no information.
  • the generation module 110 provides each file editing function on the editor window 1400 included in the integrated development environment UI 1000 has been described, but according to an embodiment, the generation module 110 May execute a separate application corresponding to each file editing function, in which case the user may edit each file on the executed application.
  • 5 is a diagram illustrating an example of a database search window 1300.
  • the database search window 1300 may include UI objects 1310 and 1320 corresponding to the DB 130 connected to the computing system 100 or the generation module 110.
  • the UI object may have UI objects 1311 to 1313 representing at least one schema at a lower level.
  • a schema is a structure that defines the structure of data in a database, how data is represented, and the relationship between data in a formal language, or as a namespace, and may mean a container including objects such as a table and a stored procedure. Therefore, a lower level of the UI object representing a specific schema may have UI objects corresponding to each object such as a table or a stored procedure included in the schema.
  • a table refers to a collection of data composed of fields, which are items for storing respective data, and one database may be composed of several tables.
  • a stored procedure or stored procedure is a set of queries for executing a series of queries as a function.
  • a stored procedure is a stored procedure in the database management system that organizes a series of operations on a database. Also called a Persistent Storage Module.
  • the editor window 1400 may display an editing UI corresponding to the file selected by the user.
  • FIG. 6 is a flowchart schematically illustrating a process of the generation module 110 performing an ERD file editing function.
  • the generation module 110 may provide an ERD file editing UI (S131).
  • the generation module 110 may display an ERD file editing UI in the editor window 1400.
  • the ERD file editing UI may include a table structure UI object representing a structure of a database table and a relationship UI object representing a relationship between a table.
  • the generation module 110 may change a relationship between a table schema and a table schema according to a user input on the ERD file editing UI (S132).
  • the changed table structure and the relationship between the tables may be reflected in the ERD file (S133).
  • the generation module 110 may provide an ERD file editing UI 2000 through the editor window 1400 based on the contents of an ERD file corresponding to an ERD file object selected by a user.
  • FIG. 7 is a diagram illustrating an example of an ERD file editing UI 2000.
  • the ERD file editing UI 2000 may include 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. Can be.
  • the ERD file editing UI 2000 may include a table structure UI object (eg, 2210, 2220, 2230) representing a structure of a database table, and a relationship UI object (eg, 2310, 2320) representing a relationship between a table. It may include.
  • Each column information included in the table may be displayed on the table structure UI objects 2210, 2220, and 2230.
  • the relationship UI objects 2310 and 2320 may be in the form of lines connecting two table structure UI objects.
  • the relationship UI object may be expressed in different forms (for example, solid line or dotted line) according to whether the relationship between the two tables is an identification relationship or a non-identification relationship.
  • the generation module 110 may change a relationship between a table structure and a table structure according to a user input on the ERD file editing UI.
  • the user may create a new table UI object on the ERD file editing UI 2000.
  • the user may create a UI object corresponding to a table previously created in the DB 130.
  • a user may input a command such as selecting a UI object corresponding to a specific table displayed in the above-described database search window 1300 or dragging and dropping onto the ERD file editing UI 2000.
  • the generation module 110 may generate a new table UI object corresponding to the table in the ERD file editing UI 2000.
  • the user may select a new table generation UI provided by the ERD file editing UI 2000 to generate a UI object corresponding to the new table.
  • 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, add / delete / change column or change attribute of the table). You may.
  • the user may create a new relationship UI object indicating a relationship between table UI objects existing on the ERD file editing UI 2000.
  • the user selects a button for creating a new relationship provided by the ERD file editing UI 2000 and then selects two tables to form a relationship to generate a new relationship UI object representing a relationship between the two selected tables. Can be.
  • the user may delete the relationship UI object existing on the ERD file editing UI 2000 or change the relationship information through the relationship UI object.
  • the generation module 110 may reflect the relationship between the changed table schema and the table schema in the ERD file.
  • the generation module 110 may change the table structure of the DB 130, add a new table, or delete an existing table by reflecting the relationship between the changed table schema and the table schema DB 130.
  • FIG. 8 is a flowchart schematically illustrating a process of the generation module 110 performing a SQL file editing function.
  • the generation module 110 may provide an SQL editing UI (S141).
  • the generation module 110 may display an SQL editing UI in the editor window 1400.
  • the generation module 110 may change the SQL query according to a user input on the SQL editing UI (S142).
  • the changed query may be reflected in the SQL file (S143).
  • the SQL file editing UI 3000 may be displayed in the editor window 1400. That is, the generation module 110 may provide the SQL file editing UI 3000 displaying the contents of the SQL file corresponding to the SQL file object selected by the user through the editor window 1400.
  • FIG. 9 is a diagram illustrating an example of the SQL file editing UI 3000.
  • 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 releasing the connection, and whether the created query is Insert or Update. It may include a toolbar UI 3100 including a UI for selecting.
  • 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 parameter variable names when creating queries.
  • the parameter variable name may be in the form of '@variable name'.
  • the parameter variable name can be used to associate a query with a control on the function screen editing UI described below.
  • at least some of the controls included in the design file may be mapped to the parameter variable names.
  • data input to the control mapped to the parameter variable name may be input to the SQL query. More precisely, data input to a control mapped to the parameter variable name may be allocated 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 on which an execution result is displayed. On the result display UI 3300, the structure of the table and the data inquired by the query may be displayed.
  • the generation module 110 may reflect the changed SQL query to the SQL file.
  • FIG. 10 is a flowchart schematically illustrating a process in which the generation module 110 performs a design file editing function.
  • the generation module 110 may provide a function screen editing UI (S151).
  • the generation module 110 may display a function editing UI in the editor window 1400.
  • the generation module 110 may change the control constituting the screen of the user-defined ERP function and the property of each control according to a user input on the function screen editing UI (S152).
  • the generation module 110 may reflect, in the design file, the control file constituting the changed screen of the user-defined ERP function, the properties of each changed control, and mapping information between the changed control and the query (S153).
  • the design file editing UI may be displayed in the editor window 1400. That is, the generation module 110 may provide a design file editing UI through the editor window 1400 based on a design file corresponding to a design file object selected by the user.
  • FIG. 11 is a diagram illustrating an example of a design file editing UI 4000.
  • the design file editing UI 4000 may display various controls (for example, 4010 to 4040) previously defined in the design file.
  • the user can delete the control 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 new controls to the design file editing UI 4000.
  • the generation module 110 may provide a toolbox window 1500 for selecting various controls. 12 is a diagram illustrating an example of a toolbox window 1500.
  • the toolbox window 1500 may include various types of controls, and the user may select a desired control or drag and drop it to the design file editing UI 4000 to drop the control into the design file editing UI. It can be placed at (4000).
  • various controls may be classified into specific categories in the toolbox window 1500 according to a predetermined classification criterion.
  • a common control 1510 commonly used in a GUI a business control 1520 specially used in the ERP field, a data control 1530, and a layout of a screen are configured.
  • the layout control 1550, a popup control 1570, etc., serving as a container may be classified.
  • a control belonging to the data control category 1530 may perform a function of displaying data retrieved by an SQL query.
  • Data controls can include a Flex Grid that displays in the form of a data table queried by an SQL query, a Pivot Grid that displays in a PivotTable format, and a Chart Grid that displays in the form of a chart. have.
  • An example of a flex grid is the data control 4040 of FIG. 11.
  • the property value of the selected control may be displayed in the property window 1600, and the user may view the property window. You can change the property value of the control shown in (1600). 13 is a diagram illustrating an example of a property window 1600.
  • the script window 1700 has a method indicating an action to be performed when a specific event occurs.
  • the script can be displayed and the user can create / edit the method script shown in the script window 1700.
  • 14 is a diagram illustrating an example of a script window 1700.
  • the script window 1700 includes a UI 1710 for selecting any one of the controls disposed in the design file editing UI 4000, and a UI 1720 for selecting an event that may occur in the control. It may include a UI 1730 for writing a method script to be executed when the selected event occurs in the selected control.
  • 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 may include a SQL mapping UI for mapping at least a portion (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. The at least one control may be mapped to a specific query included in the at least one SQL file according to a user input on the SQL mapping UI.
  • 15A to 15E illustrate an example of the SQL mapping UI.
  • the SQL mapping UI 5000 illustrated 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.
  • a query named SQL may be mapped to a given data control.
  • the user can map parameters and input controls (controls that can receive data from the user) described in the SQL query through the SQL mapping UI (5000), and map the SQL query and the data control to display the results of the query. can do.
  • the UI 5100 as shown in FIG. 15B may be displayed.
  • a user may map each parameter variable name included in an SQL statement and a specific control (eg, 4010 and / or 4030) included in the design file editing UI 4000. have.
  • the control mapped to the parameter variable name may be a control (input control) that performs a function of receiving data from a user.
  • the UI 5100 may include a list 5110 listing each parameter variable name included in an SQL statement.
  • the UI 5100 may include a UI for selecting a control to be mapped to each parameter variable name. For example, 5101 to 5103).
  • @multiModule is mapped with bpComboBox1 4010
  • @keyword is mapped with textBoxExt1 4030.
  • the UI 5200 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 (e.g. 4040) to be mapped with the SQL query.
  • a data control e.g. 4040
  • the UI 5200 may be used to perform customization such as selecting a column to be used / outputted from among columns included in a DB table to be queried through an SQL query, adjusting a display order, or setting a display format of each field. ) May be further included.
  • the UI 5300 may be displayed as illustrated in FIG. 15D.
  • a user may map a specific control included in the design file editing UI 4000 and a column included in a DB table to be queried through an SQL query.
  • the UI 5400 shown in FIG. 15E may be displayed.
  • the UI 5400 as shown in FIG. 15E includes a UI 5410 for selecting an SQL query for inserting a record inserted through the data control into a database, and a UI 5520 for selecting a query for updating changed data on the data control. ), A UI 5430 for selecting a query for deleting a record.
  • 16 is a flowchart schematically illustrating the above-described mapping process.
  • the generation module 110 may display each SQL query included in the at least one SQL file (S210).
  • the selected SQL query may be analyzed to obtain a parameter variable name included in the SQL query (S220), and the obtained parameter variable name may be displayed.
  • the generation module 110 may map each parameter variable name displayed with the control (for example, 4010 or 4030) displayed on the design file editing UI 4000 (S240). .
  • the generation module 110 may map the SQL query selected by the user's input with any one data control (for example, 4040) displayed on the design file editing UI 4000 (S240 and S250).
  • the driving module 120 may drive the user-defined ERP function generated by the generation module 110 to provide the user-defined ERP function.
  • the generation 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 information and drive the user-defined ERP function.
  • the driving module 120 may be a kind of engine that receives a kind of metadata or a script and performs an operation corresponding thereto.
  • the driving module 120 may configure a screen of a user-defined ERP function by using information about various controls included in the design file, and display it.
  • the driving module 120 may perform a method, a script, or a built-in function corresponding thereto.
  • the driving module 120 may execute an SQL query mapped to the data control and reflect the execution result to the data control or the DB 130.
  • the driving module 120 may perform various instructions to enable the user-defined ERP function to operate correctly.
  • the method for generating a user-defined ERP function may be implemented in a computer-readable program command form and stored in a computer-readable recording medium.
  • the computer-readable recording medium includes all kinds of recording devices in which data that can be read by a computer system is stored.
  • the program instructions recorded on the recording medium may be those specially designed and constructed for the present invention, or may be known and available to those skilled in the software art.
  • Examples of computer-readable recording media include magnetic media such as hard disks, floppy disks, and magnetic tape, optical media such as CD-ROMs, DVDs, floppy disks, and the like. Included are hardware devices specifically configured to store and execute the same magneto-optical media and program instructions such as ROM, RAM, flash memory, and the like.
  • the computer readable recording medium can also be distributed over network coupled computer systems so that the computer readable code is stored and executed in a distributed fashion.
  • Examples of program instructions include not only machine code generated by a compiler, but also devices that process information electronically using an interpreter, for example, high-level language code that can be executed by a computer.
  • the hardware device described above may be configured to operate as one or more software modules to perform the operations of the present invention, and vice versa.
  • the present invention can be used in a method for generating a user-defined ERP function and a computing system performing the same.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Strategic Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Economics (AREA)
  • Human Computer Interaction (AREA)
  • Marketing (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

L'invention concerne un procédé permettant à un utilisateur, tel qu'une société, d'utiliser un logiciel (ERP) de planification de ressources d'entreprise pour exécuter facilement des fonctions ERP appropriées à un processus de travail de l'utilisateur au moyen d'un environnement de développement intégré, ainsi qu'un système informatique permettant d'exécuter ledit procédé. Selon un aspect de l'invention, l'invention concerne un procédé permettant de créer des fonctions ERP définies par l'utilisateur, ledit procédé étant exécuté par un système informatique prédéterminé et consistant à : fournir une UI de conteneur comprenant un objet UI correspondant à un fichier ERD, les objets UI correspondant chacun à au moins un fichier de langage d'interrogation structuré respectif (SQL), et un objet UI correspondant à un fichier de conception, le fichier ERD étant un fichier permettant de stocker les propriétés des tables stockées dans une base de données ainsi que les informations associées à la modélisation des relations entre chaque table, le fichier SQL étant un fichier permettant de stocker des requêtes SQL pour utiliser la base de données, et le fichier de conception étant un fichier permettant de stocker des informations sur les propriétés d'au moins une commande constituant un écran pour les fonctions ERP définies par l'utilisateur, au moins certaines des commandes qui constituent l'écran pour les fonctions ERP définies par l'utilisateur étant des commandes mappées avec des requêtes spécifiques incluses dans le ou les fichiers SQL ; lorsque l'objet UI correspondant au fichier ERD est sélectionné, fournir une fonction d'édition de fichier ERD permettant d'éditer le fichier ERD ; lorsqu'un objet UI correspondant à l'un quelconque du ou des fichiers SQL est sélectionné, fournir une fonction d'édition de fichier SQL permettant d'éditer le fichier SQL correspondant à l'objet UI sélectionné ; lorsque l'objet UI correspondant au fichier de conception est sélectionné, fournir une fonction d'édition de fichier de conception permettant d'éditer le fichier de conception ; et fournir des fonctions ERP définies par l'utilisateur d'après le fichier ERD, le ou les fichiers SQL et le fichier de conception.
PCT/KR2016/013693 2016-11-23 2016-11-25 Procédé de création de fonctions erp définies par l'utilisateur et système informatique d'exécution associé WO2018097361A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
KR10-2016-0156721 2016-11-23
KR1020160156721A KR20180072889A (ko) 2016-11-23 2016-11-23 사용자 정의 erp 펑션 생성 방법 및 이를 수행하는 컴퓨팅 시스템

Publications (1)

Publication Number Publication Date
WO2018097361A1 true WO2018097361A1 (fr) 2018-05-31

Family

ID=62195446

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/KR2016/013693 WO2018097361A1 (fr) 2016-11-23 2016-11-25 Procédé de création de fonctions erp définies par l'utilisateur et système informatique d'exécution associé

Country Status (2)

Country Link
KR (1) KR20180072889A (fr)
WO (1) WO2018097361A1 (fr)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR102244887B1 (ko) * 2019-10-01 2021-04-28 (주) 더존비즈온 Sql 쿼리 추천 방법 및 시스템
KR102265629B1 (ko) * 2020-12-23 2021-06-16 (주)이앤시스 공용 프레임워크 기반의 정산처리 모듈 제공 시스템

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20040093680A (ko) * 2003-04-29 2004-11-08 이종태 Ｅｒｐ 신속 구축 시스템 및 그 구축 방법
KR20100122151A (ko) * 2009-05-12 2010-11-22 나문수 자동 생성 폼 기반의 데이터베이스 애플리케이션 생성 방법 및 이를 실현시키기 위한 프로그램을 기록한 컴퓨터로 판독 가능한 기록 매체
JP4939007B2 (ja) * 2005-08-01 2012-05-23 ケン・システムコンサルティング株式会社 システム設計支援プログラム
KR20130033652A (ko) * 2011-09-27 2013-04-04 이메디정보기술(주) 오브젝트 단위의 동적 컴파일리스 프로그램의 저작, 배포 및 구동 방법 및 장치
KR101614908B1 (ko) * 2015-09-18 2016-04-22 (주)트러시스 Erp 서비스제공시스템 및 그 방법

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20040093680A (ko) * 2003-04-29 2004-11-08 이종태 Ｅｒｐ 신속 구축 시스템 및 그 구축 방법
JP4939007B2 (ja) * 2005-08-01 2012-05-23 ケン・システムコンサルティング株式会社 システム設計支援プログラム
KR20100122151A (ko) * 2009-05-12 2010-11-22 나문수 자동 생성 폼 기반의 데이터베이스 애플리케이션 생성 방법 및 이를 실현시키기 위한 프로그램을 기록한 컴퓨터로 판독 가능한 기록 매체
KR20130033652A (ko) * 2011-09-27 2013-04-04 이메디정보기술(주) 오브젝트 단위의 동적 컴파일리스 프로그램의 저작, 배포 및 구동 방법 및 장치
KR101614908B1 (ko) * 2015-09-18 2016-04-22 (주)트러시스 Erp 서비스제공시스템 및 그 방법

Also Published As

Publication number Publication date
KR20180072889A (ko) 2018-07-02

Similar Documents

Publication Publication Date Title
WO2018097407A1 (fr) Procédé et système de partage de fonctions erp définies par l'utilisateur
US20230244476A1 (en) Systems and methods for code analysis heat map interfaces
US7269798B2 (en) Information processing apparatus for project management and its computer software
US8260764B1 (en) System and method to search and generate reports from semi-structured data
US20160019488A1 (en) Workflow management device and workflow management method
JP2016029558A (ja) ワークフロー管理システムにおいて実行するためのアプリケーションを開発する方法、及びワークフロー管理システムにおいて実行するためのアプリケーションの生成を支援する装置
JP2007233474A (ja) 案件情報作成支援システム及びプログラム
US11436029B2 (en) Help information display system, help information display method, and help information display program
US9807169B2 (en) Distributed tagging of data in a hybrid cloud environment
CN101650800A (zh) 一种更新项目任务计划系统中任务内容的方法和装置
US20080140608A1 (en) Information Managing Apparatus, Method, and Program
US7707211B2 (en) Information management system and method
WO2018097361A1 (fr) Procédé de création de fonctions erp définies par l'utilisateur et système informatique d'exécution associé
US10303668B2 (en) Automatic screen generation device, automatic screen generation program, and automatic screen generation method
US20240036890A1 (en) System and method of a modular framework for configuration and reuse of web components
CN113537943A (zh) 一种通用工作流引擎及其构建方法
JP2022041859A (ja) プログラム、方法、情報処理装置、及びシステム
CN106570189B (zh) 一种计算机应用系统和文档便捷管理方法
WO2021066231A1 (fr) Procédé et système de recommandation de requête sql
WO2019098428A1 (fr) Procédé de fourniture de fonction erp faisant appel à une table de gestion extensible spécifique à un utilisateur, et système de fourniture de fonction erp permettant la mise en œuvre dudit procédé
KR20140081326A (ko) 행정업무 처리 시스템 및 방법
JP2019101829A (ja) ソフトウェア部品管理システム、計算機および方法
CN114153425A (zh) 应用程序建模系统及其建模方法
CN108984176B (zh) 一种高自定义桌面开发系统
JP2001056809A (ja) 文書管理システム

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 16922146

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 16922146

Country of ref document: EP

Kind code of ref document: A1