jump to navigation

Friday Philosophy – Genial Greetings & Festive Fun December 23, 2016

Posted by mwidlake in Friday Philosophy, humour, Perceptions, Private Life.
Tags: , ,
2 comments

For many of us, today will be the last working day before the Christmas Break (unless you live in one of the many places that don’t celebrate Christmas, in which case ignore this post). So Merry Christmas everyone and Happy New Year!

My brother's "Christmas Card" to us this year

My brother’s “Christmas Card” to us this year

These good wishes are especially directed at those who have to be on call or actually working over the holiday period. It’s one of those blights of working in I.T. that there always needs to be a bunch of DBAs, Sys Admins, Network guys and others who can be called upon when the 7*24*365 systems we keep running decide to play up as soon as we stop looking at them. As I said this time last year, as I’ve never had kids I’ve ended up doing more than my fair share of holiday cover – but not anymore. So if you are one of those on duty over the next week or so, I hope the damned systems stay quiet for you!

As you’ve hopefully noticed over the years, I’m a stunningly intelligent person with a thorough understanding of people and I think I have the totally correct attitude towards Christmas. Traditionally it’s the time to gather together with family & friends – to play games you hate, argue about what TV you are not going to watch and see how many old family injustices you can resurrect and have a damned good argument about. Only these days I opt out of that and I see people before or after Christmas – as at Christmas nothing is open so you can’t escape to go and do interesting things or look at stuff with them (you argue less when you are at the Zoo or wandering around a castle). If you can’t take the tedium at home anymore during Christmas, the only option for going out is to go buy a sofa… or something similar

My brother and I particularly enjoy exchanging Christmas cards. To the left is our idea of a good Christmas card. No tinsel, no robins, not a Christmas tree to be seen and absolutely no sappy Christmas poems or messages. Bah Humbug 🙂

But I like to believe I think long and hard about Christmas presents. One year I’d noticed something that had been annoying my wife during the year so I addressed that problem with a Christmas gift. I bought her a new ironing board. The old one had been getting hard to put up. Ahhh, you should have seen the look on her face when she unwrapped it…

And we still have the ironing board!

And we still have the ironing board!

A couple of years later I really splashed out and got her a new set of top-of-the-range non-stick pans. Again, the reaction had to be seen to be believed… I can’t recommend enough buying your partner domestic items for the household.

My mother joins in by going into those shops that sell candles, ornaments and nick-knacks. She picks the worst one and buys it for me. I’ve had a “gnome sat on a mushroom” that was so hideous the cat would not go near it. It had the added appeal that, once it had been hidden behind a bush in the garden for a year, the cheap plastic perished from sunlight and crumbled into the soil. It’s what you want from a garden ornament…
A couple of years ago was the best from my Mum, it was a candle holder made of wood but that looked exactly like, well, a “present” a dog might leave you. Only once it had been sprayed with lacquer and polished. I was a little hurt when Sue suggested it might look good in the garage. In a box.

I can’t work out why but a few years ago my wife suggested we stop buying each other presents. Now we just spend time together, enjoying each other’s company. But she’s thoughtful, she insists I go and see my Brother for a few days over New Year. In Wales. Not at home. Every year.

Being serious, However you decide to spend Christmas, I hope you have a great time.

Advertisements

Taking Off One of my Community Hats – Oracle Scene December 19, 2016

Posted by mwidlake in Oracle Scene, UKOUG, User Groups, writing.
Tags: ,
2 comments

For the last couple of years I’ve been involved in “Oracle Scene”, the UKOUG magazine about all things Oracle. Click the link to see the current edition, which is free to view to everyone, member of the UKOUG or not.

I take of my OS deputy editor hat - and they give me one to keep :-)

I take of my OS deputy editor hat – and they give me one to keep 🙂

