|
|
 |
RE: FN-FORUM: Databases (again)
date posted 1st August 2003 17:32
okay. so if we are going to assume that the company uses MySQL, we can make
a couple more assumptions.
running MySQL, using opensource software, probably on linux.
if you want to do a little more research, goto http://news.netcraft.com/ and
put in the name of the url of your company to find out exactly what OS they
are running. whether it is IIS or Apache etc. this might be another good
area to have knowledge in.
final tip. dont lean back in your chair.
a friend of a friend did this in an interview, and felt himself fall
backwards, so he stuck his legs out to catch himself on the desk of the
interviewer. unfortunately the desk top was loose, so he pulled the desk
top, and contents onto the floor.
he stood up amongst the carnage and said "i have got this job have i?" and
the the interviewer said "no", so he left.
:-)
good luck.
-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] Behalf Of
gtstream
Sent: 01 August 2003 16:53
To: FN-FORUM / [EMAIL REMOVED]
Subject: Re: FN-FORUM: Databases (again)
Thanks for that info.
FWIW, I *do* realise that I would only want the database to reference the
media files, rather than actually putting the media files within the
database itself (if that makes sense).
You basically answered one of my questions by saying that any database could
handle this. After all, a database can reference any files no matter what
they are.
There has been mention of MySQL in the job description, but only an
'awareness of databases such as MySQL', so maybe I'll just go and do some
research into the mechanics of that one.
Thanks again, and wish me luck!
Regards
Grant
----- Original Message -----
From: "David Turner" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Friday, August 01, 2003 4:15 PM
Subject: RE: FN-FORUM: Databases (again)
>
> Hi Grant,
>
> The concensus of the list seems to have been that you wouldnt actually put
> the streaming media into a database. Instead you use the database to look
up
> the location of where the media is stored.
>
> And that the media would just be stored on a file server or a media
server.
> (which may or may not be the database server)
>
> so our db table called media_locations might look like
>
> index | author | track | media_location
> -----------------------------------------------------------------
> 01 david http blues http://myserver.net/david_1.mp3
> 02 grant db blues http://myserver.net/grant_1.mp3
>
> you would write a query in SQL (structured query language) to interogate
the
> database.
>
> so
>
> "select media_location from media_locations where author like 'david' and
> track like 'http blues'"
>
> would return
>
> "http://myserver.net/david 1.mps"
>
> and so on. basically this is very simple stuff, and **any** database could
> handle it. (in fact you could do it using flat text files, but lets not go
> there)
>
> so to go into an interview situation and try and justify using say MSSQL
at
> the expense of MySQL or Oracle would be... er.. ill advised.
>
> alternatively you seem to want to put the media into your database. so you
> would have
>
> index | author | track | media_file
> --------------------------------------------------------------------------
> 01 david http blues "FCR%Y$"VB£^U%*&kalfjd!"£!"£"%$£^%$ ....."
> 02 grant db blues "ADdSAG&"£FDS"£^&$HTYG$£"RF£"!$£"$d ....."
>
> i have done something similiar using blob fields in MSSQL, and there are
> advantages to doing it this way, but for ease of implementation i would
> strongly recommend that you use the first solution.
>
> also if you try googling database and streaming media or RDBMS and
streaming
> media you will get lots of hits.
>
> try
>
http://www.google.co.uk/search?hl=en&ie=ISO-8859-1&q=%22RDBMS%22+%2B%22strea
> ming+media%22&btnG=Google+Search
>
> there looks like a few hits to people who offers solutions.
>
> hth. and i have been **too** patronising.
>
>
>
>
>
>
> david.
>
>
>
>
> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] Behalf Of
> gtstream
> Sent: 01 August 2003 15:26
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM: Databases (again)
>
>
>
> Hi all
>
> Just asking the same question again - anyone know of a resource that gives
a
> quick description of the more commonly used database types and their pros
> and cons? If it's relevant, the database will hypothetically be used to
> access streaming media files. I need to do the research for a job I'm
going
> for, where I need an awareness of databases (at present, I'm aware of
them,
> but that's about it! It would be good if I could go to the interview with
a
> little knowledge...)
>
> Regards
>
> Grant
>
>
>
>
> ==========
> fido.net are pleased to sponsor these Freelancers messages. For all
> your web hosting needs check out http://www.fido.net/ with hosting
> packages starting from just £46.95 a year including VAT.
> Free 0871 Fax2Email numbers also available online!
> http://www.fido.net/ - the internet made simple! - 0800 1072 666
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>
==========
fido.net are pleased to sponsor these Freelancers messages. For all
your web hosting needs check out http://www.fido.net/ with hosting
packages starting from just £46.95 a year including VAT.
Free 0871 Fax2Email numbers also available online!
http://www.fido.net/ - the internet made simple! - 0800 1072 666
To advertise here: http://www.freelancers.net/advertising.html
|
|
|
