摘要:
A method, system and article of manufacture for linking logical fields abstractly describing data in a database and, more particularly, for creating an abstract query using linked logical fields. One embodiment provides a method of linking logical fields abstractly describing data in a database. The method includes creating link information for a first logical field from the plurality of logical fields. The link information identifies at least one second logical field from the plurality of logical fields and an associated link type operation. The first and second logical fields are linked using the link information.
摘要:
Techniques are disclosed for storing and rendering a graphical user interface (GUI) that includes a display area for specifying result fields and operators to define an abstract query. Each result field corresponds to a logical field specification of a data abstraction model abstractly describing data in a database. The GUI further includes a display area for specifying classification fields for the abstract query, each classification field including a result field and a classification definition, and the display area including a result field window displaying available result fields and graphical elements configured to allow specification of classification definitions for one or more selected result fields. The classification definition is suitable for dividing data into a plurality of categories. The GUI further includes a selection element for specifying whether the specified classification fields are included with the abstract query for execution, and another selection element for initiating execution of the abstract query.
摘要:
A method, system and article of manufacture for linking logical fields abstractly describing data in a database and, more particularly, for creating an abstract query using linked logical fields. One embodiment provides a method of linking logical fields abstractly describing data in a database. The method includes creating link information for a first logical field from the plurality of logical fields. The link information identifies at least one second logical field from the plurality of logical fields and an associated link type operation. The first and second logical fields are linked using the link information.
摘要:
A method, system and article of manufacture for constructing queries that are executed against a database and, more particularly, for constructing queries capable of returning classified information related to data in a database. One embodiment includes receiving user input specifying a plurality of result fields for an abstract query. Each result field corresponds to a logical field specification of a data abstraction model abstractly describing the data in the database. The method further includes receiving user input selecting one of the plurality of result fields, and receiving user input specifying a classification definition for the selected result field. The classification definition is suitable for dividing data to be returned for the selected result field into a plurality of categories. Then, a classification field for the abstract query is generated on the basis of the selected result field and the classification definition. The classification field is included with the abstract query. The method further includes receiving a user request for execution of the abstract query against the database.
摘要:
A method, system and article of manufacture for constructing queries that are executed against a database and, more particularly, for constructing queries capable of returning classified information related to data in a database. One embodiment includes receiving user input specifying a plurality of result fields for an abstract query. Each result field corresponds to a logical field specification of a data abstraction model abstractly describing the data in the database. The method further includes receiving user input selecting one of the plurality of result fields, and receiving user input specifying a classification definition for the selected result field. The classification definition is suitable for dividing data to be returned for the selected result field into a plurality of categories. Then, a classification field for the abstract query is generated on the basis of the selected result field and the classification definition. The classification field is included with the abstract query. The method further includes receiving a user request for execution of the abstract query against the database.
摘要:
One embodiment includes receiving user input specifying a plurality of result fields for an abstract query. Each result field corresponds to a logical field specification of a data abstraction model abstractly describing the data in the database. The method further includes receiving user input selecting one of the plurality of result fields, and receiving user input specifying a classification definition for the selected result field. The classification definition is suitable for dividing data to be returned for the selected result field into a plurality of categories. Then, a classification field for the abstract query is generated on the basis of the selected result field and the classification definition. The classification field is included with the abstract query. The method further includes receiving a user request for execution of the abstract query against the database.
摘要:
Embodiments of the invention allow structured data to be transferred between a source application and target applications that process structured data in different formats. For example, structured data may have associated rules which transform the structured data based on some variables. The source application may register variable definitions for each variable in a registry. Each target application may read the registry and register values for the variables. Once values are registered, the source application transfers the structured data to a transformation engine that applies the rules, using the registered values for the variables, to transform the structured data into a format compatible with the target applications. The transformation engine may also determine distinct sets of variable values and transform structured data based on each distinct set. In doing so, the number of transformed data generated is limited to the number of distinct sets, thereby avoiding generating duplicate transformed data.
摘要:
Embodiments of the invention allow structured data to be transferred between a source application and a service-oriented target application that process data in different formats. The data to be transferred may be divided into different sections, where each section is processed by a respective service of the target application. To transform each section of data into a format compatible with a respective service, the data may have a set of associated rules which transform data based on a set of variables. The source application may provide variable definitions for each of the variables. Each service of the target application may specify values for each of the variables. Once the variables have a specified value, a transformation engine may transform each section of the data and subsequently transfer the transformed sections of the data to respective services of the target application for processing.
摘要:
A method, apparatus, and program product are provided for creating an Encoded Matrix Index for a column in a database table. An element of the column for all rows in the database table is compared to a corresponding reference value in a reference data structure, and in response to at least one value for the element of the column not matching the reference value, indicating a variation in a variation data structure and creating a value data structure. Queries executed using the Encoded Matrix Index include terms associated with a sub-column defined in a column of a database table. The variation data structure is accessed to determine whether any variation exists between rows belonging to a sub-column of the database table. If no variation exists, a value is accessed from the reference data structure; otherwise, a value for each row of the sub-column is accessed from a value data structure.
摘要:
A method, apparatus, and program product are provided for creating an Encoded Matrix Index for a column in a database table. An element of the column for all rows in the database table is compared to a corresponding reference value in a reference data structure, and in response to at least one value for the element of the column not matching the reference value, indicating a variation in a variation data structure and creating a value data structure. Queries executed using the Encoded Matrix Index include terms associated with a sub-column defined in a column of a database table. The variation data structure is accessed to determine whether any variation exists between rows belonging to a sub-column of the database table. If no variation exists, a value is accessed from the reference data structure; otherwise, a value for each row of the sub-column is accessed from a value data structure.