Abstract: In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing conditional statement execution within a multi-tenant aware structured query language within a computing environment.

Abstract: An artificial intelligence and machine learning infrastructure system, including: one or more storage systems comprising, respectively, one or more storage devices; and one or more graphical processing units, wherein the graphical processing units are configured to communicate with the one or more storage systems over a communication fabric; where the one or more storage systems, the one or more graphical processing units, and the communication fabric are implemented within a single chassis.

Abstract: Provided are a computer program product, system, and method for building complex hierarchical queries. A User Interface (UI) representation of a logical query is received, wherein the UI representation describes object types, relationships between the object types, and attributes of the object types. The UI representation is translated to a logical query. The logical query is converted to data layer calls to retrieve objects having the object types, the relationships between the object types, and the attributes of the object types. The objects are received. Then, a directed graph is generated using the identified objects.

Abstract: A computer-implemented method, system using at least one computing device, and computer program product are disclosed for linking an ontology provided by a content service with a word expansion ontology. The content service ontology is referred to as a category ontology and the word expansion ontology is referred to herein as a lexical ontology. A user may provide an input such as an input command to an application. The input command is processed by a natural language processing engine to derive the user's intent and to extract relevant entities embodied in the command. The NLP engine may create a composite concept set containing multiple permutations of the concepts (entities extracted) and provide the composite concept set to a concept mapper. The concept mapper applies searches an ontology map and applies one or more scoring operations to determine a best match between the composite concept set and at least one category provided by the category ontology.

Abstract: Embodiments of the present invention provide systems and methods for data management. Synopsis tables have been found to be more effective for maintaining a high level of system performance while answering analytical queries. Synopsis tables, which contain MAX, MIN, and Bloom filter columns, may be modified by dropping ineffective data content within these columns and regenerating dropped data when beneficial. By automatically modifying data, database queries may be optimized.

Abstract: In one embodiment, a method includes receiving a search query from a client system; modifying the search query by removing a first search term associated with a first object type from the search query; retrieving search results responsive to the modified search query from a first data store storing objects of the first object type; and sending one or more of the search results to the client system.

Abstract: Methods and systems for scheduling include forming a search tree. Each node in the search tree represents a scheduling unit formed from a priority queue that includes orders from multiple, mutually compatible sets of orders and wherein each path through the search tree represents a sequence of orders and has an associated priority score. The search tree is searched for a path having an optimal associated priority score. A schedule is implemented based on the path having the optimal associated priority score.

Abstract: A mechanism for rewriting a bounded query onto a view is disclosed. A query, access constraints, and cached view(s) are obtained. The cached view(s) contain results of the query as applied to a dataset stored in a database. A query rewriting plan is generated by adding a fetch from query operation to the plan when a rewritten query variable can be fetched from a query constant. A fetch from database operation is added to the plan when a rewritten query variable can be fetched as a query variable that obtains bounded data from the database. An access view operation is added to the plan when a rewritten query variable can be fetched from the cached view. The query rewriting plan is executed to fetch retrieved data. The query is executed on the retrieved data to determine updated results to the query without reapplying the query to the dataset.

Abstract: Methods and systems for optimizing queries in a multi-tenant store are described. In one embodiment, such a method includes retrieving data from a multi-tenant database system having a relational data store and a non-relational data store, receiving a request specifying data to be retrieved, retrieving one or more locations of the data to be retrieved, generating a database query based on the request, in which the database query specifies a plurality of data elements to be retrieved, the plurality of data elements including one or more data elements residing within the non-relational data store and one or more other data elements residing within the relational data store, generating an optimized database query having an optimized query syntax that is distinct from a query syntax of the database query, and executing the optimized database query against the multi-tenant database system to retrieve the data.

Abstract: A massively parallel processing shared nothing relational database management system includes a plurality of storages assigned to a plurality of compute nodes. The system comprises a non-transitory memory having instructions and one or more processors in communication with the memory. The one or more processors execute the instructions to store a set of data in a first set of storages in the plurality of storages. The first set of data is hashed into a repartitioned set of data. The first set of storages is reassigned to a second set of compute nodes in the plurality of compute nodes. The repartitioned set of data is distributed to the second set of compute nodes and a database operation is performed on the repartitioned set of data by the second set of compute nodes.

Abstract: A method and system for performing numeric searches related to biometric information, the method comprising generating a main search key representing biometric features of an item to be searched, partitioning the main search key into at least two sub-keys, each sub-key comprising a predetermined number of bits, obtaining a set of index tables each comprising a plurality of key values, each key value being associated with a corresponding index value, wherein the number of index tables in the set is equal to the number of sub-keys within the main search key, identifying, in a first one of said set of index tables, at least one key value matching a first sub-key of the main search key, obtaining, for each identified key value, a corresponding index value pointing to a limited portion of key values in a next index table, identifying, in said limited portion of said next index table, at least one key value matching a next sub-key of the main search key repeating the steps of obtaining index values and searching a

Abstract: Systems and methods for determining a preferred communication channel can be based on determining a status of a node profile using electronic activities. The system and methods can include accessing a plurality of electronic activities and maintaining a plurality of node profiles. The system and methods can include identifying a node profile and generating a communication mode schedule. The systems and methods can include transmitting a notification to a device via a communication selected using the communication mode schedule.

Abstract: Methods and systems for generating performance profiles using electronic activities linked to record objects are disclosed. Exemplary implementations may: access a record objects of a system of record of a data source provider; identify, from the record objects, a subset of record objects associated with a node profile corresponding to an entity; identify, for each record object of the subset, electronic activities linked to the record object; determine, for each record object of the subset, a respective entity engagement profile for the entity based on the electronic activities linked to the record object and one or more object field-value pairs of the record object; generate a composite entity engagement profile of the entity based on each respective entity engagement profile corresponding to each record object of the subset of record objects; and store, in one or more data structures, an association between the entity and the entity performance profile.

Abstract: The present disclosure related to techniques for analyzing data from multiple different data sources to determine a relationship between the data (also referred to herein a “data relationship discovery”). The relationships between any two compared datasets may be used to determine one or more recommendations for merging (e.g., joining), or “blending,” the data sets together. Relationship discovery may include determining a relationship between a subset of data, such as a relationship between a pair of columns, or column pair, each column in a different dataset of the datasets that are compared. Given two datasets to process for relationship discovery, relationship discovery may identify and recommends a ranked subset of column pairs between two compared datasets. The ranked column pairs identified as a relationship may be useful for blending the datasets with respect to those column pairs.

Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for disaggregating latent causes for computer system optimization. In one aspect, a method includes accessing a data stream for data values resulting from operations performed by a computer system; providing the data values as input to a data disaggregation machine learning model that generates descriptors of latent causes of the data values; providing the data values and the descriptors of the latent causes of the data values as inputs to a control system model that generates embedded representations of commands to modify the operations performed by the computer system; determining commands to modify the operations performed by the computer system based on the embedded representations of commands to modify the operations performed by the computer system; and providing the commands to the computer system.

Abstract: Embodiments of the present disclosure include a method, a system, and a computer program product for determining wait times of tuples within a streaming environment. The method includes monitoring one or more tuples being processed within an operator graph where the operator graph includes a first processing element and a queue of the first processing element. The method includes recording a wait time of the one or more tuples within the queue of the first processing element. The method includes recording a processing time time of the one or more tuples within the first processing element. The method includes displaying the wait time and the processing time of the one or more tuples. The method includes optimizing a configuration of the operator graph, in response to recording the processing time of the one or more tuples.

Abstract: A computing resource service receives a request. In response to the request, the computing resource service queries a probabilistic data structure for an entry corresponding to the request. The computing resource service obtains, from the probabilistic data structure, a value that corresponds to the entry. Based at least in part on this value, the computing resource service determines whether the entry has expired. If the entry is expired, the request is fulfilled. However, if the entry has not expired, the request is denied.

