Databases
StackOverflow2013
Postsdbo
PONeed help maximizing 3 factors in multiple, similar objects and ordering appropriately
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONeed help maximizing 3 factors in multiple, similar objects and ordering appropriately
    primarykey
    data
    text
    <p>I need to write an algorithm in any language that would order an array based on 3 factors. I use resorts as an example (like Hipmunk). Let's say I want to go on vacation. I want the cheapest spot, with the best reviews, and the most attractions. However, there is obviously no way I can find one that is #1 in all 3.</p> <blockquote> <p>Example (assuming there are 20 important attractions):</p> <p>Resort A: $150/night...98/100 in favorable reviews...18 of 20 attractions<br> Resort B: $99/night...85/100 in favorable reviews...12 of 20 attractions<br> Resort C: $120/night...91/100 in favorable reviews...16 of 20 attractions </p> </blockquote> <p>Resort B looks the most appealing in price, but is 3rd in the other 2 categories. Wherein, I can choose resort C for only $21 more a night and get more attractions and better reviews. Price is still important to me, but Resort A has outstanding reviews and a ton of attractions: Is $51 more worth the splurge?</p> <p>I want to be able to populate a list that will order a lit from "best to worst" (I quote bc it is subjective to the consumer). How would I go about maximizing the value for each resort?</p> <ul> <li>Should I put a weight for each factor (ie: 55% price, 30% reviews, 15% amenities) and come to the result of a set number and order them that way?</li> <li>Do I need a mode, median and range for all the hotels and determine the average price, and have the hotels around the average price hold the most weight?</li> </ul> <p>If it is a little confusing then check out www.hipmunk.com. They have an airplane sort they call Agony (and a hotel sort which is similar to my question) that they use as their own. I used resorts as an example to make my question hopefully make a little more sense. How does one put math to a problem like this?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USsawa
    1. USuser686327
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PONeed help maximizing 3 factors in multiple, similar objects and ordering appropriately
      1. USjordanpg
      1. VTFavorite
    2. VO
      singulars
      1. PONeed help maximizing 3 factors in multiple, similar objects and ordering appropriately
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PONeed help maximizing 3 factors in multiple, similar objects and ordering appropriately
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThere is no one true correct way to do this, as everyone will weight these factors differently. You could try to find what the average person likes, or what a specific person likes, but there is no one true metric that will capture this in the general case.
      singulars
      1. PONeed help maximizing 3 factors in multiple, similar objects and ordering appropriately
      1. UStemplatetypedef
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload