Contents
What are some of the characteristics of a bad database design?
So, the list:
- Poor design/planning.
- Ignoring normalization.
- Poor naming standards.
- Lack of documentation.
- One table to hold all domain values.
- Using identity/guid columns as your only key.
- Not using SQL facilities to protect data integrity.
- Not using stored procedures to access data.
What are database concepts?
A database intends to have a collection of data stored together to serve multiple applications as possible. Hence a database is often conceived of as a repository of information needed for running certain functions in a corporation or organization.
What do you call an instance of a database dimension?
Cubes contain all the dimensions on which users base their analyses of fact data. An instance of a database dimension in a cube is called a cube dimension and relates to one or more measure groups in the cube. A database dimension can be used multiple times in a cube.
Are there Degenerate dimensions in a fact table?
Generally, all numeric quantities and measures are columns in the fact table (s). Then everything else is a dimensional attribute. Which dimension they belong in is rather pragmatic and depends on the data. In addition to the suggestions you have already received, I saw no mention of degenerate dimensions.
Which is the default column in dimension table?
A fully consistent set of default columns aids metadata driven ETL tool generate code that loads dimensions. For special columns, use the following prefixes: Entity key.
How to create different names for dimension tables?
To serve the expert users, create an alternative, short name for the table by declaring a database synonym or view. If you do this, maintain a list of abbreviated names When the same dimension can play multiple roles, it is convenient for users to have different names depending on the role.