I first became involved by writing an article for Oracle Scene. In fact it was the first thing I’d written that was published by a third party. This led to me helping with content selection and then content sourcing and, before you knew it, I was deputy editor for Tech content – helping out the main Editor, Brendan Tierney. We were soon joined by Toby Price as deputy editor for Apps content and the three of us were aided and assisted by first Brigit Wells and then Karen Smith from the UKOUG office.

I’ve really enjoyed helping put together the 5 or 6 issues I’ve been involved in. As a deputy editor I help source content (i.e. hassle people to submit articles), take the feedback from the content review committee, help make the final choice of the articles (with of course a focus on the tech ones) and together we decide on the running order in the magazine and which articles get mentioned on the front cover. I’ve also helped copy edit a few articles, especially those written by people for whom English is not their first language. I find it somewhat amusing that I do this as I am dyslexic. However, the professional layout company we use pick up on the spelling errors I miss (or introduce!). I also hunt down and remove all incorrect uses of the term “premise” and American spellings where it is not a technical term (did I mention my OCD tendencies too?). For the previous issue (Autumn 2016) I took on most of the role as editor as Brendan was busy with his day job. That is one of the nice things about having a small team, you can cover for each other but it does not become “decision by committee”, which I am not at all a fan of.

However with some recent changes outside my Oracle community life (nothing bad, just changes) it’s time for me to take off some of my community hats, especially those that need a constant, regular input. So I’m having to hang up the OS deputy chair one. But to my delight, at the UKOUG Volunteers drinks at the annual conference, Karen, Toby and Brendan presented me with an “Oracle Scene retired deputy editor” baseball cap, which was really nice of them. So I take off a virtual hat and get to put on a real one.

I still intend to submit articles to Oracle Scene and I’d encourage all of you to consider doing so. It is one of the very few publications in the Oracle arena that is still physically printed as well as published electronically. You can get copies at any UKOUG event and there are usually some in each UK Oracle office. And if you are in the UK (or very close by) and would like to be involved in a small but fun team, ask me (or any of the OS team) about becoming a deputy editor for Oracle Scene.

And guys, thanks once again for the hat and the fun we have had doing this.

Friday Philosophy – Is a “Free Lunch” Only Ever a Mirage? Look Closer! December 16, 2016

Posted by mwidlake in ethics, Friday Philosophy, humour, Perceptions, Private Life.
Tags: , ,
3 comments

Nearly all of us have heard (or even used) the phrase “There is no such thing as a free lunch” and we know what it means – if something of value is provided for no up-front cost, you are paying for it in some other way. According to the Wikipedia entry for it the phrase could have originated from US bars that offered a free meal with a drink, but the meal was salty and so made you want to drink more. Now you know why some up-market bars offer free salty nibbles, it’s so they can sell you more beer and the extra profit is more than peanuts.

Milton Friedman wrote a book about the lack of cost-less consumables

Milton Friedman wrote a book about the lack of cost-less consumables

I recently saw a post in a discussion thread I was watching about business interaction which said “well, I think this is OK as there is no such thing as a free lunch”. It made me pause because I realised that there are free lunches.

Why? Because the person writing it, I know I could unexpectedly land in the airport near them (say we got diverted) at late-0’Clock, call them and say “could you please come and pick me up – and I’m hungry and I have nowhere to stay”. OK, it’s not lunch, it’s probably dinner or tea or supper. But I know I could do that and they would get me and feed me and make sure I was OK. Why? Because they are a friend. I’d get my free lunch and a free bed for the night – well, maybe a sofa with the dogs but, hey, am I picky? If things similarly went wrong the next month too, I feel I could again make the call and all I would get is some light-hearted banter about “this is becoming a habit!”.

The key difference is that business is not friendship. Business is all about making more money than you spend and if your company has shareholders, they generally want as big a dividend as possible. Making money does not match giving things away for free! Unless it is a short-term cost to prompt a larger eventual profit. Any business that does not aim to maximise profit is probably going to be less successful than a similar company in the same sector and will probably eventually fail {I know, there are rare exceptions to this}. I would argue that if your friendships are based on expectation of getting more out than you put in, you are living your life with the wrong philosophy!

