Re: Database schema for univesal usage

From: Paul <paul_at_test.com>
Date: Mon, 09 May 2005 14:08:10 +0100
Message-ID: <427f60bb$0$39071$ed2e19e4@ptn-nntp-reader04.plus.net>

Chris wrote:
> Does anyone know about a intentions to build a general database schema
> (based on ER) that can be used for different purposes without changing
> the physical layer (tables, views)?

Well tables and views, in relational database terminology, are actually in the logical layer, not the physical.

A database management system (DBMS) *is* a general schema that can be used for different purposes without changing the physical layer. You talk to the DBMS at a logical level, and it translates your commands to the physical level, which is hidden from you.

Paul. Received on Mon May 09 2005 - 08:08:10 CDT