|
1. Introduction
EclipseDatabase is a general purpose Database Tool.
It lets you manage the design of your Database and generate java
code to access your Database.
This tool is designed with open technologies which provide software
independance.
Everything is stored in XML, there is no binary cryptic information.
Most of the generators are templates based and so users can modify
the templates to fit their needs.
(Click on image for full size)
The tool is designed to address the most used Databases.
To Access your Database, EclipseDatabase proposes you
several Object Mapping technologies.
2. Modeling
Database Modeling is Java independent.
It means that you can either create Database Connection and Diagrams
into Simple Project, Java Project, C Project or other kind of Projects
existing on your Eclipse Platform.
This tool focuses on database description and its associated
Database Description Language SQL.
The goal of the tool is to provide a Database Modeler to Development
Team.
This tool is not Database administrator or production targeted.
2.1. Database Connection
The Database Connection file is the central piece in EclipseDatabase.
The following UML diagrams show you how the different
database files are connected.
(Click on image for full size)
This xml file gathers the references for each database
piece :
(Click on image for full size)
2.2. Database Schema
(Click on image for full size)
This xml file gathers all of your Database Meta Datas
description.
The Database Schemas are Apache Torque and
Apache Turbine compatible.
There is only one Schema associated to a Connection.
2.3. Database Schema DTD
(Click on image for full size)
Each Schema file is associated with one DTD.
This DTD acts as a dictionary of your Database Schema Meta Data.
This DTD is Apache Torque
and Apache Turbine
compatible.
2.4. Database Diagram
(Click on image for full size)
Each Database Connection can view its Schemas in a graphical way.
This is the purpose of the Database Diagram.
You can have more than one diagram associated to a Database
Connection.
This file is xml based :
(Click on image for full size)
2.5. Database SQL
(Click on image for full size)
The tool is able to generate two kinds of SQL files :
- Database Create SQL Script
- Database Schema SQL Script
2.6. Database Data
(Click on image for full size)
This xml file gathers all of your Database Datas
This file is Database Connection specific.
This file is generated when running the Database Data DTD
and XML Resources wizard.
2.7. Database Data DTD
This dtd file acts as the dictionary of a Database Data
file.
This file is Database Connection specific.
This file is generated when running the Database Data DTD and XML Resources
wizard.
3. Code Generation
Database Code generation is Java dependent.
It means that you need to create a Java Project to generate your Java Code.
However you can define a Simple Project to hold your Database
description while you use a Java Project for your application.
3.1. Torque
Torque is a persistence layer.
Torque is an Apache Software Foundation Project.
EclipseDatabase is able to generate :
- Torque.properties file
- Object Mapping Java objects
3.2. Object Relational Bridge
ObJect Relational Bridge (OJB)
is an Object/Relational mapping tool that allows transparent
persistence for Java Objects against relational databases.
OJB is an Apache Software Foundation Project.
EclipseDatabase is able to generate :
- repository.xml file
- repository_internal.xml file
- repository_schema file
- OJB Java objects
3.3. Hibernate
Hibernate is an
object/relational persistence and query service for Java.
EclipseDatabase is able to generate :
- Hibernate configuration file
- Hibernate Java objects
- Stateless Session Bean
|
