195 results about "On line analytical processing" patented technology

This invention relates to a system and method for creation and automatic deployment of personalized, dynamic and interactive voice services, including information derived from on-line analytical processing (OLAP) systems and other data repositories. More specifically, the invention relates to a system and method that enable personalized delivery of information in real-time, via natural language voice communication with a voice-enabled terminal device. The system and method combines personalized information broadcast technology with an active voice page. An active voice page is created by the system, stored in a call database and used to generate dynamic voice menus. A call server retrieves the AVP from the call database and delivers the content of the service by dialing a subscriber's telephone number, speaking message text to the subscriber and recording the subscriber's input in response to the call menus. A unique AVP is generated for each subscriber scheduled to receive voice service content.

Improved method of and apparatus for aggregating data elements in multidimensional databases (MDDB). In one aspect of the present invention, the apparatus is realized in the form of a high-performance stand-alone (i.e. external) aggregation server which can be plugged-into conventional OLAP systems to achieve significant improments in system performance. In accordance with the principles of the present invention, the stand-alone aggregation server contains a scalable MDDB and a high-performance aggregation engine that are integrated into the modular architecture of the aggregation server. The stand-alone aggregation server of the present invention can uniformly distribute data elements among a plurality of processors, for balanced loading and processing, and therefore is highly scalable. The stand-alone aggregation server of the present invention can be used to realize (i) an improved MDDB for supporting on-line analytical processing (OLAP) operations, (ii) an improved Internet URL Directory for supporting on-line information searching operations by Web-enabled client machines, as well as (iii) diverse types of MDDB-based systems for supporting real-time control of processes in response to complex states of information reflected in the MDDB. In another aspect of the present invention, the apparatus is integrated within a database management system (DBMS). The improved DBMS can be used to realize achieving a significant increase in system performance (e.g. deceased access / search time), user flexibility and ease of use. The improved DBMS system of the present invention can be used to realize an improved Data Warehouse for supporting on-line analytical processing (OLAP) operations or to realize an improved informational database system, operational database system, or the like.

A system and method for personalizing an interactive voice broadcast of a voice service, including information derived from on-line analytical processing (OLAP) systems is disclosed. The system and method include a call server for receiving incoming telephone calls, an identification module for identifying callers, and a personalization module for determining information about the caller.

A method is provided in one example and includes generating a query for a database for information stored in the database. The information relates to data discovered through a capture system. The method further includes generating an Online Analytical Processing (OLAP) element to represent information received from the query. A rule based on the OLAP element is generated and the rule affects data management for one or more documents that satisfy the rule. In more specific embodiments, the method further includes generating a capture rule that defines items the capture system should capture. The method also includes generating a discovery rule that defines objects the capture system should register. In still other embodiments, the method includes developing a policy based on the rule, where the policy identifies how one or more documents are permitted to traverse a network.

An improved method of and a system for managing data elements in a multidimensional database (MDB) supported upon a parallel computing platform using modular-arithmetic based address data mapping (i.e. translation) processes on integer-encoded business dimensions. The parallel computing platform has a plurality of processors and one or more storage volumes for physically storing data elements therein at integer-encoded physical addresses in Processor Storage Space (i.e. physical address space in the one or more storage volumes associated with a given processor). The location of each data element in the MDB is specified in MDB Space by integer-encoded business dimensions associated with the data element. A data loading mechanism loads the integer-encoded business dimensions and associated data elements from a data warehouse. The address data mapping mechanism performs a two part address mapping processing. The first step maps the integer-encoded business dimensions associated with each data element to a given processor identifier (which uniquely identifies the processor amongst the plurality of processors of the parallel computing platform). The second step maps the integer-encoded business dimensions associated with each data element into an integer-encoded physical data storage address in Processor Storage Space associated with the processor identified by the processor identifier generated in the first mapping step. The mapping performed in this second step is based upon size of the integer encoded business dimensions. The data management mechanism manages the data elements stored in the storage volumes using the integer-encoded data storage addresses generated during the two-part address data mapping process. The use of modular-arithmetic functions in the two-part address data mapping mechanism ensures that the data elements in the MDB are uniformly distributed among the plurality of processors for balanced loading and processing. The present invention can be used to realize (i) an improved MDB for supporting on-line analytical processing (OLAP) operations, (ii) an improved Internet URL Directory for supporting on-line information searching operations by Web-enabled client machines, as well as (iii) diverse types of MDB-based systems for supporting real-time control of processes in response to complex states of information reflected in the MDB.

