International Business Machines Corporation

Frequentz LLC

Gary J Robinson

William Earl Malloy

Craig Reginald Tomlyn

Simon Edward Moore

Anthony C Asher

Christian C Clauss

Andreas Arning

Ralf Rantzau

Shrinivas Kulkarni

Tyrone W A Grandison

Daniel Martin DeKimpe

Jordan M Taylor

Marlene L Coates

Jay Merrill Bruce

Guilherme Saueressig

Steven P Beier

Paul D Bellamy

Richard A Fritz

Karin Kailing

John Squires Poelman

Raymond L Simonetty

Wayne V Myers

Alvin Hon Lam So

In various embodiments, methods define an analysis window for a dimensional model in accordance with a window template and a starting point. One or more aggregate definitions are produced based on the analysis window. In another embodiment, the dimensional model comprises a time dimension, and the window template is associated with the time dimension. In yet another embodiment, the starting point is changed to a new starting point, and a new analysis window is defined using the new starting point.

Designing aggregates based on access patterns in dimensions

Methods and apparatus, including computer program products, implementing and using techniques for providing a discovery service that provides a mapping from an electronic product code to electronic product code information services that include information about an item represented by an electronic product code. The discovery service includes a database containing a list of custodians for the item and a service interface through which electronic product code information services and applications can access the entries in the list. The list includes an entry for each custodian. Each entry includes the electronic product code number, a pointer to an electronic product code information service associated with the custodian, and a trip identifier for the item. The service interface includes several services enabling traceability of the item represented by the electronic product code. Methods and apparatus, including computer program products for using a trip identifier in a discovery service are also described.

Enhancing discovery services in an EPC network

Methods and apparatus, including computer program products, implementing and using techniques for managing security and privacy associations between an electronic product code value and an address of a repository containing information about an item represented by the electronic product code. A security certificate is issued to each of one or more parties that are authorized to use the repository. In response to a party among the one or more parties sensing the electronic product code, a record is created in the repository. The record represents the sensing of the electronic product code and includes a security certificate belonging to the party that sensed the electronic product code.

Security and privacy enforcement for discovery services in a network of electronic product code information repositories

A technique for accessing a subject multi-dimensional database stored on a data store connected to the computer. An index is created for the subject multi-dimensional database, wherein the index comprises another multi-dimensional database. Then, the subject multi-dimensional database is accessed using the index.

Using an index to access a subject multi-dimensional database

A technique for navigating an index to access a subject multi-dimensional database stored on a data store connected to the computer. Initially, a deviations spreadsheet comprising cells is displayed. Then, upon user selection of a cell in the deviations spreadsheet, the selected cell is displayed in the subject multi-dimensional database.

Navigating an index to access a subject multi-dimensional database

Systems, methods, and computer products that efficiently determine useful dimensions associated with a database when employing OLAP processing techniques. The present invention enables a user to see at a glance in which queries certain columns and tables are used. The present invention may be implemented with a query miner module that may include a query browser module that improves browsing through queries and their components over the past. The preferred embodiment of the present invention provides an easy to use graphical interface showing the queries, tables, and columns in a tree structure. Further, the preferred embodiment of the present invention presents information about relationships and dimensions associated with a database and about columns, tables, and queries to the user without discernable lag time between the user's request and the generated information.

Systems, methods and computer program products to determine useful relationships and dimensions of a database

A technique for accessing a subject multi-dimensional database stored on a data store connected to the computer. An index is created for the subject multi-dimensional database, wherein the index includes another multi-dimensional database having dimensions of the subject multi-dimensional database and an additional ranking dimension. Then, the subject multi-dimensional database is accessed using the index.

A method, apparatus, and article of manufacture for improved performance of table insertion by using multiple tables or multiple threads. A command is executed in a computer to perform a database operation on a relational database stored on a data store connected to the computer. A multi-dimensional database is represented as a relational schema in the relational database, wherein the relational schema includes one or more base tables, related dimension tables, and a key table. Each of the base tables and the key table is accessed concurrently to perform the database operation.

Performance of table insertion by using multiple tables or multiple threads

A method, apparatus, and article of manufacture for using a relational database management system to support on-line analytical processing (OLAP) systems. A multi-dimensional database is defined having a set of multi-dimensional data blocks and a set of identifiers comprising selected dimensions of multi-dimensional data for identifying particular ones of the multi-dimensional data blocks. The set of identifiers provides an ordering of the multi-dimensional data blocks using multi-dimensional member identifiers and holds usage information and age information about the multi-dimensional data blocks. The data in the set of multi-dimensional data blocks is stored in a relational database that represents the multi-dimensional database. Then, a set of rows representing a multi-dimensional data block is accessed from the relational database.

Relational emulation of a multi-dimensional database index

A method, apparatus, and article of manufacture for using a relational database management system to support on-line analytical processing (OLAP) systems. A relational database has a fact table and at least one related dimension table. A dimension identifier is received that identifies a data block in a multi-dimensional database. The dimension identifier comprises one or more multi-dimensional member identifiers. Rows are accessed from the fact table through the related dimension tables using the received dimension identifier. Then, the accessed rows are formatted as a data block for the multi-dimensional database.

Accessing multi-dimensional data by mapping dense data blocks to rows in

Relational emulation of a multi-dimensional database

An improved connector assembly includes a resistor coated guide pin to facilitate coupling or decoupling a circuit card to a circuit board. A first embodiment of the pin configuration comprises a single taper pin for eliminating current surges during insertion of the pin into its associated plug. A second embodiment of the pin configuration comprises a dual taper pin having two zones of resistance for also eliminating the spark and associated high frequency noise resulting from pin insertion into or removal from the connector assembly.

Growing community of inventors

Poughkeepsie, NY, United States of America

Gary J Robinson