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

α
Mridul Kanti Das
Mridul Kanti Das
σ
Goutam Biswas
Goutam Biswas
ρ
Md. Masudur Rahman
Md. Masudur Rahman
Ѡ
Dr. Md. Nasim Akhtar
Dr. Md. Nasim Akhtar
α Dhaka University of Engineering & Technology

Send Message

To: Author

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

AI TAKEAWAY

Connecting with the Eternal Ground
  • English
  • Afrikaans
  • Albanian
  • Amharic
  • Arabic
  • Armenian
  • Azerbaijani
  • Basque
  • Belarusian
  • Bengali
  • Bosnian
  • Bulgarian
  • Catalan
  • Cebuano
  • Chichewa
  • Chinese (Simplified)
  • Chinese (Traditional)
  • Corsican
  • Croatian
  • Czech
  • Danish
  • Dutch
  • Esperanto
  • Estonian
  • Filipino
  • Finnish
  • French
  • Frisian
  • Galician
  • Georgian
  • German
  • Greek
  • Gujarati
  • Haitian Creole
  • Hausa
  • Hawaiian
  • Hebrew
  • Hindi
  • Hmong
  • Hungarian
  • Icelandic
  • Igbo
  • Indonesian
  • Irish
  • Italian
  • Japanese
  • Javanese
  • Kannada
  • Kazakh
  • Khmer
  • Korean
  • Kurdish (Kurmanji)
  • Kyrgyz
  • Lao
  • Latin
  • Latvian
  • Lithuanian
  • Luxembourgish
  • Macedonian
  • Malagasy
  • Malay
  • Malayalam
  • Maltese
  • Maori
  • Marathi
  • Mongolian
  • Myanmar (Burmese)
  • Nepali
  • Norwegian
  • Pashto
  • Persian
  • Polish
  • Portuguese
  • Punjabi
  • Romanian
  • Russian
  • Samoan
  • Scots Gaelic
  • Serbian
  • Sesotho
  • Shona
  • Sindhi
  • Sinhala
  • Slovak
  • Slovenian
  • Somali
  • Spanish
  • Sundanese
  • Swahili
  • Swedish
  • Tajik
  • Tamil
  • Telugu
  • Thai
  • Turkish
  • Ukrainian
  • Urdu
  • Uzbek
  • Vietnamese
  • Welsh
  • Xhosa
  • Yiddish
  • Yoruba
  • Zulu

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
  1. (null). Figure 4: Network based on transformed 5S-IGS data showing inter-individual average (AVG) clonal distance relationships..
  2. =row size of data table.
  3. (null). step size.
  4. (2021). Sum Sum Sum.
  5. Unknown Title.
  6. V References,Referencias Unknown Title.
  7. E Codd (1970). A Relational Model of Data for Large Shared Data Banks.
  8. Bernhard Seliger (2009). The European Commission after the June 2009 elections – new appointment rules, old planning approaches?.
  9. Analytic Functions from Oracle® Database SQL Reference 10g.
  10. L Baekgraard,L Mark (1995). Incremental computation of nested relational query expression.
  11. Bill Graziano (2002). Comparing Tables By.
  12. Sotirios Zygiaris (2006). Structured Query Language (SQL): Views, Triggers, and Functions.

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. 2011. \u201cA New Approach For Calculating Average Value (including null) Without Aggregate Function\u201d. Global Journal of Research in Engineering - I: Numerical Methods GJRE-I Volume 11 (GJRE Volume 11 Issue I7): .

Download Citation

Journal Specifications

Crossref Journal DOI 10.17406/gjre

Print ISSN 0975-5861

e-ISSN 2249-4596

Version of record

v1.2

Issue date

December 28, 2011

Language
en
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.

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.

Article Matrices
Total Views: 5609
Total Downloads: 2824
2026 Trends
Related Research

Published Article

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.

Our website is actively being updated, and changes may occur frequently. Please clear your browser cache if needed. For feedback or error reporting, please email [email protected]

Request Access

Please fill out the form below to request access to this research paper. Your request will be reviewed by the editorial or author team.
X

Quote and Order Details

Contact Person

Invoice Address

Notes or Comments

This is the heading

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

High-quality academic research articles on global topics and journals.

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

Mridul Kanti Das
Mridul Kanti Das Dhaka University of Engineering & Technology
Goutam Biswas
Goutam Biswas
Md. Masudur Rahman
Md. Masudur Rahman
Dr. Md. Nasim Akhtar
Dr. Md. Nasim Akhtar

Research Journals