Table macros are a new Optiq feature (since release 0.6) that combine the efficiency of tables with the flexibility of functions. Optiq offers a convenient model for presenting data from multi...
It’s been a while since I posted to this blog, but I haven’t been idle. Quite the opposite; I’ve been so busy writing code that I haven’t had time to write blog posts. A few months ago I ...
http://julianhyde.blogspot.com/2014/03/improvements-to-optiqs-mongodb-adapter.html
How do you integrate MongoDB with other data in your organization? MongoDB is great for building applications, and it has its own powerful query API, but it's difficult to mash up data between M...
http://julianhyde.blogspot.com/2013/06/efficient-sql-queries-on-mongodb.html
It's time to start thinking about olap4j version 2.0. My initial goal for olap4j version 1.0 was to decouple application developers from Mondrian's legacy API. We've far surpassed that goal. Ma...
http://julianhyde.blogspot.com/2013/06/gathering-requirements-for-olap4j-20.html
I was amused by this note I just received via email.
> Subject: Need help
> To: jhyde@users.sourceforge.net
> From:
Optiq has been developing steadily over the past few months. Those of you who watch github will know most of this already, but I thought I'd summarize what's been going on. (This post origi...
The last few months, I've been collaborating on a project with Chris Wensel , the author of Cascading . Last week we announced Lingual , an open source project that puts a SQL interface on top of...
http://julianhyde.blogspot.com/2013/02/announcing-lingual.html
YOUR BIRTHDAY involves presents and cake. The day after your birthday you are allowed to say "I am x", where x is the number of candles on your cake. 4TH OF JULY is the birthday of our countr...
http://julianhyde.blogspot.com/2013/01/explaining-holidays-to-3-year-old.html
I couldn't resist. When the Mondrian in Action book is published in the spring, it will look something like this... Artist's conception of the upcoming bestseller, "Mondrian in Action"
http://julianhyde.blogspot.com/2012/10/mondrian-in-action-in-action.html
I am delighted to announce an upcoming book all about Mondrian, called "Mondrian in Action". Some chapters are available in electronic form now, and the final print version is scheduled to hit ...
http://julianhyde.blogspot.com/2012/10/mondrian-in-action.html
The SQL that Mondrian generates is, until now, different than the SQL that most people would write by hand. Most people don't use spaces or punctuation in table and column names, and don't enclos...
http://julianhyde.blogspot.com/2012/06/pesky-quoted-identifiers-in-sql.html
With NoSQL and Hadoop, the database world has undergone a revolution. The fighting reached its peak a couple of years ago, but things have calmed down since, and now is a good time to take stock ...
http://julianhyde.blogspot.com/2012/06/from-ashes-of-database-revolution.html
This is a sneak peek of an exciting new data management technology. linq4j (short for "Language-Integrated Query for Java") is inspired by Microsoft's LINQ technology , previously only available ...
http://julianhyde.blogspot.com/2012/04/first-look-at-linq4j.html
I have been a fan of LINQ for several years (my Saffron project covered many of the same themes) but I've had difficulty explaining why it isn't just a better Hibernate . In his article “Why ...
http://julianhyde.blogspot.com/2012/04/data-oriented-programming-for-rest-of.html
Now that just about every data-management and business intelligence product claims that it handles "Big Data ", the term is approaching zero information content. So, I'm shorting the term "Big ...
http://julianhyde.blogspot.com/2012/04/big-data-is-dead-long-live-big-data.html
When evaluating queries, Mondrian sometimes needs to make decisions about how to proceed, and in particular, what SQL to generate. One decision is which aggregate table to use for a query (or whe...
http://julianhyde.blogspot.com/2012/04/how-should-mondrian-get-table-and.html
It seems that whenever I have a cross-continent flight, Mondrian gets a new feature. This particular flight was from Florida back home to California, and this particular feature is a time-dimensi...
http://julianhyde.blogspot.com/2012/02/auto-generated-date-dimension-tables.html
I am pleased to announce the release of olap4j version 1.0.1 . As the version number implies, this is basically a maintenance release. It is backwards compatible with version 1.0.0, meaning t...
http://julianhyde.blogspot.com/2012/02/olap4j-releases-version-101-switches-to.html
I checked in some architectural changes to Mondrian's cache this week. First the executive summary: 1. Mondrian should do the same thing as it did before, but scale up better to more concu...
http://julianhyde.blogspot.com/2012/01/changes-to-mondrians-caching.html
You may or may not be aware of the property mondrian.olap.SsasCompatibleNaming . It controls the naming of elements, in particular how Mondrian names hierarchies when there are multiple hierarchi...
http://julianhyde.blogspot.com/2011/08/how-mondrian-names-hierarchies.html
Marc Berkowitz wrote a blog post describing an application of SQLstream to power a seismic monitoring project that is a collaboration between several leading research institutions. The project...
http://julianhyde.blogspot.com/2011/07/real-time-seismic-monitoring.html
According to their press release , Yellowfin BI version 5.2 "includes a significant OLAP overhaul, with the introduction of OLAP4j and support for PALO, BW as well as enhanced connectivity for SQ...
http://julianhyde.blogspot.com/2011/06/yellowfin-bi-release-52-moves-to-olap4j.html
The Java collections framework is great. You can create maps, sets, lists with various element types, various performance characteristics (e.g. if you want O(1) insert, use a linked list), iterat...
http://julianhyde.blogspot.com/2011/06/roll-your-own-high-performance-java.html
I would like to remove the 'high cardinality dimension' feature in mondrian 4.0. To specify that a dimension is high-cardinality, you set the highCardinality attribute of the Dimension element ...
http://julianhyde.blogspot.com/2011/06/removing-mondrians-high-cardinality.html
I saw a demo last week of scripted user-defined functions in LucidDB , and was inspired this weekend to add them to Mondrian . Kevin Secretan of DynamoBI has just contributed some extensions t...
http://julianhyde.blogspot.com/2011/05/scripted-plug-ins-in-luciddb-and.html