Abstract: A method of providing a level of certification of an attribute of an item is disclosed. A requirement is determined for a level of certification for an attribute of an item. A notification is provided of an evidence item that is to be submitted to evaluate the level of certification of the attribute of the item. The evidence item is received. The level of certification of the attribute of the item is determined based on the received evidence item.

Abstract: A computing system is described that identifies, based on search histories associated with a group of computing devices for a particular context, a task performed by users of the group of computing devices for the particular context. The computing system determines a first degree of likelihood of the task being performed by the users of the group of computing devices for the particular context and determines a second degree of likelihood of the task being performed by the users of the group of computing devices for a broader context that includes the particular context and at least one other context. Responsive to determining that the first degree of likelihood exceeds the second degree of likelihood by a threshold amount, and that a current context of a particular computing device corresponds to the particular context, the computing system transmits, to the particular computing device, information for completing the task for the particular context.

Abstract: A combined configuration rules-attribute configuration system uses an integrated configuration model to efficiently identify and attribute prioritize valid configuration answers. Submitting an attribute-based configuration query to the combined configuration rules-attribute configuration system allows the query to be answered in a single step. The combined configuration rules and attribute data guide product configuration processing and minimize configuration processing by, for example, calculating only the valid configuration answers that are candidates for the preferred valid answer(s). Thus, the combined configuration rules-attribute configuration system can minimize the number of valid configuration answers to be considered for presentation to a client system or other user of the combined configuration rules-attribute configuration system.

Abstract: Aspects extend to methods, systems, and computer program products for ranking contextual metadata to generate relevant data insights. Aspects of the invention can be used to enhance data analytics by automatically deriving relevance signals used to generate insights closely related to the context in which a user is exploring or analyzing data. User experiences can include embedded data visualizations, search engines, and natural language querying systems to help users understand their data more effectively. By utilizing metrics on the relevance information, insights related and/or relevant to the context in which the user is analyzing data can be created. Thus, relevance information can define a scope for a variety of automatically generated insights of data. Insight generation can be based on computed relevance signals that target areas interesting to users.

Abstract: Method and systems for parallel scoring an ensemble model are provided. Aspects include loading data into a first distributed data structure having a plurality of partitions, each partition having loaded data in the form of a set of pairs of data formed of a record to be scored and a partial score for that record. A component model in the ensemble model is selected and processing of the records carried out in parallel across the partitions including updating the partial score for each record. In response to a partial score for a record not meeting an accuracy threshold, the method retains the record in the first distributed data structure to be scored by a subsequent component model. In response to the partial score for a record meeting the accuracy threshold, the method moves the record and updated partial score to an output result data structure to provide a final score.

Abstract: In one embodiment, a method includes identifying a trending topic on an online social network, accessing a plurality of content objects posted to the online social network, wherein each content object is associated with the trending topic, and categorizing each content object into clusters based on a natural-language analysis of the content objects. The method may further include calculating a quality score for each cluster, wherein the quality score for each cluster is based at least on a measure of recency of one or more publication dates of the content objects within the cluster, select the cluster with the highest quality score as a trending cluster, and generating a trending-topic interface that includes a headline and description of the trending topic, wherein the headline and description are extracted from one or more of the content objects within the trending cluster.

Abstract: An online review system determines scores for document authors and document reviewers. An author score is based on a number of comments added to a document by reviewers. One way to compute the author score is to use a ratio of a number of comments provided by reviewers of a document to a number of lines of document contents provided by the author. A reviewer score for a reviewer is based on an amount of comments subsequently made by other reviewers, and on the document content itself, such as a ratio of a number of comments provided in subsequent reviews of a document to a number of lines of original document contents. In some embodiments, the online review system monitors trends in scores of individuals or teams.