You could argue that with friendship there is an expectation of reciprocation – if my friend landed at Stansted Airport and needed a bed and a meal and they let me know, they would get it. Heck, if they landed in Leeds airport (about 3 hours drive from here) they would probably still get it {if I was not too drunk to drive}. But no matter which of us had been the provider of the free lunch, I don’t think either of us would be walking around with a mental tally in our head saying something like “I need to get some payback from that guy – my next flight over there, I ain’t booking a hotel”.

I’ll give you another recent example. Another friend and I do a lot conferences, often in the same place. He is more organised than I and he has at times sorted out planes and hotels and just told me what I need to do, where to go and what I owe him. I pay him. Or I don’t and I pay for a meal or buy us beers or whatever it is we decide to do. We keep a rough tally. Hang on, didn’t I just suggest that friends don’t keep a tally? Well, we do. A rough tally. And the reason we both keep it is as we don’t want to take more than we give back – which is very different from ensuring we take back at least as much as we give. But the most interesting part of this is that last month, after I paid for a meal, I asked him what the balance was as I had lost track. He just looked at me and said “I have no idea – is it even?”. Who knows. Who cares? Part of me worries a little that I am in debt but I think he worries the same. In the end it is moot. Neither of us is counting anymore.

I’m sure we have all had the odd friend who does seem to take more than they ever give back (that Andy, never buys his round in the pub!) and if it is too extreme you might come to the conclusion that this is not a friend but a free-loader – and quietly drop them. But some people either just never think about it or might be a lot less well off than you and simply not want to admit it. And in the whole friendship scheme of things, reciprocation of favours should only ever be a part of it I think.

So in business I think the “no such thing as a free lunch” is pretty much a true state of affairs. In friendships, I’d like to think it is certainly not true. Friendship should not be like a business. If any of your friendships are, maybe they are more ‘mutual arrangements’.

“Hi, meet my mutual arrangement Dave. I’m currently up three beers on him, so he’s buying”.

So I think you can have a free lunch. They are provided by friends. I’ll be popping over to your place for one soon 🙂

Friday Philosophy – When Tech Fails to Deliver, is it Always a Problem? December 9, 2016

Posted by mwidlake in Architecture, development, ethics, Friday Philosophy.
Tags: , ,
11 comments

I nipped out to the local supermarket this lunch time to get stuff. I use one of those self-use barcode scanners to log all the goods I put in my basket (apart from the bottle of whisky I was stealing). I then go to the payment machine, scan the “finish shopping” barcode and try to pay. I can’t pay.

quickcheck-647x346-3col

I can’t pay as I bought some paracetamol (note to US readers, you know it as acetaminophen). It turns out you need to be 12 to buy paracetamol. Fair enough, but why did I have to stand there and waste 30 seconds of my life before the assistant for the area noticed and came over? She had to uses her special device to access the permissions screen, check I was 12 (the greying beard helps) and authorise it.

I asked why I had to wait. “So I can ensure you are old enough – the machine does not know.” But it does! Or at least it should. I’m using their self-scan service for which I have to be registered. They know my name, address, age, hair colour and inside leg measurement. The system knows I am old enough. Plus I have to pay with a credit/debit card (no cash option with this system). You can’t have a credit card until you are 18 in the UK so by using one of them it knows I am old enough to buy the pills – and even the bottle of whisky I was stealing. And when you use any card, it checks your details. So if I was using a debit card it could check my age at that point and stop me when it makes the check. It’s possible and should be done!

The assistant had wandered off long before I finished making this logical case. I was just an annoying customer and she’d done what I needed her to do. But it really annoyed me – it is possible for the system to check me using technology and the data at hand, and not make me wait. The problem is, they were too lazy to build this limited smarts into the system!

aberlour

