WO2000023923A1 - Verfahren zur datenbankgestützten selektion von produkten für electronic-commerce-anwendungen im internet - Google Patents

Verfahren zur datenbankgestützten selektion von produkten für electronic-commerce-anwendungen im internet Download PDF

Info

Publication number
WO2000023923A1
WO2000023923A1 PCT/EP1999/007246 EP9907246W WO0023923A1 WO 2000023923 A1 WO2000023923 A1 WO 2000023923A1 EP 9907246 W EP9907246 W EP 9907246W WO 0023923 A1 WO0023923 A1 WO 0023923A1
Authority
WO
WIPO (PCT)
Prior art keywords
product
products
list
database
customer
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Ceased
Application number
PCT/EP1999/007246
Other languages
German (de)
English (en)
French (fr)
Inventor
Andreas Böhm
Wolfgang Oberndorfer
Jörg RAHMER
Stefan Uellner
Markus Haffner
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Deutsche Telekom AG
Original Assignee
Deutsche Telekom AG
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Deutsche Telekom AG filed Critical Deutsche Telekom AG
Priority to AT99948908T priority Critical patent/ATE230505T1/de
Priority to EP99948908A priority patent/EP1131752B1/de
Priority to US09/807,856 priority patent/US6658424B1/en
Priority to JP2000577596A priority patent/JP2002528796A/ja
Priority to DE59903935T priority patent/DE59903935D1/de
Publication of WO2000023923A1 publication Critical patent/WO2000023923A1/de
Anticipated expiration legal-status Critical
Ceased legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99941Database schema or data structure
    • Y10S707/99943Generating database or data structure, e.g. via user interface

