Abstract: A reporting system that incorporates a context sensitive prompt object in a report definition to enable questions to be answered automatically by the reporting system (e.g., decision support system, business intelligence and OLAP) at report execution time. The context sensitive prompt object is an object separate from the report such that the context sensitive prompt object may be used by a plurality of different reports. The answer is defined at least in part by a contextual feature of the report execution.

Abstract: Architecture solution maps can be generated which graphically represent an interrelation among a plurality of topics related to the deployment of software in a computing landscape. A user, when generating the architecture solution map, can define that only topics having a predefined level of relatedness are included within a rendered architecture solution map.

Abstract: A method for responding to changes to properties of component instances is disclosed. A routine, that is to be informed of changes that occur to a particular property of a plurality of properties of a component instance, is registered. The value of the particular property is detected as changed when the value of the particular property changes because of a change to another property of the plurality of properties. A call is made to the routine to indicate that the particular property has changed.

Abstract: A computer implemented method for executing an ANSI SQL expression belonging to the SELECT-WHERE-equi-JOIN class on data residing in a distributed file system, said method comprising the steps of entering the ANSI SQL expression into a user interface; converting the ANSI SQL expression into a map-reduce program; running the map-reduce program on the distributed file system; storing the result set of the program in the distributed file system; and presenting the result set through a user interface.

Abstract: A multi-dimensional table having plural dimensions is stored in a database system, where plural grouping combinations of the plural dimensions define corresponding subsets of the multi-dimensional table. An aggregate measure for each of at least some of the plural subsets is computed, where the aggregate measure for a particular subset represents a relationship of the particular subset to one or more parents of the particular subset. Less than all of the at least some subsets are selected to materialize based on the aggregate measures.

Abstract: Improved data governance solutions to enterprise-level master data storage hubs are provided by implementing data governance functionality across the operational systems, analytical systems, and master data hubs of an enterprise. Data governance functionality is provided across the systems and hubs of an enterprise by providing visibility into the operational data, analytical data, and master data of an enterprise, by providing visibility into the data quality measuring processes that have been executed on the operational and analytical data, and by providing functionality for correcting fragmented, inconsistent, and erroneous information within operational and analytical data.

Abstract: Systems, methods and articles of manufacture are disclosed for building and executing analytics solutions. Such a solution may provide a comprehensive analytics solution (e.g., a risk assessment, fraud detection solution, dynamic operational risk evaluations, regulatory compliance assessments, etc.). The analytics solution may perform an analytics task using operational data distributed across a variety of independently created and governed data repositories in different departments of an organization. A framework is disclosed which allows a user (e.g., a risk analyst) to compose analytical tools that can access data from a variety of sources (both internal and external to an enterprise) and perform a variety of analytic functions.

Abstract: Systems, methods and articles of manufacture are disclosed for building and executing analytics solutions. Such a solution may provide a comprehensive analytics solution (e.g., a risk assessment, fraud detection solution, dynamic operational risk evaluations, regulatory compliance assessments, etc.). The analytics solution may perform an analytics task using operational data distributed across a variety of independently created and governed data repositories in different departments of an organization. A framework is disclosed which allows a user (e.g., a risk analyst) to compose analytical tools that can access data from a variety of sources (both internal and external to an enterprise) and perform a variety of analytic functions.

Abstract: A relational database is provided with a plurality of data entries stored in the database. The data entries have a hierarchical relationship. The data entries are assigned a real number, unique identifier, which can be calculated using a convergent series, capable of locating each data entry in the hierarchical structure. Each data entry is assigned a float type, level value, identifying the data entries hierarchical level in the structure. The data entries are also assigned an family value defining a hierarchical relationship with another data entry. The invented method allows for retrieving a sub-tree of any data entry by comparing two real numbers, and adding new data entries or a sub-tree without making changes to other data entries.

Abstract: Systems and computer products that present typically large amounts of entity information with a graphical display that efficiently maps the display of a large number of OLAP objects to related relational database tables thereby retaining contextual information about the data associated with the objects and tables. The efficient mapping is enabled by the use of areas that contain and include objects. The preferred embodiment of the present invention enhances analysis, by OLAP techniques, of the objects and the associated relational database information. An embodiment of the present invention further operates in a recursive manner by enabling the objects to include and contain additional objects.

