InformationTechnology:Modeling:Database

Contents 1 Navigation 2 Related categories 3 About this page 4 Database modeling tools 5 Object Role Modeling (ORM) 6 Resources

Navigation

Related categories

About this page

We apologize for the little information we provide, this page is still under construction. Please stay tuned.

Database modeling tools

• Quest Toad Modeler (formerly Charonware CaseStudio) [1]
  • Supports Entity Relationship Diagrams (ERD) and Data Flow Diagrams (DFD)
  • Supports reverse-engineering of popular RDBMS (Oracle, mySQL, PostgreSQL, DB2, Sybase, Informix, etc)
• Sybase Power Designer [2]
• Oracle Designer 2000 and JDeveloper
• Data Architect [3]
• PyDBDesigner - free Entity-Relation modelling tool [4]

Object Role Modeling (ORM)

ORM is a modeling methodology, for non-technical users, of designing and querying database models while capturing business rules.

• Object-Role Modeling overview [5]
• Data modeling in UML and ORM - a comparison [6]
• Business Rules and Object Role Modeling [7]
• Object-Role Modeling (ORM/NIAM) [8]
• Augmenting UML with Fact-orientation - Object Role Modeling [9]
• UML Data Models From An ORM Perspective (to be found here) - local copies
  • part 1
  • part 2
  • part 3
  • part 4
  • part 5
  • part 6
  • part 7
  • part 8
  • part 9
  • part 10
  • part 11
  • part 12
  • part 13

Resources

• CIM Database Model White Paper [10]
• Mapping objects to relational databases [11] (local copy)
• Professional community of Data Modelers, Database Designers and Data Architects [12]
• "Federate" RDBMS/RDF gateway - overview [13]