Geek Answers Handbook

OLAP Cube - PHP and MongoDB

I need to create an analytics system. I have already created a system using MognoDB and PHP, but without using OLAP. Now my queries are really the best I can get, but the system is very slow because there is no cube. Over the past 7 days, you can download the report. I really need the cube options - slice and dice.

So what would be the solution for me? Is there a good cube build with MongoDB that can insert and view data through PHP? Maybe MongoDB will not be good for me? Should I use a different database and start the whole system from 0? What OLAP solutions use PHP?

Edit: More information - Well, the system is similar to Google Analytics. You need to be able to know how many views each day, you need to be able to report only from a specific traffic source and country. The system should process 1,000,000 unique views every day. But not only the number of views, you need to be able to see how many users are returning, what is the average time for each user, etc.

Thank.

+5
source share
2 answers

MongoDB was not created for applications like OLAP cube. I can imagine two approaches:

1) , , . , , , , :

db.visits.update({'': , '': current_day()}, {$ inc: {: 1}})

. . .

2) JasperSoft MongoDB.

+2

, icCube MongoDB. MongoDB , icCube .

+2

More articles:


All Articles