Hi Joshua, as the one responsible for the database backend I'd second what Jakob said. I would like to add that Marmotta was designed from ground up to be database independent. This means that most database specific code has been factored out into separate .sql scripts and .properties files. The goal was to make it easy(ier) to add support for more databases. As Jakob said, the challenges are in the details, however. I spent a lot of time optimizing PostgreSQL as the main production database. For the next Marmotta version, I plan to do even more such optimization, but I am not yet sure how to properly separate it from the business logic code and data model. For example, I would like to make more use of PostgreSQL stored procedures and triggers, because many operations could be sped up significantly. Unfortunately, I cannot do the same for MySQL and H2, as their support for stored procedures is much more limited.
Greetings, Sebastian 2014-04-25 9:42 GMT+02:00 Jakob Frank <ja...@apache.org>: > Hi Joshua, > > welcome to the Marmotta community! > > The short answer is: Yes, at the moment you are limited to > Postgresql/MySQL/H2. > > The long answer: LMF [1] (from where Marmotta originates) once had > experimental support for Oracle but that was long ago when we still > used hibernate as a persistence layer. Hibernate was dropped due to > performance considerations several versions ago. > > Until now, a Oracle backend was not a requirement for the project. > Also, for a serious production setting you need a deep understanding > of DB-specific performance tweaks regarding query optimisation and > db-indexes. > Sebastian did this for postgresql and it brought us a performance gain > by magnitudes for certain operations. > However, for Oracle I fear we do not have such an expert on the > current development team. > > If you are familiar with Oracle as relational database, we would > welcome any contribution towards an oracle backend for kiwi - just > join d...@marmotta.apache.org for discussion and pointers were to > start. > > Best, > Jakob > > [1] http://lmf.googlecode.com/ > > > On 24 April 2014 17:56, Joshua Dunham <joshua_dun...@vrtx.com> wrote: > > Hi Marmotta Users, > > > > I’m new to the group (Hi) and wanted to see about the possibility of > an Oracle based > > backend store. I see there is reference to it in the older > config-defaults.properties, > > > > # Hibernate-specific configuration for Oracle > > database.oracle.url = jdbc:oracle:thin:@//localhost:1521/XE > > database.oracle.driver = oracle.jdbc.OracleDriver > > > > > > but those options don’t exactly work for me when I try to manually code > them in with the appropriate changes for my db instance. > > > > Is there a possibility to use Oracle or am I limited to > mySQL/Postgresql. > > > > Thx, > > -Joshua > > This email message and any attachments are confidential and intended for > use by the addressee(s) only. If you are not the intended recipient, please > notify me immediately by replying to this message, and destroy all copies > of this message and any attachments. Thank you. >
