KR19990032183A - Visual design of hypertext for web databases - Google Patents

Abstract

The present invention relates to a method of visually designing hypertext for a web database, comprising: initializing a database system of a server and directories of a web server; designing hypertext data of a graph structure; Editing, in a visual manner, static documents among the nodes of the graph designed above, and visually editing prototypes of dynamic documents, which are nodes of the remaining graph; The application server program source with FastCGI source code is connected by connecting the part of the database result in the dynamic document to the database system of the server defined above, and the graph structure with each detailed edited node. Creating and refining the generated documents and codes ent) to provide an environment that enables the development of database gateways on the web through visual programming.

Description

Visual design of hypertext for web databases

The present invention provides a method for automatically generating C language program source code of an application server that is finally linked to HTML documents and Fast Common Gateway Interface (FastCGI) through a visual design of hypertext for a web database. In particular, the C language source of the FastCGI application server for editing all nodes of a hypertext graph data structure consisting of static and dynamic documents using visual object design techniques, creating dynamic documents, and managing state. How to generate code automatically.

Web and database interworking technology is increasing in importance in terms of allocating existing databases due to the emergence of the Internet, intranet, and extranet. It shows great ripple effect, and strategically nurtures leading companies in advanced foreign countries.

Conventional interworking methods include a common gateway interface (CGI) application server method and an extended application program interface (API) method. However, the Common Gateway Interface (CGI) application server approach has the overhead of creating and destroying distributors and the inconvenience of the developer designing and managing the application server processor pool. Although it is faster than the server method, it is burdensome for the web server, and the defect of the database path connected to the extended API is decisively affecting the total number of web servers. Also, conventionally, they are only generating static documents or generating simple CGI programs that do not deal with databases. Recently, FastCGI interworking method is gradually spreading as the fastest, easy to implement and portable method.

Accordingly, in the present invention, a method for automatically generating a source code of a FastCGI application server that connects a database and a dynamic document of a server based on a graph data structure described by a user in a visual object development environment to compensate for the above disadvantages. To provide.

In the present invention, for the interworking of the web and the database, it is possible to visually design the hypertext structure of the web, and finally to create a database path of the FastCGI method for this. The automatic generation of the database path program source for such interworking can greatly increase development productivity.

Therefore, in the present invention, when developing an interworking system between a DBMS and a web that is increasingly important, a user can develop an interlocking system having a powerful function through editing visual expressions without going through a complicated programming process. Its purpose is to make it possible to provide effective services to web users.

1 is a block diagram of a hypertext visual design system for a web database according to the present invention.

2 is a flowchart of a hypertext visual design system for a web database according to the present invention;

3 is a flowchart of a hypertext graph design according to the present invention;

4 is a data flow diagram for visual editing of a template of static and dynamic document prototypes in accordance with the present invention.

5 is a database connection flow diagram in a dynamic document in accordance with the present invention.

6 is a data flow diagram for generating a Fast Common Gateway Interface (FastCGI) application server program source according to the present invention.

* Description of the symbols for the main parts of the drawings *

3: graph design processor 4: code generation processor

5: Database connection management processor 6: Dynamic document editing processor

7: Text editing processor 8: Directory connection management processor

9: static document management processor 71: text attribute control processor

81: document editing processor 114: HTML management processor

115: CGI Management Processor

According to an aspect of the present invention, there is provided a method of visually designing a hypertext for a web database, comprising: initializing a database and initializing a path of a directory for storing data files; Receiving a user command and designing a graph structure of hypertext for building a web site based on the user command; Performing static document editing on nodes whose attributes are static documents among the nodes constituting the hypertext graph, and performing dynamic document editing on nodes having dynamic document properties, which are nodes of the remaining graph; Generating a fast common gateway interface (FastCGI) application server program source based on a graph structure including each node of the dynamic document editing; Performs a refinement step of testing and refining the documents generated in the static document editing step and the dynamic document editing step, and the program codes generated in the fast common gateway interface (FastCGI) source generation step. It provides an environment that enables the development of database pathways through visual programming.

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

1 is a configuration diagram of a hypertext visual design system for a web database according to the present invention, FIG. 2 is an operation flowchart of a hypertext visual design system for a web database according to the present invention, and FIG. FIG. 4 is a data flow diagram for visual editing of static and dynamic documents, and FIG. 5 is a database connection flow diagram within a dynamic document, according to the present invention. 6 is a flowchart for generating a FastCGI application server program source according to the present invention.

The present invention is a database path program using FastCGI interworking method, which is the fastest, easy to implement and portable method among web and database interworking methods. To generate the source automatically.

1 is an overall configuration diagram of a hypertext visual design system for a web database according to the present invention, as shown, a code generator 4, a text editor 7, a database connection management processor 5, a directory connection management processor (8), a graph design processor (3), a dynamic document editing processor (6), and a static document editing processor (9).

Also used are the code pool (1) and the graph data structure (2). Hypertext Markup Language (HTML) document (13) resulting from the static document editing processor, HTML document frame (10) resulting from the dynamic document editing processor (6), database management processor (5), code generator (4), FastCGI application server source code (11), data file (12).

If a user wants to build a web site with a machine for the server, internet access, auxiliary storage, and a web server, he must design a graph structure to represent the hypertext structure of the web site. Without the aid of visual design by computer, the user must design by hand. Conventional techniques already allow graph representations up to static documents 13, which already exist in auxiliary storage and whose contents do not change. In the present invention, as a result of the FastCGI application server 10, 11, 12, the concept of a template is introduced and included in the graph data structure table 2 up to the dynamic document generated by the user's request. This graph data structure table 2 is designed by the graph design processor 3.

Each node constituting the graph data structure 2 is a static document or a dynamic document and edited by the static document editing processor 9 and the dynamic document editing processor 6. It is economical to use the same document editing processor 81 for static documents and dynamic document frames, since the contents of the document are static or dynamic, except that the contents of the FastCGI application server (10, 11, 12) are included. . So, in a real world implementation, you develop the same document editing processor that can edit static and dynamic document frameworks together. This document editing processor 81 is a WYSIWYG (What You See Is What You Get) method, and is described in FIG. However, conceptually, separating the editing of the static document from the dynamic document is more helpful for understanding, so the two are separated in FIG. The result of the static document editing processor is an HTML document 13 which can be viewed directly through a web browser.

The node representing the dynamic document in the graph data structure table 2 is connected to the FastCGI application server 10, 11, 12 by the CGI indicator. FastCGI application servers (10, 11, 12) are automatically generated from edited dynamic documents. FastCGI application server source code (11) is created by referencing in the code pool (1), which is the directory used in the code or external. The data is designated by the directory connection management processor 8 and stored in the data file 12, and the results of the database references are determined by the database connection management processor 5 to visually determine the database and tables and the results that the user wants to see. This creates the corresponding SQL operation and includes it in the dynamic document. The HTML document frame 10 is used to output the result of the application server program generated by the FastCGI application server source code in a HTML format on the web.

The result of editing the static document is an HTML document (13). The FastCGI application server (10, 11, 12), which is the result of editing the dynamic document, is the HTML document frame (10) and the FastCGI application server source code (11). It consists of a data file 12, in which case a text editor 7 is used in order to improve them directly or to change them directly.

2 is a flowchart of a hypertext visual design system for a web database according to the present invention.

The overall flow shows that the database initialization (21) is used to initially set the username, password, and connection method to connect to the database management system (DBMS) of the server where the database is to be used. To perform. Initialize each database to use different DBMS installed on several machines. Next, a directory initialization is performed to set a directory path for storing generated HTML documents 13 and HTML document templates 10, FastCGI application server source code 11, and data files 12. Perform (22).

