KR102421397B1 - Method of building backend with automatic programming code generation - Google Patents

Abstract

A method of constructing a backend through automatic generation of programming code according to an embodiment of the present invention includes receiving a data editing request signal from a user terminal, generating a data editing code based on the data editing request signal, and using the generated data editing code. Through the step in which the database is edited in the DB server and the API generation code generated according to the edited database is generated, an application programming interface (API) that can be connected to the application related to database editing is generated based on the API generation code in the API server. steps may be included.

Description

How to build a backend through automatic generation of programming code {METHOD OF BUILDING BACKEND WITH AUTOMATIC PROGRAMMING CODE GENERATION}

The present invention relates to a method of constructing a backend through automatic generation of programming codes performed by a management server interoperable with a DB server and an API server, and more particularly, according to a data editing code generated based on a signal received from a user terminal. It relates to a method of constructing a backend in which a database is edited in a DB server, and an API connectable with an application related to database editing is generated based on the API generation code generated according to the edited database.

In general, front-end and back-end refer to the first and last stages of a process. will process That is, the front-end and the back-end can be used to represent a program interface and user-related characteristics of a service. More specifically, the front-end service corresponds to a service that directly interacts with a user (or user terminal). A back-end system is a system that indirectly supports a front-end service through a function that is usually close to the requested resources or can communicate with the requested resources.

However, there is a problem in that, in the construction of the backend related to the development of the database server and API server, it is necessary to update the database or create a related API in response to input from the user (eg, adding a table, modifying a column, etc.). That is, the development of a technology capable of automating backend development by automatically generating programming codes in the backend construction process has not yet been developed.

Republic of Korea Patent Publication No. 10-2004-0010677 (published on January 31, 2004)

In the present invention, as a countermeasure to the above-described problem, programming codes for editing a database and generating an API can be automatically generated based on a data editing request signal received from a front end.

Also, based on the generated API, an API calling code for allowing the API to be called in the front end may be automatically generated.

As an embodiment of the present invention, a method for constructing a backend through automatic generation of programming codes performed by a management server interoperable with a DB server and an API server may be provided.

According to an embodiment of the present invention, a method for constructing a backend through automatic generation of programming code includes receiving a data editing request signal from a front-end, generating a data editing code based on the data editing request signal, and generating An application programming interface (API) that can be connected to an application related to database editing based on the API creation code in the API server and the stage in which the database is edited in the DB server through the edited data editing code and the API generation code is generated according to the edited database. may include a step in which

In the method of constructing a backend through automatic generation of programming code according to an embodiment of the present invention, the step of generating an API call code for allowing the API to be called from the frontend may be further included after the step of generating the API.

In the method of constructing a backend through automatic generation of programming code according to an embodiment of the present invention, the data editing code is generated based on the data editing request signal, and the step of editing the database in the DB server through the generated data editing code includes: ORM request code for requesting an object-relational mapping (ORM) function for analyzing the data editing request signal, extracting metadata based on the analysis result, and editing the database based on the extracted metadata It may include a step of generating , a step of generating a data edit code corresponding to the object relation mapping function called according to the ORM request code, and a step of editing the database in the DB server by the data edit code.

In the method of constructing a backend through automatic generation of programming code according to an embodiment of the present invention, in the step of analyzing a data editing request signal and extracting metadata based on the analysis result, analysis learned in advance based on a deep learning algorithm The data edit request signal can be analyzed through the model.

In the method for constructing a backend through automatic generation of programming code according to an embodiment of the present invention, the data edit request signal is input through a graphical user interface (GUI) of the user terminal, and the data edit request signal includes a table creation signal and a table deletion signal. Any one of a signal, a column creation signal, a column deletion signal, and a column correction signal may be included.

According to an embodiment of the present invention, programming codes for editing a database and generating an API are automatically generated based on a data editing request signal received from the front-end, thereby automating the construction of the back-end.

