Enabling collaborative development of a database application across multiple database management systems

摘要

An approach for enabling collaborative development of a database application is provided. Specifically, this approach provides a database development and collaboration tool (DDCT), which can be utilized by multiple developers involved in a particular software project, to enable automated synchronization and database version control by allowing a database development language and data changes to be stored in a metadata form that is general to more than one database management system (DBMS). Each developer is united and able to collaborate through the system, thus ensuring that a change to a database structure and/or data in a static data table created in a particular database language by one developer is automatically incorporated in the overall development process. Furthermore, the DDCT provides the opportunity to maintain a single repository entry for more than one DBMS, which simplifies synchronization.

主权项

1. A method for enabling collaborative development of a database application, the method comprising:
receiving a database, generated by a first user in a first database language, via a first database management system (DBMS); designating a set of tables from the database as a set of static data tables; committing the database and the set of static data tables to a repository; deploying, from the repository, the database in a second DBMS;receiving a change to the database, by a second user in a second database language, via at least one of: the first DBMS, and the second DBMS, wherein the change is represented as metadata that is general to both the first DBMS and the second DBMS; and
synchronizing the change to the database within the repository based on the metadata.