General database data structure, data migratory system and method thereof

Abstract

The invention relates to a general database data structure, a data migratory method and a data migratory system. The data migratory system comprises a middle domain object module, a database adapter module and a standard domain object storage module, wherein the database adapter module carries out analysis and deconstruction to a database object through a database object analyzer of the database adapter module and converts the database object into a standard domain object defined in the middle domain object module, so as to store and manage the standard domain object, and different database adapters can be adopted to convert domain objects into other database objects according to a user command; as the middle domain object technology is used, the database interdependence problem caused by the transformation between two different databases is avoided. Meanwhile, as the database adapter technology is used, the data migratory system can be simply extended to form other databases supporting SQL (structured query language) 92 and SQL95 standards.

Description

technical field [0001] The invention relates to the field of computer information technology, in particular to a general database data structure and data migration system and method thereof. Background technique [0002] In the development of enterprise information systems, the product-based development model occupies a very important position. It improves the reuse efficiency from various aspects such as software architecture reuse, code-level reuse, and database reuse, so as to achieve the purpose of product reuse. Ultimately, the goals of improving implementation efficiency, improving product quality and reducing development costs are achieved. Among them, when implementing database reuse, it is generally necessary to support multiple databases. In the current database market, most databases support standards such as SQL92 and SQL95, but each has its own set of features for specific use. system, there are large differences in data types, database functions, etc., making ...

AI Technical Summary

Problems solved by technology

In the development of more common enterprise-level information systems in the past, when it comes to migrating to another database, it is usually used to manually create the database structure and import data, or use database design tools to reverse engineer and generate new database scripts, etc. These methods generally have the following disadvantages: 1. The workload is heavy, and there are often hundreds of data tables in enterprise-level information systems

2. The maintenance frequency is high. During the development process and the later project maintenance process, the data table will often change continuously (including table structure, table data, etc.), and the database needs to be migrated synchronously after each change

3. The work is complicated. In the development of information systems, the modification of data tables and their data often only involves small-scale changes, but it needs to be synchronized in various databases

4. There are large differences, and there are often relatively large differences between different databases, including syntax, functions, keywords, data types, etc., which have high technical requirements for personnel who implement database migration

Images