![existing universal database models existing universal database models](https://www.rklesolutions.com/hs-fs/hubfs/Balance%20Sheet.png)
Note 2: Not all aspects are applicable all the time. For example, a company has a board, is the owner of an installation, produces computers, has resellers, is located in a certain town, is 25 years in business to date, is profitable, etc. Note 1: Most aspects can have a relation with each other and dependent on the need for the data model, they can be described. Even users without a background in data can understand and refine these models. In the same way, the Internet links data together, you can link your own data in a meaningful way. In this short blog, I hope I have shown you that data models can be very universal at the highest level and in structure. There are also constructions such as roads, dykes and pipelines. There are also bridges for cars, bridges for pedestrians. For example, an object can be a construction, which can be a bridge, which can be a bridge for trains. TaxonomyĪ taxonomy gives more specific terms, more narrowly defined terms. For example, a party consists of a company, which consists of departments, which consists of teams, which consists of persons. With decomposition, you describe all the parts that make the whole. These aspects will be refined in 2 ways: as decomposition and as taxonomy. To refine these aspects further and make them specific for your business, you can refine them. This kind of model is based on linked data principles and allows many organisations on the Internet to link their data with data from others in a meaningful way. The beauty is, that a universal model like this can also be very easily understood by computers. As you go along and there is a need, you can go more detailed. The good thing is that these aspects can be refined to describe much more detailed parts of your business.
![existing universal database models existing universal database models](https://utthunga.com/wp-content/uploads/2020/10/IEC61850-_architecture.jpg)
I think you can apply these aspects easily to your own situation. state – the state of a thing (for example ‘profitable’ for a company, ‘retired’ for an object, ‘in progress’ for an activity, ‘decommissioned’ for an installation).
Existing universal database models driver#
Existing universal database models series#
activity – an act or series of acts by a party or an object.requirement – a prerequisite of an object, party or activity.geometry – the shape in 2D or 3D or as a network.location – an absolute, relative, long/lat or a named location.event – an occurrence of something (for example an accident or a measurement).time – a point or period in time, either relative or absolute (for example a ‘week’ or WWII).party – a person, group or organisation.object – a physical object or abstract object (a database for example).The aspects I have used are common, but following good data architecture practice, I want to define them: In the diagram below, I have put 12 aspects, that together can describe 99% of what any business or organisation does.
![existing universal database models existing universal database models](https://www.bestshareware.net/download/img3/erd-concepts-big.jpg)
There is a very simple and meaningful way to describe the data that organisations use in a language that we all understand and use. More often than not, the ‘business user’ does not recognise their own data in these complex structures and models. This one is certainly for you! Hang on in, please.įor people who are not fully submerged in data practices, it is often very difficult to understand data models. Oh boy, non-technical readers, please keep reading.