A New Approach For Calculating Average Value (including null) Without Aggregate Function

Mridul Kanti Das; Goutam Biswas; Md. Masudur Rahman

A New Approach For Calculating Average Value (including null) Without Aggregate Function

Mridul Kanti Das * §

Contact

Goutam Biswas §

Contact

Md. Masudur Rahman §

Contact

nasim_duet §

Contact

§ Dhaka University of Engineering & Technology

A New Approach For Calculating Average Value (including null) Without Aggregate Function

Article Fingerprint

ReserarchID

M626B

A New Approach For Calculating Average Value (including null) Without Aggregate Function Banner

Key Research Insights

Synthesized scholarly intelligence & interactive research assistant

This converted HTML version may contain rendering inconsistencies. Please refer to the PDF for the authoritative version, or click here to provide feedback.

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. We show how this could be implemented into a database. We also describe how support for special kinds of aggregate queries and data structures can help in designing future high performance systems.

References

12 Cites in Article

Reference Format

1. (null). Figure 4: Network based on transformed 5S-IGS data showing inter-individual average (AVG) clonal distance relationships. Algorithm Average_WN
2. =row size of data table. =row size of data table
3. (null). step size. For r:=0 to size-2 step 2
4. (2021). Sum Sum Sum. Im Schatten von Design, 118-121.
5. Unknown Title. =NULL ) then sum
6. V References,Referencias Unknown Title.
7. E Codd (1970). A Relational Model of Data for Large Shared Data Banks. Communications of the ACM, 13(6), 377-387.
8. Bernhard Seliger (2009). The European Commission after the June 2009 elections – new appointment rules, old planning approaches?. Journal of European Union Studies, null(25), 173-196.
9. Analytic Functions from Oracle® Database SQL Reference 10g. Analytic Functions from Oracle® Database SQL Reference 10g
10. L Baekgraard,L Mark (1995). Incremental computation of nested relational query expression. ACM TODS, 20(2), 111-148.
11. Bill Graziano (2002). Comparing Tables By. Comparing Tables By
12. Sotirios Zygiaris (2006). Structured Query Language (SQL): Views, Triggers, and Functions. Database Management Systems, 173-192.

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

Mridul Kanti Das, Goutam Biswas, Md. Masudur Rahman, nasim_duet. 2011. "A New Approach For Calculating Average Value (including null) Without Aggregate Function". Global Journal of Research in Engineering - I: Numerical Methods GJRE-I Volume 11 (GJRE Volume 11 Issue I7).

More Citation Formats

Select Citation Style:

Download Citation

GJRE Volume 11 Issue I7

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 ReceivedDecember 2, 2011
Peer Review Double Blind
Handling Editor
Accepted December 27, 2011
Published January 6, 2012

Version of record

v1.2

Issue date

December 28, 2011

Language

English

Order Article Reprint

Experience 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 - I: Numerical Methods

Authors: Mridul Kanti Das, Goutam Biswas, Md. Masudur Rahman, Dr. Md. Nasim Akhtar (PhD/Dr. count: 1)

View Count (all-time): 431

Total Views (Real + Logic): 1494

Total Downloads (simulated): 75

Publish Date: 2012 01, Fri

Monthly Totals (Real + Logic):

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

Total Views: 1.5K

Total Downloads: 75

All Trends