FrenchTech SAAS
33.5K views | +2 today
FrenchTech SAAS
Les news de l'univers SAAS et FrenchTech
Curated by Mickael Ruau
Your new post is loading...
Your new post is loading...

Popular Tags

Scooped by Mickael Ruau
January 15, 2015 1:14 AM
Scoop.it!

Big data is simply another name for complicated business intelligence

Big data is simply another name for complicated business intelligence | FrenchTech SAAS | Scoop.it
Big data promises to upend the business intelligence market, but it won't do so until the tools around it become easier to use
No comment yet.
Scooped by Mickael Ruau
January 14, 2015 3:12 AM
Scoop.it!

MySQL :: MySQL 5.0 Reference Manual :: 18.5 Access Control for Stored Programs and Views

MySQL :: MySQL 5.0 Reference Manual :: 18.5 Access Control for Stored Programs and Views | FrenchTech SAAS | Scoop.it

Stored programs and views are defined prior to use and, when referenced, execute within a security context that determines their privileges. These privileges are controlled by their DEFINER attribute, and, if there is one, their SQL SECURITY characteristic.


All stored programs (procedures, functions, and triggers) and views can have a DEFINER attribute that names a MySQL account. If the DEFINER attribute is omitted from a stored program or view definition, the default account is the user who creates the object.


In addition, stored routines (procedures and functions) and views can have a SQL SECURITY characteristic with a value of DEFINER or INVOKER to specify whether the object executes in definer or invoker context. If the SQL SECURITY characteristic is omitted, the default is definer context.


Triggers have no SQL SECURITY characteristic and always execute in definer context. The server invokes these objects automatically as necessary, so there is no invoking user.

No comment yet.
Scooped by Mickael Ruau
January 13, 2015 1:47 PM
Scoop.it!

Edito – Une autre leçon à tirer de l’attaque contre Sony [par Bruce Schneier] | Observatoire FIC

Edito – Une autre leçon à tirer de l’attaque contre Sony [par Bruce Schneier] | Observatoire FIC | FrenchTech SAAS | Scoop.it
Si l’enseignement évident à tirer pour lesentreprises est qu’elles doivent améliorer leursécurité contre les attaques, l’attaque contre Sonydonne aussi une autre leçon, aussi importante,quoique nettement moins mentionnée : lesentreprises devraient avoir une politiquevolontariste d’effacement des données.
No comment yet.
Scooped by Mickael Ruau
January 13, 2015 7:14 AM
Scoop.it!

Aider le Chief Data Officer à réussir la transformation numérique de l’entreprise

Aider le Chief Data Officer à réussir la transformation numérique de l’entreprise | FrenchTech SAAS | Scoop.it
Le chief data officer - administrateur des données en français - prend une place prépondérante dans l'action publique, et, a fortiori, dans l’ensemble des transformations numériques que connaissent les entreprises. A travers différents exemples, Christophe Dorin, Vice-President Sales and Marketing de Consotel Global Services, analyse le rôle crucial de ce nouveau poste au sein des organisations.
No comment yet.
Scooped by Mickael Ruau
January 13, 2015 12:16 AM
Scoop.it!

Le BigData vous permet de « Voyager à prix réduit » ! | Le Blog des QSF-S (ex QUASSI & IdF)

No comment yet.
Scooped by Mickael Ruau
January 12, 2015 4:19 AM
Scoop.it!

Cleaning Data with Refine | School of Data - Evidence is Power

Cleaning Data with Refine | School of Data - Evidence is Power | FrenchTech SAAS | Scoop.it
Open Refine (previously Google Refine) is a data cleaning software that uses your web browser as an interface. This means it will look like it runs on the internet but all your data remains on your machine and you do not need internet connection to work with it.

The main aim of Refine is to help you exploring and cleaning your data before you use it further. It is built for large datasets – so don’t worry as long as your spreadsheets can keep the information: Refine can as well.
No comment yet.
Scooped by Mickael Ruau
January 9, 2015 1:57 PM
Scoop.it!

