KR20150065292A - Erp program conversion method using relation data base - Google Patents
Erp program conversion method using relation data base Download PDFInfo
- Publication number
- KR20150065292A KR20150065292A KR1020130150434A KR20130150434A KR20150065292A KR 20150065292 A KR20150065292 A KR 20150065292A KR 1020130150434 A KR1020130150434 A KR 1020130150434A KR 20130150434 A KR20130150434 A KR 20130150434A KR 20150065292 A KR20150065292 A KR 20150065292A
- Authority
- KR
- South Korea
- Prior art keywords
- file
- data
- creating
- converting
- data file
- Prior art date
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/455—Emulation; Interpretation; Software simulation, e.g. virtualisation or emulation of application or operating system execution engines
- G06F9/45504—Abstract machines for programme code execution, e.g. Java virtual machine [JVM], interpreters, emulators
- G06F9/45516—Runtime code conversion or optimisation
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
The present invention relates to a method for automatically converting an ERP program using a relational database, and more particularly, to a method for automatically converting a part or whole of a development process of an ERP program to improve quality, shortening a development period, The present invention relates to an automatic conversion method of an ERP program.
In general, enterprise resource planning (ERP) programs integrate personnel information systems, financial information systems, and production management systems, which were independently operated across all areas of the company including personnel, finance, and production, This means management innovation techniques that maximize utilization of material resources. ERP (Enterprise Resource Planning) is driving innovation as a new way of management innovation is the development of software called ERP package became the occasion.
In short, it is a concept to manage all the resources of the enterprise optimally for the integration of information, and it can be regarded as enterprise resource management or business integration management. In other words, it aims at realizing fast and transparent business process by integrally managing business processes throughout the company, realizing management status and sharing information.
In a narrow sense, it also means a computerized system that automatically constructs an integrated computer database to efficiently control the flow of all business activities such as funding, accounting, purchasing, production, and sales.
Once the ERP program is established, companies have all the information they need at the same time, such as production, sales, purchasing, inventory management, and accounting departments, which minimizes the loss of production time and improves inventory accuracy on the system. Effect can be obtained. In particular, manufacturers can reasonably plan for component procurement, which accounts for 60% to 70% of the product price, and respond to new production orders in real time in real time.
However, in order to construct the above-mentioned ERP program, complicated software development steps leading to analysis, design, implementation, testing, application, maintenance, and the like must be performed. Especially, effort, cost, .
An object of the present invention to solve the problems derived from the prior art is to provide an automatic ERP program conversion method using a relational database that allows a user to easily create an ERP program by simplifying a development step for building an ERP program .
The above object is achieved according to an embodiment of the present invention by a method for automatically converting a data file into an ERP program utilizing a relational database providing means for storage management, access control, retrieval and modification of data, A second step of analyzing the data file and converting the data file into a relational database in a predetermined format, a third step of converting the relational database into a predetermined programming language, and a third step of programming the programming language, To an executable file to be executed by the ERP program on the basis of the result of the automatic conversion of the ERP program.
Preferably, the second step includes a 2-B step of analyzing the meta information and the data information of the data file and converting the META information and the data information into a database of a predetermined format, A 2-D step of creating a table, a 2-E step of storing values recorded in the data file in the data table, and a 2-G step of creating a system table for managing values stored in the data table .
Preferably, the step 2 further includes a 2-F step of storing a value not normally stored in the data table in a separate spreadsheet file in step 2-E.
Preferably, the third step includes a 3-C step of creating a program source file and a folder necessary for compiling, a 3-D step of creating a source code of a project file managing a code relation of the source file and a compilation environment 3-E, which creates source code for managing all forms and creating the main menu form, and 3-F for creating source code for class files that collect common functions for database and screen output and error management and data file I / A 3-H step of creating a form for inputting, modifying, deleting and searching designated items and values in the data file, and a source program for managing the source codes created in steps 3-E and 3 -F, And a 3-I step of editing the image.
Preferably, the fourth step includes a step 4-A of compiling the source code written in the programming language into an executable file so that the user can use the source code, and a 4-A step of copying the executable file to a folder and name designated by the user And 4-C checking whether the executable file is correctly executed.
Preferably, the method further includes a fifth step of distributing the executable file to a specific computer in a network environment.
Preferably, the executable file is distributed to a computer on a network sharing the data file.
According to the present invention, it is possible to simplify a development step for building an ERP program and easily convert it into an ERP program using a relational database, thereby improving productivity.
1 is an overall flowchart for explaining an automatic ERP program conversion method using a relational database according to an embodiment of the present invention,
FIG. 2 is a flow chart illustrating S2 in FIG. 1 in detail,
3 is a flow chart for explaining S3 in Fig. 1 in detail,
4 is a flow chart for explaining details of S4 in Fig. 1,
FIG. 5 is a flowchart for explaining S5 in FIG. 1 in detail.
Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings. Brief Description of Drawings FIG. 1 is a block diagram of a computer system according to an embodiment of the present invention; FIG. 2 is a block diagram of a computer system according to an embodiment of the present invention; FIG.
The present invention is for automatically converting a data file into an ERP program utilizing a relational database providing means for storage management, access control, retrieval and modification of data,
As shown in FIG. 1, a method for automatically converting an ERP program using a relational database according to an embodiment of the present invention includes a first step (S1) of selecting a data file, a step of analyzing the data file, A third step S3 of converting the relational database into a predetermined programming language, and a third step S3 of converting the programming language into an executable file that is executed as an ERP program on a computer platform (S4) and a fifth step (S5) of distributing the executable file to a specific computer in a network environment.
The data file of the first step S1 may be a file prepared by the user in accordance with the job, and may be a spreadsheet file such as an Excel file. Such a data file may be a data file of any format as long as data that can be used for program conversion is recorded.
Next, the second step S2 will be described with reference to Fig.
The Relational Data Base (RDB) may be a commercially available relational database such as Microsoft Access (MS Access), MS SQL (Structured Query Language), MY SQL, or Oracle.
The second step S2 includes step 2-B (S2-B) of analyzing meta information and data information of the data file to form a database of a predetermined format, A 2-D step (S2-D) of creating a data table using the data table, a 2-E step (S2-E) of storing the value recorded in the data file in the data table, And a 2-G step (S2-G) for creating a system table.
The second step S2 includes a 2-A step S2-A for checking and correcting an error of a data file, a database, an executable file, and a used character before the 2-B step S2- A) may be further included. First, the data file error audit is to check whether the data file selected by the user exists in the correct position. In addition, the database error check checks whether the name and folder of the database to be created are appropriate, and whether the same name to be output exists if overwritten, and checks whether there are special characters that can not be used for folder and file names. Executable error checking checks whether the name and folder of the executable file to be created are appropriate, and whether to overwrite the same name to be output, if any, and checks whether there are special characters that can not be used in the folder and file name. Also, the character error check checks whether the size of the character used in the data file is inputted according to the rule, and it should be between 1 and 255.
In step 2-B (S2-B), the meta information may include sheet information and item information, and the data information may be analyzed and managed.
In addition, it may further include a 2-C step (S2-C) for preventing the file from being opened when another user does not know the password by assigning a password to the database.
The 2-G step (S2-G) creates a table for utilization in future programs. A system table is a set of databases for managing data, not input and output data. It consists of menu information, information about the input original data file, search information for each data table, and a table that manages each data table and downloaded data file information.
The second step S2 further includes a 2-F step S2-F for storing a value not normally stored in the data table in a 2-E step S2-E in a separate spreadsheet file . That is, if a value is input in a form other than the defined form, it can not be converted and stored in a separate file (excel file, etc.) so that the user can check it.
Next, the third step S3 will be described with reference to Fig.
The programming language may be C # source code of a .NET frame.
The third step S3 includes a 3-C step S3-C of creating a program source file and a folder necessary for compiling, a step 3-C of creating a source file of the project file managing the code relation of the source file and the compilation environment, A step 3-E (S3-E) of generating source code for managing all the forms and generating a main menu form, a step S3-E for managing the database, screen output, error management, and data file input / output 3-F (S3-F) for creating a source code of a class file for collecting public functions of the data file and a 3-H step (S3-F) for creating a form for inputting, modifying, deleting, (S3-I) for editing the source program for managing the source codes generated in the 3-E step (S3-E) and the 3-F step (S3-F) do.
Here, the third step S3 includes a 3-A step (S3-A) for setting an output UX type before the 3-C step (S3-C) And may further comprise step S3-B. First, the 3-A step (S3-A) selects a type of screen design to be used in the created program. In step 3-B (S3-B), the user can easily use the size and position of the screen to be output according to the size and resolution of the monitor screen.
On the other hand, although it is not directly related to the input data file, it may further include a 3-G step (S3-G) for producing an additional program usefully used in the program. For example, there is a calendar-like bulletin board that allows you to share schedules among team members. A basic configuration of a program for creating a screen is constituted by a program representing a shape (design) of a screen, a process program representing a process for a plurality of actions such as a button click on the screen, a program representing a resource such as a used variable .
3, the 3-H step S3-H may be subdivided as shown in FIG. 3, and includes steps of creating a registration form, registering a registration form in a menu, creating a search form, . ≪ / RTI > Here, in order to create the registration form, the table information is first analyzed, and the related table is analyzed to create the optimum design file. After that, it creates a process file including save, modify, delete, key search and conversion, adds the created form file to the project, and finally initializes the table information. To create a search form, first analyze the table information and analyze the related table to create an optimal design file. After that, a process file including condition search, condition search condition management and selection, file conversion, conversion file management and selection is created, the created form file is added to the project, and finally the table information is initialized.
Next, the fourth step S4 will be described with reference to FIG.
The fourth step S4 includes a 4-A step (S4-A) of compiling source code written in the programming language into an executable file (for example, an extension exe file) so that the user can use the source code, (S4-B) for copying the execution file to the folder and name designated by the user, and 4-C step S4-C for confirming whether the execution file is executed correctly.
Next, the fifth step S5 will be described with reference to FIG.
The fifth step (S5) includes a 5-A step (S5-A) of distributing an executable file created through the first step (S1) to the fourth step (S4) to a user on the network to which the database is connected, 5-B step S5-B for setting the position of the executable file and the 5-C step S5-C using the distributed executable file.
In the 5-A step (S5-A), the executable file is distributed to a computer on the network sharing data files selected in the first step (S1). When multiple computers are used in the same organization, usually each computer is connected to the network, and the executable file must exist on the same network in order for multiple users to use the same file. In step 5-B (S5-B), the execution file containing the information is adapted to select the location of the database. The database used in the created program is searched and set, and the path used by the computer having the shared database is different from the path used by the computer having the shared database.
According to the embodiment of the present invention described so far, there is an effect of improving the program production productivity as follows.
First, the user interface can be changed by a simple operation, which can be useful for identification and testing of the visible form of the project, and specific data for consultation.
Second, small projects can be used without modification of the source code, and you do not have to change the development method you are using at all.
Third, you can design your database with the methods and tools you are using.
Fourth, you can create a program that is applicable to your business with just a few clicks.
Fifth, in a complex business, developers can flexibly adapt their work by directly modifying and extending standardized source code.
The foregoing has outlined rather broadly the features and technical advantages of the present invention in order that the claims of the invention to be described below may be better understood. The embodiments described above are susceptible to various modifications and changes within the technical scope of the present invention by those skilled in the art. These various modifications and changes are also within the scope of the technical idea of the present invention and will be included in the claims of the present invention described below.
Claims (7)
A first step of selecting a data file;
A second step of analyzing the data file and converting the data file into a relational database in a predetermined format;
A third step of converting the relational database into a predetermined programming language; And
A fourth step of converting the programming language into an executable file to be executed as an ERP program on a computer platform;
And automatically transforming the ERP program using the relational database.
The second step comprises:
A 2-B step of analyzing the META information and the data information of the data file and converting the META information and the data information into a database of a predetermined format,
A 2-D step of creating a data table using sheet information and item information of the data file;
A 2-E step of storing the value recorded in the data file in the data table, and
And a 2-G step of creating a system table for managing values stored in the data table.
In the second step,
Further comprising a 2-F step of storing a value not normally stored in the data table in a separate spreadsheet file in step 2-E.
In the third step,
Step 3-C for creating a program source file and a folder necessary for compiling,
A 3-D step of creating source code of a project file managing a code relation of the source file and a compilation environment,
Step 3-E creates the source code for managing all the forms and creating the main menu form,
A 3-F step of creating the source code of the class file which collects the common functions for the database, the screen output, the error management, and the data file I /
A 3-H step of creating a form for inputting, modifying, deleting and searching designated items and values in the data file and
And a 3-I step of editing a source program which manages the source codes generated in the 3-E step and the 3-F step by menu.
In the fourth step,
A 4-A step of compiling source code written in the programming language into an executable file for use by a user;
A 4-B step of copying the executable file to a folder and a name designated by the user, and
And a 4-C step of confirming whether the execution file is executed correctly.
A fifth step of distributing the executable file to a specific computer in a network environment;
And automatically converting the ERP program using the relational database.
Wherein the executable file is distributed to a computer on a network that shares the data files with each other.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| KR1020130150434A KR20150065292A (en) | 2013-12-05 | 2013-12-05 | Erp program conversion method using relation data base |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| KR1020130150434A KR20150065292A (en) | 2013-12-05 | 2013-12-05 | Erp program conversion method using relation data base |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| KR20150065292A true KR20150065292A (en) | 2015-06-15 |
Family
ID=53504237
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| KR1020130150434A KR20150065292A (en) | 2013-12-05 | 2013-12-05 | Erp program conversion method using relation data base |
Country Status (1)
| Country | Link |
|---|---|
| KR (1) | KR20150065292A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2018097407A1 (en) * | 2016-11-25 | 2018-05-31 | (주) 더존비즈온 | Method and system for sharing user-defined erp functions |
| WO2021066231A1 (en) * | 2019-10-01 | 2021-04-08 | (주) 더존비즈온 | Sql query recommendation method and system |
-
2013
- 2013-12-05 KR KR1020130150434A patent/KR20150065292A/en not_active Application Discontinuation
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2018097407A1 (en) * | 2016-11-25 | 2018-05-31 | (주) 더존비즈온 | Method and system for sharing user-defined erp functions |
| WO2021066231A1 (en) * | 2019-10-01 | 2021-04-08 | (주) 더존비즈온 | Sql query recommendation method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10853387B2 (en) | Data retrieval apparatus, program and recording medium | |
| US9535965B2 (en) | System and method for specifying metadata extension input for extending data warehouse | |
| CN101308490B (en) | Dynamic report generation method and platform | |
| US8340995B2 (en) | Method and system of using artifacts to identify elements of a component business model | |
| CA2795628C (en) | Method and system for providing business intelligence data | |
| US20090319544A1 (en) | Facilitating integration of different computer data systems | |
| CN106445536B (en) | Automatic business design management system | |
| KR20150065292A (en) | Erp program conversion method using relation data base | |
| US11657218B2 (en) | Custom template generation using universal code | |
| KR101815561B1 (en) | Client program of erp system | |
| Dumitriu | Modelling and simulation software solutions as a premise for enhancing processes’ quality and business overall value | |
| US20140149186A1 (en) | Method and system of using artifacts to identify elements of a component business model | |
| KR101855251B1 (en) | Client program of erp system | |
| Yu | Getting started with Salesforce Einstein analytics: A Beginner’s guide to building interactive dashboards | |
| Vasilevich et al. | Development of a system for assessing the functionality based on KPI analysis | |
| US11216486B2 (en) | Data retrieval apparatus, program and recording medium | |
| Gadde | Optimization of Asset Allocation | |
| DE SILVA | Sales and inventory management system for imperial auto care | |
| Balakrishnan | Business Intelligence Solution | |
| Xhelo | In-Company internship at Belsimpel | |
| Chandrasekaran et al. | High Performance Business Intelligence Dashboard | |
| Tripathi | Learn Business Analytics in Six Steps Using SAS and R: A Practical, Step-by-Step Guide to Learning Business Analytics | |
| Patel et al. | A practical guide to SAP netweaver business warehouse (BW) 7.0 | |
| Kumar et al. | An Efficient Database System for Large Scale Socioeconomic Data Management. | |
| Rotter | Designing and Implementing a Modeling and Verification Tool for Object-aware Processes |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| A201 | Request for examination | ||
| E902 | Notification of reason for refusal | ||
| E902 | Notification of reason for refusal | ||
| E601 | Decision to refuse application |