An interactive mobile messaging system (IMMS) for mobile telephone marketing and promotional campaigns integrates interactive voice response (IVR), SMS, fast analysis of shared multidimensional information, and online analytical processing. Online interactive message communication protocols are managed through mobile-originated, short code-based message platforms which are interfaced with an IVR query system. Automatic configuration of multiformat messages can be performed directly into multiple telecommunications carrier networks to all supported mobile handsets.

In one example embodiment, a system and method are shown for receiving data that include a time stamp. The system and method also include building an Online Analytical Processing (OLAP) cube that includes a dimension, the dimension acting as a schema for the data that include the time stamp. The system and method may also include populating the OLAP cube with an object, the object including the data and the time stamp as at least one attribute. The system and method may also include storing the OLAP cube.

A system and method for creation and automatic deployment of audible personalized, dynamic and interactive services, including information derived from on-line analytical processing (OLAP) systems, to a two-way communication device, including electronic mail, two-way pagers, phones, personal digital assistants, and telephones, based on subscriber-specified criteria.

According to the invention, techniques for visualizing customer data contained in databases, data marts and data warehouses. In an exemplary embodiment, the invention provides a system for graphically analyzing relationships in data from one or more data sources of an enterprise. The system can be used with many popular visualization tools, such as On Line Analytical Processing (OLAP) tools and the like. The system is especially useful in conjunction with a meta-model based technique for modeling the enterprise data. The enterprise is typically a business activity, but can also be other loci of human activity. Embodiments according to the invention can display data from a variety of sources in order to provide visual representations of data in a data warehousing environment.

An "active cache", for use by On-Line Analytic Processing (OLAP) systems, that can not only answer queries that match data stored in the cache, but can also answer queries that require aggregation or other computation of the data stored in the cache.

A system and method for creation and automatic deployment of personalized, dynamic and interactive voice services relating to subscriber entertainment, including information derived from on-line analytical processing (OLAP) systems. More specifically, the invention relates to a system and method that enable personalized delivery of entertainment-related information in real-time, via natural language voice communication with a voice-enabled terminal device.

A system and method for analyzing and reporting data from multiple sources is provided. The system is a foundation for an analytical platform that covers not only traditional relational data, but also a new generation of extensible data formats designed for the web, such as those based on XML (FIXML, FpML, ebXML, XBRL, ACORD, etc.), as well as HTML, E-mail, Excel, PDF, and others. In a preferred embodiment, the eXtensible on-line analytical processing (XOLAP), is a scalable client / server platform that allows the multi-dimensional analysis of modern data types, as well as traditional relational data, by bringing them all into an internal common XML-based model, without the time and expense of creating a data warehouse.

A computer system provides access to both an online transaction processing (OLTP) database server and an online analytics processing (OLAP) database server. The computer system includes a client application adapted to receive a query. According to (a) mode of operation (e.g., read or update) of the client application and (b) synchronization status of the OLAP database server, the client application redirects the query to the OLTP database server or to the OLAP database server. The client application redirects the query to the OLTP database server when the mode of operation is other than a read-only operation or the synchronization status is “unsynchronized”. The client application redirects the query to the OLAP database server when the mode of operation is a read-only operation and the synchronization status is “synchronized”. The computer system further includes an OLTP application server (e.g., Enovia V6) comprising an OLTP adapter and an OLAP adapter. The OLAP adapter is formed of a mapping component adapted to map data between OLTP semantics and OLAP semantics.

A system and method for providing remote users with reports and analyses based on user data is disclosed. The reports are adaptable and the remote user can alter, modify, and argument the reports and analyses. Client data is extracted from a client device and other sources. The client data is quantified by analytic definitions. The analytic definitions are an identification of performance measures. The quantified data is queried and grouped according to the analytic definitions. Datamarts are created by separating the grouped data. The datamarts are then converted into on-line analytical processing (OLAP) cubes. The OLAP cubes are then used by the remote user to create adaptable reports. The adaptable reports may be used by practice professionals to understand their business and clinical operations, and to improve business performance and patient care.

