KR20210014854A - System and method of generating backend and administrator web page for information management - Google Patents

Abstract

According to the present invention, a system for creating a back-end and administrator web page for information management comprises: an information management system characteristic input unit for receiving an input of characteristics of an information management system and storing the input as text; a meta information extraction unit for extracting meta information from the stored text through natural language processing; a meta information correction unit for generating corrected meta information by comparing and analyzing the extracted meta information through deep learning based on an information management system template; an object-relational mapping (ORM) code generation unit for generating ORM code by using the corrected meta information; a database table and column generation unit for generating a database table and a column by executing the object-relational mapping code; an API generation unit for generating an API by using the database table and column information; and a UI generation unit for generating a UI by using the database table and column information, wherein the information management system characteristic input unit comprises a data collection unit and a text conversion unit. According to the present invention, an efficient information management system can be quickly implemented on a web.

Description

A system and method for creating backend and administrator web pages for information management {SYSTEM AND METHOD OF GENERATING BACKEND AND ADMINISTRATOR WEB PAGE FOR INFORMATION MANAGEMENT}

The present invention relates to a system and method for generating a backend for information management and a manager web page, and more particularly, to input the nature and use of the information management system to be developed in natural language and correct it with a deep learning process. This is a system and method for automatically creating information items necessary for an information management system to be developed in a database using meta-information and creating a backend and administrator webpage based on this.

With the explosive development of IT technology in both software and hardware aspects, the amount of information generated in homes, schools, public institutions, and businesses has increased rapidly, and how efficiently and systematically and conveniently managing such information is very important. It emerged as an important factor.

The information management system using the web not only can systematically handle such information, but also has a number of advantages, such as enabling multiple information related parties to access the information at the same time regardless of time and place if network is available. In recent years, the majority of information management systems in society have been formed, and accordingly, there is a demand for development of information management systems using the web in various areas.

On the other hand, as in Patent Document 1, a method of customizing web pages using an open source content management system called WordPress has been proposed. In addition, as in Patent Document 2, a method has been proposed that provides components, which are general elements constituting a web page, in the form of predefined cards so that users can easily produce a web page by selecting and combining such cards. In addition, as in Patent Document 3, a system has been proposed that creates and edits a plurality of components through a web site editing and management server, and then reflects the components on a web page.

Patent Application Publication No. 10-2018-0097029 Patent Application Publication No. 10-2015-0095162 Patent Application Publication No. 10-2016-0075879

However, all of the above patent documents do not consider the backend including the database of the information management system. The method of Patent Document 1 has a limitation in that it uses a specific content management system called WordPress, and also has a disadvantage in that the contents of a database must be separately designed to be used as an information management system. As in Patent Document 2, the method of selecting and combining cards, which is a set of web page components, can easily create a simple web page, but it is difficult to create a web page as a system for managing information. In addition, the method of Patent Document 3, which provides a method of creating and managing web pages through a web site editing and management server, also solves the problem of not taking into account aspects such as design, creation, and modification of information that the information management system must have, such as change and deletion Have.

The present invention is to solve the above-described problems, and the characteristics and uses of the information management system to be developed are input by a user in natural language, and the information management system to be developed using meta information obtained by processing it with an artificial intelligence model. It is an object of the present invention to provide a system and method for automatically creating necessary information items in a database and generating backend and administrator web pages based on this.

The system for generating a backend and a manager web page for information management of the present invention includes an information management system characteristic input unit that receives the characteristics of the information management system and stores it as text, and a meta that extracts meta information from the stored text through natural language processing. An information extraction unit, a meta information correction unit that generates corrected meta information by comparing and analyzing the extracted meta information through deep learning based on an information management system template, and object relationship mapping using the corrected meta information (Object -Relational Mapping) ORM code generation unit that generates code, database table and column generation unit that creates database table and column by executing the object relationship mapping code, API using the generated database table and column information And a UI generator that generates a UI using the generated database table and column information, and the characteristic of the information management system includes the purpose, purpose, or range of use of the information management system, The information management system template is characterized in that it includes a set of databases of the information management system previously generated according to the characteristics of the information management system. In one embodiment, the API connects the database table and column information with the backend and administrator web pages.

In one embodiment, the information management system characteristic input unit includes a data collection unit that collects characteristics of the information management system and a text conversion unit that converts the collected data into text.

In one embodiment, the meta-information correction unit compares and analyzes the extracted meta-information through deep learning based on the information management system template generated in advance according to the characteristics of the information management system, It is characterized in that the extracted meta information is corrected to be used in a mapping code.

In one embodiment, the UI generator generates a UI corresponding to the database table and column information on the backend and administrator web pages.

