homepage Welcome to WebmasterWorld Guest from 54.204.141.129
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Schema?
bconnor




msg:1578657
 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




msg:1578658
 4:33 am on Mar 20, 2006 (gmt 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

aspdaddy




msg:1578659
 11:26 am on Mar 20, 2006 (gmt 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved