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
October 18, 2013 5:16 PM
Scoop.it!

ChoiceMaker

ChoiceMaker | FrenchTech SAAS | Scoop.it
Record matching software
Mickael Ruau's insight:
FeaturesFinds duplicate records in a SQL, XML or flat-file databaseUses machine learning to mimic human intuition about when records matchPlug-in architecture based on Eclipse 2.1.3 is extensible to a wide variety of matching applicationsBased on patented algorithms that may be licensed from Open Invention Network 
No comment yet.
Scooped by Mickael Ruau
October 18, 2013 5:14 PM
Scoop.it!

AMB Data Profiling Data Quality

AMB Data Profiling Data Quality | FrenchTech SAAS | Scoop.it
AMB New Generation Data Empowerment - offers a comprehensive approach to data governance needs with ground breaking features to locate, identify, discover, ...
Mickael Ruau's insight:
FeaturesAMB-PDM Profiling Statistics / AnalysisAMB-PDM Domain AnalysisAMB-PDM Pattern AnalysisAMB-PDM Relationships Intra/Cross TablesAMB-PDM Technical MetaDataAMB-PDM Repeatable ProcessesAMB-PDM Open Non-Proprietary Repository
No comment yet.
Scooped by Mickael Ruau
October 18, 2013 5:12 PM
Scoop.it!

Open Source Data Quality and Profiling

This project is dedicated to open source data quality and data management initiatives. Data Quality includes profiling, filtering, governance, similarity ...
Mickael Ruau's insight:
FeaturesBig data support - HIVE thrift server supportFormat Creation, Format Matching ( Phone, Date, String and Number), Format standardizationFuzzy Logic based similarity check, Cardinailty check between tables and filesExport and import from XML, XLS or CSV format, PDF exportFile Analysis, Regex search, Standardization, DB searchComplete DB Scan, SQL interface, Data Dictionary, Schema ComparisonStatistical Analysis, Reporting ( dimension and measure based)Pattern Matching , DeDuplication, Case matching, Basket Analysis, Distribution ChartData generation and Data masking featuresMeta Data Information, Reverse engineering of Data ModelTimeliness analysis , String length analysisMysql, Oracle,Postgres,MS Access, Db2, SQL Server certified
No comment yet.
Scooped by Mickael Ruau
October 18, 2013 4:12 PM
Scoop.it!

Automation for the people: Hands-free database migration

Automation for the people: Hands-free database migration | FrenchTech SAAS | Scoop.it

Databases are often out of sync with the applications they support, and getting the database and data into a known state is a significant challenge to manage. In this installment of Automation for the people, automation expert Paul Duvall demonstrates how the open source LiquiBase database-migration tool can reduce the pain of managing the constant of change with databases and applications.

Mickael Ruau's insight:

Table 2 summarizes the list of some of the features that LiquiBase provides:


Table 2. Summary of some of LiquiBase features

FeatureDescriptionSupport for multiple databasesSupports DB2, Apache Derby, MySQL, PostgreSQL, Oracle, Microsoft SQL Server, Sybase, HSQL, and others.View a history of changes applied to a databaseUsing the databasechangelog table, you can view every change applied to the database.Generates database diff logsLearn about changes applied to the database outside the LiquiBase change sets.Capable of running custom SQL scriptsUse LiquiBase to call SQL scripts that you've already written.Utilities to roll back database changesSupports a process for rolling back any changes that were applied to the database.

You can now see that when applied appropriately through automated scripts, database migration can be a less painful and more repeatable process that many members of your team can run.

No comment yet.
Scooped by Mickael Ruau
October 18, 2013 10:37 AM
Scoop.it!

patterns & practices: Data Access Guidance - Home

patterns & practices: Data Access Guidance - Home | FrenchTech SAAS | Scoop.it

The Data Access Guidance project covers data access for SQL and NoSQL databases as well as some architectural and design decisions involved in using them.

Mickael Ruau's insight:

This project is guidance around data access using relational databases, as well as NoSQL databases. It describes the various types of data persistence technologies, as well as when, how, and why they should be used. The guidance will show how various persistence types can be used together to create a highly-scalable system, as well as illustrating the challenges that arise when moving to a polyglot persistent system.

No comment yet.
Scooped by Mickael Ruau
October 18, 2013 9:49 AM
Scoop.it!

Table de décision - Wikipédia

Table de décision

