The definition of a database. It defines the structure and content in each data element within the structure. Schemas are often designed with visual modeling tools that automatically create the SQL code necessary to define the table structures. See subschema and XML schema.
A Database Schema
In this order processing example, the tables for customers and orders are drawn graphically, and the Erwin modeling program turns the graph into the appropriate SQL code for the target database. (Example courtesy of Logic Works, Inc.)
A Database Schema
In this order processing example, the tables for customers and orders are drawn graphically, and the Erwin modeling program turns the graph into the appropriate SQL code for the target database. (Example courtesy of Logic Works, Inc.)
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- SQLWriter 2.3.0 (Windows)
- SQLWriter is a powerful SQL script editor for all database developers and database administrators. It can edit different database SQL scripts in the same window and support Windows 98, Windows NT 4.0, Windows 2000, Windows ME, Windows XP and Window2003. In addition, it also edits or runs SQL queries and...
- Software downloads 2009-11-23
- MySQL Workbench OSS 5.2.8b1 (Mac)
- MySQL Workbench enables a DBA, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases. It includes everything a data modeler needs for creating complex ER models, and also delivers key features for performing difficult change management and documentation...
- Software downloads 2009-11-18
- Altova MissionKit for Enterprise Software Architects 2010 (Windows)
- The Altova MissionKit 2010 for Enterprise Software Architects is an integrated suite of XML, database, and UML tools from the developers of XMLSpy. It delivers eight tools for less than the price of two! The Altova MissionKit for Enterprise Software Architects includes Enterprise Editions of Altova XMLSpy, MapForce, StyleVision, UModel,...
- Software downloads 2009-11-17
- Altova DiffDog Enterprise Edition 2010 (Windows)
- Altova DiffDog 2010 Enterprise Edition is the powerful differencing tool for files, folders, and databases. This easy-to-use synchronization tool quickly compares and merges text or source code files, directories, databases, and XML Schemas via its intuitive visual interface. DiffDog provides advanced XML-aware differencing and editing capabilities based on those in...
- Software downloads 2009-11-17
- Altova StyleVision Professional Edition 2010 (Windows)
- Altova StyleVision 2010 Professional Edition is a powerful visual XSLT stylesheet designer for graphically designing templates that render eye-catching HTML and RTF output from XML or database data and create intuitive Authentic electronic forms. StyleVision is fully standards-compliant and supports XSLT 1.0, XSLT 2.0, CSS, JavaScript, and all major databases....
- Software downloads 2009-11-17
- DbSchema 5.3 build 1390 (Windows)
- DbSchema is a complete solution for databases. Our target is to bring both database schema and data in a single unified workflow. This provides an efficient and productive environment to work in, with improved awareness of application schema architecture and easy access to application data. Support for offline work and...
- Software downloads 2009-11-16
- SQLite Compare 2.3.851.16 (Windows)
- SQLite Compare compares the schema of two SQLite database files and quickly locates the differences in tables, triggers, views or any other object in the database. SQLite Compare user interface mirrors familiar text oriented diff/merge utilities like WinMerge or Beyond Compare. It features schema diff/merge view similar to WinMerge and...
- Software downloads 2009-11-16
- Altova XMLSpy Enterprise Edition 2010 (Windows)
- Altova XMLSpy 2010 Enterprise Edition is the industry's best-selling XML editor and XML development environment for modeling, editing, transforming, and debugging XML technologies. In addition to the world's leading XML editor, XMLSpy includes a powerful graphical XML Schema editor that allows you to design complex schemas with ease. Advanced error...
- Software downloads 2009-11-16
- Altova XMLSpy Professional Edition 2010 (Windows)
- Altova XMLSpy 2010 Professional Edition is the industry-leading XML editor and XML development environment, with intuitive editing views and powerful XML utilities to model, edit, transform, and debug XML-related technologies quickly and easily. In addition to the world's most popular XML editor, XMLSpy Professional includes a graphical XML Schema editor...
- Software downloads 2009-11-16
- Altova StyleVision Enterprise Edition 2010 (Windows)
- Altova StyleVision 2010 Enterprise Edition is a powerful visual stylesheet designer for transforming XML, XBRL, and database data into HTML, RTF, PDF, and OOXML/Word 2007 output, and creating e-Forms. It is standards-compliant and supports XSLT 1.0, XSLT 2.0, XSL:FO, CSS, JavaScript, and all major databases. StyleVision is optimized for single...
- Software downloads 2009-11-16
- dbForge Schema Compare for SQL Server 1.50 (Windows)
- dbForge Schema Compare for SQL Server is a reliable, easy-to-use tool to compare and synchronize structures of Microsoft SQL Server databases. This product is specially designed to help you quickly analyze database structure differences at a glance and propagate the changes to a required SQL Server escaping tedious manual work....
- Software downloads 2009-11-12
- Qilan 3.2 (Mac)
- Qilan is a database and web application graphic user environment. It allows developers to work with database data and schema and to create dynamic Web applications linking one or several SQL database engines. A knowledge of SQL or code level programming is not required.In addition to SQL engines (Apache Derby,...
- Software downloads 2009-11-12
- DTM Schema Reporter 1.17.17 (Windows)
- DTM Schema Reporter is a reporting tool for database schema. The program creates reports in RTF, HTML or plain text formats and supports all common database interfaces - ODBC, IDAPI, or even Oracle Call Interface. This utility helps technical writers and database administrators create a report of any complexity level...
- Software downloads 2009-11-10
- dbscript 0.99 (Windows)
- dbscript operates on database schema information imported from an MS SQL Server, Oracle or PostgreSQL database, or uploaded via SQL files containing Create statements, organizing the schema information in Project Versions. Based on this data, users can define Value Scripts, compare schemas, and generate schema documentation as MediaWiki and ScrewTurn...
- Software downloads 2009-11-05
- MyDbExplorer Framework 1.0 (Windows)
- MyDbExplorer Framework allows opening of multiple connections for any plug-in. Connections using multiple plug-ins can be opened simultaneously. All the open connections can be saved to a file. Next time, when you start the Framework, you can open all your connections using that file. Thus, you need not enter/remember all...
- Software downloads 2009-11-01
- Flipper for iPhone 1.4 (Mobile)
- Flipper for iPhone is a MySQL client designed from the ground up for iPhone use. The features include write complex SQL queries and submit them over the network to MySQL databases, SQL-iPad makes writing queries a snap, retrieve and save the entire database schema, once written, store queries to run...
- Software downloads 2009-10-23
- SQL Server Surveyor 1.2.5.11 (Windows)
- SQL Server Surveyor is a tool which allows database administrators to easily create reports of their SQL Servers for the purposes of documentation, auditing, comparison with other servers, etc. Report Features: Version of SQL Server and operating system; Licensing; Collation; Uptime; Network configuration; Disk information; SQL Server statistics; Linked servers;...
- Software downloads 2009-10-23
- Looking beyond Windows 7 and Office; Pondering the alternatives
- No reason to look beyond Microsoft Windows 7 and Microsoft Office, its a complete solution out of the box for every business need. Pondering the alternatives will take all of 5 seconds before realizing the alternatives won't live up to what Microsoft has to offer.Preceding message brought to you...
- Discussion threads 2009-10-20
- SqlDbx 3.40 (Windows)
- Easy to use powerful Database IDE / SQL editor / SQL query tool for database and application developers. Syntax highlighting, Intellisense, Auto complete, Block select mode, Speed Typing, Schema Scripting, Schema Browser, Visual Diff, direct data edit. Supports Oracle, Sybase ASE / IQ / Anywhere, IBM DB2 / UDB /...
- Software downloads 2009-10-18
- SQL Examiner 2009 R2 3.2.0.22 (Windows)
- SQL Examiner 2009 is an easy-to-use tool that quickly and accurately compares and synchronizes schemas of MS SQL Server databases. It supports all the main innovations of SQL Server 2008, so now you can compare and synchronize databases of all SQL Server versions from 7.0 to 2008. The tool provides...
- Software downloads 2009-10-17
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- The best support in the Linux business
-
If Linux is going to power your mission-critical applications, you'd better have the best support known to business. Novell was rated the top provider of Linux technical support.
- Learn more >>
- Reduce risk. Reduce complexity. Increase reliability.
-
A simplified IT environment isn't just less complex. It's also more reliable. Standardize on a single Linux platform with SUSE Linux Enterprise from Novell, and get the world's most interoperable Linux
- Learn more >>
- Learn more about tools to grow your business
-
The Business Essentials Guide provides you useful tools and templates to help grow your business and save you time with automated shipping solutions.
- Save time with the UPS Business Essentials Guide
- Microsoft Dynamics CRM Online - Free Six-Month Trial for Eligible Organizations
-
Microsoft Dynamics CRM Online provides fast online access, simple contact management and better sales performance for a low monthly cost - the best value on the market today.
- Learn more about the free, six-month trial offer>>
-
-
Smart Tech
Expert advice on innovations in healthcare and the green technologies that make it happen.
Find out more
-
Smart Business
Discussion and advice on management issues that revolve around making your world smarter and more useful.
More Smart Advice
-
Smart People
The best and worst moves in the management and strategy trenches.
Learn More
