JP2002269000A - Method for automatically preparing and displaying homepage and user information database - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a method for automatically preparing and displaying a home page by which a homepage can be prepared, registered and displayed extremely simply and to provide a user information database which is edited easily and useful. SOLUTION: The individual items U1, U2... of user information inputted by a user for preparing a home page are constituted as a random file where the items U1, U2... of individual columns in a single row corresponding to the user information of the URL can be handled as individually separate data in a table-form relational database 20. In response to a homepage browsing request, the URL of the browsing object is retrieved with a retrieval key K from a URL file, and the row of the URL stored in the database 20 is retrieved to extract data on the individual items U1 (the name of a company), U2 (an address), U3 (a telephone number), ... of each column of the browsing-requested user information, and the extracted data are HTML-converted. Then, the resultant data are displayed at a designated place on the screen of the home page on the WWW browser of a client.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for easily creating and registering a home page of a user on the Internet and displaying it on a WWW browser of a client, and a database for storing user information in various forms. And a user information database that can be displayed on a WWW browser in a form that can be edited and processed.

[0002]

2. Description of the Related Art The use of personal computers and the Internet has been rapidly expanding, driven by a national IT promotion project. Public organizations and corporations have established websites for individuals as well as individuals, and are booming on the Internet as information dissemination sites.

[0003] However, since homepages in the WWW (World Wide Web) are described in the HTML language, it is undeniable that it is difficult for an amateur to create a homepage. Therefore, recently, support systems for creating various homepages and software for automatically creating homepages have been provided so that even amateurs can easily create homepages. As a known technique, for example,
No. 67038 discloses an apparatus for easily and efficiently creating a homepage.

Generally, as shown in FIG. 5, a client 1 (computer) of a user connected to the Internet 5 through a provider 3, a WWW server 7 of a site for supporting homepage creation, and screen data D1 of the user's homepage are displayed. A database server 11 (a server that manages the user information database 10 by software of a database management system (DBMS)) having a user information database 10 to be stored. The database server 11 is displayed on the WWW browser of the client 1 through the Internet 5. Through the homepage creation screen M on the web page of the WWW server, the user can obtain user information U1, U2, etc. for creating a homepage (company name, company profile, employment information, address, telephone number, map, image, mail address, etc. ) To create a home page 2 for the user, a step of requesting the WWW server 7 to register a home page, a step in which the WWW server 7 assigns a URL to the user and registers it in the URL file 8, and a transmission. Storing the screen data D1 of the user's homepage in the user information database 10; and a URL (for example, http: //www.a1) browsed in response to the homepage browsing request.
s. co. jp / 0125 /) is searched from the URL file 8, and the homepage data of the URL is searched from the user information database 10 using the search key (0125 in the URL example) in the URL, and the HTM
The step of displaying the document as an L document on the client WWW browser is executed.

At this time, a home page 2 created by the user
Screen data D1 is not directly stored in the user information database 10 of the database server 11 from the WWW server 7, but a security check (check for abnormal data such as computer virus, character size, data amount, etc.) is a commercially available check It is executed by software (step S1), and if it passes to a certain extent, the URL (uniform resource locator) of the client is registered in the URL file 8 and temporarily stored in the intermediate file (sequential file; SQF) 9 from the beginning. Is stored. Thereafter, the data of the user information stored in the intermediate file 9 is carefully checked by hand (step S2). This is to check the contents, such as whether a computer virus or forbidden adult data that was overlooked by commercially available software is included. Since the data check operation (step S2) requires a considerable time of one to two weeks, it takes one month or more until the URL is finally stored in the user information database 10 and the URL is issued to the user. Is the current situation.

[0006] In this regard, since the user information database 10 must be strictly prevented from being invaded from the outside and destroyed, it is unavoidable that the strict check for security requires time. And Internet stakeholders, including database administrators.

By the way, the screen data D1 of the homepage 2 created by the user in the above-mentioned conventional homepage automatic creation support system or method is treated as one data as a whole. That is, when the screen data D1 of the homepage 2 stored in the user information database 10 is displayed on a WWW browser on the screen, the client is searched by the index html or the map html and requests to browse the entire homepage data of the user as it is. Is displayed on a WWW browser.

[0008]

