Jump to content

ORM Designer

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Frehim (talk | contribs) at 10:33, 5 February 2014 (Created page with '{{Infobox software | name = ORM Designer2 | logo = | logo_size = frameless | screenshot = | caption...'). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)
ORM Designer2
Developer(s)Inventic, s.r.o.
Operating systemCross-platform[1]
Available inEnglish, Czech
TypeVisualization software
LicenseProprietary software
Websitewww.orm-designer.com

ORM Designer is a visualization tool and code/schema generator for PHP ORM frameworks like Doctrine2, Doctrine, Propel, and CakePHP, which are used to create database abstraction layer. [2][3][4][5] Developed by Czech company Inventic, s.r.o. based in Brno[2].

Overview

  • Generates visual model from the schema definition files [2][3][4]
  • Repetitive import/export of schema definitions in supported formats (XML,YML,PHP annotations) [2][3][4]
  • Schema definition files are automatically generated from the visual model [2][3][4]
  • Visual representation uses ER diagram extended by concepts of inheritance and many-to-many.[2][3][4]
  • Supports customization using .xml configuration files and JavaScript[2][6][7]
  • Does not support direct connections to the database [8]
  • Crude and simplistic visual representation and menus [9]

Architecture

ORM Designer was build on the Qt framework. Import/export of the schema definitions uses XSL transformations powered by LibXslt library. Imported source files are first converted to XML format: no conversion for XML, simple conversion for YML, creating the Abstract Syntax Tree and its subsequent conversion to XML for PHP annotations. The import/export scripts are configured in JavaScript and can be freely customized.[10]

Supported ORM frameworks

Frameworks supported for visual model and schema files generation[11]:
Doctrine2
Doctrine
Propel
CakePHP

History

ORM Designer was created as an internal tool for the web applications developed by Inventic. It was first published as a commercial tool in 2009.[12][13] Application was reworked and optimized in January 2013, and released as ORM Designer 2.[10][14] In May 2013 ORM Designer became part of the South Moravian Innovation Center Incubator program (support program for innovative technological startups). [13][15][16]

See also

List of object-relational mapping software
Comparison of object-relational mapping software
Object-relational mapping
Database abstraction layer

References