Hi Manoj,

On 27 September 2014 13:56, Manoj Gunawardena <[email protected]> wrote:

> Hi All,
>
> Is there any reason for not pulling real time data from casendra.  I think
> writing into RDBMS, and then query from RDBMS is too expensive operations.
> casendra has nice REST api to data fetch.
>

+1 to use Cassandra if it offers better performance than RDBMS (Not sure of
the exact perf stats myself.. :-)). Embedded UES released with CEP has a
gadget-gen tool that automatically generates a jaggery file to poll data
from a selected RDBMS datasource and feeds to the relevant gadget. This
feature is planned to be developed for Cassandra as well, but not yet
available. Of course, you can write your own jaggery file to pull data from
Cassandra, in which case, non-availability of support for Cassandra from
UES gadget-gen tool will not be an issue.

I had an offline chat with Chan and it seems that he will anyway be writing
his own jaggery service to pull data from a datasource since he seems to be
using CEP features embedded inside BAM which does not have the CEP/UES
dashboard (BAM has its own dashboard which does not have the UES gadget-gen
tool described above). So it would definitely make more sense to go for
Cassandra if that offers better performance and has nice rest apis.

Thanks,
Lasantha


> As Dilini said, in real time scenarios not persistence of data is not
> useful always.
>
> Some scenarios can be found the same set of data required for real time
> and non realtime dashboards.
>
>
> Thanks
>
>
>
>
>
>
>
>
> On Fri, Sep 26, 2014 at 11:32 AM, Chan <[email protected]> wrote:
>
>> Hi guys,
>> Based on all the replies - what I understand is - we need to use an Event
>> Sink (Output adaptor) to send all data to a RDBMS. Then create a jaggery
>> service to pull data from the RDBMS. And then poll that data from the
>> jaggery service. I am not sure whether we have web sockets support in the
>> jaggery version we are using or whether we support web sockets at all. I am
>> adding @sameeraM and @supunM to confirm this.
>>
>> @Lasantha currently we have written a Data Publisher for BAM. Do we need
>> to use the HTTPInput adaptor to push data to CEP or can we use the BAM Data
>> Publisher we wrote?
>>
>> @Dilini what was the strategy used on the DEBS dashboard?
>>
>> (Jaggery version we are using is 0.9.0.ALPHA4.wso2v3)
>>
>> Cheers~
>>
>> On Fri, Sep 26, 2014 at 11:25 AM, Lasantha Fernando <[email protected]>
>> wrote:
>>
>>> Hi Chan,
>>>
>>> You can't poll data from Cassandra as yet for the real-time dashboard.
>>> Polling from RDBMS databases is supported currently from UES. Also you can
>>> create a web service and poll data from there. I think that was the
>>> approach used by Dilini for DEBS dashboard. You might be able to try
>>> websockets as well which is available in the current development branch of
>>> CEP. Haven't tried it out though.
>>>
>>> @Dilini, can you add more regarding this if possible?
>>>
>>> Thanks,
>>> Lasantha
>>>
>>> On 26 September 2014 11:00, Malith Dhanushka <[email protected]> wrote:
>>>
>>>> In realtime analytics , It doesn't poll data from Cassandra. Rather you
>>>> can utilize preferred output adapter[1] to push results of execution plans
>>>> to dashboards.
>>>>
>>>> [1] https://docs.wso2.com/display/CEP310/Output+Event+Adaptors
>>>>
>>>> Thanks,
>>>>
>>>> On Fri, Sep 26, 2014 at 8:35 AM, Chan <[email protected]> wrote:
>>>>
>>>>> Hi guys,
>>>>> How do we make realtime dashboards for data. Currently the data is
>>>>> Published to the Event Receiver (thus persisted to BAM). Do we poll
>>>>> cassandra from the dashboard to show realtime dashboards?
>>>>>
>>>>> Cheers~
>>>>>
>>>>> --
>>>>> Chan (Dulitha Wijewantha)
>>>>> Software Engineer - Mobile Development
>>>>> WSO2 Inc
>>>>> Lean.Enterprise.Mobileware
>>>>>  * ~Email       [email protected] <[email protected]>*
>>>>> *  ~Mobile     +94712112165 <%2B94712112165>*
>>>>> *  ~Website   dulitha.me <http://dulitha.me>*
>>>>> *  ~Twitter     @dulitharw <https://twitter.com/dulitharw>*
>>>>>   *~Github     @dulichan <https://github.com/dulichan>*
>>>>>   *~SO     @chan <http://stackoverflow.com/users/813471/chan>*
>>>>>
>>>>> _______________________________________________
>>>>> Dev mailing list
>>>>> [email protected]
>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Malith Dhanushka
>>>> Software Engineer - Data Technologies
>>>> *WSO2, Inc. : wso2.com <http://wso2.com/>*
>>>> *Mobile*          : +94 716 506 693
>>>>
>>>> _______________________________________________
>>>> Dev mailing list
>>>> [email protected]
>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>>>
>>>>
>>>
>>>
>>> --
>>> *Lasantha Fernando*
>>> Software Engineer - Data Technologies Team
>>> WSO2 Inc. http://wso2.com
>>>
>>> email: [email protected]
>>> mobile: (+94) 71 5247551
>>>
>>
>>
>>
>> --
>> Chan (Dulitha Wijewantha)
>> Software Engineer - Mobile Development
>> WSO2 Inc
>> Lean.Enterprise.Mobileware
>>  * ~Email       [email protected] <[email protected]>*
>> *  ~Mobile     +94712112165 <%2B94712112165>*
>> *  ~Website   dulitha.me <http://dulitha.me>*
>> *  ~Twitter     @dulitharw <https://twitter.com/dulitharw>*
>>   *~Github     @dulichan <https://github.com/dulichan>*
>>   *~SO     @chan <http://stackoverflow.com/users/813471/chan>*
>>
>> _______________________________________________
>> Dev mailing list
>> [email protected]
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>>
>
>
> --
> Manoj Gunawardena
> Tech Lead
> WSO2, Inc.: http://wso2.com
> lean.enterprise.middleware
> Mobile : +94 77 2291643
>



-- 
*Lasantha Fernando*
Software Engineer - Data Technologies Team
WSO2 Inc. http://wso2.com

email: [email protected]
mobile: (+94) 71 5247551
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev

Reply via email to