Abstract: A method includes logically organizing, by an object hierarchy processor, data objects in a first hierarchy. A portion of the data objects in the first hierarchy logically includes groupings of other data objects. The object hierarchy processor physically organizes the data objects across two or more types of memory in a second hierarchy. Another portion of the data objects in the second hierarchy physically includes groupings of other data objects. Groupings of the data objects in the second hierarchy are dynamically moved across the two or more types of memory. Levels of access of the data objects are tracked using a data structure that maps groupings of the data objects in the first hierarchy onto metadata information including combined access frequencies of the data objects, and current number of accessors to the data objects, in each grouping of the data objects.

Abstract: A method involves receiving, from a user, a user query for data contained within a multi-dimensional dataset comprising a plurality of data objects, generating a multi-dimensional search box for use in searching the multi-dimensional dataset according to the user query, wherein the size of the multi-dimensional search box is approximated based upon a percentage of the scale of the dataset and upon the standard deviation of the data object distribution of the dataset, searching the multi-dimensional dataset using the multi-dimensional search box, and returning, to the user, data from the multi-dimensional dataset contained within the multi-dimensional search box. The multi-dimensional search box may be generated in part by modeling the range of values as an arbitrary start point within the multi-dimensional data set with extents that are Gaussian distributed with a standard deviation less than the scale of the data set.

Abstract: Disclosed aspects relate to access operation management to a database management system (DBMS) on a shared pool of configurable computing resources having a set of members. A map of the set of table names to the set of members may be established. A query may be received which indicates the access operation request to the DBMS. The query may be parsed to identify a mentioned table name. In the query related to the access operation request to the DBMS, the mentioned table name may be identified. A specific member of the set of members may be selected by comparing the mentioned table name with the map. The specific member of the set of members may be configured to process the access operation request to the DBMS. The routing may be performed in order to process the access operation request to the DBMS.

Abstract: A method, system and computer program product is disclosed for performing data ingestion. A request is received for data ingestion. Based on the request received, a client resource information with a server resource information is compared. After the comparing of client resource information with server resource information, location for formatting of data during data ingestion is determined. Further, in response to the determination of location, formatting of the data is performed at the determined location.

Abstract: Primary tables associated with a first user interface application are received in a migration of user interface application layer. Properties associated with the primary tables and secondary tables are determined. The primary tables and the secondary tables are converted to an entity data model file in a migration system based on the properties associated with the primary tables and the secondary tables. A service and a link to access the service are generated based on the entity data model file. UI controls corresponding to the properties determined from the service are identified in the migration system. A second user interface application with the UI controls is displayed in the enterprise application.

Abstract: A method, system and computer program product is disclosed for performing data ingestion. A request is received for data ingestion. Based on the request received, a client resource information with a server resource information is compared. After the comparing of client resource information with server resource information, location for formatting of data during data ingestion is determined. Further, in response to the determination of location, formatting of the data is performed at the determined location.

Abstract: Tiered storage may be implemented for processing data. Data processors may maintain some of a data set, including user data and metadata describing the user data, locally. The data set is also maintained a data store remote to the data processor. When processing requests are received, a determination is made as to whether the local portions of the data set can execute the processing request or one or more additional portions of the data set are needed from the remote data store. If additional portions of the data set are needed, then a request may be sent to the data store for the additional portions. Once received, the data processor may execute the processing request utilizing the additional portions. Portions of the data set maintained locally at the data processor may be selected and flushed from local storage to the remote data store.

Abstract: A system to reduce the amount of storage and memory used to maintain derived datasets is disclosed. The system operates by using pointers to the underlying data in persistent, byte-addressable storage media. The system additionally reduces the creation time of the views when storage class memory (SCM) is the underlying storage. Furthermore, the invention relates to a form of compression that is tailored to the use cases of big data analytics. The processes of this disclosure use random access to significantly improve performance.

Abstract: Managing data conversion for user-defined data types within a DBMS. A custom data type definition and one or more converters are stored within a database management system. Each converter can convert instances of the custom data type between a binary format and a programming language format. The database management system receives a request for a custom data type instance in a specified programming language format. A converter among the one or more converters converts the custom data type instance expressed in the binary format into a custom data type instance expressed in the specified programming language format, using a custom data type definition from the database management system. The request is responded to with the converted custom data type instance in the specified programming language format.

