Data Architecture for Applications

Support for hierarchical models such as JSON, MongoDB and Google BigQuery

Data is the bedrock of the information technology (IT) organization and the lifeblood of the business. Every year we amass more of it and the regulations and risks around it grow. Data governance and data management are goals that grow more important. Our data architecture team has traditionally worked hard to design and document static data assets (that is, databases) against standardized information models using logical data models. But IT staff dealt separately with data in transit and data in use.

The issue here is that one often serializes data in transit or data in use, employing structures like JavaScript object notation (JSON) that are hierarchical. Denormalization is common. These structures differ from the relational, normalized structures employed in databases.

ER/Studio now employs unique and novel techniques to bring together these worlds.