Open source database new engine of France’s social security

The open source database management system (DBMS) Postgresql is the new engine for France’s Caisse Nationale d’Allocations Familiales (CNAF). The organisation, responsible in 2009 for some 69 billion Euro in benefits distributed to 11 million claimants, earlier this year replaced its proprietary DBMS with the open source alternative.

According to a statement published in September by IT company Bull, assisting CNAF, the Postgresql system runs almost a billion SQL queries every day.

“Our choice of PostgreSql was not just driven by the fact that this software is open-source”, Marc Pavie, CNAF’s Deputy Director of Information Systems said earlier this week. “This is a technically rich DBMS, that included all the features we need. It has levels of performance and reliability that meet our production goals.”

However, Pavie says moving to Postgresql does allow the organisation to save costs on licences for a proprietary DBMS. “This was an opportunity to decrease our licence budget.” The deputy IT director is also confident that the open source community involved in development of Postgresql will result in increasing quality.

Migration to the open source DBMS started in 2008, Bull explains in its statement. “In total, it took 18 months to migrate the 168 databases involved, representing a total of 4 Terabytes of data.”

“Regular administrative tasks have been automated and system supervision is carried out using an open software solution, Nagios. In addition, the architecture that has been implemented features dual high-availability, with a remote business recovery site and locally based service continuity facilities.”

According to the IT company, the Postgresql RDBMS at CNAF is run on servers using Red Hat Linux. These servers are running on the company’s proprietary Novascale mainframes, allow the organisation to simultaneously continue to run its Cobol legacy applications on other partitions. source.

Related Posts

Hand of Thief trojan and your favorite Linux distribution The Hand of Thief (HoT) trojan is a commercial form-grabber and backdoor banking trojan released in July (2013) and aimed at Linux distributions. Codi...
EFF releases experimental open wireless router firmware The Electronic Frontier Foundation (EFF) has announced the release of the alpha version of an Open Wireless Router firmware. It was officially announc...
Vagrant 1.8 released. Includes support for linked clones and snapshots Vagrant 1.8 has been released. Comes with support for linked clones and snapshots. Vagrant is a very popular open source application for building a...
Have a Happy Holidays and give GRUB a look to match your mood Not too long ago, it was January, and in a few days, it will be another month of January. Time really does fly. But what can we do? Go with the...
Installing, troubleshooting MongoDB 2.6.4 startup failure on Fedora 20 I've been running MongoDB on Debian-based distribution and haven't had any issue installing or managing it. However, when I tried to set it up on my m...
Nuvola Player needs a new maintainer Nuvola Player is a graphical interface for tuning in to all your Cloud-based music services. I first wrote about it a month ago (see Nuvola Player: En...

We Recommend These Vendors and Free Offers

ContainerizeThis 2016 is a free, 2-day conference for all things containers and big data. Featured, will be presentations and free, hands-on workshops. Learn more at ContainerizeThis.com

Launch an SSD VPS in Europe, USA, Asia & Australia on Vultr's KVM-based Cloud platform starting at $5:00/month (15 GB SSD, 768 MB of RAM).

Deploy an SSD Cloud server in 55 seconds on DigitalOcean. Built for developers and starting at $5:00/month (20 GB SSD, 512 MB of RAM).

Want to become an expert ethical hacker and penetration tester? Request your free video training course of Online Penetration Testing and Ethical Hacking

Whether you're new to Linux or are a Linux guru, you can learn a lot more about the Linux kernel by requesting your free ebook of Linux Kernel In A Nutshell.


One Comment

  1. Pingback: Tweets that mention linux Open source database new engine of France’s social security: The open source database management system (... -- Topsy.com

Leave a Comment

Your email address will not be published. Required fields are marked *

*