However, in the conventional homepage automatic creation support system or the homepage automatic creation display method, the conventional homepage automatic creation support system or the homepage automatic creation display method requires that the screen data D1 of the homepage 2 be stored in the user information database 10 and the URL be issued to the user. Data check (Step S
There was a disadvantage that the time and effort of 2) was too much.

Further, the screen data D1 of the homepage 2 created by the user is checked after the data check, and the WWW server 7
Is stored as one piece of data in the user information database 10 under the management of the user, and when there is a browsing request, the UR of the browsing request stored in the user information database 10 is simply stored.
The entire screen data D1 of the homepage 2 corresponding to L is retrieved and displayed as it is on the client WWW browser. Therefore, since the screen data D1 of the homepage once created is treated as one data, after the homepage is created and registered, the user enters items (name, name,
Even if it is desired to change the layout of addresses, telephone numbers, maps, photos, etc.), it is difficult to re-create the homepage and re-register it. Further, it is impossible to select display items such as selectively calling some of the user information items stored in the user information database 10 as the screen data D1 of the homepage 2 and displaying a simple homepage on the WWW browser. There was a disadvantage that the screen configuration of the homepage lacked flexibility. The screen of the homepage is determined as one screen when pulled out from the user information database 10, and is metaphorically a picture-story show.

By the way, the user information U1, U2,... Of many users stored as the screen data D1 in the conventional user information database 10 is used only for displaying the home page 2 on the WWW browser. Absent. In this regard, in the form of the conventional user information database 10 composed of a set of screen data D1 of the homepage 2 composed of a set of user information input by the user for creating the homepage, the user information U1, U2,. , Name, business type, etc.) cannot be edited and processed, so that the stored user information has a low utility value, and no use other than displaying a home page on the WWW browser of the user information database 10 is assumed at all. .

If it is possible to edit and process, for example, a list by extracting only necessary items that the user wants to collect freely from the user information database 10 in which user information of a large number of users is stored, if only a home page display is to be performed, In addition, a database with high utility value that can be used for various purposes could be constructed with support for creating homepages.

The present invention has been made in view of the above circumstances, and provides a method of automatically creating and displaying a home page, which makes it possible to easily create and register a home page and to freely display the layout on a WWW browser. It is another object of the present invention to provide a user information database that makes it possible to utilize the form of user information stored in the user information database for purposes other than displaying a home page on a WWW browser when creating a home page.

[0013]

SUMMARY OF THE INVENTION In order to solve the above problems, the present invention provides: (1) a client connected to the Internet,
A W server and a database server having a user information database for storing home page data, wherein a user creates a home page through a home page creation screen on a WWW server Web page displayed on the WWW browser of the client through the Internet. Creating a home page of the user by inputting the user information of the WWW server; requesting the WWW server to register the home page;
Assigning an RL to the user and registering the URL in a URL file; storing the transmitted data of the user's home page in a user information database of the database; Search from file and U
Searching for the data of the home page of the URL from the user information database using the search key in the RL and displaying the data on the WWW browser of the client, wherein the user information database is a relational database. The storage of the data of the home page is configured as a random file in which each column item in one row corresponding to the URL is treated as separate data, and the URL to be viewed is used as a search key from the URL file in response to the home page browsing request. And then retrieves the row of the URL stored in the user information database, and then extracts the individual data of each column of the user information requested to be browsed, performs HTML conversion, and converts each data into a home page on the WWW browser. Screen location To provide the home page automatically creates display method, characterized in that the display. (2) In particular, in the homepage automatic creation and display method according to the above (1), in response to a homepage registration request from a user's client, the WWW server passes a security check program and automatically issues a URL, and immediately after the user's homepage registration request, Characterized in that user information for creating a home page input by the user is sequentially passed through a plurality of databases of 3 to 7 units, subjected to different data processing, and stored directly in each user information database. provide. (3) A user information database created by the homepage automatic creation and display method described in (1) or (2) above, wherein individual items in each column stored in each row corresponding to the URL of each user. Is provided as a search candidate key.

[0014]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A method for automatically creating and displaying a home page and a user information database according to the present invention will be described in detail with reference to the drawings.