There is a lesson here. And that lesson is this – I should stop being such a self-centred, argumentative and miserable old sod. Firstly, I had to wait 30 seconds (and I am probably exaggerating that). Big deal, I had hardly been inconvenienced and it was a lot quicker than going to a normal till. Secondly, the assistant can’t do anything about the software behind the system. I mean, many of us spend our lives working on computer systems and often we can’t make any changes. Thirdly, I am aware that some parents give their children their credit card & number (the idiots!) so even though it is illegal to do this, the result is there a lot of people under the age of credit who have the means to pay for dangerous things (booze, cigarettes, paracetamol, knives, DIY expanding foam, ‘Viz’ magazine…).

Just because something is possible with the data to hand, sometimes it is not really worth much effort to make it happen.

And sometimes, although it seems logical & sensible given all the parameters (they have my info, no one but me should be using that card) in the real world those rules and data associations are not reliable. There is no enforced RI on our lives, at best there is a set of intended/encouraged limits. A person checking my age is way more reliable than some algorithm in this case.

So next time I whine about waiting 30 seconds in the queue, I hope the assistant just gives me a withering look and tells me to grow up.

I also hope they do not check my basket for un-scanned booze.

(* Just for the record, everything about the whisky was untrue. It was gin).

((And being serious, such system prevent fraud by 2 methods.
The first is that 1 in X times you get re-scanned. The assistant has no idea if they scan anything you had not and this is on purpose – so there is no scene in the shop. But the comparison is made and recorded, for further action.
The second is that apparently they can spot likely cheats just by the data you give them when you sign up and your spending habits. Now that is ‘Big Data Analysis’.
))

UKOUG Tech16 Day 0 – Car and Curry Chaos! December 5, 2016

Posted by mwidlake in conference, humour, off-topic, Private Life, UKOUG.
Tags: , ,
1 comment so far

This year I decided to come to Birmingham a little early for UKOUG Tech16, coming up on the Saturday. I drove up to Lichfield where I grew up (15 miles North of Brum – which explains the touch of Brummie in my accent) in the morning to see my mum. Once we had discussed her various ailments and prejudices for a few hours and I’d unblocked her vacuum cleaner I set off into Birmingham to get to Jury’s hotel for 18:00. I was sure the shoppers would be pouring out of the city centre by then and it would be quietening down.

How wrong can you be! The A38 into the centre of the city was a crawl for the last 5 miles, with lots of random lane changes by people confused by the delights of inner-city town-bad-planning – or just frustrated enough to be attempting a freestyle game of “dodgem cars”. I know a sneaky way to get over to the back roads behind Broad Street and my hotel -but either the recent road changes have removed it or the density of traffic hid it from me, so I had to follow the herd.

When I finally got to the hotel – the car park was coned off. And there were dozens of cars circling the area trying to find anywhere to park, avoiding the hoards of revellers set on drunken debauchery who would lurch into the road at irregular intervals (usually going ” Wayheeeyyyy!” or “Heeheheheheheeeehehehee”). I put the car where I felt it would not receive a ticket in the near future and checked into the hotel. “Can you let me into the car park”. No. “I’m here for days!” Go park somewhere else. “Where?” I dunno, over that way somewhere. *sigh*

I decided to check out the car park on foot. There were 2 spaces on the top floor! So I got the car, whipped around to the entrance -and found some git in a blue car already removing the cones to sneak in. I tried to follow but the attendant came over and stopped me. “But I know there are spaces, I checked!”. He’d actually seen me do this and told me to try and take a ticket. It refused to give me one. It was not that the car park was physically full but the tech would not issue a ticket if it thought it was full. I started to back out and he stopped me. “Just wait – someone will leave soon” and he put the cones behind my car. Within 5 mins he was proved right, I got a ticket and went to one of my identified spots. Which was still empty. The blue car had been abandoned in an odd place…
I was very thankful to the attendant who had been so nice to me.