The method of generating a backend and a manager webpage for information management of the present invention includes the steps of receiving a characteristic of an information management system and storing it as text, extracting meta information from the stored text through natural language processing, and the extracted Generating corrected meta information by comparing and analyzing meta information through deep learning based on an information management system template, generating an object-relational mapping code using the corrected meta information, Creating a database table and column by executing the object relational mapping code, creating an API connecting the database table and column information with the backend and administrator web pages, and corresponding to the database table and column information It characterized in that it comprises the step of generating the UI, the backend and the administrator web page.

A program stored in a computer-readable storage medium that generates a backend for information management and an administrator web page of the present invention receives the characteristics of an information management system and stores it as text, and meta-information through natural language processing from the stored text. Extracted and compared and analyzed the extracted meta-information through deep learning based on an information management system template to generate corrected meta-information, and object-relational mapping code using the corrected meta-information And, by executing the object relationship mapping code, to create a database table and column, create an API that connects the database table and column information with the backend and the administrator web page, and the database table and column information It characterized in that it comprises a code for executing a command that generates a UI corresponding to the backend and the administrator web page.

According to the present invention, information for managing various information items for various purposes by reducing a process such as a requirement for information system development between a client and a developer for information system development, and a process such as feedback for the information system development, and a process such as incorrect communication resulting therefrom. Information items that can significantly reduce the time to develop and build the management system backend and administrator web pages, and are more precise than those of the information management system that the development client initially intended, and are more efficient in achieving the purpose of information management. You can create an information management system that includes them.

Accordingly, a more efficient information management system can be quickly implemented on the web through the system and method for automatically generating the backend and administrator web pages for information management of the present invention.

1 is a block diagram of a system for automatically generating a backend and a manager webpage for information management proposed in the present invention.
2 is a block diagram illustrating an internal configuration of an information management system characteristic input unit according to an embodiment of the present invention.
3 is a flowchart of a method of automatically generating a backend and a manager webpage for information management according to an embodiment of the present invention.
FIG. 4 is an exemplary diagram in which input and output examples are added to FIG. 1 to describe a backend and manager webpage system for information management according to an embodiment of the present invention.

For the embodiments of the present invention disclosed in the text, specific structural or functional descriptions have been exemplified for the purpose of describing the embodiments of the present invention only, and the embodiments of the present invention may be implemented in various forms. It should not be construed as being limited to the described embodiments.

Since the present invention can apply various changes and have various forms, specific embodiments will be illustrated in the drawings and described in detail in the text. However, this is not intended to limit the present invention to a specific form of disclosure, it is to be understood as including all changes, equivalents, or substitutes included in the spirit and scope of the present invention.

Terms such as first and second may be used to describe various elements, but the elements should not be limited by the terms. The terms may be used for the purpose of distinguishing one component from another component. For example, without departing from the scope of the present invention, a first component may be referred to as a second component, and similarly, a second component may be referred to as a first component.

When a component is referred to as being "connected" or "connected" to another component, it is understood that it may be directly connected or connected to the other component, but other components may exist in the middle. Should be. On the other hand, when a component is referred to as being "directly connected" or "directly connected" to another component, it should be understood that there is no other component in the middle. Other expressions describing the relationship between components, such as "between" and "directly between" or "adjacent to" and "directly adjacent to" should be interpreted as well.

The terms used in the present application are used only to describe specific embodiments, and are not intended to limit the present invention. Singular expressions include plural expressions unless the context clearly indicates otherwise. In the present application, terms such as "comprise" or "have" are intended to designate the presence of a set feature, number, step, action, component, part, or combination thereof, and one or more other features or numbers It is to be understood that the possibility of addition or presence of, steps, actions, components, parts, or combinations thereof is not preliminarily excluded.

Unless otherwise defined, all terms used herein, including technical or scientific terms, have the same meaning as commonly understood by one of ordinary skill in the art to which the present invention belongs. Terms as defined in a commonly used dictionary should be interpreted as having a meaning consistent with the meaning of the context of the related technology, and should not be interpreted as an ideal or excessively formal meaning unless explicitly defined in this application. .

Hereinafter, preferred embodiments of the present invention will be described in more detail with reference to the accompanying drawings. The same reference numerals are used for the same elements in the drawings, and duplicate descriptions for the same elements are omitted.

1 shows a configuration diagram of a system 100 for generating a backend and a manager web page for information management proposed in the present invention. The system 100 for generating a backend and manager web page for information management of the present invention includes an information management system characteristic input unit 110, a meta information extraction unit 120, a meta information correction unit 130, an ORM code generation unit ( 140), a DB table and column generation unit 150, an API generation unit 160, and a UI generation unit 170.

The information management system characteristic input unit 110 according to an embodiment of the present invention receives the characteristics of the information management system that the customer wants to develop for a specific purpose or use in various ways, such as voice or paper documents, and receives text that can be processed by a computer. Convert to The conversion of such various types of input into text can be referred to as a pre-work for extracting meta information for designing a database of an information management system using a computer.

