Appropriate database for web analytics?

Question

I am working on the web analytics it is similar to google analytics, Currently i am using the mongoDB.

Problem using MongoDB

Writing and reading is performed at the same time so after some point writing is bit slow. So i am looking for appropriate database which is suitable for following requirement.

Requirements

Open Source
Can adapt large volume of data.
Better performance while aggregating the data.
Time based aggregation.
Real time processing.
Driver support for node.js and java.

Database should be scalable with node.js and java

 Saving the data using java.
Fetching the data using node.js

unfortunately, questions for advice on which technology is "best" are off-topic for dba.se — Hannah Vernon, Nov 13 '13 at 05:34
@MaxVernon thanks for information. Technology or programming language used are node.js and java. — karthick, Nov 13 '13 at 05:58
may be you should check the features of https://tempo-db.com/features/ not opensource though — Mithun Satheesh, Nov 13 '13 at 06:53

score 2 · Answer 1 · edited Jun 15 '20 at 09:05

2

I think you are looking for DBs that are designed for analytics. May be you should check these solutions:.

some data storage solutions specific to realtime analytics

reference:

edited Jun 15 '20 at 09:05

Community

1

answered Nov 13 '13 at 07:38

Mithun Satheesh

121
4

Brian Langbecker · Answer 2 · 2013-11-13T06:35:35.183

1

While I work for a competitor of MongoDB, FatDB, but given your requirements are Java, I would say:

Cassandra
Google BigTable (not sure of Node.js support)
Cloudera (more of a Hadoop platform)

edited Nov 13 '13 at 06:35

answered Nov 13 '13 at 06:28

Brian Langbecker

109
3

Thanks, I forgot to mention the open source in the requirement. – karthick Nov 13 '13 at 06:56