1 is a flowchart illustrating a method of constructing a backend through automatic generation of programming code according to an embodiment of the present invention.
2 is a flowchart illustrating a process in which the step of generating an API call code is added in the method of constructing a backend through automatic generation of programming code according to an embodiment of the present invention.
3 is a flowchart illustrating a step in which a database is edited in a method of constructing a backend through automatic generation of programming code according to an embodiment of the present invention.
4 is an exemplary diagram illustrating that the management server is in a state capable of interworking with the backend and the frontend in the method for building a backend through automatic generation of programming code according to an embodiment of the present invention.

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings so that those skilled in the art can easily carry out the present invention. However, the present invention may be embodied in several different forms and is not limited to the embodiments described herein. And in order to clearly explain the present invention in the drawings, parts irrelevant to the description are omitted, and similar reference numerals are attached to similar parts throughout the specification.

Terms used in this specification will be briefly described, and the present invention will be described in detail.

The terms used in the present invention have been selected as currently widely used general terms as possible while considering the functions in the present invention, but these may vary depending on the intention or precedent of a person skilled in the art, the emergence of new technology, and the like. In addition, in a specific case, there is a term arbitrarily selected by the applicant, and in this case, the meaning will be described in detail in the description of the corresponding invention. Therefore, the term used in the present invention should be defined based on the meaning of the term and the overall content of the present invention, rather than the name of a simple term.

In the entire specification, when a part "includes" a certain component, it means that other components may be further included, rather than excluding other components, unless otherwise stated. In addition, terms such as "...unit" and "module" described in the specification mean a unit that processes at least one function or operation, which may be implemented as hardware or software, or a combination of hardware and software. . In addition, when a part is "connected" to another part throughout the specification, this includes not only a case in which it is "directly connected" but also a case in which it is connected "with another element in the middle".

Hereinafter, the present invention will be described in detail with reference to the accompanying drawings.

4 is an exemplary diagram illustrating that the management server 100 is in a state capable of interworking with the backend 200 and the frontend 300 in the method for constructing a backend through automatic generation of programming code according to an embodiment of the present invention.

Referring to FIG. 4 , as an embodiment of the present invention, a method of constructing a backend through automatic generation of programming codes performed by the management server 100 interoperable with the DB server 220 and the API server 210 may be provided. have. That is, the method of constructing the backend of the present invention may be performed by the management server 100 , and the management server 100 may be linked with the DB server 220 and the API server 210 .

The management server 100 may further include a code generation unit (not shown), a control unit (not shown), and a communication unit (not shown). In the code generator, as described later, data editing code for data editing in the database, API creation code for API creation, ORM request code for requesting an object relation mapping function, API call code, etc. can be automatically generated. have. The programming language generated by the code generator is not limited, and various programming languages may be used according to the purpose of constructing the backend 200 . The control unit may control the operation of the code generator as well as control for interworking with the backend 200 and the frontend 300 . That is, the control unit may control the overall operation for implementing the method of constructing a backend of the present invention. For example, an operation such as compiling a programming language generated by the code generator or executing a program generated based on the programming language may be performed. In the communication unit, communication with other devices or other systems such as the DB server 220 , the API server 210 , and the front end 300 as well as communication between the components in the management server 100 may be performed. As the communication method of the communication unit, various wired or wireless communication methods may be used, and the communication method is not limited to a specific communication method.

In this specification, the DB server 220 may be a server or DBMS provided with a database management system (DBMS) for accessing data in the database. However, the DB server 220 is not limited thereto, and may be a device (eg, a personal computer, a computer cluster, a tablet PC, a smart phone, etc.) provided with a database or a function module that can access the database. In addition, the API server 210 refers to a server for generating an application programming interface (API), and may be a server for generating an API for enabling access to a database through the DB server 220 . Also, the API server 210 may be a server that transmits or receives data related to an API call from the front end 300 .

Also, in the present specification, a back-end may refer to a back-end system as a system for processing user data input from the front-end. That is, in the present specification, the backend 200 may be a backend system that indirectly supports a frontend service through a function that is close to the requested resources or can communicate with the requested resources. The backend system may include an API server 210 and a DB server 220 as shown in FIG. 4 .

Also, the front end 300 may be a service or system that directly interacts with a user (or a user terminal). That is, the front-end 300 and the back-end 200 may be used to represent a program interface and user-related characteristics of a service. For example, the front-end 300 may transmit the requested content to the back-end system in order to obtain requested data or perform a requested service by interfacing with a user (or a program) or through a user terminal.

1 is a flowchart illustrating a method of constructing a backend through automatic generation of programming code according to an embodiment of the present invention.

Referring to FIG. 1 , the method for building a backend through automatic generation of programming code according to an embodiment of the present invention includes receiving a data edit request signal from a user terminal (S100), and a data edit code is generated based on the data edit request signal. A step (S200) of the database being edited in the DB server 220 through the generated and generated data editing code (S200) and the API generation code generated according to the edited database is generated, and based on the API generation code in the API server 210 Thus, a step (S300) of generating an application programming interface (API) connectable to an application related to database editing may be included.

Hereinafter, a process (S100-S300) of implementing the method of constructing a backend through automatic generation of programming code of the present invention will be described.

First, the management server 100 may receive a data editing request signal from the front end 300 (S100). In the method for constructing a backend through automatic generation of programming code according to an embodiment of the present invention, the data editing request signal may be input through a graphical user interface (GUI) of the user terminal. That is, the front end 300 may provide a GUI so as to be connected to the user terminal, and the user may transmit a data editing request signal to the management server 100 through the GUI. In this specification, a user may refer to an individual or a corporation for operating the DB server 220 and the API server 210 to perform a predetermined service. In addition, the data edit request signal may include any one of a table creation signal, a table deletion signal, a column creation signal, a column deletion signal, and a column correction signal. In addition, the data editing request signal includes a KEY setting signal for controlling the data processing speed related to a query, a default value setting signal, and “Not Null” and “auto increase” as a table setting value. Signals for setting may be further included. That is, the data editing request signal may collectively refer to signals related to data processing in the database. Alternatively, the data editing request signal may be inputted to data, a table, a column, a spreadsheet, or a database itself. That is, a database to be edited may be input as the data editing request signal.

Next, in the management server 100, a data edit code may be generated based on the data edit request signal, and the database may be edited (S200) in the DB server 220 through the generated data edit code. More specific details regarding the process S200 will be described with reference to FIG. 3 described below.

3 is a flowchart illustrating a step S200 in which a database is edited in a method of constructing a backend through automatic generation of programming code according to an embodiment of the present invention.

Referring to FIG. 3 , in the method of constructing a backend through automatic generation of programming code according to an embodiment of the present invention, a data edit code is generated based on a data edit request signal, and a DB server ( In the step (S200) in which the database is edited in 220), the data editing request signal is analyzed, the metadata is extracted based on the analysis result (S210), and object relation mapping for editing the database based on the extracted metadata (Object-relational mapping, ORM) A step of generating an ORM request code for requesting a function (S220), a step of generating a data editing code corresponding to the object-relational mapping function called according to the ORM request code (S230), and data editing A step (S240) of editing the database in the DB server 220 by the code may be included.

The metadata is data on a subject of an editing request, and the metadata may include a name, format, size, etc. of data, as well as contents requested to edit data (eg, creation, modification, deletion, etc.) in the metadata. up to may be included. Also, the metadata may be extracted as a JSON type, but the extracted type/format is not limited thereto.

In S200, there is no limitation on how the data editing request signal is analyzed in the step S210 of analyzing the data editing request signal and extracting metadata based on the analysis result. That is, in the backend construction method of the present invention, any analysis method may be used in step S210 to extract metadata.

Specifically, in the method of constructing a backend through automatic generation of programming code according to an embodiment of the present invention, in the step of analyzing the data editing request signal and extracting the metadata based on the analysis result, based on the deep learning algorithm in advance The data editing request signal can be analyzed through the learned analysis model.

For example, the data editing request signal may be input as a sound type voice signal. That is, the analysis model for analyzing the input voice signal may be generated by being trained in advance based on a deep learning algorithm. In addition, the data editing request signal may be input as text, and an analysis model for recognizing the input text may be learned and generated based on the deep learning algorithm described above. The deep learning algorithms include Artificial Neural Network (ANN), Support Vector Machine, Multi-Layer Perceptron (MLP), Recurrent Neural Network (RNN), Deep Neural Network (DNN), and Long Any one of Short Term Memory (LSTM) may be included. However, this is only an example, and various machine learning algorithms or deep learning algorithms other than the above algorithm may be used. In addition, it may be a newly formed analysis model by combining or connecting the machine learning or deep learning algorithms to each other.

