InterSystems, InterSystems Caché, InterSystems cache, InterSystems ensemble, InterSystems healthshare, InterSystems jobs, Cache Object Script, Ensemble programmer, Ensemble developer, InterSystems big data, Mumps language, InterSystems IRIS, MUMPS Programmer, MUMPS Developer, IRIS Programmer, IRIS Developer

DATA DICTIONARY CREATION

DATA DICTIONARY CREATION

Is your legacy system lacking a data dictionary making it impossible for your organization to access your Caché or M based data via standard ODBC reporting tools such as Crystal Reports or Cognos? Are your current reporting tools inadequate or is your vendor unwilling or unable to produce the reports you require?

As you all know Documentum is all about Objects and its attributes, Have you ever wondered where Documentum is storing information about its Object types and its attributes. To get the answer for this question you should know more about Data Dictionary in Documentum. Let me walk you through some of the important aspects of Data Dictionary.

A data dictionary is a database about a database. It define the structure of the database itself and it's used in control and maintenance of large databases The data dictionary (or data repository) or system catalog is an important part of the DBMS. It contains data about data (or metadata). It means that it contains the actual database descriptions used by the DBMS. In most DBMSs, the data dictionary is active and integrated. It means that the DBMS checks the data dictionary every time the database is accessed. A data dictionary may be a separate part of DBMS (non-integrated data dictionary). The data dictionary contains the following information.

 bullet Logical structure of database.

 bullet Schemas, mappings and constraints.

 bullet Description about application programs.

 bullet Descriptions of record types, data item types, and data aggregates in the database.

 bullet Description about physical database design, such as storage structures, access paths etc.

 bullet Descriptions about users of DBMS and their access rights.

Let us leverage our experience & know-how and map your database for you. Our experts are ready to evaluate your system and produce a plan to meet your requirements.