Logique intelligente

Logique intelligente | FrenchTech SAAS | Scoop.it

Une des fonctionnalités clés des bases de données SQL est leur support des requêtes personnalisées : de nouvelles requêtes peuvent être exécutées à tout moment. Ceci est seulement possible parce que l’optimiseur de requêtes(planificateur de requêtes) fonctionne à l’exécution ; il analyse chaque requête à sa réception et génère un plan d’exécution raisonnable immédiatement. La surcharge introduite par l’optimisation à l’exécution peut être minimisée avec les paramètres liés.

L’intérêt de ceci est que les bases de données sont optimisées pour le SQL dynamique. Utilisez-le si vous en avez besoin.

Néanmoins, une pratique fréquemment répondue est d’éviter le SQL dynamique et de privilégier le SQL statique, principalement à cause du mythe indiquant que « le SQL dynamique est lent ». Cette pratique fait plus de mal que de bien si la base de données utilise un cache partagé de plan d’exécution comme DB2, Oracle ou SQL Server.

No comment yet.
Scooped by Mickael Ruau
January 9, 2015 3:17 AM
Scoop.it!

Securing MySQL Server - How to LAMP

Securing MySQL Server - How to LAMP | FrenchTech SAAS | Scoop.it
Securing MySQL Server involves the following steps.
1) Overview
2) Securing root & anonymous users
3) Securing test Database
4) Removing anonymous MySQL accounts (OPTIONAL)
5) Removing test database (OPTIONAL)
6) Disabling MySQL Server history file
7) Disabling remote login
8) Changing the default MySQL Server administrator name (OPTIONAL)
9) Do not specify passwords on command line
No comment yet.
Scooped by Mickael Ruau
January 7, 2015 3:22 AM
Scoop.it!

Using OpenRefine to Clean Multiple Documents in the Same Way | School of Data - Evidence is Power

Using OpenRefine to Clean Multiple Documents in the Same Way | School of Data - Evidence is Power | FrenchTech SAAS | Scoop.it
When working with data that is published on a monthly basis according to the same template, it is often the case that we need to apply the same data cleaning rules to the data each time a new file is released. This recipe shows to use OpenRefine to create a reusable script for cleaning data files that get published month on month according to the same schedule.
No comment yet.
Scooped by Mickael Ruau
January 5, 2015 3:08 AM
Scoop.it!

MySQL :: MySQL High Availability: DRBD Configuration and Deployment Guide

MySQL :: MySQL High Availability: DRBD Configuration and Deployment Guide | FrenchTech SAAS | Scoop.it
There are many different ways of achieving high availability for MySQL. This Guide introduces DRBD (Distributed Replication Block Device), one of the leading solutions for MySQL HA (High Availability), offering users:

An end-to-end, integrated stack of mature and proven open source technologies, fully supported by Oracle;
Automatic failover and recovery for service continuity;
Mirroring, via synchronous replication, to ensure failover between nodes without the risk of losing committed transactions;
Building of HA clusters from commodity hardware, without the requirement for shared-storage.
No comment yet.
Scooped by Mickael Ruau
January 3, 2015 5:07 PM
Scoop.it!

How well does your table fit in the InnoDB buffer pool in MySQL 5.6+?

How well does your table fit in the InnoDB buffer pool in MySQL 5.6+? | FrenchTech SAAS | Scoop.it
Some time ago, Peter Zaitsev posted a blog titled “How well does your table fits in innodb buffer pool?
No comment yet.
Scooped by Mickael Ruau
January 2, 2015 3:07 AM
Scoop.it!

MySQL :: MySQL Reference Architectures for Massively Scalable Web Infrastructure

