KR101195943B1 - Method for service of multi-tenant based database as a service - Google Patents

Abstract

Disclosed is a database service method as a multi-tenant based service that automatically creates a work table for serving in a multi-tenant form. To this end, the present invention collects work information from a user terminal, extracts a basic table by analyzing the work information and provides it to the user terminal, and provides a user-defined field page to the user terminal. And receiving table information, and automatically generating a work table by collecting the table information. According to the present invention, it is possible to reduce the production time and production cost of the application, it is possible to provide an application including a work table optimized for individual users.

Description

Database service method as a multi-tenant based service {METHOD FOR SERVICE OF MULTI-TENANT BASED DATABASE AS A SERVICE}

The present invention relates to a database service method as a multi-tenant-based service that automatically creates a work table for a service providing a database in a multi-tenant form. More specifically, a plurality of users jointly use the service through the Internet. The present invention relates to a database service method as a multi-tenant-based service that can satisfy an individual user's needs by allowing users to directly add necessary tables without a developer's help.

Application Service Provider (ASP) refers to an application service that provides an application to a user through the Internet, that is, a web-based application hosting service provider. In addition, ASP refers to a service providing method of using a web application in the form of a lease in proportion to the time when an application user pays a monthly amount or uses it.

In other words, ASP services lend high-end applications such as customer relationship management (CRM), enterprise resource planning (ERP), groupware, and office products through a communication network such as the Internet.

As a result, customers pay a monthly fee for software that is rather expensive to use for a period of time or too much maintenance, so customers do not have to buy expensive software and worry about the additional cost of upgrading each time. You don't have to.

By using this service, the company has low user fees, reduced server operation and maintenance costs, and enables integrated management of data regardless of region.

These ASPs consist of program providers, network providers, security management providers, database providers, and portal providers. In order to revitalize this ASP business, the role of the security management service provider in addition to the program provider to securely manage confidential information is important.

Recently, telecommunications companies, system integrators, large information technology companies, and small and medium-sized companies have joined this market and emerged as the next growth business in the IT field, and major IT companies such as IBM, Microsoft, Oracle, and SAP. Are competing for the lead.

On the other hand, SaaS (Software as a Service) has recently emerged as an extension of the existing ASP.

If the ASP is focused on replacing traditional applications online, SaaS is a concept that emphasizes a new way of distribution in all areas of software.

More specifically, SaaS is a distribution form of software in which only a user's functions required by a user are distributed as a service so that the user can use the service. And with SaaS, users get only what they need when they need it, and they pay only for what they use.

Such a SaaS has a form in which a user downloads and installs a required function in a user's terminal, and uses a function of a software running on a server online through a network, and the latter has become mainstream in recent years.

General software combines the functions required by the user to provide the same function to all users, but such software has many functions that are not necessary for any one user, and they have to pay for the functions that are not needed.

Thus, the idea of SaaS, which allows users to use only the features they really need, pays only for those features. The SaaS is similar to an ASP service in that software is used online through a network, and may also refer to a general ASP service.

The ASP and SaaS markets are expected to grow significantly in the future due to the expansion of the IT infrastructure due to the expansion of leased lines and the availability of web-based software at a low price from the point of view of application users.

However, there is a problem that ASP must create new logic according to the user, cannot reuse existing data, and it is difficult for the user to directly modify the application. In addition, SaaS takes a long time to develop, there is a table that is not suitable for the user, it is inconvenient to use, and there is a problem that requires high specification hardware.

In addition, the SaaS technology architecture maturity level of most SaaS service providers provided in Korea is level 2, and technology development is required to upgrade to a level 3 level similar to that of overseas SaaS service providers such as Salesforce.com.

Accordingly, an object of the present invention is to provide tenant properties so that users who provide existing SaaS services can directly create a table suitable for a user's task while minimizing addition and change of an existing system, and service the service as a multi-tenant. It is to provide a database service method as a multi-tenant-based service that automatically generates an application so that all users can use an application optimized for their work.

In order to achieve the above object of the present invention, an embodiment of the present invention provides a database service method as a service for providing software stored in a database of the server to a user terminal connected to the server through an Internet communication network, Collecting work information from a user terminal through a communication network; extracting a base table from a database by analyzing the collected work information by the server; providing the base table to the user terminal; If a request signal of an additional table is input from a user terminal, the server extracts a user-defined field page and provides it to the user terminal, and inputs information of a table to be added by the user terminal through the user-defined field page to the server. Transmitting System, and provides database services, as a way of multi-tenant-based services, including the step of the server is automatically generated by the work table, additional tables are added to the main table in accordance with the information transmitted from the user terminal.

According to the present invention, although the basic table is provided according to the user's task, the final format of the task table is not fixed, and the user can add the table directly to the basic table according to his or her purpose. You can use an application that contains task tables optimized for the task. As such, the present invention can reduce the production time and production cost of the application because it can utilize a predetermined default table without producing the application from the beginning, and the user is different in the business field because the base table for various fields are stored in the database Both provide a common environment.

In addition, the present invention can be added to the table required by the user only by the metadata and customization without the programming process such as source coding, easy to use, and excellent in scalability.

In addition, the present invention can create and use a web application suitable for a user's business purpose regardless of time and place, provided that there is a minimum environment for accessing the Internet.

In addition, the present invention can be used over the Internet without installing the application required for the task directly on the user terminal can utilize the application required for the task without building a high level of hardware.

1 is a block diagram illustrating a database service system as a service according to an embodiment of the present invention.
2 is a block diagram illustrating a server of a system according to an embodiment of the present invention.
3 is a flowchart illustrating a database service method as a service according to an embodiment of the present invention.
4 is a flowchart illustrating a process of collecting work information according to an embodiment of the present invention.
5 to 12 are screen views for various web interfaces according to an embodiment of the present invention.

Hereinafter, a method of a database service (hereinafter, referred to as a 'database service as a service') of a multi-tenant based service according to preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings.

1 is a block diagram illustrating a database service system as a service according to an embodiment of the present invention.

Referring to FIG. 1, a database service system as a service according to an embodiment of the present invention includes a server 100 in which a web application is stored, a user terminal 300 accessing the server 100 to use the web application, And a wired / wireless network communication network 400 connecting the server 100 and the user terminal 300. Here, the communication network 400 is preferably an internet network supporting the TCP / IP protocol, but is not limited thereto.

In the present invention, a web application includes a web program linked to a content and a database. The content refers to a web document providing general simple information, and the web program refers to a program for interactively storing, processing, and deleting information by referring to a database.

The content is created as a file having a general html extension. And a web program can usually be written as a file with an extension of asp, php, jsp, aspx, xml, etc.

The web application may mean a website that includes a web program. These web applications can be used for CRM, ERP, and so on.

Hereinafter, each component will be described in more detail with reference to the drawings.

Referring to FIG. 1, a database service system as a service according to an embodiment of the present invention includes a server 100.

The server 100 according to the present invention receives information about a task from a plurality of user terminals 300 connected through the communication network 400 to generate a web application suitable for the task of each user terminal 300, and this It is provided to the user terminal 300.

The server 100 provides a hardware and software environment in which the user terminal 300 can produce a web application suitable for a business purpose online. To this end, the server 100 includes a program unit 110, a database 130, a web interface storage 150 that stores various web interfaces necessary for online production of a web application, and a produced web application. The control unit 160 connected to the application store 140, the program unit 110, the database 130, the web interface store 150, and the application store 140 stored and managed for each user, controls the operation of each device. It includes.

The database 130 is constructed as a relational database, but preferably includes a first database dedicated to the server 100 and a second database assigned and provided for each user registered in the server 100, but is not limited thereto. Do not. Here, the first database includes a user information storage unit, an account information storage unit for each user, and a terminal information storage unit for each account in which various terminal information on which a web application is transmitted and mounted is stored and managed. In the second database, various tables are newly created, changed, or deleted while the user accesses the server 100 to produce a web application including the user's additional contents. On the other hand, the database 130 stores a basic table required for each task for the rapid creation of the application. As such, since the base table is stored in the database 130, the process of generating the base table for each task is omitted.

The web interface storage 150 provides a web interface capable of collecting various parameters from the user terminal 300 necessary for producing a web application. The web interface store 150 has a number of form elements and is managed by the controller 160. Here, the web interface is extracted from the web interface storage 150 by the controller 160 and provided to the user terminal 300 at the request of the user terminal 300. Various data collected through the web interface is transferred to a module of the program unit 110 that is designated in advance and processed. Here, the various data means parameters related to table generation of the database 130.

The program unit 110, for example, the member registration module 111, member authentication module 112, table generation module 113, program generation module 114, billing module 115, transfer module 116 It may include. Each of these modules is written in a known web programming language. In other words, each module according to the present invention is not limited by a specific software development language.

More specifically, the member registration module 111 is a module that processes this when the user terminal 300 accesses the server 100 through the communication network 400 and requests membership. The member registration module 111 provides the user terminal 300 with a member registration page included in the web interface storage 150 during the user registration process. At this time, the user terminal 300 obtains a member ID and a login password through membership registration. The member registration module 111 registers new member information or changes previously registered member information in a user information storage unit of the database 130 in association with the server 100 at the request of the user terminal 300. Or delete the registered member information.

