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:

 

Database

Content related to relational, key-value pair, XML, network, and other databases.

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

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

OpenStreetMap - Location, Location, Location

in Community, Database, How To, Open Data, SC2011 - Software Developers' Haven, OpenLayers, PostGIS, PostgreSQL, OpenStreetMap, Databases, OSGeo, Programming, Web Programming
Speaker: 
Richard Weait
Event: 
SC2011
Abstract: 

OpenStreetMap is geographic data that you can use and improve.  This presentation will:

  • cover a brief history of OpenStreetMap
  • show you why you want to be involved in OpenStreetMap
  • familiarize you with common solutions using OpenStreetMap
  • familiarize you with the OpenStreetMap tool set

Plan to join us at the Mapping Party on Sunday for peer-coaching on OpenStreetMap data surveys and editing tools.

Level: 
Beginner

PostgreSQL replication

in Database, SC2011, PostgreSQL
Speaker: 
Steve Singer
Event: 
SC2011
Abstract: 

PostgreSQL is an open source relational database system that features a high level of standards complience and support for most programming languages.   PostgreSQL offers a number of different options for data replication.   This talk will provide an introduction to database replication in PostgreSQL and explain the different types of problems that replication can solve.  The talk will explain how the built in WAL shipping replication works, how to set it up and discuss the limitations.  The Slony replication system will be explained including the basic steps involved in setting up a Slony cluster and how Slony can be used to solve common problems

Level: 
Intermediate