The meta-information extracting unit 120 extracts meta-information by using text described in natural language. Natural language processing algorithms can be applied to extract meta information.

Since it may be insufficient to compose information items of the information management system with only the extracted meta-information due to the incompleteness of the information management system's characteristics entered in natural language, it is necessary to correct the extracted meta-information. The meta information correction unit 130 performs the task. This correction is made through a deep learning process. In this deep learning, information management system templates created in advance for each type are used as a kind of reference. The information management system template created in advance for each type refers to an information management system created in advance to represent the classification after classifying widely used information management systems according to their purpose and purpose. Examples of information management systems classified based on purpose and use include logistics data systems, research management systems, factory automation systems, and medical record systems. Such information management systems are generally composed of unique information items suitable for their purpose.

The ORM code generation unit 140 creates an object-relational mapping code that enables the database table and column to be composed of information items of the information management system to be developed using the corrected meta information. Object relationship mapping code is a code that implements the object of a program, which can be a unit of information, as a table or a data unit to be classified, and forms a relationship between the data. It is intuitive and easy to reuse and maintain, so business logic It has the advantage of allowing you to be more loyal to you.

The DB table and column generation unit 150 generates a database table and column by executing an object relationship mapping code. Designing the tables and columns of the database of the information management system takes considerable time and effort, but the DB table and column generation unit 150 of the present invention automatically uses the object relationship mapping code created from meta information. It allows you to shorten the time to create tables and columns.

The API generation unit 160 creates an API that allows the information items in the generated database table and column to be accessed from the administrator web page. These APIs may include functions such as get and set. In general, get is a function to read and retrieve information in the database, and set is a function to set the information in the database to a desired value.

The UI generator 170 performs a function of generating a UI that enables a user of the administrator web page, that is, the administrator to use information in the database.

The API generation unit 160 and the UI generation unit 170 connect the database and the manager web page to allow the user of the manager web page, that is, the manager to access the database through the web, thereby providing a backend and manager web page for information management. Is finally completed.

2 is a configuration diagram illustrating an internal configuration of an information management system characteristic input unit 110 according to an embodiment of the present invention. The information management system characteristic input unit 110 includes a data collection unit 210 and a text conversion unit 220 as shown in FIG. 2.

The data collection unit 210 collects characteristic data of an information management system that a customer wants to develop, including various forms such as voice, paper documents, and text files of the customer.

The text conversion unit 220 performs an operation of converting the data into text that can be processed by a computer in consideration of the type of data collected by the data collection unit 210. For example, in the case of speech data, speech recognition may be performed, and in the case of paper documents, an automatic optical character recognition (OCR) operation may be performed.

3 is a flowchart of a method of automatically generating a backend and a manager webpage for information management according to an embodiment of the present invention.

The information management system characteristic input unit 110 according to an embodiment of the present invention receives the purpose and purpose of the information management system to be developed that the customer wants and stores it as text (S310), and the meta information extraction unit 120 Meta-information is extracted by processing the text in natural language (S320), and in order to improve the extracted meta-information, the meta-information correction unit 130 performs deep learning comparison analysis based on the information management system template previously created for each type. The meta information is corrected (S330).

The meta information correction unit 130 corrects or corrects errors existing in the extracted meta information from the meta information extraction unit 120 through a deep learning comparison analysis process based on the information management system template as described above. .

The ORM code generation unit 140 generates an object relationship mapping code capable of generating a database table and a column by using the meta information corrected by the meta information correction unit 130 (S340).

The object relationship mapping code generated by the ORM code generation unit 140 is used by the DB table and column generation unit 150 to generate a database table and column (S350). The database tables and columns created in this way are composed of information items, including attributes, which are managed by the information management system.

When the database table and column are determined as above, the API generation unit 160 creates an API (Application Programming Interface) that connects the information in the determined database table and column so that the administrator web page can access it (S360), and creates a UI. The unit 170 creates a user interface (UI) corresponding to the above information on the manager web page (S370) to complete the manager web page. The API and UI generation method may include a method performed through a click without coding.

FIG. 4 is an exemplary diagram in which input and output examples are added to FIG. 1 in order to describe a backend and manager webpage system for information management according to an embodiment of the present invention.

