Join our community and discuss about SysDB, UP, XP, MDA, UML, Java, Corba...

Click here

 

Index - Page : 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8

SysDB Version Beta 0.3


What is SysDB ?

SysDB is a tool for synchronizing XML Files (based on XML Schema) and a Relational Database. XML files are stored and managed in the database.
When the XML file change, only changes are added on the Database and all versions can be retrieved from the database.

The structure of the database is completely dependent of the XML Schema which describes the XML files.
The database schema is automatically synchronized with the XML Schema, keeping the database management as simple as possible. When the XML Schema changes, there is no need to create another database. Database Tables and Column are updated to encompass new XML elements.


Why SysDB ?

Sysalys is developing modelisation tools for System Engineering. Since our internal format is based on XML Schema, we have searched a tool to synchronize our data with a relational Database. But, if there is a large amount of tools, no one was able to do what we need:

  • Relatively large XML files,
  • Based on XML Schema (There are many tools based only on DTD format)
  • The XML output should be as close as possible from the input XML format (avoid all marshalling/unmarshalling operation)
  • Manage change with the smallest granularity.
  • Manage non UTF-8 encoding.Manage multiple Schema files.
  • Manage recursive element definitions
So, we decide to develop our own technology (based first on xmldbms v1, but with many adaptations).

Installation Requirements

The software is written in java 2 and tested on PC (Windows XP™) and Macintosh (MacOS™ X.2). If Someone want to test on another platform, the Windows™ version should be used.

SysDB needs JAVA2 and a database Installed. MySQL™ is the only database tested today, but things may change. The database may run on another computer in the network.
JAVA2 and the database are not delivered with SysDB.

SysDB is delivered with two libraries :
mm.mysql-2.0.14-bin.jar as a database driver
xerces.jar for a XML Reader


Installation
  • Macintosh:
First verify if java 2 is installed. In terminal application type: "java -version" and the answer should be (version 1.4.1 minimum):
java version "1.4.1_01"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1_01-39)
Java HotSpot(TM) Client VM (build 1.4.1_01-14, mixed mode)
If Java 2 is not installed, update your System on apple site:
http://www.apple.com

Verify that a mySQL database is accessible somewhere. To install mySQL on macintosh there are some interesting sites:
http://www.mysql.com
http://www.entropy.ch/software/macosx/mysql
http://developer.apple.com/internet/macosx/osdb.html

Expand the downloaded file with Stuffit Expander™
  • PC Windows:
If Java 2 is not installed, update your System here :
http://java.sun.com (install J2SDK)

Verify that a mySQL database is accessible somewhere. To install mySQL on PC there are some interesting sites:
http://www.mysql.com
http://www.easyphp.org

You are looking for a quotation ? Send us your request on line.

Click here

Tel :
+33 1 60 13 18 70

© Copyright 2003 Sysalys - All right reserved