Oracle International Corporation

Ipventure, Inc.

Other

June Ray Limited

Joyo Wijaya

Louis H Borders

Sunil Bhargava

Ajit Ramachandra Mayya

Peter Ham

Margaret Sue Lloyd

Gray Andrew Clossman

Anil Nori

Andrew Karl Miller

James Connell Mills

Arvind Peter Relan

Franklin Goodhue Woodward

Randolph Ashton Hodge

Sudheer Thakur

Chin Hong

Chin-Heng Hong

Tze-Pin Cheng

Avrind Peter Relan

Lakshminarayanan Luxi Chidambaran

Srinath Krishnaswamy

Susan M Kotsovolos

Sandeep Nijhawan

Tin A Nguyen

Rajagopalan Govindarajan

Ramkumar Krishnan

Vicky L Kool

Robert P Kooi, Deceased

John Boonleungtomnu

A technique for effecting electronic commerce using a data network is described. The data network includes a plurality of subsystems which, together, form an integrated system for receiving customer orders for selected items via a data network, fulfilling the customer orders, and delivering the ordered products to the customers. Moreover, according to a specific embodiment, the integrated nature of the system architecture of the present invention allows the on-line merchant to provide a guarantee to the customer that the ordered items will be available to be delivered to the customer at the specified delivery date, time, and location.

Online store product availability

Integrated online store

A technique is disclosed for implementing electronic commerce transactions via a data network. A regulated item selected by a customer is identified. The regulated item may correspond to an item which satisfies predetermined criteria, indicating that the regulated item is prohibited from being purchased by the customer. Action is then taken to prohibit the purchase of the selected item, via the data network, by the customer. According to one embodiment, the action taken to prohibit the purchase of the regulated item is automatically implemented at a server system configured to implement electronic commerce transactions between an on-line merchant and the customer. According to a specific implementation, the predetermined criteria correspond to regulations which restrict sales of the regulated items to persons in a particular jurisdiction based upon certain criteria such as, for example, time of day, day of week, age of the customer, type of product being sold, etc.

Restricted purchase of regulated items over a network

A technique is disclosed for automatically implementing item substitutions for unavailable items in a customer order. According to one embodiment, line item orders from selected customer orders may be aggregated and processed for substitution analysis. Substitutions for unavailable items of selected customer orders may then be automatically implemented based upon substitution instructions, business rules, and/or other predefined criteria.

Item substitution for unavailable items relating to a customer order

Webstore supporting multiple merchants

Method and apparatus for facilitating online purchase of regulated products over a data network

Technique for handling sales of regulated items implemented over a data network

Technique for implementing item substitution for unavailable items relating to a customer order

Integrated system for ordering, fulfillment, and delivery of consumer products using a data network

Methods and apparatus for scheduling delivery of an order via a wide area network. A computer system associates a customer point value with each customer according to a customer point system. The customer point values is determined with reference to customer order data. The computer system then divides the customers into customer groups, each of which has a range of customer point values. The system determines an actual capacity allocation distribution among the customer groups based on the customer order data. The system adjusts the range of customer point values for customer groups to cause the actual capacity allocation distribution to converge to a target capacity allocation distribution.

Scheduling delivery of products via the internet

A method and apparatus for presenting and modifying data from a set of tables in a database is provided. A view that is defined is based on a set of one or more tables that may include relational tables or object tables. The view defines a presentation of data from the one or more tables as a set of objects that reside in the database. Data is read from the one or more rows of the tables based on the view, and is presented as a set of objects that reside in the database. An object id that is based on data from the one or more rows is generated and associated with each object presented. The view may specify which columns from the one or more tables contain values used to generate the object ids. A trigger may associated with the view. The set of objects presented may be presented as objects having an attribute that is a column object. Column objects include user specified object types, collection objects (e.g. nested tables and variable arrays), or references to objects.

Object views for relational data

Growing community of inventors

Menlo Park, CA, United States of America

Joyo Wijaya