Cart (Loading....) | Create Account
Close category search window

DBMS support for nonmetric measurement systems

Sign In

Cookies must be enabled to login.After enabling cookies , please use refresh or reload or ctrl+f5 on the browser for the login options.

Formats Non-Member Member
$31 $13
Learn how you can qualify for the best price for this item!
Become an IEEE Member or Subscribe to
IEEE Xplore for exclusive pricing!
close button

puzzle piece

IEEE membership options for an individual and IEEE Xplore subscriptions for an organization offer the most affordable access to essential journal articles, conference papers, standards, eBooks, and eLearning courses.

Learn more about:

IEEE membership

IEEE Xplore subscriptions

1 Author(s)
Lorentzos, N.A. ; Inf. Lab., Argic. Univ. of Athens, Greece

In commercial DBMSs, it is possible to model only primitive numeric data types and perform arithmetic between them. In practice, however, organizations need to store and manipulate more complex numeric elements that could be interpreted as representing quantities of a non-numeric measurement system like that in which a distance is expressed in feet and inches, or like that in which a weight is expressed in quarters, stones, pounds, and ounces. This implies that users have to choose between two options, either to abandon the nonmetric system and completely adapt their applications to the limited capabilities of the DBMS, or to write their own pieces of code for the management of such more complex numeric data types. The first approach is principally unacceptable, and at the same time, there is a loss in the precision of arithmetic operations, because quantities have to be expressed as real numbers. The second one is tedious, because distinct pieces of code have to be written for handling different nonmetric units. Furthermore, integrity checking for these pieces of data has to be performed by application programs rather than by the DBMS. To overcome these problems, a new generic data type is proposed, the composite number, whose support automatically enables the use of any nonmetric measurement system. Functions and operations are defined for the management of composites. Because, in practice, time is usually expressed in many distinct nonmetric measurement units whose choice depends on the particular application, temporal databases represent one of the many application areas of the proposed formalization

Published in:

Knowledge and Data Engineering, IEEE Transactions on  (Volume:6 ,  Issue: 6 )

Date of Publication:

Dec 1994

Need Help?

IEEE Advancing Technology for Humanity About IEEE Xplore | Contact | Help | Terms of Use | Nondiscrimination Policy | Site Map | Privacy & Opting Out of Cookies

A not-for-profit organization, IEEE is the world's largest professional association for the advancement of technology.
© Copyright 2014 IEEE - All rights reserved. Use of this web site signifies your agreement to the terms and conditions.