Abstract: An online analytical processing (OLAP) specification system for specifying a new OLAP cube from an OLAP cube template including an OLAP cube template determination module determining the OLAP cube template and retrieve a corresponding template metadata file, the template metadata file including metadata defining the structure of the OLAP cube template. The OLAP specification system also includes a metadata copy module copying the template metadata file to create a base metadata file. The OLAP specification system also includes a viable options generation module generating and presenting viable options for modifying metadata in the base metadata file to define the new OLAP cube, where the viable options for modifying metadata in the base metadata file conforms with one or more predetermined rules.

Abstract: A system and method of deriving software use and software data object characteristics determine one or more locations on one or more computer storage devices where one or more configuration and data files associated with computer software components are stored, and obtain one or more attributes associated with said one or more computer software components. One or more commands associated with said one or more computer software components may be issued and one or more related information associated with said one or more software computer components resulting from issuing one or more commands may be collected. The related information and the one or more attributes may be mapped to the computer software components to derive information about the computer software component use and data object use characteristics.

Abstract: A method, system, and computer program product for updating and/or expanding the functionality of the sequence control of at least one control unit of a motor vehicle are provided. In accordance with the method, a first data may be read from a first control unit and a second data may be read from a second control unit. A first check in the vehicle may be performed to ascertain whether the version of the sequence control currently running in the second control unit corresponds to a predetermined version of a sequence control or is even more current than the predetermined version. If the outcome of the first check is positive, a more current version in comparison with the version of the sequence control currently running in the first control unit may be saved and/or a version which expands the functionality may be saved in the first control unit.

Abstract: A system, method, and program for improving the performance for SQL queries. Multidimensional metadata associated with a cube model metadata object is obtained. One or more summary tables to be built are automatically identified based on the obtained multidimensional metadata. One or more indexes to create are automatically identified based on the obtained multidimensional metadata.

Abstract: A system and method for managing customer's preference information, the system including: a first storage device which stores first information of first clothes which a customer carries to a dressing room to try on; a second storage device which stores second information of second clothes purchased by the customer, and a processing device which processes and reports the first information and the second information.

Abstract: A testing system includes a server device and at least one testing station communicating with the server device. The server device includes a storage unit, a configuration module, and an executing module. The storage unit stores a testing task function database therein. The testing task function database includes a plurality of testing task functions, which are capable of controlling the at least one testing station. The configuration module is capable of setting a testing item corresponding to the at least one testing station and identification numbers of testing tasks to the testing item. Each identification number of the testing tasks corresponds to one of the testing task functions. The executing module is capable of reading the testing task functions from the testing task function database according to the identification numbers of the testing tasks and starting the testing task functions to control the least one testing station to test the electronic devices.

Abstract: Systems and methods that supply extensibility mechanisms for analysis services, via a plug-in component that enables additional functionalities. The plug-in component provide additional custom logic for the analysis services unified dimensional model (UDM). Accordingly, server functionalities can be extended in an agile manner, and without a requirement for a new release, for example.

Abstract: An approach to processing data streams includes a new type dynamic database of stream star schema to accommodate high data stream rates for giga bits per second by reducing the insert time to a constant and a new type of data cube as nested binary tree to supports both data aggregates and data values.

Abstract: A data extraction tool is provided for cataloging information in an information source for searching by a user. The tool mines information from the information source and organizes the information, or the locations of that information, within a database. A user may then query the tool for a desired type of information. The tool filters the database to provide a set of pinpoint site locations with information of the type requested in the query. These pinpoint site locations are presented to a user and indexed for future reference. The index of site locations may be updated automatically by the tool. A context system is provided for manually or automatically determining the proper context for a user's query. Thus, the data extraction tool provides information with a high probability of relevance to the user. The user obtains the information without expending much effort to refine the search.

Abstract: A method for analyzing data from a database using an analytic database function includes receiving a selection of measured items from a user, receiving a placement item from the user, and determining a partitioning of the selection of measured items from the placement item. A placement item can be a column, a row, or an axis. A template associated with the analytic database function is adapted to define at least one partitioning relative to the placement item. The template is further adapted to define an ordering parameter for the analytic database function and optionally an aggregation level for the analytic database function. A database query is created with the partitioning. The database query can be an SQL statement.

