Abstract: Disclosed herein are system, method, and computer program product embodiments for performing ad-hoc analytical queries of graph data. An embodiment operates by receiving a graph pattern for a subgraph of interest. The facts of interest are then selected from graph data based on the received graph pattern. Dimensions are then defined based on a dimension seed pattern and a set of level expressions, and measures are defined based on a computation function and an aggregation function. A graph cube is formed based on the selected facts and the defined dimensions and measures. Because the facts, dimensions, and measures of interest are defined at the time of an analytical query, a user does not have to define such facts, dimensions, and measures, or know which analytical queries will be of interest, at the time of data collection.

Abstract: Systems and methods for network security are provided. Various embodiments of the present technology provide systems and methods for an identity security gateway agent that provides for privileged access. Embodiments include a system and method that uses a single sign-on (SSO) (or similar) mechanism to facilitate a user accessing web-based service providers, but separates the assertion and entire SSO process from the user credential.

Abstract: An automated agent may communicate with a user via a chat channel to proactively alert the user of an L1 IT support issue. The L1 IT support issue may be determined based on monitoring indications of human-initiated activities maintained by a system of record, and may, prior to the automated agent's alert, be unknown to the user. In some instances, a natural language understanding (NLU) module may be used to identify an entity and intent from the indications of human-initiated activities, and the L1 IT support issue may be determined based on the determined entity and intent. After alerting the user of the L1 IT support issue, the automated agent may inform, via the chat channel, the user of a remediation step available to address the L1 IT support issue. Upon obtaining the user's permission, the automated agent may perform the remediation step to address the L1 IT support issue.

Abstract: Various embodiments of systems and methods to provide multi-threaded data analytics. In one aspect, a master view table is generated by retrieving data records corresponding to a plurality of entities from one or more data source tables. A plurality of aspects are determined from the generated master view table. Further, a plurality of aspect relational view tables are generated by comparing the plurality of aspects with one another based on relationship factors. At least one insight of the data records are determined by analyzing the plurality of aspect relational view tables and the master view table in multi-thread.

Abstract: The techniques discussed herein leverage structure within data of a corpus to parse unstructured data to obtain structured data and/or to predict latent data that is related to the unstructured and/or structured data. In some examples, parsing and/or predicting can be conducted at varying levels of granularity. In some examples, parsing and/or predicting can be iteratively conducted to improve accuracy and/or to expose more hidden data.

Abstract: A Codex human knowledge encyclopedia including a webpage database residing in the Codex and stored in non-volatile digital memory, a master index and a partial master index for each element of the Codex, an optimizer receiving from a computing device interactive input, and executing software instructions to transform input based on rules of grammar and semantics into a search pattern and personalizing the search pattern by adding Global Positioning System (GPS) coordinates from the computing device. Mapping the search pattern to an element stored in the Codex and upon identifying the search pattern, obtaining the optimal dataset from the Codex bypassing all calculations since optimal dataset is readily available, picking and arranging, in an order from highest to lowest, from the optimal dataset, the top responses as output based on personalized usage pattern of behavior, and displaying the output to the user.

Abstract: A method, system and computer program product for processing queries in a hybrid database system. A database management system of the hybrid database system obtains an estimated execution time of a query by an online transaction processing engine. The database management system further obtains an estimated execution time of the query by a database accelerator. Furthermore, the database management system determines a wait time (which could be zero) for the database accelerator to process the query. The database management system then determines whether the online transaction processing engine or the database accelerator will process the query using the estimated execution time of the query by the online transaction processing engine, the estimated execution time of the query by the database accelerator and the wait time (which could be zero) for the database accelerator to process the query. In this manner, the processing of queries in hybrid database systems is optimized.

Abstract: In accordance with an embodiment, described herein is a system and method for automatic inference of a cube schema from a tabular data for use in a multidimensional database environment. A cube schema inference component can successively perform column-wise splits to calculate information gain ratios between each pair of a plurality of columns in the tabular data. A cross correlation matrix can be constructed from the information gain ratios between each pair of columns. The system can determine relationships among the plurality of columns based on the cross correlation matrix; create a hierarchy directed graph to represent the relationships; and further transform the hierarchy directed graph into a cube schema that can be used to create a cube for loading the tabular data, or to map the tabular data into an existing cube in the multidimensional database environment.

