John Riker

John Riker

  • NA
  • 85
  • 15.8k

Best way to collect and use groups of data.

Dec 11 2020 5:07 PM
So I have data that is similar and want to group it so I can loop thru and find the one I want to use for some video content..  So for example:
 
  1. - ContentType: audio  
  2.    - _bandwidth: 1234567  
  3.    - _media_path: c:\blablabla\joe.ac3  
  4. - ContentType: audio  
  5.    - _bandwidth: 435435345  
  6.    - _media_path: c:\blablabla\joe.eac3  
  7. - ContentType: video  
  8.    - _bandwidth: 43534543545  
  9.    - _width: 1920  
  10.    - _height: 800  
  11.    - _media_path: c:\blablabla\pete_1.mpg  
  12. -ContentType: video  
  13.    - _bandwidth: 345345435  
  14.    - _width: 1280  
  15.    - _height: 1024     
  16.    - _media_path: c:\blablabla\pete_2.mpg  
  17. -ContentType: video  
  18.    - _bandwidth: 5435345  
  19.    - _width: 640  
  20.    - _height: 480  
  21.    - _media_path: c:\blablabla\pete_3.mpg  
I'd share the actual XML but it's massive and a lot of garbage in it.  So basically I'm trying to pull all the audio info together and then all the video info together.  Assume separately since they have different data but technically they don't have to be as some of the fields on the audio side could be blank which I'm fine with to keep it all together.
 
What is the best way to store this kind of data.  Essentially in the end I'm going to find out which video has the most bandwidth and pick that one as the highest quality video and do something similar with the audio, however need to collect it all into one place and then compare. 
 
EDIT:  And should probably say, be able to sanely be able to keep track of what is what.
 
Thoughts?
 
Thanks.
 
JR 

Answers (2)