Calculate Average of an Attribute Including Null Without Aggregate Function

Dr. Mridul Kanti Das; Md. Shakil khan; Md. Mostafa Kamal

Calculate Average of an Attribute Including Null Without Aggregate Function

Dr. Mridul Kanti Das * §

Contact

Md. Shakil khan

Contact

Md. Mostafa Kamal

Contact

Dr. Md.Saiful Islam

Contact

§ Dhaka University of Engineering Technology

Calculate Average of an Attribute Including Null Without Aggregate Function

Article Fingerprint

ReserarchID

RE9042Q

Calculate Average of an Attribute Including Null Without Aggregate Function Banner

Key Research Insights

Synthesized scholarly intelligence & interactive research assistant

Abstract

An evaluation of aggregate functions in relational database system considerable impact on performance in many application areas like geographic information systems and statistical and scientific databases. The problem with existing systems is inefficient execution of aggregate functions with large data volumes and lack of flexibility. It is not possible to extend the systems with new aggregate (average) functions. In this paper we extend the concept of aggregate functions from relational databases. This paper introduces the concept of average functions which could enhance flexibility and performance considerably. We show how this could be implemented into a database. Our implemented technique easily detects any changing in replicated data and original data with considering Null values.

References

7 Cites in Article

Reference Format

L Baekgraard,L Mark (1995). Incremental computation of nested relational query expression.
Jeff Smith is software developer, he using UNION operator comparing NULL values to other NULLs.
Bill Graziano (2002). Comparing Tables By.
SQL Functions from Oracle Database Globalization Support Guide 6. Analytic Functions from Oracle® Database SQL Reference 10g Release 1.
Mary Schneider (2009). CMS Adds Readmission Data to Hospital Compare Web Site.
(2006). 1 SQL (Structured Query Language).
E Codd (1970). A relational model of data for large shared data banks.

Download References

Funding

No external funding was declared for this work.

Conflict of Interest

The authors declare no conflict of interest.

Ethical Approval

No ethics committee approval was required for this article type.

Data Availability

Not applicable for this article.

How to Cite This Article

Dr. Mridul Kanti Das, Md. Shakil khan, Md. Mostafa Kamal, Dr. Md.Saiful Islam. 1970. "Calculate Average of an Attribute Including Null Without Aggregate Function". Global Journal of Research in Engineering - F: Electrical & Electronic GJRE-F Volume 12 (GJRE Volume 12 Issue F1).

More Citation Formats

Select Citation Style:

Download Citation

GJRE Volume 12 Issue F1

Explore Journals Explore Volume Read This Issue

Journal Specifications

Crossref Journal DOI 10.17406/gjre

Print ISSN 0975-5861

e-ISSN 2249-4596

Keywords

Aggregate Function Boolean algebra NULL SQL Sub Queries

Classification

GJRE-I Classification FOR Code: 010303

Submission ReceivedFebruary 5, 2012
Peer Review Double Blind
Handling Editor
Accepted February 29, 2012
Published March 15, 2012

Version of record

v1.2

Language

English

Experiance in AR

Explore published articles in an immersive Augmented Reality environment. Our platform converts research papers into interactive 3D books, allowing readers to view and interact with content using AR and VR compatible devices.

View in VR

Read in 3D

Your published article is automatically converted into a realistic 3D book. Flip through pages and read research papers in a more engaging and interactive format.

View in 3D

Article Matrices

Total Score: 109

Country: Bangladesh

Subject: Global Journal of Research in Engineering

Authors: Dr. Mridul Kanti Das , Md. Shakil khan , Md. Mostafa Kamal , Md. Saiful Islam (PhD/Dr. count: 1)

View Count (all-time): 336

Total Views (Real + Logic): 8506

Total Downloads (simulated): 395

Publish Date: 2012 03, Thu

Monthly Totals (Real + Logic):