Abstract: A system analyzes transformations for processing datasets. The transformations may be used for build a transformation script for preprocessing data for analysis by big data analysis systems. The system receives a new transformation for analysis. The system determines a measure of an impact of the new transformation operation on a dataset. The system determines statistical information describing rows of the transformed dataset that are impacted by the new transformation. The system receives request to add the new transformation to the transformation script responsive to presenting the statistical information.

Abstract: A mechanism for managing data operations in an integrated database system. The method includes receiving a request to perform a data operation and retrieving a data set from a primary data source (PDS) in view of the request. The method also includes storing the data set in a temporary data store (TDS). The method further includes performing the data operation on the stored data set in the TDS.

Abstract: A method for maintaining a data storage system is disclosed. The method may include monitoring for receipt of a first broadcast message from a first data storage node, where the first broadcast message may indicate that the first data storage node is operating correctly. The method may also include detecting that the first data storage node is malfunctioning based on not receiving the first broadcast message for a predetermined period of time. The method may also include initiating a data replication procedure based on detecting that the first data storage node is malfunctioning. The data replication procedure may include sending a first multicast message to a plurality of data storage nodes requesting identification of a second data storage node that maintains a copy of a file stored on the first data storage node.

Abstract: A computer-automated method for securing unidirectional communication within a network. The method includes orchestrating an automated arrangement and/or coordination of at least one portion of a message using a top-level orchestration server, transmitting a first data packet from the top-level orchestration server to a first top-level backbone server, wherein the first data packet is a first portion of the message, and authenticating the first data packet using the first top-level backbone server. The method can include transmitting a second data packet from the first top-level backbone server to a second top-level backbone server, wherein the second data packet is a second portion of the message and/or the second data packet includes a modified first data packet and authenticating the second data packet using the second top-level backbone server.

Abstract: A method includes identifying a first table including data. The first table has associated metadata, an associated replication state, an associated replication log file including replication logs logging mutations of the first table, and an associated replication configuration file including a first association that associates the first table with a replication family. The method includes inserting a second association in the replication configuration file that associates a second table having a non-loadable state with the replication family. The association of the second table with the replication family causes persistence of any replication logs in the replication log file that correspond to any mutations of the first table during the existence of the second table. The method further includes generating a third table from the first table, the metadata associated with the first table, and the associated replication state of the first table.

Abstract: In accordance with various embodiments of the disclosed subject matter, a method and an apparatus for checking and updating data on a client terminal are provided. In some embodiments, the method comprises: obtaining a presentation time interval between two adjacent presenting actions of target data on the client terminal, and obtaining an update time interval between two adjacent updating actions of the target data on a server; calculating a weighted mean value of the target data based on the presentation time interval and the update time interval, as well as a preset presentation weight and a preset update weight; and determining an update check period of the client terminal for periodically performing an update operation to the target data based on the weighted mean value.

Abstract: Disclosed in some examples is a method of database replication, the method including at a Relational Database Management System (RDMS), determining a first replication mode; identifying a triggering event; determining that the triggering event indicates a change in the first replication mode; responsive to determining that the triggering event indicates a change in the first replication mode, determining a second replication mode, the second replication mode being a different replication mode than the first replication mode; identifying a database change made by one or more database tasks; and replicating the database change to an external replication component according to the second replication mode.

Abstract: In a method for improving performance of a database, create, in a memory, an instance of a segment of data corresponding to a segment of data in a database on a persistent file system. The segment of data in the database on the persistent file system is expected to experience a high plurality of reads and writes during a certain time period. Receive a request to modify the segment of data in the database on the persistent file system. Modify the instance of the segment of data in the memory.

Abstract: In an example, a database system may be configured to validate relational database instructions using a plurality of validators. In some examples, validation may be pre-production for relational database instructions based on simulated user inputs and/or file, such as plan files (e.g., PL/SQL (procedural language/structured query language) files). In some examples, validation may be in production for relational database instructions based on system views of a database engine.

