KR101572509B1 - the operating method of user interface framework for web-based application construction - Google Patents

Abstract

The present invention relates to a method for operating a user interface framework for establishing a web-based application. The method includes the following steps: performing a web platform setting including one or more information among a service location information, a data security setting information, a database connection information, and a session setting information; executing an application template manager providing a graphic user interface (GUI) function; organizing content per screen in accordance with a work model that a user wants; and providing a common data service to perform data access, process, and management.

Description

TECHNICAL FIELD [0001] The present invention relates to a method of operating a user interface framework for constructing a web-based application,

The present invention relates to a method of operating a user interface framework for building a web-based application. More specifically, the present invention relates to a method of operating a user interface framework for constructing a web based application, The present invention relates to a method of operating a user interface framework for building a web-based application capable of connecting to a service and displaying a page on a screen in connection with a stored procedure of a database.

In recent years, the cost of computer hardware has been low, and the number of computerized systems has increased due to the increase in the number of computer users who have been explosively increased since the advent of the Internet. Also, in order to develop enterprise computer system, system development projects involving hundreds of programmers, usually dozens of programmers in general, have also increased in size.

In the case of enterprise computing systems developed in a relatively short time by the participation of tens or hundreds of people, high productivity is required despite the complexity of business. As a result, a new methodology has emerged from the viewpoint of software engineering in the times, and there is also an attempt to visualize and standardize design documents at various stages with the emergence of the standard design language UML.

This is because the problem of how to create and express business logic is simple, and the more clearly the method of expressing and expressing the business logic is, the higher the development productivity and the less maintenance cost is generated.

 The database application creator must perform the coding using the procedural language in the case of implementing the business logic and the data access logic of the database application and the coding must be performed using the declarative language for the operation in the database. You should be familiar with all of the declarative languages.

Therefore, it takes a lot of time to develop a database application.

Generally, a database application production process performs a basic design of a database application according to a business model desired by a user, and then creates a source code of an actual database application based on a basic design, and tests the created source code.

During the process of creating a database application, the developer and the user are subjected to a process of confirming whether the user's desired requirements are accurately reflected in the database application through a plurality of meetings.

Meanwhile, various methods have been developed to increase the productivity of programming a database application. However, in order to visually create a form of a database application, to bind a database table to a GUI (Graphic User Interface) control (Binding).

As a prior art document, Korean Patent Laid-Open No. 10-2010-0122151 discloses a method for generating a database application based on an automatically generated form and a description of a computer-readable recording medium on which a program for realizing the method is generated.

Conventionally, a method for generating an automatically generated form-based database application comprises: using a data model including one or more database tables and a relationship definition of one or more database tables, and a business logic method written in executable code form for the data model, Updating the data model and the business logic method using one or more base forms, updating one or more base forms using the updated data model and the updated business logic methods, And converting the one or more base forms into a user mode form.

Such an automatic generation form-based database application generation method can support smooth communication between a customer and a developer by implementing a data model in a form form and presenting it to a customer in a form executable by coding a business logic in conjunction with a form form And it is possible to minimize workload and development cost when developing a database application.

However, the conventional automatic creation form-based database application creation method has a problem that since there is no framework that can be used for constructing a web-based application according to various business models and can perform a visualization procedure with an improved reusability, There is a problem in that it is not possible to smoothly and dynamically perform the dynamic editing process of the task execution procedure because the means for graphically designing the task execution procedure and associating the business logic with a programming language such as Java is insufficient.

In addition, although various types of user interface authoring tools are provided in the conventional technology for building database-related applications, since business logic and a user interface are mixed in the presentation layer of the web environment, There is a difficulty in maintenance and expansion of function due to the connection of development source and logic due to connection, difficulties in reuse of user interface part and logic, and difficulty in maintaining consistency of development components.

Korean Patent Laid-Open No. 10-2010-0122151 "A method of generating a database application based on an automatically generated form and a computer readable recording medium recording a program for realizing the method

In the present invention, an application template manager configures a frame according to a desired business model, and then adds, sets, and creates a page by a basic template or a user definition, connects to a service, connects to a stored procedure of a database, Since the screen can be displayed independently of the business logic because the page can be displayed, the GUI operation can be minimized. In addition, the dynamic layout by the screen-specific configuration file can improve the reusability of the previously constructed page It provides a method of operating a user interface framework for building a web-based application in which a developer who is unfamiliar with web development can build a web application easily, thereby increasing a developer's productivity.

