Bottom Clause Construction

• A tightly-coupled approach

  • prepare the tables for each modeb
  • prepare the tables for registered term for each type

<For each modeb>

INSERT INTO modeb_MODEB

SELECT DISTINCT T.att1, ... ,T.attM,

(depth+1) as depth, R1.id

FROM rterm1 R1, … ,rtermN RN, modeb T

WHERE

(R1.id = R2.id AND ... AND R(N-1).id = RN.id)

AND

(R1.depth = depth OR ... OR RN.depth = depth)

AND

(R1.inst = T.att1 AND ... AND RN.inst = T.attn)

AND … //Some Condition for modeb

<for each -type>

INSER INTO rtermN

SELECT DISTINCT

Att as inst , depth, id

FROM modeb_MODEB

[ WHERE Att NOT IN (

SELECT Old.inst

FROM rtermN Old

)]

前のｽﾗｲﾄﾞ

次のｽﾗｲﾄﾞ

最初のｽﾗｲﾄﾞに戻る

ｸﾞﾗﾌｨｯｸｽの表示