Posts Tagged ‘data architecture’

Forrester recently released some research titled “Reset on Big Data” and this research highlighted the lag between IT’s understanding of Big Data’s role within the enterprise data ecosystem.   In short, business leaders were 40% less likely to cite Big Data’s role as an extension to the current the current analytical environment.  This is not surprising […]

One of the not so nice parts of the conference is seeing companies that have technology that have been superseded by the new releases of Hadoop, primarily Hive. One company, boasted about the fact it did not have to do full scans and could return SQL queries in seconds on large datasets. The look on […]

Before 2000, primary challenges for companies were to enable the systems so that transactional data could be captured faster for organizational productivity, now gear is shifted towards delivery of information to the business users through reporting, analytical system and actionable drill down dashboard etc that organization have stored in files, data, audio and video stream etc on propriety clustered and […]

Data model patterns identify common model structures and define how they should look and interact with other parts of the model.  PowerDesigner can assist in this process by automating the setup of objects (tables, columns, mappings) based on the pattern to be applied and ensuring consistency through the use of custom model checks. Stereotypes Anyone […]

In its most basic form, deploying a data model means simply applying the model directly to a database via ODBC or a DDL script.  But that neglects much of that value in your model beyond the physical structure. Here are the steps in our model deployment process.  We’ve scripted these in the build tool, but […]

Once you’ve invested the time and effort into creating really solid, well documented data models, it would be really great to let some folks know about it, right!?!? If you’re using PowerDesigner, you’ve got a few options: Use the included (in some editions) web repository.  This requires the use of the model repository and displays […]

In our standards XEM file (extended model definition), I’ve added column ordering functionality by categorizing each column and then ordering the categories. Column groups are defined in a BaseColumn template.  We have:   PRIM,0,%Primary% ROWMETA,3,%extIsRowDateMeta% META,4,%extIsMetaColumn% AKNONMETA,1,%AllKeys% BASE,2,TRUE  

I love PowerDesigner.  It’s the Cadillac (Mercedes, BMW, etc.) of the modeling tools.  I love that I can do conceptual, logical, and physical data modeling.  I can do business process modeling with direct linkage to my data models.  And I can model mappings between everything for both data flow relationships (ETL mappings) and design flow […]