Welcome to WebmasterWorld Guest from 23.22.250.113

Forum Moderators: open

Message Too Old, No Replies

Schema?

     

bconnor

10:15 am on Mar 19, 2006 (gmt 0)




I cant seem to think at the moment, What is a schema? Its basically the structure of a database, right?

And how do you show your schema for a database? Simply list the breakdown of relations, attributes, etc?

BuckerBucker

4:33 am on Mar 20, 2006 (gmt 0)

10+ Year Member



An XML Schema is a XML language for describing
and constraining the content of XML documents.

In very simple words, XML is code written by you, and defined by you. In order to validate and process that code, a schema is written to support it.

I assume that a schema is a schema is a schema...which probably means that a database schema describes and constrains the content of a database...never heard of it before, but seems to make sense.

Bucker

aspdaddy

11:26 am on Mar 20, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Yes a database schema describes the structure (including constraints & domains) of a database.

XML and Data definition Language or DDL(SQL Create,Add,Alter etc) are two common languages for documenting schemas, but can also use an entity relationship diagram or a data dictionary - typically a very large and hard to maintain spreadsheet :)

DDL has one huge benefit over the other methods - when you execute it, it creates the structure for you. But its not very good for communicating the schema to other (non-technical) stakeholders.

 

Featured Threads

Hot Threads This Week

Hot Threads This Month