Une table de décision est un outil logique permettant de modéliser facilement un ensemble de choix d'une certaine complexité. Au lieu d'obtenir une série de conditions imbriquées par une succession de SI..., ALORS..., SINON..., il est possible de créer une table les contenant. Ce type de table est particulièrement utile en programmation informatique.

Mickael Ruau's insight:

Cette table de décision ainsi renseignée, le type de requête suivant devient alors possible :

select je_vais_a_la_plage,je_reste_au_lit,je_bronze, je_me_baigne from table_de_decision where il_fait_beau like '%o%' and la_mer_est_chaude like '%n%' and il_y_a_des_requins like '%o%';

No comment yet.
Scooped by Mickael Ruau
October 18, 2013 6:14 AM
Scoop.it!

InnoDB scalability issues due to tables without primary keys

InnoDB scalability issues due to tables without primary keys | FrenchTech SAAS | Scoop.it
Each day there is probably work done to improve performance of the InnoDB storage engine and remove bottlenecks and scalability issues.
No comment yet.
Scooped by Mickael Ruau
October 18, 2013 2:22 AM
Scoop.it!

mysql-cacti-templates - A project to create better Cacti templates for MySQL, Apache, Memcached and more - Google Project Hosting

mysql-cacti-templates - A project to create better Cacti templates for MySQL, Apache, Memcached and more - Google Project Hosting | FrenchTech SAAS | Scoop.it

The Better Cacti Templates project is now part of the Percona Monitoring Plugins project.

No comment yet.
Scooped by Mickael Ruau
October 17, 2013 12:34 PM
Scoop.it!

Percona MySQL Data Recovery Tool for InnoDB Software

Percona MySQL Data Recovery Tool for InnoDB Software | FrenchTech SAAS | Scoop.it
Percona Data Recovery Tool for InnoDB recovers lost or corrupted data from InnoDB tables.
Mickael Ruau's insight:

Percona Data Recovery Tool for InnoDB is a free toolkit for recovering lost or corrupted data from InnoDB tables. It provides a way to extract InnoDB's data from files or raw devices in a tab-separated format when standard InnoDB recovery cannot be used for some reason, such as a dropped table, or severe corruption that prevents InnoDB from recognizing the data. It can be used to retrieve deleted tables, recover previous versions of updated rows, or fix InnoDB file corruption after a hardware failure such as a memory fault or bad cabling.

Percona has used these tools to perform MySQL data recovery for many customers, including extremely large datasets. Although the tools are powerful, performing InnoDB data recovery correctly requires expert knowledge of InnoDB's storage format and source code, experience, and intuition.

No comment yet.
Scooped by Mickael Ruau
October 17, 2013 12:24 PM
Scoop.it!

Percona Tools for MySQL - Percona Configuration Wizard for MySQL

The Percona Configuration Wizard for MySQL applies best practices to build a custom my.cnf file for your application.
Mickael Ruau's insight:

Apply Percona best practices to achieve better MySQL database performance and avoid the time, complexity, and risk of customizing a my.cnf configuration on your own. Simply copy and paste the results of the Percona Configuration Wizard for MySQL into your my.cnf file.

Tens of thousands of MySQL users have already used this tool to improve their MySQL performance. When you complete the wizard, your configuration files are saved for future use and you can easily share them with colleagues. Registration is required but your information will not be shared with third parties.

 
No comment yet.
Scooped by Mickael Ruau
October 17, 2013 11:52 AM
Scoop.it!

MySQL Tools & Management Software to Perform System Tasks by Percona

MySQL Tools & Management Software to Perform System Tasks by Percona | FrenchTech SAAS | Scoop.it
Choose from the vast collection of advanced command-line tools offered in Percona Toolkit to perform tasks like finding duplicate indexes & summarize MySQL servers.
Mickael Ruau's insight:

 

Verify master and replica data consistencyEfficiently archive rowsFind duplicate indexesSummarize MySQL serversAnalyze queries from logs and tcpdumpCollect vital system information when problems occur

 

No comment yet.
Scooped by Mickael Ruau
October 17, 2013 5:51 AM
Scoop.it!

MariaDB vs. MySQL » ADMIN Magazine

MariaDB vs. MySQL » ADMIN Magazine | FrenchTech SAAS | Scoop.it
MariaDB is a cousin of MySQL – but not an identical twin.
Mickael Ruau's insight:

The goal for Maria-DB is to be a drop-in replacement for MySQL – with more features and better performance.

