66 results about "Database object" patented technology

The invention discloses a data query method and device based on a natural language. The method comprises the following steps: receiving natural language input of a user; performing semantic analysis on the natural language input, and determining a user intention and a plurality of semantic elements; based on the user intention, target query operators corresponding to the semantic elements respectively are determined in a query operator sequence, and the query operator sequence comprises a plurality of query operators arranged according to the execution sequence; generating a query plan based on the target query operators, the semantic elements corresponding to the target query operators and the execution sequence of the multiple target query operators; a query statement is generated based on the query plan and target database object identifiers corresponding to the semantic elements respectively, and the target database object identifiers comprise at least one of table names and field names; and performing data query based on the query statement. According to the embodiment of the invention, the accuracy and the interpretability of the query statement can be improved, so that the accuracy and the reliability of the query result are improved.

Disclosed is an improved approach to manage hierarchical metadata for a database system. A hierarchical metadata structure pertaining to a hierarchical object structure of a multitenant database architecture for a plurality of tenants may be maintained where the multitenant database architecture comprising a container database (CDB) that includes a pluggable database (PDB). A request for an access to a metadata object in the hierarchical metadata structure for one or more database objects in the container database may be received. In response to the request for the access to the metadata, access to at least a portion of the hierarchical metadata structure is provisioned.

A method for execution by a database system to improve testing, the method includes creating a synchronization database object (SDO) indicating a set of conditions for suspension of execution of queries. The method further includes establishing a first and second session, where the first session applies the SDO to a query expression and the second session monitors the SDO. The method further includes initiating, via the first session, execution of queries, and suspending the execution of queries when detecting a condition is met. The method further includes updating, via the first session, at least one relational database table to include monitoring data indicating suspension of the queries. The method further includes the second session verifying the suspension and instructing the SDO to resume suspended queries. The method further includes resuming, via the first session, the queries until a next condition is met or execution of the queries is finished.

The application discloses a JSON data processing system implementation method based on FastAPI, which comprises the following steps: establishing a working directory based on FastAPI, creating a request processor in the working directory, and receiving original JSON data through the request processor; constructing a database object model in the working directory, generating a database table, and storing the original JSON data into the database table; constructing a business verification model in the working directory, preprocessing the original JSON data through the business verification model, and converting the processed JSON data into a Python object; creating a business processing tool in the working directory, processing the business logic of the Python object through the business processing tool, converting the processed Python object into a JSON data format; and creating a request agent and a middleware client agent of an external system in the working directory, and interacting the converted JSON data with the external system and the middleware. The application realizes an asynchronous processing kernel, supports high-concurrency tasks, improves the execution efficiency, and reduces the response time.

The application discloses a kind of blocking method, device, equipment and storage medium.The method comprises: when receiving the blocking instruction for target database object, active node obtains the first lock mode carried by the blocking instruction and the identification information of the target database object;The active node obtains first lock mode set according to the identification information of the target database object inquiring target mapping table;The active node generates second lock mode set according to the compatible lock mode of each lock mode in the first lock mode set;If the second lock mode set includes the first lock mode, the active node executes the blocking instruction for target database object, by the technical scheme of the application, it can be guaranteed that the total database object of transaction access is always complete during fault handling process, and there is no blocking conflict with active transaction of fault node after data recovery is completed, to ensure that fault node transaction and blocking can be successfully reconstructed.

The embodiment of the present specification provides a DDL statement execution method and device, and relates to the technical field of databases.The method comprises the following steps: in response to an execution request for a data definition language (DDL) statement, starting a transaction, the transaction being used for executing the DDL statement; recording target lock information corresponding to the DDL statement in the transaction, the target lock information being used for indicating parameters of locks added on a database object in the execution process of the DDL statement; in response to successful submission of the transaction, deleting the target lock information, so as to complete the execution of the DDL statement.The scheme provided by the present specification connects the lock operation in the execution process of the DDL statement into the transaction, provides a perfect lock management mechanism, makes the execution condition of the DDL statement consistent with the control of the lock, and thus can coordinate the concurrent processing of multiple DDL statements.

A database system detects a query targeting a first database object stored in a unified persistence format in a persistence store. In response to detecting the query, the database system determines whether to load the first database object in column-loadable format or page-loadable format into an in-memory store. In response to determining to load the first database object in the column-loadable format, the database system determines if a first bit representation of one or more corresponding primitives in the persistence store is compatible with a second bit representation used for storing the primitives in the in-memory store. The database system performs a native copy operation to copy the primitives from the persistence store to the in-memory store if the bit representations are compatible, where the native copy operation involves copying the primitives on a page-by-page basis without decoding and encoding values of the one or more primitives.

