database Archives - Bommarito Consulting

Built to Sell: Finance

Your company’s finances are the most quantified part of your business, so when it comes to due dil...

by Jillian Bommarito

Built to Sell: Taxes

We’re going to be up-front with you here: it’s time to talk taxes. Don’t run away yet, unless ...

by Jillian Bommarito

Built to Sell: HR

People are the metaphorical lifeblood of any company. Perhaps it’s no coincidence then that ...

by Jillian Bommarito

Built to Sell: Legal

Entrepreneurs are often portrayed as rule-breaking rebels who have a great new idea to introduce to ...

by Jillian Bommarito

Built to Sell: The Blueprints

Imagine your company five to ten years down the road: what does it look like? Do you see a well-run ...

by Jillian Bommarito

Since our Last Episode

The Internet is awash in posts looking back on 2018, but over here at Bommarito Consulting, we decid...

by Jillian Bommarito

Course material for Complex Systems 530 – Computer Modeling for Complex Systems

This term, I’m teaching Complex Systems 530 – Computer Modeling for Complex Systems a...

by mjbommar

Predicting the Supreme Court

One of the more exciting and public projects we’ve been working on lately has finally come ...

by mjbommar

Advanced approximate sentence matching in Python

In our last post, we went over a range of options to perform approximate sentence matching in Python...

by mjbommar

Fuzzy match sentences in Python

Let’s imagine you have a sentence of interest. You’d like to find all occurrences of t...

by mjbommar

Isotonic Regressions in scikit-learn

Isotonic regression is a great tool to keep in your repertoire; it’s like weighted least-squ...

by mjbommar

Featured in Wired: Measuring the Complexity of the Law

Thanks to Sam Arbesman (@arbesman) for featuring Dan and my paper, Measuring the Complexity of the L...

by mjbommar

Is there tax in the cloud?

Do you contract for IaaS, PaaS, or SaaS services like Amazon Web Services or SalesForce? Do you pr...

by mjbommar

Benchmarking the new AWS Postgres RDS instances

Postgres has finally come to RDS! Want to know how these instances stack up on a naive pgbench tes...

by mjbommar

Monitoring AWS VPC tunnels

While many Amazon Web Services resources with “state” have CloudWatch sensors available,...

by mjbommar

Automating Oracle ORION I/O testing

Oracle ORION is a powerful tool for evaluating realistic OLTP and DSS/DW I/O performance. ORION sh...

by mjbommar

AWS EC2 hs1.8xlarge Oracle ORION benchmark results

Benchmarking I/O with Oracle ORION is an important part of planning, baselining, and performance-tun...

by mjbommar

ipython notebook for R: Quickstart for Ubuntu

If you’re like me, you love ipython notebook but often write R. RStudio’s integrated R...

by mjbommar

Is the Tax Code the longest Title?

Last week, I shared that Dan Katz and I had finally published a draft of our paper, Measuring t...

by mjbommar

Measuring the Complexity of the Law: The U.S. Code

Four years ago, Dan Katz and I began working on a project to measure the complexity of the law. �...

by mjbommar

Plotting average read and write operation size by ASM disk for Oracle

Throughput, throughput, throughput – for many databases, this is the performance measure of...

by mjbommar

Plotting Oracle RMAN backup durations with R

How long does your Oracle RMAN backup take to complete? How does this vary over time? Are the...

by mjbommar

Revisiting text processing with R and Python

Back in 2011, I covered the relative performance difference of the most popular libraries for tex...

by mjbommar

Law’s Future from Finance’s Past: Recorded Talk from Reinvent Law Silicon Valley

Back in March, I posted the slides to my talk at the Silicon Valley Reinvent Law event – Law&#...

by mjbommar

Generating SSH config from AWS hosts using boto

As a consultant and advisor to many firms running on or investigating AWS, I find SSH host and ke...

by mjbommar

Slides from ReInvent Law Silicon Valley Talk

