Abstract: Disclosed herein are system, method, and computer program product embodiments for providing a natural, pen-and-paper user experience that harnesses cutting edge artificial intelligence and machine learning to enhance user interactions with data in a suite of software applications. The pen-and-paper user experience may mimic the time-honored human tradition of writing with pen and paper, allowing users to work in an intuitive, productive, familiar fashion. The user experience may automatically retrieve objects, e.g., data, charts, tables, graphs, etc. from backend systems and display the objects in the user experience. The user experience may allow users to provide additional natural language directly on or around the objects and update the displayed results accordingly.

Abstract: Data in a micro-partition of a table is stored in a compressed form. In response to a database query on the table comprising a filter, the portion of the data on which the filter operates is decompressed, without decompressing other portions of the data. Using the filter on the decompressed portion of the data, the portions of the data that are responsive to the filter are determined and decompressed. The responsive data is returned in response to the database query. When a query is run on a table that is compressed using dictionary compression, the uncompressed data may be returned along with the dictionary look-up values. The recipient of the data may use the dictionary look-up values for memoization, reducing the amount of computation required to process the returned data.

Abstract: The present invention provides a system, method and software for digitizing and automating an auditing process. The system comprises a computer, a regulations database, a storage database, and a software program. The method includes: providing regulations or standards for a user to select from the regulations database as a focus for an audit; providing a user-selected filtered regulation or standard from the regulations database; presenting the user a plurality of audit questions in the form of an audit row, one audit row at a time; receiving user responses from which at least one standard row item is created and/or updated; and sending one or more of a filtered regulation or standard row item to the storage database as an audit. The system may permit user information updates. After an audit is completed, the system may transfer the audit information into a final report, which may be provided to the user.

Abstract: Embodiments use a graphical tree to illustrate hierarchical records including a child record having parent field(s) identifying a first parent record and a second parent record of the child record. The graphical tree is generated by determining a first position for the child record and a second position for the first parent record without considering the second parent record. Subsequently, a third position for the second parent record is determined at a same level as the second position. Once the positions are determined, a first shape, a second shape and a third shape are rendered at the first position, the second position and the third position, respectively. The graphical tree is then generated by visually connecting the first shape with the second shape and the third shape, thereby graphically illustrating the plurality of hierarchical records on a target output medium.

Abstract: A system may deliver personalized content to a user. The system may create a user persona based on demographic information and stored clickstream data of the user. The system may learn which functionalities the user typically uses on a webpage, and the system may create a personalized version of the webpage for the user.

Abstract: Provided are methods and systems for using multi-faceted trust scores in data security. A method may commence with determine a plurality of data facets for a data item. The method may further include determining a plurality of parameters and weights corresponding to the plurality of data facets associated with the data item. Upon determining the plurality of parameters and weights, at least one trust score for the data item may be calculated based on the plurality of parameters and weights. The method may further include selectively taking an action based on the at least one trust score.

Abstract: Systems and methods are provided for tracking data in a computer network. An exemplary method includes: storing a first data in the one or more data servers; receiving a first request to aggregate the first data; aggregating a first set of the first data; analyzing one or more fields of each of the first set of the first data; removing the one or more first data elements from the first set of the first data; generating a second set of the first data; aggregating the second set of the first data; retrieving information associated with the aggregation of the second set of the first data; and generating one or more reports using the retrieved information associated with the aggregation of the second set of the first data.

Abstract: Techniques for a database management system to predict when in the future a materialized view will have a quiet period during which the materialized view will not be stale. This is a followed by an approach that uses the quiet period prediction to determine an optimized schedule for refreshing the materialized view. The approach combines the quiet period prediction with a query rewrite pattern prediction for the materialized view and an estimated refresh duration for the materialized view to determine the optimized refresh schedule for the materialized view.

Abstract: The invention relates to an electronic element supporting data inquiry method, a storage medium and a terminal. The method comprises: obtaining an initial series element code; splitting the initial series element code according to a preset splitting mode to obtain at least a sub-word; establishing a corresponding relationship between the sub-word and the electronic element supporting data and storing the corresponding relationship in a database. Receiving an electronic element identifier; extracting at least a sub-word corresponding to the electronic element identifier, wherein the sub-word is a part of the electronic element identifier; searching for a data tag corresponding to the sub-word, wherein the data tag comprises the sub-word; obtaining the electronic element supporting data corresponding to the data tag. Through the implementation of the invention, the workload in the database construction process is greatly reduced, and the maintenance cost is reduced.

Abstract: A multi-cluster configuration of a database management system in a virtual computing system includes a server that defines a first policy for a source database on a first cluster of a plurality of clusters. Each of the plurality of clusters is registered with the server and the first policy defines capture of snapshots and/or transactional logs from the source database on the first cluster. The server defines a second policy for the source database to replicate at least some of the snapshots and/or transactional logs from the first cluster to a second cluster of the plurality of clusters, captures a first snapshot and/or a first transactional log from the source database in accordance with the first policy, and replicates the first snapshot and/or the first transactional log to the second cluster in accordance with the second policy.