When the initialization is completed, the user command is analyzed (23) to correspond to the graph data structure design step 24, the static document editing step 26, the dynamic document editing step 28, and the code generation step 31. Execute routines. The four steps 24, 26, 28 and 31 are the actual editing steps before source generation. If the user selects a graph data structure design step 24, the user performs a graph data structure design task (25). 3, the graph data structure design work is described in more detail. The design of the graph data structure repeats adding nodes to the graph data structure (54), deleting nodes (56), changing node attributes (58), moving nodes within the graph data structure (60), and editing static and dynamic documents (62). By design. Design a graph data structure and divide it into static or dynamic documents for nodes created at the same time, so that static document editing (27) for static documents, dynamic document editing (29) for dynamic documents, and linking CGI indicators ( 30), SQL generation 32 is performed. In the static document editing task 27 and the dynamic document editing task 29, the document editing is the same, but the dynamic document includes the CGI indicator and the SQL statement. These are generated in the form of HTML document frameworks 10, FastCGI application server source code 11, and data file 12 via FastCGI source generation 33 with a user code generation 31 command. Once the code has been generated, the generated code test task 36 for the code test 35, the generated code fine tuning task 38 for the code fine tuning 37, and the installation are performed via the user command 34. Installation tasks 40 will be performed.

3 is a flowchart of a hypertext graph design according to the present invention. Depending on whether the user input 52 is a condition of adding node 53, deleting node 55, node attribute 57, moving node 59, or editing document 61 assigned to the node, the node in the graph data structure Visualize static and dynamic documents with Add (54), Delete Node from Graphical Data Structure (56), Change Node Attributes (58), Move Nodes within Graph Data Structure (60), Edit Static / Dynamic Documents (62). Data flow for editing. The document editing processor 81 receives the data structure of the node where the document editing is to be performed in the graph structure design processor 3 (74), edits the document, and returns the edit result signal to the graph structure design processor 3 (75). . The edited static and dynamic documents are stored in the graph data structure data table (79). The graph structure design processor 3 can query the graph data structure data table 2 (73) to know the document edits and store the changes in the graph structure in the graph data structure table (72) (72). . The document editing processor 81 entrusts the text attribute control processor 71 with the text attribute conversion 76 which enables the attribute of the text in the document to be converted according to the HTML specification. The text attribute control processor 71 obtains the information on the text attribute from the TAG data table 83, performs the text attribute conversion, and returns the text attribute conversion result 77 to the document editing processor 81. . In document editing 81, document linking information 80 for hyperlink can be obtained from graph data structure 2, and information about HTML tag 82 can be obtained from TAG data table 83. . The CGI indicator required to edit the dynamic document is inserted during document editing 81. From the initialized databases and directories, you know in advance which database and directory will be used for the CGI indicator. The inserted CGI indicator is passed to the database connection management processor 50. After the database, tables, and columns are visually selected and defined by the user, SQL statements 85 are generated accordingly, and the document editing processor 81 is generated. Is returned. The returned SQL statements 85 are stored in an extended tag for the CGI indicator. Figure 5 describes in more detail the database connection for dynamic documents. When the dynamic document is edited in the dynamic document editing processor 81 and the text property control is finished in the text property control processor 71 and the contents of the CGI indicator are determined, the dynamic document edited by the FastCGI source generation processor 4 is displayed. Passed 87, the FasatCGI source generation processor 4 generates HTML document frames 10, FastCGI application server source code 11, and data file 12. 6 illustrates FastCGI application server program source generation in more detail. There can be several different CGI indicators in one dynamic document. Some of these have gone through the creation of FastCGI sources and some do not. FasatCGI source generation (4) The processor sets and returns a CGI indicator registration flag indicating that the source generation has been registered for the completed CGI indicator (86).

5 is a flow diagram for a database connection in a dynamic document in accordance with the present invention. First, the word is acquired in the dynamic document (91), and whether it is the end of the document (92) is checked if there is a CGI indicator if it is not at the end of the document (93). Graphics user interface) (94), accepts user input for database selection (95) selects a database (96) and outputs a list of available tables (97). The user inputs the table to be used (98), selects the tables to be used (99), and outputs the contents of the table (100). After selecting (101, 102, 103) the number of columns and the number of rows to be output in the selected tables, SQL is generated (104).

