What is such data exactly?
A mix of structured and semistructured data with pointers between two worlds
Purely XML. Then
- use a relation as a materialized view
Product(name, code, category, subcategory, price, rest)
- Index on name and subcategory
select P.name, P.price from P in Product
where P.subcategory = “sound”