Hello,
Welcome to the forum.
Take a look at the PI-OLEDB driver (and PI-OLEDB Enterprise Driver which includes AF), it will give you a relational view of your PI data - along the lines of what I think you need. Also, make sure you take a look at AF when you consider PI.
Happy to help you understand more about PI, just give me a shout (or post on here).
Principal Consultant
Real-Time Data Management @ Wipro Technologies