Welcome to WebmasterWorld Guest from 23.20.6.20

Forum Moderators: open

Message Too Old, No Replies

Schema?

     

bconnor

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

Inactive Member
Account Expired

 
 



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?

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

Junior Member

10+ Year Member

joined:Dec 28, 2003
posts:58
votes: 0


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

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 13, 2002
posts:2162
votes: 0


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.

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members