Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
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...
1 Answer
- 1 decade agoFavorite Answer
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.
