Importing tpc-h testdata into mongodb

As written in a former post, tpc-h offers an easy possiblity to generate various amounts of testdata. Download dbgen from this website and compile it: http://www.tpc.org/tpch/ now run ./dbgen -v -s 0.1 this should leave …

Importing large csv-files into mongodb

I wanted to import some dummy data into Mongo-DB to test the aggregation functions. I thought a nice source would be the tpc-h testdata which can generate arbitrary volumes of data from 1 GB to 100 GB. You can download …

Oracle exp export with full tns-string

Handling the oracle tns-names file can be a pain in the ass, especially if you don’t want to rely on it. For example you want a user to enter dynamically a connection with typical “host, port, sid, username, password” …

oracle day 2: datafile is missing

playing around with oracle the other day I added a new tablespace and thought it would be smart to put the corresponding datafile on my tmp-directory. At first everything worked fine, now some days later I wanted to …

oracle day 1: first steps with oracle

recently I am familiarizing myself with the Oracle Database and I want to share my first impressions with you. A good start seemed to me the free oracle-xe version. I started the install with this tutorial and everything …

Find slow-queries in MySQL

Often when a web-application seems slow it’s not (or not only) the parse time, but also or mayorly database speed. Most scripting-languages don’t act “intelligent” in parsing as it would be best for user experience, but …