Abstract:
A query processing device includes a communication interface accessing a database and database catalog, a memory storing instructions, and a processor coupled to the memory and the communication interface. The processor executes the instructions to parse a query and generate first and second execution plans for the query, retrieve respective previously determined cardinality values for previously executed logical steps of the first and second execution plans from the database catalog, select an execution plan from the first execution plan or the second execution plan, the selected execution plan having a lower cost based on the previously determined cardinality values, and execute the selected execution plan on data accessed from the database. The query processing system stores actual cardinality values determined during the execution of the logical steps in the database catalog for use by subsequent queries. The query processing device, therefore, re-uses previously determined cardinality values.
Abstract:
A method implemented by a database system, comprising generating, by a processor of the database system, a plurality of join requests to at least two database tables with a common field responsive to a plurality of data requests, identifying, by the processor, at least two intervals of data with the common field using the plurality of join requests, creating, by the processor, a shadow table comprising the at least two intervals of data with the common field, wherein the shadow table comprises a plurality of fields from the at least two database tables, and wherein the plurality of fields are identified based on at least one of the join requests, storing, in a memory coupled to the processor, the shadow table, and generating, by the processor, a response to a subsequent data request using data stored in the shadow table.
Abstract:
A system and method for performing self-learning for adaptively achieving passenger comfort enhancement in an autonomous vehicle. The system comprises a plurality of sensor inputs. Each sensor input provides data representative of voice responses and image responses from a passenger in the vehicle. A controller is coupled to the plurality of sensor inputs. The controller generates and updates a reward function that includes a plurality of driving state transitions. The reward function is updated based on destination information and the data representative of the voice and image responses. The controller further generates a goal function that determines an optimized driving state transition updates the goal function based on the updated reward function and a previous goal function. The controller also generates a vehicle speed control signal, based on the updated goal function, to control the speed of the autonomous vehicle.
Abstract:
A method of dynamically computing an optimal materialization schedule for each column in a column oriented RDBMS. Dynamic column-specific materialization scheduling in a distributed column oriented RDBMS is optimized by choosing a materialization strategy based on execution cost including central processing unit (CPU), disk, and network costs for each individual exchange operator. The dynamic programming approach is computationally feasible because the optimal schedule for a sub-plan is path independent.
Abstract:
A query processing device includes a communication interface accessing a database and database catalog, a memory storing instructions, and a processor coupled to the memory and the communication interface. The processor executes the instructions to parse a query and generate first and second execution plans for the query, retrieve respective previously determined cardinality values for previously executed logical steps of the first and second execution plans from the database catalog, select an execution plan from the first execution plan or the second execution plan, the selected execution plan having a lower cost based on the previously determined cardinality values, and execute the selected execution plan on data accessed from the database. The query processing system stores actual cardinality values determined during the execution of the logical steps in the database catalog for use by subsequent queries. The query processing device, therefore, re-uses previously determined cardinality values.
Abstract:
A method of dynamically computing an optimal materialization schedule for each column in a column oriented RDBMS. Dynamic column-specific materialization scheduling in a distributed column oriented RDBMS is optimized by choosing a materialization strategy based on execution cost including central processing unit (CPU), disk, and network costs for each individual exchange operator. The dynamic programming approach is computationally feasible because the optimal schedule for a sub-plan is path independent.
Abstract:
A multiple disk loader apparatus includes a plurality of rods. Each rod has a pair of pins extending radially from a side of the rod. The pair of pins are spaced circumferentially around the rod with respect to each other. Each pin has a top surface wherein the top surface of a first pin is longitudinally separated from the top surface of a second pin by a predetermined gap. A rotation device is coupled to the plurality of rods. The rotation device rotates the plurality of rods individually through a respective predetermined arc and in a respective rotational direction in order to extract a disk stack from storage and to separate a disk from the stack to load into a drive.
Abstract:
A method implemented in a network element (NE) configured to operate as an Ensemble Information Broker (EIB) within a data and energy storage internet architecture, the method comprising collecting device data, human presence data, and human activity data; determining predicted human behaviors for the user; determining a predicted energy metric for the smart system during a future time slot; calibrating weighted objective metrics of an operating status of the devices, a human comfort level, and a human productivity level according to the predicted human behaviors and user defined preference levels defined for the smart system; generating a set of control commands for the devices within the smart system by executing the dynamic human-centric Objective Function on the predicted energy metric; and transmitting, via a transmitter, the set of control commands to corresponding devices within the smart system.
Abstract:
A method includes traversing a query plan tree having multiple nodes, each node representative of an operation on data that is the subject of a query, to extract multiple pipelines from the query plan tree, identify dependencies between the multiple extracted pipelines, and provide a pipeline dependent tree based on the dependencies between the multiple extracted pipelines for execution of the query by multiple processors.
Abstract:
A method for updating a column store database and includes establishing a row store database, wherein each row comprises a plurality of attributes. The method includes establishing a column store database including attribute vectors corresponding to at least one attribute in the row store, wherein each attribute vector includes data used to satisfy at least one of previously received analytic queries. The method includes collecting a SQL change statements beginning from a synchronization point indicating when the row store database and the column store database are synchronized, and continuing until an analytic query is received. The method includes sending the plurality of SQL change statements to the column store database upon receipt of the analytic query for updating the column store database for purposes of satisfying the query, wherein the analytic query is directed to a queried range of primary key attributes in the plurality of attributes.