Tag: Data Model

Technology - Why Business Intelligence (BI) needs a Semantic Data Model

Technology – Why Business Intelligence (BI) needs a Semantic Data Model

A semantic data model is a method of organizing and representing corporate data that reflects the meaning and relationships among data items. This method of organizing data helps end users access data autonomously using familiar business terms such as revenue, product, or customer via the BI (business intelligence) and other analytics tools. The use of a semantic model offers a consolidated, unified view of data across the business allowing end-users to obtain valuable insights quickly from large, complex, and diverse data sets. What is the purpose of semantic data modeling in BI and data virtualization? A semantic data model sits

Continue reading

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 times when working with existing data sets it is essential to understand the nature the existing data to begin the modeling and information governance process. Column Data Classification Generally, individual columns can be classified into the classifications: Identifier — A column/field which is unique to

Continue reading

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 information.   These common models can be leveraged as accelerators by organizations form the foundation for their information, including SOA interchanges, Mashup, data vitalization, Enterprise Data Model (EDM), business intelligence (BI), and/or to standardize their data models to improve meta data management and data integration practices.

Continue reading

What are the Factor Affecting the Selection of Data Warehouse Naming Convention?

The primary factors affecting the choices in the creation of Data Warehouse (DW) naming convention policy standards are the type of implementation, pattern of the implementation, and any preexisting conventions. Type of implementation The type of implementation will affect your naming convention choices. Basically, this boils down to, are you working with a Commercial-Off-The-Shelf (COTS) data warehouse or doing a custom build? Commercial-Off-The-Shelf (COTS) If it is a Commercial-Off-The-Shelf (COTS) warehouse, which you are modifying and or enhancing, then it is very strongly recommended that you conform to the naming conventions of the COTS product.  However, you may want to

Continue reading

Data Modeling – Database Table Field Ordering Effective Practices

Field order can help the performance on inserts and updates and, also, keeps developer and users from having to search entire table structure to be sure they have all the keys, etc. Table Field Ordering Distribution Field Or Fields, if no distribution field is set the first field will be used by default. Primary Key Columns (including Parent and Child key fields) Foreign Key Columns (Not Null) Not Null Columns Nullable Columns Created Date Timestamp Modified (or Last Updated) Date Timestamp Large text Fields Large binary Columns or Binary Field references Related References Data Modeling – What is Data Modeling?

Continue reading

Infosphere Data Architect Install Error CRIMC1029E or CRIMC1085E

The CRIMC1029E / CRIMC1085E errors may be caused by running the incorrect Infosphere Data Architect installer.  If you run the admin installer (launchpad.exe) on 64bit windows with insufficient privileges, the process will throw a CRIMC1029E / CRIMC1085E error. What the Error Looks Like Installation failed. CRIMC1029E: Adding plug-in com.ibm.etools.cobol.win32_7.0.921.v20140409_0421 to repository E:Program FilesIBMSDPShared failed. CRIMC1085E: Resumable download failed for: file:/E:/InstallIBM/INFO_DATA_ARCH_V9.1.2_WIN/disk2/ad/plugins/file000086. ‘plug-in com.ibm.etools.cobol.win32_7.0.921.v20140409_0421’ does not exist (at file:/E:/InstallIBM/INFO_DATA_ARCH_V9.1.2_WIN/disk2/ad/plugins/file000086). Elapsed time 00:00.00. Solution Run the launchpad_win_nonadmin64.exe file, instead of the launchpad.exe file. Reference Link: Installing IBM InfoSphere Data Architect with the Installation Manager Install wizard https://www.ibm.com/support/knowledgecenter/SS9UM9_9.1.2/com.ibm.datatools.rda.install.doc/topics/t_install_product.html?lang=en

Continue reading