StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
819922
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-05-04T12:39:07.750
FavoriteCount
0
LastActivityDate
2015-11-01T08:40:19.350
LastEditDate
2015-11-01T08:40:19.350
LastEditorUserId
1862812
OwnerUserId
17174
ParentId
819866
PostTypeId
2
Score
27
ViewCount
0
LastEditorDisplayName
text
Body
Music similarity is not an easy problem. There are two general approaches to solving this problem. Approach 1. Throw data at the problem. This is the approach LastFM and Pandora take. It's basically one huge database which is maintained by either a community or group of experts. Note that to use this approach you will need clean metadata or some kind of audio fingerprinting solution like <a href="http://musicbrainz.org/" rel="noreferrer">musicbrainz</a>. Once you have the feature database you can use algorithms such as <a href="http://en.wikipedia.org/wiki/Correlation" rel="noreferrer">Pearson correlation coefficient</a> to find similar items. Approach 2. Throw algorithms at the problem. In particular, computer audition algorithms. This means you calculate vectors of various features a song contains and using neural nets and a variety of other techniques you find other songs with similar vectors. This approach has been used successfully for <a href="http://webhome.cs.uvic.ca/~gtzan/work/projects/pastc.html" rel="noreferrer">automatic genre classification</a> and <a href="http://en.wikipedia.org/wiki/Query_by_Example" rel="noreferrer">query by example</a>. If you are looking for open source software for music analysis, <a href="http://marsyas.info/" rel="noreferrer">marsyas</a> can do pretty much everything the commercial stuff can do. Its the brain child of <a href="http://webhome.cs.uvic.ca/~gtzan/" rel="noreferrer">George Tzanetakis</a> and on his web site you can find many papers about the state of affairs with computer audition. 
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POMusic analysis software
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USNikolay Kostov
UserOwnerUserId
1. USSam Saffron
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POMusic analysis software
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.