According to the invention, techniques for profiling of human behavior based upon analyzing data contained in databases, data marts and data warehouses. In an exemplary embodiment, the invention provides for creating a dynamic customer profile by analyzing relationships in data from one or more data sources of an enterprise. The method can be used with many popular visualization tools, such as On Line Analytical Processing (OLAP) tools and the like. The method is especially useful in conjunction with a meta-model based technique for modeling the enterprise data. The enterprise is typically a business activity, but can also be other loci of human activity. The human behavior profiled is typically that of a customer, but can be any other type of human behavior. Embodiments according to the invention can display data from a variety of sources in order to provide visual representations of data in a data warehousing environment.

An improved method of and apparatus for aggregating data including a high-performance aggregation module (comprising a scalable multi-dimensional database (MDDB)) that is integrated into a database management system (DBMS). The DBMS includes a relational part comprising a relational datastore storing data in tables and support mechanisms. Bi-directional data flow occurs between the relational part and the integrated aggregation module whereby data stored in the relational datastore in loaded into the aggregation module and aggregated data stored in the MDDB of the aggregation module is communicated to the relational part. The improved DBMS can be used to realize achieving a significant increase in system performance (e.g. deceased access / search time), user flexibility and ease of use. The improved DBMS system of the present invention can be used to realize an improved Data Warehouse for supporting on-line analytical processing (OLAP) operations or to realize an improved informational database system, operational database system, or the like.

A method, a computer system and a computer program product for a computer system for transforming general On-line Analytical Processing (OLAP) hierarchies into summarizable hierarchies whereby pre-aggregation is disclosed, by which fast query response times for aggregation queries without excessive storage use is made possible even when the hierarchies originally are irregular. Pre-aggregation is essential for ensuring adequate response time during data analysis. Most OLAP systems adopt the practical pre-aggregation approach, as opposed to full pre-aggregation, of materializing only select combinations of aggregates and then re-use these for efficiently computing other aggregates. However, this re-use of aggregates is contingent on the dimension hierarchies and the relationships between facts and dimensions satisfying stringent constraints. The present invention significantly extends the scope of practical pre-aggregation by transforming irregulare dimension hierarchies and fact-dimension relationships into well-behaved structures that enable practical pre-aggregation.

The invention discloses a multi-dimensional OLAP (On Line Analytical Processing) inquiry processing method facing a column storage data warehouse. In the multi-dimensional OLAP inquiry processing method, the OLAP inquiry is decomposed into a bitmap filtering operation, a grouping operation and an aggregation operation. In the bitmap filtering operation, firstly, the predication is executed on a dimension table and a predicate vector bitmap is generated; and a connection operation is converted into a direct dimension table record access operation by surrogate key address mapping so as to implement access according to the positions. In the grouping operation, the pre-generation of grouping units is carried out on fact table records which meet the filtering conditions according to grouping attributes in an SQL (Structured Query Language) command and increasing IDs (identity) are distributed. In the aggregation operation, the grouping aggregation calculation which is carried out according to a grouping item of a grouping filtering vector of a fact table is implemented by carrying out column scanning on the metric attribute of the fact table for once. According to the invention, all OLAP processing tasks can be completed only by carrying out column scanning on the fact table for once, so that the cost of repeatedly scanning is avoided.

An improved method of and apparatus for aggregating data including a scalable multi-dimesional database (MDDB) and a high-performance aggregation engine that are integrated into a database management system (DBMS). The improved DBMS can be used to realize achieving a significant increase in system performance (e.g. deceased access / search time), user flexibility and ease of use. The improved DBMS system of the present invention can be used to realize an improved Data Warehouse for supporting on-line analytical processing (OLAP) operations or to realize an improved informational database system, operational database system, or the like.

A concurrent on-line analytical processing (OLAP)-oriented database query processing method is described, for performing, on the basis of predicate vector-based memory OLAP star-join optimization, concurrent OLAP query processing based on a batch query predicate vector bit operation. The concurrent query processing optimization technology is implemented for I / O performance and parallel OLAP processing performance in a database management system, and setting of concurrent OLAP processing load in an optimized way catering to the I / O performance is supported, thereby improving predictable processing performance oriented to diversified OLAP queries and implementing concurrent query star-join bitmap filtering processing based on predicate vector arrays.

