Tags » Data Access

Options for Open Source, Public Access for ATBI Data

When I worked for the NBII we used Rackspace and Amazon’s cloud service, along with MySQL for the “Species of Greatest Conservation Need” database that held a similar number of species, but no spatial data. 275 more words

Coursework

A Cursor By Any Other Name

Recently again I had to give customer DBA team advice on most performing JDBC settings for data access from SQL Server via MS JDBC Driver. Unfortunately, again majority of “SQL People” after looking at wait stats and traces from SQL Server and seeing some old fashioned data access cursors with commands like see sp_cursoruprepare, sp_cursorfetch, etc. 522 more words

SQL Server

Hey what happenned to my Isolation Level

As with one of my customers they do a lot of J2EE on IBM Websphere AS with SQL Server I observed an interesting phenomenon while troubleshooting excessive blocking. 578 more words

SQL Server

Feedback Wanted: Publishers & Data Access

This post is co-authored with Jennifer Lin, PLOS

Short Version: We need your help!

We have generated a set of recommendations for publishers to help increase access to data in partnership with libraries, funders, information technologists, and other stakeholders. 319 more words

Current Events

How to forget ODBC and Rethink PLM Data Openness?

One of the most popular topics in engineering (but not only) software ecosystem. Open vs. Close. I’ve been discussing it many times – Open vs. Closed PLM Debates… 787 more words

Daily PLM Think Tank

Semi-Automated Dissemmination of Geographically Linked Policing Data

I post Regional Analyisis and Information Data Sharing (RAIDS) online data for my neighborhood on a separate blog. I made a matching twitter account… 285 more words

Civic Life

Replication in International Relations: Successes & Failures in Practice

The largest International Relations conference, ISA’s 55th Annual Convention (March 26-29, 2014), features two panels on replication and reproducibility this year. The second panel covers “Replication in International Relations: Successes & Failures in Practice.”

Replication