159 results about "Aggregate function" patented technology

A system and method for providing attestation and / or integrity of a server execution environment are described. One or more parts of a server environment are selected for measurement. The one or more parts in a server execution environment are measured, and the measurements result in a unique fingerprint for each respective selected part. The unique fingerprints are aggregated by an aggregation function to create an aggregated value, which is determinative of running programs in the server environment. A measurement parameter may include the unique fingerprints, the aggregated value or a base system value and may be sent over a network interface to indicate the server environment status or state.

Systems and methods in accordance with various embodiments of the present invention provide for representing a hierarchical dataset as graphical elements in a configurable data visualization having at least one graphical attribute. At least one aggregate function of a plurality of aggregate functions are determined. Aggregate values of the hierarchical dataset for each hierarchical depth level is determined. The aggregate function is used to determine the aggregate values. The data visualization based on the aggregate values is rendered.

A method and system for text data analysis by performing deep syntactic and semantic analysis of text data and extracting entities and facts from the text data based on the results of deep syntactic and semantic analysis, including extraction of sentiments using a sentiment lexicon constructed upon a semantic hierarchy. The data analysis can include determining sign of the extracted sentiment, aggregate function of the text data, analyzing social mood, and classifying the text data.

A method, computer program product, and system for optimizing aggregate queries are provided. The method, computer program product, and system provide for receiving an aggregate query comprising a GROUP BY operation and an aggregate function, creating an access plan for executing the aggregate query, the access plan including a join between an outer relation and an inner relation, and designating the join included in the access plan as an early out join.

Techniques are provided for improving efficiency of database systems, and in particular, to refreshing materialized views maintained by database systems and rewriting queries to access the materialized views. According to the approaches, a ranked materialized view is incrementally refreshed, and during the incremental refresh operation, rows in the partitions of the materialized view are ranked within the partitions.

A risk analysis method uses a multi-dimensional risk representation that allows a standard OLAP engine to perform analysis on multi-dimensional data corresponding to a portfolio of financial positions. The analysis includes context-dependent, heterogeneous aggregation functions. The multi-dimensional data is represented as a multi-layered multi-dimensional cube (“outer” cube), which consists of dimensions and cells. Each cell includes a set of coordinates and an inner multi-dimensional cube (“inner” cube). Dimensions of the inner cube include all dimensions required for aggregations. Dimensions of the outer cube include only dimensions needed for context (or reporting). An aggregation is performed on the set of measures of the inner cube based on a context for the aggregation provided by the outer cube.

A method and a computer program product for identifying the domains, selecting for each domain one domain-specific search engine and data source to be involved, generating the domain-specific subqueries for each selected search engine, defining a strategy for sending requests to each search engine and data source, and receiving, merging and ranking results. The result of the multi-domain query is a list of combinations, where every combination consists of a tuple of data, each relative to one of the domains of the query; such data is present in the results returned either by search engines or by data sources. The method provides the combinations having the highest combination score, as computed by a monotone aggregation function over the combinations.

A system and method for information retrieval are disclosed. The method includes querying a multimedia collection with a first component of a multimedia query (e.g., a text-based part of the query) to generate first comparison measures between the first component of the query and respective objects in the collection for a first media type (e.g., text). The multimedia collection is queried with a second component of the multimedia query (e.g., an image-based part of the query) to generate second comparison measures between the second component of the query and respective objects in the collection for a second media type (e.g., visual). An aggregated score for each of a set of objects in the collection is computed, based on the first comparison measure and the second comparison measure for the object. This includes applying an aggregating function to the first and second comparison measures in which a first confidence weighting is applied to the first comparison measure and a second confidence weighting is applied to the second comparison measure. The first confidence weighting is independent of the second comparison measure. The second confidence weighting is dependent on the first comparison measure. Information based on the aggregated scores is output.

