Infrastructure at your Service

dbi services BLOG

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

Franck Pachot

Modern software architecture – what is a database?

By | Database Administration & Monitoring | 2 Comments
 

 This blog post is focused at developers and software architects. I’m probably not writing at the right place. You’re on an infrastructure experts blog and the author is an Oracle DBA. So what can you learn from someone working on that 30 years old technology talking about that old SQL language ? You run with modern languages, powerful frameworks, multi-layer architecture, micro-services, distributed database and of course all open-source. You hate your DBA because he…

Read More
Clemens Bleile

Oracle Open World 2016 – Day 4 and 5

By | Database Administration & Monitoring | No Comments
 

 At the end of Oracle Open World my last BLOG concerning OOW 2016 covering day 4 and 5: Wednesday is the day of the Party: Oracle’s appreciation event, a concert with Gwen Stefani and Sting at the AT&T Park (Stadium of the San Francisco Baseball team, the Giants). It was a great event with awesome musicians. Before the party I visited the session “Oracle Active Data Guard: Power, Speed, Ease and Protection” provided by Larry…

Read More
Saïd Mendi

MySQL 8.0.0 DMR – First impression

By | Database management | One Comment
 

 Last week (09/12/2016) was announced the new MySQL 8.0.0 DMR (Development Milestone Release) It is now available for download at dev.mysql.com I downloaded and installed it Following are my first impression on some new features First of all, when you remember the size of earlier versions, it is more & more gluttonous, see below mysql-5.0.96-linux-x86_64-glibc23.tar.gz    121.2M mysql-5.1.72-linux-x86_64-glibc23.tar.gz    127.8M mysql-5.5.52-linux2.6-x86_64.tar.gz            177.2M mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz    299.7M mysql-5.7.15-linux-glibc2.5-x86_64.tar.gz   611.8M mysql-8.0.0-dmr-linux-glibc2.12-x86_64.tar.gz is around 1Gb and uncompressed 3.6Gb (Oups…) At…

Read More
Clemens Bleile

Oracle Open World 2016 – Day 3

By | Database Administration & Monitoring | 2 Comments
 

 On day 3 I visited various sessions about In-Memory and its many new features in 12gR2. Yesterday I already listed some new features of In-Memory. In this post I want to explain the new features more in detail:   In-Memory Join Groups: Columns are specified, which are used to join tables: CREATE INMEMORY JOIN GROUP V_name_jg (VEHICLES(NAME), SALES(NAME)); Those columns share the compression dictionary. My understanding on how this works is as follows: The joins…

Read More
Franck Pachot

Ravello

By | Database Administration & Monitoring | No Comments
 

 I’m at Oracle Open World and I’m rather focused on database rather than all those Cloud topics, but one product caught my attention at the Oracle ACED Briefing. Oracle bought Ravallo systems at the beginning of the year. What is Ravello? You have virtualized your applications on VMware and want to move them to the Cloud… without any changes.

Read More
Franck Pachot

Oracle 12cR2 Optimizer Adaptive Statistics

By | Database Administration & Monitoring | 4 Comments
 

 When 12.1 came out, the major issue we encountered after migration was related to the new adaptive features of the optimizer: automatic reoptimization, SQL Plan Directives and the resulting dynamic sampling. Of course, Oracle product managers listen to feedbacks, ensure to provide workarounds or fixes and make things better for next release. Let’s see what has been announce on this topic for 12.2

Read More
Daniel Westermann

DOAG 2016, Schulungstag: Oracle Grid Infrastructure

By | Database Administration & Monitoring | No Comments
 

 Wie auch in den letzten Jahren werden wir auch dieses Jahr wieder einen Schlungstag an der DOAG ausrichten. Dieses mal wird sich alles um die Oracle Clusterware (“Infrastruktur & Middelware” –> “Oracle Grid Infrastructure”) drehen: Los geht es mit den Anforderungen an Netzwerk, Speichersysteme, Betriebssystem und Kernel Parameter, denn nur wenn die Basis auch stimmt arbeitet eine Cluster-Lösung auch verlässlich. Wie immer bei uns wird es zahlreiche Live Demos geben, denn zeigen ist immer besser…

Read More
Clemens Bleile

Oracle Open World 2016 – Day 2

By | Database Administration & Monitoring | No Comments
 

 Day 2 is the first official day of the Oracle Open World (OOW) 2016. As a parallel event the Oak Table Network organized his Oak Table World (OTW) close to the Open World. I attended several sessions from OOW and OTW: Jeremy Schneider: Ansible Ansible is a very light software written in Python, which allows automation in deploying applications and managing systems. The main goal of the developer of Ansible Michael DeHaan was to make…

Read More
Clemens Bleile

Oracle Open World 2016 – Day 1

By | Database Administration & Monitoring | No Comments
 

 Oracle Open World 2016 started on Sunday. The first day is always reserved for presentations provided by members of the various Oracle User Groups. However, the last part of the day is the first Keynote from Larry Elison. But let’s start by some of the sessions I visited Sunday: Ludovica Caldara: Migrating to Oracle Databases 12c: 300 databases in 300 days. Ludovica provided a presentation about the experience he gained during the migration project of…

Read More