List of articles   Colour designations   Choose language


Hypercube from database

There exist typical operation of looking database table as hypercube: one column contains value in node of multidimensional cube, other columns - specify multidimensional coordinates (smaller quantity of coordinate items is shown in browser, bigger quantity is still not inquired from database). Example of so hypercube is displayed below, where "h" and "H" - are headers of dimensions (e.g. "customer", "goods", "city", etc), "v" and "V" - are items of multidimensional coordinates (names of cumtomer, names of goods, names of cities), "a" - is value in node of multidimensional cube.

-----------------------------------------------------
|           | H |         V         |       V       |
|           -----------------------------------------
|           | H |   V   |     V     |   V   |   V   |
|           -----------------------------------------
|           | H | V | V | V | V | V | V | V | V | V |
-----------------------------------------------------
| h | h | h |
-------------   -------------------------------------
|   |   | v |   | a | a | a | a | a | a | a | a | a |
|   |   |---|   |-----------------------------------|
|   | v | v |   | a | a | a | a | a | a | a | a | a |
|   |   |---|   |-----------------------------------|
| v |   | v |   | a | a | a | a | a | a | a | a | a |
|   |---|---|   |-----------------------------------|
|   |   | v |   | a | a | a | a | a | a | a | a | a |
|   | v |---|   |-----------------------------------|
|   |   | v |   | a | a | a | a | a | a | a | a | a |
|---|---|---|   |-----------------------------------|
|   |   | v |   | a | a | a | a | a | a | a | a | a |
|   |   |---|   |-----------------------------------|
|   |   | v |   | a | a | a | a | a | a | a | a | a |
|   | v |---|   |-----------------------------------|
|   |   | v |   | a | a | a | a | a | a | a | a | a |
|   |   |---|   |-----------------------------------|
|   |   | v |   | a | a | a | a | a | a | a | a | a |
|   |---|---|   |-----------------------------------|
| v |   | v |   | a | a | a | a | a | a | a | a | a |
|   |   |---|   |-----------------------------------|
|   | v | v |   | a | a | a | a | a | a | a | a | a |
|   |   |---|   |-----------------------------------|
|   |   | v |   | a | a | a | a | a | a | a | a | a |
|   |---|---|   |-----------------------------------|
|   |   | v |   | a | a | a | a | a | a | a | a | a |
|   | v |---|   |-----------------------------------|
|   |   | v |   | a | a | a | a | a | a | a | a | a |
-------------   -------------------------------------
We enter html-element dialogue, displaying records of database table as hypercube (that database table is demonstrated especially so, instead of representation as table or tree, property type must be equal cube). In attribute roll, we specify name of database table

<dialogue roll="A"/>

dialogue {
  type: cube;
}
or SQL-request
<dialogue roll="select * from A where a15=100"/>

dialogue {
  type: cube;
}
and in properties
dialogue {
  thead1: ža3;
  thead2: ža4;
  thead3: ža9;
  tside1: ža3;
  tside2: ža2;
  tside3: ža5;
  tbody:  ža7;
}
and also

Connection with database occurs via separate TCP-port by protocal SQL5. When browser meets this html-element during loading document, it: Note: field of view A refers to the same column of some table C, to which field of table B, entered into view, refers.

Displayed values are demonstrated so:

P.S.

dialogue with any value of property type (equal to record, tree, or cube) can be master html-element for dialogue with any value of property type. Html-document itself, requests from all dialogue, containing in it, answers to request go sequentially via the same TCP-connection (answers are separated from each other and from html-document by bament <?new/?>, answers come after end of accepting html-document).



Dmitry Turin



List of articles   Colour designations   Choose language