The invention discloses a multi-band frequency spectrum aggregating wireless transmitter-receiver device which is characterized in that multi-band simulating radio frequency front ends are aggregated; different radio frequencies are divided into 20 MHz and 60 MHz processing frequency bands; analog-to-digital conversion while receiving a base-band signal and digital-to-analogue conversion while sending are performed in low and intermediate frequencies; and a signal treatment relative to a base-band NC-OFDM modulation-demodulation is performed by a sending base-band processing channel and a receiving base-band processing channel which are dynamically arranged. The invention solves the problem that the prior mobile communication terminal cannot work in multi-band at the same time during the communication process and only can use continuous frequency spectrums. The frequency spectrum aggregating function of the transmitter-receiver device realizes a data rate required by an IMT-Advanced system.

A method and apparatus are provided for determining the probability that one or more problems have occurred within a complex multi-host system. A probabilistic model representing the cause / effect relationships among potential system problems identifies the probability that a problem occurred in the system based at least on system measure states that are input into the probabilistic model. System measure states may be determined based on an aggregation of system measurement values taken periodically. Aggregating system measurement values may be performed over system measurement values that were taken during a recent time interval. A rolling count aggregation function may be used for this purpose. A rolling count function counts the number of system measurement values taken within the recent time interval that lie within a particular range of values. A system measure state may be determined based on whether the rolling count exceeds a threshold associated with the system measure.

Methods are provided for efficiently evaluating database queries including multiple rollup operators. With the computation of grouping identifiers to distinguish grouping levels of each rollup operator, evaluation of database queries that include concatenation of rollup operators includes nesting of the rollup operators and includes the grouping identifiers as sorting keys for subsequent processing. Furthermore, to optimize the query evaluation process, the order in which the rollup operators are computed can be determined based on cardinalities that estimate the number of records generated by each rollup operator, and parallel evaluation can be utilized by partitioning data records between rollup operator processing stages based on the grouping keys associated with the rollup operators that are not being processed at the next stage. If the query includes an algebraic aggregate function, the algebraic function is represented as distributive functions, which are propagated through the evaluation stages and used to compute the algebraic function at the final rollup stage.

Techniques are disclosed for managing a commodity resource in a distributed network by aggregating marginal demand functions or marginal supply functions, depending on whether a node is a commodity consumer or a commodity producer, and determining an optimal allocation / production based on the aggregated function. By way of example, the commodity being managed may be an energy-based commodity such as electrical energy. In such case, the distributed commodity resource-based network may be a distributed electrical grid network.

The invention discloses a method and device for aggregate query in distributed databases. The method comprises the steps of receiving an original SQL query statement sent by a client side; obtaining a query column of the original SQL query statement and an aggregate function in condition subquery; in the aggregate function, transforming the complicated aggregate function for multilist computation into a simple aggregate function; according to the simple aggregate function, updating the original SQL query statement into a new SQL query statement; sending the new SQL query statement to two or more databases for querying and receiving the returned query result of the query column; according to the query result and the new SQL query statement, calculating and obtaining the query result of the original SQL query statement. According to the method and device, aggregate query in the databases of multiple computers is achieved, it is not needed to write aggregate processing logic in an application program, and therefore the development time of the application program is shortened.

Property store information and an aggregation of a plurality of ranking mechanisms, including a learning mechanism, are leveraged to provide performant query results with increased user relevancy. The learning mechanism permits query feedback to be accepted to facilitate in optimizing user relevance. This mechanism can also be incorporated with traditional Information Retrieval (IR) components, each supplying independent ranking to a relevance aggregation function that determines relevancy at a high level. This precludes diminishing the value of query feedback that occurs when the data is fed into traditional IR algorithms. By allowing the query feedback to maintain its proper weighting and utilizing scope and bias capabilities of the property store information, relevance increases in a highly performant manner.

