7 results about "Database catalog" patented technology

An improved data system supports creation of multiple hierarchical database catalogs under a particular account. Users or organizations have the flexibility to organize their data, native or external, into an n-level hierarchy of their choice. There is a root database catalog of the account, and other catalogs (1 or n-levels) are created under it. The data system has extract, transform, and load (ETL) features that allows data to be moved between different data sources and targets.

The invention relates to an orphan file processing method and device, computer equipment, a computer readable storage medium and a computer program product. The method comprises the steps that an orphan file processing instruction is obtained, the orphan file processing instruction carries a target database label, and the target database label is used for determining a target database for executing the orphan file processing instruction; querying a database directory table by using the target database tag, determining a storage space corresponding to the target database, and obtaining each file in the storage space to obtain a first file data set; according to the target database label, a corresponding table record table is determined, a target field in the table record table is determined, and the target field is matched with a field value of a preset field; obtaining each file corresponding to the target field to obtain a second file data set; and determining the orphan file according to the first file data set and the second file data set. By adopting the method, the accuracy of orphan file determination can be improved.

Described herein are systems and techniques to facilitate a rapid database system that automates estimating a database footprint for a database implemented across multiple environments. The system may receive inputs from a user and / or automatically generate inputs. The system may determine database size using various logic-based extraction methods. For instance, operational database resources may be sized using logic-based extraction to search a database catalog of a production database, non-production databases may be sized using logic-based extraction to search database catalog metadata, development database resources may be sized using fuzzy logic queries generated based on production database information (e.g., since development database names are likely to resemble, but be different than, production database names), and associated mirror databases are also determined and measured during these steps. Outputs from the queries are used to generate a database footprint estimate and cost information, which may be transmitted to a user device for display.

An improved data system supports creation of multiple hierarchical database catalogs under a particular account. Users or organizations have the flexibility to organize their data, native or external, into an n-level hierarchy of their choice. There is a root database catalog of the account, and other catalogs (1 or n-levels) are created under it. The data system has extract, transform, and load (ETL) features that allows data to be moved between different data sources and targets.

A system includes reception of a first transaction including updates to a database catalog comprising transactions stored on a log and a timestamp of a snapshot of the database catalog, determination of a signature of a transaction stored on the log after the timestamp of the snapshot, determination, based on the signature, that a conflict exists between the updates to the database catalog and updates of the stored transaction, and, in response to the determination that a conflict exists, reject the first transaction.

Systems, methods are provided for encrypting, decrypting, re-encrypting an existing database with neither downtime nor storage overhead. Create a list of tables to be processed. Identify status of each table by an indicator in a database catalog. Store a second status in each data page. Select a table to process from list of tables. Issue a table lock against the selected table. Select a configurable number of data pages to process during the duration of the table lock. Following the processing, flush the data pages to storage. If there are no more data pages to encrypt for the selected table, remove the selected table from the list of tables to be processed. Release the table lock. If there are more data pages to process in the selected table, and there are waiters for the selected table, release the table lock; select another table from the list of tables to process.

Methods and systems are described for assisting in programming stimulation parameters for deep brain stimulation (DBS) of a subject patient. A cumulative database records a set of stimulation parameters used in a programming session for a plurality of patients and associates the set of parameters with good treatment outcomes and / or side effects. The cumulative database also includes a stimulus field model (SFM) for the set of parameters. The overlap of the SFM for the set of parameters may be associated with a therapeutic effect and used to determine a target volume and / or an avoidance volume for stimulation of the subject patient. In some embodiments, the SFMs may be weighted to de-emphasize the volume near the electrode leads.