different algorithms, sql queries and other stuff implementation