Among the embodiments, a method for operating a user interface framework for building a web-based application includes: building a web-based application for operating a web application framework according to a business model using a platform system that provides a web- Wherein the platform system authenticates the user authority according to a request of the user terminal, and then transmits the at least one of service location information, data security setting information, database connection information, and session setting information for the user terminal Performing a web platform setup including one or more information; When the user terminal is connected to a web application framework running on the platform system, the web application framework includes an application template manager for dynamically managing the screen configuration with a screen-specific configuration file and providing a graphical user interface (GUI) function Executing; Wherein the application template manager comprises a page created by an application template providing a resource file created in advance or a user page defined by a user and constituting content for each screen according to a business model desired by the user; And a controller for managing the configuration file for the per-screen content and for coordinating the configuration file and the stored procedure stored in the database and for performing data access, processing and management based on the stored procedure and the configuration file Thereby providing a common data service.

The web application framework is layered into a presentation layer, a data access layer, and a business logic layer.

Wherein the presentation layer performs a frame configuration function of a screen, a page creation / modification / deletion / editing function, a view control function for setting attributes by content, a user page addition / modification / deletion / editing function, The business logic layer is implemented as the stored procedure and implements the business logic separated from the graphical user interface (GUI).

The frame structure function of the presentation layer may include generating a menu frame and a screen display condition in which a menu is dynamically generated according to a user right of the user terminal, an intermediate aggregation table area generated according to the search condition, And a basic common page including a detailed page area to which the service is connected.

When generating a page of a screen of the presentation layer, the layout information and the field information are called in the configuration file of the screen, and layout and control are generated in the basic template at the time of rendering, and event generation and service information are stored.

Transmitting the current field information and the data information to the edit template page in a post manner when the page of the presentation layer screen is edited; Generating an input control according to the field information and editing information of the configuration file, generating an event, and storing service information; And transmitting the corresponding service name and input data to the data manager when storing or deleting the data information, and performing a refresh using the callback when the result of storing or deleting the data information is received .

The application template manager generates a screen in the event of a user event and then maintains data of the previous screen using a view state.

The view control function of the presentation layer may be visualized in the form of at least one of a grid view, a chart view, and an HTML view.

The user interface framework operating method for constructing a web-based application of the present invention visualizes the execution of an application in order to improve development productivity in the development of a computer system of an enterprise and generates a screen independent of the business logic, In addition to minimizing workload, developers who are unfamiliar with Web-based application development can easily build applications based on business models, and can provide integrated management environment between developers, users, and administrators. There is an effect that satisfaction can be improved.

In addition, since the development source is not disclosed, the present invention can easily work with other companies or external developers, and can improve the reusability of previously constructed pages by generating a dynamic layout by a configuration file (config file) And visualization in the form of grid, chart, or HTML using XML enables the business logic implementation to be clear and concise, thereby improving the efficiency of operation and maintenance as well as development productivity.

1 is a flowchart illustrating a method of operating a user interface framework for building a web-based application according to an embodiment of the present invention.
2 is a diagram for explaining the configuration of the web application framework of FIG.
FIG. 3 is a view for explaining a frame configuration function of the presentation layer of FIG. 2. FIG.
4 is a diagram for explaining a page creation function of the presentation layer of FIG.
FIG. 5 is a view for explaining a view control function of the presentation layer of FIG. 2. FIG.
6 to 8 are views for explaining an example of applying a user interface framework operating method for building a web-based application according to an embodiment of the present invention to a business model of quality management.
9 is a diagram for explaining an example of applying a user interface framework operating method for building a web-based application according to an embodiment of the present invention to a business model of facility management.

The description of the present invention is merely an example for structural or functional explanation, and the scope of the present invention should not be construed as being limited by the embodiments described in the text. That is, the embodiments are to be construed as being variously embodied and having various forms, so that the scope of the present invention should be understood to include equivalents capable of realizing technical ideas. Also, the purpose or effect of the present invention should not be construed as limiting the scope of the present invention, since it does not mean that a specific embodiment should include all or only such effect.

Meanwhile, the meaning of the terms described in the present invention should be understood as follows.

The terms "first "," second ", and the like are intended to distinguish one element from another, and the scope of the right should not be limited by these terms. For example, the first component may be referred to as a second component, and similarly, the second component may also be referred to as a first component.

It is to be understood that when an element is referred to as being "connected" to another element, it may be directly connected to the other element, but there may be other elements in between. On the other hand, when an element is referred to as being "directly connected" to another element, it should be understood that there are no other elements in between. On the other hand, other expressions that describe the relationship between components, such as "between" and "between" or "neighboring to" and "directly adjacent to" should be interpreted as well.

