Abstract: A system and method for displaying data using temporal granularities. The method includes determining at least one first dataset of a plurality of datasets based on at least one temporal data requirement, wherein the plurality of datasets is generated based on a data model, wherein each of the plurality of datasets is generated based further on a distinct temporal granularity of a plurality of temporal granularities, wherein the distinct temporal granularity of each of the at least one first dataset meets at least one of the at least one temporal data requirement; and querying the determined at least one first dataset in order to obtain at least one query result.

Abstract: A system and method for providing an improved user interface for executing data operations. A method includes: identifying a first node and a second node from different connections graphs, each node representing a respective user account, the user accounts of the first and second nodes sharing at least one common attribute; generating, based on the different connections graphs, an influence indicator for each of the first node and the second node; identifying a data operation executed by the first node on a dataset when the influence indicator of the first node is higher than the influence indicator of the second node, wherein the identified data operation causes generation or retrieval of business intelligence system data when executed; and sending data indicating the identified data operation to a device of the second node, wherein the device is configured to display a user interface including the identified data operation.

Abstract: A system and method for generating data visualizations. The method includes generating an enriched data layer based on a plurality of knowledge graphs, the plurality of knowledge graphs including a plurality of first nodes, the enriched data layer including a plurality of second nodes, wherein each of the plurality of second nodes is connected via an edge to at least one of the plurality of first nodes; and generating a data visualization based on the enriched data layer and a request for data, wherein the request for data indicates a type of data corresponding to at least one of the plurality of second nodes, wherein the data visualization is generated using data represented by at least one of the plurality of first nodes connected to the at least one of the plurality of second nodes.

Abstract: A system and method for providing visual data for user interfaces based on a knowledge graph. A method includes identifying at least one second node with respect to a first node based on connections between nodes of a knowledge graph, wherein the knowledge graph includes the first node and the at least one second node, wherein the first node represents a dimension of interest; selecting at least one third node from among the at least one second node by determining a correlation between the first node and each of the at least one second node; determining a new value for a dimension of each of the at least one third node based on a target value such that the correlation of the third node to the first node is maintained while achieving the target value; and generating visual data for an action item user interface based on the new values.

Abstract: A system and method for representing query elements in an artificial neural network. A method includes generating a translation table based on a plurality of query elements, wherein the translation table maps a plurality of vectors to the plurality of query elements, wherein each of the plurality of vectors is mapped to at least one query element of the plurality of query elements, wherein a first vector of the plurality of vectors is mapped to at least two query elements of the plurality of query elements; converting a plurality of input query elements into respective numerical representations using the translation table; and generating a result for a database query based on the numerical representations.

Abstract: A system and method for generating a semantic graph. The method includes: parsing each of a plurality of events into a plurality of objects, wherein the plurality of events includes a plurality of queries, wherein each event of the plurality of events is related to an interaction with at least one data source; determining, for each of the plurality of events, a relationship between two objects of the plurality of objects; and generating a semantic knowledge graph based on the determined relationships, the semantic knowledge graph including a plurality of query nodes and a plurality of edges, wherein each query node corresponds to a respective object of the plurality of objects, wherein each query node is connected to another query node of the plurality of query nodes by one of the plurality of edges, wherein each edge represents a relationship between the objects connected by the edge.

Abstract: A system and method for accelerating relational functions between tables. The method includes: determining a plurality of first index values for a plurality of first unique keys in a first column of a first table; determining a plurality of second index values for a plurality of second unique keys in a second column of a second table; generating a hashed third table based on the first column of the first table and the plurality of first index values; generating a hashed fourth table based on the second column of the first table and the plurality of first index values; and generating a fifth table by performing a JOIN operation between the third table and the fourth table based on at least one third column, wherein each of third column includes a plurality of third unique keys that are common between the third table and the fourth table.

Abstract: A system and method for partitioning data based on authorization rules. The method includes initiating a plurality of data nodes, each data node including a dataset generated based on a shared data model, wherein each of the plurality of data nodes corresponds to at least one authorization rule, wherein each authorization rule authorizes at least one user identifier to access a respective data node of the plurality of data nodes; and configuring an extract, transform, and load (ETL) application service to extract data from a data source and to load data from the data source to the dataset stored on a first data node of the plurality of data nodes when the at least one first authorization rule authorizes a requesting user to access the first data node.

Abstract: A system and method for displaying data using temporal granularities. The method includes determining at least one first dataset of a plurality of datasets based on at least one temporal data requirement, wherein the plurality of datasets is generated based on a data model, wherein each of the plurality of datasets is generated based further on a distinct temporal granularity of a plurality of temporal granularities, wherein the distinct temporal granularity of each of the at least one first dataset meets at least one of the at least one temporal data requirement; and querying the determined at least one first dataset in order to obtain at least one query result.

