Sydney Water plans SOA to data warehouse bridge

The utility, which is already three years into a large-scale data warehouse initiative , told iTnews that it is now starting to address the contextual relationship between the warehouse and its SOA environment.

“We recognised it’s not much of a stretch that a business object that the warehouse has and a business object that the SOA has – a customer, for example – might share similar properties,” said Ralph Mackey, enterprise data architect at Sydney Water.

“There’s a potential to identify ‘apples’ in both spaces. The question is how do you integrate that on a practical level?”

Mackey said the utility is in the process of identifying logical design concepts to facilitate ‘semantic consistency’ between the environments.

It is also ‘6 to 12 months’ into a new program of work around unstructured data that will see up to seven new projects rolled out internally.

At least one of these projects is understood to involve defining a document standard for metadata.

“We’ve been able to produce a data model that shows unstructured content linked to structured content – for example, an account identification concept linked to a billing statement,” explained Mackey.

The utility is approximately two years away from integrating unstructured content with information stored in the data warehouse, Mackey said.

It will utilise the ‘main components’ of Inmon’s DW 2.0 framework to make this happen, he added.

datasoastoragesydneywarehousewater