It should be understood that the singular " include "or" have "are to be construed as including a stated feature, number, step, operation, component, It is to be understood that the combination is intended to specify that it does not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, or combinations thereof.

In each step, the identification code (e.g., a, b, c, etc.) is used for convenience of explanation, the identification code does not describe the order of each step, Unless otherwise stated, it may occur differently from the stated order. That is, each step may occur in the same order as described, may be performed substantially concurrently, or may be performed in reverse order.

All terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs, unless otherwise defined. Commonly used predefined terms should be interpreted to be consistent with the meanings in the context of the related art and can not be interpreted as having ideal or overly formal meaning unless explicitly defined in the present invention.

1 is a flowchart illustrating a method of operating a user interface framework for building a web-based application according to an embodiment of the present invention.

Referring to FIG. 1, a method of operating a user interface framework for building a web-based application is a method in which a platform system providing a web-based application building service authenticates a user authority according to a request of the user terminal, (S1 and S2), which includes at least one of location information, data security setting information, database connection information, and session setting information.

When setting the Web platform, the user terminal generates Internet Information Service settings and data security information, and generates service location information on the root of the service URL and database connection information on the basic connection database. At this time, when using multiple databases, database connection information is generated with the key value of the corresponding database. The user terminal sets the shared folder through the web sharing function and performs the security setting on the folder.

The platform system creates session setup information with the user terminal by adding code to the session event of Global.asax which serves as a gate for accessing all pages of the web site.

When the user terminal is connected to the web application framework running on the platform system, the web application framework includes an application template manager that dynamically manages the screen configuration with a screen-specific configuration file (Congig file) and provides a graphical user interface (S3 and S4)

The application template manager generates a page based on an application template that provides a pre-created resource file or a user page based on a user definition, creates an XML-based dynamic layout according to a business model desired by the user, And sets the content by configuring a page for each layout (S5)

The business model includes order management, production management, facility management, purchasing management, quality management, and inventory / financing management. The contents of detailed pages vary depending on the case of long-term planned production, short-term fixed plan production and order production. .

The application template manager manages a configuration file for each content, and coordinates a configuration file and a stored procedure stored in the database (S6). Then, the application template manager notifies the application that the application To provide a common data service for performing access, processing and management (S7)

The application template manager causes the user terminal to display the pages including the content on the screen through the view control function expressing the GUI (S8)

2 is a diagram for explaining the configuration of the web application framework of FIG.

Referring to FIG. 2, the web application framework 100 is layered into a presentation layer 110, a data access layer 120, and a business logic layer 130.

The presentation layer 110 supports a frame configuration, a page creation / modification / deletion / editing of a screen, a view control for setting a property for each content, and a function of adding / modifying / deleting / editing a user page.

The data access layer 120 handles a standardized interface with the upper database 135. When using multiple databases, the data access layer 120 generates database connection information with a key value of each database 135, and the resultant value is a serializable data set Dataset) format.

In addition, the data access layer 120 is connected in a non-forward oriented manner using a connection pool. When there is an instruction execution request, the data access layer 120 connects to the server, performs a corresponding operation, returns a result value, . The server to which the data access layer 120 can connect is an Oracle server or an MS-SQL server.

The business logic layer 130 implements the business logic separate from the graphical user interface (GUI) and is implemented in the stored procedure 131 or package of the database 135. In addition, the business logic layer 130 may read the stored procedure 131 or the package list of the current database 135 at the time of setting a page, connect to the service, and may be replaced with a web method format in the future.

FIG. 3 is a view for explaining a frame configuration function of the presentation layer of FIG. 2. FIG.

Referring to FIG. 3, the presentation layer 110 generates a menu frame 210 and a basic common page 220 on a screen 200 to form a frame.

The menu frame 210 dynamically creates a top-down type menu in accordance with the logged-in user right, and the basic common page 220 can call the detailed page area 223 as an entire common page below the menu frame It contains an iFrame.

The basic common page 220 includes a query condition creation unit 221, an intermediate aggregation table creation unit 222 and a detailed page area 223. The detailed page area 223 includes an edit page 224, Page 225. < / RTI >

The inquiry condition generation unit 221 generates the inquiry condition control and the intermediate aggregation table generation unit 222 can be the data table generated with the inquiry condition data. If there is no connected service, the intermediation aggregation table generation unit 222 does not appear on the screen, We pass to detail page.