After that fiasco I dropped my stuff in my room and met Dave Roberts & Brendan Tierney in the Jury’s bar for a couple of relaxing pints. Relaaaaaxxxxx. Dave knew of a massive, £4M curry house that had just opened, about 2 mins up the road. It was 3 levels of basement. We decided to give it a go!

The establishment itself had curtains up at the doors -all away across the doors. You could not see in. Was it open? We approached the doors and it was opened for us. Inside was a swish reception area and three people to great us. 3? We asked for a table for 3. And they did that bloody annoying thing all posh restaurants that are up their own arse do.

“Does Sir have a reservation?”
“No”.
Pause, hard stare at us and in a cold voice “I will check if there is space for you….sir” (no capitals in ‘Sir’ anymore).

This check consisted of him wandering away for 5 seconds, coming back and saying “I think we can fit you in”. We were led down an odd tubular corridor, down through one floor that was obviously not yet in use, another floor that looked fully kitted out for diners and to the lowest floor with maybe 70, 80 tables in it. And less than 1/4 occupied. Veeeery full! So why the snotty attitude you tits?

So we sat down and quite soon one of the waitresses came over (there seemed to be about 1 for every 2 occupied tables) and she took a drinks order. She was not sure what beers they had but ho hum, the menu had them in. Then another of the under-utilised staff came and took our food order. Everything we asked for, she would look dazed and say “I really need to get used to these names” and we would have to point at the item in the menu. They were highly unusual items of Indian cuisine – such as a Lamb Korai or Chicken Tikka…. Hmmmm.

We chatted and sipped our beer. And chatted. And sipped. And chatted some more about ?how long? – and watched the table next to us get a bit short with waiting staff and the “man in charge” had to come over and appease them. And then he came over to us and asked if everything was OK. Brendan was a star “We ordered almost an hour ago so shall we just settle for the beers or are we likely to get any food soon?”.

Within 5 minutes we had our starers. The waitress came over and asked who was having the chicken and I said yes – and she gave me the fish. To be fair it was hard to tell as, like many up-market restaurants they were creating an “atmosphere” by keeping it too dark to clearly make out items on the table. But the added interest was that every couple of minutes or so the lighting would raise a little, only to dim again the next minute.

The starters were very nice, to be fair, and once we had swapped them around we enjoyed them. And the mains came soon after. Mine was too salty but other than that nice enough. But certainly not as nice as the price indicated it would be.

We ate the food and left, pausing on the way out to point out to each other the dust and poor finish in certain areas 🙂 It had been an entertaining evening but not for any of the reasons the restaurant would want is to remember it for.

We retired to the bar in Jury’s and enjoyed a couple of drinks with some other conference early arrivals before retiring at a reasonably sensible hour. Day zero was over and I felt ready for Super Sunday and the rest of the conference.

For tradition’s sake I left my cashmere jumper in the bar. I do it every year.

Friday Philosophy – Hello….?Dave? December 2, 2016

Posted by mwidlake in conference, Friday Philosophy, humour, Perceptions, UKOUG.
Tags: , , ,
8 comments

In 2 days time the UKOUG Tech16 conference starts. I love this conference, I’ve been to all but 1 one of them in the last 15 years – but I am not going to go on about why I like it so much again.

Gratuitous Minion Picture

Gratuitous Minion Picture

I’m going to tell you one reason I don’t like it. Names! Names of people I know. Names of people I have known for years and who I’ve seen and spent time with at many of the UKOUG Tech conferences. Yes, I have mentioned before that I am terrible with names (and all memory task to be frank) and I know others have the same problem. But for me, the annual UKOUG conference is particularly bad – and I’ve even started developing some anxiety about it.

Why is UKOUG Tech particularly bad for me?

  1. I’ve been going to it for so long I know many, many people there from prior conferences, some of whom I have met a dozen times now, had meals with, got drunk with… Let’s stop there.
  2. There are a lot of people there who I meet at other UKOUG events and other conferences. We have a LOT of speakers at this conference and I must know 75% of the database ones and half the others.
  3. As I present every year at UKOUG and now help organise the event, lots of people recognise me – but I don’t really recognise them!

