Abstract: Examples of dynamic database query efficiency improvement are provided herein. Query portions of a received database query can be identified as candidates for replacement. The candidates for replacement can be query portions that reduce the efficiency of the query. Alternative queries can be determined that include substitute query portion(s) in place of candidate(s) for replacement. An expected performance of the alternative queries can be determined. Based at least in part on the expected performance of the alternative queries, one or more alternative queries can be selected as replacement database queries for the received database query.

Abstract: Adaptable internet-of-things (IoT) computing systems and methods are disclosed for improved and flexible declarative control of streaming data, such as Big Data, in compute intense environments. A declarative scripting engine determines an input data stream based on a first declarative statement defining input data stream variable(s) of a declarative scripting language in declarative scripting module(s). The input data stream is bound to a stream controller and is ingested into computer memory. The declarative scripting engine generates a snapshot data stream based on a second declarative statement in the declarative scripting module(s), and is derived from the input data stream. A stream model is defined, where a listener entity comprising an event is triggered based on the input data stream or the snapshot data stream as ingested into the stream model.

Abstract: A computer-implemented method includes positioning a sliding window over a string of data and calculating a hash value using a rolling hash function for data encompassed by the sliding window. The method includes determining whether the calculated hash value for the data encompassed by the sliding window matches the value of an element in a cut point candidate (CPC) array by comparing the calculated hash value to the value of a first element in the CPC array. In response to the calculated hash value being equal to the value of the first element in the CPC array, the method includes defining an index of the sliding window as the cutting point for a data block.

Abstract: A client may send to a provider network a request to classify data at one or more data sources of the client network. The provider network receives the request and transmits the request to a local instance of a network-based data classification service at the client network. The local instance of the network-based data classification service classifies the data at the one or more data sources. The data is not exposed outside of a data isolation boundary associated with the client network during classification of the data by the local instance of the network-based data classification service. The provider network may initially provision the local instance of the network-based data classification service to run on the client network.

Abstract: A method includes receiving a plurality of files where each file represents an object. The method further combines selected files of the plurality of files into an aggregation file and stores the aggregation file on low-latency storage media, such as disk storage media. The method represents the aggregation file with a single inode that is stored on the low-latency storage media. The method migrates the aggregate file to high-latency storage media, such as tape storage media. By collecting files into larger aggregation files, the number of files archived is significantly reduced and the files archived are of larger size. The reduced number of files and increased size of the files improves archival and retrieval performance due to reduced metadata operation overhead. A corresponding system and computer program product are also disclosed.

Abstract: A response to a first query related to a geographic area, and search results responsive to a second query related to the geographic area, are received from a server system. A digital map of the geographic is provided via a user interface. A focus is provided to the first query to illustrate the response on the digital map, where the response defines a geographic context. A subset of the search results is identified based on a relationship to the geographic context. The search results in the identified subset are visually emphasized on the digital map relative to the rest of the search results.

Abstract: Systems, methods, and non-transitory computer-readable media can, for a first content item comprising a plurality of scan versions, calculate render scores for at least some of the plurality of scan versions, each render score being indicative of a likelihood of an associated scan version to render successfully on a first client computing device. A first scan version of the plurality of scan versions is selected based on the render scores. The first scan version of the first content item is transmitted to the first client computing device.

Abstract: The present invention relates to a method and a system for generating MARC data in real time, and the method for generating MARC data in real time, according to one embodiment of the present invention, can comprise the steps of: (a) constructing a database by using MARC data and book information about a book having the MARC data generated therein; (b) receiving book information about a new book, and generating MARC data of the new book on the basis of the database and the received book information about the new book; and (c) providing the generated MARC data about the new book to a user.

Abstract: Systems and methods for live reindexing include receiving, at a dispatch server, a request to reindex a database, wherein, at the time the request to reindex is received, the dispatch server is configured to send queries for information in the database to a first index server, the first index server comprising a first index of information in the database. The systems and methods further include, responsive to receiving the request to reindex and while the database is live, generating a second index of the information in the database, storing the second index at a second index server, and configuring the dispatch server to use the second index server as a live index server and to no longer use the first index server as a live index server.

Abstract: Systems, methods, and devices for retrying a query. A method includes receiving, by a first database query manager, a query directed to database data from a client account. The method includes assigning an original execution of the query to one or more execution nodes of an execution platform. The method includes determining the original execution of the query was unsuccessful. The method includes transferring the query to a second database query manager configured to manage internal tasks for improving operation of a database platform that are not received from client accounts. The method includes assigning, by the second database query manager, a retry execution of the query to one or more execution nodes of an execution platform.

Abstract: A method including generating an index comprising (a) question-answer pairs generated based at least in part on a set of ingested source documents and (b) respective location metadata associated with each of the question-answer pairs. The respective location metadata can include a source document identifier of a first ingested source document of the set of ingested source documents and one or more location delimiters indicating a location of target text in the first ingested source document. The target text can correspond to a stored answer of a respective one of the question-answer pairs associated with the respective location metadata. The method also can include receiving a user question from a user. The user question can correspond to a question of a first question-answer pair of the question-answer pairs of the index.

Abstract: Data tags, such as may be used to classify data, can be automatically applied at appropriate times in a resource environment. A customer can provide an auto-tagging configuration file that can be used to determine tags to be applied to specific data objects based upon properties of those objects. The customer can also provide policies that indicate which actions can be performed for those objects based at least in part upon the applied tags. The tags can be automatically applied at any appropriate time, such as upon storage into the environment, upon modification of the auto-tagging configuration, or upon modification or the data object. In some embodiments, an auto-tagging process can also be performed in response to a request for access to the data object in order to ensure that the correct tags are applied before determining the permitted actions.

Abstract: Examples of techniques for tracking client sessions in a publish and subscribe system using a shared repository are described herein. An example system includes a processor of a server to receive a connection request with a client identifier from a client a predefined policy for duplicate client sessions. The processor is to query a shared repository of the system using the client identifier. The processor is to also execute a set of actions based on the predefined policy, a query result including a detected duplicate client session from the shared repository, and a set of parameters.

Abstract: There is provided data source system agnostic fact partitioned data information repository system comprising: a data repository comprising: a plurality of fact partitions; a plurality of dimensions stored in relation to the fact partitions, the plurality of dimensions shared by each of the fact partitions; and a plurality of data source system specific data mappings; a data receiver for receiving data from the plurality of data source systems; and a data mapper for partitioning the data into the plurality of fact partitions using the plurality of data source system specific data mappings.

Abstract: Systems, methods, and devices for retrying a query. A method includes receiving, by a first database query manager, a query directed to database data from a client account. The method includes assigning an original execution of the query to one or more execution nodes of an execution platform. The method includes determining the original execution of the query was unsuccessful. The method includes transferring the query to a second database query manager configured to manage internal tasks for improving operation of a database platform that are not received from client accounts. The method includes assigning, by the second database query manager, a retry execution of the query to one or more execution nodes of an execution platform.

Abstract: Herein are computerized techniques for deploying JavaScript and TypeScript stored procedures and user-defined functions into a database management system (DBMS). In an embodiment, a computer generates a SQL call specification for each subroutine of one or more subroutines encoded in a scripting language. The generating is based on a signature declaration of the subroutine. Each subroutine comprises a definition of a stored procedure or a user-defined function. The computer packages the definition and the SQL call specification of each subroutine into a single bundle file. The definition and the SQL call specification of each subroutine are deployed into a DBMS from the single bundle file. Eventually, the SQL call specification of at least one subroutine is invoked to execute the definition of the subroutine in the DBMS.

Abstract: A database entry may be stored in a container in a database table corresponding with a partition key. The partition key may be determined by applying one or more partition rules to one or more data values associated with the database entry. The database entry may be an instance of one of a plurality of data object definitions associated with database entries in the database. Each of the data object definitions may identify a respective one or more data fields included within an instance of the data object definition.

Abstract: Techniques are provided for transitioning from a hierarchical file system to an object store. A request is received to change file metadata of a hierarchical file system. In response to the request: in-cache file metadata of the hierarchical file system is modified. The in-cache file metadata includes a directory structure of the hierarchical file system and file metadata of the hierarchical file system. Additionally, an in-store metadata journal entry is generated. The in-store metadata journal entry indicates an update to in-store file metadata. The in-store file metadata includes the directory structure of the hierarchical file system and file metadata of the hierarchical file system and is stored in an object store. The in-store metadata journal entry is stored in the object store. Furthermore, in-store file metadata and in-store metadata journal entry may be used to reconstruct the in-cache file metadata on another node.

Abstract: A system and computer implemented method for cataloging database metadata using a signature matching process are provided. The method includes receiving an input name to be matched to a key in a seed table; generating a first fingerprint by decomposing the received input name into a first set n-grams; generating, based on the received input name, a second fingerprint using a predetermined pronunciation schema, wherein the second fingerprint is a phonetic fingerprint; generating a third fingerprint by decomposing the second fingerprint into a second set of n-grams; identifying a matching key by matching any combination of the first fingerprint, the second fingerprint, and the third fingerprint against keys in the seed table; and cataloging the metadata with the matching key as a tag.

Abstract: Methods, computer program products, and computer systems for performing dynamic storage tiering in a virtual environment are disclosed. In one embodiment, such a method can include moving a storage object from a first storage tier of a storage system to a second storage tier of the storage system, which can be performed based, at least in part, on tiering information. Such moving can include determining a location of the storage object in the storage system by translating a location of the storage object in a virtual machine file to the location of the storage object in the storage system, using mapping information, and transmitting an instruction to a storage manager of the storage system. The instruction indicates that the storage manager should perform the moving. The mapping information translates a location in the virtual machine file to a corresponding location in the storage system.