Abstract: A technique is described for selectively obtaining information stored in a business warehouse. Such a technique may include selecting a data access service from a library during run-time and presenting data within the business warehouse using the selected data access service. The library may contain at least one data access service for each of a plurality of on-line analytical processing data access queries. Related apparatus, systems, computer program products, and computer systems are also described.

Abstract: Processes, systems and computer program products for data management. A distributed map is provided that maps data from a first dimension level in a hierarchy to a second dimension level in the hierarchy. The data is aggregated from the first dimension level to the second dimension level based on the mapping. The distributed map is partitioned across multiple devices.

Abstract: In an information processing system including an information processing apparatus and a content output apparatus which are connected to each other, the content output apparatus is configured to include a function identification file creation unit adapted to, in accordance with a button operation by a user, create a function identification file for causing the information processing apparatus to execute a predetermined function, and a file storage unit adapted to store the function identification file in a storage unit, and the information processing apparatus is configured to include a detector adapted to detect a connection of the content output apparatus to the information processing apparatus, and a controller adapted to, after detecting the connection of the content output apparatus, start an application program to execute the function depending on the presence/absence of the function identification file in the storage unit.

Abstract: Provided is a method for mapping traits in organisms, in particular in plants. The method comprises a) providing a population of SDR-0 organisms, in particular plants, that each arise from one member of a population of unreduced cells resulting from second division restitution, in particular a population of unreduced spores; b) producing SDR-1 progeny populations of each of these SDR-0 organisms; c) phenotyping the SDR-1 progeny populations to identify segregating traits within each SDR-1 progeny population; d) if segregating progeny are present in a SDR-1 progeny population, genotyping the corresponding SDR-0 organism and comparing the genotype thereof with the genotype of the other SDR-0 organisms to identify heterozygous chromosomal regions associated with the occurrence of the segregating trait identified in the SDR-1 progeny population.

Abstract: A method for detection is presented. The method includes extracting data based upon one or more predefined rules. Further, the method includes preprocessing the extracted data based on the predefined rules to generate one or more rule groups. The method also includes instantiating one or more inference engines based on the generated rule groups. Additionally, the method includes processing the extracted data by a corresponding inference engine based on the predefined rules to generate processed data. Systems and computer-readable medium that afford functionality of the type defined by this method is also contemplated in conjunction with the present technique.

Abstract: Methods and systems to analyze domain rules based on domain coverage of the domain rules are provided. First, the system receives a first plurality of data items from a database utilized by an information storage and retrieval platform, respectively counting the first plurality of data items to determine a total quantity of data items. Next, the system applies a plurality of rules to the first plurality of data items to identify a second plurality of data items associated with a first domain based on the respective rule, respectively counting the first plurality of data items to determine a first quantity of data items. Next, the system determines a percentage of coverage for the first domain, the percentage of coverage based on the first quantity of data items and the total quantity of data items. Next, the system represents the percentage of coverage as a first interface element within an interface.

Abstract: The system includes at least one server, at least one query terminal and at least one answer terminal. The query terminal can utilize the online consultation apparatus of the invention, and transmit at least one query and a coordinate point of the query terminal to the server based on the position of the query terminal. The server then actively transmits the query to the potential answer terminals in the vicinity of the coordinate point of the query terminal. Accordingly, the query terminal could obtain at least one response/answer and a coordinate point of the answer terminal through the server.

Abstract: One embodiment of the invention provides a computer-implemented method for providing prediction results to an application system during an interactive session with a user. In this embodiment, the method includes receiving a first set of input values from the application system, using a data mining model along with the first set of input values to compute a first prediction result, and saving state information generated from the computation of the first prediction result. The method further includes receiving a second set of input values from the application system, and using the data mining model along with the state information and the second set of input values to compute a second prediction result.

Abstract: Systems and methods for managed access to tiered storage are disclosed. One such system comprises a plurality of storage systems and a tier manager. Each storage system implements a tier selected from the group of online and other than online. The tier manager is configured to ensure that a specified file is available on a specified tier, responsive to a client request.

Abstract: Methods and apparatus are provided for propagating functional dependencies with conditions. Propagation covers are computed using an SPC view of a dataset, wherein the SPC view comprises selection, projection and Cartesian product operations. Selection operations are processed to extract equivalence classes. Cartesian product operations are processed to obtain a renamed set of the plurality of conditional functional dependencies, that have attributes appearing in the SPC view. Domain constraints from the equivalence classes are applied to the renamed set to remove attributes not in the SPC view. Projection operations are processed using a reduction by resolution procedure to identify inferences that can be propagated to the SPC view from the conditional functional dependencies having attributes that do not appear in the SPC view. Domain constraints of the equivalence classes are converted to conditional functional dependencies; and a minimal cover of the SPC view is determined.

