120 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.

Embodiments are provided herein that include receiving, from a natural language model and based on a first textual prompt, a first output that represents a database entry, wherein the database entry includes a plurality of elements; obtaining a selection of a subset of the plurality of elements; determining a second textual prompt based on the selected subset of the plurality of elements; and generating, via the natural language model, a second output based on the second textual prompt, wherein the second output represents an update to the database entry. These embodiments provide for faster generation of catalog items or other types of database entries using generative natural language models in a manner that exhibits reduced memory requirements, computational cost, and / or amounts of training data.

Techniques and solutions are provided for providing improved replay of a database workload. In particular, the present disclosure provides techniques for generating dependency graphs that have a reduced number of redundant edges. In particular, the dependency graphs can be generated using a technique that removes subpaths of a larger path of requests for database operations that access a common database object. Another technique removes subpaths of a larger path the incudes additional requests in multiple sessions, even if some requests access different database objects. Particular implementations process a set of requests to generate state information, where the state information can be used in generating a dependency graph that excludes one more types of redundant edges. Additional efficiency is provided in that graphs can be generated using a single scan of a given request.

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 invention discloses a database object manager and a management method, the manager realizes operation on a database object through interface design, and the manager comprises a database object creating module for creating and modifying the database object, the database object comprises one or more of a library, a mode, a table, an index, a partition, a constraint, a view, a sequence value, a storage process, a function, a packet, a user and a role; the database object management module is used for checking and modifying a database object, operating data, editing SQL (Structured Query Language), checking a table structure, and importing and exporting the table structure and table data; and the database object maintenance module is used for realizing table statistical analysis, index reconstruction, view compilation and modification, trigger compilation and modification, storage process and function compilation of database objects. Through the interface operation, the user can better use the database.

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.

Systems and methods for generalized structured data discovery utilizing contextual metadata disambiguation via machine learning are disclosed. A method may include receiving physical application metadata for an attribute, a database object, or a database; receiving reference data including tokens and their associated abbreviations and acronyms; parsing the physical application metadata into application tokens including known application tokens and unknown application tokens; identifying unknown application tokens by comparing the parsed application tokens to a corpus; performing probabilistic parsing on the unknown application tokens using the reference data resulting in token phrases; identifying monosemous tokens in the token phrases using a look-up dictionary; replacing the monosemous tokens with their expansions from the look-up dictionary; and outputting a mapping of the physical application metadata to enhanced physical application metadata that includes an expression for the physical application metadata comprising the expansions for monosemous tokens in a supported language.

A database system detects an operation to move a first database object from an in-memory store to a persistence store, wherein the first database object is in either a page-loadable or column-loadable format in the in-memory store, and wherein the first database object comprises a plurality of subcomponents. Each subcomponent of the first database object is examined separately from other subcomponents of the plurality of subcomponents. In response to determining that a first subcomponent of the plurality of subcomponents has a datatype and a compression type supported by a unified persistence format, the first subcomponent is stored in a unified persistence format in the persistence store. In response to determining that a second subcomponent of the plurality of subcomponents has either a datatype or a compression type which is not supported by the unified persistence format, the second subcomponent is stored in a serial persistence format in the persistence store.

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.

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.

The invention discloses a conversion migration and verification method for a database object link and an embedded object. The method comprises the following steps: extracting target object data containing the object link and the embedded object from a preset database by utilizing Kettle software; performing format conversion on the target object data by adopting a pre-written analysis and conversion script to obtain converted target object data suitable for a target data block storage format; loading the conversion target object data to a pre-configured target field of a target database by using table output of the Kettle software, and obtaining migration object data; performing hash value calculation verification on the conversion target object data before migration and the migration object data after migration by using Kettle software to obtain a verification result, and performing manual spot check verification on unstructured data of the conversion target object data before migration and the migration object data after migration to obtain a verification result; and according to the verification result and the verification result, determining a migration result of the object link and the embedded object.

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.

The invention relates to the technical field of smart homes, and provides a front-end page rapid generation method and device, a storage medium and a product, and the method comprises the steps: selecting a to-be-applied reference page from a reference page library according to a page generation demand, and selecting a to-be-applied database object from a plurality of pre-defined database objects; according to the to-be-applied reference page and the to-be-applied database object, automatically adding or removing a difference component to obtain a complete page structure corresponding to the page generation demand; and according to the complete page structure, generating a front-end page code, and running the front-end page code to generate a target front-end page. According to the scheme, on the premise that the front-end page generation accuracy is guaranteed, rapid generation of the front-end page can be achieved, the workload and time of front-end page development are saved, and the efficiency of front-end page development is improved.

A database system detects a query targeting a first database object stored in a unified persistence format in a persistence store, where a first load unit is specified for loading the first database object into an in-memory store. The database system determines whether to convert the first load unit to a second load unit based on one or more conditions. In response to determining to convert the first load unit to the second load unit for the first database object, the first database object is loaded into the in-memory store according to the second load unit without performing a rewrite of the first database object in the persistence store. In an example, the first load unit is a column-loadable unit and the second load unit is a page-loadable unit.

To provide a database load unit for replication log replay.SOLUTION: A process for using different load units comprises: loading a database object into a primary in-memory store; capturing it in a replay log according to a predetermined format and transmitting it to a secondary database system; checking, by the secondary database system, the value of a log replay configuration parameter in response to reception of the replay log; if the configuration parameter is a first value, replaying the replay log to load the corresponding database objects into a secondary in-memory store according to a first format; if the configuration parameter is a second value, replaying the log and loading the object according to the second format; and if the configuration parameter is a third value, replaying the log and loading the object in the same format that was used by the primary database system.SELECTED DRAWING: Figure 8

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.