July 24, 2008 at 10:06 am
Have an interview next week. They will implement fundamentally sound data warehouses. I have no clue about this. Anybody has idea?
Thanks in advance
Alan
July 24, 2008 at 10:31 am
I know you can store picture and audio files in a database, just like any other data. It just takes more room.
It sounds like they may want to have stock sounds (or maybe sound transitions?) for use in presentations, announcements, maybe radio broadcasts? Can you say what kind of company it is? How do they make their money?
July 24, 2008 at 10:42 am
fundamentally sound meaning a strong design and good foundation or storing audio data?
I'd think that meta data is the key with audio data to be sure it can be found, queried, patterns matched, etc.
July 24, 2008 at 10:46 am
Right, I should have said audio data. I know some radio news shows pump up the "excitement" with various sound bites. One Southern California news reporter re-uses clips of voices saying "Yeah, right!" and Ted Kennedy singing "La Cucaracha" when he wants to take a dig at someone in the news. Those audio files have to be stored somewhere.
July 24, 2008 at 1:07 pm
If you don't understand even what the job is, why are you interviewing for the position? You should call them and ask what they are talking about. If you do not understand, interviewing seems like a waste of your time as well as theirs.
July 24, 2008 at 3:21 pm
They are looking for a database developer. This is one of the responsibilities.
Thanks, Steve and jpowers. I guess they need a way to query, patterns match for audio data. Do you guys have any idea how to query audio, image files in SQL server?
July 25, 2008 at 9:06 am
Actually attempting to do matches and searches on the content of the files themselves is - realistically - infeasible. What you'd be looking for would probably be setting up Dims for things such as Artist, Publisher, Year, Genre, Sub Genre (if it's a database of musical files, for example) with a description in the fact table which can be searched via a full text index for keywords - as a start.
Personally, if that is what they're looking for I'd say a 3-5NF relational design would probably suit better than a Dimensional Model. But that's just a guess based on what I *think* they *may* want to do - I could be talking rubbish. However, a dimensional model is generally used for measuring and reporting - not storing and retrieving
July 25, 2008 at 2:02 pm
Thanks, Andrew. very helpful
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply