panel is selected by the "XML Schema" tabbed pane in the main window.




The fist Column is for XML Schema files. In this column, button allow file opening, save and data analysis.
The save function is not allowed if no file is open. Analyze function is not allowed if no database is open.
Later, edition functions will be added to this column.

The second column is for mapping information. A map file fully compatible with the xmldbms 1.0 mapping format is also created in the default directory (see Preferences chapter for the localisation of this file). For the xmldbms mapping format, see http://www.rpbourret.com/xmldbms/index.htm.

The database may be open before or after the XML schema file, but an open database is necessary for XML Schema analysis and for data manipulation in data panel.

The data panel is selected by pressing on the "Data" tabbed Pane in the main window. A database should be open in order to manipulate data.



Buttons in the upper panel allow data manipulation and the data tree allows data selection in the database.

"Add data to DB" button allows the insertion of a XML file in the database.
"Update data in DB" button allows to update selected data (in the right column) with a selected XML File.
"Extract data..." button allows to create a new XML data file from data in database. The new XML is equivalent to the original file inserted in the database
"Extract fragment..." button allows to create a new XML fragment file corresponding to a fragment of a file inserted in database. This button open the search an navigation window


Search and navigation window

Pressing the "Extract fragment..." button in the Data window open the following window:



The tabbedPane allows the selection of the search mode:

• Navigation mode.
• Keyword search mode.

In navigation mode, the panel present two tables:

• The left table with two columns presents elements hierarchy for navigation
  
  • First column with Element name (as is XML schema)
  • Second column with path (when exists)


• The right column with two columns presents element contains
  
  • First column with Column name (as is XML attribute or as in Database)
  • Second column with attribute or column value

The "Close" button close the window (This window is also automatically closed when another data element or another database is selected in the main window.

The navigation is done by a click on ">" and "<" buttons:

• ">" button is accessible only if an element is selected in the right table (when selected, values are displayed in the right table).
  When the button is pressed, all children element are listed in the left table.
  The path tags in XML schema are not yet interpreted.
  Now, SysDB search for "Id" or "name" attribute name. Later, SysDB will use "path" tag.


• "<" button is accessible if the current element is not the root element.
  When the button is pressed, the left table displays the parent node.

When only one element is present in the left table, this element is automatically selected.



When data values are displayed in the right table, a press on the "Extract fragment;" button create a new XML file. The selected element is taken as root for this file.
A file selector window is displayed for output file name selection.

The Keywords search mode presents the following window:



In Keywords search mode, the panel present two tables:

• The left table with two columns presents search criteria
  
  • First column with XML attribute (as is XML schema) or column name
  • Second column is editable for search criteria
  A pop-up menu above is for XML attribute or column name selection.
  


• The right column with two columns presents element contains
  
  • First column with Column name (as is XML attribute or as in Database)
  • Second column with attribute or column value

The "Close" button close the window (This window is also automatically closed when another data element or another database is selected in the main window).

First select an element name in the pop-up menu above the right table. element name correspond to elements found in the XML schema. After selection, attribute and column names are displayed in the left table, left column (the exact name corresponds to the column name in database, some of the columns are XML attributes and some others columns are added by SysDB and have no correspondance in the XML schema file).
The right column in the left table is editable. User can enter desired values. The syntax for these values is unix™ regular expressions. In this example, only a part of the value is entered.



Press the "Search" button to let SysDB search for data. Results are displayed in the right table. The number of results is displayed above the right table.
The navigation from one result element to another is done with "<" and ">" buttons.



The search can be refined by entering values in more than one field. SysDB uses logical "and" between all fields: