58 results about "Data definition language" patented technology

Storing and querying XML data in a primary table or document utilizes an index of XML data and includes creating a primary table structure, creating a primary XML index commensurate with the primary table structure, populating the primary table and the primary XML index, and running a query on the XML data in a primary table by utilizing the XML index. The XML index can be implemented as a node table. The node table may have a B+-tree structure and be populated by shredding the XML values in the primary table. The XML data may be stored as binary large objects in an XML column of the primary table. Secondary XML indexes may be created to assist in the search and retrieval of XML data stored in the primary table. Both the primary XML index and the secondary XML index tables may be created using data definition language statements.

A meta object facility file is parsed into a plurality of schema elements. For each schema element, it is determined that the definition of the schema element is complete. A computing artifact usable in a database description language database table or a JAVA class is created from the schema element. When the schema element is a meta object facility class, a modeling entity is created to store the computing artifacts derived from the meta object facility file wherein the modeling entity is a JAVA class. The meta object facility class is transformed into a JAVA class, and upon determining that an attribute of the meta object facility class has an array of values, an array table is created and identified in the modeling entity, and an array attribute is added to JAVABEAN information in the modeling entity.

Scriptlets based extensible automated testing software allows for an extendible, scalable and simplified process of testing data messages against standards defined in some data definition language like SECS, XML, ASN1. Scriptlets written in some scripting language like Perl, TCL / TK, BeanShell, JPyton are embedded into such data definitions allowing for a way to formally express requirements of the data items associated with such scriptlets. A data definition compiler compiles such data definitions and creates a database of data messages annotated with scriptlets. When new data message is received the test software identifies which template this message corresponds to and then executes scriptlets associated with this template using the data message and / or previous messages as a context for the scriptlets.

A method for facilitating creation and managing of partitioned table indices of a table object of a first partitioning type includes steps of: automatically looking up a table and its partitioning type definition; retrieving the table index and all indices defined for that table object, and their definitions; presenting to a user at least a portion of the table index in a single set of index alter screens; receiving from the user an alter request in the form of a screen option; performing validity checking on the screen option, based on the index type. If the screen option is not compatible with the index type, the method automatically overrides the screen option with one that is compatible, and issues a diagnostic message. If the screen option is valid for the index type, the user is notified about the changes that will be made and the effect of those changes. Data definition language statements are then generated consistent with the screen options.

The invention discloses a packing method based on a line storage database engine, which comprises a line storage database, and following operations are carried out based on the line database: creating a compress table, specifying a corresponding compressing level, and importing data files with CSV (Comma Separated Value) format into the created compress table. The method is characterized in that: the compress table is a common data table showed externally for supporting general DML / DDL (Data Manipulation Language / Data Definition Language) operation; the compress table comprises a master HOT data segment and a slave LOB large object segment realized internally, wherein the master HOT segment is used for storing internally defined attribute lines, and the slave LOB segment is used for storing a compression method control structure and compressed data content; the compress table is used for supporting various query languages, and when in query, even though all fields in the line need to be read into memory, the related line data only needs to be decompressed and queried; the compress table is used for supporting update operation, and only decompressing updated lines when in update; and the compress table is used for supporting speedy deletion, only delete mark is made, and when no record is in a slave line, a master line is automatically deleted; and the compress table is deleted. According to the invention, through a line storage database technology, without changing a storage engine physical result, the technology of compression and storage according to line is realized, and the effect of high compression ratio of the line storage database is achieved.

A system and method includes steps or acts of: organizing table partitions in logical order; presenting the partition table numbers and their current ending values in logical order to a user; receiving an alter command from the user, the alter command specifying at least one logical partition number and its corresponding ending value; internally matching the specified logical partition number to its corresponding physical partition number; altering the physical partitioning of the table by manipulating one or more current ending values of partitions by altering the current ending value of the physical partition to which the specified logical partition is associated, such that new ending values are generated; and automatically generating at least one data definition language statement corresponding to the alter command, using the new ending value.

The invention provides a method and equipment for processing metadata. The method comprises the following steps that: the equipment for processing the metadata acquires an extraction-transformation-loading (ETL) execution log and acquires a first data definition language (DDL) command, wherein the first DDL command is used for performing node definition on a data object included by the ETL execution log; the equipment for processing the metadata analyzes the acquired ETL execution log to acquire a second DDL command and a data manipulation language (DML) command, wherein the second DDL command is used for performing node definition on a temporary object included by the ETL execution log, and the DML command is used for recording the conversion operation of the data object and / or the temporary object in an ETL execution process; and the equipment for processing the metadata acquires the metadata which is used for representing the data flow direction of the data object and / or the temporary object by analyzing the first DDL command, the second DDL command and the DML command. By the method and the equipment for processing the metadata, the metadata which reflects the real data flow direction can be acquired.

