Abstract: Embodiments of the present invention provide a method, system and computer program product for test data generation using unique common factor sequencing. In an embodiment of the invention, a method for test data generation using unique common factor sequencing is provided. The method includes loading a table for population with test data in a test data generation tool executing in memory of a computer. A column set of multiple columns in the table associated with a key to the table can be selected for processing and different cardinality sequence values are assigned to the columns in the set such that the cardinality sequence values do not share a common factor except for unity as in the case of prime numbers.

Abstract: Methods and systems for generating a database index and searching the database index are described herein. In one aspect this may include receiving an item of database data, wherein the item of database data comprises a sequence of data elements. Groups of data elements may be identified within the received item of database data. If any one or more of the identified groups of data elements have not been previously identified within the item of database data and/or previous items database data then the one or more identified group may be stored as index entries in a database index. Information describing the sequence of the groups of neighbouring data elements may be recorded within the database index as they are located within the item of database data. The database index may be searched based on a received search term comprising a sequence of data elements.

Abstract: In an embodiment, a database platform receives query instructions for a query on a database, where the query instructions include instructions for a geospatial-function join that includes a geospatial-function predicate. The database platform generates a query-execution plan based on the query instructions, including replacing the geospatial-function join with one or more interval joins that each include one or more predicates implied by the geospatial-function predicate. The database platform inserts, into the query-execution plan above the one or more interval joins, a filter operator that applies the geospatial-function predicate. The database platform obtains results of the query at least in part by executing the query-execution plan, and returns the query results in response to the query.

Abstract: In some implementations, a method includes, for each of multiple hosts: identifying visual leaf pages hosted by the host that are each a web page including image data defining an image or a video that is prominently displayed relative to all other content of the web page, identifying a set of hub pages hosted by the host that each link to at least one of the visual leaf pages through an image-based link, and for each hub page, generating cluster data representing the visual leaf pages to which the hub page links by determining, for each visual leaf page, a set of feature values that each indicate pre-defined features of the visual leaf page, and generating, from the sets of feature values, a set of central feature values as the cluster data for the hub page that indicate a central tendency of each respective pre-defined feature.

Abstract: In certain embodiments, media item search and machine learning system training may be facilitated. In some embodiments, a first set of media items may be obtained (based on performance of a query) and presented on a user interface. A user selection of a media item of the first set may be obtained, and the query may be updated based on the user-selected media item. A second set of media items may be obtained based on performance of the updated query, and media items of the second set may be assigned to a group based on their similarities with one another. A predicted name for the group may be determined via a machine learning system and presented on the user interface. A user-indicated update to the predicted name for the group may be obtained and provided to the machine learning system to train the machine learning system.

Abstract: A method for communicating data includes connecting stand-alone software agents customized for different source data repositories with the different source data repositories. The method also includes the stand-alone software agents generating first-stage data feeds in a neutral format in accordance with the customization by dynamically selecting, from within the source data repositories, selected source data and transforming the selected source data into the first-stage data feeds in the neutral format. The method also includes the stand-alone software agents sending the first-stage data feeds to an aggregation agent. The aggregation agent generates for a user and based on specified criteria, a second-stage output as a composite of selected source data from the first-stage data feeds.

Abstract: Systems and methods are disclosed for generating messages in a cloud platform. One method comprises storing a collection of audio files and destination information identifying location information corresponding to plurality of different geographic locations where a plurality of edge devices are located and grammar information including language-specific rules, receiving messages from one or more of a plurality of requesting devices, the messages including a first type of message and a second type of message, generating an action list, determining an available time slot at a first geographic location of a first edge device when the first edge device is available to render an announcement, retrieving, using the grammar information associated with the second type of destination information included in the action list, an audio file from the collection of audio files stored; and transmitting the audio file and the action list to the first edge device to render an announcement.

Abstract: In providing visual cues in a document, a server captures search term(s) input by a user and detects a user selection of a document returned based on the search term(s). The server determines a dataset describing the user, where the dataset includes the search term(s), the document, and a set of demographic data of the user. The server maps the dataset to a user group, where the user group is associated with an expertise level for a domain associated with the document. The server assigns the expertise level associated with the user group to the user and maps the expertise level of a risk model for the domain. The risk model is applied to the document to identify the content segments that may pose a risk of harm to a reader with the user's expertise level. The document with the visual cues can then be displayed to the user.

Abstract: An approach is provided for sending a notification of change(s) in a database in a multi-client database environment. Event data in a database satisfying criteria is identified by examining a log that is updated after the event data is committed in the database. The criteria indicate change(s) in data in the database. The event data is grouped into data sets specified by subscriptions of client computer(s) in the multi-client database environment. The grouped event data is pushed to the client computer(s) for consumption by application(s) being executed by the client computer(s), respectively. A notification is sent to the client computer(s) of the change(s) to the data in the database.

Abstract: A database platform receives query instructions for a query on a database, where the query instructions include a geospatial-function join that includes a geospatial-function predicate. The database platform generates a query-execution plan by replacing the geospatial-function join with a single interval join that has an interval-join predicate that is implied by the geospatial-function predicate, and by also inserting a filter above the single interval join to apply the geospatial-function predicate. The database platform executes the query-execution plan, and returns query results in response to the query.

