Looking at How the Catalog Database Fits In - Intergraph Smart 3D - Reference Data

Intergraph Smart 3D Reference Data

Language
English
Product
Intergraph Smart 3D
Subproduct
Reference Data
Search by Category
Reference Data
Smart 3D Version
12.1 (2019)

The software uses seven databases: Site, Site Schema, Catalog, Catalog Schema, Model, Reports, and Reports Schema.

Site and Site Schema

The Site database and Site Schema database are containers for the other databases. The Site database stores work-breakdown and user access for the model. A site database can have multiple model and catalog databases. Typically, there is one site database set for each customer location. To view the Site database, start the Project Management task. For information about site databases, see the Project Management User's Guide, available from the Help > Printable Guides command in the software.

Catalog and Catalog Schema

The Catalog database contains reference data, which includes part dimensions and industry standards. This Reference Data Guide is about the data in the Catalog database. To view the hierarchy and contents of the Catalog database, start the Catalog task.

Using the Bulkload utility, you can create a starting Catalog database and schema from a data file delivered with the software. You can use your own custom Excel workbooks and custom symbols to create a new Catalog database specifically for your project.

After creating the Catalog database, you can modify the delivered reference data. Two methods exist to modify the reference data: you can either edit the workbooks in Excel and bulk load the data, or use the commands in the Catalog task to edit the data (bulkload is not necessary in this case).

Model

The Model database contains all instances of parts in the physical model. The Catalog and Model databases share the same schema.

Reports and Reports Schema

The Reports database and schema interact with the other databases to generate tabular reports from the model data. For information about reports, see the Reports User's Guide and the Drawings and Reports Reference Data Guide, available from the Help > Printable Guides command in the software.

For creation date and size information on each database, you can use the tools delivered with the database engine that you are using. This software also provides further technical details about the relational tables in each database.

The following picture shows the relationships of the databases:

(A) - Reports database
(B) - Site database
(C) - Model database
(D) - Catalog database
(E) - Site Schema database
(F) - Catalog Schema database
(G) - Reports Schema database

See Also

Understanding Reference Data
Learning about Reference Data Types