FIG. 1 is a diagram showing an overall system configuration for performing a method for automatically creating and displaying home pages on the Internet according to the present invention. FIG. 2 is a diagram illustrating a procedure for storing user information constituting screen data of a homepage in a user information database according to the present invention. FIG. 3 is a diagram illustrating a procedure for displaying a homepage screen on a WWW browser in response to a homepage browsing request from a client. Figure 4 is a homepage creation screen (template)
It is a figure showing the example of.

First, as shown in FIG. 1, the configuration of the system for realizing the method for automatically creating and displaying a home page according to the present invention is the same as that of the conventional support system shown in FIG. Are the same except that the internal configuration is different.

That is, the client 1 connected to the Internet 5 and the WW of a site that supports the creation of a home page
A W server 17 and a database server 21 having user information databases 20A to 20E storing user information U1, U2,... Of respective items constituting screen data of a home page.
The W displayed on the W browser through the Internet
Homepage creation screen M on Web page of WW server
(See FIG. 4), the user inputs user information U1, U2,... For creating a home page, creates a home page 2 for the user, then requests the WWW server 17 to register the home page, FIG.
As shown in the above, the WWW server 17 creates a new search key K (for example, 0125 = 0124 + 1) unique to the user from the search key table 13 and makes a URL (for example, http: //www.@.co.jp/). 0125
/) To the user and registering it in the URL file 8;
The user information U1, U2,... Constituting the user information databases 20A to 20E of the database server 21 are
Sequentially processing and storing the data in the U.S.A .;
The RL is searched from the URL file 8 and the user information of the home page 2 of the URL is searched from the user information database 20A or another user information database 20B by the search key K in the URL, and is displayed on the WWW browser of the client 1. Steps to display;
I do.

In particular, the user information databases 20A-
20E is a relational database 20 in the form of a table as shown in FIG. 2, and stores each item U1, U2,.
The items U1, U2,... Of the individual columns in one row corresponding to the user information of L are configured as random files that can be handled as separate data, and as shown in FIG. URL to be viewed (for example, http: //www.@.co.j
p / 0125 /) from URL file 8 as search key K
(K = 0125) (P2), and then search for the row of the URL stored in the user information database 20 (P3). Then, individual items U1 of each column of the user information requested to be browsed are searched. (Company name), U2 (Address), U3 (Phone number),... Are extracted and converted into HTML, respectively, and displayed at the designated location on the homepage 2 screen on the client WWW browser, for example. WWW server 1
7 incorporates a CGI (common gateway interface) program.

In other words, the data of the individual items U1, U2,... Fetched by the search key are displayed on the client's WWW browser by being fitted to the screen of the homepage 2, and the substance of the homepage is the user information. It does not exist in the database 20. The user information relating to the home page input by the user is individually retrieved from the user information database 20, and each of the HTs is retrieved.
A single home page screen is formed as a whole by being called in the ML format at the designated display location of the home page screen on the client WWW browser. In other words,
Conventional index. html, map. There is no such thing as html, and necessary user information is retrieved from a database and inserted into a homepage screen on a WWW browser to make a homepage. Therefore, the user can freely enter each item U1, U2,... In an arbitrary designated place in his home page on the WWW browser. In other words, it is possible to freely determine which item is displayed and where. In the structure of the database, all user information items are used as keys, and sorting is performed using the company name as a parent when storing the database.

In the WWW server 17, a folder containing a search key K for designating a destination (link) of the user information database 20 is created.

