Database overview

SME LibreAquarium has a simple design. Various tables have been used to separate different functions or species. The fishes, plants and invertebrates that live in our aquariums have their own tables. The expenses, analytics, task and incidents too. All of then share an ID number, that it´s used to aquariums identification in each table.

The other 3 tables are the central Database of fishes, plants and invertebrates. These tables are consulted by the Simulator to check the parameters and when we add an specie to an Aquarium. In other words, the specie that we are going to add to the aquarium should be included in the central database with the corresponding requirements, in order to control.

How the SME determines if the environment is correct for the aquarims habitants?

It´s a nice question that requires theory explanation about Biology and Chemistry. However, it can be explained in an easy way. The concept is simple. In all aquatic systems there´s a relationship between the pollutant consumption and generation. In the aquariums, as they are “closed” environments it´s logical to think that the pollutants will increase until they reach to a toxic values for the aquarium habitants. This is the principle that folows the Simulator. It simply, checks if the recorded analytics along the time and tries to predict when the limit values will be reached. Let´s describe it in a complete way:

OBJETIVE: Determination of the expected days until de limit amount of  NO3, PO4 and Fe is reached

METHOD: With more than 4 analytics along the time we can determine what is the average amount of these elements that are produced per day in the aquarium.

MATERIALS: Aquarium pH,gH,NO2,NO3,PO4 and Fe measure kits.

HYPOTHESIS: The fish feeding and their life cycle will increase the NO2 and NO3 in the system. The Nitrogen cycle will maintain NO2 close to 0. However the NO3 will increase. If the aquarium counts with enough number of plants, part of this NO3 could be consumed. The amount of the consumed NO3 depends of the plant demands, the Fe. micro elements concentration and light availability. Anyway, we expect that the NO3 value increases along the time.

In the same way, the amount of Fe will be reduced by the plants, so the limit will be reached quickly than the NO3 limit is reached. The PO4 will also increase, and its average rate could be more rapidly depending on the quantity of fish.