*4.2. Database*

The system is provided with a database used to store information about users' profiles, predefined locations with their light requirements, and information about registered locations and light measurements performed until the date.

The first time the application is running, the database will only have information about the different locations and their characteristics. This information will be the base for the light analysis done by the application.

To ease the use of this tool by different users, it provides a local user register, making it possible to personalize the information about the measurements performed by each user in the same device.

The developed system has two databases. On one hand, a database for the mobile application has been developed using SQLite, since Android has integrated a complete API that allows the managemen<sup>t</sup> of this kind of database. The main advantages of SQLite, along with the fact that it is open source, are the use of small size records, it meets the SQL-92 standard, and it does not need a server to run [34]. On the other hand, a Web server database was developed to store all the information and share it with other users. At this point, the database was developed using MySQL. In this case, to avoid all the personal information related to the user, it will only store the number of users in the application, making it necessary to check this value each time that a user is registered in the mobile application. In this way, all the information has an anonymous origin, thus fulfilling the Constitutional Law for Data Protection (LOPD) [35].
