95 results about "Database object" patented technology

The invention relates to a heterogeneous database synchronization method and device, electronic equipment and a storage medium, and the method comprises the steps: analyzing a transaction log of a source database, extracting and generating an abstract syntax tree of a DDL event, and carrying out the node-level syntax conversion of the abstract syntax tree according to the database type of a target database and a preset syntax mapping rule base, and obtaining an equivalent DDL operation sequence of the target database, blocking a data processing operation corresponding to the database object associated with the DDL event, and executing the equivalent DDL operation sequence on the target database. The whole-process intelligent processing of the isomerous database DDL is realized without depending on manpower, the equivalent DDL operation sequence of the target database having semantic consistency with the DDL event of the source database is obtained through dynamic replenishment and deep analysis of the DDL event and the context semantics of the DDL event in combination with the grammar mapping rule base, the processing efficiency of isomerous database DDL synchronization is improved, and the processing efficiency of isomerous database DDL synchronization is improved. And meanwhile, the safety and reliability of synchronous processing can be ensured.

The invention provides a domestic database compatibility comparison evaluation and migration method and system and a medium, and belongs to the technical field of database migration. The method comprises the following steps: acquiring a creation statement of each database object in a pre-connected target source database; and based on a preset grammar parser and a preset grammar feature library, analyzing each creation statement, generating an abstract grammar tree and traversing the abstract grammar tree to determine grammar features corresponding to each database object, and generating a mapping list between each database object and each grammar feature. And comparing the mapping list with a plurality of preset grammar feature templates of the domestic databases, generating compatibility evaluation results corresponding to the domestic databases according to comparison results, and determining corresponding migration working hours and an automatic rewriting grammar set according to the compatibility evaluation results. And based on each compatibility evaluation result, each migration man-hour and the automatic rewriting grammar set, generating a multi-dimensional comparison view corresponding to each domestic database, and sending the multi-dimensional comparison view to an evaluation migration user terminal.

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 data platform for managing an application as a first-class database object. The data platform includes at least one processor and a memory storing instructions that cause the at least one processor to perform operations including detecting a data request from a browser for a data object located on the data platform, executing a stored procedure, the stored procedure containing instructions that cause the at least one processor to perform additional operations including instantiating a User Defined Function (UDF) server, an application engine, and the application within a security context of the data platform based on a security policy determined by an owner of the data object. The data platform then communicates with the browser using the application engine as a proxy server.

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.

The present application discloses a method, apparatus, device, and storage medium for detecting database objects. The method comprises: dividing database objects in a database to be tested in a testing environment according to a preset database object division rule to obtain a first database object, a second database object, and a third database object; determining identical database objects of the first database object in the database to be tested in a first environment and a second environment based on the object name of the first database object and a preset first comparison rule; obtaining target database object creation statements associated with the object name in the testing environment according to the identical object names of the identical database objects; and determining, according to a preset second comparison rule, differential creation statements in the target database object creation statements corresponding to the first environment and the second environment, respectively, so that a tester can determine a consistency test result for the database objects based on the differential creation statements.

A local object database is populated from a geospatial indexing system database. An object has a geolocation representing one or more locations relative to points and / or regions relative to a geographic range of object records. A method might comprise determining a device geolocation state of the mobile device, determining a first geographical search space as a function of device geolocation and area relative to the device geolocation, querying the geospatial indexing system database for a localized subset of object records with geolocations within the first geographical search area, populating the local database with the search results, determining whether the results comprise filterable object records that include a filter parameter, comparing the filter parameter and device geolocation state. When a filterable object record is present in the results and a filter parameter does not match the device geolocation state, the filterable object record is filtered from the local database.

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.

Techniques are provided for optimizing storage of database records in segments using sub-segments. A base segment is a container used for storing records that belong to a database object. A database management system receives a request to load, into the database object, a first set of records that are in a first state. In response to receiving the request, the system generates a new sub-segment, which is a container that is separate from the base segment. The system stores the first set of records, in their first state, within the sub-segment. The system then monitors one or more characteristics of the database system. In response to the one or more characteristics satisfying criteria, the system performs a migration of one or more records of the first set of records from the sub-segment to the base segment. During the migration, the system converts the one or more records from the first state to a second state and stores the one or more records, in their second state, in the base segment.

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 invention provides an SQL statement generation method and device based on multiple libraries, and relates to the technical field of artificial intelligence. The method comprises the following steps: acquiring first table establishment information and second table establishment information of a plurality of databases in a target scene; determining first reference table building information corresponding to the to-be-processed query from the second table building information on the basis of input length limitation of a specified model; controlling the specified model to identify a database object and an object relationship related to the query to be processed according to the first reference table building information and a preset compression rule to obtain skeleton information; retrieving second reference table establishment information from the second table establishment information by using the skeleton information; and controlling the specified model to perform expansion processing on the skeleton information according to the second reference table building information and the to-be-processed query to obtain a target SQL statement corresponding to the to-be-processed query. According to the method, the length of the table building information is compressed, so that information loss can be reduced to the greatest extent, and then the accuracy of generating the SQL in the multi-library scene can be improved.

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.

A method for maintaining a cache of database objects using a chain set is disclosed. The chain set includes a plurality of chains, each chain specifying an ordering of database objects. In response to a state change of a particular database object, a corresponding chain is selected. The selected chain is then locked, the state of the particular database object is changed, and then the selected chain is unlocked.

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.

The present application provides a method, apparatus, device and medium for establishing a database object-relational mapping model, comprising: performing macro expansion processing on the source code of an original file to obtain expanded code corresponding to the source code, the expanded code including a data model consistent with the data structure definition of the original file and a runtime function that expands the data structure, the runtime function including multiple strings expanded from the source code to generate SQL statements when the program starts; configuring a data table with multiple strings, and the fields, comments and attributes belonging to the data table; at runtime, storing the functions, field representations, inter-table relationships and data structures expanded from the source code in memory, establishing a database object-relational mapping model, generating SQL statements corresponding to the model, and loading the database object-relational mapping model during data migration to achieve data persistence and reduce operational complexity.

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.

Techniques are disclosed relating to updating a database schema. A computer system may store database schema versions for a database schema. A given schema version may have an active state or one of multiple non-active states. One of the schema versions may be a first schema version that is in the active state and the remaining schema versions may be in the non-active states. The computer system may receive updates to apply to the database schema. The computer system may transition a second schema version from a first non-active state that does not permit structural or content updates to a second non-active state that permits structural and content updates. The computer system may apply the updates to the second database schema version and then transition the second database schema version into the active state and the first database schema version into the first non-active state.