This new version adds the following features to the platform:
· Now, Sofia2’s public webpage, in Italian and Portuguese:
Italian and Portuguese languages have been added to Sofia2’s Site.
We are working also in translating all user guides to these languages.
· Ontologies visual modeling:
An ontology visual editor has been added to the configuration web console in Sofia2`s version2.18, in order to make the modeling of ontologies easier.
(this editor has been built using jsUML2 library developed by Jose Raúl Romero and his team, who we want to thank for his cooperation)
To visually model ontologies, we will use the corresponding button
It will open up the graphic editor
We can build ontologies using the elements shown at the menu, which allow us to create classes, attributes and relations:
After modeling our ontology, we will have a structure similar to the one bellow. Where we can see that an Ontology does not have to be the equivalent of a relational model table, but a complex set of entities which represent a whole domain model.
Finally we will generate the schema that represents the model of our Ontology.
· RTDB (Real Time Data Base) relational Data Bases V1 support.
Sofia2 BDTR reference implementation is built using MongoDB. In this release, relational data base RTDB support has been included. The data base engine works over any relational data base that uses JDBC driver (Oracle, MySQL, PostgreSQL, SQLServer…), even though this first version has been certified on just Oracle Database.
This new implementation allows Sofia2 to be used in Organizations (even Systems ) where we have a Relational Data Base Manager System already deployed or where the systems department already have experience managing them. In this scenario, Sofia2, maintains every functionality and it is transparent for the final platform client (in this case the native query language will be SQL ).
Using a relational data base as Sofia2 RTDB, the ontologies will be mapped as tables of the data model, and Sofia2 RTDB manager module will be which translate from/to the relational model any ontology instance and query result (JSON documents).
When this implementation is chosen, the ontology modeling is done from a new assistant that integrates the capabilities of the Relational Data Base Manager System that has been chosen.
Also whenever the underlying data base supports JSON (e.g. Oracle 12 or Postgresql 9.3) this type of attribute could be selected:
· Binary Support on Sofia2 Ontologies
The Sofia2 Platform already allowed the inclusion of binaries on ontologies but required a manual management when defining the Ontology.
This release includes support for modeling a new attribute type (binary) to our ontologies.
This field allows setting the mime-type, encoding, storage type and name of the binary to be added to our ontology.
In the Java API there is also provided a utility method to easily work with this type of data that allows adding binary with a simple method:
You can find more information on this functionality in the Web Console User and APIs Guide and in the new post.
· New Display Gadgets
In this new version of Sofia2 we have included new gadgets and improved the existing. This allows the creation of more sophisticated Sofia2 Dashboards.
· Improvements in Sofia2 Dashboards
Complementing the new features in the Gadgets there has been incorporated improvements in Sofia2 dashboards, allowing in this version:
New layouts and styles:
· Incorporation of the social network Instagram to the Social Media capabilities of the Platform:
Sofia2 as IoT Platform simplifies the integration of information from any “Thing”, these Things can be devices, smartphones, corporate systems and of course the social networks that are among the most important sources today.
The capabilities of the Platform have expanded including Instagram, on which we can in this version get the most popular media (image and video):
The results can be stored on a new Ontology or on an existing one.
· How to build APPs Sofia2 on App Inventor
In this release of Sofia2 several posts have been published on the Sofia2 blog/wiki in which we explain the integration of APP inventor tool with Sofia2 for visually developing Android applications
The content of the posts is distributed as follows:
– Sofia2 y Google App Inventor: Introducción. (Introduction)
– Sofia2 y Google App Inventor: Primeros Pasos y Configuración (First steps and configuration)
– Sofia2 y Google App Inventor: Enviar Información (Send information)
– Sofia2 y Google App Inventor: Pedir, recibir y mostrar información (Query, receiving and displaying information)
The purpose of these publications is to explain how to make a mobile application and how to configure it to connect to Sofia2 to send and receive information from an ontology.
Related to this task we have done 2 training sessions at the Carlos III University of Madrid supporting the Smart Campus UC3M contest in which Indra participates.