An entity-level visibility statistic may be determined for a database entity in a database system based on one or more visibility rules providing access to instances of the database entity to one or more user accounts. A user-level visibility statistic quantifying a set of instances of the database entity accessible to a user account via the one or more visibility rules may be determined based at least in part on the entity-level visibility statistic. A request may be received by the user account to execute an input database query retrieving one or more of the instances of the database entity. A database object retrieval query including two or more data security subqueries evaluating accessibility of the one or more instances of the database entity and positioned based at least in part on the user-level visibility statistic may be determined based on the input database query.

The invention provides a database object relation mapping method based on secondary equipment of an electric power system, which comprises the following steps: analyzing and classifying the secondary equipment of the electric power system, defining attributes and parameters of different equipment, sorting association relations among the equipment, and forming a secondary equipment object information system; designing an adaptive database model according to a secondary equipment object information system, and creating corresponding data tables for different types of secondary equipment to realize effective storage and management of secondary equipment data; the method comprises the following steps: mapping secondary equipment in a power system and related data thereof into a database through a data relation mapping method of the secondary equipment in the power system, and establishing a corresponding data relation; and querying and analyzing the data according to actual requirements through the mapping relationship. The method has the advantages that the problems existing in data management of secondary equipment of a traditional power system are effectively solved, the efficiency and reliability of data management and application are improved, and powerful support is provided for safe and stable operation of the power system.

Various implementations disclosed herein include obtaining data indicative of a request to modify a configuration item (CI) of a database and one or more portions of a pattern applicable to a service based, at least in part, on the request. A command is identified based on the one or more portions and one or more values of the CI are modified using the command.

The embodiment of the invention provides a database object recovery method and device, relates to the technical field of databases, is applied to a relational database on electronic equipment, and comprises the following steps: registering a data block reset function; obtaining an object recovery command, wherein the recovery command comprises a to-be-deleted target database object; calling a memory operation function by utilizing the data block reset function, and emptying data in a target data block belonging to a target database object on the electronic equipment; and recovering the target data block. According to the scheme, the security problem of database object reuse can be solved.

The technology disclosed relates to manipulating and visualizing database objects that represent layers and parts of layers in insurance or other risk transfer programs. Disclosed is graphically creating placement objects, maintaining a database of objects that can be linked in trees, with policy objects linked to respective proposal objects, and coverage objects linked to the proposal objects and the policy objects. A GUI represents a placement using objects, with metadata that describes objects' statuses, with groups of objects properly nested and linked in the database of objects. User selection of a displayed first object and mode control initiates creation of second objects linked to the first object and, opening of a panel that scales the selected first object to fit the panel and allows the user to add nested second objects, by drawing an added object or entering metadata for the added object, with consistent metadata constrained with the nesting.

The application discloses an object relationship mapping code generation method and device and a computer storage medium. The method comprises the following steps: obtaining a database address; determining database information according to the database address; mapping a data table of a database into a structure according to a preset mapping template and the database information; and generating an object relationship mapping code for the structure according to a preset operation template, wherein the object relationship mapping code is used for operating the structure to operate the database. According to the embodiment of the application, the database object is strictly mapped into the corresponding structure, the tediousness of manually defining the structure is avoided, the database structure definition efficiency is improved, and various problems that the structure does not correspond to the database structure are avoided. Meanwhile, a unified object relationship mapping code is generated for each object, the object relationship mapping codes are compatible with the operation syntax of various databases, the behaviors of all objects are consistent, and the software stability is improved.

Questionnaire completion systems and methodologies for a data platform. The data platform receives from a consumer an unstructured questionnaire to be completed based on structured database objects, semi-structured database objects, and unstructured database objects stored on the data platform by a provider. The data platform generates a secured completion of the unstructured questionnaire based on a questionnaire completion model and the unstructured questionnaire. The data platform determines a confidence score for the completion and in response to determining the confidence score does not exceed a threshold value, the data platform generates a structured query based on the unstructured questionnaire and a structured query model, and generates the secured completion based on querying the structured database objects using the structured query. The data platform applies a security function to the secured completion to generate a completion of the unstructured questionnaire and provides the completion to the consumer.

