The full video of my talk from Hadoop Summit (San Jose, June 28, 2016) is now available. In this talk I cover performance considerations when moving analytic workloads into production. I even give away the game changing secret sauce for extreme performance in Actian’s Vector in Hadoop product for SQL analytics. VID: Solving Performance Problems […]
Drowning while trying to understand your options for SQL-based database management in Hadoop? This graphic is a simplified comparison of the various features of several popular products being used today. I outline some of my biggest differentiators in this post. While this is a marketing slide for Actian’s SQL in Hadoop enterprise solution, I wish I saw it earlier so I could […]
See this official 2015 hype cycle video here to get it straight from Gartner. In the video she says, first, it’s passed over the hump and is no longer just hype. Second, it’s embedded within other items throughout the cycle now. I can understand how this can get confusing to track and qualify, but isn’t […]
Kibana dashboards, from the Elasticsearch project, can help you visualise activity and incidents in log files. Here I show 3 different types of use cases for dashboards and how each can be used to answer different questions depending on the person. Video and details follow.
Graph analytics – is it just hype or is it technology that has come of age? Mike Hoskins, CTO of Actian sums it up well in this article from InfoWorld: “One area where graph analytics particularly earns its stripes is in data discovery. While most of the discussion around big data has centered on how to […]
I’ve been spending a lot of time this past year running queries against the open source SPARQLverse graph analytic engine. It’s amazing how simple some queries can look and yet how much work is being done behind the scenes. My current project requires building up a set of query examples that allow typical kinds of graph/network […]
Need to “Perform Big Data Analytics at Massive Scale?” The Actian Analytics Platform includes the Matrix high performance analytics database (formerly known as Paraccel). I’ve seen some people asking online for what JDBC URL syntax is. If you are using the JDBC driver be sure to read the README which gives the details:
|
1 2 3 4 5 6 7 8 9 10 11 |
The driver recognises JDBC URLs of the form: jdbc:paraccel:database jdbc:paraccel://host/database jdbc:paraccel://host:port/database Also, you can supply both username and passwords as arguments, by appending them to the URL. For example: jdbc:paraccel:database?user=me jdbc:paraccel:database?user=me&password=mypass Notes: 1) If you are connecting to localhost or 127.0.0.1, you can leave the host out of the URL; that is, jdbc:paraccel://localhost/mydb can be replaced with jdbc:paraccel:mydb 2) The port defaults to 5439 if it is not specified. |
Note that this […]