An On-Line Analytic Processing (OLAP) system identifies a plurality of simultaneously computable moving aggregate functions in a query. The identified moving aggregate functions are then partitioned into sets that can be computed simultaneously based on equivalent sort expressions. Finally, the OLAP system generates an access plan that executes the partitioned sets simultaneously.

A computer-implemented method of using a database management system (DBMS) for providing an aggregate of a plurality of entities, constructing an aggregate of said plurality of entities in a memory to provide a result, and returning the result from the memory. Constructing the aggregate in memory includes storing in the memory a plurality of intermediate aggregation results each associated with a unique identifier. The unique identifier for each intermediate result is stored in the DBMS. Each unique identifier indicates information identifying a position within a sequence of generating the intermediate result and a pointer to a location in the memory where that intermediate result is stored.

Systems and methods for conducting attribute-based queries over a plurality of objects using bounded memory locations and minimizing costly input and output operations are provided. A plurality of attributes are associated with each object, and a plurality of data groups, one each for the identified attributes are created. The objects associated with the attributes are placed into the appropriate data groups, and the objects contained within each data group are sorted into blocks such that each block within a given attribute contains that objects having the same attribute value. Results to the query are created by loading blocks into a primary memory location in a middleware system and combining the loaded blocks to create the desire query results. Block combinations are created based upon the fit of the given block combination to the query as expressed in an aggregation function. A second dedicated memory location can also be provided to hold multiple block combinations to optimize the order in which blocks are loaded and combined. Empty block buffers and external storage devices can also be provided to further enhance the generation of query results.

The invention discloses a method for monitoring the compaction of a concrete-filled steel tube structure based on a piezoelectric intelligent aggregate and a sending and receiving interactive approach, belonging to the field of monitoring the compaction status of the concrete-filled steel tube structure. The method comprises the following steps: embedding the piezoelectric intelligent aggregates in pairs in the concrete-filled steel tube structure in advance; excitating the intelligent aggregates through a signal generator; collecting the output signal of the piezoelectric intelligent aggregates corresponding to the inner part of a concrete-filled steel tube through a signal collection system; interchanging two intelligent aggregate functions; repeatedly excitating and signal receiving processes; carrying out analytical processing on the signals acquired at two times, so as to obtain the index of similarity level of the signals acquired at two times; and estimating the compaction status in the concrete-filled steel tube by utilizing the index. The method provided by the invention can be used for rapidly monitoring the compaction status of the concrete-filled steel tube, can be used for accurately finding out the damage position, and has high sensitivity and rapid response, and low price, and is simple in operation.

A system and method for providing attestation and / or integrity of a server execution environment are described. One or more parts of a server environment are selected for measurement. The one or more parts in a server execution environment are measured, and the measurements result in a unique fingerprint for each respective selected part. The unique fingerprints are aggregated by an aggregation function to create an aggregated value, which is determinative of running programs in the server environment. A measurement parameter may include the unique fingerprints, the aggregated value or a base system value and may be sent over a network interface to indicate the server environment status or state.

The invention discloses a system and a method for distributed complex event detection under an RFID (Radio Frequency Identification Devices) equipment network environment. The system comprises a server side, a client side, an RFID recognizer and a label which can be recognized by the recognizer, wherein the server side comprises a used input processing unit, an event analyzing unit, a task queue generating unit, a detection task sharing unit and a task monitoring unit; the client side comprises a task acquisition unit, a task analyzing unit, an event generating unit, an event filtering unit, a task processing unit and a task output unit. Compound event detection under the RFID equipment network environment is realized through event filtering, compound event detection and the event processing of an event aggregate function. The system supports distributed environments, multiple event construction symbols, non-spontaneous events and aggregated events.

