Difference between revisions of "GOCDB/Doctrine"

From EGIWiki
Jump to: navigation, search
(Replaced content with "Moved to GOCDB/Release4/Development/v5")
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Template:Op menubar}}
Moved to [[GOCDB/Release4/Development/v5]]
[[Category: GOCDB]]
<< Back to [[GOCDB/Release4/Development]] <br />
= Introduction =
By replacing the PROM model with the [http://www.doctrine-project.org Doctrine ORM] GOCDB will support RDBMSs other than Oracle. This will be released as GOCDB 5.
= Benefits =
* Write code once, deploy to Oracle, MySQL, Postgres, SQLite.
* Much simpler than the [[GOCDB/PROM]] model (see query comparison below)]
* Easier for other projects to extend / modify
* Easier for new developers to learn
* Better performance
** Reduced risk of failover performance issues
|[[File:Get_Site_PROM.png|200px|thumb|left|PROM SQL]]
|[[File:Get_Site_Doctrine.png|200px|thumb|left|Doctrine SQL]]
= Drawbacks =
* Data will be deleted rather than marked as 'off'. We therefore require an audit table to record who/when performed data deletions/updates (this is already on the requirements roadmap however).
* Loose some flexiblity as the DB will manage the relationships (FKs) between entities rather than the application (but in turn we gain performance/simplicity/db-agnostic).
* Changes to Portal URLs and object IDs (below)
= Changes =
The move to Doctrine will introduce changes to the GOCDB portal URLs and to the PRIMARY KEY, ID and GOCDB_PORTAL_URL fields of the GOCDB PI.
== Portal URLs ==
In PROM, each "entity" (site, service endpoint, downtime) was assigned an ID from a global pool. There is only one object 123, the GRIDOPS-GOCDB site. The following URL is used to access an entity regardless of type:
In Doctrine, each entity receives an ID unique only to that entity type. There is a site with ID 123, a service endpoint with ID 123 and a downtime with ID 123. The new URL will reflect the entity type:
(...and so on for each GOCDB entity type)
== PI XML Output Values ==
In the GOCDB PI there are a number of PROM specific XML values that will change if we move to Doctrine: PRIMARY_KEY, ID and GOCDB_PORTAL_URL. These are highlighted in RED below:
The PRIMARY_KEY and ID fields are generated by PROM and will be either removed or replaced with similar values from Doctrine.
We would like to remove the ID field entirely and use the primary key only. The primary key will be purely numeric and unique only to the specific entity type (e.g. there will be a Site with ID 5 and a Service Endpoint with ID 5).
= Request for Comments =
If these changes affect a system that reads from the GOCDB-PI or links to the web portal please [mailto:gocdb-admins@mailman.egi.eu let us know].

Latest revision as of 14:51, 5 August 2013