MariaDB is based on the corresponding version of MySQL, if one exists. For example, MariaDB 5.1.53 is based on MySQL 5.1.53, with some added bug fixes, additional storage engines, new features, and performance improvements. Versions of MariaDB that do not have an equivalently numbered version of MySQL (e.g., MariaDB 5.2.4) contain major new features the developers felt warranted a new version number.

No comment yet.
Scooped by Mickael Ruau
October 17, 2013 3:52 AM
Scoop.it!

Enriching XMLType data using relational data – XQuery and fn:collection in action

Enriching XMLType data using relational data – XQuery and fn:collection in action | FrenchTech SAAS | Scoop.it
One of my colleagues had an interesting challenge. In an Oracle Database he has a table that contains an XMLType column. The column contains XML documents with people collections.
No comment yet.
Scooped by Mickael Ruau
October 18, 2013 5:15 PM
Scoop.it!

Jailer

Jailer | FrenchTech SAAS | Scoop.it

Database Subsetting and Browsing Tool. Exports consistent, referentially intact row-sets from relational databases (JDBC). Removes data w/o violating integrity.

Mickael Ruau's insight:

Generates DbUnit datasets, hierarchically structured XML and topologically sorted SQL-DML

No comment yet.
Scooped by Mickael Ruau
October 18, 2013 5:13 PM
Scoop.it!

DataCleaner

DataCleaner | FrenchTech SAAS | Scoop.it
Data quality analysis, profiling, cleansing, duplicate detection +more
Mickael Ruau's insight:
FeaturesProfiles and analyzes your database within minutes!Access almost any datastore - Oracle, MySQL, PostgreSQL, MS SQL Server, MongoDB, CUBRID, CSV files, Excel spreadsheets, dbase and moreDiscover patterns in your textual data with the Pattern FinderFind out which values occur the most with the Value Distribution profileCleanse your contact details with name and address validationsDetect duplicates using fuzzy logic and configurable weights and thresholdsMerge your duplicates and create a single version of the truthWrite data back to relational databases, CSV files, Excel spreadsheets or MongoDB databases 
No comment yet.
Scooped by Mickael Ruau
October 18, 2013 5:12 PM
Scoop.it!

Talend Open Studio for Data Quality

Talend Open Studio for Data Quality | FrenchTech SAAS | Scoop.it
This data profiling tool allows business users to define a set of indicators for each data element that needs to be analyzed or monitored. It produces ...
No comment yet.
Scooped by Mickael Ruau
October 18, 2013 1:47 PM
Scoop.it!

Apprentissage automatique : les arbres de décision

Pour certains domaines d'application, il est essentiel de produire des procédures de classification compréhensibles par l'utilisateur. C'est en particulier le cas pour l'aide au diagnostic médical où le médecin doit pouvoir interpréter les raisons du diagnostic. Les arbres de décision répondent à cette contrainte car ils représentent graphiquement un ensemble de règles et sont aisément interprétables. Pour les arbres de grande taille, la procédure globale peut être difficile à appréhender, cependant, la classification d'un élément particulier est toujours compréhensible. Les algorithmes d'apprentissage par arbres de décision sont efficaces, disponibles dans la plupart des environnements de fouille de données. Ils constituent l'objet de ce chapitre.

Mickael Ruau's insight:
Les arbres de décisionExemple introductif et préliminairesGénéralités sur l'apprentissage des arbres de décisionUn premier algorithme : CART (Breiman et al. [BFOS84])Un deuxième algorithme : C4.5 (Quinlan 93 [Qui93])Conclusion
No comment yet.
Scooped by Mickael Ruau
October 18, 2013 10:16 AM
Scoop.it!

Data-driven testing - Wikipedia, the free encyclopedia

Data-driven testing

Data-driven testing (DDT) is a term used in the testing of computer software to describe testing done using a table of conditions directly as test inputs and verifiable outputs as well as the process where test environment settings and control are not hard-coded.

No comment yet.
Scooped by Mickael Ruau
October 18, 2013 9:28 AM
Scoop.it!

myVertica Registration | MyVertica

myVertica Registration | MyVertica | FrenchTech SAAS | Scoop.it
Sign Up for the Vertica Community Edition Today

The HP Vertica Community Edition allows you to fully experience the HP Vertica Analytics Platform and join the myVertica community. 

Mickael Ruau's insight:

Download the HP Vertica Analytics Platform Community Edition and:

- Gain access to all the features and functionality of the industry’s leading Big Data analytics platform (no cost and no time limit)
- Manage and analyze up to 1 TB of data across three nodes for an unlimited time
- Join the MyVertica community and access downloads, documentation, FAQs, user forums, and other helpful resources

No comment yet.
Scooped by Mickael Ruau
October 18, 2013 2:22 AM
Scoop.it!

check-mysql-all - check_mysql_all is a suite of Nagios checks for MySQL 4.0+ and common surrounding technologies (maatkit, mmm, etc) - Google Project Hosting

check-mysql-all - check_mysql_all is a suite of Nagios checks for MySQL 4.0+ and common surrounding technologies (maatkit, mmm, etc) - Google Project Hosting | FrenchTech SAAS | Scoop.it

Many of the current Nagios checks are version-specific, leaving organizations running multiple versions of MySQL no choice but to support multiple Nagios checks for the same services. This program is designed to support all of the basic MySQL checks (including replication). If there are additional checks that you'd like to see, please request them on the issues page.

No comment yet.
Scooped by Mickael Ruau
October 18, 2013 2:20 AM
Scoop.it!

Percona XtraDB Software - Enhanced InnoDB for MySQL

Percona XtraDB Software - Enhanced InnoDB for MySQL | FrenchTech SAAS | Scoop.it
Percona XtraDB is a turbocharged version of the InnoDB storage engine for MySQL. It is backwards compatible with InnoDB and is 100% open-source and free.
Mickael Ruau's insight:

Percona XtraDB is an enhanced version of the InnoDB storage engine for MySQL® and MariaDB®. It has much faster performance than InnoDB and better scalability on modern hardware. XtraDB has more features than InnoDB; these are useful in high-load environments. It is backwards-compatible with InnoDB, so you can use it as a drop-in replacement.

Percona XtraDB includes all of InnoDB's reliable ACID-compliant design and advanced MVCC architecture. It adds features, tunability, metrics, and scalability. In particular, it is designed to scale better than InnoDB on many cores, to use memory more efficiently than InnoDB, and to be more convenient and usable than InnoDB. The new features are specially designed to overcome some of InnoDB's limitations. We choose enhancements based on customer requests, and on our best judgment of real-world needs as a high-performance consulting company.

The Percona XtraDB engine does not have separate binary releases. It is available as part of Percona Server and MariaDB.

No comment yet.
Scooped by Mickael Ruau
October 17, 2013 12:33 PM
Scoop.it!

Percona Tools for MySQL - Percona Query Advisor for MySQL

Use the Percona Query Advisor for MySQL to analyze complex MySQL queries in milliseconds.
Mickael Ruau's insight:

Analyzing MySQL queries can be difficult and time consuming. While your queries may parse correctly, the results can sometimes be unexpected. Join the tens of thousands of MySQL users who have used the free Percona Query Advisor for MySQL to analyze their queries in seconds.

There is no software to install. Simply submit your SQL query and receive expert recommendations based on the deep experience of Percona’s MySQL performance team. You can then save your results and share the advice with your colleagues. Registration is required but your information will not be shared with third parties.

No comment yet.
Scooped by Mickael Ruau
October 17, 2013 12:10 PM
Scoop.it!

10 Percona Toolkit Tools Every MySQL DBA Should Know About

Percona Toolkit is the must-have toolkit for serious MySQL administrators with well-tested tools developed by Percona to solve real-world challenges faced by our customers. This webinar will present 10 of these tools, including usage examples that will help attendees understand when and how to use these tools in their environments.

Mickael Ruau's insight:

 

Slides: Download Here

No comment yet.
Scooped by Mickael Ruau
October 17, 2013 11:45 AM
Scoop.it!

Percona Toolkit 2.2.5 is now available

Percona Toolkit 2.2.5 is now available | FrenchTech SAAS | Scoop.it
Percona is glad to announce the release of Percona Toolkit 2.2.5 on October 16th, 2013. Download it today!
Mickael Ruau's insight:

All of Percona‘s software is open-source and free, all the details of the release can be found in the release notes and 2.2.5 milestone at Launchpad.

No comment yet.
Scooped by Mickael Ruau
October 17, 2013 3:54 AM
Scoop.it!

MariaDB Dynamic Columns client API

MariaDB Dynamic Columns client API | FrenchTech SAAS | Scoop.it
I have blogged on using MariaDB Dynamic Columns already, and I hope this was useful and introduction.
No comment yet.