Hi,
1. The better way load data to Apache Ignite via DataStreamer. [1] Also
hight reccomend configure properly data colloacation. In this case
employees for one organization will be placed on the node that allows to
improve join performance. [2]
2. You can create a separate cache which will contains aggregation data
(similar db view), describe on update events and update the cache.
3. Apache Ignite does support this SQL functions and I guess you can with
minimal changes run them under caches with acceptable performance.
On Sun, Oct 1, 2017 at 2:25 PM, James <2305958...@qq.com> wrote:
> I want to generate reports in html table in Ignite as I do in traditional
> database
> 1. load all data such as employee, address, department and organization
> from
> database into ignite. The primary key and foreign key are still kept in
> Ignite.
> 2. In order to do some computation and report, first I need to use a lot
> of
> join to generate a set of data as a view like in traditional database. How
> do I create a view in Ignite.
> 3. On the data in above view, I need to query again to do a lot of
> computations such as "group by" to find a maximum value.
>
> What is best approach in Ignite?
>
> Thanks,
>
> James
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>