Problem:

DB Schema (Tables) Definitions Used for Naming Service

Resolution:

• Product Name: Visibroker
• Product Version: All
• Product Component: Naming Service
• Platform/OS Version: All

Description:

List?the different tables used?by Naming Service and their purpose.

Answer/Solution:

There are 4 tables that are created by Visibroker for Naming Service

The tables are as follows:

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
VBINS_NAMEMASTER_CTX_TBL
(
CTX_INDEX INTEGER,
CTX_TYPE INTEGER
);

This table stores the information for each context that gets created.
Each context gets assigned a unique index value.
Column CTX_INDEX stores this unique index value.
Column CTX_TYPE stores the type of the context such as root context, normal context, or cluster context type.
A new row gets added to the VBINS_NAMEMASTER_CTX_TBL every time a new context gets created.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
VBINS_NAMEMASTER_GRAPH_TBL
(
PARENT_CTX_INDEX INTEGER,
NAME_ID VARCHAR(255),
NAME_KIND VARCHAR(255),
C_TYPE INTEGER,
REFERENCE LONG
);

This is the binding graph table.
PARENT_CTX_INDEX column stores the parent context index of the bindings.
C_TYPE column tells what kind of binding -- object binding, context binding, cluster binding etc.
The stringified object reference is stored into the REFERENCE column if the binding type is object binding.
The object id is stored for context and cluster binding type.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
VBINS_NAMEMASTER_META_TBL
(
C_TYPE VARCHAR(255),
INDEX_VALUE INTEGER
);

This table has only one row right now and its sole purpose for now is to remember the last index value used.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
VBINS_NAMEMASTER_CLUSTER_TBL
(
CLUSTER_INDEX INTEGER,
CRITERION_TYPE INTEGER
);

This table stores the cluster - criterion association.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Related Articles:

http://support.borland.com/kbclick.jspa?categoryID=124&externalID=2575&searchID=1228602
http://support.borland.com/kbclick.jspa?categoryID=124&externalID=4598&searchID=1228602

Author: Boney Sze