Technology – The Basics of Data Virtualization

Data virtualization is a process for loading metadata and physical views from source systems into another database. These mappings define how information is converted for integration. The result is the creation of a virtual database that represents a set of semantically similar data assets. The data assets can be accessed in different ways, depending on … More Technology – The Basics of Data Virtualization

Technology – Data Catalog Vs. Data Dictionary Vs. Business Glossary

The differences between a data catalog and a data dictionary are vast, and the choices of a single database can be overwhelming. The data dictionary depends on the data that is stored in the database. As a result, changes in data are likely to affect the dictionary as well. However, a data catalog will always … More Technology – Data Catalog Vs. Data Dictionary Vs. Business Glossary

Technology – Can A Hyperlink Be Added To A Denodo View Description?

In a recent meeting, we are running up against the maximum length of the view descriptions of 4,000 characters.  When someone asked the question “Can a hyperlink be added to a denodo view description?” So, I did some testing. Denodo Virtual Data Port (VDP)  in Denodo Virtual DataPort (VDP) and the short answer is yes.  … More Technology – Can A Hyperlink Be Added To A Denodo View Description?

Technology – What Is a Data Mesh?

The term “data mesh” refers to an architectural and organizational paradigm that originated in 2019. This concept is gaining momentum and is expected to be a major influence on how we organize, process, and analyze data. The data-centric approach is a critical component of the data-mesh architecture. In fact, the idea of creating a “data … More Technology – What Is a Data Mesh?

Technology – The Differences Between Data Mesh and Data Fabric

The debate over big data architectures has been going on for a while, and Data Mesh and Data Fabric have their fans and detractors. However, both have their advantages and disadvantages. Here are some of the most important points to consider when deciding which one is right for your company. Read on to discover the … More Technology – The Differences Between Data Mesh and Data Fabric

Technology – What is Data Fabric?

A data fabric is a virtual collection of data assets that is used to facilitate complete access and analysis. A data fabric is most useful for centralized business management. Distributed line operations will still use traditional data access and application interfaces. However, these fabrics are especially useful for national and regional segmented organizations. These systems … More Technology – What is Data Fabric?

Technology – The Power of a Data Catalog

A data catalog can be an excellent resource for businesses, researchers, and academics. A data catalog is a central repository for curated data sets. This collection of information helps you make the most of your information. It also makes your content more accessible to users. Many businesses use data catalogs to create a more personalized … More Technology – The Power of a Data Catalog

Technology – Should I Put My Whole Work History on LinkedIn?

You might be wondering if it’s a good idea to put your entire work history on LinkedIn. Your resume is the first thing that employers will see. It’s important to keep it relevant and to keep your experience to a minimum. However, if you’ve been working for a number of companies, it’s important to make … More Technology – Should I Put My Whole Work History on LinkedIn?

Technology – Some Pinterest Social Media Alternatives

Some Pinterest social media alternatives may be more fun than the original. While Pinterest is a popular information discovery tool, the site isn’t the only platform that uses images, GIFs, and videos. In addition to the pinboards that Pinterest provides, there are other sites that are just as fun. The following are a few alternatives … More Technology – Some Pinterest Social Media Alternatives

Technology – What Is An Iterative Approach In Software Development?

What is an iterative development approach? This software development method combines an iterative design process and an incremental build model. It can be applied to any type of software project. Iterative development approaches are also known as agile development. These methodologies are generally used for smaller projects. In many cases, a team of developers can … More Technology – What Is An Iterative Approach In Software Development?

Technology – Alternative Browsers For Chrome

Many of the more popular browsers, namely Microsoft’s Internet Explorer and Mozilla Firefox, are not considered “open source” browsers. This is because they are not developed by or developed for the community. Their code is not released under an Open Source license but instead is released under a Commercial License. These licenses can be a … More Technology – Alternative Browsers For Chrome

Technology – Denodo ODBC And JDBC Driver Virtual DataPort (VDP) Engine Compatibility?

Recently, while patching a Denodo environment, the question arose as to whether an older ODBC or JDBC driver can be used against a newer patched environment. It is described in the first paragraph of the denodo documentation, the directionality of the compatibility can be overlooked easily. Can An Older ODBC Or JDBC Driver Be Used … More Technology – Denodo ODBC And JDBC Driver Virtual DataPort (VDP) Engine Compatibility?

Technology – An Introduction to SQL Server Express

If you use SQL, several options are open to you, from the Enterprise editions down to SQL Server Express, a free version of Microsoft’s main RDBMS (Relational Database Management System), SQL Server. SQL Server is used to store information and access other information from multiple other databases. Server Express Edition is packed with features, such … More Technology – An Introduction to SQL Server Express

Technology – 5 Best Free Online Flowchart Makers

Did you know that you can create stunning flowcharts anywhere and at any time without spending a lot with the best flowchart makers? Flowcharts are handy as they streamline your work and life. Even though flowcharts makers are available on Windows and other platforms, one can create a flowchart on Excel or even make it … More Technology – 5 Best Free Online Flowchart Makers

Technology – The Difference Between Float Vs. Double Data Types

It would be incorrect to say that floating-point numbers should never be used as an SQL data type for arithmetic. I will stick to double-precision floating-point data types for SQL Server that are suitable for my requirements. The double-precision floating-point data type is ideal for modeling weather systems or displaying trajectories but not for the … More Technology – The Difference Between Float Vs. Double Data Types

What Is The Data Fabric Approach?

What is The data fabric, and how does it automating discovery, creation, and ingestion help organizations? Data-fabric tools, which can be appliances, devices, or software, allow users to quickly, easily, and securely access and manage large amounts of data. Automating the discovery, creation, and ingestion, big data Fabric accelerates real-time insights from operational data silos, … More What Is The Data Fabric Approach?

Technology – Denodo 8 Java Version Requirements

In a recent customer meeting about the denodo installation requirements, the discussion turned to the supported Java version for denodo 8.   So, we looked it up to confirm, and as it turns out, the supported version of Java for denodo 8 is Oracle 11. Fortunately, it is well documented in the denodo documentation, the links … More Technology – Denodo 8 Java Version Requirements

Denodo – VQL Script To Add A Primary Key to derived Views?

Here is a Denodo Virtual Query Language (VQL) code snippet to add a primary key to multiple derived views in Virtual DataPort (VDP).  This code snippet assumes the primary key is the first field in the table.  Useful when needing to do bulk work on data warehouse-style views where the surrogate key of the view … More Denodo – VQL Script To Add A Primary Key to derived Views?

Technology – How to Install Zip and Unzip in Linux

Zipping and unzipping files make complicated tasks like file transfer easier. Zip is a commonly utilized compression function that is portable and easy to use. One can even unzip files in Windows created in Linux. Compression of files and folders allows faster and more effective transfer, storage, and emailing of files. Unzip is a tool … More Technology – How to Install Zip and Unzip in Linux

Technology – When To Cache A Denodo View

Here’s a quick summary of practices about when to use cache when developing denotative views.  These guidelines come from the usual documentation and practical experience and may help you decide whether to cache a view. These are general guidelines, and they should happen the conflict with any guidance you’ve gotten from the Denodo; Please use … More Technology – When To Cache A Denodo View

Technology – Denodo Supported Business Intelligence (BI) and Reporting Tools

The question of which PI tools to Denodo supports comes up perhaps more often than it should. The question usually comes in the form of a specific intelligence (BI) and reporting tool being asked about. For example, does Denodo support tableau or Cognos, etc. Denodo does provide a list of intelligence (BI) and reporting tools … More Technology – Denodo Supported Business Intelligence (BI) and Reporting Tools

Technology – Denodo VQL To Get A List Of Cached View Names

Hello, this is a quick code snippet of a Denodo VQL (Denodo Virtual Query Language) to pull a list of cached view names which can be useful in pulling list of cached views. It’s not a complicated thing, but now that I’ve bothered to look it up on putting this note here mostly for me … More Technology – Denodo VQL To Get A List Of Cached View Names

Technology – Denodo View Performance Best Practice

Since I have been doing more training of beginning users of the Denodo, there have been a lot of questions around performance best practices and optimization. This article is a quick summary of some of the high points of the Donodo documentation, which are typically useful. However, I would like to point out that the … More Technology – Denodo View Performance Best Practice

Technology – Integration Testing Vs. System Testing

Software applications may contain several different modules, which essentially require a partnership between teams during the development process. The individually developed modules get integrated to form a ready-to-use software application. But before the software gets released to the market, it must be thoroughly tested to ensure it meets user requirement specifications. Integration Testing The integration … More Technology – Integration Testing Vs. System Testing

Technology – Understanding Data Model Entities

Data Modeling is an established technique of comprehensively documenting an application or software system with the aid of symbols and diagrams. It is an abstract methodology of organizing the numerous data elements and thoroughly highlighting how these elements relate to each other. Representing the data requirements and elements of a database gra phically is called … More Technology – Understanding Data Model Entities

Denodo – Script To Alter Association Metadata Description

Here is a Denodo Virtual Query Language (VQL) code snippet, which I use to populate the metadata description of Denodo Associations in Virtual DataPort (VDP).  This snippet identifies Denodo Association without a Metadata Description and fills Metadata Description with a simple explanation of what the Denodo Association’s purpose. VQL To Generate Association Alter Statements Description … More Denodo – Script To Alter Association Metadata Description

Denodo – Find Views With Missing Metadata Description

Here is a Denodo code snippet, which I use to identify views that do not have the metadata description populated.  Granted, this is a simple thing, but I have found it useful when validating that all Denodo views have been described in Virtual DataPort (VDP). SELECT *FROM GET_VIEWS()WHEREinput_database_name = ‘Database_Name‘And len(description) = 0;

Obtaining The Difference Between Timestamps Or Microsecond Fields

The topic of how to obtain the difference or duration from timestamps having milliseconds has come up when working in Denodo a few times. So, after having clarified for different developers I thought I’d create this quick reference to clarify the subject little bit. To get the difference with the duration you must subtract the … More Obtaining The Difference Between Timestamps Or Microsecond Fields