
This Article  
 
Share  
Bibliographic References  
Add to:  
Digg Furl Spurl Blink Simpy Del.icio.us Y!MyWeb  
Search  
 
ASCII Text  x  
S.P. Ghosh, "Numerical Operations on a Relational Database," IEEE Transactions on Software Engineering, vol. 15, no. 5, pp. 600610, May, 1989.  
BibTex  x  
@article{ 10.1109/32.24709, author = {S.P. Ghosh}, title = {Numerical Operations on a Relational Database}, journal ={IEEE Transactions on Software Engineering}, volume = {15}, number = {5}, issn = {00985589}, year = {1989}, pages = {600610}, doi = {http://doi.ieeecomputersociety.org/10.1109/32.24709}, publisher = {IEEE Computer Society}, address = {Los Alamitos, CA, USA}, }  
RefWorks Procite/RefMan/Endnote  x  
TY  JOUR JO  IEEE Transactions on Software Engineering TI  Numerical Operations on a Relational Database IS  5 SN  00985589 SP600 EP610 EPD  600610 A1  S.P. Ghosh, PY  1989 KW  Codd; relational database; numerical operations; statistical analyses; bivariate frequency table; relational algebra; bivariate statistical operations; bivariate relational data structures; realtime automatic statistical quality control; manufacturing process; categorynumeric operations; relational tables; database theory; relational databases; statistical analysis VL  15 JA  IEEE Transactions on Software Engineering ER   
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 realtime automatic statistical quality control of a manufacturing process. Also discussed are some new categorynumeric operations on relational tables.
[1] R. Agrawal, "Alpha: An Extension of Relational Algebra to Express a Class of Recursive Queries,"Proc. Third Int'l Conf. Data Eng., CS Press, Los Alamitos, Calif., Order No. FN762, 1987, pp. 580590.
[2] E. F. Codd, "A relational model of data for large shared data banks,"Commun. ACM, pp. 377387, June 1970.
[3] E. Fortunato, M. Rafanelli, F. L. Ricci, and A. Sebastio, "An algebra for statistical data," inProc. Third Int. Workshop Stat. Sci. Database Management, Luxembourg, July 2224, 1986, pp. 122134.
[4] S.P. Ghosh, "An application of statistical databases in manufacturing testing," inProc. COMPDEC, vol. 1, 1984, pp. 96103.
[5] S.P. Ghosh, "Statistical Relational Tables for Statistical Database Management,"IEEE Trans. on Software Eng., Vol. SE12, No. 12, Dec. 1986, pp. 1,106 1.116.
[6] S. P. Ghosh, "Statistics Metadata: Linear Regression Analysis," inFoundations of Data Organization. New York: Plenum, 1987, pp. 317; also, IBM Res. Rep. No. RJ 4444, 1984.
[7] S.P. Ghosh, "Statistical data reduction for manufacturing testing," inProc. IEEE Int. Conf. Data Eng., Los Angeles, CA, 1985, pp. 5866.
[8] S. P. Ghosh, "SIAM: Statistical information access method," IBM Res. Rep. No. 4865, 1985: also, inThird Int. Workshop Stat. Sci. Database Management, Luxembourg, July 2224, 1986.
[9] S. P. Ghosh,Data Base Organization Jor Data Management, 2nd ed. New York: Academic, 1986.
[10] R. Hammond and J. L. McCarthy, Eds.,Proc. Second Int. Workshop Stat. Database Management, Los Altos, CA, Sept. 2729, 1983.
[11] A. Klug, "Equivalence of Relational Algebra and Relational Calculus Query Languages Having Aggregate Functions,"J. ACM, Vol. 29, No. 3, July 1982, pp. 699717.
[12] P. Kreps, "A semantic core model for statistical and scientific data bases," inLBL Perspective on Statistical Database Management, H. K. T. Wong, Ed. Berkeley, CA: Lawrence Berkeley Laboratory, Univ. California, 1982, pp. 129157.
[13] M. G. Kendall and A. Stuart,The Advanced Theory of Statistics, Vol. 1. London UK: Charles Griffin, ch. 16.
[14] M. G. Kendall and A. Stuart,The Advanced Theory of Statistics, Vol. 2. New York: Hafner, 1961, ch. 1720.
[15] A. Shoshani, "Statistical databases: Characteristics, problems, and some solutions," inProc. 8th Int. Conf. Very Large Data Bases, Mexico City, Mexico, 1982, pp. 208222.
[16] S. S. Y. W. Su, "SAM*: A semantic association model for corporate and scientificstatistical databases,"J. Inform. Sci., vol. 29, pp. 151 199, 1983.
[17] SQL/Data System Application Programming, IBM Program Prod. SH2450180, 1983.
[18] M. Stonebraker, Ed.Ingres Papers. Reading, MA: AddisonWesley, 1986.
[19] H. K. T. Wong, Ed.LBL Perspective on Statistical Database Management. Lawrence Berkeley Laboratory, Univ. California, 1982.
[20] H. K. T. Wong, Ed.Proc. First LBL Workshop Stat. Database Management, Menlo Park, CA, 1982.
[21] J. D. Gibbons,Nonparametric Statistical Inference, 2nd ed. New York: Marcel Dekker, 1985.
[22] M. M. Zloof, "Query by examples," inProc. AFIPS NCC, vol. 44, 1975, pp. 431438.
[23] SAS User's Guide: Basics, SAS Institute, Cary, NC.
[24] Proc. Third Int. Workshop Stat. Sci. Database Management, Luxembourg, July 2224, 1986.