MySQL :: MySQL Reference Architectures for Massively Scalable Web Infrastructure | FrenchTech SAAS | Scoop.it
The whitepaper covers the core underlying technologies supporting today’s most successful web services including:
- MySQL Database
- MySQL Cluster
- MySQL Replication
- Caching with Memcached and Redis
- Big Data with Hadoop
- NoSQL APIs
- Geographic Redundancy
- Hardware Recommendations
- Operational Best Practices

By leveraging the best practices identified in this Guide, you will have a starting point to building the next web and mobile phenomenon.
No comment yet.
Scooped by Mickael Ruau
December 31, 2014 3:06 AM
Scoop.it!

MySQL :: MySQL Workbench: Database Design. Development. Administration. Migration.

MySQL :: MySQL Workbench: Database Design. Development. Administration. Migration. | FrenchTech SAAS | Scoop.it

This paper looks at the various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how Oracle’s MySQL Workbench can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.

No comment yet.
Scooped by Mickael Ruau
January 14, 2015 7:15 AM
Scoop.it!

Les entreprises françaises plutôt sceptiques sur le potentiel du Big Data

Les entreprises françaises plutôt sceptiques sur le potentiel du Big Data | FrenchTech SAAS | Scoop.it
Selon une étude du cabinet EY, seulement 17% des entreprises françaises ont entamé une démarche d’exploitation des données massives. Deux tiers d’entre elles ne voient pas dans le Big Data un levier de croissance. Les freins résident pour l’essentiel dans la culture cloisonnée et pyramidale des sociétés en France
No comment yet.
Scooped by Mickael Ruau
January 13, 2015 4:19 PM
Scoop.it!

Les 10 tendances 2015 dans la data

Les 10 tendances 2015 dans la data | FrenchTech SAAS | Scoop.it
En 2015, les individus et les entreprises vont voir leurs données augmenter. Il sera essentiel de répondre aux attentes des utilisateurs en ce qui concerne les analyses conviviales et l'utilisation des données pour trouver des réponses rapides à leurs questions et enjeux.
No comment yet.
Scooped by Mickael Ruau
January 13, 2015 7:15 AM
Scoop.it!

La data visualisation dans tous ses états

La data visualisation dans tous ses états | FrenchTech SAAS | Scoop.it
Les entreprises sont aujourd’hui confrontées à une croissance exponentielle de leurs données. Ressource extraordinaire pour éclairer la stratégie d’entreprise, la data visualisation vient révolutionner l’exploitation des données et offrir un accès simple et efficace à l’information issue de la masse de données produites. À l’heure du Big Data, de l’Open Data, de la "business i
No comment yet.
Scooped by Mickael Ruau
January 13, 2015 12:16 AM
Scoop.it!

BigData et Qualité: Introduction [1] | Le Blog des QSF-S (ex QUASSI & IdF)

No comment yet.
Scooped by Mickael Ruau
January 12, 2015 5:11 AM
Scoop.it!

MySQL :: MySQL 5.0 Reference Manual :: 2.18.2 Securing the Initial MySQL Accounts

MySQL :: MySQL 5.0 Reference Manual :: 2.18.2 Securing the Initial MySQL Accounts | FrenchTech SAAS | Scoop.it
Mickael Ruau's insight:

A more secure example of using mysqladmin to set the initial passwords. If you use the ways this document suggests, your password will show in shell history.
But this way, your password never shows and doesn't go into shell history:
mysqladmin -u root -h localhost password
Then you will be prompted for the new password.
Repeat for each user/host in the initial tables.

From the man page:
As of MySQL 5.5.3, the new password can be omitted following the password command. In this case, mysqladmin prompts for the password value, which enables you to avoid specifying the password on the command line. Omitting the password value should be done only if password is the final command on the mysqladmin command line. Otherwise, the next argument is taken as the password.

No comment yet.
Scooped by Mickael Ruau
January 12, 2015 3:10 AM
Scoop.it!

MySQL :: MySQL 5.0 Reference Manual :: 4.4.7 mysql_secure_installation — Improve MySQL Installation Security