Abstract: Methods and systems for optimizing a number of files stored in a distributed file system are provided. The method includes determining whether the size of a plurality of input files in a directory are less than a block size. The method further includes determining whether the size of the input files in the directory divided by a desired file size is greater than a threshold. Additionally, the method includes combining the collection of input files into a reduced set of files.

Abstract: A system and a method for locating application-specific data that has been previously deleted and located in an address of the data storage device marked as being available for storing new data. The method includes accessing unidentified data from at least one data storage device; examining the unidentified data to detect at least one application-specific data pattern associated with at least one application; for each detected application-specific data pattern, executing an application-specific validation process to determine whether the unidentified data includes valid data associated with a corresponding application; and if it is determined that the unidentified data includes valid data associated with the corresponding application, then recovering the valid data.

Abstract: A database platform receives query instructions for a query on a database, where the query instructions include a geospatial-function join that applies a geospatial-function predicate to a first relation that includes a first join key and a second relation that includes at least one row in which a second join key is a point. The database platform generates a query-execution plan by replacing the geospatial-function join with a one-sided interval join of at least a first portion of the first relation and the at least one row of the second relation in which the second join key is a point, and by also inserting a filter above the one-sided interval join to apply the geospatial-function predicate. The database platform executes the query-execution plan, and returns query results in response to the query.

Abstract: A computer program product is provided for auditing data in object storage. The computer program product comprises a computer readable storage medium having program instructions embodied therewith. The program instructions executable by a processor to cause the processor to: send, by the processor, an object to an object storage system. A directive to audit the object is also sent to the object storage system by the processor. Furthermore, one or more additional directives are sent to the object storage system by the processor. Each of the one or more additional directives are independently selected from the group consisting of: a feedback directive to obtain feedback regarding a progress and/or a status of the audit; and a control directive to start, pause, or stop the audit.

Abstract: A system provides emotionally and intellectually relevant responses to user queries received by a chatbot instantiated by a computing device. The system also receives user data associated with the user query. The user query is communicated to a first supervised machine learning model to obtain a first plurality of ranked responses. The system also communicates the received user data to a second supervised machine learning model to obtain a first plurality of emotions associated with the user data. The system then determines determine a second plurality of emotions for the first plurality of responses and re-ranks the first plurality of responses based on a comparison of the first plurality of emotions and the second plurality of emotions. The system then selects a response to the user query from the re-ranked responses and outputs the selected response using the chatbot instantiated by the computing device.

Abstract: Provided are systems and methods for storing checkpoints of an in-memory storage device. In one example, the method may include detecting database transactions performed on a slice of an in-memory storage and storing a record of the database transactions in a log file, receiving a request to persist the slice of in-memory storage, the request comprising a timing indicator corresponding to a timing of database transactions, trimming the log file based on the timing indicator to remove a record of one or more database transactions from the log file that occurred prior to the timing indicator and to preserve a record of one or more database transactions that occurred after the timing indicator, and persisting, to disk, data from the slice of in-memory storage and the trimmed log file preserving the record of the one or more database transactions that occurred after the timing indicator.

Abstract: A computer system is configured to provide a database system. The computer system comprises one or more processors, a primary database system implemented by the one or more processors, and a secondary database system implemented by the one or more processors. The secondary database system is configured as a hot-standby system for the primary database system. The secondary database system is capable of providing at least a minimum amount of essential functionality of the primary database system during a disruption to the primary database system. The secondary database system is configured by programming instructions, executable on the computer system, to cause the one or more processors to accept an authentication request from the client application to allow user access to the secondary database to execute the query and delegate an authentication check to the primary database system using connection credentials received from the client application.

Abstract: A stream application receives a stream of tuples to be processed by a plurality of processing elements. The plurality of processing elements operating on one or more compute nodes. Each processing element has one or more stream operators. The stream application assigns one or more processing cycles to one or more segments of software code. The segments of software code are embedded in a tuple of the stream of tuples. The software-embedded tuple identifies a set of target tuples based upon operation criteria. The set of target tuples are a part of the stream of tuples. The software-embedded tuple performs an operation based on the set of identified target tuples.

Abstract: A system for query planning and execution with source and/or sink operators is provided. In some implementations, the system performs operations comprising identifying a plurality of operators for executing a query, allocating space in memory for storing data when a second operator comprises a collection operator for collecting the data, generating at least a portion of the data based on executing a first operator, and providing the data (e.g., access to the data) to another operator which occurs after the first operator. In some implementations, a query plan for execution of the query can be generated to include the first operator and exclude the collection operator. Related systems, methods, and articles of manufacture are also described.

Abstract: A data analysis system allows users to interact with distributed data structures stored in-memory using natural language queries. The data analysis system receives a prefix of a natural language query from the user. The data analysis system provides suggestions of terms to the user for adding to the prefix. Accordingly, the data analysis system iteratively receives longer and longer prefixes of the natural language queries until a complete natural language query is received. The data analysis system stores natural language query templates that represent natural language queries associated a particular intent. For example, a natural language query template may represent queries that compare two columns of a dataset. The data analysis system compares an input prefix of natural language with the natural language query templates to determine the suggestions. The data analysis system receives user defined metrics or attributes that can be used in the natural language queries.