Throughput, throughput, throughput - for many databases, this is the performance measure of importance. When you are working with a fixed number of IOPS but see mixed workload types, system health can be assessed through the average read and write operation size. In an ASM environment, we can query this information by ASM disk
How long does your Oracle RMAN backup take to complete? How does this vary over time? Are there patterns by week, week of month, or day of week? The gist below can help you evaluate questions like these. If you're interested in using R with Oracle more generally, check out this previous post
Back in 2011, I covered the relative performance difference of the most popular libraries for text processing in R and Python. In case you can't guess the answer, Python and NLTK won by a significant margin over R and tm. Text processing with R seemed simple on paper, but performance and flexibility limitations have
Back in March, I posted the slides to my talk at the Silicon Valley Reinvent Law event - Law's Future from Finance's Past. Last week, we posted the video online; you can watch below. Michael Bommarito - Law’s Future from Finance’s Past from ReInvent Law Channel on Vimeo.
As a consultant and advisor to many firms running on or investigating AWS, I find SSH host and key management to be a constant struggle. From IAM credentials to default OS logins, it's easy to lose time with constant lookups. What we'd really like is to get a custom SSH config file for AWS.
Live from ReInvent Law Silicon Valley, where I gave an Ignite-style talk drawing analogy to law's future from finance's past. Slides embedded below and video forthcoming:
Automating Oracle Database deployment with Amazon Web Services, fabric, and boto – SEMOP Talk, Feb 12, 2013
I'll be giving a talk tonight on automated Oracle database deployment at the SouthEast Michigan Oracle Professionals (SEMOP) Meetup Group. While I'll be following up on this post later, I wanted to share the slides and Github repository for participants to follow along: Automating Oracle Database deployment with Amazon Web Services, fabric, and boto from mjbommar Github
After a nice twitter conversation this morning, I finally got the impetus to release the source for my Congressional Bill Statistics data. You can find the source at this Github repository. I haven't taken the time to review licensing yet, but I won't be asserting anything more than CC3 Attribution on my code.
In many circumstances, you might want to connect R directly to a database to store and retrieve data. If the source database is an Oracle database, you have a number of options: ROracle RODBC RJDBC Using ROracle should theoretically provide you with the best performing client, as this library is a wrapper around the
Much of my time lately has gone into analyzing and trading products in the volatility complex. As a result, I regularly watch the VIX term structure for continuations or deviations from trend. To make analysis simpler, I've written some R code that rips the term structure off the CBOE VIX term structure page and