MySQL :: MySQL 5.0 Reference Manual :: 4.4.7 mysql_secure_installation — Improve MySQL Installation Security | FrenchTech SAAS | Scoop.it

This program enables you to improve the security of your MySQL installation in the following ways:

  • You can set a password for root accounts.

  • You can remove root accounts that are accessible from outside the local host.

  • You can remove anonymous-user accounts.

  • You can remove the test database (which by default can be accessed by all users, even anonymous users), and privileges that permit anyone to access databases with names that start with test_.

Mickael Ruau's insight:

mysql_secure_installation helps you implement security recommendations similar to those described atSection 2.18.2, “Securing the Initial MySQL Accounts”.

No comment yet.
Scooped by Mickael Ruau
January 9, 2015 4:08 AM
Scoop.it!

MySQL :: A Guide to Securing MySQL on Windows

MySQL :: A Guide to Securing MySQL on Windows | FrenchTech SAAS | Scoop.it
This guide will walk you through understanding the MySQL security model, post-installation, nd securing user accounts and replication.
No comment yet.
Scooped by Mickael Ruau
January 8, 2015 2:15 AM
Scoop.it!

Protect yourself from SQLi attacks

Protect yourself from SQLi attacks | FrenchTech SAAS | Scoop.it
MySQL does not have a built-in command to execute shell commands, as Microsoft SQL Server does. Nonetheless, I will show you how SQL injection can allow anyone to run arbitrary commands using standard features provided by MySQL.

First of all, I will give you a brief description of SQL injection. Then I will present you with a couple of less known methods that exist in MySQL, which I will use to open a backdoor to a webserver. I will use 2 built-in MySQL commands - one that writes arbitrary files and one that can be used to read arbitrary files. After that I will describe webshells and the attack itself.
No comment yet.
Scooped by Mickael Ruau
January 6, 2015 3:08 AM
Scoop.it!

MySQL :: MySQL Guide to High Availability Solutions

MySQL :: MySQL Guide to High Availability Solutions | FrenchTech SAAS | Scoop.it
This Guide is designed to assist Developers, Architects and DBAs in navigating the complex waters of HA. It presents:

A methodology for selecting the right HA solution to meet Service Level Agreements;
A tour of the leading certified HA solutions for MySQL;
Operational best practices to implement and support HA.
No comment yet.
Scooped by Mickael Ruau
January 5, 2015 3:07 AM
Scoop.it!

A Garden and a Library: Presentations

A Garden and a Library: Presentations | FrenchTech SAAS | Scoop.it
This is a walk-through of a sample project using Google Refine - standardizing the names of cities of publication for books. (from the 260|a for all you library geeks out there) This also shows how to link or reconcile to Freebase to return linked data to your spreadsheet!
No comment yet.
Scooped by Mickael Ruau
January 3, 2015 5:06 PM
Scoop.it!

The MySQL Query Cache: How it works, plus workload impacts (good and bad)

The MySQL Query Cache: How it works, plus workload impacts (good and bad) | FrenchTech SAAS | Scoop.it
Query caching is one of the prominent features in MySQL and a vital part of query optimization. It is important to know how it works as it has the potential to cause significant performance improvements – or a slowdown – of your workload.
No comment yet.
Scooped by Mickael Ruau
January 1, 2015 5:52 AM
Scoop.it!

Déclaration CNIL : comment 15 minutes peuvent vous éviter 50.000 € de frais

Déclaration CNIL : comment 15 minutes peuvent vous éviter 50.000 € de frais | FrenchTech SAAS | Scoop.it

Voici un cas assez classique dans lequel une entreprise essaye de faire valoir ses droits, sur le fondement d’un traitement de données personnelles qui n’a pas été déclaré à la CNIL.

Peine perdue, le traitement étant illicite, les informations issues de là ne peuvent être légalement utilisées, nous dit sagement la Cour de cassation.

No comment yet.