In S200, the data editing code generated in the step S230 of generating the data editing code corresponding to the object relation mapping function called according to the ORM request code may be a code or a syntax generated in the SQL language. However, the present invention is not limited thereto, and if it is a programming language for database management, various languages other than the SQL language may be used to generate the data editing code.

Next, in the management server 100, an API generation code generated according to the edited database is generated, and in the API server 210, an application programming interface (API) that can be connected to an application related to database editing based on the API generation code is provided. may be generated (S300).

Any one of a REST method and a GraphQL method may be used as a method for implementing the endpoint structure of the API in the process of generating the API in the API server 210 . The REST method and the GraphQL method are beyond the scope of the present invention, and a description thereof will be omitted.

The endpoint may refer to a communication channel or contact point provided by the API server 210 .

The process S200-S300 relates to the construction of the backend 200 , and based on the data editing request signal, the database may be edited in the DB server 220 , and the API may be generated in the API server 210 . However, the method of constructing a backend through automatic generation of programming code of the present invention may also include a process in which the frontend 300 is edited as the API is called from the frontend 300 as will be described later.

2 is a flowchart illustrating a process in which the step (S400) of generating an API call code is added in the method of constructing a backend through automatic generation of programming code according to an embodiment of the present invention.

Referring to FIG. 2 , in the method of constructing a backend through automatic generation of programming code according to an embodiment of the present invention, after the step of generating the API, the management server 100 calls the API from the front-end An API call code for making it possible may be generated (S400). That is, the API call code generated by the management server 100 is transmitted to the front end 300 , so that the API can be called based on the API call code in the front end 300 .

As an embodiment of the present invention, a computer-readable recording medium in which a program for implementing the above-described method is recorded may be provided.

Meanwhile, the above-described method can be written as a program that can be executed on a computer, and can be implemented in a general-purpose digital computer that operates the program using a computer-readable medium. In addition, the structure of the data used in the above method may be recorded in a computer-readable medium through various means. A recording medium for recording an executable computer program or code for performing various methods of the present invention should not be construed as including temporary objects such as carrier waves or signals. The computer-readable medium may include a storage medium such as a magnetic storage medium (eg, a ROM, a floppy disk, a hard disk, etc.) and an optically readable medium (eg, a CD-ROM, a DVD, etc.).

The foregoing description of the present invention is for illustration, and those of ordinary skill in the art to which the present invention pertains can understand that it can be easily modified into other specific forms without changing the technical spirit or essential features of the present invention. will be. Therefore, it should be understood that the embodiments described above are illustrative in all respects and not restrictive. For example, each component described as a single type may be implemented in a distributed manner, and likewise components described as distributed may also be implemented in a combined form.

The scope of the present invention is indicated by the following claims rather than the above detailed description, and all changes or modifications derived from the meaning and scope of the claims and their equivalent concepts should be interpreted as being included in the scope of the present invention. do.

100: management server
200: backend
210: API server
220: DB server
300: frontend

Claims (5)

In the method of constructing a backend through automatic generation of programming code performed by a management server that is interoperable with a DB server and an API server,
A data editing request inputted from a front-end through a graphical user interface (GUI) of the user terminal and including any one of a table creation signal, a table deletion signal, a column creation signal, a column deletion signal, and a column correction signal receiving a signal;
generating a data edit code based on the data edit request signal, and editing a database in the DB server through the generated data edit code; and
generating an API generation code according to the edited database, and generating an application programming interface (API) connectable with an application related to database editing based on the API generation code in the API server; and
and generating an API call code for calling the API in the front end after the step of generating the API,
The step of editing the database in the DB server,
analyzing the data editing request signal through an analysis model learned in advance based on a deep learning algorithm, and extracting metadata based on the analysis result;
generating an ORM request code for requesting an object-relational mapping (ORM) function for editing a database based on the extracted metadata;
generating a data editing code corresponding to the object relation mapping function called according to the ORM request code; and
Backend construction method through automatic programming code generation further comprising the step of editing the database in the DB server by the data editing code. delete delete delete delete

Images