Navigation: MRALD - Finding the gems in your data | Home | MITRE | Contact Developers

Private information

All the user specific information is here. A list of Personalized Forms , along with facilities to create and manage them, and a link to list the history of all queries the user has submitted to the database (since the last log file rotation).

Personalized Forms

This system should cater to db novices, intermediate users, and power users. Normal forms work for novices, and DirectQuery works for the power user. What about the average user with special needs? Personalized forms allow people with passing db knowledge, decent domain knowledge, and a general understanding of how the standard forms work to build new forms from any group of available tables The user has a very low level control of what goes on the form so it can be tailored for a very specific use. The resulting form is then shareable with any number of users, or can be adopted as a standard form. There is also an integrated editor so minor changes can be made through the web (though shared froms would have to be re-shared).

Pre-built Forms

This is the location for all the pre-built forms for your users. The forms in this location should aim to satisfy most of the needs of an average user. People with special needs can use the Formbuilder, located in the Personalized Forms section, and power users who want to write their own SQL can use the DirectQuery links in the Special Purpose Forms section.

Special Purpose Forms

This is the location for special purpose forms. Initially, there is only a link to DirectQuery, where a more advanced user can write their own queries, and a form to upload a text file with many pre-written queries in it - they will all be processed together.

Documentation

Licensing information for MRALD and the included libraries, a users' guide, and acknowledgements.

News

A simple news area where the administrator can announce major new data sets, system upgrade, or other local information. System administrators have facilities for updating and archiving news items. Or it can be modified by directly modifying the news.xml file.

Database review and visualization

Using a heirarchical structure, users can click to review the database structure one table or field at a time. Also provided is a database visualization tool that shows the entire database structure, including the table relationships, in a graphical, manipulatable form. The visualization feature requires the Java 5.0 browser plugin available from Sun when you install the Jave Runtime Environment.

Keyword Search

The keyword search features a search throughout the entire database for a single word or phrase. The search is case sensitive and checkes only the text fields in the database. The result is a list of all tables where the word appears and all the rows in the table that contain the word.

Care must be taken as this can take a long time on large datasets and may return an unweildly amount of information.

Administration

Certain users can be granted administrative privledges. The following administrative functions are available.