Abstract: Systems, methods, and non-transitory computer-readable media can determine that a content item corresponds to a category, the category including a plurality of other content items. A user selection of the category is received through a display interface. The content item is provided for presentation through the display interface. User feedback indicating whether the content item corresponds to the category is received. A determination is made whether to include the content item in the category based at least in part on the user feedback.

Abstract: A system to align codes between two coding standards, including: an expert mapping module, a syntactical mapping module, and a case-based mapping module; a module adjustment unit or system; and an alignment unit or system; where the expert mapping module collects established mappings between pairs of codes of the two coding standards from the internet and/or from machine-readable publications; the syntactical mapping module accesses the two coding standards including descriptions for each code, and to find the similarity of pairs of codes of the two coding standards using the descriptions to provide syntactical mappings; the case-based mapping module accesses existing cases that are annotated with both coding standards and to find case-based mappings between pairs of codes of the two coding standards; the module adjustment unit aggregates the mappings from the modules; and the alignment unit accepts input of codes from one of the coding standards and to use the aggregated mappings from the module adjustment u

Abstract: Exemplary systems and methods for visualization of data analysis are provided. In various embodiments, a method comprises accessing a database, analyzing the database to identify clusters of data, generating an interactive visualization comprising a plurality of nodes and a plurality of edges wherein a first node of the plurality of nodes represents a cluster and an edge of the plurality of edges represents an intersection of nodes of the plurality of nodes, selecting and dragging the first node in response to a user action, and reorienting the interactive visualization in response to the user action of selecting and dragging the first node.

Abstract: Unstructured data items are stored at an object storage service. A filtering criterion to be used to generate a result set for an access request is determined. A test that can be used to determine, without completing parsing of a record identified in an unstructured data item, whether the record satisfies the filtering criterion is identified. Parsing of a particular record is abandoned in response to determining, using the test, that the record satisfies the filtering criterion. A response to the access request is determined using a subset of records that satisfy the filtering criterion.

Abstract: Systems and devices for presenting coordinated event search results in a user interface for a calendar are disclosed. In an example, operations include: generating a calendar surface user interface, to display at least one event in a calendar view; receiving a search query for a search of the calendar; generating a search result user interface, to display events from a result of the search query; and updating the calendar surface based on the search result, with the display of the events in the calendar surface being updated based on a match with the search query. As various examples, based on the search results or the search query: the search result portion may indicate that a corresponding event is displayed within the calendar surface portion; graphical emphasis effects may be applied to search results or events; or graphical de-emphasis effects may be applied to search results or events.

Abstract: Mechanisms are provided for performing an operation based on an identification of similar lines of questioning by input question sources. Question information identifying extracted features of an input question and a first source of the input question is obtained. A clustering operation is performed to cluster the input question with one or more other questions of a cluster based on a similarity of the extracted features of the input question to features of the one or more other questions. An operation is performed based on results of the clustering of the input question with the one or more other questions.

Abstract: Techniques described herein relate to systems and methods of data storage, and more particularly to providing layering of file system functionality on an object interface. In certain embodiments, file system functionality may be layered on cloud object interfaces to provide cloud-based storage while allowing for functionality expected from a legacy applications. For instance, POSIX interfaces and semantics may be layered on cloud-based storage, while providing access to data in a manner consistent with file-based access with data organization in name hierarchies. Various embodiments also may provide for memory mapping of data so that memory map changes are reflected in persistent storage while ensuring consistency between memory map changes and writes. For example, by transforming a ZFS file system disk-based storage into ZFS cloud-based storage, the ZFS file system gains the elastic nature of cloud storage.

Abstract: An information processing apparatus is provided that includes a memory storing a program and a processor configured to execute the program to implement processes of determining whether an execution request for executing a function of the information processing apparatus has been accepted from a user, acquiring information relating to the execution request upon determining that the execution request has been accepted, generating a screen to be displayed on a display unit based on the acquired information relating to the execution request, executing an authentication process with respect to the user, and controlling the display unit to display the generated screen when the user has been successfully authenticated by the authentication process.