Interview Question in Data Mining


 

Interview Question :: Can anyone help me how to implement datawarehousing concepts with MS Acess


I have a Access database which keeps track of mp3 songs along with thier album name, artist, genre etc... Can anyone tell me about where to find information, so that i could make sql queries work faster by applying the concepts of data warehousing or data mining...
Answers to "Can anyone help me how to implement datawarehousing concepts with MS Acess"
RE: Can anyone help me how to implement datawarehousing concepts with MS Acess?

Datawarehousing concepts involve simplified schemas based around star schema ideas which involve main fact tables with other dimension tables linked to them. This allows you to store information (usually added over time) which can be indexed and searched against the dimensions you have chosen.



In the case you mention, datawarehousing is not going to be applicable to your system, unless you are storing data on each time the mp3 was accessed, last played, last changed etc.



I would focus on the structure of your db and make sure that you are adequately indexed on the main columns you access the data. If you are doing searches exclusively by artist or album, ensure that these columns are indexed, so the database does not have to search the whole mp3 table.



If you want more information on speeding up your db, then a search engine search on database indexing will be your friend rather than datawarehousing concepts, which are more applicable to very different storage systems than yours.
 
Vote for this answer ::  
Update Alert Setting