The invention discloses an OLAP (On Line Analytical Processing) inquiry processing method facing a database and a Hadoop mixing platform. In the method, on the basis of a multicopy fault-tolerance mechanism of a Hadoop, when the OLAP inquiry processing is carried out, firstly, the OLAP inquiry processing is executed on a main working copy and an inquiry processing result is recorded into an aggregation result table of a local database; and when a working node goes wrong, node information of a fault-tolerance copy corresponding to the main working copy is searched by a namenode and a MapReduce task is called to complete the OLAP inquiry processing task on the fault-tolerance copy. According to the invention, a database technology and a Hadoop technology are combined and the storage performance of the database and the high extendibility and high availability of the Hadoop are combined by a mode of double storage engines and double inquiry processing engines; and the database inquiry processing and the MapReduce inquiry processing are integrated in a loosely coupling mode by utilizing a master-slave copy management mechanism so as to not only ensure the high inquiry processing performance, but also ensure the high fault-tolerance performance.

Embodiments relate to systems and methods for the generation of multi-population statistical measures on a set of data sources. A set of applications such as online analytical processing (OLAP) applications can access the combined data of a set of data sources via an aggregation engine. The set of data sources can be configured with diverse dimensions and associated data. In general the data sources may not be expected to reflect a strictly consistent structure. In embodiments, the aggregation engine can combine or aggregate the set of data sources using common dimensions or data points, and build an index into a transform table reflecting a combined mapping. An OLAP or other application can then perform statistical computations, searches, sorts, and / or other operations on the combined mapping, even when the original data sources do not contain identical dimensions or other formats.

The invention discloses a visualized on-line analytical processing (OLAP) application realizing method and a visualized OLAP application realizing system. The visualized OLAP application realizing method and the visualized OLAP application realizing system store business data analyzed by OLAP in Hadoop cluster which supports the distributed and column-oriented mode, and the effective dock of an on-line analytical platform and a Hadoop storage platform is realized through a structured query language (SQL) query engine supported by Hive and Impala. The visualized OLAP application realizing method and the visualized OLAP application realizing system increase the storage volume, improve the storage expansibility and safety, and effectively operate the hundred billion or even thousand billion data level on-line multidimensional statistical analysis and machine learning.

A system and method for generating an On-Line Analytical Processing (OLAP) query. A query object is provided that supports a plurality of OLAP servers which use different structured query formats. An OLAP server is determined from among the OLAP servers for which the query will be executed based on a property of the query object. The query object is processed to generate a query statement using the structured query format that corresponds to the determined OLAP server.

Embodiments relate to systems and methods for the hierarchical aggregation of multi-dimensional data sources. A set of applications such as online analytical processing (OLAP) applications can access the combined data of a set of multi-dimensional data sources via a transform engine. The set of data sources can be configured with diverse dimensions and associated data, which in general do not reflect a strictly hierarchical structure. In embodiments, the transform engine can combine or aggregate the set of data sources using common dimensions or data points, and build an index into a transform table reflecting the hierarchical level of dimension from each data source in a combined hierarchical mapping. An OLAP or other application can therefore perform searches, sorts, and / or other operations on the combined hierarchical mapping based on the resulting ordering of data, even when the original multi-dimensional data sources do not contain an explicit common hierarchy.

According to the invention, techniques for visualizing customer data contained in databases, data marts and data warehouses. In an exemplary embodiment, the invention provides a apparatus for graphically analyzing relationships in data from one or more data sources of an enterprise. The apparatus can be used with many popular visualization tools, such as On Line Analytical Processing (OLAP) tools and the like. The apparatus is especially useful in conjunction with a meta-model based technique for modeling the enterprise data. The enterprise is typically a business activity, but can also be other loci of human activity. Embodiments according to the invention can display data from a variety of sources in order to provide visual representations of data in a data warehousing environment.

A system and method for efficient data retrieval and processing in an online analytical processing system, a reporting system, a business intelligence system, or a data mining system. The system provides for retrieval and processing of a data result set from a plurality of data sources. The system includes a query structure assembly module, a syntax assembly module, and a process optimization module. The query structure assembly module defines a query structure based upon query assembly rules and a desired data set (such as the set of data for a particular OLAP report). The syntax assembly module defines one or more query language statements based upon the defined query structure. The process optimization module evaluates processing options based upon a database schema associated with the data sources. One or more query language statements may be assembled by the system and run against the data sources to return the desired data result set. A method and medium having processor readable code therein are also described.