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 query processing device is provided, including a processor coupled to a communication interface and a query storage. The processor receives a current submission of a query in a training mode, a stored prior execution plan, and stored statistics for the prior execution plan. The processor generates a current execution plan for the query, executes the current execution plan, and collects statistics. The processor stores the current execution plan and the statistics in the query storage and determines, based on the current execution plan, that the query is not in the training mode. The processor selects an execution plan for the query from among a plurality of stored execution plans for the query, including the prior execution plan and the current execution plan, and stores the selected execution plan for the query in the query storage with an indication that the query is not in the training mode.

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 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.

Abstract: A method implemented in a network element (NE) configured to operate as an Ensemble Information Broker (EIB) within a distributed data and energy storage internet architecture comprising collecting energy data indicating a flow of energy, an amount of energy consumed and generated by devices; collecting human presence data; collecting human activity data; predicting future energy consumption requirements and generation by employing prediction algorithms and analyzing the collected data; generating a set of control commands based on the predicted future energy consumption requirements and energy generation as applied to a cost function; transmitting the set of control commands to the corresponding devices; transmitting a broadcast message to determine an external NE to establish as a friend connection based on a user preference; transmitting a request to establish a friend connection with the determined NE; and transmitting the human presence data to the external NE when the friend connection is established.

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 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 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 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 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 for dynamically building a column store database from a row store database. The method includes establishing the row store database for storing data, wherein each row includes a plurality of attributes, and wherein data in row store database is current to a temporal point in time. The method includes establishing the column store database including data structured to satisfy received analytic queries. The method includes beginning from an initial state of the column store database, for each subsequently received analytic query, importing a targeted amount of data from a corresponding temporal state of the row store database into the column store database to satisfy the corresponding subsequently received analytic query.

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 implemented in a network element (NE) configured to operate as an Ensemble Information Broker (EIB) within a distributed data and energy storage internet architecture comprising collecting energy data indicating a flow of energy, an amount of energy consumed and generated by devices; collecting human presence data; collecting human activity data; predicting future energy consumption requirements and generation by employing prediction algorithms and analyzing the collected data; generating a set of control commands based on the predicted future energy consumption requirements and energy generation as applied to a cost function; transmitting the set of control commands to the corresponding devices; transmitting a broadcast message to determine an external NE to establish as a friend connection based on a user preference; transmitting a request to establish a friend connection with the determined NE; and transmitting the human presence data to the external NE when the friend connection is established.

Abstract: The present invention is directed to a novel, a topic-based messaging architecture (including schema, protocols, naming conventions, etc.) to be used in a distributed data-oriented OLTP environment. According to an aspect of the claimed subject matter, the topic-based messaging architecture can be implemented as a type of publication-subscription (“pub-sub”) messaging pattern. In one or more embodiments of the topic-based system, messages are published to “topics,” or named logical channels. Subscribers in a topic-based system will receive all messages published to the topics to which they subscribe, and all subscribers to a topic will receive the same messages. The publisher is responsible for defining the classes of messages to which subscribers can subscribe. The topic-based messaging interface improves the scalability of a distributed database management system and provides a robust mechanism for message delivery.

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.

Abstract: A method for dynamically building a column store database from a row store database. The method includes establishing the row store database for storing data, wherein each row includes a plurality of attributes, and wherein data in row store database is current to a temporal point in time. The method includes establishing the column store database including data structured to satisfy received analytic queries. The method includes beginning from an initial state of the column store database, for each subsequently received analytic query, importing a targeted amount of data from a corresponding temporal state of the row store database into the column store database to satisfy the corresponding subsequently received analytic query.

Abstract: A method for adaptively building and updating a column store database from a row store database using queries. The method includes establishing the row store database for storing data, wherein at least one row of the row store includes attributes. The method includes establishing the column store including data structured to satisfy received analytic queries, wherein the column store includes attribute vectors corresponding to attributes in the row store, wherein at least one of the attribute vectors includes data used to satisfy previously received analytic queries. The method includes receiving change transactions directed to the row store, wherein the change transactions are ordered. The method includes when a first referenced attribute referenced by an analytic query corresponds to an attribute vector in the column store, updating the attribute vector based on log information corresponding to change transactions directed to the referenced attribute to satisfy the analytic query.

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.