Live from ReInvent Law Silicon Valley, where I gave an Ignite-style talk drawing analogy to law&#821...

by mjbommar

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 Michig...

by mjbommar

Git Repository for Congressional Bill Statistics

After a nice twitter conversation this morning, I finally got the impetus to release the source f...

by mjbommar

Connecting R to an Oracle database with RJDBC

In many circumstances, you might want to connect R directly to a database to store and retrieve data...

by mjbommar

Retrieving the VIX term structure in R

Much of my time lately has gone into analyzing and trading products in the volatility complex. ...

by mjbommar

Natural Language Processing and Machine Learning for e-Discovery – Slides from guest lecture at MSU College of Law

Fellow Computational Legal Studies blogger and MSU law prof Dan Katz invited me to give an expert...

by mjbommar

Oracle ORION I/O benchmark results for AWS EC2 hi1.4xlarge instance type

In a typical Oracle database implementation, you’ll want to baseline or benchmark your stor...

by mjbommar

Debugging parameter mismatch across RAC database instances with R, dba_hist, and gv$parameter

Did you find this post useful? Does your organization need Oracle services? We can help. Much...

by mjbommar

Legal Informatics with AWS CloudSearch – Slides for tonight’s AWS Michigan meetup

Tonight, Eric and I will be presenting back-to-back talks at the AWS Michigan meetup (hosted by t...

by mjbommar

Wordcloud of the Healthcare/ACA (NFIB v. Sebelius) Opinion

Here’s a wordcloud of the NFIB et al. v. Sebelius et al. opinion. Very interesting coalition...

by mjbommar

Wordcloud of the Arizona et al. v. United States opinion

Here’s one purely for fun – a wordcloud built from the Supreme Court’s opinion on ...

by mjbommar

Summary of community detection algorithms in igraph 0.6

Based on Launchpad traffic and mailing list responses, Gabor and Tamas will soon be releasing igr...

by mjbommar

Building Python pandas from development source

I first heard about Python pandas from a friend at RenTech or AQR in the early summer of last yea...

by mjbommar

OTM in the Cloud: Hosting Architectures, Part 2 – 1+RDS

In our last post on cloud architectures, I covered a simple one-node Oracle Transportation Manage...

by mjbommar

Grexit stage left: visualizing the online discussion around Greece’s possible Euro exit

While Tsipras and his Syriza coalition have been busy in Greek parliament, the Internet has been ...

by mjbommar

Oracle Transportation Management (OTM) in the Cloud: Hosting Architectures, Part I – Single Node

As I mentioned on Monday, I’ll be starting a series of posts on Oracle Transportation Manag...

by mjbommar

Upcoming Series: Oracle Transportation Management (OTM) in the Cloud

I wanted to update readers to let them know of an upcoming post series on Oracle Transportation M...

by mjbommar

Visualizing the #nonato Twitter hashtag – time series and top users

The NATO summit is currently being held in Chicago, and, as is typical for NATO or G# summits, th...

by mjbommar

Charting Twitter time series data with tweet and unique user counts

Let’s say you’ve used my Python script to automate the download of a hashtag or search p...

by mjbommar

eDiscovery Consulting in the Cloud: Searching an Outlook mailbox and attachments

You may have noticed that I keep talking about eDiscovery consulting and legal search in the clou...

by mjbommar

Down with the static

After six years of static HTML, it finally became apparent that this site needed a real CMS. Pleas...

by mjbommar

Generating AWS CloudSearch SDF for Emails

In my last post on CloudSearch and eDiscovery, I described something like “Google” fo...

by mjbommar

“Google” for subpoenaed emails: AWS CloudSearch for eDiscovery

In the last post on AWS CloudSearch, I provided a tutorial on the creation of a simple CloudSear...

by mjbommar

Building an AWS CloudSearch domain for the Supreme Court

It should be pretty clear by now that two things I’m very interested in are cloud computing...

by mjbommar

Visualization of Reading Level Frequency by Congressional Bill Stage

Here’s a fun example of how you might use my data on Congressional bill length and complexi...

by mjbommar

Updates to data and statistics on Congressional bill complexity

When I put together my original post on the length and complexity of Congressional bills, I was h...

by mjbommar

Installing AWS Cloud Search Command Line Tools

In case you’re too lazy to dig into the full CloudSearch developer guide, here’s a qu...

by mjbommar

Updated Michigan Compiled Laws (MCL) XML

Last August, I released an XML copy of the Michigan Compiled Laws (MCL). As an example of what ...

by mjbommar

Statistics on the length and linguistic complexity of bills

Where would you go to find out what the longest bill of the 112th Congress was by number of secti...

by mjbommar

Hash collision attacks hose Oracle Transportation Management

Ars had a great write-up a few weeks ago about the huge hash resource starvation attack that was un...

by mjbommar

Visual Summary of #jan25 Twitter Activity

Last year, I covered a number of the so-called “Twitter protests” in China (#cn220), ...

by mjbommar

Network of foreign key constraints in Oracle Transportation Management

If you’ve ever worked under the hood with OTM, you’ll know that there’s some pr...

by mjbommar

Debugging ORA-02292: integrity constraint (OWNER.CONSTRAINT) violated – child record found

Did you find this post useful? Does your organization need Oracle services? We can help. W...

by mjbommar

Saving memory in redis and python with struct.pack

In redis, every object is either a binary-safe string or collection thereof. Even if you’...

by mjbommar

Building, configuring, and benchmarking redis from Github source

Part of blogging for myself is making notes about process that may or may not garner a wide audie...

by mjbommar

Blogging for myself, not you.

In between writing the wrong year on documents, I’ve been reflecting on this blog. Specif...

by mjbommar

Building Legal Language Explorer: Interactivity and drill-down, noSQL and SQL

Dan and I recently released a new legal informatics project with a few colleagues. The project, ...

by mjbommar

21st Century Legal Informatics: Part 1, Introduction

Dan and I have written and spoken on legal informatics many times. Inevitably the...

by mjbommar

Single HTML File of the Michigan Compiled Law (MCL)

Last night, I posted a copy of the Michigan Compiled Law (MCL) as an improved and structured X...

by mjbommar

XML Copy of the Michigan Compiled Law (MCL)

A few weeks ago, Ari Hershowitz posted on Quroa calling for a Californa code hackat...

by mjbommar

Building igraph’s Python bindings with plotting support on Ubuntu

igraph is my preferred library for graph manipulation. The core library is written in C and is...

by mjbommar

Natty Narwhal on the Precision M4600

Since there are always questions of support for newly released models, I thought I’d put up a ...

by mjbommar

More monitor fun with Natty Narwhal – rotating one screen

After struggling with Natty’s multiple monitor support last week, I thought I’d t...

by mjbommar

Multiple Monitors on Natty Narwhal

Have you been infuriated by Natty Narwhal’s poor/broken support for multiple monitors (#1, #2,...

by mjbommar

Electronic World Treaty Index and Tax Court Appendix

I’ve been busy lately with my new day job and wedding planning , but Dan and I still managed t...

by mjbommar

Historical data mining the Supreme Court headnotes

Two weeks ago, I posted a pair of very rough working papers. The second of these, E...

by mjbommar

Slides from my talk at the University of Houston, Law and Computation Workshop – Law ? Computation

I’ve uploaded the slides for my talk today at the University of Houston Computational Law Conf...

by mjbommar

Two new papers on SSRN: Measuring EU integration through sovereign debt & Exploring relationships between headnotes in the Supreme Court

What do you do with that unfinished paper? You know, the one that’s 50%&nbsp...

by mjbommar

Paper: Quantifying and Modeling Long-Range Cross-Correlations in Multiple Time Series with Applications to World Stock Indices

Here’s another econophysics paper from H. Eugene Stanley and crew: D. Wang, B. Podobnik,...

by mjbommar