• 01276 855 847 Nationwide (UK)
  • info@bmscontrols.co.uk Email Us
  • Unit C1D, Fairoaks Airport Surrey, GU24 8HX

Data Schema 

Data Schema 

Accurate data schema definition is important for building management systems because it can control how the system is used and interacted with, as well as improve organization and data management.

There are three main types of data schema:

1. star schema

2. snowflake schema

3. dimensional modeling

4. physical data model

5. object-oriented Modeling

A star schema is the simplest type of data schema and is used to map out hierarchical relationships between data points. In a star schema, each data point is represented by a single table, and relationship lines are drawn between tables to indicate the connection between them. Star schemas are easy to understand and use, but they can be difficult to maintain if the underlying data structure changes frequently.

A snowflake schema is a more complex type of data schema that uses a series of linked tables to represent relationships between data points. In a snowflake schema, each data point is represented by one or more tables, and relationship lines are drawn between these tables to indicate the connection between them. Snowflake schemas can be more difficult to understand and use than star schemas, but they offer more flexibility in terms of representing complex relationships between data points.

Dimensional modeling is a type of data schema that is used to represent multidimensional relationships between data points. In dimensional modeling, each data point is represented by one or more dimensions, and relationship lines are drawn between these dimensions to indicate the connection