Abstract: A method, computer system and computer program product, the method comprising: upon receiving a database query comprising at least a first and a second join operations: storing the database query in the memory; identifying by the processor within the database query the first join operation, wherein the first join operation is a many-to-many join operation or a one-to-many join operation between a first table and a second table, in which fields of the second table are used only for filtering rows from the first table or for joining with another table; and converting by the processor the first join operation to an enhanced operation which eliminates returning at least two matches for at least one row from the first table when the database query is executed.

Abstract: A system and method for partitioning data based on authorization rules. The method includes initiating a plurality of data nodes, each data node including a dataset generated based on a shared data model, wherein each of the plurality of data nodes corresponds to at least one authorization rule, wherein each authorization rule authorizes at least one user identifier to access a respective data node of the plurality of data nodes; and configuring an extract, transform, and load (ETL) application service to extract data from a data source and to load data from the data source to the dataset stored on a first data node of the plurality of data nodes when the at least one first authorization rule authorizes a requesting user to access the first data node.

Abstract: A system and method for displaying data using temporal granularities. The method includes determining at least one first dataset of a plurality of datasets based on at least one temporal data requirement, wherein the plurality of datasets is generated based on a data model, wherein each of the plurality of datasets is generated based further on a distinct temporal granularity of a plurality of temporal granularities, wherein the distinct temporal granularity of each of the at least one first dataset meets at least one of the at least one temporal data requirement; and querying the determined at least one first dataset in order to obtain at least one query result.

Abstract: A method, computer system and computer program product, the method comprising: upon receiving a database query comprising at least a first and a second join operations: storing the database query in the memory; identifying by the processor within the database query the first join operation, wherein the first join operation is a many-to-many join operation or a one-to-many join operation between a first table and a second table, in which fields of the second table are used only for filtering rows from the first table or for joining with another table; and converting by the processor the first join operation to an enhanced operation which eliminates returning at least two matches for at least one row from the first table when the database query is executed.

Abstract: A system and method for providing sensory analytics responses. The method comprises collecting raw data from a plurality of data sources; extracting, from the collected raw data, a subset of the raw data to be analyzed; generating, based on the extracted subset of the raw data, an analytics dataset, wherein the analytics dataset includes a performance indicator; determining, based on at least one received input, at least one query; determining, based on the generated analytics dataset, a response to the at least one query, wherein the response includes at least one sensory output; and causing projection of the determined at least one sensory output.

Abstract: A system and method for generating approximations of query results. The method includes sending a received query to a neural network, wherein the received query is executable on a target data set; receiving from the neural network a predicted result to the received query; providing the predicted result as a first output to a device having initiated the received query; determining a real result of the query from a data set stored in the database when the predicted result is insufficiently accurate; and providing the real result as a second output to a device having initiated the received query.

Abstract: A system and method for representing query elements in an artificial neural network. A method includes generating a translation table based on a plurality of query elements, wherein the translation table maps a plurality of vectors to the plurality of query elements, wherein each of the plurality of vectors is mapped to at least one query element of the plurality of query elements, wherein a first vector of the plurality of vectors is mapped to at least two query elements of the plurality of query elements; converting a plurality of input query elements into respective numerical representations using the translation table; and generating a result for a database query based on the numerical representations.

Abstract: A system and method for providing an improved user interface for executing data operations. A method includes: identifying a first node and a second node from different connections graphs, each node representing a respective user account, the user accounts of the first and second nodes sharing at least one common attribute; generating, based on the different connections graphs, an influence indicator for each of the first node and the second node; identifying a data operation executed by the first node on a dataset when the influence indicator of the first node is higher than the influence indicator of the second node, wherein the identified data operation causes generation or retrieval of business intelligence system data when executed; and sending data indicating the identified data operation to a device of the second node, wherein the device is configured to display a user interface including the identified data operation.

Abstract: A system and method for generating training sets for training neural networks. The method includes determining a segmentation based on a column from a columnar database table; generating a group-by query based on the segmentation; generating a plurality of reduced queries based on the group-by query; executing the group-by query on a table of a database to obtain a result table, wherein the result table includes a plurality of results, wherein each result corresponds to a respective reduced query of the plurality of reduced queries; and generating a plurality of training query pairs by pairing each reduced query with its corresponding reduced result.

Abstract: A system and method for representing query elements in an artificial neural network. The method includes generating a translation table based on a plurality of query elements, wherein the translation table maps a plurality of vectors to the plurality of query elements, wherein each of the plurality of vectors is mapped to at least one query element of the plurality of query elements, wherein a number of distinct query elements among the plurality of query elements is greater than a number of distinct vectors among the plurality of vectors.

Abstract: A system and method for providing an improved user interface for executing data operations. The method includes: identifying a first node and a second node, wherein the first node is selected from a first connections graph and the second node is selected from a second connections graph, wherein each node is associated with a user account having a plurality of attributes, wherein the first and second nodes share at least one common attribute; generating an influence indicator for each of the first node and the second node; identifying a data operation executed by the first node on a dataset when the influence indicator of the first node is higher than the influence indicator of the second node, wherein the identified data operation is not executed by the second node; and sending, to a device of the second node, a notification indicating the identified data operation.