Infrastructure at your Service

Cloud Archives - Page 6 of 7 - Blog dbi services

Daniel Westermann

PostgreSQL on Amazon RDS – Setting up the beast

By | Database Administration & Monitoring | No Comments

Today I had a look at PostgreSQL in Amazon RDS. Once you have an Amazon AWS account (this requires a valid credit card for verification) setup bringing up a PostgreSQL instance is pretty easy. The first 12 months are free but be sure to read about the restrictions and what is terminated by default and what is not. Once your AWS account is ready you can login to the management console which lists all the…

Read More
Oracle Team

IBM Bluemix Database Cloud Service – My first trial

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . Remember my first try of Oracle cloud when Larry Ellison announced the Cloud in june? This week at OOW15 Larry Ellison announced that IBM is not a competitor anymore for them, then I checked IBM Cloud: IBM Bluemix offers IaaS, PaaS and SaaS. As I did in my first trial for Oracle, I’m testing the simplest DB2 ‘SQL Database service’.

Read More
Oracle Team

SLOB in the Cloud: how to check Cloud Services performance

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . You buy resources on the Cloud, but they are mutualized, thanks to virtualization. Are you sure you have the resources you paid for? When it comes to Oracle databases there are 3 ways to test performances: Run an application, or a simulation of an application, such as the excellent SwingBench from Dominic Giles Run low-level calibration tools, such as Orion that simulate database, good when you have no database yet Or…

Read More
Oracle Team

Oracle Cloud Services DBaaS and dbi services best practices

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . When we give our trainings (dbi services workshops) we signal our best practices with this logo. It’s our know-how, acquired through experience, consulting, service desk, exchange at events, beta testing, etc. that we share with our customers. Let’s have a look at a few points that we recommend to change if you provision a database with DBaaS on the Cloud.

Read More
Oracle Team

Oracle Database Cloud Service – My first trial

By | Database management, Oracle | No Comments

By Franck Pachot . The cloud has been annouced, I want to try. From the cloud.oracle.com/database website, there is Trial only for the ‘Database Schema Service’ so I asked fot it, received an e-mail with connection info and it works:   Good. The password was temporary, so I have to change it, and set answers to 3 within 4 questions in case I forgot my password. Java error: my user does not exist: Ok, I…

Read More
Matthieu Munch

Row Store vs Column Store in SAP HANA

By | Development & Performance | One Comment

The SAP HANA database allows you to create your tables in Row or Column Store mode. In this blog, I will demonstrate that each method has its advantages and disadvantages and should be used for specific cases. Thanks to two kind of tests, I will show you that the Row Store mode should be used for simple SELECT SQL queries, without aggregation and the Column Store mode should be used for complex SELECT queries, containing…

Read More