G06F16/24573

Automated discovery of databases

In some examples, a networked computing system comprises a backup node cluster of a backup service in communication with a host database node cluster of a host, a host database at least initially undiscovered by the backup node cluster, one or more processors coupled with memory storing instructions that, when executed, perform operations comprising at least installing a backup agent on at least one node of the host database node cluster, registering the host at the backup service, based on the host registration, triggering a host database discovery process to discover the undiscovered database automatically, the discovery process including a discovery call, in response to the discovery call, receiving metadata relating to the discovered database, and communicating with the discovered database.

System and method for facilitating metadata identification and import
11561976 · 2023-01-24 · ·

Techniques and solutions are described for storing and processing metadata, including to instantiate database artefacts at a target system based on metadata for database artefacts maintained at a source system. The target system can query the source system for metadata associated with database artefacts of the source system. The target system can instantiate database artefacts based on such metadata. The database artefacts of the target system are linked to corresponding database artefacts of the source system, such as by associating a database artefact of the target system with an API useable to obtain data or metadata from the source system for a corresponding database artefact of the source system. The target system obtains additional data or metadata for a database artefact of the target system using a corresponding API.

Platform for semantic search and dynamic reclassification

A platform receives an input document from a user device and automatically determines a semantic signature for the input document based on a probabilistic distribution of rare words within the input document. The platform automatically scrapes at least one Internet database for additional documents and webpages, determining semantic signatures for each document or webpage. Based on similarity of semantic signatures, the platform automatically constructs and displays a graphical network of documents, wherein each document is represented as a node and similarity of semantic signatures is used to determine the locations of edges between nodes. The graph automatically groups nodes by communities and selects nodes in different communities to promote serendipity of results.

Systems and methods of establishing correlative relationships between geospatial data features in feature vectors representing property locations

In an illustrative embodiment, an automated system engineers customized feature vectors from geospatial information system (GIS) metadata. The system may include computing systems and devices for extracting metadata for GIS features located within a predetermined distance of a property from a GIS map file and storing the extracted GIS features within a feature vector. The system can augment each of the extracted GIS features with amplifying data features extracted from external data sources. The system can calculate a distance between the property and each extracted GIS feature, which establishes a relationship between the property and each GIS feature and associated amplifying data features. Amounts of correlation between each of the extracted GIS features and associated amplifying data features within the feature vector and a market assessment of the property location can be identified using a data model trained with a data set customized to characteristics of the property.

Collision-free hashing for accessing cryptographic computing metadata and for cache expansion

Embodiments are directed to collision-free hashing for accessing cryptographic computing metadata and for cache expansion. An embodiment of an apparatus includes one or more processors to: receive a physical address; compute a set of hash functions using a set of different indexes corresponding to the set of hash functions, wherein the set of hash functions combine additions, bit-level reordering, bit-linear mixing, and wide substitutions, wherein the plurality of hash functions differ in the bit-linear mixing; access a plurality of cache units utilizing the set of hash functions; read different sets of the plurality of cache units in parallel, where a set of the different sets is obtained from each cache unit of the plurality of cache units; and responsive to the physical address being located one of the different sets, return cache line data of the set corresponding to the set of the cache unit having the physical address.

Restricted views to control information access in a database system
11704306 · 2023-07-18 · ·

A restricted view definition is received by a database system. The restricted view definition defines a view over a database table with one or more restrictions on use of the view. The view over the database table is generated based on the restricted view definition. A query directed at the view is received by the database system. The database system determines whether the query directed at the view is permitted based on the one or more restrictions on the use of the view.

OPERATION FRAGMENTATION WITH METADATA SERIALIZATION IN QUERY PROCESSING PUSHDOWNS

Methods for operation fragmentation with metadata serialization in query processing pushdowns are performed by systems and devices. A compute node receives a query directed to database data, and generates query text fragments. Portions of metadata of the database are read from different page servers, and are serialized by the compute node. Page identities of data pages in a page server that stores the data are determined from a page index at the compute node, and the compute node provides the text fragments, the serialized metadata, and the page identities to the page server storing the data. The page server compiles the text fragments based on the serialized metadata to generate an executable query plan for the query. The page server initializes and performs execution of the executable query plan against the data as a pushdown query operation, and a result of pushdown query operation is provided to the compute node.

SYSTEM FOR MANAGING DATABASE HAVING RECORDS WITH VARYING NUMBER OF FIELDS
20230018268 · 2023-01-19 ·

A system for managing a database having records with a varying number of fields can include a processor and a memory. The memory can store a determination module and an allocation module. The determination module can include instructions that when executed by the processor cause the processor to determine a category of content in a first field of a record of the database. The allocation module can include instructions that when executed by the processor cause the processor to cause, in response to the category being: (1) a first category, a count of other fields of the record to be a first number and (2) a second category, the count of the other fields of the record to be a second number. The system can allocate a group of memory cells for each field included in a corresponding record of the database, rather than for each field of each record.

Data aggregator graphical user interface

Systems and methods for generating a data aggregator interactive graphical user interface. An interactive graphical user interface (GUI) includes a selectable symbol region, a query region and a data results region. The selectable symbol region displays predefined symbols. The query region displays user input fields for generating queries. The system receives user input associated with the user input fields of the query region to form a filter set. The data results region is automatically updated responsive to the user input, to display one or more data values from among one or more databases associated with the filter set. The system receives a subscription request to save the filter set as a user-customized query. A custom symbol is created responsive to the subscription request that is associated with the filter set. The the selectable symbol region is updated to display the custom symbol together with the predefined symbols.

SCHEMA VALIDATION WITH SUPPORT FOR ORDERING
20230014239 · 2023-01-19 ·

Computer-readable media, methods, and systems are disclosed for validating data associated with schemas. A user defines the object model of at least one asset and a first schema is generated in accordance with the defined object model, and a unique fingerprint is generated. Data is collected from one or more devices in accordance with the object model. The collected data is serialized, and a second schema is generated. The second schema is ordered in accordance with the first schema and a unique fingerprint is generated. The fingerprint of the first schema is compared to the fingerprint of the second schema to provide an efficient review process for determining whether the schemas are equal, and the associated data may be validated. A fingerprint cache may be updated with fingerprints associated with a plurality of schemas, as well as version history of each schema, to provide an efficient review process.