JP2006024038A - Web data creation method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a web data creation method capable of complying with various requests such as easy creation and maintenance of a web page without any knowledge about an HTML, easy data display/search and the like on a web, and search using no database software. <P>SOLUTION: In this Web data creation method constructed of a client 1 connected to the Internet 5, a WWW server 7, and a database server 4 having a user information database 10 storing home page data, a user inputs data information U1-U4 to the Web page 2 of the WWW server 7 displayed on a WWW browser of the client 1 via the Internet 5 for creating Web data of the user. By means of an automatic transformation program 11 automatically generating an HTML file according to the type of the data inputted onto the WWW browser, a database based on the HTML file searchable for data on the WWW browser from the inputted data is created. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a method for easily creating / registering a user's web page on the Internet and displaying / searching a client's web page on a WWW browser, or a method for creating web data that can be easily maintained. It is.

  With the recent spread of personal computers (hereinafter abbreviated as personal computers), the number of companies, store managers, and the like that post their own web pages (homepages) on the Internet has increased. Individuals as well as public organizations and corporations have set up homepages, and the Internet has become popular as an information transmission and collection site for work and hobbies.

  However, in order to create a web page on the WWW (World Wide Web), it is necessary to understand the Hyper Text Markup Language (HTML) grammar. It was difficult. Therefore, in creating a web page, a creation method having a function of “What You See What You Get (WYSIWYG)” is desired in the same way as using a word processor. Widget Wig means, literally, "what you see is what you can get", and in a word processor, what you see on the display screen can be output as it is with a printer, etc. Insert.

  In addition, when created with a conventional offline editor tool, an empty space linked with a web server on the Internet is provided to upload its own home page, and its own web is transmitted through a file transfer protocol (FTP). There was an inconvenience that the page had to be transmitted by FTP command. In particular, in the case of an offline editor, if an existing web page is to be modified, the modification is made through the editor every time, and the file is transmitted to the Internet web server with its own login ID using FTP. Must. For this reason, even if it is a web page that it has, it has been difficult to maintain.

Furthermore, in order to construct a search method on the web, database software such as MySQL or PostgreSQL has been conventionally used. However, expert knowledge is necessary to use these software, and it is a threshold for the general public. It was expensive and difficult to create. Among them, as disclosed in Patent Document 1, there is a method in which a plurality of users can efficiently create a web page together. It hasn't come out, and it hasn't come to a tool that can be easily created.
JP 2004-126761 A

  As described above, the problem is whether web pages can be created and maintained relatively easily even if you do not have much knowledge of HTML language and grammar, or can you create a mechanism that can easily display and search data on the web? Another object of the present invention is to provide a web data (homepage) creation method capable of meeting various requests such as whether a search method that does not use database software is possible.

The method of claim 1 comprises a client 1 connected to the Internet 5, a WWW server 7, and a database server 4 having a user information database 10 for storing homepage data. In the web data creation method in which the user inputs data information U1 to U4 to the web page 2 of the displayed WWW server 7 to create the user's web data,
Creating an HTML file database that can be searched for data on the WWW browser from the data input by the user by the automatic conversion program 11 that automatically generates an HTML file according to the type of data input on the WWW browser. It is characterized by.

  The method of claim 2 is the web data creation method according to claim 1, wherein the automatic conversion program 11 uses data binding, and data management is performed in a database by access 2000. .

  According to a third aspect of the present invention, in the web data creation method according to the first aspect, the automatic conversion program registers means for programming the manual part of data binding, and the data part that does not vary greatly is registered by template creation. The data portion that frequently changes includes a means for executing search logic that functions so as to be registered in the related information registration.

  The method according to claim 4 is the web data creation method according to any one of claims 1 to 3, wherein the automatic conversion program 7 creates a template based on the designated data information U1 to U4, Thereafter, an HTML file is automatically generated based on the latest information of classification registered in the database in accordance with a search command selected by the user.

  The method according to claim 5 is the web data creation method according to any one of claims 1 to 4, wherein the input data uses one or more data to be input, It is specified in the order of relation.

  The program mechanism according to the present invention uses “data binding”, which is a function supported after Internet Explorer 4.0. A JavaScript program (Java is a registered trademark) creates an HTML file in accordance with data binding, and allows the prepared data to be browsed and searched with a browser such as Internet Explorer.

  The program of the present invention automatically performs all the conventional work of creating an HTML file by describing HTML based on data binding by itself, and creates an HTML file. It is programmed so that the maximum set database can be created in HTML, and the required HTML is selected according to the selected items and conditions to create an HTML file, and the consistency of HTML Are checked and output as an HTML file.

  Even without any knowledge about HTML, it is possible to create an HTML file that can be searched for data on a browser. Conventional web page creation software (homepage builder, etc.) was able to create an HTML file by inputting text, inserting an EXCEL table or a photo, without writing HTML directly. This is a big merit because only texts, tables, photos, etc. are displayed as they are, and the data could not be displayed on the screen so as to be searchable.

  In order to newly update the HTML file, the HTML must be directly rewritten, and this rewriting work is very troublesome. In particular, when HTML is created using data binding, correction associated with updating is very time-consuming and prone to mistakes. When updating, the program of the present invention does not correct necessary parts but inputs according to the program according to the same procedure as the first, so errors other than input mistakes occur in the HTML file. It can be updated easily.

  Hereinafter, the web data creation method according to the present invention will be described. First, the configuration of a system for realizing the web data creation method will be briefly described. As shown in FIG. 10, the client 1 (personal computer) of the user connected to the Internet 5 through the provider 3, the WWW server 7 of the site that supports the creation of the web page (homepage), and the screen data D1 of the user's homepage are stored. A server that manages the user information database 10 with software of a database server 4 (database management system: DBMS) including the user information database 10. ) And are prepared. User information U1 to U4 (title, personal name, web page outline, table of contents, image) for the user to create a home page through the home page creation screen M on the web page of the WWW server 7 displayed on the WWW browser of the client 1 , An address, a telephone number, a map, an e-mail address, etc.) are entered to create a user home page 2.

  In FIG. 10, 8 is a URL file for the WWW server 7 to register by giving a URL (uniform resource locator) to the user, and 9 is an intermediate file (temporarily storing the registered URL from the beginning). Sequential file (SQF). S1 is a security check before the screen data D1 of the home page 2 created by the user is stored in the user information database 10 of the database server 4 from the WWW server 7 (abnormal data check such as computer virus, character size, data amount, etc.) ) Is a first step for executing commercially available check software or the like, and S2 is a second step for performing a data check of user information stored in the intermediate file 9 by manual work. In this system, an automatic conversion program 11 installed in the main body 1H of the personal computer 1 is used to automatically generate an HTML file according to the type of data input on the WWW browser. It is possible to create a database using an HTML file that can be searched for data.

  A specific example of the web data creation method according to the present invention using the personal computer system described above will be described. The purpose is: a. I want to create a search screen that runs on HTML simply by registering image files and search keywords, b. I want to register individual information such as product information in categories and narrow down from the categories, c. Even without knowledge of HTML, it would be desirable to automatically generate an HTML file from the latest information to facilitate maintenance.

As a work flow,
1. 1. Preparation of data 2. Registration of title Registration of parent-child relationship of classification Generate HTML template 5. 5. Register related information in HTML template This is the completion of an HTML format search screen. Next, each work process will be described.

  In “1. Data preparation”, up to 6 classifications and up to 4 supplementary information can be designated. For example, classification 1, classification 2, classification 3, classification 4, classification 5, classification 6, pretend kana, file, related image, description, and so on. Up to 50 items of data can be specified by extension setting, and each item can be associated with the basic setting item.

  In “2. Registration of title”, a title can be assigned to the classification, and the title of supplemental information can be changed. For example, title 1, title 2, title 3, title 4, title 5, title 6, pseudonym, file, related image, description, and so on. With the extended setting, it is possible to automatically set the first line of the imported data to multiple.

In “3. Registration of parent-child relationship of classification”, it is possible to give a relationship such as a large classification, a middle classification, and a small classification to the classification. The specific example is as follows.
[Example 1] When a photograph taken with a digital camera (digital camera) is related to "hot springs", it can be classified by region or prefecture. In the classification example shown in FIG. 1, when “Kinki” is selected, “Kyoto / Shiga / Hyogo”, which is a prefecture belonging to Kinki, is narrowed down. All that needs to be entered is registration of keywords such as “Kinki” and “Kyoto / Shiga / Hyogo”, and the HTML file is automatically generated. For example, relationship 1: category 1-category 2, relationship 2: category 2-category 3, and so on.

[Example 2] If you want to classify music CDs (Note: Up to two parent-child relationships can be specified), in the classification example shown in FIG. 3-Category 5 ".
In this case, it is free to attach a parent-child relationship, and the classification input screen is automatically switched according to the parent-child relationship. Also, depending on how you want to classify image files, you can specify titles, parent-child relationships, etc. as you wish. When there is no parent-child relationship, the classification input screen is independent of the classification 1 to classification 6 screen, and when there is a parent-child relationship, the input screen is dedicated to the parent-child relationship.

In “4. Generate HTML template”, a basic pattern of the HTML file is created based on the parent-child relationship between the title and the classification. First, what can be realized when creating a template is as follows.
The registered title is automatically reflected in the HTML file by the automatic conversion program 11 (see FIG. 10), so there is no need to be aware of the HTML tag.
-Of classification 1 to classification 6, only classification 1 to classification 3 can be used (designation of the number of items).
-It is possible to specify that a search condition is not created for a certain category among categories 1 to 6.
-It is possible to select not to display “pretend kana / file / related image / description” other than classification 1 to classification 6.
・ For keyword search, search method can be selected from “No specification / Equal / Fuzzy / Front match / Back match” for each category.
-The table format of the search screen can be selected (horizontal format (see FIG. 3) / vertical format (see FIG. 4)).
-Images can be registered in association with each other, but it is possible to select whether or not to attach a related image display button.
・ You can specify the number of data to be displayed on one page (how many data to make one page).
-Items can be rearranged (for example, specifying the image file before the file name).
-Data type (character type, numeric type, date type, floating point type) can be specified for each item.

  And what we want to realize in the future is as follows. In other words, the current focus is on managing image files, but it is possible to provide functions as file management software by making the link destinations correspond to various file formats such as “video / url / text / pdf”. desired. The data is sorted in the form specified by the file order or the classification order at the time of data creation (the form that arrives at the target data by keyword search and category search), and on the HTML screen, for example, “Fake Kana "I want to arrange them in order." By clicking the titles of classification 1 to classification 6, it is possible to sort each classification data in “ascending / descending order”.

  In “5. Register related information in HTML template”, the latest file / classification information is added to the basic pattern of the HTML file. If you are unfamiliar with HTML, it is difficult to change a web page without knowledge of tags, and even when creating a simple table, changing rows and columns while looking at tags is a cumbersome task. Even when using web page creation software (homepage builder 8 or the like), an Excel table can be inserted as it is into HTML, but it is a fixed table and data cannot be searched. On the other hand, if a technique called “data binding” that has become possible after Internet Explorer 4.0 is used, data is registered in a text file (or CSV file) in advance, and if it is changed, it is displayed on HTML. The contents can be changed dynamically. However, in order to use this technology, specialized knowledge and programming of JavaScript (Java is a registered trademark) are essential.

  In addition, consider the possibility of various changes to the web page. For example, when “Shikoku” or “Hokuriku” is added to “Region”, the “prefecture” belonging to it will be added as a matter of course. Become. Therefore, I think that it would be good to use a database, but it is not only for the general public, but also for “environmental / technical”, and deviates from the purpose of “no knowledge of HTML and easy maintenance”. There are difficulties in terms.

  Therefore, the data management itself is performed in the database created with Access2000 (taro.mdb), and the user's intended form is simply specified as “What to do with the category? What is the title? What is the data content?” First, create a “template”. After that, it is expected that there will be an image update or data change. Therefore, when “Register related information” is executed at the time of trying to change to the HTML format, JavaScript is based on the latest information of the registered classification. An HTML file is automatically generated by a program (Java is a registered trademark) (see FIG. 5).

  In “6. Completion of HTML format search screen”, keyword search, category search, number display, page break, table layout, etc. can be realized on the search screen. Here, it can be executed anywhere as long as it is an environment of IE 4.0 or higher and Java Script (Java is a registered trademark). The search screen in HTML format is created in the specified folder, and the linked image file is also copied to the image folder, so if you copy the contents of the folder to a CD-ROM, you can use it as an electronic catalog. There is no need to install dedicated software such as a general album, and since the data format is text-based, it is also possible to “spill out to other software / accept from other software” (Note: The number of items is 9 on the basic setting screen) Up to 50 can be input on the extended setting screen).

  In keyword search, a search method can be specified for each item when creating a template, and search is performed under search conditions according to the search method. If keywords are entered by separating them with double-byte blanks, such as “Hyogo iron containing”, data including “Hyogo” and “iron containing” can be extracted (division search).

  In the category search, when “Region” is selected, data for the region is narrowed down. Similarly, when any one of classification 1 to classification 6 is changed, data that matches the selected category is narrowed down. If a plurality of classifications are selected, data matching those is narrowed down (AND condition). If a parent-child relationship is set for the classification, selecting “Region” will narrow down the “Prefecture” and so on. Condition cancellation, such as canceling the minor classification if the major classification is canceled, is also automatically performed. The condition range setting “from to” is not currently supported, but will be supported in the future.

  In the number display, the number of data in all cases and the number of search results are always displayed. For example, if the search result is zero, “0” is displayed. In page breaks, the number of data to be displayed on one page can be specified at the time of creating a template, and the number of displayed items follows that. Page breaks are possible with the "Back" and "Forward" buttons. In the table layout, the table format of the search screen [horizontal format (see FIG. 3) / vertical format (see FIG. 4)] can be selected at the time of creating the template, and the display format follows that. The number of items to be displayed and the sorting of items are also in the format specified when creating the template. The template can be changed at any time according to the user's preference, but if only one pattern can be registered, it cannot be restored when it fails. In order to respond to such a request, it is now possible to register any number of templates with names (eg, “hot spring data 1”, “hot spring data 2”).

  I don't know much about databases or web pages, but this software is best suited to the desire to quickly create an HTML search screen from limited information. The above 1. Preparation of data-5. FIG. 6 shows a procedure flow that summarizes the workflow for registering related information in an HTML template.

  Here, the automatic conversion program 11 will be described. First, how data binding is automatically generated will be described. From the user's point of view, only the heading “Region, Prefecture” and data such as “Kinki, Hyogo” can be viewed on the browser, and “Kinki” registered by the user as “Region” data is in the form of a table. (See FIG. 11A). Therefore, one point is that a registration screen for each category of “Category 1 and Category 2” is provided from the beginning, a title is given to the category, and data is input. It seems that even users who are not familiar with the database can reasonably understand the idea that “the data I want to manage is divided by region and prefecture…”.

  As shown in FIGS. 11A and 11B, the user registers “Region, Prefecture” as the title, and these are actually input on the input screen of “Category 1, Category 2”. The data displayed in the “region” with the HTML tag does not cause a problem in the consistency from “bunrui1”. In FIG. 11C, “datafld =“ bunrui1 ”” means “data to be displayed here is from bunru1” in translation, but a “.html” file output when generating HTML from the program. In addition, there is a “.txt” file in which data is registered. The data of “bunrui1” is properly managed there as “Kinki”. Thus, in data binding, the relationship of “title → item name → data” is important. Strictly speaking, it is programmatically correct that “region” is chihou and “kikin” is the data chihou, but this time, the program is managed by bunru1 as the chihou part, and the user maintains it. This makes it possible to avoid problems.

  The reason why general users, that is, amateurs (including professionals) do not want to use data binding, is to decide “title”, decide “item name”, enter “data” that matches it, and check with browser However, it is troublesome to adjust the appearance while adjusting the width if the item does not fit. Moreover, even if there are other basic data that you want to use, such as a database, you have to create data that conforms to the rules for data binding, and you must hit the limit that you must display it correctly in a tabular format. In reality, there is a possibility that data images and HTML tag images may change frequently.

  However, if these problems are left to the program, there is no problem (in principle). This is because, even if the title is changed and the data of classification n corresponding to the title is changed, if you want to change the appearance greatly, you can recreate the “template” and “I want to make it HTML!” If the program is executed from the latest data at the time, a data image and an HTML tag image are created, and the data image and the HTML tag image are output in synchronism even if the classification increases or decreases or the text changes. This is because there is no contradiction. This is because even when the user's shape and the output result are different, it is only necessary to repeatedly execute “related information registration → HTML creation”. “Registered information” is a function for creating a search condition from information such as “Kinki” and “Hyogo”.

  The “template” itself is initially “<th> class 1 </ th> <th> class 2 </ th>”, and if a title is input, “<th> region </ th> > <Th> prefecture </ th> ”. For example, when “region” is changed to “region”, HTML is automatically converted to “<th> region </ th>” if a template is recreated. The basics are the same for classification data. From the beginning, “<td> datafld =” bunrui1 ”</ td>... <Td> datafld =“ bunrui6 ”</ td>” is registered, and types “1-6” are set for each classification. is there. When only classifications 1 and 2 are used, data of type “3-6” is deleted from the HTML file after the template is created. Users do not need to be aware of tag changes.

  When considered in a higher dimension, it seems that “even if there are about 10 classifications,” or “items such as pretend kana, explanation, etc. should be decided arbitrarily”. Certainly, the definition of a database table is quite different, and it is hard to say which is general purpose. However, this is the reason why it is difficult for amateurs. In this program (automatic conversion program), an “Extended Settings” screen is provided for professionals. There is an advantage that it can be set freely, such as whether to give it a name or an arbitrary name, what the attribute is, how many pixels the width is. Although this is a necessary function, it seems to be cruel to suddenly fill a large number (250) of blanks as you like. Therefore, even if you don't know anything, you can simply check the box if you want to "pretend to be a product name" or "add a description to an image", making it easy and quick.

  Based on the above, an automatic conversion program can be defined as a manual part of data binding that is programmed, but it also has the feature that it can execute the search logic described below. is doing. In other words, if search logic is involved, it will be difficult to program, and typical examples will be described below.

