Oracle Naming Conventions

When designing a database it’s a good idea to follow some sort of naming convention. This will involve a little thought in the early design stages but will save significant time when maintaining the finished system.

It’s less important which exact conventions you choose to follow – but this page has a few suggestions.

The benefits of using a naming convention are more to do with human factors than any system limitations – but this does not make them any less important.

Continue reading “Oracle Naming Conventions” »

Entity Mapping: Table-per-type and Table-per-hierarchy

In the object world, Inheritance is natural thing. However the flat data model cannot be easily mapped to the hierarchy object model. Entity Framework provide TPT and TPH to solve this problem.  

Continue reading “Entity Mapping: Table-per-type and Table-per-hierarchy” »

Creating Grails Custom Constraints

Now and than there is the requirement to create custom constraints. As you might already know, there are plenty of constraints that already are shipped with Grails. Those can be applied in the constraints closure of your domain or command classes:

Continue reading “Creating Grails Custom Constraints” »