The invention relates to an ecology environment protection type regenerating aggregate function wall board and its manufacturing method. In our country, the builders rubbish caused by pulling down the old residence and building new reaches from forty million ton to sixty million ton every year. The comprehensive utilization ratio and level of the builders rubbish are quite low from long time, and the existing builders rubbish brick or building blocks belong to the extensive low affixation utilization ratio. The ecology environment protection type regenerating aggregate function wall board and its manufacturing method of the invention are that the builders rubbish is sorting machining and disintegrated, then formed different aggregates, used as the filler of the different wall board, produced into functionality wall board such as building sound proof wall board, building fireproofing partition wall board, building heat preservation wall board, outer wall board, outer wall composite wall board, and so on, according to the building function material principle. It gives prominence to the building function of the wall board, improves the level of its service performance, as well as effectively improves the affixation value of the comprehensive utilization of the builder rubbish. And it possesses notable economic and social benefit.

Techniques are provided for improving efficiency of database systems, and in particular, to refreshing materialized views maintained by database systems and rewriting queries to access the materialized views. According to the approaches, a ranked materialized view is incrementally refreshed, and during the incremental refresh operation, rows in the partitions of the materialized view are ranked within the partitions.

The present invention provides a video motion identification method based on a time domain segmentation network. The main content of the method comprises: time domain segmentation network (TSN) based on segmented sampling, clustering function and analysis, time domain segmentation network input and training strategy and motion identification in non-cutting video. The process of the method comprises: dividing video into equal continuous time, randomly extracting one segment from corresponding segments, each segment in a sequence generating motion-level segment-stage prediction, designing a common function, aggregating the segment-level prediction into a video-level score, and in the training process, defining an optimal target in the video-level prediction, and performing optimization through an iteration updating model parameters. The sampling and aggregation modules based on segmentation are employed to establish a long-term time structure to use the whole motion video to effectively learn a motion model, store long-term video and improve the sensitivity and accuracy for the detection and identification of the motion.

A new ecosystem monitoring solution provides novel features including a dashboard service, a dashboard notifier, a near real time query processor. The dashboard service can continuously aggregate, through the dashboard notifier and optionally dashboard agents, metadata from disparate ecosystem components of a complex computing platform or ecosystem. The metadata include metrics of crawling, data ingestion, and content enrichment activities and health information of the disparate ecosystem components. The metrics are processed with respect to a time window utilizing an expression tree dynamically constructed by the query processor. The query processor can navigate the expression tree to form collection models. Each collection has aggregation functions for aggregating a set of metrics specified in a view model. Responsive to a view request, the view model can be dynamically updated utilizing the collection model and communicated to a user device for rendition and presentation of a view through a dashboard user interface.

A system and method transform queries with subqueries, using window aggregation. An optimizer in a relational database management system transforms queries to optimize their efficiency and speed. The method transforms queries that have a subquery, replacing the subquery with a window aggregation function. In the case of a correlated subquery, the window aggregation function is partitioned by a correlated column of a correlated table. All data in the main select clause, or outer block, of the query that was obtained through references to the correlated table is instead obtained through the new window aggregation subquery. By using window aggregation, the aggregation is performed at the same time as the selection of relevant data from the correlated table, thereby compiling all needed data in a single pass through the table or view. Reducing the number of times that tables or views are accessed reduces the computational demands of a query.

A system and method for information retrieval are disclosed. The method includes querying a multimedia collection with a first component of a multimedia query (e.g., a text-based part of the query) to generate first comparison measures between the first component of the query and respective objects in the collection for a first media type (e.g., text). The multimedia collection is queried with a second component of the multimedia query (e.g., an image-based part of the query) to generate second comparison measures between the second component of the query and respective objects in the collection for a second media type (e.g., visual). An aggregated score for each of a set of objects in the collection is computed, based on the first comparison measure and the second comparison measure for the object. This includes applying an aggregating function to the first and second comparison measures in which a first confidence weighting is applied to the first comparison measure and a second confidence weighting is applied to the second comparison measure. The first confidence weighting is independent of the second comparison measure. The second confidence weighting is dependent on the first comparison measure. Information based on the aggregated scores is output.