my database has a datetime field and data is logged into this database every 5 secs. from 9.0 am to 11.00pm. soon i realized that the datetime field is occupying much more space than the data. also when inserting a new record it is taken care that data is not unnecessarily repeated so a fequency field is added which goes on incremmenting each time a similar data record is encounterd(update previuos record's frequency instead of inserting new)
please suggest me a suitable relational data model.