Physical data model

Physical data model

A physical data model (a.k.a. database design) is a representation of a data design which takes into account the facilities and constraints of a given database management system. In the lifecycle of a project it is typically derived from a logical data model, though it may be reverse-engineered from a given database implementation. A complete physical data model will include all the database artifacts required to create relationships between tables or achieve performance goals, such as indexes, constraint definitions, linking tables, partitioned tables or clusters. The physical data model can usually be used to calculate storage estimates and may include specific storage allocation details for a given database system.

At present, there are four (possibly five) main databases in the business market; Oracle, SQL Server, Sybase, DB2 and MySQL. There are a great many other RDBMS systems out there, but these tend either to be legacy databases or used within academia such as universities or further education colleges. A physical data model on each implementation would be significantly different, not least due to the underlying OS requirements that sit underneath them. Examples would be SQL Server which only run on Microsoft Windows operating systems, while Oracle and MySQL can run on Solaris, Linux and other UNIX-based operating systems.

This means that the disk requirements, security requirements and many other aspects of a physical data model will be influenced entirely by the RDBMS that a database administrator (or his organization) chooses to use.

Whilst there is increasingly debate surrounding which RDBMS is better within various domains, it is generally accepted that Oracle's architecture is best suited to enterprise & larger implementations, SQL Server better for SME's and MySQL adequate for SME's and small businesses. A useful resource for such debate (which contains useful case studies) can be found at the IT QUEST [IT QUEST] web site.

References

[http://www.it-quest.bz/itq/rdbms/rdbms-review.asp] http://www.it-quest.bz/itq/rdbms/rdbms-review.asp


Wikimedia Foundation. 2010.

Игры ⚽ Нужно решить контрольную?

Look at other dictionaries:

  • Data model — Overview of data modeling context: A data model provides the details of information to be stored, and is of primary use when the final product is the generation of computer software code for an application or the preparation of a functional… …   Wikipedia

  • Logical data model — A logical data model also referred to as LDM in computer science is a representation of an organization s data, organized in terms of a particular data management technology. When ANSI first laid out the idea of a logical schema (in 1975 [1] ),… …   Wikipedia

  • Data model (GIS) — A data model in geographic information systems is a mathematical construct for representing geographic objects or surfaces as data. For example, the vector data model represents geography as collections of points, lines, and polygons; the raster… …   Wikipedia

  • Core Architecture Data Model — Example of a CADM Diagram for Overview and Summary Information (AV 1) of the DoDAF.[1] Core Architecture Data Model (CADM) in Enterprise Architecture is a logical data model of information used to describe and build architectures …   Wikipedia

  • Semantic data model — A semantic data model in software engineering is a data modeling technique to define the meaning of data within the context of its interrelationships with other data. A semantic data model is an abstraction which defines how the stored symbols… …   Wikipedia

  • Data architecture — in enterprise architecture is the design of data for use in defining the target state and the subsequent planning needed to achieve the target state. It is usually one of several architecture domains that form the pillars of an enterprise… …   Wikipedia

  • Physical design — can refer to*Physical database design see also Physical data model *Physical design (electronics) …   Wikipedia

  • Data modeling — The data modeling process. The figure illustrates the way data models are developed and used today. A conceptual data model is developed based on the data requirements for the application that is being developed, perhaps in the context of an… …   Wikipedia

  • Data Format Description Language — (DFDL, often pronounced daff o dil) is a modeling language from the Open Grid Forum for describing general text and binary data. A DFDL model or schema allows any text or binary data to be read (or parsed ) from its native format and to be… …   Wikipedia

  • Data flow diagram — example.[1] A data flow diagram (DFD) is a graphical representation of the flow of data through an information system, modelling its process aspects. Often they are a preliminary step used to create an overview of the system which can later be… …   Wikipedia

Share the article and excerpts

Direct link
… Do a right-click on the link above
and select “Copy Link”