Abstract: A method for generating a suggested phrase having a similar meaning to a supplied phrase in an analytics system includes: receiving, on a computer system comprising a processor and memory storing instructions, the supplied phrase, the supplied phrase including one or more terms; identifying, on the computer system, a term of the phrase belonging to a semantic group; generating the suggested phrase using the supplied phrase and the semantic group; and returning the suggested phrase.

Abstract: Described in detail herein is an event streaming system. A controller disposed at a facility, can receive an event from computing systems disposed at the facility. The event is received by the controller at a time the event occurs. The controller can stream the event including the set of data. A central system can receive the at least one event streamed by the controller. The central system can include a repository cluster, a relational database, and a NoSQL database. The central system can concurrently route the set of data included in the event to the repository cluster, the relational database and the NoSQL database of the event response system to store the set of data in the repository cluster, the relational database and the NoSQL database.

Abstract: Provided are methods comprising receiving a query for information from the database, determining particular data element types and data element values that are the subject of the query, instantiating a query data structure containing the data element types and the data element values that are the subject of the query, identifying records within the database that contain one or more data element types and/or data element values that are included in the query data structure, and instantiating a results data structure comprising information relating to the identified records.

Abstract: A method of querying data including: providing a transaction management table; providing a system-period temporal table; assigning a unique identifier to a transaction; performing a first operation at a first timestamp; writing a first row identifier in the system-period temporal table; writing in the row corresponding to the first row identifier the unique identifier of the first operation in the row begin entry of the system-period temporal table; writing in the row corresponding to the first row identifier a dummy transaction identifier corresponding to a maximum timestamp value of the database system in the row end entry of the system-period temporal table; committing the transaction at a commit timestamp such that the commit timestamp is later than the first timestamp; inserting a row in the transaction management table and inserting values for the unique transaction identifier, the first timestamp and the commit timestamp in the transaction management table.

Abstract: A data parallel pipeline may specify multiple parallel data objects that contain multiple elements and multiple parallel operations that operate on the parallel data objects. Based on the data parallel pipeline, a dataflow graph of deferred parallel data objects and deferred parallel operations corresponding to the data parallel pipeline may be generated and one or more graph transformations may be applied to the dataflow graph to generate a revised dataflow graph that includes one or more of the deferred parallel data objects and deferred, combined parallel data operations. The deferred, combined parallel operations may be executed to produce materialized parallel data objects corresponding to the deferred parallel data objects.

Abstract: A computer-implemented method, computerized apparatus and computer program product, the method comprising: receiving a latency constraint on a Complex Event Processing (CEP) computation; monitoring progress of the CEP computation to determine a risk of violating the latency constraint; and, responsive to determining that a risk of violating the latency constraint exists, outputting at least one possible result of the CEP computation.

Abstract: Merging adjacent rows of a synopsis table so as to increase the effectiveness of the synopsis table regarding data skipping. Adjacent rows for merging are identified based on statistics regarding: (i) queries of the database; (ii) effectiveness of the synopsis table for data skipping; and (iii) usage of predicates in queries of the database. Once merged, the synopsis table is smaller, and more effective with respect to data skipping, while fewer computing resources (administrative, maintenance, memory, clock cycles, storage space, etc.) are needed to process the database queries.

Abstract: Merging adjacent rows of a synopsis table so as to increase the effectiveness of the synopsis table regarding data skipping. Adjacent rows for merging are identified based on statistics regarding: (i) queries of the database; (ii) effectiveness of the synopsis table for data skipping; and (iii) usage of predicates in queries of the database. Once merged, the synopsis table is smaller, and more effective with respect to data skipping, while fewer computing resources (administrative, maintenance, memory, clock cycles, storage space, etc.) are needed to process the database queries.

Abstract: A system includes a processor and a computer-readable medium configured to store instructions for execution by the processor. The instructions include receiving a first document corresponding to a first application hosted by a distributed computing provider. The instructions include parsing the first document into a first data structure according to a data structure definition. The data structure definition describes an inheritance property. The instructions include, in response to presence of a first inheritance property in the first data structure: identifying an inherited document based on the first inheritance property; obtaining the inherited document; reading the inherited document; determining inheritance permissions from the inherited document; and, in response to the inheritance permissions permitting the first document to inherit the inherited document, selectively modifying the first data structure based on the inherited document.

Abstract: A method for providing low-latency responses to queries to a data search system comprises storing first digital data in a first digital data repository using a first column-oriented storage format; storing second digital data in a second digital data repository using a second column-oriented storage format, wherein the second column-oriented storage format is different from the first column-oriented storage format; generating a plurality of pre-computed views based on both the exposure data and the risk item data; storing the plurality of pre-computed views in the second data repository using the second column-oriented storage format; and in response to receiving a search query, determining a result set that is responsive to the query based on one or more particular pre-computed views of the plurality of pre-computed views and providing the result set to another computer or display device as output.

Abstract: At each delegate device and each non-delegate device of a logical device hierarchy, a data cube is generated. The logical device hierarchy includes more than one level, and each level includes one or more groups, and each group includes one delegate device and one or more non-delegate devices. At each delegate device, data cubes are received from the one or more non-delegate devices associated with the same group. At each delegate device, data cubes are received from delegate devices of a different group, and that delegate device is the parent of the delegate devices associated with a different group. At each delegate device, the received data cubes are aggregated into a weighted data cube. From each delegate device, the weighted data cube are outputted to the parent of the delegate device.

Abstract: Systems and methods for hosting variable schema data such as dynamic tables and columns in a fixed physical database schema. Standard objects, such as tables are provided for use by multiple tenants or organizations in a multi-tenant database system. Each organization may add or define custom fields for inclusion in a standard object. Custom fields for multiple tenants are stored in a custom data column within the object data structure, and this single custom data column may contain different data types for each tenant.

Abstract: Provided is a computer implemented method including receiving a digital communication; analyzing said communication using natural language processing to identify any semantic reference to one or more digital artifacts; and identifying and locating the one or more digital artifacts. In some embodiments one or more digital artifacts are not specifically identified in the digital communication. In some embodiments one or more digital artifacts are not specifically included in the digital communication. Related apparatus, systems, techniques, and articles are also described.

Abstract: Methods for splitting a plurality of records into subsets for parallel processing by separate threads are disclosed. In one embodiment, a plurality of records are added to a database. The adding includes tracking, for each unique value found in the plurality of records within a selected one of the sequence of fields, a statistic based on the values found in the plurality of records within a next one of the sequence of fields. Then a plurality of queries are generated, each includes a row value constructor (RVC) with a logical operation, a specific one of the unique values found within the selected one of the sequence of fields, and, for that specific value, the tracked statistic. Then a plurality of threads are caused to execute that each submit one of the queries and operate on a subset of the plurality of records responsive to execution of that query.

Abstract: Data structures stored on a source database are migrated to a destination database in which the data are structured in a different format than that of the source database. Dictionaries are stored that are based on representations of the data structures stored on the source database that are formatted in other than the structural format used on the source database for the data structures. One of the data structures and a corresponding one of the dictionaries are transferred from the source database to a destination database. The transferred data structure is loaded onto the destination database in accordance with the transferred dictionary.

Abstract: A system and method for facilitating timely end user creation, customization, and/or configuration of analytic reports in a computing environment, such as an enterprise-computing environment. An example method includes receiving configuration information characterizing one or more User Interface (UI) features to be incorporated into an analytic report; employing the configuration information to generate one or more database queries to selectively retrieve data from the database; using the configuration information and the one or more database queries to construct an analytic template; and publishing the analytic template so that the analytic template is accessible to one or more end users of the computing environment. In a more specific embodiment, the computing environment includes an enterprise-computing environment, and the one or more users include enterprise personnel.

Abstract: To provide overall security to a utility management system, critical command and control messages that are issued to components of the system are explicitly approved by a secure authority. The explicit approval authenticates the requested action and authorizes the performance of the specific action indicated in a message. Key components of the utility management and control system that are associated with access control are placed in a physical bunker. With this approach, it only becomes necessary to bunker those subsystems that are responsible for approving network actions. Other management modules can remain outside the bunker, thereby avoiding the need to partition them into bunkered and non-bunkered components. Access to critical components of each of the non-bunkered subsystems is controlled through the bunkered approval system.

