Database Reference
In-Depth Information
Table 4.
(
Continued
)
Individual
Query (IQ)
Query Details
IQ25
SELECT tr.table_column_id, tr.value, tr.table_row_id, tr.serial_id FROM
table_row tr JOIN table_column tc ON tr.table_column_id = tc.
table_column_id and tr.tenant_id = tc.tenant_id and tr.db_table_id = tc.
db_table_id WHERE tc.is_primary_key_column =
'
t
'
and tr.
tenant_id = 1000 and tr.db_table_id = 17 and tr.table_row_id IN
(SELECT distinct tr.table_row_id FROM table_row tr WHERE tr.
tenant_id = 1000 and tr.db_table_id = 17 and tr.table_column_id = 60
and(cast(value as numeric) > =
'
9000
'
) and tr.table_row_id IN
(SELECT tr.table_row_id FROM table_index tr WHERE tr.
tenant_id = 1000 and tr.db_table_id = 17 and((tr.
table_column_id =
'
58
'
and tr.value =
'
100
'
)))) ORDER BY 3,4 ASC;
IQ26
SELECT * FROM table_relationship trs WHERE trs.tenant_id = 1000
and trs.db_table_id = 17 or trs.target_table_id = 17 ORDER BY trs.
table_relationship_id;
IQ27
SELECT tr.table_column_id, tr.value, tr.table_row_id, tr.serial_id FROM
table_row tr WHERE tr.tenant_id = 1000 and tr.db_table_id = 18 and
tr.table_row_id IN (SELECT distinct tr.table_row_id FROM table_row
tr WHERE tr.tenant_id = 1000 and tr.db_table_id = 18 and tr.
table_column_id = 81 and(cast(value as numeric) > =
'
30
'
) and tr.
table_row_id IN (SELECT distinct tr.table_row_id From table_index tr
WHERE tr.tenant_id = 1000 and tr.db_table_id = 18 and((tr.
table_column_id =
'
80
'
and tr.value =
'
9
'
) OR (tr.
table_column_id =
'
80
'
and tr.value =
'
12
'
)OR(
…
and other symetric
query lters, but with different values)) LIMIT 1 OFFSET 0)) ORDER
BY 3,4 ASC;
IQ28
SELECT * FROM table_relationship trs WHERE trs.tenant_id = 1000
and trs.shared_table_name =
'
product
'
ORDER BY trs.
table_relationship_id;
IQ29
SELECT * FROM table_relationship trs WHERE trs.tenant_id = 1000
and trs.shared_table_name =
'
sales_fact
'
ORDER BY trs.
table_relationship_id;
7 Conclusion
In this paper, we have proposed a multi-tenant proxy service for EET called EETPS,
which integrates, generates, and executes tenants
queries by using a codebase solution
that converts multi-tenant queries into traditional database queries and execute them in a
RDBMS. This service has three objectives. Firstly, it allows the users to choose from
three EET database models, including multi-tenant relational database, integrated
multi-tenant relational database with virtual relational database, and virtual relational
database. Secondly, it allows users to extend their database schemas, by extending a
single schema of a business domain database based on a traditional RDBMS during the
application
'
'
s runtime. Thirdly, it avoids programming effort associated with writing
Search WWH ::
Custom Search