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 widely-used data definition language such as the Extensible Markup Language is used to implement a tuple space-based coordination mechanism. Entries and template entries can represent any type of networked or network-proxied resource, object or service. Using this framework, diverse entry spaces can be aggregated and operated upon as though they were a single large entry space. The flexibility and power of XML constructs can be leveraged to make such aggregation straightforward and efficient.

The invention discloses a method and a system for a read-write splitting database. The system comprises an application server layer, a database access interface layer, a database agent layer and a database layer. The database agent layer is arranged between the database access interface layer and the database layer to conduct data communication, switch data sources and provide route service, data definition language (DDL) statement analysis, database state monitoring, high availability, data source switching and transaction control service. The method and the system achieve the aim that read-write splitting can be conducted between any database software and versions by conducting read-write splitting on a business layer.

The present invention relates to the usage pattern, commonly found in many software applications, of defining sets of objects based on object attributes. A specifically designed set definition language for defining sets, called SDL, is described and a software system that implements this language efficiently on top of a standard relational database management system (RDBMS) is presented. The unique features of the SDL language are the implicit constraints that are enforced on the relational data that belong to the objects. Unique to the SDL system is also the logical metadata of dimensions that enables the SDL system to enforce these constraints across relations. The SDL system utilizes several optimization techniques to enable efficient implementation on top of RDBMS. It is also shown how the SDL language and the SQL language can be merged with bidirectional inlining using syntactic gates. Query composition tools are also described that facilitate the creation of SDL expressions.

A computerized method, program product, and a service that resolves the business problem by enabling an automated and simplified process to generate DDL and JAVA classes directly from a MOF definition. The method, program product, and service creates useful computing artifacts from a set of abstract and generic specifications described in the MOF format. The computing artifacts include a DDL database schema having tables that accurately reflect the object-oriented hierarchy of the objects described in the MOF format; JAVA classes that correspond to the objects defined in the MOF format; object-to-relational (O / R) mapping file that maps the JAVA classes and their attributes to the tables and columns in the DDL database schema; SQL insert statements for loading the data of enumerated list values into the tables and the JAVA classes; database design reports; and O / R name translation reference reports.

Unification of a programming language with a definition language creates a powerful tool for object-oriented programming. A programming language is extended to include definition language constructs. In a compiler environment, a compiler recognizes the definition language constructs in programming language code. The compiler environment unifies representation of the definition language information and programming language code in a unified parse tree, and derives semantic meaning from definition language information. The compiler environment also checks for lexical, syntax, and semantic errors.

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.

The invention discloses a method and a device for copying information after table structure modification. The method comprises the following steps: extracting source-end DDL (Data Definition Language) statements corresponding to structure modification of a source table when the structure of the source table in a source-end database varies; and modifying the structure of a target table in a target-end database to be the same as the structure of the source table according to the source-end DDL statements. Thus, the table structure modification can be copied automatically without pausing or interrupting a data copying process, so that artificial participation is reduced, and project implementation and maintenance cost is lowered.

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

Techniques are disclosed relating to create a configuration for a database system. In some embodiments, program instructions of a change set for an application are received from a source code management (SCM) repository. In response to the receiving, a build process is performed that includes causing compilation of the received program instructions to produce program instructions executable to run the application. The build process also includes provisioning the configuration with a schema by retrieving a first set of metadata defining the schema and issuing corresponding data definition language (DDL) instructions to create the schema in the configuration. The build process includes provisioning the configuration with data by retrieving a second set of metadata defining the data and issuing corresponding data manipulation language (DML) instructions to insert the data into the configuration and storing the provisioned configuration in a repository as one of multiple configurations associated with multiple received change sets.

The invention discloses a data center middleware system. Data definition and application registration and management are provided, and data is analyzed and defined by adopting a virtual object mode; applications connected to a data center are registered, data objects related to the applications are determined, and the read-write authority for the data objects are determined; by building a data center data definition language (DDL), data object definition and application setting are described, a description file based on an XML format is formed, different development languages can generate local development assemblies suitable for being called for the file, and the generated development assemblies include data center client services, data object definitions and a data operation API. The uniform data center can be built under the B / S mode, the data synchronization and unified identity authentication services can be provided for application systems, persistence data storage systems of various modes can be supported, and a unified data warehouse can be built.

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.

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 provides a persistent layer device and a database operation method. The method comprises the following steps: establishing at least one group of preset tables in advance, wherein each group of preset tables comprises at least one database table; establishing a management table, and managing the preset table; carrying out a DML (Data Manipulation Language) operation on the management table; mapping the management table and a persistent object PO (Persistent Object) class through a configuration file; and finally, packaging a one-to-one correspondence relationship obtained by mapping into one object operation; and providing the packaged object operation for outside to be called through a uniform external operation interface. In the process, the double-layer table structure design of the management table and the preset table converts a complex database DDL (Data Definition Language) operation into a simple database DML operation, a defect that a static configuration file restricts certain DDL operations on the database by an application system in a traditional persistent layer structure can be solved, and the flexible operation of the database is realized.

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

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 relates to a DDL (Data Definition Language) statement audit method and device. The above-mentioned method includes: acquiring a to-be-audited script file; parsing the script file to obtain an object type of each DDL statement in the script file; categorising each DDL statement according to the object type of each DDL statement to obtain the DDL statements, which belong to each objectcategory, by division; acquiring an object audit template corresponding to each object category; and respectively auditing the DDL statements, which belong to each object category, according to the object audit template corresponding to each object category. According to the above-mentioned DDL statement audit method and device, massive manpower and time are saved, audit efficiency of the DDL statements can be improved, accuracy of audit is effectively improved, and audit errors are reduced.

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.

The invention relates to a data processing method and device, computer equipment and a storage medium. The method comprises the steps: sending a data table processing request to a far-end database; when response information fed back by the far-end database in response to the data table processing request is received, generating a data definition language statement of a local-end database based onthe response information; creating or updating a library table of the home terminal database through the data definition language statement; when a data processing request for the library table created or updated in the home terminal database is received, performing language conversion on a structured query language statement in the data processing request; and performing data processing on the library table created or updated in the home terminal database through the structured query language statement after language conversion. By adopting the method, the data processing efficiency can be improved.

The invention provides a method for quickly initializing a system database, and is applied to an electronic device. The method comprises the following steps that: scanning database table names corresponding to all DDL (Data Definition Language) script files in a historical system database, and obtaining the DDL script files of which the database table forms are the same; combining the obtained DDLscript files of which the database table forms are the same into a DDL statement file; and revising the feature information of the combined DDL statement file, and generating an initialized databasescript corresponding to a target system. By use of the method, the initialization efficiency of the database is improved, and a data error rate is lowered. The invention also provides an electronic device and a computer readable storage medium.

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.

A method, computer program product, and system for providing access to a database object during modification of that object. Upon receipt of a data definition language (DDL) operation specifying a modification to the database object, currently executing database transactions are invalidated in a two-step process of a soft invalidation followed by a hard invalidation. The soft invalidation permits the current database transactions to continue executing while modifying the logical structure of the database object in accordance with the DDL operation, and the hard invalidation waits for the database transactions started prior to the DDL operation to finish execution before modifying the physical structure of the database object in accordance with the DDL operation. After the modification to the logical structure is complete, new database transactions are allowed to execute against the modified database object, thus improving the availability of the object while it is being modified.

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.