Databases
StackOverflow2013
Usersdbo
USdave
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USdave
    primarykey
    data
    text
    plurals
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. POWhy doesn't the printf statement execute here after entering some text and pressing the "enter" key (EOF)?
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhy | doesn't work with find?
      1. USdave
      1. VTFavorite
    1. CO@Vanwaril The algorithm I provided works for the relaxed version of the problem I have formulated. The algorithm cannot pick up "2,3" first due to the fact that "1,2" is added to the list "pair-areas" before "2,3" in step 1, thus, when sorted in order of ascending pair areas (step 2), "1,2" will still appear before "2,3" even though they share the same value for their area. In order to "break" my algorithm, one would need to recur to an extraneous "black" rectangle labeling scheme, e.g. labeling the "black" rectangles "3, 1, 2, 4", as opposed to "1, 2, 3, 4" as you suggested.
      singulars
      1. PO
      1. USdave
    2. COMy suggestion for @Louis, still is to review the literature on existing *geometric clustering algorithms* to avoid trying to reinvent the wheel, *perhaps* in light of the algorithm I have provided for a relaxed version of his problem. Alternatively, he could also investigate the possibility of applying a genetic or simulated annealing algorithm to this problem.
      singulars
      1. PO
      1. USdave
    3. CO@BlueRaja The case you originally stated ("black" rectangles as endpoints of "a cross") can also be solved with two "red" bounding rectangles without overlap resulting in the same area as the solution that involves overlapping. The new case you suggest ("extremely far" fifth square) is optimally solved for total area by use of overlapping as you suggest.
      singulars
      1. POGiven a set of rectangles, find 3 bounding rectangles with the smallest area
      1. USdave
 

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