Research
A New Approach For Calculating Average Value (including null) Without Aggregate Function
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.
Calculate Average of an Attribute Including Null Without Aggregate Function
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.
