Data
Data integrity
WebQuant is reading the processed data from MassMetaSite or Lipostar MSI obtained from external vendor raw data files or UNIFI samples. The system is keeping a copy of the original data so the user can always download and review either the raw or process data.
The WebQuant workflow for data analysis and reviewing includes two states: in the first one, the experiments are in the Pending state and the user can review/modify the chromatographic peaks, query the raw data. All the activity will be recorded in the Audit trail called Notebook of the system. Once the user decided to approve the experiment then its status changes to approved and in that situation the user cannot modify the experiment anymore. When the experiments have been approved, it can be used in reporting, but the underlying data cannot be modified. Therefore, the system takes care of the integrity of the original raw and processed data as well as the modifications that the user may have introduced. These functionalities together in combination with the user access control to the different modules and functionalities in Oniro help to maintain the system that contains sensitive research and development data.
WebQuant also provides a system for database consolidation enabling the possibility to integrate data from multiple sources into a single destination. WebQuant database consolidation allows the user to consolidate some types of data. The system shows to the user a GUI where he can choose the type of data to consolidate and to let him to set the source data (the one to convert) and the destination data (the one it will be consolidated to). The system also allows the user to remove (or not) the source data after its consolidation to the destination data. This possibility is showed only when the customer has the granted permission to remove that type of data. The database consolidation process takes priority over the import process of the experiments, due to database consolidation meaning itself. When a user decides to consolidate a data, he changed all the source data with the destination data in the whole database. So, the system updates the import mapping information with the consolidation information for all the users, independently from which user has done the consolidation.
Audit trail
WebQuant has an audit trail system called Notebook that records all the operations that are affecting the data, annotating together with the action done, the author (who has made the change in the experiment) and the date. This information is shown in the right panel on every opened experiment, and it can be output to a report, but the user cannot modify it. IF the changes in the experiment are done by the system the user is set to Unknown.
Also, the database consolidation action that is use for data integration is reported in the audit trail of the system. Only users with the enabled role to modify an experiment it can consolidate the data from a particular experiment.
SQL database and Standard data formats
All the information that is produced by WebQuant it is saved in a SQL database system, that can be under several systems: MySQL and Oracle and the preferred ones. The schema of the database is also available for the user. The data it is saved in standard format using mol format for structure description. In this way this database can also be queried directly from the SQL server. The system uses 2 schemas one of the information about the experiment and another one where the raw datafiles are parked. IN the second one the database is used to park the long files that are used as an entire blob of data.
Licensing and Free/easy access to your data
The licensing system is flexible and can be configured to give you access to the different modules of the application. The license system grants to the user the possibility to import new data to the system, but the user can retrieve any data that has been already introduced into the system without the need of having a valid license. Therefore, the data is always available to the user independently of the license. WebQuant provides a Restful API service to communicate with 3rd party software. (Link to the Restful API manual)