Teradata Us, Inc.

Michael Chaves

Jason Keith Figge

Scott Shelton

Harold R Lee

Henry Fu

Susan Jamie Borofsky

Robert Baril

Leslie Mannion

Jason Allen Stone

Larry L Terhune

Dennis Tackett

David Brophy

David Carmer

Haseem Ul Haq Kheiri

Anish Shah

Sean Pritchard

Jeffrey Canna

Alex Chapman

Anil Peres-da-Silva

Mark William Coley

Mark Christopher Bush

Michael J Brown

Kasturi Belur

Claud Teeter

Steven Kennedy

Techniques for annotation driven Representational State Transfer (REST) web services are presented. A platform-independent World-Wide Web application is annotated to expose the methods of the application when accessed via a WWW site. The methods are described when rendered via a WWW site in a REST compliant format (RESTful).

Annotation driven representational state transfer (REST) web services

The subject mater herein relates to requesting data from a database and, more particularly, to database query table substitution. Various embodiments provide systems, methods, and software to evaluate requests for data from a database and make table substitutions in the request to reduce a number of tables queried. Some embodiments include receiving a data request including data from two or more database table columns and building a list of all database tables specified in the data request. Some such embodiments further include, for each column in the data request, identifying each table from the list of all tables within which the column is present and identifying a least number of one or more tables that together include all of the columns of the data request. The data request may then be modified by changing the table of one or more of the columns in the received data requests.

Database query table substitution

The subject mater herein relates to database management and, more particularly, to non-equijoin metadata. Various embodiments described herein provide systems, methods, software, and data structures to facilitate non-equijoins of data. Some such embodiments include a data store to hold metadata describing relationships between database tables. The relationships between database tables may include one or more non-equijoins of tables in the form of one or more table-column pairs of a first table being non-equal to one or more table-column pairs of a second table. In some embodiments, the metadata may be used by a query generator to build query statements including one or more non-equijoin.

Non-equijoin metadata

Techniques are presented for tracking status within object chains. Global objects are associated with unique identifiers and each dependent local object created within the context of a particular global object receives that particular global object's identifier. A unique counter value is maintained for each status type of each global object. The local object facilitates communicating changes in its status using the received global identifier, and the counter values are updated accordingly for the affected global object.

Techniques for tracking status within object chains

Tools for defining and using custom analysis modules are presented. A generic graphical user interface (GUI) custom analysis tool is presented to a user. The generic GUI custom analysis tool is adapted to receive selections and inputs from the user that define many-to-many relationships in a data store and that include user-defined measures. The inputs are used to generate an instance of a custom analysis module that is capable of being processed against the data store. The instance of the custom analysis module may be stored, recalled, executed, and/or modified from the generic GUI custom analysis tool.

Tools for defining and using custom analysis modules

Methods and systems provide automatic search generation capabilities. A search constraint and a control field identifier are received. A search generating module generates a search that when executed returns records from a data store. The records satisfy the search constraint and have identical values for the control field identifier for unique customer identifications.

Search query generation

Techniques are presented for synchronizing data store tables. Elements of first tables are linked together to form dependent chains. The dependencies are not housed with the elements in the first tables; rather, the dependencies are housed in multiple second tables. Each second table maps one of the elements from one of the first tables to another of the elements in another of the first tables.

Techniques for synchronizing data store tables

Techniques for applying segment conditions to measure results are presented. Row and column segment data is acquired from a database according to row and column definitions. A measure calculation is applied against the intersecting row and column segment data. Next, one or more combinations or conditions derived from the row and column definitions are used as a filter to produce filtered results.

Applying segment conditions to measure results

An application includes a variety of metadata and operations that may process the metadata. Selective portions of the metadata are identified and various combinations of available operations are automatically generated for the selective metadata. Each generated operation is then individually validated for syntax and semantics, without actually executing the operation.

Automated metadata validation

Techniques are presented for mapping a physical table to multiple virtual tables. One or more fields within a results set from a query are mapped or associated to one or more virtual tables. The virtual tables are organized as sub graphs and connected together as a set. A reference to the set is provided to a table join analysis service and a join is performed against the set to produce a single logical reference to a table. The single table reference may be treated as a single table for purposes of subsequent search and retrieval by a searcher.

Techniques for mapping a physical table to multiple virtual tables

Methods, systems, and data structure custom queries for segmentation. Queries are imported into a segmentation tool and modified. The queries are associated with data sources that are not mapped within the segmentation tool. Parts of the queries are manually supplied or imported into the segmentation tool and parts of the queries are automatically generated based table and key selections associated with a customer hierarchy. When the custom queries are executed the query results provide customer segmentations for desired marketing campaigns.

Custom queries for segmentation

Techniques are presented for reusing business measures within a data store. A measure is associated with a measure type. Each measure is associated with a particular data store schema or schema element and includes metadata for fields and calculations against those fields. Requestors can select existing measures, create new measures, delete existing measures, and/or modify existing measures. A measure, when processed against the data store, produces results from a data store that are associated with the data store schema or the schema element and which conform to the fields and calculations defined within the measure's metadata.

Growing community of inventors

Cary, NC, United States of America

Michael Chaves