Datasets generated for project technology.ease

Context of this work

Crossminer is EU-funded research project that aims at providing tailored recommendations for software practitionners. Its outputs include the Scava Eclipse project and a set of public datasets extracted from a selection of representative Eclipse projects.

This report was generated on 2019-03-13.

About this document

This document is a R notebook, dynamically created from the numbers extracted on the project. It lists all datasets published for the project, providing basic numbers, figures and a quick summary, and serves as a test case to make sure that all the required data is present and roughly consistent with requirements. All plots and tables are computed from the actual data as provided in the downloads.

To re-execute the document, simply render it with the project ID as a parameter:

render("datasets_report.Rmd", params = list(project_id = "technology.ease"))

About the downloads

Downloads are mainly composed of CSV and JSON files. CSV files always have a header to name the fields, which makes it easy to import in analysis software like R:

data <- read.csv(file='myfile.csv', header=T)
names(data)

All downloads are available as compressed (gzip’d) files to reduce bandwidth usage.

Content

List of datasets generated for the project:

Git

Git commits

Download: git_commits_evol.csv.gz

data <- read.csv(file=url_git_commits, header=T)

File is git_commits_evol.csv, and has 3 columns for 377 commits.

data$commits_sum <- cumsum(data$commits)
data.xts <- xts(x = data[,c('commits_sum', 'commits', 'authors')], order.by=as.POSIXct(as.character(data[,c('date')]), format="%Y-%m-%d"))

p <-dygraph(data.xts[,c('commits')],
        main = paste('Daily commits for ', project_id, sep=''),
        width = 800, height = 250 ) %>%
      dyRangeSelector()
p

Git log

Download: git_log.txt.gz

File is git_log.txt, and full log has 9387 lines.

Bugzilla

Bugzilla issues

Download: bugzilla_issues.csv.gz

data <- read.csv(file=url_bz_issues, header=T)

File is bugzilla_issues.csv, and has 17 columns for 758 issues.

Bugzilla open issues

Download: bugzilla_issues_open.csv.gz

data <- read.csv(file=url_bz_issues_open, header=T)

File is bugzilla_issues_open.csv, and has 17 columns for 121 issues (all open).

Bugzilla evolution

Download: bugzilla_evol.csv.gz

data <- read.csv(file=url_bz_evol, header=T)

File is bugzilla_evol.csv, and has 3 columns for 417 weeks.

data.xts <- xts(x = data, order.by = as.POSIXct(data$date))
data.monthly <- apply.monthly(x=data.xts, FUN = nrow)

p <-dygraph(data.monthly[,1],
        main = paste('Monthly issues submissions for ', project_id, sep=''),
        width = "750px", height = 250 ) %>%
      dyRangeSelector()
p

Versions

Download: bugzilla_versions.csv.gz

data <- read.csv(file=url_bz_versions, header=T)

File is bugzilla_versions.csv, and has 2 columns for 7 weeks.

Components

Download: bugzilla_components.csv.gz

data <- read.csv(file=url_bz_components, header=T)

File is bugzilla_components.csv, and has 2 columns for 8 weeks.

Eclipse Forums

Forums posts

Download: eclipse_forums_posts.csv.gz

data <- read.csv(file=url_forums_posts, header=T)

File is ../scripts/projects/technology.ease/eclipse_forums_posts.csv, and has 6 columns for 209 posts. The evolution of posts

data$created.date <- as.POSIXct(data$created_date, origin="1970-01-01")
posts.xts <- xts(data, order.by = data$created.date)
posts.weekly <- apply.weekly(x=posts.xts, FUN = nrow)
names(posts.weekly) <- c("posts")

p <- dygraph(
  data = posts.weekly,
  main = paste('Weekly forum posts for ', project_id, sep=''),
  width = 800, height = 250 ) %>%
  dyAxis("x", drawGrid = FALSE) %>%
  dySeries("posts", label = "Weekly posts") %>%
  dyOptions(stepPlot = TRUE) %>%
  dyRangeSelector()
p

The list of the 10 last active posts on the forums:

data$created.date <- as.POSIXct(data$created_date, origin="1970-01-01")
posts.table <- head(data[,c('id', 'subject', 'created.date', 'author_id')], 10)
posts.table$subject <- paste('<a href="', posts.table$html_url, '">', posts.table$subject, '</a>', sep='')
posts.table$created.date <- as.character(posts.table$created.date)
names(posts.table) <- c('ID', 'Subject', 'Post date', 'Post author')

print(
    xtable(head(posts.table, 10),
        caption = paste('10 most recent posts on', project_id, 'forum.', sep=" "),
        digits=0, align="lllll"), type="html",
    html.table.attributes='class="table table-striped"',
    caption.placement='bottom',
    include.rownames=FALSE,
    sanitize.text.function=function(x) { x }
)
10 most recent posts on technology.ease forum.
ID Subject Post date Post author
1794393 Re: How to debug Python script launched from Java 2018-08-30 08:51:09 58927
1794392 Re: Release Schedule? 2018-08-30 08:32:52 58927
1794290 How to debug Python script launched from Java 2018-08-28 15:44:06 8884
1794281 Release Schedule? 2018-08-28 14:26:00 8884
1794199 Re: Py4J: import instead of loadModule 2018-08-27 14:17:14 58927
1794195 Re: Py4J: import instead of loadModule 2018-08-27 12:25:23 58927
1794113 Py4J: import instead of loadModule 2018-08-23 22:00:55 8884
1793221 Re: Javascript File Read Tutorial/Snippets 2018-08-01 19:29:44 58927
1792806 Javascript File Read Tutorial/Snippets 2018-07-24 11:41:54 222148
1792805 Re: EASE - Javascript Simple Program 2018-07-24 11:38:02 222148

Forums threads

Download: eclipse_forums_threads.csv.gz

data <- read.csv(file=url_forums_threads, header=T)

File is ../scripts/projects/technology.ease/eclipse_forums_threads.csv, and has 8 columns for 57 threads. A wordcloud with the main words used in threads is presented below.

The list of the 10 last active threads on the forums:

data$last.post.date <- as.POSIXct(data$last_post_date, origin="1970-01-01")
threads.table <- head(data[,c('id', 'subject', 'last.post.date', 'last_post_id', 'replies', 'views')], 10)
threads.table$subject <- paste('<a href="', threads.table$html_url, '">', threads.table$subject, '</a>', sep='')
threads.table$last.post.date <- as.character(threads.table$last.post.date)
names(threads.table) <- c('ID', 'Subject', 'Last post date', 'Last post author', 'Replies', 'Views')

print(
    xtable(threads.table,
        caption = paste('10 last active threads on', project_id, 'forum.', sep=" "),
        digits=0, align="lllllll"), type="html",
    html.table.attributes='class="table table-striped"',
    caption.placement='bottom',
    include.rownames=FALSE,
    sanitize.text.function=function(x) { x }
)
10 last active threads on technology.ease forum.
ID Subject Last post date Last post author Replies Views
1094878 How to debug Python script launched from Java 2018-08-30 08:51:09 1794393 1 1474
1094877 Release Schedule? 2018-08-30 08:32:52 1794392 1 1257
1094824 Py4J: import instead of loadModule 2018-08-27 14:17:14 1794199 2 1453
1094389 Javascript File Read Tutorial/Snippets 2018-08-01 19:29:44 1793221 1 2417
1094313 Confused about bug tracker 2018-07-19 16:34:19 1792563 0 1810
1094282 EASE - Javascript Simple Program 2018-07-24 11:38:02 1792805 4 997
1092018 EAST=ADL instance injection 2018-03-03 07:26:17 1782882 1 1608
1091145 Execute script programmatically and synchronous 2018-01-29 12:27:10 1780867 4 1554
1090760 py4-java for ease update site 2017-12-22 15:03:05 1778852 0 6596
1090752 Py4J Update site Problem 2017-12-29 09:12:52 1779026 3 2477

PMI

PMI Checks

Download: eclipse_pmi_checks.csv.gz

data <- read.csv(file=url_pmi_checks, header=T)

File is eclipse_pmi_checks.csv, and has 3 columns for 17 commits.

checks.table <- head(data[,c('Description', 'Value', 'Results')], 10)

print(
    xtable(checks.table,
        caption = paste('Extract of the 10 first PMI checks for ', 
                        project_id, '.', sep=" "),
        digits=0, align="llll"), type="html",
    html.table.attributes='class="table table-striped"',
    caption.placement='bottom',
    include.rownames=FALSE,
    sanitize.text.function=function(x) { x }
)
Extract of the 10 first PMI checks for technology.ease .
Description Value Results
Checks if the URL can be fetched using a simple get query. https://bugs.eclipse.org/bugs/enter_bug.cgi?product=EASE OK: Create URL could be successfully fetched.
Checks if the URL can be fetched using a simple get query. https://bugs.eclipse.org/bugs/buglist.cgi?product=EASE OK: Query URL could be successfully fetched.
Sends a get request to the given CI URL and looks at the headers in the response (200 404..). Also checks if the URL is really a Hudson instance (through a call to its API). Failed: could not get CI URL [].
Checks if the Dev ML URL can be fetched using a simple get query. https://dev.eclipse.org/mailman/listinfo/ease-dev OK: Dev ML URL could be successfully fetched.
Checks if the URL can be fetched using a simple get query. Failed: no URL defined for documentation_url.
Checks if the URL can be fetched using a simple get query. Failed: no URL defined for download_url.
Checks if the Forums URL can be fetched using a simple get query. Failed: no forums defined.
Checks if the URL can be fetched using a simple get query. Failed: no URL defined for gettingstarted_url.
Checks if the Mailing lists URL can be fetched using a simple get query. Failed: no mailing list defined.
Checks if the URL can be fetched using a simple get query. Failed: no URL defined for plan.

SonarQube

SonarQube blocker issues

Download: sq_issues_blocker.csv.gz

data <- read.csv(file=url_sq_issues_blocker, header=T)

File is sq_issues_blocker.csv, and has 5 columns for 140 issues.

data$last.update <- as.POSIXct(data$last_update, origin="1970-01-01")
issues.table <- head(data[,c('key', 'rule', 'sev', 'last.update', 'message')], 10)
issues.table$last.update <- as.character(issues.table$last.update)
names(issues.table) <- c('Key', 'Rule', 'Severity', 'Last update', 'Message')

print(
    xtable(issues.table,
        caption = paste('Extract of 10 SonarQube blocker issues for ', 
                        project_id, '.', sep=" "),
        digits=0, align="llllll"), type="html",
    html.table.attributes='class="table table-striped"',
    caption.placement='bottom',
    include.rownames=FALSE,
    sanitize.text.function=function(x) { x }
)
Extract of 10 SonarQube blocker issues for technology.ease .
Key Rule Severity Last update Message
01ba92be-945f-4e68-ad67-fe6f66041f38 findbugs:DMI_BLOCKING_METHODS_ON_URL BLOCKER 2017-09-14 Invocation of java.net.URL.equals(Object) which blocks to do domain name resolution in org.eclipse.equinox.launcher.Main.processConfiguration()
0a6fc12b-3766-45af-a27b-2d484b3f6d7d findbugs:DMI_COLLECTION_OF_URLS BLOCKER 2016-01-24 org.eclipse.pde.ui.tests.target.LocalTargetDefinitionTests.testVariableDirectoryBundleContainer() is or uses a map or set of URLs which can be a performance hog
0b158569-d2f5-4b0a-b7fa-9ac84ecb208e findbugs:NP_NULL_INSTANCEOF BLOCKER 2017-12-13 A known null value is checked to see if it is an instance of org.eclipse.emf.diffmerge.api.scopes.IPersistentModelScope in org.polarsys.kitalpha.model.attachment.ui.merge.MergeCommand.doExecute()
0c930952-b0e0-4dac-a3c6-d2871170d05a findbugs:NP_NULL_INSTANCEOF BLOCKER 2016-01-15 A known null value is checked to see if it is an instance of org.eclipse.emf.diffmerge.api.scopes.IPersistentModelScope in org.polarsys.kitalpha.model.attachment.ui.merge.MergeCommand.doExecute()
0e2c939f-15a7-4543-aedc-f139a3c0b02e findbugs:NP_GUARANTEED_DEREF BLOCKER 2017-04-04 newValue could be null and is guaranteed to be dereferenced in org.polarsys.capella.core.data.interaction.impl.ScenarioImpl.eSet(int Object)
0fdc935b-33b1-445a-ad2a-389d6fa9c37f findbugs:BC_IMPOSSIBLE_CAST BLOCKER 2016-11-16 Impossible cast from Integer to Boolean in org.eclipse.kura.internal.wire.publisher.CloudPublisherOptions.getPublishingRetain()
10a086df-f8b8-45f2-91fe-5ec6b2eee4a9 findbugs:DMI_BLOCKING_METHODS_ON_URL BLOCKER 2016-02-27 Invocation of java.net.URL.equals(Object) which blocks to do domain name resolution in org.eclipse.andmore.android.common.utilities.EclipseUtils.openedWebEditor(IWorkbenchPage URL)
18f035f0-9c7b-4fe5-9fcf-78ee13625d45 squid:S2583 BLOCKER 2019-02-18 Change this condition so that it does not always evaluate to true
194f5b55-4812-4654-98f9-ef6df651e302 findbugs:NP_GUARANTEED_DEREF BLOCKER 2017-04-04 newValue could be null and is guaranteed to be dereferenced in org.polarsys.capella.core.data.fa.impl.AbstractFunctionImpl.eSet(int Object)
1c0e67ca-a0e6-4a18-a548-6ad2d8e25435 findbugs:NP_GUARANTEED_DEREF BLOCKER 2016-02-05 e could be null and is guaranteed to be dereferenced in org.eclipse.dltk.xotcl.internal.core.parser.processors.xotcl.XOTclClassNewInstanceProcessor.process(TclStatement ITclParser ASTNode)

SonarQube critical issues

Download: sq_issues_critical.csv.gz

data <- read.csv(file=url_sq_issues_critical, header=T)

File is sq_issues_critical.csv, and has 5 columns for 500 issues.

SonarQube major issues

Download: sq_issues_major.csv.gz

data <- read.csv(file=url_sq_issues_major, header=T)

File is sq_issues_major.csv, and has 5 columns for 500 issues.

SonarQube metrics

Download: sq_metrics.csv.gz

data <- read.csv(file=url_sq_metrics, header=T)

File is sq_metrics.csv, and has 45 columns for 1 line.

# Transform from wide to long format.
data <- t(data)
data_ <- data.frame(rownames(data), data[,1])
names(data_) <- c('Metric', 'Value')
# Remove NAs
data_  <- data_[complete.cases(data_$Value),]

print(
    xtable(data_,
        caption = paste('SonarQube metrics for ', 
                        project_id, '.', sep=" "),
        digits=0, align="lll"), type="html",
    html.table.attributes='class="table table-striped"',
    caption.placement='bottom',
    include.rownames=FALSE,
    sanitize.text.function=function(x) { x }
)
SonarQube metrics for technology.ease .
Metric Value
SQ_VIOLATIONS_MAJOR 1632
SQ_CPX_CLASS_IDX 15
SQ_COVERAGE_BRANCH 10
SQ_COVERAGE 11
SQ_PACKAGES_CYCLES 19
SQ_DUPLICATED_FILES 13
SQ_CPX_FILE_IDX 16
SQ_STATEMENTS 9310
SQ_CPX 5100
SQ_NCLOC 21996
SQ_PUBLIC_API 1126
SQ_DUPLICATED_LINES_DENSITY 1
SQ_COVERAGE_LINE 12
SQ_DUPLICATED_LINES 303
SQ_ISSUES_OPEN 1892
SQ_CPX_FUNC_IDX 3
SQ_COMMENT_LINES 3743
SQ_PUBLIC_UNDOC_API 660
SQ_RULES 35
SQ_FILES 314
SQ_VIOLATIONS_MINOR 199
SQ_VIOLATIONS_INFO 33
SQ_TEST_SUCCESSFUL_DENSITY 100
SQ_PACKAGES_TANGLE_IDX 25
SQ_PUBLIC_API_DOC_DENSITY 41
SQ_FUNCS 1839
SQ_TESTS 71
SQ_DUPLICATED_BLOCKS 15
SQ_VIOLATIONS_CRITICAL 28
SQ_COMR 14
SQ_VIOLATIONS 1892