[jira] [Comment Edited] (JENA-1693) Add Aggregate Function MEDIAN To SPARQL ARQ Syntax

["Marco Neumann (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/JENA-1693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16837859#comment-16837859 ] 

Marco Neumann edited comment on JENA-1693 at 5/11/19 1:26 PM:
--------------------------------------------------------------

very good [~ajs6f], I have finished and implemented the changes now with the Apache Commons Math lib on the lotico site for testing. This satisfies my use case and I will continue to test it here:

 [Lotico SPARQL endpoint|http://www.lotico.com/query/#SELECT%20median%28%3Fx%29%20WHERE%7B%0A%3Fx%20a%20<http%3A%2F%2Fwww.lotico.com%2Fontology%2FMember>%20%20%0A%7D

]

What would be the next steps for the PR? I still would like to clean up the code a little and add a test. And I also will change the result set value from [http://www.w3.org/2001/XMLSchema#double] to [http://www.w3.org/2001/XMLSchema#decimal].


was (Author: neumarcx):
very good [~ajs6f], I have finished and implemented the changes now with the Apache Commons Math lib on the lotico site for testing. This satisfies my use case and I will continue to test it here:

www.lotico.com/query/#SELECT%20median%28%3Fx%29%20WHERE%7B%0A%3Fx%20a%20<http%3A%2F%2Fwww.lotico.com%2Fontology%2FMember>%20%20%0A%7D

What would be the next steps for the PR? I still would like to clean up the code a little and add a test. And I also will change the result set value from http://www.w3.org/2001/XMLSchema#double to http://www.w3.org/2001/XMLSchema#decimal.

> Add Aggregate Function MEDIAN To SPARQL ARQ Syntax
> --------------------------------------------------
>
>                 Key: JENA-1693
>                 URL: https://issues.apache.org/jira/browse/JENA-1693
>             Project: Apache Jena
>          Issue Type: New Feature
>         Environment: general 
>  
>            Reporter: Marco Neumann
>            Priority: Minor
>              Labels: features
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
> As briefly mentioned to Andy Seaborne I'd like to see the aggregate function MEDIAN in the ARQ SPARQL syntax. 
> "Median is the value that separates lower half from the higher half when the values are ordered in ascending or descending order. It is the middle value in a given dataset. Medians are helpful in understanding the distribution of data. This can be done by comparing mean and median values. By observing the difference between these values we can understand whether the data is left skewed or right skewed. The formula for median is: Median = ((n + 1)/2) th number in the series where the numbers are ordered. Here, n denotes the number of values for the given variable."
> DIVYA SPANDANA MARNEN, SPARQL-R: EXTENDED SPARQL FOR STATISTICAL COMPUTATIONS.
>  
> example
>  
> SELECT agg:median(?age) AS ?median
> WHERE
> { ?x ex:age ?age }
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)