Abstract: Systems and methods for improving efficiency are described herein. The systems and methods described herein can also comprise systems and methods for reducing waste. Systems and methods described herein can comprise a date warehouse, data marts, and visualizations.

Abstract: A system and method facilitating transforming or updating displayed data using data hierarchy information. An example method includes storing hierarchy information characterizing a dataset via one or more tree tables; selectively accessing a database to update data characterized by metadata of the one or more tree tables; employing one or more pivot grids to replicate one or more hierarchical properties of the one or more tree tables; and displaying information based on the one or more pivot grids. The displaying step may further include using the pivot grid(s) to generate and display analytic(s), wherein data for the pivot grid(s) and analytics(s) is obtained from flattened tree tables. Dynamically executed Structured Query Language (SQL) construct(s) may retrieve un-cached fresh multi-dimensional data used for the pivot grid(s) or analytic(s) in a manner consistent with hierarchy information retrieved (via SQL) from the tree tables as tree metadata.

Abstract: In a distribution system including a plurality of physical machines, when an output file output by first processing performs multistage processing input to second processing, a physical machine which is a deployment destination of a first virtual machine for performing the first processing, a physical machine which is a storage destination of each data block included in the output file, and a physical machine which is a deployment destination of a second virtual machine for performing the second processing are determined based on relationship between the first and second processing.

Abstract: A method and system for enabling transfer of widgets across containers at runtime. According to embodiments of the present invention, a user is allowed to transfer a widget across containers at runtime, for example, moving a widget that has been deployed and operated in one widget container to another, even though the destination widget container originally does not support the widget. Specifically, the widget being transferred can keep consistency in terms of data and state before and after the transfer. Furthermore, the user can implement the cross-container transfer of widgets at runtime by, for example, convenient interaction means like a drag-and-drop operation. In this way, the user can operate and interact with Web applications in a more convenient and flexible way.

Abstract: The present disclosure provides a detailed description of techniques used in systems, methods, and in computer program products for dynamic aggregate generation and updating for high performance querying of large datasets. Certain embodiments are directed to technological solutions for determining at least one aggregate of selected virtual cube attributes (e.g., measures, dimensions, etc.) describing a virtual multidimensional data model of a subject database, and generating an aggregate table and a set of aggregate metadata for the aggregate. In some embodiments, an aggregate database statement configured to operate on the subject database can be issued to generate the aggregate table and/or aggregate metadata. Further, the aggregate can be dynamically determined responsive to receiving a database statement configured to operate on the virtual multidimensional data model representing the subject database.

Abstract: Example embodiments of the present invention relate to a method, a system, and a computer program product for data analytics. The method includes receiving a plurality of first data streams from respective managed elements in a network and partitioning data of the plurality of first data streams according to an attribute regarding the data into a partitioned second data stream. The partitioned second data stream then may be streamed toward a data analytics platform for consumption by the data analytics platform. In a preferred embodiment, WebSockets are used.

Abstract: This disclosure relates to predicting and managing supply chain network risks. In one embodiment, a processor-implemented method obtains identifiers for supply chain contributors and parameters; and a query. The method performs a natural language processing algorithm on the query to extract text components, which it analyzes to identify supply chain component clusters and risk identifiers. It also includes executing a machine learning technique for learning of the risk identifiers and generating co-occurrence rules between the risk identifiers, as well as associated rule support and rule confidence parameters. It further includes sorting the co-occurrence rules to generate a prioritized rules list, and generating a risk prediction model for the supply chain using the prioritized rules list, using a classifier algorithm.

Abstract: Systems, computer-implemented methods, and non-transitory computer readable media are provided for determining related ontological data. The disclosed systems may be configured to receive a first ontology and a second ontology, the first ontology and the second ontology comprising hierarchically organized ontological data. The disclosed systems may also be configured to receive an indication that a first ontological datum in the first ontology is equivalent to a second ontological datum in the second ontology, and a query for ontological data related to a third ontological datum subordinate to the first ontological datum. The disclosed systems may be configured to determine a first semantic distance between the third ontological datum and a fourth ontological datum in the second ontology satisfies a semantic distance criterion, and output the fourth ontological datum based on the determination that the first semantic distance satisfies the semantic distance criterion.

