Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.

DB Schema (Tables) Definitions Used for Naming Service

DB Schema (Tables) Definitions Used for Naming Service

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

Old KB# 15190

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 18:20
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.