Open Source Models

Getting back to ORMs - Need help

Stephen Hampton — Fri, 12 Feb 2010 00:37:52 GMT

Hi, I'm new to the forums here. I haven't done any ORMs for 10 years and I need to get back into it. I'm doing up an ORM that encompasses employee details, laptop details, and all software and accessories. I've done up a "first draft" in VisioModeler but I'm sure I've missed a lot of required constraints. Is there anyway I can upload the file so someone could check it out for me? Thanks

Talent Agency - CQL

Ken Evans — Thu, 29 Oct 2009 11:51:39 GMT

Clifford's conversion of Tyler's "Talent Agency" model is a good example of what can be done with an ORM file.

However, I'm left wondering how to correctly read the file?
When I downloaded Clifford's CQL file of Tyler's "Talent Agency", the file opened in notepad by default! (quite a mess)
When I opened it in Word, I saw a list of XML like statements. (much more helpful)

So right now I have two questions:
1: What editor should I use to open the file?
2: How would I use the file? (i.e. in what part of the development process?)

Clifford, can you help here?

Ken

Common Models

Tyler Young — Fri, 23 Oct 2009 15:17:22 GMT

First of all, thanks to Ken for setting up this new section of the boards!

In my part time I enjoy making websites, and very often the projects I want to do are for specialized domains. Over the years I've done various (amateur) models of climate zones, a talent agency, message boards, microarrays for proteomic expression, and numerous other things. Often, the projects have overlapping areas. While NORMA doesn't yet support the combining of separate models, it might be of value to the community to share our experiences and some of the commonly used models that we've come up with.

To start us out I'll be posting several models that I've worked on over the years. The search through my archives just finished, and it looks like I've made a total of 81 models. Go me! Most of them are trivial bits of fluff, but we can look at them as a starting point until other people want to share too. In the meantime, they're available for discussion and anyone is free to download and modify as they see fit. All I ask is that you upload the results of your modification so that we can grow as a community. Surely there's some sort of open-source license that's appropriate for this... any suggestions? Once I figure that out, consider them all released under that license. :)

So join the fun! Post pieces of models that you commonly use, and let's start working on a community library that we can all benefit from!

Talent Agency

Tyler Young — Tue, 27 Oct 2009 20:10:30 GMT

I just posted the Talent Agency model in the OSM section of the Library. The details document contains screen shots of all the pages, as well as the logical model and the SQL. The NORMA model is also available.

I'll post other models as I create their respective documentation, but for now at least the ball is rolling. You'll notice that several of the areas that are not specific to the talent agency domain are modeled quite thin. This is not a production system, so there may be glaring logical errors. Please feel free to discuss it, tear it apart, and come up with something better.

One of the goals of posting this model is to demonstrate the need for open-source, reusable models that allow us to focus on our core domains. I would have saved hours of work by not modeling the address and invoice sections from scratch.

This model was created when I was not employed by any talent agency, and I am the owner of it. I hereby release it under the GPLv3 open source license.