The application relates to the technical field of database maintenance, and discloses a database maintenance analysis method and system based on big data, which comprises the following steps: obtaining the priority maintenance indexes of each database object, generating maintenance work orders according to the numerical values, and taking corresponding maintenance measures on each database object; the application quantitatively calculates the fault risk indexes through multi-dimensional operation data, realizes scientific division of the database risk grades, can accurately identify high-risk databases and trigger deep analysis, avoids excessive consumption of maintenance resources by low-risk databases, and significantly improves the configuration efficiency of maintenance resources; at the same time, a database object dependency graph is constructed, and a graph neural network is used to calculate the correlation influence indexes, so that the influence range of each object in the whole system is accurately quantified, and reliable basis is provided for subsequent maintenance decisions; furthermore, a performance degradation model is constructed by using a time sequence convolution network, and the performance degradation trend of the database object is accurately predicted.

Systems and methods for cloud object storage and versioning are provided. In an example, a cloud object storage and versioning system (COSVS) coordinates insertion of metadata into a database and data into an object store in a compute infrastructure, the compute infrastructure including the database, the object store, a data source, and a client application interacting with the data source. The COSVS has an architecture comprising a client API layer confined to provide an interface to the client application to facilitate storing or restoring of items originally obtained from the data source, and query different versions of item content originally obtained from the data source; a deduplication layer to deduplicate item content and store items originally obtained from the data source devoid of external item metadata or semantic relations among items; and a packing layer confined to store and retrieve bytes of item or object content.

Techniques for delivering virtualized content are disclosed. In some embodiments, elements in source content are mapped to a set of corresponding database objects, and the set of database objects is modified to generate a virtualized version of the source content. A specification of the virtualized version of the source content is provided to an output device in response to a request from the output device for the source content.

A method for execution by a database system to improve testing, the method includes creating a synchronization database object (SDO) indicating a set of conditions for suspension of execution of queries. The method further includes establishing a first and second session, where the first session applies the SDO to a query expression and the second session monitors the SDO. The method further includes initiating, via the first session, execution of queries, and suspending the execution of queries when detecting a condition is met. The method further includes updating, via the first session, at least one relational database table to include monitoring data indicating suspension of the queries. The method further includes the second session verifying the suspension and instructing the SDO to resume suspended queries. The method further includes resuming, via the first session, the queries until a next condition is met or execution of the queries is finished.

Mechanisms are provided to perform application modernization through data modularization by using complex networking analysis. A static network of a data model is generated comprising nodes for database objects. Use case information is collected for use cases and community detection is performed on the static network to generate communities of database objects. A cohesion index for each community is determined and the use case information is integrated into the static model to generate a dynamic model having use case node(s) and edges representing interactions between the use case with database objects of the static model. A dispersion index is generated for each use case node and, in response to the dispersion index having a predetermined condition, the communities are dynamically optimized based on the cohesion index and the dispersion index to thereby generate a decomposed data model which is used for application modernization and / or migration.

The technology disclosed relates to manipulating and visualizing database objects that represent layers and parts of layers in insurance or other risk transfer programs. Disclosed is graphically creating placement objects, maintaining a database of objects that can be linked in trees, with policy objects linked to respective proposal objects, and coverage objects linked to the proposal objects and the policy objects. A GUI represents a placement using objects, with metadata that describes objects' statuses, with groups of objects properly nested and linked in the database of objects. User selection of a displayed first object and mode control initiates creation of second objects linked to the first object and, opening of a panel that scales the selected first object to fit the panel and allows the user to add nested second objects, by drawing an added object or entering metadata for the added object, with consistent metadata constrained with the nesting.

A database manager is disclosed that retrieves database records having binary encoded data from a database and instantiating objects in an in-memory database. Binary encoding compresses data, allowing many subrecords to be stored a single blob field of a database record. Retrieving chunks from storage reduces transfer time by reducing the size of data and the number of operations needed to retrieve all the subrecords.The database manager receives database access requests from a database application. Changes made to the database objects and committed by the application are written back to the persistent database as versioned delta records. In a subsequent session, loading the database from storage includes first loading the most recent snapshot record, then applying changes to the data stored in delta records. The changes stored in the delta records are applied to the data in the snapshot record in the order in which they were made.

