Abstract: An OLAP-based method and system for profiling customer behavior that can be utilized to detect telecommunication fraud. First, call records are received. Next, a calling profile cube (e.g., a multi-customer profile cube) is generated based on the call records. A volume-based calling pattern cube (e.g., a calling pattern cube for each individual customer) is then generated based on the multi-customer profile cube. The volume-based calling pattern cube is then compared with known fraudulent volume-based calling patterns. If the similarities generated by the comparison reaches or exceeds a predetermined threshold, then the particular caller with the calling pattern being analyzed is considered suspicious. In this manner, suspicious calling activity can be detected, and appropriate remedial actions, such as further investigation or the cancellation of telephone services, can be taken.

Abstract: A system and method for processing data are described. The method quantizes a portion of data processed at a first node within a distributed database processing system to generate one or more quantization tuples, aggregates the tuples at the node to create a plurality of aggregated tuples, and transmits the aggregated tuples to a second node within the distributed database processing system.

Abstract: A query engine receives a continuous stream of data and applies a Structured Query Language (SQL) query to the data. The data is processed on a chunk-by-chunk basis with a query rewind mechanism that sustains the SQL query as a single long-standing query that allows a state of the SQL query to be maintained.

Abstract: A method and system for processing a data stream are described. The method executes, until the occurrence of a cut condition, a map function from a set of query processing steps to generate map results for a first portion of the data stream, executes a reduce function from the set of query processing steps to generate history-sensitive data from the map results, and rewinds the set of query processing steps, without termination of processing. The history-sensitive data is maintained for a second execution of the map function and reduce function on a second portion of the data stream.

Abstract: A database system executes a method that receives, at a query engine in the database system, a continuous stream of data. The query engine continuously analyzes the continuous stream of data with window functions in a single long-standing query.

Abstract: A data processing system and method for processing images received from multiple cameras are provided. The system includes a memory for receiving first and second images associated with respective cameras; a determiner adapted to process the first and the second images to identify respective objects depicted therein; the determiner is further adapted to calculate a predetermined metric associated with projections of the respective objects in a first frame of reference; and a labeler adapted to assign a common label to the objects according to the predetermined metric.

Abstract: A method is provided for generating a user-defined function (UDF) on a database engine of a database server. A user-function is sent to the database engine. The user-function includes a relational declaration with application and query logic. When the database engine receives the user-function, the database engine generates a function shell. The UDF processes the relational declaration of the user-defined function. The UDF includes the user-function and the function shell. The function shell returns a final data result of the user-defined function through the shell from the database engine.

Abstract: Methods, systems, and computer program products are provided for performing structured parallel data intensive computations. A SQL-FCF framework that defines a SQL construct based interface for performing the computations is provided. The computations within an application are coded as table valued functions (TVFs). Data for the application is partitioned into data partitions to co-locate and load balance the data partitions and corresponding computations. The TVFs are invoked and applied to corresponding ones of the data partitions in a structured order defined by function control forms (FCF).

Abstract: A method and system for generating recommendations are described. The method of generating a recommendation list of products to a customer comprises using OLAP (On-Line Analytical Processing) to analyze raw data in a multilevel and multidimensional manner. Furthermore, the method includes applying a plurality of filtering processes to the raw data to generate a plurality of preliminary recommendation lists. Moreover, the method further comprises generating the recommendation list based on the plurality of preliminary recommendation lists.

Abstract: Middleware is integrated within a database engine. The middleware is to execute a functional-form query representing a dataflow graph comprising queries and relation valued functions. The middleware is to interact with the database engine to cause the database engine to execute the queries. Each relation valued function receives a plurality of first relations as input and generates a second relation as output.

Abstract: Methods, database management systems (“DBMS”) and computer-readable media are provided for processing unbounded stream data using a traditional DBMS. Execution of a query that includes a data stream as a data source may be initiated. Tuples may be processed in accordance with the query as the tuples are received through the data stream until an indication is received that execution of the query should cease.

Abstract: A data warehouse that operates to receive a spatial query and return a spatial result for the spatial query, the data warehouse comprises a regular database operating to receive and process a regular query and return a query result in response to the regular query. The data warehouse also comprises an interface layer implemented external to the regular database and operating to intercept the spatial query and translate the spatial query into the regular query for processing by the regular database. The regular database includes at least one spatial index that is accessed by the interface layer to translate the spatial query into the regular query for processing by the regular database.

Abstract: A system for provisioning a geographical image for retrieval, comprising: an application server operating to receive a query for a geographical region in a geographical area of coverage; and a database server operating to store a plurality of geo-image tiles that cover the geographical area of coverage at different zoom levels, the database server is coupled to the application server to receive the query from the application server and return one or more of the plurality of geo-image tiles to illustrate the geographical region requested in the query; wherein the plurality of geo-image tiles are partitioned for storage in the database server in accordance with a database management system (DBMS) scheme and indexed or retrieval with a non-spatial index.

Abstract: One embodiment is a method that uses MapReduce and Relation Valued Functions (RVFs) with parallel processing to search a database and obtain search results.

Abstract: A method is provided for generating a user-defined function (UDF) on a database engine of a database server. A user-function is sent to the database engine. The user-function includes a relational declaration with application and query logic. When the database engine receives the user-function, the database engine generates a function shell. The UDF processes the relational declaration of the user-defined function. The UDF includes the user-function and the function shell. The function shell returns a final data result of the user-defined function through the shell from the database engine.

Abstract: A customer profiling apparatus is provided for conducting customer behavior pattern analysis. The apparatus includes processing circuitry, a data warehouse, a profiling engine, and at least one computer program. The processing circuitry is operative to process customer records. The data warehouse is coupled with the processing circuitry and is configured to store the processed customer records. The profiling engine communicates with the data warehouse and is operative to build and update customer behavior profiles by mining the customer records that flow into the data warehouse. The at least one computer program is performed by the profiling engine, and is operative to define behavior profiles as data cubes and derive similarity measures on patterns extracted from the behavior profiles. A method is also provided.

Abstract: A method and system for peer to peer common channel collaboration. The method includes exchanging collaboration messages between a plurality of proxies. The collaboration messages are configured for mediating communication between a corresponding plurality of servers. Each server is associated with a corresponding proxy. The execution of data transfers between the servers is controlled through a mediation implemented by the proxies.

Abstract: One embodiment is a method that repeatedly triggers a User Defined Function (UDF) that generates a data stream. A data continuous Structured Query Language (SQL) query is applied to the data stream to construct a data continuous SQL process (DCSP) which executes in a database.

Abstract: The present invention relates to devices and methods that coordinate an external conversation process between entities with an internal workflow of one of the entities. More particularly, it relates to devices and methods that are compliant with an inter-enterprise conversation process standard for routing electronic commerce documents between enterprises. Particular aspects of the present invention are described in the claims, specification and drawings.

Abstract: Methods, systems, and computer program products are provided for processing correlated queries in a collaborative, role-based, peer-to-peer (P2P) execution system. A correlated query is configured in accordance to a collaborative correlated query process (CQP) template. The collaborative CQP template defines roles and steps, each step being executable by one of the roles. A role is assigned to each peer node of the P2P system. A peer node having a designated role executes a step that is executable by the designated role. A message is communicated to other P2P nodes to indicate completion of the step. Another peer node having a matching role to a next step in the correlated query executes the next step in response to the message.