A Forest or a Bunch of Trees?

Schraml, Todd
February 2007
Database Trends & Applications;Feb2007, Vol. 21 Issue 2, p26
The article discusses the design and construction of a relational table. Relational table within the context of a database contains columns and data items that represent an entity. An entity must be defined because data items can have valid values only when the entity is in a certain state. Sub-typing the data so that data points within any given sub-types are always populated is another option. Data items can also be placed on a single super -type entity. However, this approach will require attribute names and definitions that can lead to bad data usage practices. The author concludes that a designer can make choices about creating additional structures after he really understood the intended meaning or scope of a table.


Related Articles

  • Performance and Design are Independent. Schraml, Todd // Database Trends & Applications;Dec2005, Vol. 19 Issue 12, p26 

    The article focuses on the database design and database management (DBMS) performance. The normalized database design supporting an enterprise is devoid of physical performance considerations which flows form an exploration of an organization's requirements. In normalizing the organization's...

  • Application Profile Development for Consortial Digital Libraries. Hicks, Emily A.; Perkins, Jody; Maurer, Margaret Beecher // Library Resources & Technical Services;Apr2007, Vol. 51 Issue 2, p116 

    In 2002, OhioLINK's consortia of libraries recognized the need to restructure and standardize the metadata used in the OhioLINK Digital Media Center as a step in the development of a general purpose digital object repository. The authors explore the concept of digital object repositories and...

  • Cluster File Systems Can Ease the Transition to Linux. Crusing, Frank // Database Trends & Applications;Jul2003, Vol. 17 Issue 7, p27 

    This article explains how cluster file systems (CFS) software can ease the management of Linux databases. Database software consists of two components: files used to run the database and files associated with storing and managing data. A CFS supports these components to drive down the costs...

  • It is Impolite to Point. Schraml, Todd // Database Trends & Applications;Feb2006, Vol. 20 Issue 2, p26 

    The article discusses on the importance of data pointers referencing when accessing database content. Pointers facilitate indexing in the physical layer, thereby enhancing data access. In the database paradigms, a pointer provides access to some specific initial parent record, and referencing a...

  • Modified Streaming Format for Direct Access Triangular Data Structures. Abid, Khaled; Mebarki, Abdelkrim; Hidouci, Wahid // International Journal of Image, Graphics & Signal Processing;Jan2014, Vol. 6 Issue 2, p14 

    We define in this paper an extended solution to improve an Out-of-Core data structure which is the streaming format, by adding new information allowing to reduce file access cost, reducing the neighborhood access delay to constant time. The original streaming format is conceived to manipulate...

  • Data Flow and Data Structure Modeling for Database Requirements Determination: A Comparative Study. Mantha, Robert W. // MIS Quarterly;Dec1987, Vol. 11 Issue 4, p531 

    This study investigated, in an experimental setting, the existence, nature and causes of the differences in the completeness of logical data specifications generated by professional systems analysts having training and experience in the use of one of two modeling approaches. The approach used...

  • On the Interdependencies between Record Structure and Access Path Design. March, Salvatore T.; Carlis, John V. // Journal of Management Information Systems;Fall1987, Vol. 4 Issue 2, p45 

    The physical organization of data within a database has two major components: record structures and access paths. Record structures specify the grouping of data items into data records that are physically stored and accessed together. Access paths specify the algorithms and system data used to...

  • Adapter Description File.  // Network Dictionary;2007, p22 

    A definition of the term "adapter description file" is presented. It refers to a type of data format with an extension .adf.

  • A 3D revolution in communicating science. Murienne, Jérôme; Ziegler, Alexander; Ruthensteiner, Bernhard // Nature;5/22/2008, Vol. 453 Issue 7194, p450 

    The article offers information on the usefulness of the three-dimensional (3D) models as embedded in the portable document format (PDF) of Adobe Systems. It highlights the effectiveness of the 3D models in PDF by boosting information content and the transparency of data in scientific and...


Read the Article


Sorry, but this item is not currently available from your library.

Try another library?
Sign out of this library

Other Topics