-Keyword search: Kinki = Kinki (exact match), Kin ... → Kinki (ambiguous) [Others: Forward match, backward match].
・ Split search: “Kinbei” → “Kinki Hyogo” (Keyword search separated by full-width blanks).
・ Condition search: Canceling narrowing by classification, canceling narrowing by keyword, canceling minor classification from major classification cancellation. Unsort when sorting.
・ Class Search: Narrow down the character selected for category n as a keyword. If multiple categories are selected, narrow down the AND conditions (eg “Kinki” and “Hyogo”).
Parent-child classification search: Up to two of classifications 1 to 6 can have a parent-child relationship. “Large → Medium → Small” is also possible. For example, if classifications 1 and 2 are separate, the provinces and prefectures are not linked, as in “1 Kinki, 1 Hyogo”. If you are a parent and child, it will be registered as “1 Kinki Hyogo, 2 Kinki Kyoto, 3 Kinki Shiga”, so if you select “Kinki” for the region, “Hyogo / Kyoto / Shiga” will be narrowed down to the prefecture. . The user only needs to be aware of the data. Which classification is in the parent-child relationship and how the options are switched is realized by generating a JavaScript program (Java is a registered trademark) from the data. Specifically, the contents of the options of the large classification are judged and the contents of the small classification are rewritten.

  Similar to the classification data, the search logic as described above is determined for each classification by selecting a type of “1-6” and re-editing when creating a “template” with a combination of “use / do not use”. ing. The search part of the classification and the parent-child classification is displayed in a combo box in the browser, but since it is necessary to always synchronize with the data, it is created at the time of executing “Register related information”. In other words, the part that is determined at the beginning and does not vary greatly is created as a “template”, and the part that frequently changes later is registered as “related information registration”. All you have to do is click a button, and if there is a problem, you only need to recreate the "template" or execute "Register Related Information". In this way, the automatic conversion program programs the manual part of data binding, registers the data part that does not fluctuate greatly by creating a template, and registers the data part that frequently changes by registering related information. It can be said that this is a means by which search logic that functions like this is executed.

  According to the database creation software of the present invention, it is possible to meet the demands of organizing photographs taken with a digital camera, creating a product catalog CD-ROM, placing a search screen on a web page, and the like. With the function of 11, it is possible to realize those desired items by a simple operation by the following steps 1 to 3.

  In step 1, as shown in FIG. 7, an image file and a search keyword are prepared. At this time, it is also possible to import data from an external file. You can easily enter data without knowledge of the database. A search screen can be created simply by registering an image file and a keyword for search, and it is possible to respond to the request of “I want to organize photos taken with a digital camera”.

  In step 2, as shown in FIG. 8, the food is classified into food (major category) 大 fruit (minor category) ⇔product information. Since individual information such as product information can be registered in categories, a large amount of data can be narrowed down easily. As a result, it is possible to meet the demand of “I want to make a CD-ROM for a product catalog”.

  In step 3, as shown in FIG. 9, a search screen is automatically created in the HTML format based on the registered information. At this time, programming is unnecessary. For example, keyword search, category search, rearrangement, number of cases display, page break, table layout, etc., can respond to the request of “I want to put a search screen on a web page”.

  The database creation software according to the present invention can be used for various purposes. For example, it can be used as a search page that can be used as a personal data management tool such as a music CD, used as a learning material, a simple dictionary, a product catalog, used as an album of image files such as travel photos, etc. It is. It is also possible to search from a personal computer or a CD-ROM by registering various information such as housing, medical care, and construction.

