FOSSLC is a non-profit organization that specializes in technology and know-how to record conferences with excellent quality. Click on the icons below to view great videos from communities we are actively involved with:

 

Databases

Content related to databases.

Critical Analysis of the WFS Transactional

in FOSS4G, FOSS4G2011, Video, Databases, OSGeo
OSGeo
While some standards have decisively contributed for more interoperable solutions, others need more time to mature and to become really useful. Only when several software providers offers compliant implementations, the standard become useful. Full interoperability is achieved when we can replace smoothly one functional module by another compliant with the same standard.
In this paper we discuss the usefulness of the Transaction component of the WFS. The WFS standard was published in 2002, version 1.0. In 2005, version 1.1 was published.
 
The Transaction operation is optional, so a WFS implementation does not need to support it to be conform.
According to OGC, the WFS was widely implemented (203), although the transactional part wasn't (55). Only 11 are official implementations of the WFS-T.
 
If users are not demanding its implementation, the developers tends to focus on more required features. So, we could use these numbers to infer that the transactional component is the less important part of this particular standard.
In this paper, more than showing that the WFS-T still didn't capture the users interest, we will try to explain the lack of usage of this standard.
 
Analyzing the two most typical GIS scenarios: the desktop scenario, where just one user is exploring GI, thus no concurrency exists and where the WFS-T will complicate more than simplify. In the multi-user scenario, the most demanding one, with clients and servers, the concurrency does exist, and transactional mechanisms are required. In this scenario, applications can rely on RDBMG transactional mechanisms. So, instead of connecting to WFS-T services, users and developers can connect directly to RDGMS supporting SQL+SFS. SQl and SFS are open standards widely used.
 
With these examples, it is shown that in both cases, the use of the WFS-T may be replaced, ensuring the achievement of the same goals. To illustrate the second scenario, we show two examples of clients (uDig and OpenLayers) connected to a WFS-T (Geoserver) and directly to the underlying RDGMS. We also present some benchmarks, regarding the performance with or without the WFS-T.
Finally, we conclude our paper stating that in practical terms, the WFS-T standard is less used, and so, the interoperability promise by its usage is compromised. The widespread and rich functionalities of geo-enabled RDBMS might be the major responsible for this. Nevertheless, the concepts behind the WFS-T, and the motivation behind its development are still important.
 
Event: 
FOSS4G2011
Speaker: 
Jorge Rocha
José Silva

Integration of GeoServer with NoSQL databases

in Database, FOSS4G, FOSS4G2011, GeoServer, Mapping, Video, Databases, OSGeo
GeoServerOSGeo

This presentation will introduce a GeoServer Plugin for the NoSQL Mongo Database. Cloud-based data storage built around NoSQL document-oriented stores continues to grow, this plugin offers GeoServer-based visualization of geospatial data stored in MongoDB. The plugin allows a MongoDB instance with GeoJSON-encoded data to be used as a backing store for GeoServer. The plugin, developed in Java, is available under a GNU GPL v2 license.

The presentation will address the derivation of implied schema from a schema-less NoSQL store for use with GeoServer's Feature objects, handling type conflicts in document fields, performance issues calculating this schema for a new GeoServer Data Store, and the use of MongoDB's map-reduce to distribute the load when operating in a sharded cloud environment. Each MongoDB collection is generally stored as a separate GeoServer layer, although mixed-geometry collections can be split out into corresponding layers for visualization.

 

Event: 
FOSS4G2011
Speaker: 
Alan Mangan

Test Driven Development web development with postgres or mysql.

in SC2011 - Software Developers' Haven, Video, Databases

Test Driven Development is about writing the test cases first, and then writing the code.  To use this method, a programmer needs to actually be able to quickly write test cases.

Web site development falls into two flavours: legacy development is where your only tool for testing is a browser, and modern development using some kind of systematic unit testing such as occurs with Django or Ruby on Rails.   Rewriting an application into a modern framework is not always an option, and one can be stuck with an older language with poor support, or an older application with no framework.

Even with frameworks, it is often difficult to test web services applications where there are multiple web servers necessary.

This talk presents some fast ways to get testing up and running, and to separate oneself from endlessly reconfiguring the database servers on your development platform.

 

Event: 
SoTM2011
Speaker: 
Michael Richardson

Open Data - Successes, Pitfalls and Advocacy

in Community, Database, Open Data, SC2011 - Software Developers' Haven, OpenStreetMap, Databases, Licenses, OSGeo
Speaker: 
Richard Weait
Event: 
SC2011
Abstract: 

Open Data is booming.  Like the Wild West, with too few Sheriffs, exciting things can happen in the blink of an eye.  This presentation will:

  • demonstrate successful and important applications of Open Data
  • discuss threats to Open Data
  • discuss best pracitces for Open Data communities
Level: 
Beginner