Featured Post

dsc_0007

Data Data Everywhere

How NoSQL complements traditional relational databases I like working with traditional relational database management systems (RDBMS).  There is something elegant about good table design and the physical implementation of a database.  I like running SQL statements and looking at data along with figuring out how to get specific result sets.  I’m not sure why this pleases me, but it has something to do with order in a chaotic world.  Traditional relational databases have a long history, and I’ve been working with them since the early 90s.  My first ten years as a consultant I built portal applications that were focused on reporting and analytics with features like financial dashboards and reports delivered via secured personalized websites.  During those ten years, I worked with databases every day. How We Got Here (And Where is Here?) In 1974 IBM released “System R” based upon the work of EF Codd.  Codd worked at IBM and he proposed theories on data relationships and invented the … [Read More...]

Other Recent Posts

Apache Solr JDBC - Background

Apache Solr JDBC – How to get involved

Overview My previous post in my Apache Solr JDBC blog series showed how to connect Apache Zeppelin (incubating) to Apache Solr. This post describes how you can get involved with Apache Solr and the JDBC driver. This post was inspired by the great Lucidworks … [Read More...]

zeppelin_solrjdbc_1

Apache Solr JDBC – Apache Zeppelin (incubating)

Overview My previous post in my Apache Solr JDBC blog series showed how to connect SQuirrel SQL to Apache Solr. This post highlights how to connect Apache Zeppelin (incubating) to Apache Solr using the JDBC driver. Apache Zeppelin (incubating) is a web-based … [Read More...]

SDLC: Seeing the Forest for the Trees

When I was a Professor, my favorite topic of discussion with students was System Development Life Cycle (SDLC) phases and practices for IT projects.  I enjoyed this discussion because I knew every one of my students; no matter what discipline, no matter what … [Read More...]

squirrelsql_solrjdbc_1

Apache Solr JDBC – SQuirrel SQL

Overview My previous post in my Apache Solr JDBC blog series showed how to connect DbVisualizer to Apache Solr. This post highlights how to connect SQuirrel SQL to Solr using the JDBC driver. SQuirrel SQL is a Java-based database query and management tool. … [Read More...]

dbvisualizer_solrjdbc_1

Apache Solr JDBC – DbVisualizer

Overview My previous post on Apache Solr JDBC gave an introduction of the feature and a sneak peak into some of the SQL clients and database visualization tools that can be connected to Apache Solr. This post highlights how to connect DbVisualizer to Apache … [Read More...]

Apache Zeppelin (incubating) Solr JDBC

Apache Solr JDBC Introduction

In my first post, I detailed the history that led up to my working on the Apache Solr JDBC driver and becoming an Apache Lucene/Solr committer. This post will describe the Solr JDBC driver and its usage. The next few posts in the series will be detailed guides … [Read More...]