FrenchTech SAAS
33.5K views | +0 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
March 17, 2013 5:40 AM
Scoop.it!

Virtuoso Universal Server - Wikipedia, the free encyclopedia

Virtuoso Universal Server is a middleware and database engine hybrid that combines the functionality of a traditional RDBMS, ORDBMS, virtual database, RDF, XML, free-text, web application server and file server functionality in a single system. Rather than have dedicated servers for each of the aforementioned functionality realms, Virtuoso is a "universal server"; it enables a single multithreaded server process that implements multiple protocols. The open source edition of Virtuoso Universal Server is also known as OpenLink Virtuoso. The software has been developed by OpenLink Software with Kingsley Uyi Idehen and Orri Erling as the chief software architects.

Virtuoso provides an extended object-relational model, which combines the flexibility of relational access with inheritance, run time data typing, late binding, and identity based access. Virtuoso Universal Server database includes physical file and in memory storage and operating system processes that interact with the storage. There is one main process, which has listeners on a specified port for HTTP, SOAP, and other protocols.

Virtuoso is designed to take advantage of operating system threading support and multiple CPUs. It consists of a single process with an adjustable pool of threads shared between clients. Multiple threads may work on a single index tree with minimal interference with each other. One cache of database pages is shared among all threads and old dirty pages are written back to disk as a background process.

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

CUBRID - Wikipedia, the free encyclopedia

CUBRID (pron.: /ˈkjuːbrɪd/ "cube-rid") is an open source SQL based relational database management system (RDBMS) with object extensions[3] developed by NHN Corporation for web applications.[4] The name CUBRID is a combination of the two words cube and bridge, cube standing for a sealed box that provides security for it's contents while bridge standing for data bridge.[citation needed]

CUBRID has a separate license for its server engine and its interfaces. The server engine adopts the GPL v2.0 or later license, which allows distribution, modification, and acquisition of the source code. CUBRID APIs and GUI tools have the Berkeley Software Distribution license in which there is no obligation of opening derivative works. The reason of adopting two separate license systems is to provide complete freedom to Independent software vendors (ISV) to develop and distribute CUBRID based applications.[5]

The feature that distinguishes CUBRID Database from other relational database systems is its 3-tier client-server architecture[6] which consists of the database server, the connection broker[7] and the application layer.

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

Cloud Database

Cloud Database | FrenchTech SAAS | Scoop.it
Xeround is an elastic, always-on cloud database that lets you run your MySQL applications in the cloud, with auto scaling and high availability.
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:43 AM
Scoop.it!

OCTO talks ! » NewSQL: Comment distribuer ses données avec SQLFire

OCTO talks ! » NewSQL: Comment distribuer ses données avec SQLFire | FrenchTech SAAS | Scoop.it
Le blog d'OCTO Technology, cabinet d'architectes en systèmes d'information
Mickael Ruau's insight:

SQLFire est une base de données relationnelle « in memory », c’est-à-dire qu’à tout instant ses données sont disponibles en mémoire vive. Les performances attendues sont donc très élevées, mais ce choix impose une limite sur le volume de données que peut stocker efficacement une instance (hors overflow sur le disque).

 

Pour franchir cette limite, pour permettre un failover en cas de panne matérielle et pour pouvoir monter en puissance, les concepteurs de SQLFire ont choisi d’encourager les développeurs à partitionner et répliquer leurs données sur plusieurs machines, toutes connectées sur un réseau local.

 

L’architecture choisie est de type share nothing, ce qui a des conséquences intéressantes à la fois pour le développeur et pour les performances. Ce deuxième article va présenter le mécanisme de partitionnement de SQLFire, proposer une méthodologie pour adapter le modèle de données, et discuter les conséquences des choix d’architecture de la solution.

 

No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:37 AM
Scoop.it!

DataCleaner

DataCleaner | FrenchTech SAAS | Scoop.it
DataCleaner est un outil d'analyse de données versatile, complet et efficace.  Il vous permet d'analyser, de nettoyer, de transformer et de profiler le contenu des tables de vos bases de données. L...
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:36 AM
Scoop.it!

BigDump

BigDump | FrenchTech SAAS | Scoop.it
Vous utilisez phpMyAdmin (que Dieu vous pardonne!) et vos imports s'arrêtent en plein milieu parce que vous rencontrez un timeout?  Vous utilisez le client MySQL et la connection vous reliant au se...
Mickael Ruau's insight:

Vous utilisez phpMyAdmin (que Dieu vous pardonne!) et vos imports s’arrêtent en plein milieu parce que vous rencontrez un timeout?  Vous utilisez le client MySQL et la connection vous reliant au serveur à distance se coupe après une certaine période d’inactivité et votre import s’arrête encore?  Votre dump est trop gros et il n’y a pas moyen d’en faire l’import ?

Qu’à cela ne tienne, il existe un merveilleux outil vous permettant d’importer vos données par tranches : BigDump !

No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:34 AM
Scoop.it!

Creating sequences in MySQL

Creating sequences in MySQL | FrenchTech SAAS | Scoop.it
Those who have used PostgresSQL usually gets lazy when write the SQL code to auto-numeric fields, but we miss that feature when we are in a MySQL database. As we know, MySQL have auto-increment fie...
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:32 AM
Scoop.it!

SQL and Relational Theory

SQL and Relational Theory | FrenchTech SAAS | Scoop.it
Understanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. In SQL and Relational Theory, author C.J.
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:31 AM
Scoop.it!

Relational databases as reality sandwiches: thoughts about C.J. Date's "SQL and Relational Theory" - O'Reilly Broadcast

Relational databases as reality sandwiches: thoughts about C.J. Date's "SQL and Relational Theory" - O'Reilly Broadcast | FrenchTech SAAS | Scoop.it
I recently returned to
SQL and Relational
Theory: How to Write Accurate SQL Code
by C.J.
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:30 AM
Scoop.it!

InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries

InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries | FrenchTech SAAS | Scoop.it
Results returned from an InnoDB full-text search query are often extremely different from those returned by MyISAM.
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:29 AM
Scoop.it!

MySQL performance: Impact of memory allocators (Part 2)

MySQL performance: Impact of memory allocators (Part 2) | FrenchTech SAAS | Scoop.it
What impact does the number of processor cores have on different memory allocators and what difference we will see in MySQL performance in this scenario?
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:28 AM
Scoop.it!

MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown

MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown | FrenchTech SAAS | Scoop.it
While preparing the webinar I will deliver this Friday, I run into a quite interesting optimizer issue, related to the Index Condition Pushdown (ICP).
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:27 AM
Scoop.it!

les databases et plus: jointures et collate

les databases et plus: jointures et collate | FrenchTech SAAS | Scoop.it
Mickael Ruau's insight:

L'option COLLATE peut être utilisée dans l'ordre de création d'une table pour spécifier le comportement à observer sur les opérations liées à une colonne. Vous pouvez par exemple grâce à ce mot clé effectuer une recherche sur une chaîne de caractères en ne tenant pas compte des accents. Cependant, il est important de savoir que cela peut avoir un impact sur les performances de vos jointures SQL si vous n'utilisez le même COLLATE sur les colonnes servant à effectuer la jointure. Nous allons voir un exemple concret rencontré en production.

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

Free Cloud Database | Xeround

Free Cloud Database | Xeround | FrenchTech SAAS | Scoop.it
Need a free cloud database? Xeround’s powerful MySQL database service is free. Ensure high availability and auto-scaling for your DB with 1-click.
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:43 AM
Scoop.it!

OCTO talks ! » Consistent Hashing ou l’art de distribuer les données

OCTO talks ! » Consistent Hashing ou l’art de distribuer les données | FrenchTech SAAS | Scoop.it
Le blog d'OCTO Technology, cabinet d'architectes en systèmes d'information
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:38 AM
Scoop.it!

Open source data quality, data profiling, data cleansing, data matching | DataCleaner

Open source data quality, data profiling, data cleansing, data matching | DataCleaner | FrenchTech SAAS | Scoop.it
open source software for data quality, data profiling, data warehousing, master data management, business intelligence, corporate performance management
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:37 AM
Scoop.it!

OCTO talks ! » Ranger sa chambre, ou l’archivage de données

OCTO talks ! » Ranger sa chambre, ou l’archivage de données | FrenchTech SAAS | Scoop.it
Le blog d'OCTO Technology, cabinet d'architectes en systèmes d'information
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:34 AM
Scoop.it!

A better SHOW TABLE STATUS

A better SHOW TABLE STATUS | FrenchTech SAAS | Scoop.it
From command line we have the entire MySQL server on hands (if we have privileges too of course) but we don’t have a overall overview, at this point the show table status command is every use...
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:32 AM
Scoop.it!

2 petits outils pratiques pour MySQL

2 petits outils pratiques pour MySQL | FrenchTech SAAS | Scoop.it
Je suis tombé par hasard sur un excellent blogue (en anglais malheureusement), Fatal Exception, principalement dédié à MySQL et qui explique en détail 2 procédures stockées qui pourraient grandemen...
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:32 AM
Scoop.it!

Comprendre son fichier de configuration – 3è partie « dbnewz

No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:30 AM
Scoop.it!

How Percona does a MySQL Performance Audit - MySQL Performance Blog

How Percona does a MySQL Performance Audit - MySQL Performance Blog | FrenchTech SAAS | Scoop.it
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:29 AM
Scoop.it!

InnoDB Full-text Search in MySQL 5.6 (part 1)

InnoDB Full-text Search in MySQL 5.6 (part 1) | FrenchTech SAAS | Scoop.it
InnoDB Full-text Search (FTS) in MySQL 5.6: An overview of FTS in InnoDB and observations made while getting it configured. By Percona's Ernie Souhrada.
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:29 AM
Scoop.it!

Impact of memory allocators on MySQL performance - MySQL Performance Blog

Impact of memory allocators on MySQL performance - MySQL Performance Blog | FrenchTech SAAS | Scoop.it
No comment yet.
Scooped by Mickael Ruau
March 15, 2013 6:27 AM
Scoop.it!

les databases et plus: Contraintes uniques et valeurs nulles

les databases et plus: Contraintes uniques et valeurs nulles | FrenchTech SAAS | Scoop.it
No comment yet.