The intermediate aggregate table generating unit 222 shows a grid view showing the result of the stored procedure 131. If there is no stored stored procedure, the intermediate aggregate table generating unit 222 generates the intermediate aggregate table generating unit 222, The query condition data is transmitted.

The detail page area unit 223 can form a table frame according to the setting of the user and generate condition controls, buttons, and view controls corresponding to the settings in the cell area. The detail page area unit 223 can divide the area, and can set content for each area and connect to the service.

When the application template is used, the detailed page area 223 can be connected to the detail page of Load / detail0100.aspx to divide the area, and the content for each area can be set and connected to the service. On the other hand, the detail page area unit 223 can specify the URL of the user page.

The detail page area unit 223 can set a layout using an application template, add a query condition to be displayed at the top of the detailed page, and configure a page for each layout.

Layout setting divides the section of the detail page into rows and columns, sets the height and width of each section, and sets the merging for each section. Layout-specific pages can add a title for each selection, set the stored procedure to link by selection, and set the content to show the results of the linked stored procedure.

On the other hand, the page file name and the menu_ID can be displayed at the top of the detail page area 223. [ At this time, one XML number per page is generated for the menu_ID, and can be automatically generated as an XML number each time a page is generated.

The edit page 224 generates an edit window using the column information of the grid view, and the pop-up page 225 displays the detailed information of the row in the grid view as a pop-up window according to the set service name.

The detail page area unit 223 can support the flexible use by allowing the user page defined by the user to be called instead of the page generated by the basic template in addition to the frame configuration.

The user page can replace the basic common page, the detail page, the edit page, and the pop-up page, and a user can specify a connection URL by adding a new pop-

4 is a diagram for explaining a page creation function of the presentation layer of FIG.

Referring to FIG. 4, the presentation layer 110 performs page creation, data retrieval, data editing, and data retention functions.

The screen generation function takes layout information (LAYOUT_INFO) and field information (FIELD_INFO) from the configuration file (Configuration file) to generate layout and control in the basic template upon rendering, and generates an event to store the service information (SERVICE_INFO).

The data inquiry function transmits the corresponding service name and condition control value to the data management language (DAL), receives the data inquiry result in the data set, and generates the screen by referring to the header reservation word and the tag.

DAL is an SQL command used by users who manage databases (for example, database administrators (DBAs)). By using DAL, database administrators can use the contents of a specific database (attributes, relations, (Group) can be approached, and SQL command that can be canceled after a certain period of time can be utilized to effectively maintain database security.

The data editing function transmits current field information and data information to the edit template page in a post manner, generates input control according to field information and edit information (EDIT_INFO) of the configuration file, and generates an event and stores service information. When saving or deleting data, the data editing function transfers the corresponding short name and input data to the DAL, and refreshes the upper page using the callback after receiving the result.

Since all dynamically generated pages are initialized when a user event occurs, data can not be maintained due to the characteristics of the web. Therefore, the data holding function always generates a screen when an event occurs and retains data of a previous screen using a view state Update the page.

FIG. 5 is a view for explaining a view control function of the presentation layer of FIG. 2. FIG.

Referring to FIG. 5, the view control function of the presentation layer 110 performs a grid view, a chart view, and an HTML view.

The grid view connects the data set through the DAL to the data source, generates a computed column (row) when there is a computed tag, and generates a header column and an item column. Item columns are reserved word, style, and merge.

Grid views can generate additional event scripts such as user rendering events, editing in user-rendered events depending on the mode, sub-grid, sub-chart invocation, and so on.

The chart view serializes the data set through the DAL and transmits it to the chart page in a post manner, converts the received string into a data set by parallelizing the received string, and connects the data to the chart.

The chart view also receives the client size using a callback, generates a temporary image file of the chart according to the client size, and connects the image file in the client script.

The HTML view receives the data set via the DAL, transforms the string into HTML tags when rendering, and passes the resulting string to the client script.

This view control function finally sends the generated pages to the user terminal according to the desired business model so that the result of the linked stored procedure is displayed in a grid, chart or HTML format.

On the other hand, the application template manager performs the update function, and the inquiry condition can be designated according to the ID of the logged-in user, so that the data of the intermediate aggregation table area and the detail page area can be displayed differently for each user.

In addition, the application template manager can search log-in / log-out history by date of the corresponding login by creating a login history procedure, and can add a supported language table to enable multi-language support.

6 to 7 are views for explaining an example of applying a user interface framework operating method for building a web-based application according to an embodiment of the present invention to a business model of quality management according to an embodiment of the present invention .

As shown in FIG. 6, the application template manager adds a button related to quality control to the query condition creating unit or the detail page area by the user terminal, and displays the legend visibility (Hide Legend), and set the Bar / Line (Chart Style). At this time, the chart style sets the default value.

The application template manager implements the chart view procedure. That is, by using the tag in the column name of the data, it implements series style such as bar series, smooth line series line series, and pointless line series (none-point) If no tag is specified, it is set to the chart style of the chart view. It is set to Chart Style of Chart View.

As shown in FIG. 7, the user terminal can generate the Xbar-R chart using the none-point chart and the legend. At this time, the application template manager implements the procedure of the chart view by implementing the style for each series by using the tag of the column name of the corresponding data. The column name of the series data uses the label of the series legend, and the title of the Xbar control chart is used as the title of the chart view.

As shown in FIG. 8, the process capability analysis / evaluation items of the quality management are implemented as an area (AREA), a smooth area (SMOOTH AREA) chart, HTML, and contents.

The application template manager implements the chart view procedure by setting a series style of an area series and an area-smooth series using a tag for the column name of the data by the user terminal. The HTML content can implement the procedure by performing HTML selection (Content) and completion HTML sentence selection (select).

9 is a diagram for explaining an example of applying a user interface framework operating method for building a web-based application according to an embodiment of the present invention to a business model of facility management.

Referring to FIG. 9, the application template manager may implement a top N grid (TOP N Grid) that can analyze and display the top N data according to the sorting criteria set by the user terminal.

When the application template manager concatenates the procedures that set the sorting criteria, the data of the top N data, the top N data sum, the total sum, and the top N total data ratio are displayed in the grid view format.

The application template manager can generate and display a statistical line when the number of upper N data to be displayed on the screen is set as in the procedure implemented in FIG.

It will be apparent to those skilled in the art that various modifications and variations can be made in the present invention without departing from the spirit or scope of the present invention as defined by the following claims It can be understood that

110: Presentation Layer 120: Data Access Layer
130: business logic layer 135: database

Claims (8)

A method of operating a user interface framework for building a web-based application for operating a web application framework according to a business model using a platform system for providing a web-based application building service,
The platform system authenticates the user authority according to a request of the user terminal, and then performs a web platform setting including at least one of service location information, data security setting information, database connection information, and session setting information for the user terminal ;
When the user terminal is connected to a web application framework running on the platform system, the web application framework includes an application template manager for dynamically managing the screen configuration with a screen-specific configuration file and providing a graphical user interface (GUI) function Executing;
Wherein the application template manager comprises a page created by an application template providing a resource file created in advance or a user page defined by a user and constituting content for each screen according to a business model desired by the user; And
Processing and managing data on the basis of the stored procedure and the configuration file after coordinating the configuration file with the configuration file and the stored procedure stored in the database, Providing a data service;
Lt; / RTI >
Wherein the web application framework is layered into a presentation layer, a data access layer, and a business logic layer.
delete The method according to claim 1,
The presentation layer functions as a screen frame configuration function, a page creation / modification / deletion / editing function, a view control function for setting attributes by content, a user page addition / modification / deletion /
Wherein the data access layer is responsible for a standardized interface with the database,
Wherein the business logic layer is implemented as the stored procedure and implements the business logic separate from the graphical user interface (GUI).
The method of claim 3,
The frame structure function of the presentation layer may include generating a menu frame and a screen display condition in which a menu is dynamically generated according to a user right of the user terminal, an intermediate aggregation table area generated according to the search condition, And a basic common page including a detailed page area to which the service is connected is configured. The method for operating a user interface framework for building a web-based application.
The method of claim 3,
Wherein the layout information and the field information are called from the configuration file of the screen when the page of the presentation layer screen is created, and the layout and control are generated in the basic template upon rendering, and the event generation and the service information are stored. A method of operating a user interface framework for construction.
The method of claim 3,
Upon editing a page of the presentation layer screen,
Transmitting current field information and data information to an edit template page in a post manner;
Generating an input control according to the field information and editing information of the configuration file, generating an event, and storing service information; And
Transferring the service name and the input data to the data manager when storing or deleting the data information, and performing a refresh using the callback when the result of storing or deleting the data information is received A method of operating a user interface framework for building a web based application.
The method according to claim 1,
Wherein the application template manager generates a screen when a user event is generated and then maintains data of a previous screen using a view state.
The method of claim 3,
Wherein the view control function of the presentation layer is visualized in a form of at least one of a grid view, a chart view, and an HTML view.

Images