Abstract: To ensure that there is an elected manager among storage nodes of an erasure coding group (“ECG”), an ECG manager (“ECGM”) election process is periodically performed among available storage nodes that are configured with the software to perform the services of an ECGM. When a storage node is activated, an ECGM process of the storage node begins executing and is assigned a process identifier (“PID”). A storage node can utilize a service query framework to identify other available storage nodes and retrieve their ECGM PIDs. The storage node then selects a PID according to a criterion and elects the storage node corresponding to the selected PID to be the acting ECGM. This process is performed periodically, so even if the acting ECGM storage node fails, a new ECGM is eventually selected from the available storage nodes.

Abstract: Methods and apparatus, including computer program products, are provided for in-memory simulations. The method may include forming a virtual cube including at least one change value representative of a change to a simulation; forming another cube including online data; and combining the virtual cube and the other cube to form a union cube representative of a result of the simulation, the virtual cube, other cube, and the union cube comprised in an in-memory storage and shared for at least a session associated with the simulation. Related systems, methods, and articles of manufacture are also disclosed.

Abstract: Systems, apparatuses, and methods for cloud memory sizing are disclosed. An initial database memory allocation is determined for the provisioning of a database server instance. Periodically, sizes of key database tables of the database server instance are measured and an upper and a lower bound ratio are determined based on the key database table sizes and a buffer pool size. The upper and lower bound ratios are used to determine a desired memory allocation from which a report is generated including an interface for generating an instance move action for re-provisioning the database server instance with the desired memory allocation.

Abstract: The present disclosure is directed at methods, systems, and techniques for sharing data in a physical security system that includes multiple server nodes. One of the server nodes (a “first node”) accesses a node identifier identifying another of the server nodes (a “second node”), following which the first node sends the data to the second node. Both the first and second nodes are part of a server cluster that includes multiple server nodes, and each of the server nodes in the server cluster has access to cluster membership information. The cluster membership information identifies all of the server nodes in the server cluster, and the node identifier is part of the cluster membership information.

Abstract: An information processing apparatus includes circuitry configured to acquire time data relating to a state of an object in each process of an operation performed on the object, the operation including at least one process; calculate an achievement value indicating a state of each process, based on the time data acquired; compare the achievement value calculated with a reference value; and generate a chart that visually represents a result of comparison for each process. The visual representation of the result of comparison is different according to the result of comparison.

Abstract: Methods, systems and computer program products for generating hypergraph representations of dialog are provided herein. A computer-implemented method includes analyzing at least one dialog to identify one or more topics and one or more contributions by one or more persons to the one or more topics, tracking evolution of the identified topics over time in the at least one dialog, generating a hypergraph representation of the at least one dialog utilizing the identified topics, the identified contributions and the tracked evolution of the identified topics, and providing an interactive visualization tool based on the hypergraph representation of the at least one dialog.

Abstract: A system and method is described for database split generation in a massively parallel or other distributed database environment including a plurality of databases and a data warehouse layer providing data summarization and querying functionality. A database table accessor of the system obtains, from an associated client application, a query for data in a table of the data warehouse layer, wherein the query includes a user preference. The system obtains table data representative of properties of the table, and determines a splits generator in accordance with one or more of the user preference or the properties of the table. The system generates, by the selected splits generator, table splits dividing the user query into a plurality of query splits, and outputs the plurality of query splits to an associated plurality of mappers for execution by the associated plurality of mappers of each of the plurality of query splits against the table.

Abstract: Some embodiments provide a system that provisions multidimensional data storage (MDDS) cubes. The system includes a data management module for (1) accessing data from a plurality of data storages and (2) providing the data from the plurality of data storages through a unified data source for a set of MDDS cubes. The system also includes a cube provisioning module to (1) access the data from the plurality of data storages through the unified data source and (2) based on the unified data source, provision the set of MDDS cubes to a set of MDDS clients for viewing the set of MDDS cubes' data.