Abstract: A novel framework optimizes SQL queries that are generated from a templated virtual sematic layer. The framework introduces the use of a virtual semantic layer into database management systems' operations, whereby templated SQL queries can be rewritten according to a determined and measured nesting, dimensional structure that produces an optimized search system. This enables templated SQL fragments to be translated for query optimization, thereby reducing the drain on a database's resources and minimizing a query's impact on the database's performance.

Abstract: In an example embodiment, a solution is used to provide for multiple and concurrent web application accessing of a database in a database-as-a-service (DBaaS) framework. More particularly, a cloud solution is provided on a DBaaS for leveraging Docker network functionality to provide a virtual Internet Protocol (IP) address pool, while utilizing in-memory database technology to set up an entire accessing solution for multiple and concurrent DBaaS users and web applications, which serve the data-intensive jobs to the in-memory database. This allows for improved functionality, performance, concurrency, and handling of network stress.

Abstract: Methods, systems, and computer-readable storage media for notarized communication between platform systems is provided. A first data object is notarized by storing a first root hash value at a blockchain network. The first root hash value is notarized in response to a transaction request received through a first notarization interface instantiated at a first platform system. A subscription for the first platform system is established to provide notification events in relation to a second data object. The first root hash value comprises an object reference to a second root hash value for the second data object. A notification event is sent for the second data object to the first platform system, comprising a third root hash value of a third data object associated with the second data object. The third data objects is notarized at the blockchain network by the second platform system through a second notarization interface.

Abstract: Identification of content gaps based on relative user-selection rates between multiple discrete content sources. A system analyzes search log activity to determine whether users that are conducting particular types of search activities are ultimately selecting and relying upon content resources from a predefined content source of interest or, alternatively, whether such users are unsatisfied with the predefined content source of interest and are instead relying upon other third-party content sources. This particular type of analysis provides valuable insights into whether content gaps exist within the predefined content source of interest.

Abstract: An embodiment of the present invention is directed to implementing a data usage analytics engine for database systems. An embodiment of the present invention is directed to implementing a Data Usage Analysis engine that receives queries (e.g., SQL queries), tables (e.g., Internal Catalog tables) and/or other data formats as input. An embodiment of the present invention may then parse the queries and identify various data usage patterns. This may include details concerning what tables are used, how much data is queried at what intervals, frequency of querying along what attributes are used in the queries and/or other usage details in various levels of granularity.

Abstract: Systems and methods for guaranteeing the integrity of created within or transferred using a network of moving things. Different types of data from different data sources may be monitored, and various approaches to validating such data may be employed using expected data characteristics, alternate data sources, and historical information to help maximize the likelihood that data destined for a particular destination is available when needed, and is found to be valid and reliable.

Abstract: In some embodiments, a context-based translation application generates a co-occurrence data structure for a target language describing co-occurrences of target language words and source language words. The context-based translation application receives an input tag for an input image in the source language to be translated into the target language. The context-based translation application obtains multiple candidate translations in the target language for the input tag and determines a translated tag from the multiple candidate translations based on the co-occurrence data structure. The context-based translation application further associates the translated tag with the input image.

Abstract: Persistence and linking of analytic products is provided. Information regarding a plurality of analytic methods is collected. A first process node is generated in a network. The first process node corresponds to a first analytic method. Information is collected regarding a plurality of executions of the first analytic method. A plurality of session nodes is generated in the network corresponding to the plurality of executions. Each of the plurality of session nodes is linked to the first process node. Metadata regarding the plurality of executions is associated with the plurality of session nodes. At least one product node is generated corresponding to a product. The product integrates a result value of at least one of the plurality of executions. The at least one product node is linked to the session node of the plurality of session nodes corresponding to the at least one of the plurality of executions.

Abstract: Embodiments use a phantom apex node to graphically illustrate a plurality of hierarchical records. Each record includes a parent field, and an entry in the parent field identifies a parent record of a given record. The parent record is higher in hierarchy than the given record. Embodiments identify record(s) that have no entry in the parent field. A phantom apex record is added to the database. A reference to the phantom apex record is inserted for each record that did not have an entry in the parent field. An x-y coordinate position is determined for all hierarchical records based on the parent field in each record. Once the positions are determined, all references to the phantom apex record are removed from all of the parent fields, and the phantom apex record itself is removed from the database. The plurality of records are then graphically rendered on a target output medium.

Abstract: A database system operates by: receiving a user-generated secondary indexing hint data for a dataset from a client device, wherein the client device generated the user-generated hint data based on user input in response to at least one prompt displayed by an interactive interface displayed via a display device of the client device; generating a plurality of segments that each include distinct subsets of a plurality of rows of a dataset; automatically selecting, for each of the plurality of segments, a secondary indexing scheme from a plurality of secondary indexing options based on the user-provided secondary indexing hint data; generating a plurality of secondary indexes for each of the plurality of segments in accordance with the corresponding secondary indexing scheme; and storing the plurality of segments and the plurality of secondary indexes in memory.