I've got a 10Mb+ XML table. For ease, let's say that the table has year, make, and model of cars.
I'd like to show the table with year only. If the user clicks on the year, I'd like it to go back and query the parent xml and return all the makes of the cars. If the user clicks on the make of the car, I'd like it to go back and query the xml by year and make and return all the model cars.
It's important that the entire XML doc is not loaded... it's too big. Basically, user interaction queries and returns data.