Category Archives: DBA as a Service

Standard Edition Community – DOAG &UKOUG Conference


Standard Edition Community Represented at Conferences

As an Oracle Standard Edition Advocate, I feel privileged to say, that after many discussions and many blog posts, Standard Edition Database is getting its well deserved spot in the sun, and the Standard Edition Community is starting to speak and socially discuss its role, opportunities, and challenges in the IT society.

Birmingham 7th-9th Dec

Tech15_ResourcePk_ISA_v1This year UKOUG Conference has decided to dedicate a whole day/track (7th Dec 2015) especially for Standard Edition Database. This is the first time ever a conference has done so. If keen to know the reasons why this conference made such decision, please read about this on my blog. But below is a small part from that interview:

Since this is the first conference in history, that has dedicated a whole day to a Standard Edition Track, could you please tell us the database team reasons for having this track?

Martin: Standard Edition is used by a large number of UKOUG members (and non-members), either because there has been a decision to only licence SE to reduce costs or because they have SE databases as part of the whole mix of Oracle systems within the organisation. SE has it’s own challenges, mostly due to the lack of certain options and technologies such as Partitioning, Data Guard and many of the security features. There are ways to work around these issues but there are few presentation given that address them. Joel Goodman (a highly respected Oracle trainer and presenter who is part of the database committee) initially raised the need for such talks to support what is often an under-represented part of the community and we were happy to support it within this year’s conference.
Joel: I attended Harmony 2014 and saw the interest there in SE. I also help to organise the Oracle University Expert Summits and in the London 2014 summit attended by about 50 people.
Of those over 30 of them either used or supported Standard Edition for at least some of their databases. I realised then that UKOUG should be addressing that audience, so proposed this to the committee at the kick-off meeting for planning Tech15. The committee accepted this suggestion immediately, agreeing that there is a large SE community for whom there has not been a conference before and that we should be the first to do so.

In Birmingham I will have two presentations, plus one Standard Edition Roundtable. Please see below, there are lots of good presentations in this track! Here is the whole UKOUG agenda.

Official Standard Edition AGENDA – 7th of December:

  • 09:00 – 09:50 “Oracle Standard Edition is Awesome!” – Tom Dale – Fivium
  • 11:20-12:10 “Standard Edition Something for the Enterprise?” – Ann Sjökvist
  • 12:20 – 13:10 “Looking for Performance Issues in Oracle SE – Check what OraSASH Can do for You” -Marcin Przepiorowski – Delphix
  • 14:10 – 15:00 – “Silent but Deadly : SE Deserves Your Attention” -Philippe Fierens – FCP
  • 15:10 – 16:00- “Max Protection Standby in Standard Edition RAC Environment” -Eter Pani – TSYS International
  • 16:30 – 17:20 – “SE DBA’s Life a Bed of Roses?” – Ann Sjökvist
  • 17:30 – 18:20 – “A Manly Man’s Guide to Open-Source Database Tuning Tools: Life Without EM12c” – Bjorn Rost
  • 17:30-18:20 – “Oracle Standard Edition Round Table” – Joel Goodman – Oracle Co-presenter(s): Ann Sjokvist (also:Philippe Fierens, and Jan Karremans)

DOAG Conference 17th-20th November

I just received the acceptance letter from DOAG conference team, so the Standard Edition Community will also be represented in Nuremberg. I have not yet seen the agenda, but I am sure other people who supports Oracle Standard Edition Database will be there.

Keen to make Standard Edition Community even bigger?

Can we rock the boat like APEX Community has done in the past months?

Join the Standard Edition Community lovers at both DOAG conference in Nuremberg (17th-20th Nov) UKOUG TECH15 in Birmingham (7th-9th Dec). Book your tickets as soon as possible!

Take care, stay well and let’s enjoy the summer!


Turku, Finland 22 July 2015

Engage Big Data in Standard Edition

bigdata_5v  No need to hesitate

Time to Engage Big Data in Standard Edition

Last week I asked “Big Data in Standard Edition Seriously” and after one week of studying at EMC Education Centre, I truly believe that smaller companies should start to embrace the opportunities that this technology can bring.

When asking different people the question “What is  Big Data?“,  many different explanations will be provided. But the one I received from EMC Education Centre, opened my mindset about the Big Data concept:

Big Data is really about ANY attribute that challenges the constraints of a system capability or business need

It’s not only about size – examples

spreadsheetI have a 50 MB spreadsheet document that I cannot share it with my colleague via e-mail or a shared storage due to limitations of space – I just bumped into the “challenge of a system capability”

marketingMy CMO assistant made a 1,1TB marketing ad, that cannot be displayed remotely in real time to the board of Executives – once again, I just bumped into the “challenge of a system capability”

timeglassMy CMO came up with a new service, and a new 1PB marketing video need to be edited and rendered, but the Editor’s job is interrupted due to lack of resources on his computer – once again, I just bumped into the “challenge of a system capability”

So to my understanding, at all three examples we are facing “Big Data”.

One other thing that EMC Education pointed out to me, is :

“How Can We Get Closer to Big Data & Start Taking Advantage of it?”

That question I think, is not an exclusive property for big enterprises , but also applicable to smaller companies who is running their applications on an Oracle Standard Edition Database environment.

Since I am a novice on Big Data, and in the beginning of my learning path, I asked one of the instructors Barry Heller about his thoughts on how a small company could start to use their “Big Data”, to grow their understanding and sees the opportunities of the insight such analyse will bring:

  • what new services should they implement?
  • how to grow their business?
  • do we need to change our processes or create new ones?

Advices from the expert Barry Heller (c)

  • identify one pain point or opportunity within a company and produce a quick win.
  • Possible projects may be to build a
    • recommender system,
    • reduce customer churn,
    • identify upselling
    • cross-selling opportunities
  • For statistical analyses
    • the R programming language is a great place to start.  
    • the Apache Hadoop ecoystem is great place to start for
      • storing
      • processing
      • analysing Big Data.  

Beyond the technology, another important aspect is how the project will be staffed; small companies may not have the expertise in-house.

Thanks Barry for guidance, and to me, this sounds like an opportunity to all companies running an Oracle Standard Edition Database; Big Data is available to all business – it’s not about the size.

So why not start thinking about transforming your data to the next level, and look into new business options/possibilities?

Even as a novice, I must say THAT would be a great challenge to have a Standard Edition Database Environment, and start a Big Data project, to find new opportunities of any kind to the company!


Take care, stay well and enjoy this Monday!

– Ann

Turku 18th May 2015