The member authentication module 112 performs a member authentication operation when the user terminal 300 logs in to the server 100 through the communication network 400. In this login process, the user terminal 300 inputs a member ID and a login password to the server 100. Thereafter, the member authentication module 112 refers to the user information storage of the database 130 and performs a member authentication operation. Here, the member authentication operation follows a known technique.

The table generating module 113 collects data for generating a table to be associated with a web application in the database 130 from the user terminal 300, and analyzes the data to extract a base table from the database 130. . In this case, the base table may be output in the form of a list according to a predetermined extraction criterion. Here, the data for generating the table refers to data that can determine the business purpose of the user terminal 300.

Such data is extracted from the web interface storage 150 by the controller 160 and collected through the work table generation information input page provided to the user terminal 300. The work table generation information input page includes a form field for inputting a table name, a name of each field included in the table, a property of a field, and a description of the field, and information inputted in each field through the communication network 400. It includes a submission interface, such as a submit button that can be received at 100. In addition, the interface of the work table generation information input page may be implemented using a dropdown control, a check box control, or a text area control.

In addition, the table generation module 113 stores each data input from the work table generation information input page in the database 130, in addition to generating the base table in the database 130. At this time, the database 130 stores the name of the table, the name of the field included in the table, the attribute of the field, and the description of the field. When the base table is extracted by the table generation module 113, the table generation module 113 includes the necessary items (unique number, registration date, registrant, modification date, modifier, member company number) for identifying each record of the table. It's a good idea to automatically add fields to your base table.

 The program generation module 114 extracts a user-defined field page from the web interface storage 150 when an additional table request signal is received from the user terminal 300 to the server 100 in addition to the basic table. Module provided to the user terminal 300. In addition, the program generation module 114 collects the contents of the additional table input from the user terminal 300 through the user-defined field page, analyzes the collected contents, and generates a work table in which the additional table is added to the basic table. . As such, when the generation of the work table is completed through the program generation module 114, the controller 160 provides this to the user terminal 300. In this case, the controller 160 may perform a separate charging process for the user terminal 300 before providing the application including the work table to the user terminal 300.

The charging module 115 performs charging before transmitting the application including the work table to the user terminal 300 under the control of the controller 160. More specifically, the charging module 115 requests a payment from the corresponding user terminal 300 before transferring the web application to the user terminal 300. In this case, the payment amount may be differentially determined according to the capacity of the program file constituting the web application to be transferred or the size of the database 130 used.

Referring to FIG. 2, the hosting service system according to the present invention includes a user terminal 300.

The user terminal 300 accesses the server 100 through the communication network 400, inputs information on the work content of the user, checks the basic table provided from the server 100, and inputs information on additional tables. As a general desktop computer, a notebook computer, a mobile communication terminal and the like can be used.

The user terminal 300 may download a necessary function from the server 100 and install it in its own terminal, or use a function of software operating on the server 100 online through a network.

Accordingly, the user terminal 300 may use the web application in the form of lease in proportion to the time used to pay a certain monthly amount to the manager of the server 100. Therefore, the user terminal 300 does not need to purchase and install an expensive program.

On the other hand, since the user terminal 300 can use the functions of the software operating on the server 100 online, the user terminal 300 does not have to provide a software and hardware environment for driving the web application. However, since the user terminal 300 needs to access the server 100 through the communication network 400 and use a web application online, the communication interface (LAN card, communication modem, etc.) and the server 100 are optimized for the user. A web browser is provided for analyzing and outputting various user interfaces provided for the production of the web application. Here, the web browser may be Microsoft Internet Explorer, but is not limited thereto.

Referring to FIG. 2, the hosting service system according to the present invention may further include an agent server 200.

The agent server 200 is connected to the server 100 and the user terminal 300 through the communication network 400, and accesses the server 100 to generate an application suitable for a specific business purpose, the user terminal 300 It can be used to provide desktop and notebook computers.

The agent server 200 generates an application suitable for a specific task in place of the user terminal 300 and serves to provide the application to the corresponding user terminal according to a request of the user terminal 300 performing a specific task.

On the other hand, the present invention provides a database service method (hereinafter referred to as a 'database service method as a service') as a service using the above-described database service system as a service.

3 is a flow chart sequentially showing the overall flow of the present invention.

