Arad-OneTable-Editor is a set of perl modules to manage and display a dialog for a single-table SQL query. It can verify types, and scroll between the records. The data handling is separate from the dialog class, so it is possible to write different generic dialogs for the same query. A Perl/Tk dialog and a GNU/readline (or plain text) dialog are included in the distribution.
Orac is a GUI tool for Database Administrators written in Perl, Tk, and DBI. It organizes many useful DBA scripts into a nice graphical interface, for collecting statistics on your database, or diagnosing problems. It currently supports Oracle, Sybase, and Informix. Richard Sutherland's DDL::Oracle Perl module has been integrated with the current version for the Oracle side of things, greatly improving the Oracle developer options on the program.
XML-DBMS is a set of Java packages for transferring data between XML documents and relational databases. It views the XML document as a tree of objects in which element types are generally viewed as classes and attributes and PCDATA as properties of those classes. It then uses an object-relational mapping to map these objects to the database. An XML-based mapping language is used to define the view and map it to the database.
XML-DBMS (Perl) is a port of the Java version of XML-DBMS. XML-DBMS is middleware for transferring data between XML documents and relational databases. It views the XML document as a tree of data-specific objects in which element types are generally viewed as classes and attributes and PCDATA as properties of those classes. It then uses an object-relational mapping to map these objects to the database. An XML-based mapping language is used to define the view and map it to the database.
libdbi implements a database-independent abstraction layer in C, similar to the DBI/DBD layer in Perl. Writing one generic set of code, programmers can leverage the power of multiple databases and multiple simultaneous database connections by using this framework. The plugin architecture allows for new database drivers to be easily added by a third party with flexible licensing.
Permission Record Information Machine (PRIM) delivers database connectivity via a web browser. Users can have different database permissions (e.g. create tables, modify tables, etc.). PRIM has built-in database analytical tools such as graph displays, reporting, etc. English and Chinese (Big5) language support.
Dataxi is a database access system that uses a single form to query, view, and modify data spread to one or more tables in a true relational manner. In addition, Dataxi provides a platform to build database-oriented applications of any size that can be accessed through a Web interface.
This small tool connects to the P6Spy JDBC logger and displays in real time the queries going to the database. It uses an integrated SQL parser to build statistics on the most accessed tables and columns to enable database index creation. Other information is also gathered and displayed, such as the request time for a single request, for a class of request, and for all the requests. Sorting may be done on these views to detect database problems efficiently.