摘要:
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.
摘要:
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.
摘要:
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.
摘要:
Techniques for searching and presenting search results to a user are provided. A search is decomposed into sub search combinations. Logical operator ordering is maintained within each sub search combination and each sub search combination is processed to acquire a waterfall count for the resulting answer set associated with processing that sub search combination. The sub search combinations and their waterfall counts are then presented to the user for visual inspection and analysis.
摘要:
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.
摘要:
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.
摘要:
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).
摘要:
Techniques for Product Affinity Analysis are presented. A user interacts with a tool to supply user-defined criteria. The criteria are used to automatically generate code that processes against a data store to collect results that conform to conditions defined by the criteria. The results are used to automatically populate a Product Affinity Analysis chart or grid for the user to view and in some cases dynamically interact with.
摘要:
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.
摘要:
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.