When the information management system characteristic example 410 described in natural language that the customer wants to develop is input to the information management system characteristic input unit 110 in the system 100 for generating a backend and manager web page for information management, the extracted Meta information for designing or configuring a database of an information management system, such as the meta information example 420 may be output. The example of meta-information 420 extracted in this way is that the information management system characteristic example 410 that the customer wants to develop may be incomplete or insufficient in defining the target information of the information management system to be actually developed. There is also the possibility of being incomplete or insufficient. Accordingly, the meta information correction unit 130 outputs an example 430 of the corrected meta information in consideration of such a point, and the ORM code generation unit 140 uses the corrected meta information to provide a DB table and column example 440. Create an ORM code that can generate ). In addition, the ORM code created in this way creates a DB table and column example 440 by the DB table and column generation unit 150, which becomes a base material for creating an API and UI for connection with the administrator web page. Finally, each API and UI generated by the API generation unit 160 and the UI generation unit 170 constitute the content and formal elements of the example administrator web page 450, and the information existing in the database table and column is It plays the role of making it accessible through.

An embodiment of the present invention may also be implemented in the form of a recording medium including instructions executable by a computer, such as a program module executed by a computer. Computer-readable media may be any available media that can be accessed by a computer, and includes both volatile and nonvolatile media, removable and non-removable media. Further, the computer-readable medium may include both computer storage media and communication media. Computer storage media includes both volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data. Communication media typically includes computer readable instructions, data structures, program modules, or other data in a modulated data signal such as a carrier wave, or other transmission mechanism, and includes any information delivery medium.

100: System for creating backend and administrator web pages for information management
110: information management system characteristic input unit
120: meta information extraction unit
130: meta information correction unit
140: ORM code generation unit
150: DB table and column generator
160: API generation unit
170: UI generator
210: data collection unit
220: text conversion unit
410: An example of the characteristics of the information management system that the customer wants to develop, described in natural language
420: Example of extracted meta information
430: Example of corrected meta information
440: Example of DB table and column
450: Example of administrator web page

Claims (9)

As a system that creates backend and administrator web pages for information management,
An information management system characteristic input unit for receiving the characteristics of the information management system and storing them as text;
A meta information extraction unit that extracts meta information from the stored text through natural language processing;
A meta information correction unit for generating corrected meta information by comparing and analyzing the extracted meta information through deep learning based on an information management system template;
An ORM code generation unit that generates an object-relational mapping code using the corrected meta information;
A database table and column generator for generating a database table and column by executing the object relationship mapping code;
An API generator that generates an API using the generated database table and column information; And
Including a UI generator for generating a UI using the generated database table and column information,
The characteristics of the information management system include the purpose, purpose or range of use of the information management system,
The information management system template includes a set of databases of the information management system previously generated according to the characteristics of the information management system. The method of claim 1,
The information management system characteristic input unit,
A data collection unit collecting characteristics of the information management system; And
A system for generating a backend and an administrator web page for information management, including a text conversion unit for converting the collected data into text. The method of claim 1,
The meta information correction unit,
Through deep learning based on the information management system template generated in advance according to the characteristics of the information management system, the extracted meta-information is used to the object relationship mapping code by comparing and analyzing the extracted meta-information. A system that creates backend and admin webpages for information management, calibrating. The method of claim 1,
The API connects the database table and column information with the backend and the manager webpage, and creates a backend and manager webpage for information management. The method of claim 1,
The UI generator,
A system that generates a UI corresponding to the database table and column information on the backend and the manager webpage, and generates a backend and manager webpage for information management. In the method of creating a backend and administrator web page for information management,
Receiving the characteristics of the information management system and storing them as text;
Extracting meta information from the stored text through natural language processing;
Generating corrected meta information by comparing and analyzing the extracted meta information through deep learning based on an information management system template;
Generating an object-relational mapping code using the corrected meta-information;
Generating a database table and column by executing the object relationship mapping code;
Creating an API for connecting the database table and column information with the backend and the administrator web page; And
Generating a UI corresponding to the database table and column information in the backend and the manager webpage. A method of generating a backend and manager webpage for information management. The method of claim 6,
Generating the corrected meta information,
Through deep learning based on the information management system template generated in advance according to the characteristics of the information management system, the extracted meta-information is used to the object relationship mapping code by comparing and analyzing the extracted meta-information. A method of creating a backend and admin webpage for information management comprising the step of calibrating. The method of claim 6,
The API connects the database table and column information with the backend and the administrator webpage. A method of creating a backend and administrator webpage for information management. In a program stored in a computer-readable storage medium for generating a backend and an administrator web page for information management,
The above program,
The characteristics of the information management system are input and stored as text;
Extracting meta information from the stored text through natural language processing;
Generating corrected meta information by comparing and analyzing the extracted meta information through deep learning based on an information management system template;
Generating an Object-Relational Mapping code using the corrected meta information;
Executing the object relationship mapping code to create a database table and column;
Creating an API for connecting the database table and column information with the backend and the administrator web page; And
A program stored in a computer-readable storage medium, comprising a code for executing a command to generate a UI corresponding to the database table and column information in the backend and the administrator web page.

Images