Month 1: 53 views
Month 2: 58 views
Month 3: 42 views
Month 4: 28 views
Month 5: 60 views
Month 6: 47 views
Month 7: 50 views
Month 8: 54 views
Month 9: 58 views
Month 10: 23 views
Month 11: 24 views
Month 12: 27 views
Month 13: 35 views
Month 14: 28 views
Month 15: 30 views
Month 16: 35 views
Month 17: 34 views
Month 18: 29 views
Month 19: 32 views
Month 20: 24 views
Month 21: 26 views
Month 22: 40 views
Month 23: 20 views
Month 24: 24 views
Month 25: 30 views
Month 26: 36 views
Month 27: 28 views
Month 28: 18 views
Month 29: 22 views
Month 30: 32 views
Month 31: 24 views
Month 32: 23 views
Month 33: 33 views
Month 34: 41 views
Month 35: 42 views
Month 36: 25 views
Month 37: 31 views
Month 38: 35 views
Month 39: 32 views
Month 40: 19 views
Month 41: 30 views
Month 42: 38 views
Month 43: 47 views
Month 44: 35 views
Month 45: 26 views
Month 46: 21 views
Month 47: 33 views
Month 48: 42 views
Month 49: 26 views
Month 50: 30 views
Month 51: 31 views
Month 52: 50 views
Month 53: 20 views
Month 54: 17 views
Month 55: 22 views
Month 56: 26 views
Month 57: 39 views
Month 58: 22 views
Month 59: 30 views
Month 60: 38 views
Month 61: 26 views
Month 62: 40 views
Month 63: 26 views
Month 64: 32 views
Month 65: 38 views
Month 66: 38 views
Month 67: 23 views
Month 68: 22 views
Month 69: 39 views
Month 70: 19 views
Month 71: 18 views
Month 72: 39 views
Month 73: 29 views
Month 74: 30 views
Month 75: 37 views
Month 76: 34 views
Month 77: 38 views
Month 78: 30 views
Month 79: 26 views
Month 80: 24 views
Month 81: 27 views
Month 82: 33 views
Month 83: 20 views
Month 84: 33 views
Month 85: 13 views
Month 86: 45 views
Month 87: 47 views
Month 88: 39 views
Month 89: 33 views
Month 90: 25 views
Month 91: 43 views
Month 92: 26 views
Month 93: 10 views
Month 94: 32 views
Month 95: 41 views
Month 96: 45 views
Month 97: 30 views
Month 98: 39 views
Month 99: 39 views
Month 100: 44 views
Month 101: 32 views
Month 102: 33 views
Month 103: 38 views
Month 104: 34 views
Month 105: 15 views
Month 106: 41 views
Month 107: 41 views
Month 108: 37 views
Month 109: 36 views
Month 110: 38 views
Month 111: 21 views
Month 112: 34 views
Month 113: 49 views
Month 114: 34 views
Month 115: 36 views
Month 116: 30 views
Month 117: 22 views
Month 118: 31 views
Month 119: 22 views
Month 120: 24 views
Month 121: 40 views
Month 122: 32 views
Month 123: 33 views
Month 124: 38 views
Month 125: 38 views
Month 126: 31 views
Month 127: 32 views
Month 128: 36 views
Month 129: 41 views
Month 130: 36 views
Month 131: 34 views
Month 132: 34 views
Month 133: 25 views
Month 134: 20 views
Month 135: 19 views
Month 136: 37 views
Month 137: 19 views
Month 138: 46 views
Month 139: 16 views
Month 140: 38 views
Month 141: 15 views
Month 142: 16 views
Month 143: 29 views
Month 144: 46 views
Month 145: 27 views
Month 146: 28 views
Month 147: 42 views
Month 148: 41 views
Month 149: 36 views
Month 150: 27 views
Month 151: 23 views
Month 152: 48 views
Month 153: 21 views
Month 154: 18 views
Month 155: 27 views
Month 156: 36 views
Month 157: 28 views
Month 158: 27 views
Month 159: 39 views
Month 160: 30 views
Month 161: 28 views
Month 162: 25 views
Month 163: 40 views
Month 164: 49 views
Month 165: 54 views
Month 166: 35 views
Month 167: 46 views
Month 168: 19 views
Month 169: 36 views
Month 170: 32 views
Month 171: 14 views
Month 172: 43 views
Month 173: 62 views
Month 174: 41 views
Month 175: 48 views

Total Views: 8.5K

Total Downloads: 395

All Trends