Reporting Database

Difference (from prior revision)

Changed: 9c9

Once you have this class in place with child classes that you wish to appear in the reporting database, simply save your Protege repository as an XML backend. Once saved, you can use [http://www.saxonica.com/download/saxonsa8-9j.zip Saxon] to convert the XML using the XSLT to a SQL statement. You must use Saxon8 or higher because we use a number of XSLT 2.0 features. There are two files, the main one being [http://protege.cim3.net/file/work/files/ReportingDatabase/gendatabase.xslt gendatabase.xslt]. This main file includes a second XSLT file [http://protege.cim3.net/file/work/files/ReportingDatabase/model_utils.xslt model_utils.xslt]. You can then feed the resulting SQL statement in to [http://www.mysql.com/ MySQL] at the command line. {nid 8SP}

Once you have this class in place with child classes that you wish to appear in the reporting database, simply save your Protege repository as an XML backend. Once saved, you can use [http://www.saxonica.com/download/saxonsa8-9j.zip Saxon] to convert the XML using the XSLT to a SQL statement. You must use Saxon8 or higher because we use a number of XSLT 2.0 features. There are two files, the main one being [http://protege.cim3.net/file/pub/files/ReportingDatabase/gendatabase.xslt gendatabase.xslt]. This main file includes a second XSLT file [http://protege.cim3.net/file/pub/files/ReportingDatabase/model_utils.xslt model_utils.xslt]. You can then feed the resulting SQL statement in to [http://www.mysql.com/ MySQL] at the command line. {nid 8SP}