An XML wrapper queries an XML document in an on-the-fly manner so that only parent nodes in the document that satisfy the query are extracted and then unnested. The parent nodes and associated descendent nodes are located using XPath expressions contained as options in data definition language (DDL) statements. The parent nodes satisfying the query and associated descendent nodes are extracted and stored outside of a database according to a relational schema. The wrapper facilitates applications that use convention SQL queries and views to operate on that information stored according to the relational schema. The wrapper also responds to query optimizer requests for costs associated with queries against external data sources associated with the wrapper.

The invention discloses a method of generating SQL statements, an electronic device and a readable storage medium. The method includes: receiving an SQL statement generation instruction sent by a user, and generating and displaying an SQL statement generation type selection interface; if an instruction of selecting generation of universal SQL statements by the user on the basis of the SQL statement generation type selection interface is received, generating and displaying a DDL (data definition language) statement parameter setting interface, and after basic information input by the user on the basis of the DDL statement parameter setting interface is received, generating DDL statements according to the basic information; and if an instruction of selecting generation of customized SQL statements by the user on the basis of the SQL statement generation type selection interface is received, generating and displaying a function change selection interface, and after a changed function selected by the user on the basis of the function change selection interface is received, determining SQL statement blocks, which correspond to the selected changed function, according to mapping relationships of preset function change items and SQL statement blocks. The method realizes automatic and accurate generation of the SQL statements.

Storing and querying XML data in a primary table or document utilizes an index of XML data and includes creating a primary table structure, creating a primary XML index commensurate with the primary table structure, populating the primary table and the primary XML index, and running a query on the XML data in a primary table by utilizing the XML index. The XML index can be implemented as a node table. The node table may have a B+-tree structure and be populated by shredding the XML values in the primary table. The XML data may be stored as binary large objects in an XML column of the primary table. Secondary XML indexes may be created to assist in the search and retrieval of XML data stored in the primary table. Both the primary XML index and the secondary XML index tables may be created using data definition language statements.

An embodiment of the invention discloses a method and device for high-performance query of a database. The method for high-performance query of the database comprises the steps of storing to-be-stored data in a buffer area of a system memory by executing data definition language (DDL); and enquiring about the data in the buffer area by executing data query language (DQL). According to the method and device for high-performance query of the database, data query efficiency of a database system can be remarkably improved.

The invention discloses a database table changing method and device, computer equipment and a storage medium. The method comprises the steps: acquiring table change information of a database, acquiring first target sub-table information of the database according to the table change information, and enabling the database to be subjected to sub-database sub-table processing; generating a target change statement according to the first target sub-table information and the table change information, wherein the target change statement adopts a data definition language; obtaining a target Internet protocol address according to the first target sub-table information; and executing the target change statement according to the target Internet protocol address so as to complete table change of the database. According to the technical scheme, the DBA can automatically execute table change of the database through one key, the working efficiency is improved, and online faults caused by manual tablechange of the database are reduced.

This application belongs to the field of database application technologies, and discloses a data scrubbing method and apparatus. In the method, a server adds a share update exclusive lock to a target table, to prevent a system from performing a data definition language (DDL) operation on the target table. The server then creates a temporary table and a temporary index, copies data from the target table to the temporary table, and generates index information according to the data in the temporary table. Next, the server adds an access exclusive lock to the target table to prevent the system from performing a data manipulation language (DML) operation on the target table. Then data in the target table and the temporary table as well as corresponding index information is exchanged, thereby completing cleaning and reclaiming of disk space.

The invention belongs to the technical field of databases and provides an incremental data synchronization method. The incremental data synchronization method is characterized by comprising the steps that firstly, the data manipulation language of a source database is obtained; secondly, the data manipulation language is derived and serves as a data package; thirdly, the data package is synchronized to a target database; fourthly, a time quantum is set through a time module, and data of the target database is updated; fifthly, the data package is analyzed into the query language and change data; sixthly, the query language and the change data are synchronized to the target database; finally, in the target database, tables needing data changes and tables on which the data changes are conduced are generated and stored. The incremental data synchronization method effectively resolves the problems that logic repetition exists, the data are not consistent, the data are difficult to process and synchronize, and the data are obliterated easily.