Databases
|
MicroStation® is a tool for designing, analysing, and presenting 3D models. As well as the visual aspect of modelling, MicroStation also lets you annotate components of a model with alpha-numeric data. Those alpha-numeric data may be stored in the same file as the model, in which case we have an internal database. Alternatively, they may be stored in an external database. Each method of storage has its advantages and disadvantages.
Internal Databases (non-graphic data)
MicroStation provides a number of ways to store alpha-numeric data in a DGN file alongside your geometric model data. Some methods are there to support legacy data, others have been introduced more recently and offer a flexible and accessible way to store and retrieve data.
Alpha-numeric data may be associated in some way with a graphic element. A DGN file can store unassociated alpha-numeric data.
Here are some ways that MicroStation lets us store data in a DGN file …
| Name | Location |
|---|---|
| Application Element | DGN file: non-graphic DgnStore |
| User Data | Element user data linkage |
| XData | Element user data linkage |
| XML Fragments | Non-graphic DgnStore |
| Tag elements | Independent or associated with an element in a DGN model |
| XAttributes | Associated with an element, but stored separately, in a DGN model |
Application element
A type 66, level 20 application element is a survivor from IGDS. It's a MicroStation idiom and has limitations — primarily space for data is limited by the MicroStation element size.
User Data
User Data is a MicroStation idiom. Data are appended to an element in a non-structured format. Or rather, the structure is dependent on the application that created the data. An element may have multiple user data linkages. The amount of data that can be attached to an element is limited.
There is no standard user interface for user data. Because the data are application-dependent, it's up to the application to provide a user interface if appropriate.
XData
XData is an AutoCAD™ idiom. It's been added to MicroStation explicitly to support data exchange. It's implemented as User Data. That, of course, might be a benefit in some circumstances. XData in MicroStation is subject to the same limitations as XData in AutoCAD and MicroStation User Data.
XML Fragments
A child of the V8 era in the 21st century, XML Fragments don't suffer the constraints of IGDS or DWG data. XML Fragments can be attached to an element or free-floating. As structured data, this approach could be very fruitful.
However, XML Fragments pre-date XAttributes and as such when you create an XML Fragment element the data actually gets stored as non-graphic DgnStore elements.
An example of XML Fragments is provided Bentley's own product Bentley Map, which implements its XFM GIS data very effectively using XML Fragments.
Tag elements
Tags can be can be attached to an element or free-floating. Tags are structured data, and are supported by MicroStation's user interface. Third party products, such as FlexiTable, can be used with tags.
XAttributes
Brien Bastings: The Bentley folks love XAttributes and that is the preferred way to store new variable size/parasite data on elements.
XAttributes are data that are stored on an element, not in an element.
An XAttribute is not part of the element's data (that is, visible through an MSElement).
By way of contrast, a User Data linkage is part of an element's data.
XAttributes were introduced with MicroStation V8i. They are stored in the non-model cache of a DGN file. There is no user interface for XAttributes.
Here's a Be Communities article about XAttributes for MDL developers: Getting Started With XAttributes.
External Databases
MicroStation provides a way to connect to relational databases such as Oracle™, Microsoft Access®, and Microsoft SQL Server®. Graphic objects in a 3D model are linked to corresponding rows in the database. suppose, for example, that a model of a house contains a cell representing a door: the cell is linked to a database table that stores the manufacturer and cost of doors. We can run a report that extracts the cost of the door and with other items. The report tells us the total cost of the components making up the house.
When a relational database is linked to MicroStation, it must have certain components. Firstly, the MSCATALOG table must exist and must have columns EntityNum and TableName. For each table in your database that you want to link to MicroStation, that table must have a column named MSLINK that stores a 32-bit integer (Int 32). The name of that table must be present in MSCATALOG's TableName column, and should be assigned an Entity ID (table identity) stored in the EntityNum column.
|
Here are answers to questions about MicroStation® Database Linkages that are posted from time to time on the Bentley Discussion Groups. The questions are posted by MDL and VBA developers as well as database developers.
Bentley Systems have a Technical Note about databases and MicroStation: Databases and MicroStation V8 FAQ
Q What is an MSLINK?
When you link a database to graphic elements in MicroStation, you create a correspondence between a row in a database table
and the element. The table that contains the row must have a column named MSLINK, having datatype 32-bit integer.
The element has a corresponding MSLINK 32-bit value, known as the database linkage or database attribute.
There is more information about MSLINK.
Q How does the database provided by MicroStation work?
A MicroStation does not provide a database. It provides a database server that communicates with an external relational database. Relational databases that work with MicroStation include Oracle Enterprise Server™, Microsoft SQL Server, and Microsoft Access™. For more information, visit the Bentley Systems web site.
There are some example files and databases delivered with MicroStation. The example database is located in …
X:\Program Files\Bentley\Program\MicroStation\database\odbc\examples\
The example files are located in …
X:\Program Files\Bentley\Workspace\Projects\Examples\Mapping\dgn
Where X is the drive where your MicroStation installation is located. This is usually the C drive.
Q I would like to know more about the link between objects and the database.
A Each object (graphic element) that is linked to a database has a database linkage attached to the element. Sometimes this is called the MSLINK in Bentley Systems' and other literature.
|
When you use MicroStation's Analyse tool (the i icon) on an element that has a linkage, the Attributes tab will reveal the linkage in Hexadecimal.
Each linkage comprises …
- a unique signature (found in
\mdl\include\dbdefs.h) - a
MSLINKvalue - an
Entity IDvalue
|
In C or C++ the Entity ID and MSLINK are long (32-bit) integers; in VB or VBA these are Long datatypes.
The Entity ID is a reference to the database table that contains the MSLINK column.
The name of the table is found in the [mscatalog] table. Here's an SQL statement that
reveals a table name given its Entity ID …
SELECT tableName FROM mscatalog WHERE entityNum=20;
The value 20 is an example: it may not exist in your [mscatalog] table.
Examine the data in [mscatalog] and substitute an alternative.
You can list all the catalogy rows like this …
SELECT * FROM mscatalog ORDER BY tableName;
Suppose you have a table in your database named [myTable].
To link with a MicroStation element, there are two conditions …
-
[myTable]must appear in the[mscatalog]table -
[myTable]must have a column[mslink]
The entry in [mscatalog] defines your table's entity ID.
For example …
| Column | [tablename] | [entityid] |
| Data | myTable | 20 |
Your graphic element database linkage must have the entity ID
of 20 to link with your [myTable] table. The element's MSLINK
value determines the row in [myTable] that holds data about
that element.
Q How do I link an object to multiple tables?
A
An element may have multiple database linkages. That is,
there may be one or more [mslink]|[entity id] pairs of
information attached to an element from more than one table.
|
Each linkage will refer to a different table. For example, if
you have tables [myTable1] and [myTable2], then [mscatalog] might have
these entries …
| Column | [tablename] | [entityid] |
| Data | myTable1 | 20 |
| Data | myTable2 | 21 |
If your element is linked to both tables, the database linkage attached to the element could be …
| MSLINK | Entity ID |
|---|---|
1234 | 20 |
4567 | 21 |
The tables could have rows like this …
| MSLINK | Col2 | Col3 |
|---|---|---|
| … | ||
1234 | Data 1234 | MoreData 1234 |
| … |
| MSLINK | Col2 | Col3 |
|---|---|---|
| … | ||
4567 | Value 4567 | Another 4567 |
| … |
Q How do I use Visual Basic (VB) to communicate with MicroStation and a database?
Q How do I communicate with a database using MicroStation VBA?
A
MicroStation V8 includes Visual Basic for Applications (MVBA).
MVBA includes functions for reading and creating database linkages
on graphic elements. MVBA functions can be used from VB by
creating a reference to the MicroStationDGN.Application object, then
calling the methods on that object.
MVBA does not, however, provide a mechanism to communicate with a database. Instead, you can use technology such as Microsoft's ActiveX Data Objects (ADO, also known as Microsoft Data Access Components) to connect to a database and exchange data. You can download the Microsoft Data Access Components libraries and SDK here …
The VBA project in this ZIP Archive demonstrates how Visual Basic can interrogate the linkage between MicroStation V8 and the delivered Access database mentioned above.
Note: VB.NET developers should use ADO.NET to communicate with a database.
Q Can I store my data (in my case, object name) without using an external database?
A Yes, through one of two technologies that are part of MicroStation …
Tag Elements
FlexiTable™ uses tags as a data source to create a schedule table that is displayed in MicroStation. However, it's a little more versatile than just a tag editor, because those data can be derived from many different data sources. FlexiTable also exports data in a number of ways.
Tag Elements are available through MicroStation's Tags toolbox. They are graphic objects that may be manipulated and printed like any other element. What's different is that there are built-in tools to query and report on tag data.
Tags Elements contain your data that are associated with
a host element. They are part of the DGN file and require no
external database or application. MicroStation's tag functionality includes
a reporting mechanism. You can save the data from tagged elements
to a CSV or XML file.
MicroStation lets you define a named Tag Set that contains a number of Tag definitions. This is analogous to defining the columns of a table in a database schema.
Some applications created by LA Solutions use Tag Elements to store data. For example, the freeware application AreaAnnotator™ records room areas in tags. Its strength is that it automatically updates its area tag value as you edit an area boundary.
Using FlexiTable™ in conjunction with AreaAnnotator lets you gather reports of annotated areas. FlexiTable can save a report in several formats, including HTML and Microsoft Excel®.
XML Fragments
XML Fragments are implemented with technology introduced publicly with MicroStation V8.1. An XML Fragment contains data embedded in an XML element. The XML element and its contained data are attached to a MicroStation graphic element as a data linkage.
Currently there are no user tools available for XML Fragments. The first Bentley Systems application to use XML Fragments is MicroStation GeoGraphics 2004 Edition, and subsequently Bentley Map. Bentley Map and MicroStation GeoGraphics provide GIS analysis, labelling, and reporting using XFM technology.
There is an XML Fragment API for MDL but not for MicroStation VBA. The MDL API provides full access not only to XML Fragments, but also to stand-alone XML data that is part of the DGN file but not associated with any particular graphic element.
Contact LA Solutions using this 