Tags » Data Model

Considerations for Relationships

  • You can convert a master-detail relationship to a lookup relationship as long as no roll-up summary fields exist on the master object.
  • You can convert a lookup relationship to a master-detail relationship, but only if the lookup field in all records contains a value.
  • 50 more words

Refactoring Databases P2.5: Scoping the Cheats

One of the side-effects of the little cheat posted here is that, if we are going to design early we have to decide what we will design early… and this question has two complications. 302 more words


MDM Tools Revealed

Every organization needs Master Data Management (MDM). But does every organization need a MDM tool?

In many ways the MDM tools we see on the market resembles common database tools. 464 more words


How we model data: Making gazette notices standard and comparable

A few weeks ago, we announced the launch of OpenGazettes, a new project that will make the information in government gazettes more accessible. Gazettes are periodicals in which notices are published to comply with legal requirements for public notice. 734 more words


Simplifying Pivot Tables by hiding unwanted columns (using Power Pivot)

Unwanted or redundant columns can confuse the users of Pivot Table. Here is how you can remove unwanted columns from appearing in the Pivot Table field list. 501 more words


Inmon or Kimball? The debate of the century...

When designing a data warehouse we are faced with a very important decision to make. This concerns the data warehouse architecture. Do we adopt the Inmon approach or rather, follow the philosophy of Ralph Kimball? 551 more words

Data Warehouse

SALE: Oracle SQL Developer Data Modeler Jump Start

So in honor of the upcoming #OOW15 and User Group Sunday Symposiums, I decided to put my video workshop for #SQLDevModeler on Sale!

Why use #SQLDevModeler? 812 more words