{"action":"opened","issue":{"url":"https://api.github.com/repos/ciandt-dev/CIOT/issues/63","labels_url":"https://api.github.com/repos/ciandt-dev/CIOT/issues/63/labels{/name}","comments_url":"https://api.github.com/repos/ciandt-dev/CIOT/issues/63/comments","events_url":"https://api.github.com/repos/ciandt-dev/CIOT/issues/63/events","html_url":"https://github.com/ciandt-dev/CIOT/issues/63","id":53252304,"number":63,"title":"Migrate from relational database do NoSQL schemaless approach","user":{"login":"larruda","id":1940532,"avatar_url":"https://avatars.githubusercontent.com/u/1940532?v=3","gravatar_id":"","url":"https://api.github.com/users/larruda","html_url":"https://github.com/larruda","followers_url":"https://api.github.com/users/larruda/followers","following_url":"https://api.github.com/users/larruda/following{/other_user}","gists_url":"https://api.github.com/users/larruda/gists{/gist_id}","starred_url":"https://api.github.com/users/larruda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/larruda/subscriptions","organizations_url":"https://api.github.com/users/larruda/orgs","repos_url":"https://api.github.com/users/larruda/repos","events_url":"https://api.github.com/users/larruda/events{/privacy}","received_events_url":"https://api.github.com/users/larruda/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/ciandt-dev/CIOT/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-01-02T13:22:35Z","updated_at":"2015-01-02T13:22:35Z","closed_at":null,"body":"As far as I know this application has born relational (if I'm wrong you can stop reading and close this issue right now :P). For the nature of its usage, on a production environment with hundreds of sensors generating thousands of inputs per day the amount of data to be recorded is going to increase exponentially. \r\n\r\nIn a matter of time querying all this data on a relational database is going to become unpractical, because of many characteristics of this database kind such as fixed schema, normalised structure, table locking, etc, which results on an unscalable solution for what people call today as \"Big Data\". \r\n\r\nSo I'm raising this issue as an enhancement request that you migrate the data management to a NoSQL database such as Google BigQuery, Redis, MongoDB, Cassandra, whatever you feel its more appropriate. Remember that for those not so used to this \"way of thinking\", the process of denormalising data is not going to be trivial, however the learning process will certainly be valuable :-)\r\n\r\nWhat do you guys think?"}}