Mall server with product search capability

• US 6,125,353 A
• Filed: 08/25/1997
• Issued: 09/26/2000
• Est. Priority Date: 03/17/1997
• Status: Expired due to Term

• Current Assignee: Fujitsu Limited
• Original Assignee: Fujitsu Limited
• Inventors: Yagasaki, Isao
• Primary Examiner(s): Voeltz, Emanuel Todd
• Assistant Examiner(s): Dixon, Thomas A.
• Application Number:
  US08/917,202
• Time in Patent Office: 1,128 Days
• Field of Search: 705/26, 705/27, 707/104
• US Class Current: 705/26.62
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: G06Q 30/0625 Directed, with specific intent or strategy
• CPC Class Codes: G06Q 30/0641 Shopping interfaces
• CPC Class Codes: H04L 67/75 Indicating network or usage conditions on the user display
• CPC Class Codes: H04L 69/329 in the application layer [OSI layer 7]
• CPC Class Codes: H04L 9/40 Network security protocols
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

A mall server with a product search function, in which each product category has a particular effective period during which it is presented to customers as a selectable search key. In a virtual shopping mall system, customers can conduct a search for a set of products by designating a particular product category as a search key. As part of a mall server, a category master table stores a plurality of product categories accompanied by information on their respective effective periods, and a product master table stores information on various online products along with their respective category definitions. Based on the category master table, a product search screen generation unit produces product search screen data containing a set of categories whose effective periods include the present date. Receiving the product search screen data from the mall server, the customer terminal displays a product search screen including a category selection menu to provide the customer with a list of selectable categories. The customer issues a search request after selecting one category from the list. A product searching unit searches the product master table for the products that fall under the selected category. The customer terminal displays a product list screen upon receipt of the product list screen data from the mall server.

Claims

1. A mall server comprising:

a category master table indexing a plurality of categories, each category being accompanied by information on an effective period thereof;

a product master table cross-referencing products to categories, having at least two category columns for storing a first category code and a second category code so as to allow each product to have two different categories;

product search screen creation means, responsive to a search screen request from a customer terminal, for creating product search screen data including a category selection menu listing categories having effective periods which include a present date; and

product searching means, responsive to a search command from the customer terminal, for searching said product master table for the products belonging to a category selected from the list of the categories of the category selection menu.

2. The mall server according to claim 1, wherein the effective period of each category is defined by a starting date and an ending date.

3. The mall server according to claim 1, wherein said product search screen creation means creates the product search screen data as a structured document in a format readable by an Internet Browser.

4. The mall server according to claim 1, wherein said product searching means, in response to the search command, determines whether a particular store is specified, and, if no particular store is specified in a search condition, creates a per-store hit count screen data by counting the number of products that suit the search condition on an individual store basis.

5. A computer readable medium encoded with software causing a computer to perform the following actions:

maintaining a table of products offered for sale via an electronic store front including fields containing an indication of each product'"'"'s name and at least two categories of the product;

maintaining a table of categories including fields containing an indication of each category name and an effective period of time for which the category is to be available to shoppers; and

upon a request from a shopper for a list of available categories, forming the list by searching the table of categories to find categories having an effective period of time containing the date upon which the request was made.

6. A method of presenting products to customers in a virtual shopping mall comprising:

creating a table of products offered for sale via an electronic store front including fields containing an indication of each product'"'"'s name and at least two categories of the product;

creating a table of categories including fields containing an indication of each category name and an effective period of time for which the category is to be available to shoppers;

upon a request from a shopper for a list of available categories, forming the list by searching the table of categories to find categories having an effective period of time containing the date upon which the request was made;

displaying the list of categories to the customer;

upon the selection of a category, displaying the products from the table of products having the selected category.