摘要:
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.
摘要:
A mechanism is described for processing requests to specify operations to database objects. A request to perform an action on a set of multiple objects is received by a database system. The request includes references to each object in the set, each reference indicating a table where the respective object resides. The reference is used to locate the object, and once located, the action is performed on the object. The reference may indicate a table using a unique table id not used in any of a plurality of databases to identify a table. The action request may be to modify the object, the references may include references to objects that reside in different database systems.
摘要:
A method and apparatus for generating references to a set of objects which reside in a plurality databases is described. Each object is associated with a table from a plurality of tables that are contained in the plurality of databases. An object id is associated with each object; the object id uniquely identifies the object relative to the objects in the set of objects. A table id is associated with each table; the table id uniquely identifies the table relative to tables in the plurality of tables. A table containing an object is located based on the table id associated with the table, and the object is located in the table based on the object id associated with the object. A table mapping is generated. The table mapping maps a set of tables to databases associated with the set of tables. The set of tables are from the plurality of tables. References to objects from the set of object are generated. Each reference comprises data that identifies an object. The reference contains data representing the object id of the referenced object, the object referred to by the reference. The reference also contains data representing the table id of the table containing the referenced object. An object is located based on the table mapping and the reference referring to the object. The table containing the object is located based on the data in the reference, the data representing the table id associated with the table containing the object.
摘要:
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.
摘要:
A method and apparatus are provided for locating a object based on a reference to the object. An application determines whether the reference has previously been used to locate the object. If the reference has previously been used to locate the object, then a data structure referred to as a "tombstone" that has been associated with the object is located based on a first virtual memory address that is stored in the reference. Once the tombstone has been located, a first pseudo-timestamp that is stored in the reference is compared to a second pseudo-timestamp that is stored in the tombstone. If the first pseudo-timestamp matches the second pseudo-timestamp, then the object is located based on a second virtual memory address that is stored in the tombstone. If the first pseudo-timestamp does not match the second pseudo-timestamp or if the reference has not been previously used to locate the object, then the object is located based on the identifier stored in the reference. During the process of locating the object based on the object identifier, the virtual address of the tombstone associated with the object is stored in the reference, and the pseudo-timestamp stored in the tombstone is stored in the reference. When tombstones are reused, the pseudo-timestamp within the tombstone is incremented.
摘要:
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.
摘要:
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.
摘要:
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.
摘要:
The present invention provides interprocess communication in a DBMS. The present invention provides the ability for these processes to communicate with other DBMS processes or processes external to the DBMS. A pipe is implemented as an object of the general purpose object cache. The general purpose object cache resides in the systems shared memory space. It is concurrently accessible by many sessions, or processes. A pipe is located in a shared global memory area. The present invention provides the ability to send a message (i.e., record) to a pipe, and receive a message (i.e., record) from a pipe. A pipe is located in shared memory. Shared memory can contain multiple pipes. Each pipe is comprised of a linked list of records, and linked list of sessions, an exclusivity indicator, and a session waiting indicator. Multiple sessions can access the same pipe, and each pipe can contain multiple messages. A message is sent by a sending session to a local buffer. The contents of the local buffer is sent to a pipe. The contents of a pipe, one or more records, can be accessed by getting a record from the pipe and placing it in a local buffer. The contents of the local buffer can be accessed by the requesting session.
摘要:
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.