That last point is an interesting one, it’s similar to when people who work in television met “the public”. Sometimes those members of the public assume they know the television personality – as they see them on TV so often. So when I present or chair a session people see me and are reminded who I am (I usually admit my name when I present). I might have spent time chatting to them so I DO know them – but with my memory and the fact that I do not have a regular reminder of their name, in my head they are either Dave or Sarah (if I can’t remember your name, mentally those are the names I give you. I can usually determine gender…).

One example is John Lancashire. I’ve known John for years & years, we get on really well. We always catch up with where we are in our jobs, what odd things have happened in our lives and the like. We had a chat on Facebook a couple of days ago and plan to meet up again this year at the conference. Only whenever I meet him for some reason I want to call him Richard or Patrick and I have to run through the counties of Northern England to try to remember his last name to trigger his correct first name. All the time I’m internally screaming “He knows I’ve forgotten his name! He knows, He’ll be offended!”.  Women seem to get particularly miffed if you get their name wrong. Maybe that is why, as a young man, I was utterly incapable of “chatting women up”. Name anxiety kind of makes you nervous.

So the name thing is particularly bad for me at UKOUG and part of the reason for this post is as an up-front excuse and to say “sorry!!!”

But the other reason for it is – I am not alone in this. Lots of us struggle with names and those who don’t probably can’t understand why we do – we just do!

So it would be really nice, everyone, if you could wear your badge so your name is easy to see. So not on your belt, not in your pocket and please try and not locate it near your groin or your breasts, as it unnerves people when I stare at them in those locations. I have to confess that I am a repeat offender for having my badge down by my crotch as, well, I’m short and the lanyards are long. I have to remember to shorten it. (The lanyard, not the crotch).

One thing I forgot to ask the UKOUG to do this year is do what the Bulgarian User Group do – make sure the name is on both sides of the badge. That really helps and the UKOUG ones seem to always spin to the none-name side.

So if I meet you at a conference and I look panicked, it’s probably name-anxiety. And if I call you Dave or Sarah you know exactly why. What’s bad is when I meet a Dave and call them Patrick.

Why oh Why Do We Still Not Have a Fast Bulk “SQL*Unloader” Facility? December 1, 2016

Posted by mwidlake in Architecture, database design, performance.
Tags: , , ,
6 comments

Way back in 2004 I was working at the UK side of the Human Genome project. We were creating a massive store of DNA sequences in an Oracle database (this was one of two world-wide available stores of this information, for free & open use by anyone {* see note!}). The database was, for back then, enormous at 5-6TB. And we knew it would approx double every 12 months (and it did, it was 28TB when I had to migrate it to Oracle 10 in 2006, over 40TB 6 months later and grew to half a petabyte before it was moved to another organisation). And were contemplating storing similar massive volumes in Oracle – Protein, RNA and other sequence stores, huge numbers of cytological images (sorry, microscope slides).

I did my little bit to work out how we all tick

I did my little bit to work out how we all tick

Significant chunks of this data were sometimes processed in specialist ways using Massively Parallel Processing farms (hundreds or thousands of compute nodes so we could do “2 years of compute” in a day or even a few hours). Oracle was never going to be able to support this within the database.

But Oracle had no fast, bulk data unloading offering, a “SQL*Unloader”. Other RDBMSs did. And that gave me an issue. I had to argue as to why hold this data in Oracle where it was hard to yank out chunks of it rather than keep it in say a simple file store or MySQL?

That year I was invited to Oracle Open World and I was given a slot with a senior VP in the RDBMS/OCFS area (as that is what were using – I know! But we were). I had been warned by someone that he could be a little “robust”. In fact my friend called him “Larry’s Rottweiler”. However my chat with the SVP went fine. Until he asked me for the one thing I would really want and I said “well, it’s been promised for the last 2 or 3 versions of Oracle, but it still does not exist in V10 – I’d like a SQL*Unloader so we can rapidly extract bulk data from Oracle into a structured file format”. He went very cold. I continued: “We need to do really intensive processing of the data with ‘C’ and if it is locked into the database we can’t do that. It’s hard for me to justify using Oracle as our primary data store if the data is now stuck there…”