6 is a data flow diagram for generating a FastCGI application server program source according to the present invention. The document analysis processor 84, which is a subprocessor of the FastCGI code generation processor 4, receives a dynamic document from the document editing processor 81 (85) and renders the portions represented in HTML as a result of the FastCGI application by the CGI indicator. Divide the parts you want to express. The portions represented in HTML are in turn sent to HTML management processor 114 (112). The HTML management processor 114 receives the HTML presentation parts (112), generates an HTML document template by grouping them into a linked list, and stores the HTML document template in the HTML document template table 10 (116). The portion represented by the CGI indicator is sent to CGI management processor 115, which is also a subprocessor of FastCGI code generation processor 4 (113). The CGI management processor 115 receives a basic code skeleton from the code pool 1 and generates an application server source code and application server data using an embedded SQL method. The code is stored in FastCGI application server source code table 11 (117), and the application server data is stored in data file table 12 (118).

According to the present invention, it is possible to automatically generate an application server (Application Server) necessary for interworking of the web and the database at the source level, and to use files, databases, and output for interworking with visual representations through a GUI (Graphics User Interface). You can easily edit HTML documents. In particular, the generated application server to support FastCGI, FastCGI is the most extensible, stable and excellent among the currently used interlocking methods, the market is growing, the demand of the present invention will increase greatly in the future.

Claims (5)

Initializing a database and initializing a path of a directory for storing data files; Receiving a user command and designing a graph structure of hypertext for building a web site based on the user command; Performing static document editing on nodes whose attributes are static documents among the nodes constituting the hypertext graph, and performing dynamic document editing on nodes having dynamic document properties, which are nodes of the remaining graph; Generating a fast common gateway interface (FastCGI) application server program source based on a graph structure including each node of the dynamic document editing; A refinement step of testing and refining the documents generated in the static document editing step and the dynamic document editing step and the program codes generated in the fast common gateway interface (FastCGI) source generation step is performed. A method of visually designing hypertext for a web database, characterized by providing an environment for visually programming database passages on the web. The method of claim 1, The graph structure design step, Upon completion of initialization, the user command is received and the user command analyzes any of the conditions of adding node, deleting node, changing node properties, moving node, and editing document assigned to the node. For a hypertext graph data structure made up of multiple nodes, add a node, delete a node from a graphic data structure, change node properties, move nodes within the graph data structure, and edit static / dynamic documents to build a Web site through a graphical user interface (GUI). A visual design method of hypertext for a web database, characterized by designing a graph data structure. The method of claim 1, The dynamic document editing step, The location of dynamic data is determined by a computer graphical interface indicator that displays the results of a file processing program or database application that supports Fast Common Gateway Interface (FastCGI) in a dynamic document through a computer graphical interface. Each database connection management processor and directory connection management processor for directory and directory connection are connected to the server's database system and file structure, and the structured query statements (SQL) statements and files included in the dynamic document are located in the computer. A visual design method of hypertext for a web database, characterized by storing it inside a graphical interface indicator to represent a dynamic document. The method of claim 3 The displaying through the computer graphic interface may include: Expresses in dynamic documents with Extended HTML Tag, and displays a list of databases, a list of tables, a list of tables, and a visual representation of columns and rows for interworking with the database. A visual design method of hypertext for a web database, characterized by setting in stages through a user interface (GUI). The method of claim 1, The fast computer graphic interface source generation step, The HTML document frame is edited by an HTML processor that manages the HTML document based on the edited dynamic document, and the part represented by the computer graphic interface indicator is the web site for building the web site through the computer graphic interface management processor. A method of visually designing hypertext for a web database, comprising generating source code of an application server and data of an application server based on the contents of a code pool representing the structure of the hypertext.