Technology – Denodo Data Virtualization Project Roles

A Denodo virtualization project typically classifies the project duties of the primary implementation team into four Primary roles. Denodo Data Virtualization Project Roles Data Virtualization Architect Denodo Platform Administrator Data Virtualization Developer Denodo Platform Java Programmer Data Virtualization Internal Support Team Role To Project Team Member Alignment While the denodo project is grouped into security … More Technology – Denodo Data Virtualization Project Roles

Technology – Denodo Virtual Dataport (VDP) Naming Convention Guidance

Denodo provides some general Virtual Dataport naming convention recommendations and guidance.  First, there is the general guidance for basic Virtual Dataport object types, and secondly, more detailed naming guidance recommends.       Denodo Basic Virtual Dataport (VDP) Object Prefix Recommendations Associations Prefix: a_{name} Base Views Prefix: bv_{SystemName}_{TableName} Data Sources Prefix: ds_{name} Integration View Prefix: iv_{name} JMS Listeners Prefix: … More Technology – Denodo Virtual Dataport (VDP) Naming Convention Guidance

Data Modeling – Column Data Classification

Column Data Classification When analyzing individual column data, at its most foundational level, column data can be classified by their fundamental use/characteristics.  Granted, when you start rolling up the structure into multiple columns, table structure and table relationship, then other classifications/behaviors, such as keys (primary and foreign), indexes, and distribution come into play.  However, many … More Data Modeling – Column Data Classification

What is a Common Data Model (CDM)?

What is a Common Data Model (CDM)? A Common Data Model (CDM) is a share data structure designed to provide well-formed and standardized data structures within an industry (e.g. medical, Insurance, etc.) or business channel (e.g. Human resource management, Asset Management, etc.), which can be applied to provide organizations a consistent unified view of business … More What is a Common Data Model (CDM)?

Data Modeling – Fact Table Effective Practices

Here are a few guidelines for modeling and designing fact tables. Fact Table Effective Practices The table naming convention should identify it as a fact table. For example: Suffix Pattern: <<TableName>>_Fact <<TableName>>_F Prefix Pattern: FACT_<TableName>> F_<TableName>> Must contain a temporal dimension surrogate key (e.g. date dimension) Measures should be nullable – this has an impact on … More Data Modeling – Fact Table Effective Practices

Data Modeling – Dimension Table Effective Practices

I’ve had these notes laying around for a while, so, I thought I consolidate them here.   So, here are few guidelines to ensure the quality of your dimension table structures. Dimension Table Effective Practices The table naming convention should identify it as a dimension table. For example: Suffix Pattern: <<TableName>>_Dim <<TableName>>_D Prefix Pattern: Dim_<TableName>> … More Data Modeling – Dimension Table Effective Practices

What is BYOD?

What is BYOD? Basically, BYOD (bring your own device) is an information technology trend toward employee-owned devices within a business, in which consumer software and hardware are being integrated into the enterprise workplace. Benefits of BYOD The benefits of BYOD depend upon the point of view, here is a quick list Supports integrated remote work … More What is BYOD?