Both sides previous revision
Previous revision
Next revision
|
Previous revision
|
jvs:dbax [2011/06/08 21:00] voyvodic |
jvs:dbax [2023/02/23 18:43] (current) |
===== DBAX -- Database XML web-service and client===== | ===== DBAX -- Database XML web-service and client===== |
| |
DBAX is a database utility program for communicating with a SQL database. It was designed to map XML data files to database tables and vice-versa, and to provide a generic XML-based web-service for database access. However, it can also move data in simple text column format into and out of database tables (or XML table files). DBAX itself is not a database program -- it simply acts as a user-interface for accessing a database (e.g. Postgres). At a minimum DBAX expects that a database has already been created and a SQL-server is running for for that database. | DBAX was designed for organizing imaging data (e.g. MRI) and related behavioral or clinical data, into a relational database. DBAX is a utility program for communicating with a standard SQL database. It was originally designed to provide a simple interface for mapping XML data files (or Excel-type table files) to database tables and vice-versa; this makes it easy for users to specify their own table structures and then import data into the database without doing any database programming. DBAX also provides a generic XML-based web-service for database access; this allows other programs to interact with the relational database simply by sending XML commands via a web interface. |
| |
Currently DBAX has been implemented for Postgres. For instructions on setting up a Postgres database, see [[jvs:dbax:postgres|Postgres]]. | DBAX itself is not a database program -- it simply acts as a user-interface for accessing a database (e.g. Postgres). At a minimum DBAX expects that a standard database has already been created and a SQL-server is running for that database. Currently DBAX has been implemented for Postgres. |
| |
DBAX can be used in 3 different ways:\\ | * [[jvs:dbax:manual|DBAX Manual]] |
* as a database client ([[jvs:dbax:databaseclient|see more]]) | |
* as a DBAX web-service ([[jvs:dbax:dbaxserver|see more]]) | |
* as a DBAX web-service client ([[jvs:dbax:dbaxclient|see more]]) This is the most useful. | |
| |
DBAX can be used for: | For instructions on setting up a Postgres database, see [[jvs:dbax:postgres|Postgres]]. |
* managing (creating and removing) database tables - ([[jvs:dbax:managing|Managing]]) | |
* viewing data in database tables - ([[jvs:dbax:view|Viewing]]) | |
* importing/exporting database tables - ([[jvs:dbax:import|Importing]]) | |
* editing database tables - ([[jvs:dbax:editing|Editing]]) | |
* querying database tables - ([[jvs:dbax:queries|Queries]]) | |
* backing-up database tables - ([[jvs:dbax:backup|Backup]]) | |
| |
| DBAX can be used in 3 different ways:\\ |
| * as a [[jvs:dbax:manual:chapter1:databaseclient|Database Client]] -- Talks directly to the database |
| * as a [[jvs:dbax:manual:chapter1:webserver|DBAX Web-Service]] -- Lets web clients talk to the database via an XML-based network interface |
| * as a [[jvs:dbax:manual:chapter1:webclient|DBAX Web-Client]] -- A web client for talking to the DBAX server |
| |
| DBAX can be used for: |
| * managing (creating and removing) database tables - ([[jvs:dbax:manual:chapter1:managing|Managing]]) |
| * viewing data in database tables - ([[jvs:dbax:manual:chapter1:viewing|Viewing]]) |
| * importing/exporting database tables - ([[jvs:dbax:manual:chapter1:importing|Importing]]) |
| * editing database tables - ([[jvs:dbax:manual:chapter1:editing|Editing]]) |
| * querying database tables - ([[jvs:dbax:manual:chapter1:queries|Queries]]) |
| * backing-up database tables - ([[jvs:dbax:manual:chapter1:backup|Backup]]) |
| |
| **See also**\\ |
| [[jvs:|JVS Home]],[[jvs:fscan|fScan]] |
| |