Need Help Restructuring Tables for Fast Data Retrieval
I have below DB structure in MSSQL for a small application which follow relational approach. Data retrieval (for Hostels) will need several Join so looking for suggestions, may be Key-Value approach where data retrieval will be fast. Please advise.
Hostels
------------
HostelId,
Name,
Address,
CategotyId,
SubCategoryId,
FoodCategoryId,
LandLordId
Data:
1 H1 Address1 1 1 2 20
2 H2 Address2 1 2 2 21
3 H3 Address3 2 2 1 17
Category
----------
CategoryId,
CategoryName
Data:
1 Hostels,
2 Paying Guests
SubCategory
------------
SubCategoryId,
SubCategoryName
Data:
1 Gents
2 Ladies
FoodCategory
--------------
FoodCategoryId,
CategoryName
Data:
1 Vegeterian
2 Non-Vegeterian
Amenities
----------
AmenityId,
AmenityName
Data:
1 Breakfast
2 Lunch
3 Dinner
4 Internet
5 Laundery
HostelAmenities
---------------
Id,
HostelId,
AmenityId
Data:
1 1 1
2 1 2
3 1 3
4 2 1
5 2 2
6 2 4
Subject
Views
Written By
Posted
Need Help Restructuring Tables for Fast Data Retrieval
1720
May 28, 2015 12:42PM
891
June 01, 2015 01:39PM
851
June 09, 2015 11:59PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.