FrenchTech SAAS
33.5K views | +3 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
November 24, 2016 3:31 AM
Scoop.it!

Qu'est-ce qu'est Open ModelSphere?

Open ModelSphere est un outil de modélisation et de gestion de modèles, unique en son genre, qui combine les fonctionnalités de modélisation de processus (diagramme de flux de données), de données et UML, tout en offrant un environnement de gestion de modèles des plus flexibles. Parce qu'il a été conçu en Java, et qu'il s'appuie sur une machine virtuelle standard, Open ModelSphere peut être installé sur la plupart des plateformes, soit Windows, Linux et Unix.

Mickael Ruau's insight:

Open ModelSphere permet aux utilisateurs de construire leurs modèles plus facilement, à partir de zéro ou via rétro-ingénierie provenant d'une variété de sources (SGBDR ou autres sources non-relationnelles comme Java). Les utilisateurs peuvent choisir entre plusieurs systèmes cibles SQL, comme Oracle, Informix, SQL Server de Microsoft, Sybase et DB2 UDB. Ensuite, ils peuvent facilement employer le processus de génération pour mettre leurs bases de données à jour. Open ModelSphere propose également une fonction de génération de rapport en format HTML améliorée, permettant une personnalisation du contenu et du format.

No comment yet.
Scooped by Mickael Ruau
November 22, 2016 12:04 PM
Scoop.it!

Open ModelSphere

Open ModelSphere | FrenchTech SAAS | Scoop.it

Open ModelSphere can run on a Macintosh computer

Mickael Ruau's insight:

Q: How can I do to run Open ModelSphere on Macintosh?


1) As Open ModelSphere runs in Java, make sure you have installed a JRE (Java runtime environment) on your machine. 

2) Do not download "Open ModelSphere" with Windows installer, but rather the zipped version (.zip). Unzip the archive.

3) You will have to write a shell script for Mac OS. A shell script is a text file that executes OS commands, in our case launches the JVM (Java virtual machine). Here is an example of a script that launches Open ModelSphere

No comment yet.
Scooped by Mickael Ruau
November 11, 2016 6:16 AM
Scoop.it!

auth_admin - PHP & MySQL - Logiciels Libres - Framasoft

Gestionnaire d'accès pour des utilisateurs pour PHP/MySQL
No comment yet.
Scooped by Mickael Ruau
November 9, 2016 6:14 AM
Scoop.it!

MyIGSR - Utilitaires - Logiciels Libres - Framasoft

Interface de Gestion des Sauvegardes et des Restaurations pour MySQL
No comment yet.
Scooped by Mickael Ruau
November 8, 2016 3:13 AM
Scoop.it!

30 mins avec JSON en MySQL | dasini.net - Journal d'un expert MySQL

Quick review of Native JSON Data Type and generated columns in MySQL 5.7
No comment yet.
Scooped by Mickael Ruau
November 7, 2016 3:12 AM
Scoop.it!

Inner vs Outer Joins on a Many-To-Many Relationship

Inner vs Outer Joins on a Many-To-Many Relationship | FrenchTech SAAS | Scoop.it
Someone will probably tell me that this is an elementary-level topic, but I got some good questions regarding joins from my most recent ZCE class students, so I thought I’d put down the examp…
No comment yet.
Scooped by Mickael Ruau
November 4, 2016 2:58 AM
Scoop.it!

How good is UML for Database Design? Interview with Michael Blaha. | ODBMS Industry Watch

How good is UML for Database Design? Interview with Michael Blaha. | ODBMS Industry Watch | FrenchTech SAAS | Scoop.it

The UML is a good notation for conceptual data modeling. The representation stands apart from implementation choices, be it a relational database, object oriented database, files, or some other mechanism.

Q2. What are the main weaknesses of UML for database design? And how do you cope with them in practice?

Blaha: First consider object databases. The design of object database code is similar to the design of OO programming code. The UML class model specifies the static data structure. The most difficult implementation issue is the weak support in many object database engines for associations. The workaround depends on object database features and the application architecture.

Now consider relational databases. Relational database tools do not support the UML. There is no technical reason for this, but several cultural reasons. One is that there is a divide between the programming and database communities; each has their own jargon, style, and history and pay little attention to the other.
Also the UML creators focused on unifying programming notation, but spent little time talking to the database community.
The bottom line is that the relational database tools do not support the UML and the UML tools do not support relational databases. In practice, I usually construct a conceptual model with a UML tool (so that I can think deeply and abstractly).
Then I rekey the model into a database tool (so that I can generate schema).

No comment yet.
Scooped by Mickael Ruau
November 3, 2016 6:58 AM
Scoop.it!

Entity relationship modeling with UML

Entity relationship modeling with UML | FrenchTech SAAS | Scoop.it
Entity Relationship Modeling (ER) defines the methodology often used by database designers to gather requirements and define the architecture of database systems. This white paper defines the core concepts of ER modeling and explains how UML can be used by development teams to develop ER models.
No comment yet.
Scooped by Mickael Ruau
November 3, 2016 5:56 AM
Scoop.it!

The Process of Database Refactoring: Strategies for Improving Database Quality

The Process of Database Refactoring: Strategies for Improving Database Quality | FrenchTech SAAS | Scoop.it

 

Table of Contents
  1. Refactoring
  2. Database Refactoring  
  3. Why Database Refactoring is Hard
  4. How to Refactor Your Database 
  5. Adopting Database Refactoring Within Your Organization  
  6. Database Refactoring Best Practices
  7. Database Refactoring in the Real World  
  8. The Catalog of Database Refactorings (posted as another page)

 

No comment yet.
Scooped by Mickael Ruau
November 3, 2016 5:32 AM
Scoop.it!

Database Testing: How to Regression Test a Relational Database

Database Testing: How to Regression Test a Relational Database | FrenchTech SAAS | Scoop.it
Table of Contents
  1. Why test an RDBMS?
  2. What should we test?
  3. When should we test?
  4. How should we test?
  5. Who should test?
  6. Introducing database testing into your organization
  7. Database testing and data inspection
  8. Best practices

 

No comment yet.
Scooped by Mickael Ruau
November 3, 2016 5:26 AM
Scoop.it!

Data Modeling 101

Data Modeling 101 | FrenchTech SAAS | Scoop.it
Table of Contents
  1. What is data modeling?
  2. How to model data  
  3. Evolutionary/agile data modeling
  4. How to become better at modeling data 

 

Mickael Ruau's insight:

Notations anglo-saxonnes pour la modélisation des bases de données.

 

No comment yet.
Scooped by Mickael Ruau
November 3, 2016 5:12 AM
Scoop.it!

Mapping objects to relational databases

Mapping objects to relational databases | FrenchTech SAAS | Scoop.it
Why is mapping objects to relational databases an issue for modern developers? For one thing, object technology, such as Java technology, is the most common environment applied for the development of new software systems. Also, relational databases are still the preferred approach for storage of persistent information and are likely to remain so for quite some time. Read on to see how you'll put this skill to use.
No comment yet.
Scooped by Mickael Ruau
November 3, 2016 4:55 AM
Scoop.it!

DB-UML Database Modeling Tool

DB-UML Database Modeling Tool | FrenchTech SAAS | Scoop.it

Database Modeling Tool DB-UML is an open source modeling tool for creating, updating and visualizing relational database schemas.

No comment yet.
Scooped by Mickael Ruau
November 23, 2016 5:09 AM
Scoop.it!

Les BCR (règles internes d'entreprise) | CNIL

Les BCR (règles internes d'entreprise) | CNIL | FrenchTech SAAS | Scoop.it
Des BCR « responsable de traitement » et « sous-traitant » Jusqu’à fin 2012, les BCR (dites « responsable de traitement) ne permettaient d’encadrer que des transferts effectués au sein d’un groupe agissant en qualité de responsable de traitement. Fort de ce succès et constatant que les outils d’encadrement des transferts existants ne sont pas suffisamment adaptés à des situations d’externalisation ou de cloud computing, le Groupe des CNIL européennes («G29») a officiellement lancé les BCR «sous-traitant» le 1er janvier 2013.
No comment yet.
Scooped by Mickael Ruau
November 12, 2016 8:15 AM
Scoop.it!

Deux failles dans MySQL, MariaDB et PerconaDB permettent à un simple utilisateur d'avoir des privilèges root, des correctifs sont disponibles

Deux failles dans MySQL, MariaDB et PerconaDB permettent à un simple utilisateur d'avoir des privilèges root, des correctifs sont disponibles | FrenchTech SAAS | Scoop.it

Récemment, un hacker éthique du nom de Dawid Golunski a découvert un

No comment yet.
Scooped by Mickael Ruau
November 10, 2016 6:14 AM
Scoop.it!

Adminer - Database management in a single PHP file

Adminer - Database management in a single PHP file | FrenchTech SAAS | Scoop.it
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB.
No comment yet.
Scooped by Mickael Ruau
November 8, 2016 4:27 AM
Scoop.it!

Mapping Objects to Relational Databases: O/R Mapping In Detail

Mapping Objects to Relational Databases: O/R Mapping In Detail | FrenchTech SAAS | Scoop.it
Table of Contents
  1. Basic mapping concepts
  2. Mapping inheritance structures  
  3. Mapping object relationships
  4. Mapping class-scope properties
  5. Performance tuning
  6. Implementation impact on your objects
  7. Implications for Model Driven Architecture (MDA)
  8. Patternizing what you have learned

 

No comment yet.
Scooped by Mickael Ruau
November 7, 2016 3:59 AM
Scoop.it!

Modeling the enterprise data architecture

Modeling the enterprise data architecture | FrenchTech SAAS | Scoop.it
from The Rational Edge: This article describes a new approach, based on the Unified Modeling Language (UML), which the authors believe meets the real requirements for modeling an enterprise data architecture.
No comment yet.
Scooped by Mickael Ruau
November 4, 2016 4:10 AM
Scoop.it!

Explaining MySQL's EXPLAIN

Explaining MySQL's EXPLAIN | FrenchTech SAAS | Scoop.it
The MySQL explain plan is a great tool to help developers and database administrators to improve the performance of specific queries happening against a database. It is very easy to use, but its ou…
No comment yet.
Scooped by Mickael Ruau
November 4, 2016 1:57 AM
Scoop.it!

UML for Database Design

UML for Database Design | FrenchTech SAAS | Scoop.it
By IBM Rational authors, Eric J. Naiburg and Robert A. Maksimchuk. This book introduces the Unified Modeling Language (UML) and how it can be applied to database modeling and design. Read an excerpt.
Mickael Ruau's insight:

Read the following excerpts (in PDF format):
Chapter 2: Database Design from Requirements to Implementation
Chapter 7: Database Design Models -- the UML Profile for Database Design

No comment yet.
Scooped by Mickael Ruau
November 3, 2016 5:56 AM
Scoop.it!

Developing Object-Relational Database Applications, Part 1: database analysis and design methodology

Developing Object-Relational Database Applications, Part 1: database analysis and design methodology | FrenchTech SAAS | Scoop.it
The following article was previously published in the Informix Tech Notes quarterly journal. The Tech Notes archive covers the years 1991 to 2001. This is the first article in a two-part series on developing object-relational database applications.
No comment yet.
Scooped by Mickael Ruau
November 3, 2016 5:41 AM
Scoop.it!

DatabaseToUML

DatabaseToUML | FrenchTech SAAS | Scoop.it

DatabaseToUML download. DatabaseToUML 2013-04-29 16:42:42 free download. DatabaseToUML The goal is to generate UML classes from an existing database. Connect to a database, read its schema and produce UML 2 classes

No comment yet.
Scooped by Mickael Ruau
November 3, 2016 5:29 AM
Scoop.it!

Agile/Evolutionary Data Modeling: From Domain Modeling to Physical Modeling

Agile/Evolutionary Data Modeling: From Domain Modeling to Physical Modeling | FrenchTech SAAS | Scoop.it
Table of Contents
  1. The Case Study
  2. The Initial Requirements
  3. The Initial Domain Model
  4. Iteration 1
  5. Iteration 2
  6. Iteration 3
  7. "Disaster Strikes" and the Requirements Change
  8. The Updated Domain Model
  9. Iteration 4
  10. Iteration 5
  11. Iteration 6
  12. Going Straight to Physical Data Modeling
  13. Critical Lessons in Agile Data Modeling
  14. References

 

No comment yet.
Scooped by Mickael Ruau
November 3, 2016 5:08 AM
Scoop.it!

Database Modeling in UML | EE Times

Database Modeling in UML | EE Times | FrenchTech SAAS | Scoop.it

When it comes to providing reliable, flexible, and efficient object persistence for software systems, today's designers and architects are faced with many choices. From the technological perspective, the choice is usually between pure Object-Oriented, Object-Relational hybrids, pure Relational, and custom solutions based on open or proprietary file formats.

Mickael Ruau's insight:

This article is about only one of those choices, that is the layering of an object-oriented class model on top of a purely relational database. This is not to imply this is the only, best, or simplest solution, but pragmatically it is one of the most common, and one that has the potential for the most misuse.

No comment yet.