Abstract :
Software tools used to administer databases are vendor specific, proprietary, and require extensive prior database knowledge on the part of the database professional. We have developed dbAnalyst, a vendor independent database administration and maintenance tool. dbAnalyst is an Open Architecture database administration and maintenance tool that can be used to graphically show a database schema, manage database objects, import and export database content, and generate database alerts. dbAnalyst can also be used to reverse engineer existing databases to uncover database objects and relationships and diagnose impending database issues. These features, and a uniform interface to any database, are supported for Structure Query Language-type databases.
Keywords :
relational databases; reverse engineering; software maintenance; user interfaces; Open Architecture; SQL type databases; cross database management tool infrastructure; database alert generation; database content export; database content import; database object management; database relationships; database schema; dbAnalyst; impending database issue diagnosis; reverse engineering; software tools; uniform interface; vendor independent database administration and maintenance tool; Application software; Computer architecture; Content management; Knowledge management; Open source software; Relational databases; Reverse engineering; Software tools; Spatial databases; User interfaces;