Welcome to the new Gigaspaces XAP forum. To recover your account, please follow these instructions.

Ask Your Question
0

How to perform join from multiple objects ?

Hi Team,

We have a requirement to perform a join in gigaspace. I believe gs doesnot support joins between multiple objects.

Scenario :

We have multiple tables in our database like Shipment, Route, Customer. Now we have a front end where we have a screen in which we have to display data whose some fields are present in Customer like customerId, customerName then we have some fields from Shipment like shipmentId, shipmentCarrier etc.

So how can i effectively fetch the data from space without making multiple calls, for each Table.

One way is executing a task, but i dont think it sensible to execute a task for every customer.

So how can i effectively replicate a SQL join in gigaspace

asked 2017-05-13 08:33:12 -0500

Harvey gravatar image
edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted
0

You have few options: - Model the data using same parent class for all types (Shipment, Route, Customer) and execute custom aggregators. Query against the parent object fields that are common across multiple class types, but in the custom aggregator you can determine the child class type and perform conditions against fields that only pertain to the child class. This will work very fast. We can post example how to do this. - via InsighEdge. Load into spark whatever data required and join via spark SQL. - XAP JDBC API. It does support multi table join. Not fast as custom aggregators but easy to use.

Shay

answered 2017-05-15 08:28:52 -0500

shay hassidim gravatar image
edit flag offensive delete link more
0

Hi, Distributed tasks are good idea, it doesn't have to be a task per customer, You can return from the task collection of the joined data if you don't need paging.

Regards, Ester.

answered 2017-05-15 08:25:48 -0500

Ester gravatar image
edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2017-05-13 08:33:12 -0500

Seen: 117 times

Last updated: May 15