I honestly thought he would bite!

I honestly thought he would bite!

He went ballistic. He was furious, he was raising his voice, leaning forward, I honestly thought he might hit me. I can’t remember the whole rant but one line stuck: “We will NEVER help you get your data out of Oracle!”. I ended the discussion as soon as I could – which obviously suited him fine also.

And here we are over 10 years later and no SQL*Unloader has appeared. And, as far as I can see, there is no longer even a suggestion that “one day” one will exist. You can obviously get data out of Oracle using SQL*Plus, SQLcl or PL/SQL’s UTL_FILE. But you have to write your own code and to make it parallel or fast is not that simple. And there are some commercial tools out there to do it. But fundamentally we do not have a simple, robust & fast data unloader tool within the Oracle toolset.

But I remain mystified as to why Oracle Corp will not provide a tool to do this. I can see the argument that doing so would help you migrate your Oracle Data set to a different platform and thus move away from Oracle, but I think that is a dumb argument. If you are willing to dump your Oracle environment for something else you are already not happy – and making life difficult is only going to make you less happy and almost certain to never come back! It’s incredibly inconvenient to extract all your data at present but compared to the cost to your organisation of changing a central part of your infrastructure, it’s just a bloody annoyance. It’s like domestic service providers (telephone, internet, TV) that make it easy for you to sign up but a nightmare to leave. Thus guaranteeing that once you leave (cos you will) you will certainly NOT be going back to them in a hurry!

So for the sake of what I see as a misplaced protectionist stance they close the door to rapidly extracting data from Oracle databases for processing in other ways. I’ve come across other situations like this, before and since, but the Human Genome issue threw it into sharp relief for me. The end result I’ve seen a few times (and effectively what we had at the Sanger) is the data gets stored at least twice – once in Oracle and then somewhere else where it is easy to access. Now that’s a daft and bad place to be, multiple copies and one of them at least lacking RI. Thanks for forcing that one on us Oracle.

Something that is changing is Cloud. Oracle wants us all to move our data and systems into the sky. Their whole marketing message at the moment is nothing but cloud-cloud-cloud and they give the impression that cloud is in fact everything, every solution. So how do you get 10TB of data into the cloud? It’s not so hard really. You can trickle it in over time, after all networks are constantly getting faster, but for bulk data this is a poor solution. Or you can ship your data physically. You can’t beat the bandwidth of a transit van. I’ve heard Oracle people at OOW and other conferences saying this is easy-peasy to arrange (as it should be, I’ve done it for clients doing migrations a couple of times).

But how are you going to get it out again? How well do you think that a company that has never provided SQL*Unloader is going to help you get bulk data back out of your Oracle cloud-based databases into on-premises systems? And how well are they going to help you shift it from one of their systems to another cloud system? One they have not sold you? Sometimes people talk about business relationships being like a marriage. Well once you gave gone cloud, you might have ensured any divorce is going to be really messy!

Update – see the comment by Noons on the fact that VLDBs and Data Warehouses are often not as static as you think – so there can be a constant need to move a lot data into and out of such very large data stores. Cloud is not currently going to support this well. And if you have a data life-cycle management policy, say archiving off data 3+ years old. Where are you archiving it off to and how will you do this once it is in the web?

* Please note, this was not human DNA sequence information gathered for medical reasons! It was mostly sequence information for other organisms (chimps, flies, potatoes, rice, viruses, bacteria all sorts) generated by the scientific and, in some cases, biopharma community. There was human DNA sequence in there but by consent and anonymised – you can’t have a human genome sequence without involving some humans! We did not hold your Dodgy Uncle’s DNA test that was taken for that court case…