Data Base

To many ads? Support ODJT and see no ads!

Brian Martin

New DJ
Dec 7, 2006
2,521
0
Everywhere
Do most of you list the first name of the artist first, followed by the last name.
Example: Tom Petty
or Petty, Tom
I know when you rip your music and create a database, it always list the first name followed by the last name, but I kind of like the last name first. Lot of work changing it though. Any opinions?
 
Used to go by last name first, now I've gotten lazy and use first name first...if that makes sense?
 
Ditto Kirby so many of my albums came back on audiograbber and visitrax Artist first name then last I gave up and now just look my first name and have changed all files in the process. I was adamant about it with vinyl and CD as well as adamant about staying with the formats. Eventually things wear you down like carrying 12 crates of vinyl or typing each name last name first with a bad case of artrhitis in my hands. I call it the Ali technique. Eventually to stay on top you have to adjust your weknesses as they present themselves ASAP.
 
I hear you on that Brother Jon!

I used to manage a record store (remember those vinyl things?) and I had to have all my music arranged by, Artist name (last name, first), Band name (first word, etc.) just like you would find it in a properly tagged store...then I just gave up and went with the flow. :sqembarrassed:

I'm just glad that most programs ignore the word "The".... :sqrolleyes:
 
I've always had mine First Name Last Name because when most people ask for a song, especially for karaoke, they don't ask for Petty, Tom they want to know if I have any Tom Petty.

In a record store it makes sense to organize via last name or first word in an artists name or band name. On computer however, makes more sense to go by first name instead... I've never had someone ask for anything by Kelly, R. Couple that with the fact that most DJ software is geared for "SayIt" or basically starts bringing up results as you type so if you happent to be searching for Michael W Smith and you just enter Smith your likely to find what your looking for just as quickly.
 
Everything is arranged in my data base by last name first and first name last. Whether it is the easiest way to do it is a matter of conjecture, but it would be too much work to change things now
 
Everything is arranged in my data base by last name first and first name last. Whether it is the easiest way to do it is a matter of conjecture, but it would be too much work to change things now

Agreed, once you start one way might as well continue... there are however loads of programs that will re-name files in batch.... but if your like me you're too lazy to do it. So on we march to our respective drummers.
 
Brian Martin : Using the Last Name, First Name has many advantages in a data base management scheme as it relates to outside search for information.

Charting information is by last name first. Bibliography and biography information is by last name first. Almost every catalog and search feature is by last name first.

There are a few programs that operate and/or manipulate large numbers of files in a batch mode, whether file name and/or ID3 tag.

This also holds true for numerically names groups. 3 Doors Down won't be found in any outside reference materials under numerical "3". It will be under alpha "Three" though listed as "3". Might be a solid consideration the rename numerical to alpha will you're at it.
 
mine are all stored by first name, last name for the most part

however....when i do searches for tom petty....i'm not going to type in "tom", i'd probably type in "petty" because it's pretty unique and only his stuff would come up.
i don't do much scrolling through my list....i'm either searching or looking in catagories..so the exact way it's listed doesn't make much difference.

kinda like my ac-dc songs....i'm not going to type in "ac-dc" because some are actually "ac/dc" or "acdc" and because i have lot of them.....i'd just type in "shook me".


i'm not sure if all programs do searches like that, but i think so...i use ots.
 
Petty, Tom
Lennon, John
Beatles, The
Etc.

Just like the record stores. It's the more professional way to catagorize.
It makes it easier for catagorizing & looking up.
I don't care to look through a zillion "John"
it's easier to type in "Lennon,"

If you wanted to print out a list for someone, to have it alphabetized by first names looks silly & is more time consuming to look up a song based on the artist.
 
Please stand by. Rant follows. Not pointing a finger directly at anyone person by using a recent post but merely using it as an illustration. Moderators, if this is out of line, please delete it. Bill, if it offends you, I will delete it and except my advance apologies.

It's the more professional way to catagorize.
Lord have mercy, that word does not apply!
Universally accepted? Fine.
Chronologisist preference? Fine.
The way I like to do it? Fine.
professional ? Says friggin who?
 
I use first name last name, e.g. Tom Petty

I also use "The", as in The Beatles, The Rolling Stones.

With software, it shouldn't matter, as it should be able to search based upon a substring, and across all fields available.

When I used vinyl and CDs, they were in last name order -- which was a major PITA to add anything to a crate :sqerr:
 
Petty, Tom
Lennon, John
Beatles, The
Etc.

Just like the record stores. It's the more professional way to catagorize.
It makes it easier for catagorizing & looking up.
I don't care to look through a zillion "John"
it's easier to type in "Lennon,"

If you wanted to print out a list for someone, to have it alphabetized by first names looks silly & is more time consuming to look up a song based on the artist.

Thank you Cap you took the words right out of my mouth.... that said.

Bill the flaw in your logic is this... its a matter of opinion not professionalism... it's about what works for you not the profession.

Yes it's true the universal way to organize a physical inventory is typically alpha based on last name or first word of the group name. However, in the virtual world there are no set rules. As I've posted previously most softwares use the a search that searches the entire song title string including first and last name, song title and will find matches with in that. Which makes how your store (ie file name) less important.
 
is this with your HD 2500? Scott? Are you using it regularly now?

i still find myself using the computer more......but the way i search is the same with the 2500....i do use categories there too.
 
I'm basing it on the common way to look things up or catagorizing things.

Examples:
Phone books...Imagine having to look through all the Roberts' or Marys' to find someone?
Record stores
Etc. etc.

To each his own I guess.
 
I'm basing it on the common way to look things up or catagorizing things.

Examples:
Phone books...Imagine having to look through all the Roberts' or Marys' to find someone?
Record stores
Etc. etc.

To each his own I guess.

In the above you'd be correct.... but in the virtual world of computers the how it's listed is a moot point.

More often than not I get this question "do you have that song by Jimmy Buffett?" not "Do you have that song by Buffett, Jimmy?" see the difference. Same goes for my karaoke books.... and we are not talkin phonebook sized books.... so the phone book example is bogus.
 
Bill on the HD2500 I can type John Lennons birthday and get his song list nearly. On my laptop using Visitrax you type keywords and it limits all to that word then you add more as you go it narrows down which in the library record stores and phone books cant narrow down with keywords cause they are an actual physical item unlike a computer file. Which is the only way any format works and can be acceptable and whatever works for you alongside another persons way.