Block diagram showing an example of regional classification Block diagram showing an example of music classification Figure showing an example of a horizontal search screen Figure showing an example of a vertical search screen Diagram showing the automatically generated HTML file Flow chart showing operation procedure of database creation software Diagram showing image and keyword input screen Figure showing a screen with data sorted Diagram showing the automatically generated HTML file Configuration diagram of the entire system for executing the web data creation method Diagram showing browser, data, and tag images in automatic conversion program

Explanation of symbols

1 Client 2 Homepage (Web page)
3 Provider 4 Database Server 5 Internet 7 WWW Server 10 Database 11 Automatic Conversion Program U1-U4 User Information

Claims (5)

A client connected to the Internet, a WWW server, and a database server having a user information database for storing homepage data are prepared, and a user can access data information on a Web page of the WWW server displayed through the Internet on the client's WWW browser. Is a web data creation method for creating user web data by inputting
Web data for creating a database of HTML files that can be searched on the WWW browser from data input by a user by an automatic conversion program that automatically generates an HTML file according to the type of data input on the WWW browser How to make.   The web data creation method according to claim 1, wherein the automatic conversion program uses data binding, and data management is performed in a database by access 2000.   The automatic conversion program registers the manual part of data binding as a program, the data part that does not vary greatly is registered by creating a template, and the data part that frequently changes is registered by the related information registration. The web data creation method according to claim 1, further comprising: means for executing search logic that functions in a manner.   In the automatic conversion program, a template based on the specified input data is created, and then the HTML file is automatically generated based on the latest information of the classification registered in the database by a search command selected by the user. The web data creation method as described in any one of Claims 1-3 produced | generated. The web data creation method according to any one of claims 1 to 4, wherein the input data is specified in the order of a title and a parent-child relationship of classification using one or a plurality of data to be input.

Images