database schema


Also found in: Dictionary, Thesaurus, Medical, Wikipedia.

database schema

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.)
References in periodicals archive ?
Automated mainframe intelligence (AMI), which is policy driven, enforces database schema best practices.
AIR's software platforms were the first to be certified by ACORD for the implementation of the ACORD property exposure standards, and today, AIR's exposure database schema is open and fully accessible to the public online.
The applicability of the ontological model of conceptual objects and the method for identifying semantic conflicts and the inconsistency of the integrable data were experimentally evaluated of the using 861 conceptual database schemas that represent 368 possible cases of conflicts: attribute-attribute, attribute-entity, entity-relationship, dependency, behavior, inheritance, key, data types, acceptable values, permitted values, and the relevance of values.
Keywords: SQLite, Recovery, Database Schema, Internet of Things, Digital forensics.
In addition, these DSLs all use the underlying database schema as the reference model, so there is no need for a complex concept mapping.
Procedures for extraction and processing of data from heterogeneous sources, database schema and data warehouse will be refined and implemented.
Pyrrho's response to the Java Enterprise Edition was to implement the Java Persistence API inside Pyrrho, and this exploration was very interesting, as it highlighted the way that the data model emerged as declarations in applications rather than being intrinsic to the database schema. This aspect is also a feature of Microsoft's entity framework and language-integrated query (LINQ).
Furthermore, it was not possible to import/export the domain-dependent information used to enhance the virtual object to or from a relational database because the underlying relational database schema was not explicitly codified in the virtual object model.
Documentation of the design using appropriate methods (e.g., database schema, UML diagrams).
The meet and confer may include a 'quick peek' at the database schema to establish relevant elements.
Exploring systems based around Oracle brand technologies, the work covers topics such as identifying levels of effort and cost, database schema and data migration, Oracle database cloud planning and implementation, Sybase migrations, application migrations, and PowerBuilder to Oracle APEX migrations.