Abstract: A system and method is described for database split generation in a massively parallel or distributed database environment including a plurality of databases and a data warehouse layer providing data summarization and querying functionality. A database table accessor of the system obtains, from an associated client application, a query for data in a table of the data warehouse layer, wherein the query includes a user preference. The system obtains table data representative of properties of the table, and determines a splits generator in accordance with one or more of the user preference or the properties of the table. The system generates, by the selected splits generator, table splits dividing the user query into a plurality of query splits, and outputs the plurality of query splits to an associated plurality of mappers for execution by the associated plurality of mappers of each of the plurality of query splits against the table.

Abstract: A computer implemented method for monitoring databases includes providing views for monitoring information associated with a first datacenter and proxy views for monitoring information associated with a second datacenter. The first datacenter receives a query for monitoring information and parses the query to identify filter information that identifies which of the first or second datacenter the requested services are running on. If the filter information indicates the service is running on the first datacenter, the first datacenter queries the views to request the monitoring information from the server on the first datacenter running the requested service. If the filter information indicates the service is running on the second datacenter, the first datacenter queries the proxy views to request the monitoring information from the server on the second datacenter running the requested service, and receives the monitoring information. Related apparatus, systems, techniques and articles are also described.

Abstract: Marketing data communication control techniques and systems are described. A digital environment is described in which a plurality of devices are configured to communicate marketing data to one or more of a plurality of marketing services. One or more inputs are received that are entered by a user through interaction with the single unified user interface of the computing device, the one or more inputs specifying marketing data communication settings to control communication of marketing data per individual ones of the plurality of devices and per individual ones of the plurality of marketing data collection services. The marketing data communication settings are propagated by the computing device to respective ones of the plurality of devices, the propagated marketing data communication settings configured to control communication of marketing data by the respective said devices to respective ones of the plurality of marketing data collection services.

Abstract: Provided are technical solutions for preparing and using a cache of social media post data. In an example, a database of social media posts is queried for matching posts and respective metadata for each matching post. Index item data describing one or more respective attributes of each matching post is gathered. For each of the matching posts, the respective index item data is combined with the respective metadata to form combined data. The matching posts and the combined data for each matching post are stored in the cache of social media post data. The cache can be indexed. The cache index can be subsequently queried to provide, for further analysis, social media data which matches specific attributes.

Abstract: A system includes determination of a query context comprising a measure and one or more dimension values of a data source, generation of a query of the data source for the measure over time and aggregated over the one or more dimension values, reception of a result set of the query, providing of the result set to a predictive analysis engine, and reception of forecast data based on the result set, the forecast data comprising forecast values of the measure over time, aggregated over the one or more dimension values.

Abstract: A system and method for sensor-driven automatic device interaction, comprising a sensor aggregator that receives a plurality of sensor data from a plurality of hardware sensors, analyzes at least a portion of the sensor data, determines a sensor threshold, iteratively compares the results of the analysis to the sensor threshold, and directs the operation of a camera based on the results of the comparison.

Abstract: To efficiently recover from a multiple storage node failure, a storage node concurrently restores data fragments to the multiple failed storage nodes, as opposed to restoring each node individually. In the VCS based storage technique, storage nodes are restored as part of an ECG repair process. For each ECG being repaired, a storage node performing the restoration process reads data fragments from active nodes in the ECG and generates new data fragments to replace any lost data fragments. The node then stores one of the new data fragments across each of the failed storage nodes. By concurrently restoring data fragments to each failed storage node, the data fragments needed to repair each ECG are only read once, thereby preserving disk operations and network bandwidth.

Abstract: In an example, columns in a data table may be categorized according to a data type based upon an analysis of data elements contained in each column with a grammar file. The data type of a column be may be categorized as one of a general data type and a specific data type. In addition, the grammar file may be expanded by at least one of adding a data element to the grammar file in response to a column being categorized as a specific data type and inserting a new data type to the grammar file in response to a column being categorized as a general data type.

Abstract: In various example embodiments, systems and methods for building data cubes to be stored in a cube store are presented. In some embodiments, a metadata engine generates the cube metadata. In further embodiments, cube data is generated by a cube build engine based on the cube metadata and source data. The cube build engine performs a multi-stage MapReduce job on the source data to produce a multi-dimensional cube lattice having multiple cuboids. In further embodiments, the cube data is provided to the cube store.