Numerical operations on a relational database

Author

Ghosh, Sakti P.

Author_Institution

IBM Almaden Res. Center, San Jose, CA, USA

Volume

15

Issue

5

fYear

1989

fDate

5/1/1989 12:00:00 AM

Firstpage

600

Lastpage

610

Abstract

The problem is discussed of defining numerical operations on a relational database to accommodate the statistical analyses associated with a bivariate frequency table. An attempt has been made to extend Codd´s relational algebra to include simple bivariate statistical operations preserving the closure of Codd´s algebra. This extended algebra is applied to bivariate relational data structures needed for real-time automatic statistical quality control of a manufacturing process. Also discussed are some new category-numeric operations on relational tables

Keywords

database theory; relational databases; statistical analysis; Codd; bivariate frequency table; bivariate relational data structures; bivariate statistical operations; category-numeric operations; manufacturing process; numerical operations; real-time automatic statistical quality control; relational algebra; relational database; relational tables; statistical analyses; Algebra; Data structures; Database languages; Frequency; Geometry; Helium; Quality control; Relational databases; Set theory; Statistical analysis;

fLanguage

English

Journal_Title

Software Engineering, IEEE Transactions on

Publisher

ieee

ISSN

0098-5589

Type

jour

DOI

10.1109/32.24709

Filename

24709