Table (OLAP)

[Table of Contents](https://github.com/dell-oss/Doradus/wiki/OLAP Databases: Table-of-Contents) | Previous | Next
OLAP Data Model: Table

---

A table is a named set of objects. Table names are identifiers and must be unique within the same application. Example table names are: `Message`, `LogSnapshot`, and `Security_4xx_Events`.

A table can include the following components:

• Options: Depending on the storage manager, some table-level options may be supported.
• Fields: Definitions of scalar, link, and group fields that the table uses.
• Aliases: Alias definitions, which are schema-defined expressions that can then be used in queries.

The general structure of a table definition in XML is shown below:

<tables>
	<table name="Message">
	<fields>
		// fields
	</fields>
	<aliases>
		// aliases
	</aliases>
	</table>
	...
</tables>

In same structure in JSON is shown below:

"tables": {
	"Message": {
		"fields": {
			// fields
		},
		"aliases": {
			// aliases
		}
	},
...
}