A single computer, group of computers, or mechanism for handling some communication traffic through a particular point on a computer network.
Data that is static or that does not change. In transaction processing systems the data is updated on a continual regular basis. In a data warehouse the database is added to or appended, but the existing data seldom changes.
The process of eliminating duplicate information in a database by creating a separate table that stores the redundant information. For example, it would be highly inefficient to re-enter the address of an insurance company with every claim. Instead, the database uses a key field to link the claims table to the address table. Operational or transaction processing systems are typically “normalized”. On the other hand, some data warehouses find it advantageous to de-normalize the data allowing for some degree of redundancy.