Patent application number | Description | Published |
20120117054 | Query Analysis in a Database - A method of analyzing an expression to infer output data properties, comprises storing, in a storage device, a root node “e” in R, in which “e” is an expression and R is a root node of an abstract syntax tree (AST) of the expression “e”, storing a number of child nodes of R into C | 05-10-2012 |
20120290590 | CONSTRUCTING A PROJECTION FOR STORING DATA - A method for constructing a projection for storing data on a storage device may include causing a processor to extract characteristics of expected output of a query on the data, and to construct a projection for the data based on the extracted characteristics. | 11-15-2012 |
20120290615 | SWITCHING ALGORITHMS DURING A RUN TIME COMPUTATION - A system and method for switching algorithms during a run time computation, the method including configuring hardware of a networked cluster of processing elements, each processing element with a memory hierarchy, to perform a first-tier algorithm on input data, the input data having cardinality and stored on one or a plurality of nodes in the networked cluster. Performing at least a portion of a second-tier algorithm and determining whether to complete the second-tier algorithm and perform a third or subsequent tier algorithm, the determination dependent on cardinality. Automatically passing data to an output if the cardinality of the second-tier algorithm is greater than a threshold cardinality, and passing the data back to the second-tier algorithm or to one or a plurality of subsequent algorithms, in response to the cardinality being less than the threshold, and automatically passing the data to an output at the completion of the data processing. | 11-15-2012 |
20130290287 | EXECUTING USER-DEFINED FUNCTION ON A PLURALITY OF DATABASE TUPLES - A method for executing a user-defined function on a plurality of input database tuples. The method may include causing a processor to invoke the function once; and to compute results of the function for the plurality of database tuples. | 10-31-2013 |
20130290294 | EVALUATION BY NESTED QUERIES - A system, method, and non-transitory computer readable medium are disclosed herein to optimize nested queries. At least one field is associated with each row of data evaluated by at least one nested query. A value is assigned to the at least one field so as to indicate whether each row of data satisfies the at least one nested query. The at least one field associated with each row of data is evaluated to determine satisfaction of the at least one nested query. | 10-31-2013 |
20140324889 | EXECUTING USER-DEFINED FUNCTION ON A PLURALITY OF DATABASE TUPLES - According to an example, in a method for executing a user-defined function on a plurality of database tuples, the user-defined function and an analysis function may be obtained. In addition, the plurality of database tuples may be divided into parts by a processor, the processor may be caused to execute the analysis function on each of the parts, and the processor may be caused to execute the user-defined function on at least one of the parts for which the analysis function returned a true predicate. | 10-30-2014 |
20150052107 | OBJECT DEPENDENCY MANAGEMENT - A method for object dependency management for historical access includes assigning versions to states of a structure for storing objects, and assigning the versions to dependency changes between the objects. The method further includes managing historical access to the objects based on an analysis of the versions and the dependency changes between the objects. | 02-19-2015 |
20150088865 | QUERY PROCESSING - A method for query processing includes receiving a query, and determining a query type by determining if the query is a structured query language (SQL) query including multiple distinct aggregates (MDAs), or a SQL query including cube, rollup or grouping sets operations. Based on the determination, the method includes processing the query to generate an output, and performing a predetermined number of maximum group by operations on the output based on the query type to generate a response to the query. | 03-26-2015 |