Definitions

  • E-commerce refers to the use of the technical means of electronic data networks to promote the economic and sales processes of a company and new ones
  • Online shopping e.g. B. Advertising, product information, customer / seller interaction,
  • the DeutscheInstitut AG (DTAG) e-commerce system which is similar to the e-commerce systems of many other companies, is described in more detail below as a known solution.
  • Intershop is a fully equipped medium that enables smooth entry into the online market. Intershop technology goes beyond the typical limits of HTML pages and opens its own shopping center. Intershop is the world's first standardized software that makes it possible to design interactive, multimedia online shops. Intershop can be easily linked to existing ERP or accounting systems, operated as an autonomous system, or both.
  • the Intershop software programs are connected to the WWW server that offers the HTLM pages. Intershop has integrated a database that contains the product catalog data. On the server side, e-commerce is usually provided by three components.
  • the customer has the following options on the T-Versand homepage of DTAG:
  • the customer In the left menu bar, he has the option to switch to another category at any time. If the customer has selected the "Corded phones" link, the next step is to get the list of corded end devices as a result. The customer will therefore be taken to a product selection list after his third selection. This is an important principle that e-commerce shops always have In the product selection list you can now see a picture, the name, the price and a brief description of the selected phone. Once the customer has selected a phone, they can display the product data sheet, which shows the most important features the customer looks at the features and chooses the product, then the customer can:
  • the shopping cart fulfills the function of storing the products until the customer has finally decided to place his order.
  • the shopping cart offers the following functionalities:
  • the customer either wants to buy a product, find out about products and then buy them, or just find out about products.
  • a customer who wants to buy a product and already knows his goal and usually also the desired product that he wants to select can easily shop using the system described above.
  • the hesitant or information-seeking customers have a harder time. You have to change pages very often to find out about the differences in the products on offer. The reason for this is that products can only be compared directly using the values in the product data sheet.
  • the current system offers the presentation of the DTAG catalog on the Internet with complete sales processing, but there is still not enough support for the customer to find the right product for him. This is particularly due to the fact that the length of the product lists makes them suitable for a search.
  • the invention is based on the object of developing a method for customer-specific selection of products from a product catalog via the Internet, in which the complete range (product list) and the comprehensive product information are retained, and in which the above-mentioned. Defects are eliminated.
  • the invention is intended to offer the customer a better and faster way of comparing the products.
  • Known e-commerce applications are based on a database in which the products of the catalog to be represented are managed and maintained.
  • the medium Internet offers the possibility to present products from the databases much more effectively for the customer than is possible with the known e-commerce applications, in which the relevant information, e.g. the current price, is only available when a product is called up Database read and output.
  • the method according to the invention which is referred to below as product finder, is also based on a product catalog.
  • the difference to known e-commerce applications is based on the fact that there is no connection to a group of products, but rather that certain products are selected with the help of parameters previously defined by the customer during online access.
  • the product finder consists of static components that do not change or always run the same way and dynamic components that adapt to the parameters that were previously defined, for example, by an administrator of the product finder. These parameters ensure that the correct ones are found in the product finder interface
  • Components are set up so that the correct data are fetched from the database and that the further processing of the data also proceeds correctly with the interaction of the user.
  • Components of a universally applicable product finder are:
  • the first five components also have dynamic components.
  • the new Component parameter list is used by all other components to initialize the product finder.
  • Control button type control button label
  • Initial values of the operating button are important for the graphical user interface and for processing the data from their value range.
  • the comparison operator connects a value of the value set of the operating button with attributes of the internal data structure in order to compare them and to determine the valid objects.
  • the graphical user interface of the product finder consists of four components:
  • buttons - Button bar and - Groupings of operating buttons.
  • the method for database-supported selection of products for electronic commerce applications on the Internet is based on access to a database management system in which the user controls the product selection with the aid of operating buttons. As shown in FIG. 1, the process is composed of several process steps.
  • data is read from the database of the database management system after the system is started and into an internal data structure (product of Product Finders) converted.
  • a product list is formed from the instances of the product data structure.
  • a comparison function is used to check whether the objects in the product list are valid.
  • the valid objects are copied into a result list (list of valid objects).
  • the comparison function is triggered by calling up the product finder or by changing an operating button by the user. If the status of an operating button changes, the validity of the objects in the product list is checked using a comparison function compiled by the user / customer according to his or her wishes.
  • the comparison function consists of the selected values of the control buttons and the associated ones
  • Attribute values from an object of the product list and a comparison operator for each selected value of the control button are Attribute values from an object of the product list and a comparison operator for each selected value of the control button.
  • the valid objects determined using the comparison function are entered in a result list.
  • the result list is displayed to the user in a result list field.
  • the user can make his selection based on the objects from the result list field.
  • Data structure of the product finder are required can be dealt with by a static SQL statement and transferred to the product data structure.
  • an administrator In order to generate correct dynamic SQL statements, an administrator must first define the set of table names and the corresponding ones
  • the number of tables or attributes also determines the number of attributes of an object in the product list.
  • Fig. 2 shows how two dynamic and a static SQL statement are handled and how the respective attributes of the product list are filled.
  • An operating button is identified by the label field, the type of button and the set of values.
  • the label field specifies the text that shows the later user of the product finder which features he can set with the operating button.
  • the type specifies the type of control button, e.g. B. Checkbox or selection field.
  • the set of values is the amount of values that can be set in the operating button, which can be numbers, strings or even truth values. In order to set up the control button in the product finder, the administrator must specify the type and the label field.
  • the set of values for the operating buttons comes from attribute values from the product list. To get the correct attribute values of the product list, there is a projection on their respective objects in the product list.
  • the filling of the value set is always determined by the operating button and the associated values of an object in the product list.
  • the parameters that have already been defined (table name / attribute name of the administrator's database) also determine the origin of the set of values when extended by the type and label field of the operating buttons.
  • FIG. 3 shows an example in which two dynamic and one static attribute of all objects in the product list fill the set of values for operating buttons.
  • a result list is created from the product list. Three components are provided to fill the result list: - certain attributes of the product,
  • Figure 4 the process of interactive selection is illustrated using an example.
  • the system or the user sets the value W2 from the set of values in the operating button B2.
  • This value is linked with the help of the comparison operator 2 with the attribute Att. 2 of the product list and checked for validity. If this validity is given and all other validities are given, then exactly this object is copied into the result list. This also happens with all other objects in the product list. The values of all valid objects are now in the result list.
  • the result list field is displayed so that it is visible to the user.
  • the result list field is a projection from the result list, i.e. H. only certain attribute values of each object in the result list are transferred to the result list field. With most product finders, it makes sense to output the name and color of the product to the user.
  • the product finder runs on the server side and only input / results are transferred from / to the customer.
  • the second possibility is that the product finder is transferred as a program to the customer's computer or browser.
  • the first alternative can be solved with the help of CGI programming.
  • An HTML form is sent to the customer by a server.
  • the customer makes his or her entries in the selection settings form.
  • a "Submit” button sends the results of the selection to a server-side CGI script. This would send the Use settings to select the right products from a database in the database management system and the result would be sent back to the customer as an HTLM form.
  • An advantage of this method is that the form is very small and can be sent to the customer quickly. Another advantage results from the fact that a database query on a powerful server runs very quickly.
  • the transmission of the result in the form of an HTML page is also not time-critical.
  • a disadvantage of this method is seen in the fact that the customer would have to press the "Submit” button with every variation of his selection settings and would therefore have to establish a server connection again and again. Such a server connection delays the provision of the desired result to the customer.
  • the first implementation option is based on a script running on the client, such as. B. Java Script or Visual Basic Script.
  • the second way to implement the product finder on the client side is based on programs that are integrated in the HTML pages to be transferred.
  • Such programs are e.g. B. Java applets or ActiveX components.
  • An advantage of this variant is that immediate interactivity with the customer is possible. This means that the customer can make selections that are processed immediately and in which the result is available to the customer without delay.
  • the method according to the invention can advantageously be used in e-commerce applications on the Internet, since it makes it easier for the customer to find the product.

Landscapes

  • Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Strategic Management (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Development Economics (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Information Transfer Between Computers (AREA)
PCT/EP1999/007246 1998-10-19 1999-09-30 Verfahren zur datenbankgestützten selektion von produkten für electronic-commerce-anwendungen im internet Ceased WO2000023923A1 (de)

Priority Applications (5)

Application Number Priority Date Filing Date Title
AT99948908T ATE230505T1 (de) 1998-10-19 1999-09-30 Verfahren zur datenbankgestützten selektion von produkten für electronic-commerce-anwendungen im internet
EP99948908A EP1131752B1 (de) 1998-10-19 1999-09-30 Verfahren zur datenbankgestützten selektion von produkten für electronic-commerce-anwendungen im internet
US09/807,856 US6658424B1 (en) 1998-10-19 1999-09-30 Method for the database-supported selection of products for electronic-commerce applications on the internet
JP2000577596A JP2002528796A (ja) 1998-10-19 1999-09-30 インターネットにおける電子商取引用途の製品のデータベースサポートされた選択プロセス
DE59903935T DE59903935D1 (de) 1998-10-19 1999-09-30 Verfahren zur datenbankgestützten selektion von produkten für electronic-commerce-anwendungen im internet

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
DE19849354A DE19849354A1 (de) 1998-10-19 1998-10-19 Verfahren zur datenbankgestützten Selektion von Produkten für Electronic-Commerce-Anwendungen im Internet
DE19849354.1 1998-10-19

Publications (1)

Publication Number Publication Date
WO2000023923A1 true WO2000023923A1 (de) 2000-04-27

Family

ID=7885701

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/EP1999/007246 Ceased WO2000023923A1 (de) 1998-10-19 1999-09-30 Verfahren zur datenbankgestützten selektion von produkten für electronic-commerce-anwendungen im internet

Country Status (7)

Country Link
US (1) US6658424B1 (enExample)
EP (1) EP1131752B1 (enExample)
JP (1) JP2002528796A (enExample)
AT (1) ATE230505T1 (enExample)
DE (2) DE19849354A1 (enExample)
ES (1) ES2189495T3 (enExample)
WO (1) WO2000023923A1 (enExample)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20010081131A (ko) * 2001-08-02 2001-08-29 성보현 인터넷을 이용한 다중채널 아이템 평가시스템 및 그시스템 운영방법
KR20010106708A (ko) * 2000-05-23 2001-12-07 김치국 판매 제품에 대한 현지 평가에 기초한 전자 상거래 방법
KR20020006171A (ko) * 2000-07-11 2002-01-19 윤중환 구매의사결정기능을 제공하는 전자상거래시스템 및 방법
KR20020006833A (ko) * 2000-07-13 2002-01-26 김진국 인터넷상의 전자부품경매를 이용한 전자상거래시스템 및그 방법
JP2002117193A (ja) * 2000-10-11 2002-04-19 Yokogawa Electric Corp 情報提供システム
WO2004086252A1 (en) * 2003-03-27 2004-10-07 British Telecommunications Public Limited Company Data retrieval system

Families Citing this family (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
DE19951757A1 (de) * 1999-10-27 2001-05-10 Intershop Software Entwicklung Verfahren zur Kennzeichnung von Geschäftsobjekten für den elektronischen Geschäftsverkehr
DE10031006A1 (de) * 2000-06-30 2002-01-17 Bingooo Ag Verfahren zum Suchen und Wiedergeben von Informationen
US7272618B1 (en) * 2002-01-30 2007-09-18 Emerson Power Transmission Manufacturing Lp Method and apparatus for automated information retrieval and component ordering
US20060045523A1 (en) * 2004-08-31 2006-03-02 Kozischek David R Online system for designing a fiber optic network and associated methods
US7457772B2 (en) * 2006-01-06 2008-11-25 Tabin Joshua Z Method and apparatus for interactive criteria-based commodity comparisons
US20080016441A1 (en) * 2006-01-06 2008-01-17 Tabin Joshua Z Method and Apparatus to Facilitate Altering a Presentation Order for Search Results
US8554639B2 (en) 2006-07-07 2013-10-08 Joseph R. Dollens Method and system for managing and displaying product images
US8260689B2 (en) 2006-07-07 2012-09-04 Dollens Joseph R Method and system for managing and displaying product images
US11481834B2 (en) 2006-07-07 2022-10-25 Joseph R. Dollens Method and system for managing and displaying product images with progressive resolution display with artificial realities
US10614513B2 (en) 2006-07-07 2020-04-07 Joseph R. Dollens Method and system for managing and displaying product images with progressive resolution display
US12373883B2 (en) 2006-07-07 2025-07-29 Joseph R. Dollens Method and system for managing and displaying images with progressive resolution display throughout artificial realities
US11049175B2 (en) 2006-07-07 2021-06-29 Joseph R. Dollens Method and system for managing and displaying product images with progressive resolution display with audio commands and responses
US9691098B2 (en) 2006-07-07 2017-06-27 Joseph R. Dollens Method and system for managing and displaying product images with cloud computing
WO2009155375A2 (en) * 2008-06-19 2009-12-23 Wize, Inc. System and method for aggregating and summarizing product/topic sentiment

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP0807891A1 (en) * 1996-01-11 1997-11-19 Sun Microsystems, Inc. Stateless shopping cart for the web
US5737592A (en) * 1995-06-19 1998-04-07 International Business Machines Corporation Accessing a relational database over the Internet using macro language files
EP0855687A2 (en) * 1997-01-15 1998-07-29 AT&T Corp. System and method for distributed content electronic commerce
WO1998057277A1 (en) * 1997-06-11 1998-12-17 Scientific-Atlanta, Inc. System, method, and media for intelligent selection of searching terms in a keyboardless entry environment

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6247129B1 (en) * 1997-03-12 2001-06-12 Visa International Service Association Secure electronic commerce employing integrated circuit cards
DE19724479B4 (de) * 1997-06-10 2006-12-14 BSH Bosch und Siemens Hausgeräte GmbH Programmablaufanzeige an einem Haushaltsgerät
US5960411A (en) * 1997-09-12 1999-09-28 Amazon.Com, Inc. Method and system for placing a purchase order via a communications network
US6175823B1 (en) * 1998-09-15 2001-01-16 Amazon.Com, Inc. Electronic gift certificate system
US6397212B1 (en) * 1999-03-04 2002-05-28 Peter Biffar Self-learning and self-personalizing knowledge search engine that delivers holistic results

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5737592A (en) * 1995-06-19 1998-04-07 International Business Machines Corporation Accessing a relational database over the Internet using macro language files
EP0807891A1 (en) * 1996-01-11 1997-11-19 Sun Microsystems, Inc. Stateless shopping cart for the web
EP0855687A2 (en) * 1997-01-15 1998-07-29 AT&T Corp. System and method for distributed content electronic commerce
WO1998057277A1 (en) * 1997-06-11 1998-12-17 Scientific-Atlanta, Inc. System, method, and media for intelligent selection of searching terms in a keyboardless entry environment

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
"INTERNET ACCESS TO DATABASES WITH USER-DEFINED FIELDS", IBM TECHNICAL DISCLOSURE BULLETIN,US,IBM CORP. NEW YORK, vol. 40, no. 10, 1 October 1997 (1997-10-01), pages 133 - 134, XP000739452, ISSN: 0018-8689 *

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR20010106708A (ko) * 2000-05-23 2001-12-07 김치국 판매 제품에 대한 현지 평가에 기초한 전자 상거래 방법
KR20020006171A (ko) * 2000-07-11 2002-01-19 윤중환 구매의사결정기능을 제공하는 전자상거래시스템 및 방법
KR20020006833A (ko) * 2000-07-13 2002-01-26 김진국 인터넷상의 전자부품경매를 이용한 전자상거래시스템 및그 방법
JP2002117193A (ja) * 2000-10-11 2002-04-19 Yokogawa Electric Corp 情報提供システム
KR20010081131A (ko) * 2001-08-02 2001-08-29 성보현 인터넷을 이용한 다중채널 아이템 평가시스템 및 그시스템 운영방법
WO2004086252A1 (en) * 2003-03-27 2004-10-07 British Telecommunications Public Limited Company Data retrieval system

Also Published As

Publication number Publication date
EP1131752A1 (de) 2001-09-12
US6658424B1 (en) 2003-12-02
ATE230505T1 (de) 2003-01-15
DE19849354A1 (de) 2000-04-20
DE59903935D1 (de) 2003-02-06
JP2002528796A (ja) 2002-09-03
EP1131752B1 (de) 2003-01-02
ES2189495T3 (es) 2003-07-01

Similar Documents

Publication Publication Date Title
EP1131752B1 (de) Verfahren zur datenbankgestützten selektion von produkten für electronic-commerce-anwendungen im internet
DE69729926T2 (de) Netzwerkbrowser
DE60306186T2 (de) Verfahren und system zur anordnung von dienste in einer webdienstarchitektur
DE69527926T2 (de) Ein mit Rechner durchgeführtes Verfahren und System zur Informationswiederauffindung
DE60128676T2 (de) Verfahren und system zur automatisierung von internettransaktionen mittels gespeicherter daten
DE69527120T2 (de) Elektronisches Verfahren und System zum Suchen von Bezugsquellen
DE10252815B4 (de) Datenbanksuchsystem und Verfahren für ein Datenbanksuchsystem mit Zahlung für Platzierung von Suchlisten
DE60016772T2 (de) Verfahren und system für die publikation und revision von hierarchisch organisierten sätzen von statischen intranet- und internet-seiten
DE69724356T2 (de) Verfahren und Apparat für die Darstellung von Information im Bezug auf jeden einzelnen von mehreren Hyperlinks
DE69511425T2 (de) Herstellungshilfe für online-dienste mit gebührenfeststellung
DE10196670B3 (de) System und Verfahren zur Migration von Daten in einem elektronischen Handelssystem
DE10320615A1 (de) Verwendung erweiterbarer Markup-Sprache in einem System und Verfahren zum Beeinflussen einer Position auf einer Suchergebnisliste, die von einer Computernetzwerksuchmaschine erzeugt wird
DE10252805A1 (de) System und Verfahren, das einem Werber ermöglicht, Sucheinträge in einem Suchsystem mit Bezahlung für Position unter Verwendung von Gruppierung zu verwalten
DE112006002886T5 (de) System und Verfahren zum Speichern von Postenattributen in einem elektronischen Katalog
DE10144707A1 (de) Verfahren und System zum dynamischen Erzeugen von Web-Formularen in einer Vielzahl von Sprachen
EP1241603A1 (de) Internet-Banner
EP1620810A2 (de) Verfahren und anordnung zur einrichtung und aktualisierung einer benutzeroberfl che zum zugriff auf informationsseiten in ein em datennetz
EP1484696B1 (de) Verfahren zum Optimieren eines auf eine Netzwerkseite verweisenden Verweises
WO2002023415A2 (de) Verfahren zum vertreiben von bildern über ein netzwerk
DE69809319T2 (de) Elektronisches Transaktionsverarbeitungssystem
WO2005091184A1 (de) Informationssystem
DE102004008493B4 (de) Internetgestütztes Informationssystem
EP1043667A2 (de) Online Service zur effizienten Kontaktaufnahme zwischen Käufern und Anbietern chemischer Produkte
DE10123773A1 (de) Verfahren zur Suche nach Inhalten eines Rechnernetzwerks
EP1170676A1 (de) Darstellung einer Informationsstruktur von Dokumenten des Word Wide Web

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A1

Designated state(s): JP US

AL Designated countries for regional patents

Kind code of ref document: A1

Designated state(s): AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE

WWE Wipo information: entry into national phase

Ref document number: 1999948908

Country of ref document: EP

DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
121 Ep: the epo has been informed by wipo that ep was designated in this application
WWP Wipo information: published in national office

Ref document number: 1999948908

Country of ref document: EP

WWG Wipo information: grant in national office

Ref document number: 1999948908

Country of ref document: EP