Abstract: Described herein are methods and systems for capturing OLAP analysis thread and transferring the data into a data visualization tool. According to one aspect, OLAP analysis step queries and the corresponding results are recorded and transferred to a data visualization tool. In another aspect, the data in the data visualization tool may be refreshed without affecting the data format.

Abstract: Methods, systems, and computer program products dynamically filter an aggregate report based on values resulting from one or more filters previously applied to the aggregate report. A method involves maintaining a collection of filters to be applied in a designated evaluation order to the aggregate report, applying a first filter to the aggregate report, and evaluating values in the aggregate report to produce aggregate values resulting from applying the first filter. The method also involves applying a next filter to the aggregate report and evaluating the aggregate values in the aggregate report resulting from applying the first filter therein producing aggregate values resulting from applying the next filter to the aggregate report. Additionally, the method involves displaying the aggregate report wherein evaluating values resulting from previously applying any filter to the aggregate report involves evaluating visual values displayed in the aggregate report after each previous filter has been applied.

Abstract: A method and structure for analyzing a database having non-text data in data fields and text in text fields. The invention first selects a subset of the database based upon criteria. The subset includes data field(s) and associated text field(s). The invention searches for data matching the criteria within structured data fields of the database. If the invention searches multiple databases, the invention creates shared dimensions for databases that do not share common attributes. The invention automatically selects a relatively short text phrase from the text fields that helps to explain the underlying meaning (i.e. unique text content) of a data subset selected using the non-text data fields.

Abstract: A computer-implemented dimension engine that automatically identifies the market segments represented in user-specified input data. The dimension engine creates new dimension variables based on those segments that most accurately predict the outcomes of a target variable. A data store is used to store the input data. A decision tree processing module determines a subset of the dimension variables to split the input data. The splitting of the dimension variables predicts the target variable. A multi-dimension viewer generates a report using the determined dimension variables subset and the splitting of the dimension variables.

Abstract: Disclosed is a storage management system including at least one client, a first server having a primary storage, a second server having a secondary storage, and an intermediate device logically arranged between the client and the first and second servers. The primary storage includes a stub file in which there is recorded the position information of the real file migrated from the primary storage to the secondary storage. The intermediate device exercises control so that, when a file access request of the primary storage of a first server, issued by the client, is received by the intermediate device, the intermediate device receives the file access request and, if the file to be accessed is a stub file, and the access request necessitates accessing to the real file, the intermediate device accesses the real file of the secondary storage using the information of the stub file to return a response.

Abstract: Information stored in a corporate database is monitored and used to determine when certain business-related events have occurred. Event information is transmitted over the Internet to a print production facility, where it is used to fire one or more event rules, which in turn automatically generate print requisitions or print production orders. In one variation, print requisitions are routed through an existing and commercially available procurement system before a print production order is generated. The system can monitor and handle events from multiple corporations, each having its own business-related event rules, and each potentially having its own procurement approval system.

Abstract: Data can be extracted from one or more data sources. Thereafter, the extracted data can be transformed to a format compatible with a plurality of structurally identical data targets so that the transformed data can be loaded into the plurality of data targets via data transfer processes. The data transfer processes define disjoint data sets among the plurality of data targets. Related apparatus, systems, methods, and articles are also described.

Abstract: A technique includes selectively obtaining information stored in a business warehouse. Such a technique may include selecting a data access service from a library during run-time and presenting data within the business warehouse using the selected data access service. The library may contain at least one data access service for each of the plurality of on-line analytical processing data access queries. Related apparatus, systems, computer program products, and computer systems are also described.

Abstract: A novel rules engine which automates many warehouse processes, and provides for efficient management of a warehouse. The rules engine provides a flexible and customizable structure for modeling the many different types of processes governing the function of a warehouse. The rules engine translates business level logic into code for manipulating the warehouse database. The rules engine allows a user to create their own user logic for working with the database, which operates at a level of abstraction more feasible for the user. The rules engine understands the user logic by the way the user decides how to string various restrictions together. The rules engine implements the translation via its internal understanding of the structure of the particular application. Thus, the rules engine allows the user to define logic without understanding how to manipulate a database.

Abstract: The subject invention pertains to systems and methods for interacting with fact dimensions. In particular, systems and methods are disclosed that optimize performance and scalability with respect to processing queries that involve fact dimensions. Furthermore, queries involving fact dimensions can be evaluated in distinct manners. For instance, queries can be processed such that regular dimensions restrict the scope of the data and only fact dimension members that are relevant to that scope are exposed.

Abstract: A system for use in rendering a report for a client application, client server application or multi-tier applications. The system includes a report definition generator that is configured to generate a report definition using metadata located in a metadata store. A database in the application configured to receive a query and to provide a data set. A design engine is configured to render the report based on the report definition, parameters and the data set.

Abstract: The subject disclosure pertains to databases as well as generation and utilization of keys. A desired or default number of values can be requested from a domain and allocated for use. These values can be utilized to generate surrogate keys. Subsequently or concurrently, the keys can be employed with respect to operations such as single pass loading of databases and/or data warehouses. Any unused keys can be returned and made available for use by other users or processes. Furthermore, the key generation functionality can be provided outside a database thereby relieving a database system of this burden.

Abstract: A method of organizing, storing and representing a hierarchy of human resource information and organizational responsibilities of an enterprise provides a human resource user the ability to define and view an organizational chart for a plurality of organizations within a company or enterprise. The method may be used to define a top node and a plurality of other nodes that then can have responsibilities and managers assigned to each node in the hierarchy. Each other manager can have multiple responsibilities, multiple managers or multiple delegations. A graphical user interface may allow users to select and manipulate different combinations of managers and responsibilities to view a hierarchy in an employee centric manner, using menus and drill down charts.

Abstract: According to some embodiments, systems and methods are provided to facilitate a distribution of bank accounts via an educational institution. For example, information associated with a student, faculty member, or alum may be received from a university. A soft bank account may then be established based on the received information. If an indication of acceptance is received (e.g., via a Web site), the soft bank account may be activated. The activated bank account may then be used to process banking transactions.

Abstract: A computer implemented method, apparatus, and computer usable program code for determining aggregate values of health data items from heterogeneously coded databases containing heterogeneously coded medical data. The data, in heterogeneous databases, is queried using a series of semantic layers including i) cascaded asymmetric association tables and ii) semantic search. The heterogeneously coded medical data items are translated into conformal dimensions and denominator files of combinations of disease data are derived. The denominator files of combinations of disease are aggregated based on a mapping of the coded medical and demographic conditions. The data is stored in a target data repository.

Abstract: A system and method are provided for providing a shared RAM cache of a database, accessible by multiple processes. By sharing a single cache rather than local copies of the database, memory is saved and synchronization of data accessed by different processes is assured. Synchronization between the database and the shared cache is assured by using a unidirectional notification mechanism between the database and the shared cache. Client APIs within the processes search the data within the shared cache directly, rather than by making a request to a database server. Therefore server load is not affected by the number of requesting applications and data fetch time is not affected by Inter-Process Communication delay or by additional context switching. A new synchronization scheme allows multiple processes to be used in building and maintaining the cache, greatly reducing start up time.

Abstract: Exemplary illustrative embodiments provide for a computer implemented method, apparatus, and computer usable program code for mapping data. The mapping is defined by a user and maps a source datum to a target datum having a target attribute. The mapping is defined using metadata. Source specific information is omitted from the mapping and stored in a target data repository.

Abstract: Audit records generated from applications running on multiple machines in a computer network are managed on an audit management system. Audit records are sent by the applications over a network to the audit management system. One or more operations are performed on the audit records within the audit management system. After the one or more operations are performed, data representing the audit records from the different applications is written by the audit management system to a repository.

Abstract: The present invention provides a method and system for the automatic extraction of data from a transaction system to an analytics system, which is capable of handling large volumes of application data.

Abstract: Systems and computer products that improve the techniques used to search multidimensional databases over techniques of the past. The preferred embodiment of the present invention advantageously improves the technique of determining a grid index that is used to locate a geometric shape in a spatial database. More particularly, the preferred embodiment of the present invention improves the technique of defining the grid cell size in a grid for a given data set, thereby improving the grid indexing process that locates a particular minimum-bounding rectangle and the associated geometric shape.