Domain: pentaho.org
Stories and comments across the archive that link to pentaho.org.
Comments · 13
-
Re:Our last Pentaho experience....
With access to Pentaho's knowledgebase and support you would have had first class support and access to a wealth of documentation.
Some of this documentation is available on Pentaho's open wiki: http://wiki.pentaho.org/
-
Re:Enough acronyms?
The worst part is that even if you google Kettle and get to their website, the front page for their product is a essentially a changelog and roadmap. There are FAQ links but even the "Beginners FAQ" (which should be "WTF is Kettle?" style Q&A) is a product troubleshooting guide.
I suspect that the same secrecy-obsessed person that built the product website also wrote this review -
Re:Enough book reviews?
I'm going to expand on this one a bit. When it said data integration, I immediately found out that ETL might be Extract, transform, load. The only reason I know this is because I work for a TLA type company. Kettle seems to be the name of something that already has a name, "Pentaho Data Integration". I'm not sure why it has two names. It is also part of the Pentaho BI suite.
A good review would give us a link to this tool, so we can figure out if the book is even relevant. Otherwise the assumption is that everyone knows what it is an everyone is using it. http://kettle.pentaho.org/ There's a FAQ which deals with usage, not what it's about, and no overview. So despite finding the website myself I still have no idea what this thing does. Does it solve the problem of exporting data from MS SQL Server and re-loading it somewhere else? Cos that's what I need.
A good review would also indicate if it's a free and/or open source tool, so we can decide if we're even interested in the tool, let alone the book. The source is available and hosted on sourceforge, so that answers that. But there is a separate link under Products for PDI, with links to Buy. Is this a poor attempt at a slashvertisement? Why would I use kettle instead of PDI? Is there a difference? http://www.pentaho.com/products/data_integration/
A good review would also identify the audience of the book, letting people know who might use it. It's a datbase tool - if I'm a Microsoft shop would I have any interest in reading about this?
-
Re:MySQL's future
OK, recently (8.3?) I have tried to test postgres with bulk query loading. Something similar to this, not exactly identical: http://forums.pentaho.org/showthread.php?t=72863 To make the long story short, the performance was not the best I have seen. Why do I need the bulk loader? Well, we have an app where people like to load large amount of numbers and text. So, it is the easiest way. Maybe I should blog them one day...but where can I find time?
-
Copy the data
Seriosuly, download Kettle http://kettle.pentaho.org/ and create a transformation of the required data only into a new DB on a seperate server (while you are at it, make it a star or snowflake schema). Give them all the access they want telling them that the data will be updated regularly but is not live. If you need live data, I think Oracle has a product that creates a direct image of the DB live (i.e. one row changes in DB1, changes in DB2 etc). I think this is expensive though (isn't Oracle always?). Karem
-
Beekeeper Model
Sounds like you want to convert your "amateur" OSS "project" into a "professional" OSS "product". Checkout The Beekeeper Model
-
Blargh! Mondrian is already an open-source OLAP
Blargh! Mondrian is already an open-source OLAP engine! Seriously, a casual google search could tell you that. And it's not some sf.net abandonware, it's a mature and powerful OLAP Cube engine used by some big-name corps!
Oh, and just to rant a bit more: Python WAS ALREADY THE NAME of the Lisp Compiler used in the CMUCL Common Lisp implementation and lately SBCL. And was relatively well known in computing science at the time Guido was naming python because it is a snazzy type inferencing lisp compiler!
Guido's some sort of naming-dick. What'll he call his next python project? Glibc? Mesa? Gimp? -
A prominent example: Pentaho
Pentaho, the Open Source Business Intelligence Suite is a very prominent example of this new approach on development. It consists of well-known projects like JFreeReport, JFreeChart, Jasper, Kettle, Mondrian and others.
What the Pentaho guys do beyond marketing is writing glue code and user-friendly development tools. They also usually hire the project owners after incorporating a new project. -
A prominent example: Pentaho
Pentaho, the Open Source Business Intelligence Suite is a very prominent example of this new approach on development. It consists of well-known projects like JFreeReport, JFreeChart, Jasper, Kettle, Mondrian and others.
What the Pentaho guys do beyond marketing is writing glue code and user-friendly development tools. They also usually hire the project owners after incorporating a new project. -
A prominent example: Pentaho
Pentaho, the Open Source Business Intelligence Suite is a very prominent example of this new approach on development. It consists of well-known projects like JFreeReport, JFreeChart, Jasper, Kettle, Mondrian and others.
What the Pentaho guys do beyond marketing is writing glue code and user-friendly development tools. They also usually hire the project owners after incorporating a new project. -
Shameless Weka PlugSo I can already anticipate people being concerned about their identities being tracked through clicks online.
You don't have to worry about this, however, as it is easy to distinguish two different users but probably difficult to pick you out of a crowd. Furthermore, if they're tracking your clicks, they probably already know your IP address. The number of sessions probably raises to a problematic number if you are trying to identify one user out of one thousand. Therefore, this will only be useful in identifying different behavior between two users -- or specifically identifying when it is highly likely that someone who is logged in is significantly different from the click profile associated with that account (as the article states).
There's a lot of discussion about this in the paper. Mentioning that the priors are set at 50% for 2 users but at 1% for 100 users (obviously). And also that:In an experiment involving 42 user profiles, Monrose and Rubin (1997) shows that depending on the classifier used, between 80 to 90 percent of users can be automatically recognized using features such as the latency between keystrokes and the length of time different keys are pressed.
They go on to say that the method they suggest for detecting a fradulent user "do not require that users have truly unique profiles."
I read a bit of the paper and I identified Weka's decision tree method being used to classify the users (if you've ever used the ID3 algorithm or its brethren C4.5 in classification, imagine exploring methods of developing different decision trees).
Indeed the paper states:We chose weka's J4.8 as the classifier since classification trees in general have been shown to be highly accurate classifiers.
I'll take this opportunity to recommend two open source projects. Torpark for those of you concerned about your identity and also Weka -- the easy to use collection of data mining software in Java! Also something to note is that Weka has recently become part of Pentaho, a project of open source business intelligence products. Explore the valuable tools that are out there and enjoy! -
And now, something completely different....
I don't know, in my line of work (Data Warehousing) where I need to move around large amounts of data, no amount of tuning beats a large amount of spindles.
In that regard, I find the new advances that MySQL is making on table partitioning (http://dev.mysql.com/doc/refman/5.1/en/partitioni ng.html ) in their 5.1 beta VERY interesting.
[warning: shameless plug ahead!]
If you combine this with my own Free/free open source ETL tool Kettle (http://www.kettle.be/ ) you can build your data warehouse just as fast or faster than most commercial ETL tools.
The deal then becomes very simple: spend the money you save on licensing on hardware! You'll be amazed at the results...
Oh, and try the Pentaho (http://www.pentaho.org/ ) open source BI solution while you're at it...
Cheers,
Matt -
Open Source Solution
I have looked fairly extensively for a nice open source version of a workflow type program. One that I am currently watching is http://pentaho.org/. This is a very impressive package of not only workflow but business intellegence and reporting.