This my first post here, happy to join.
my question is regarding the right DB choice for an application.
I am to build a big-data application which would require constant updating on one side, and constant querying on the other.
The (frequently accessed) data consists mostly of textual fields, and some relations between data objects may result from analytic calculations performed on them:
Initial data will be of constant record types - one can call it 'flat' data. lots and lots of records of flat data.
analytic calculations will aggregate and manipulate the flat data, and the results will be stored in the database as well.
queries on the data will be performed on all data levels.
time related data manipulations require that the database model supports datetime type fields.
my question is which DB would you think be best suitable for such an application?