Tables

Tables in Granta MI are used to organize and group the data in a database by common characteristics or properties, for example, a Materials table containing records that represent materials and their properties, a Tensile Test Data table with records that capture test data about those materials.

The Table schema defines which data may go into the Table and which data may not, and how users can interact with the data.

• The Attributes in each table are typically specialized for the type of data and metadata in that table, so a Metals table may include Attributes like Density, Composition, and Young's Modulus, while a Test data table could include these and additional Attributes for Test Type, Specimen ID, and Tensile Response.
• Subsets and Layouts are used to present different views of the data in the Table to application users, allowing them to better focus on only the relevant data when browsing and searching.
• Search Templates provide pre-defined search queries that can be used to search the Table in MI Viewer.
• Report Templates provide pre-defined Comparison Table and XY Chart templates for viewing data in the Table in MI Viewer.
• Excel Template Definitions can be used in MI Viewer to import data to or export data from the Table.
• Expressions are used to define mathematical expressions for use in Equations and Logic Attributes.

Table properties provide additional options for controlling the visibility and searchability of data in the table, assigning a Quality Ratings System to a table, defining datasheet headers/footers, and enabling Record Version Control on the table.