Referring to FIG. 3, a database service method as a service according to an embodiment of the present invention includes a first step (S400) in which the server 100 collects work information from the user terminal 300 through a communication network 400; The second step (S500) of analyzing the collected work information by the server 100 and extracting the basic table based on this and providing it to the user terminal 300 (S500), and the user terminal confirmed the basic table by the server 100 ( A third step (S600) of providing a user-defined field page (S300), and a fourth step of inputting information of a table to be added by the user terminal 300 through the user-defined field page to the server 100 ( S700, and a fifth step (S800) in which the server 100 checks the information transmitted from the user terminal 300 and automatically generates a work table based on the information.

Hereinafter, each step will be described in more detail with reference to the accompanying drawings.

As shown in FIG. 3, the database service method as a service according to an exemplary embodiment of the present invention includes the steps of first requesting the user terminal 300 to use the web application service from the server 100 through the communication network 40 ( S100 and a step (S200) of approving an application for using the service of the user terminal 300 through the server 100.

As such, when a specific user terminal 300 accesses the server 100 through the communication network 400 to apply to use the web application service in the multi-tenant environment, the server 100 selectively requests to use the web application service. I approve. At this time, the application for using the service and the approval procedure for the application may proceed as a general membership registration process. In other words, the user terminal 300 applying for membership acquires an ID and a login password for accessing the server 100.

More specifically, when the user terminal 300 is connected to the server 100 to apply for the use of the web application service, the control unit 160 of the server 100 through the member registration module 111 the user terminal 300 Provides a registration page shown in FIG. Subsequently, when the user terminal 300 provided with the member registration page inputs each piece of information to the member registration page and provides the information to the server 100, the member registration module 111 controls the database 130 under the control of the controller 160. The member information is registered in the user information storage unit) and then the application of the user terminal 300 is approved.

Referring to FIG. 3, the database service method as a service according to an exemplary embodiment of the present invention includes a step (S300) of allocating a storage space by the server 100 to the user terminal 300.

More specifically, when the application for use of the user terminal 300 is approved, the server 100 allocates a storage space for storing an application to be generated by the user terminal 300. Here, the storage space is present in the storage medium of the server 100 and may exist in the database 130 or in a separate large drive, but it is preferably present in the database 130. After the storage space is allocated, the server 100 may store a directory name for each member information stored in the storage space.

As shown in FIG. 6, after the storage space capacity of the user terminal 300 is allocated, the user terminal 300 may access the server 100 to produce a web application.

Referring to FIG. 3, a database service method as a service according to an embodiment of the present invention includes a first step S400.

The first step (S400) is a step for collecting work information from the user terminal 300, as shown in Figure 4, the new project application step (S410) and the step of providing a work information input page (S420) and work Information input step (S430) and collecting the work information from the page (S440).

More specifically, when the user terminal 300 receives the contents of the web application to be promoted to the server 100 as a new project (S410), the table of the program unit 110 is generated under the control of the controller 160. The module extracts the work information input page from the web interface storage 150 and provides it to the user terminal 300 (S420). In this case, the work information input page may be formed as shown in FIG. 7 and includes an application date, a title, a table name, an applicant name, a table description, and the like.

Subsequently, the user terminal 300 inputs the work information through the work information input page to generate a web application suitable for a work purpose, and provides the work information to the server 100 through the communication network 400 (S430). In this case, logical information (eg, customer name, address, phone number, etc.) of a work table to be generated may be input to the table description of the work information input page. In addition, the user terminal 300 may receive the generation of a plurality of web applications to the server 100.

When the work information input page in which work information is input is received by the server 100, the controller 160 collects work information from the work information input page through the table generation module 113 to recognize a work field of the web application. . In this case, the table generation module 113 may include the collected work information in the database 130.

Referring to FIG. 3, a database service method as a service according to an embodiment of the present invention includes a second step S500.

The second step (S500) is to analyze the business information collected by the server 100, and to extract the base table from the database 130 based on the analyzed information to generate a base table approval page, the base table approval page Is provided to the user terminal 300. As shown in FIG. 8, the basic table approval page includes a list of tables essential for each business field entered by an administrator of the server 100. In other words, different base tables may be extracted from the database 130 according to the work content input from the user terminal 300.

Subsequently, the user terminal 300 checks the basic table approval page provided from the server 100 to individually approve or return the necessary tables according to the business purpose.

In addition, the server 100 may request modification of the base table by clicking the title of the individual table. As such, when the user terminal 300 requests a modification operation of the base table, the server 100 extracts a table modification information input page from the web interface storage 150 through the table generation module 113, and then the user terminal 300. To provide. At this time, the table correction information input page may be formed as shown in FIG.

Thereafter, the table generation module 113 receives information necessary for table modification from the user terminal 300. In this case, information necessary for modifying the table includes a table name, a name of each field to be included in the table, an attribute, and a brief description.

If necessary, the user terminal 300 searches for a specific table among a plurality of tables included in the base table as shown in FIGS. 10 to 12, and clicks the table name to modify the metadata for the table. You can also ask for (100).

  Referring to FIG. 3, a database service method as a service according to an embodiment of the present invention includes a third step S600.

In the third step (S600), if a request signal for an additional table is input from the user terminal 300 that checks the basic table, the server 100 sends a user-defined field page from the web interface storage 150 through the program generation module 114. Extracting and providing the same to the user terminal 300.

More specifically, the user terminal 300 confirms the basic table and approves the necessary tables. If the necessary table is not included in the basic table, the user terminal 300 transmits a generation signal of the additional table to the server 100.

Subsequently, when the generation signal is received, the controller 160 of the server 100 extracts the user-defined field page from the web interface storage 150 through the program generation module 114 and then converts the user-defined field page into the corresponding user terminal ( 300).

Referring to FIG. 3, a database service method as a service according to an embodiment of the present invention includes a fourth step S700.

The fourth step S700 is a step in which the user terminal 300 inputs information of a table to be added through the user defined field page and transmits the information to the server 100.

More specifically, when a user-defined field page transmitted from the server 100 is received by the user terminal 300, the user terminal 300 adds the contents of the table to the user-defined field page in order to add a table necessary for the task. The user inputs the completed custom field page to the server 100.

Referring to FIG. 3, a database service method as a service according to an embodiment of the present invention includes a fifth step S800.

The fifth step S800 is a step in which the server 100 automatically generates a work table in which an additional table is added to the basic table according to the information transmitted from the user terminal 300.

More specifically, when a user-defined field page in which the content of the additional table is input through the user terminal 300 is received by the server 100, the controller 160 controls the additional table to be added to the base table through the program generation module 114. A web application having an added work table is generated and stored in the application storage 140.

Subsequently, the server 100 calculates a program capacity of the generated web application, calculates a cost based on a charging policy of the server 100 administrator, and requests a payment from the user terminal 300. This billing policy corresponds to the price of providing the user terminal 300 with an environment in which a service provider can provide a web application optimized for a user's work, and receives a fee according to the amount of time received or the amount of use or monthly usage. The terminal 300 can be charged.

Subsequently, if there is a payment request, the user terminal 300 pays the requested payment amount using a known payment method such as credit card payment or bank transfer payment. On the other hand, the charging policy may adopt a method of increasing according to the number of programs to be transferred, and various other methods are applicable.

Subsequently, when the payment of the payment is confirmed, the previous module 116 of the program unit 110 transmits the web application installation information to the user terminal 300 so as to install and use the web application on the user terminal 300 or the user. At the request of the terminal 300, the web application is stored in the database 130 so that the web application can be used through the hardware of the server 100.

When the web application generated according to the application of the user terminal 300 is stored in the database 130 as described above, the user terminal 300 accesses the online application without using a web application operating environment by itself and uses the web application. It becomes possible.

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 invention as defined in the appended claims. It can be understood that it is possible.

100: server 110: program unit
111: Membership Registration Module 112: Membership Authentication Module
113: table generation module 114: program generation module
115: charging module 116: previous module
130: database 140: application repository
150: web interface storage 160: control unit
200: agent server 300: user terminal
400: communication network

Claims (5)

A database service method as a service for providing software stored in a database of a server to a user terminal connected to a server through an internet communication network,
(Iii) the process of receiving the information of the web application to be promoted by the user terminal as a new project to the server, the process of extracting and providing the business information input page to the user terminal, and inputting the business information to the user terminal. A work information collection step of providing a work information input page to a server, and a process of collecting work information from a work information input page by a server;
(Ii) the server analyzing the collected work information, extracting a base table from the database based on the analyzed information, generating a base table approval page, and providing the base table approval page to the user terminal. Providing an approval page including a process;
(Iii) a basic table approval step of confirming, by the user terminal, the basic table approval page provided from the server and individually approving the necessary basic tables according to the business purpose;
(Iii) extracting a user-defined field page and providing the user terminal to the user terminal when a request signal for an additional table is input from the user terminal which has checked the basic table;
(Iii) inputting, by the user terminal, information of a table to be added through a user-defined field page to the server; And
(Iii) automatically generating, by the server, a work table in which an additional table is added to the base table according to the information transmitted from the user terminal. The method of claim 1, wherein prior to said step (iii)
And allocating a storage capacity of a server to the logged-in user terminal. delete delete The method of claim 1, wherein after providing the authorization page
When the user terminal requests to modify the base table, the server extracts a table modification information input page to provide to the user terminal, the database service method as a multi-tenant based service.

Images