Next, in the case of the WWW server 17 shown in FIG. 1, in particular, the user information security-checked by the commercially available software in step S1 sequentially passes through the five database servers 19A to 19E so that a plurality of different data processes ( A method of summing data while compressing, AND conditions, OR conditions, and their inverse conditions, further converting to binary, compressing, and directly sorting and storing the results in the user information databases 20A to 20E. Has been adopted. As described above, by processing various data in a plurality of databases and storing the same user information data, even if a computer virus enters the first database 20A and the data is destroyed, the next server 19B starts up. Database security is ensured. Since the security of the database is ensured in this manner, the data is temporarily stored in the intermediate file 9 and manually checked by security (step S
It is not necessary to perform 2), and the URL is quickly issued to the user.

As can be seen from the above-described embodiment, according to the method for automatically creating and displaying a home page of the present invention, even a user who does not know the HTML language can create and register a home page very easily and quickly. The layout of each item on the homepage and the selection of the item can be freely changed at any time.

In the homepage automatic registration system to which the homepage automatic creation display method of the present invention is applied, for example, sites of chambers of commerce and commerce are assumed as a WWW server for automatically creating the homepage. A company, corporation, individual store, etc. in that area accesses the homepage of the Chamber of Commerce and Industry, opens the homepage automatic creation registration screen (see FIG. 4), and enters user information to create and register its own homepage. By doing so, the WW of Chamber of Commerce
The W server collects a large amount of information on commercial and industrial companies in the area and stores it in the user information database. This is not only for displaying the registered user's homepage on the WWW browser, but also for the user information database having a random file. Because of the configuration, it is possible to grasp the industrial form of the area from various viewpoints based on the user information database.

For example, an address list of a clothing store in XX town,
△ Selective information searched by various search means from a user information database such as a telephone number list of restaurants in the city, used car dealer information in the area, and gourmet information is appropriately WW.
It is possible to list them on the W browser.

Further, if similar user information databases constructed on WWW servers of various chambers of commerce are combined, a wide range of useful various databases can be freely extracted from the user information database and constructed. This makes it possible to utilize the user information database.

[0026]

The homepage automatic creation and display method and the user information database according to the present invention are configured as described above and have the following effects.

(1) There is an excellent effect that the creation and registration of the homepage are performed quickly.

(2) The display location of each user information on the homepage screen can be freely set, and the display items can be freely selected and assembled, so that there is an excellent effect that a flexible homepage screen is realized.

(3) It is possible to search for various purposes from the user information database in which a large number of user information is stored, and there is an excellent effect that the user information database can be utilized.

[0030]

[Brief description of the drawings]

FIG. 1 is a diagram showing an overall system configuration for performing a method for automatically creating and displaying a home page on the Internet according to the present invention.

FIG. 2 is a diagram illustrating a procedure for storing user information constituting screen data of a homepage in a user information database according to the present invention.

FIG. 3 is a diagram illustrating a procedure for displaying a homepage screen on a WWW browser in response to a homepage browsing request from a client according to the present invention.

FIG. 4 is a diagram showing an example of a homepage creation screen (template) according to the present invention.

FIG. 5 is a diagram showing a configuration of a conventional homepage automatic creation support system.

[Description of Signs] 1 Client 3 Provider 5 Internet 7, 17 WWW Server 8 URL File 9 Intermediate File 10, 20, 20A-20E User Information Database 11, 21, 19A-19E Database Server 13 Search Key Table D1 Screen Data M Homepage Creation screen U1, U2 ... User information K Search key

Claims (3)

[Claims] 1. A WWW server, comprising: a client connected to the Internet; a WWW server; and a database server having a user information database for storing homepage data, the WWW server displaying the WWW server on the client's WWW browser through the Internet.
a step of creating user's homepage by inputting user information for creating a homepage through a homepage creation screen on an web page; a step of requesting the WWW server to register a homepage;
A step in which a server assigns a URL to the user and registers the URL in a URL file; a step of storing the transmitted data of the user's homepage in the user information database; Search from file and URL
Searching the data of the homepage of the URL from the user information database by the search key in the user information database and displaying the data on the WWW browser of the client, wherein the user information database is a relational database;
The homepage data is stored in a random file configuration in which each column item in one row corresponding to the URL is treated as separate data. In response to a homepage browsing request, the URL to be browsed is retrieved from the URL file using a search key. A search is performed, then a row of the URL stored in the user information database is searched, and then individual data of each column of the user information requested to be browsed is extracted and HTML-converted, and a home page screen on a WWW browser is obtained. A method for automatically creating and displaying a home page, which is displayed at a designated place. 2. The method according to claim 1, wherein the WWW server passes a security check program and automatically issues a URL in response to a homepage registration request from the user's client, and then immediately issues the URL. A method for automatically creating and displaying a home page, wherein input user information for creating a home page is sequentially passed through a plurality of database servers of three to seven and subjected to different data processing, and stored directly in each user information database. 3. A user information database created by the homepage automatic creation and display method according to claim 1 or 2, wherein each item of each column stored in each row corresponding to the URL of each user is stored. A user information database, which is used as a search candidate key.