PRAHALAD's STOCK MONITOR [TABLE]

Tables are categories as 3 categories :

1. Simple columns.

2. Aggregated view.

3. Pivot view.

Table data cache:

1. All Data in memory.

2. Data in memory is the visible page, rest are in db. [More than 1k rows]

Data fetching is of 2 kind:

1. Data update with out sorting.

2. Data update with variable frequency.

3. NO Data update.

4. Data update with sorting on paginate data.

To give an example where am I comming from:

Now various combination of operation that can be applied on the data. Per say i have to run my analysis over a bunch of stocks in various market then rank them according to their category with explaination of those ranking.

Once we do the ranking we also have to explain them the ranking they hold but these can happen in there own time. or on demand. or while creating these numbers i would be storing these information some where in local db.