Database Reference
In-Depth Information
You can check it yourself, but just remember that the previously presented relational mod-
el from the real SR database is simplified for brevity. Nevertheless, using the model, you
can easily construct the insert statement to manually insert assets. In addition to asset
relations being constructed this way, the metadata domain also has a similar structure.
Tip
Another noteworthy, and rather important, point with regard to this type of DB model is
that, although quite simple in design and, probably, in the initial value population, the
key-value pair DB approach will most certainly turn into a nightmare from a maintenance
standpoint later. Key-value pairs in relational databases are a constant headache for
DBAs, SOA process owners, service custodians, and so on. Yes, the Oracle ER interface
around this previous model will solve this problem gracefully, but the main issue will per-
sist—the performance bottlenecks of your SQL statements during the runtime discovery
on your Mediators and Service Brokers. And don't think of turning to the Big Data
NoSQL model for this kind of metadata; this is not the case by any means. Quite soon,
you will see that the taxonomy can be really lightweight and compatible with a relatively
simple relational model.
In Chapter 1 , SOA Ecosystem - Interconnected Principles, Patterns, and Frameworks , we
mentioned another standard published by the HL7 group, called Service-Aware Interop-
erability Framework-Canonical Definition (SAIF CD) . We kept this framework for the
final discussion as we see it as an optimal model for lightweight repository implementa-
tion. Actually, it is not a single framework, it is an entire collection, covering Service Data
Modeling, Governance, Enterprise Consistency, Conformity, and several others. Some of
the frameworks (Governance) are completely based on the SOA concepts gathered in
Thomas Erl's topics. We will not repeat the concepts discussed in Chapter 1 , SOA Ecosys-
tem - Interconnected Principles, Patterns, and Frameworks . One framework is of particu-
Search WWH ::




Custom Search