Disclosed herein are techniques related to efficient database reads based on checkpoint avoidance. The techniques may include determining, by a database server instance in a multi-node database system, whether a database object is dirty. The multi-node database system may include a plurality of database server instances that share access to a database that stores the database object. The techniques may also include sending a request to one or more database server instances of the plurality of database server instances to perform a global checkpoint on the database object if the database object is dirty. The techniques may further include commencing an operation that requires reading the database object if the database object is not dirty.

A shared database platform implements dynamic masking on data shared between users where specific data is masked, transformed, or otherwise modified based on preconfigured functions that are associated with user roles. The shared database platform can implement the masking at runtime dynamically in response to users requesting access to a database object that is associated with one or more masking policies.

The application provides a database version control method, system, device, medium and program product based on table classification management, the method comprises the following steps: obtaining the structure information of a target database, automatically identifying and classifying the data tables of the target database, determining the update strategy of different types of data tables according to the classification result; generating a baseline version file of the database according to the classification result, and recording the version identification and release information of the baseline version file; comparing the baseline version files of different version identifications, identifying the change type of the database object and generating a difference analysis result; generating corresponding update scripts for different types of data tables according to the difference analysis result and the update strategy; verifying and executing the update scripts, and updating the version identification and release information according to the execution result. By introducing table classification management and differential update mechanism in the database version management process, the application realizes the automatic update, intelligent verification and unified version control of the database version.

This application discloses a database object processing method, system, device, and medium, applied in the field of database technology. In the mapping phase, the hierarchical identifiers (after removing hierarchical separators) of the original identifier key are concatenated into a hierarchical identifier string, generating a first digital fingerprint. A mapping identifier key is generated based on the target start character, the target digital fingerprint algorithm identifier, the first digital fingerprint, the target hierarchical identifier length, and the hierarchical identifier string. In the inverse mapping phase, after determining that the mapping identifier key starts with the target start character, the hierarchical identifier string is segmented based on the target hierarchical identifier length to obtain each hierarchical identifier, generating a second digital fingerprint. When the second digital fingerprint matches the first digital fingerprint, the hierarchical separator is used to restore each hierarchical identifier to the original identifier key. By constructing a unified bidirectional mapping mechanism, the database cluster can be compatible with different metadata services, significantly improving system scalability.

The invention discloses a satellite API (Application Program Interface) service access control and data service system, which relates to the field of satellite data processing, and comprises a Web interface presentation layer, a back-end service engine layer and a basic storage component layer, and the back-end service engine layer is integrated with a gateway system, an API spatial data service, an API model data service and an authority system. The gateway system carries out unified routing, identity authentication, access authority verification and calling frequency statistics on API access requests from a Web end or a third party, and forwards the requests passing verification to corresponding data services. The authority system is used for managing API authorization information and user identity certificates in a centralized mode, and the basic storage component layer supports efficient storage and access of API management data, authority data and satellite data through a relational database, object storage and cache storage. According to the invention, unified access control of multi-star-source satellite data is realized, and the security, controllability and expansibility of data service are improved.

Techniques are disclosed that relate to manipulating a chain of database objects without locking the chain. A computer system may maintain a chain that orders a set of database objects stored in a cache of the computer system. The computer system may receive a set of requests to perform database transactions. Based on those received set of requests, the computer system may determine to perform a plurality of chain operations that involve modifying the chain. The computer system may perform two or more of the plurality of chain operations at least partially in parallel using a set of atomic operations without acquiring a lock on the chain.

The application provides a heterogeneous database compatible adaptation method and system, relates to the technical field of database compatibility, and comprises the following steps: obtaining a data migration request containing a source database type identifier and a target database type identifier, and obtaining schema definition information of the source database; based on a preset type mapping rule, analyzing data type declaration, constraint conditions and index structures in the schema definition information, generating an intermediate representation structure, performing compatibility detection on each metadata unit in the intermediate representation structure, mapping incompatible metadata units into equivalent metadata expression forms supported by the target database, and maintaining semantic constraint relationships; finally, creating a database object based on a target schema definition, and establishing a data access adaptation layer. The application can realize efficient compatible adaptation between heterogeneous databases, and ensures the accuracy and integrity of data migration.

Embodiments as disclosed allow identity management with respect to SQL database by discovering substantially database objects and their entitlements and associating them with corresponding identities within the identity management system, thus providing insights into such SQL server entitlements and their associated identities, even across multiple SQL servers within an enterprise environment.