Virtualization Archives

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 be the most accessible reference point when the business glossary is not available. These differences are crucial in determining whether or not a business glossary is appropriate for a specific situation. Alation An Alation Data Catalog is a powerful metadata organization tool that scours the …

Big Data vs. Virtualization

Globally, organizations are facing challenges emanating from data issues, including data consolidation, value, heterogeneity, and quality. At the same time, they have to deal with the aspect of Big Data. In other words, consolidating, organizing, and realizing the value of data in an organization has been a challenge over the years. To overcome these challenges, a series of strategies have been devised. For instance, organizations are actively leveraging on methods such as Data Warehouses, Data Marts, and Data Stores to meet their data assets requirements. Unfortunately, the time and resources required to deliver value using these legacy methods is a …

What is Information Management?

A broad overview of information management includes its identification, custodianship, and connection. The goal is to create business value by connecting and optimizing information. In this sense, information is the core business asset. This economic good can help organizations solve a variety of problems. To understand its scope, consider its purpose: to improve the efficiency of a company. For example, the management of information about a customer is concerned with how the customer identifies and uses that data. The DAMA Guide defines information management in detail. It also outlines the roles of different types of managers and organizations. A general …

Denodo Model Best Practices For Creation of Associations

Denodo Model Best Practices For Creation of Associations What Are Denodo Associations? In denodo, associations follow the same concept as modeling tools, which can be described as an ‘on-demand join.’ Where Should Associations Be Created In the Denodo Model? You don’t necessarily need to define an Association at every level; usually, the best practice is to apply associations at the following points: On final views published for data consumers, indicating relationships between related views; Especially, on published web services. On the component views below, any derived view brings together disparate (dissimilar) data sources. The associations should be defined as Referential …

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 testing phase involves assembling and combining the modules tested separately. It helps detect defects in the interfaces during the early stages and ensure the software components work as one unit. Integration testing has two puposes: component and system integration testing. System Testing System testing is …

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 sure that you highlight your most recent employment. Treat LinkedIn like a resume, which means that you should provide the past 10 to 15 years with the most recent five to 10 years being the most important. Generally, the experience section on your LinkedIn profile should …

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 type of calculations the average organization may use in the database. The biggest difference is in the accuracy when creating the database. You need to analyze the data types and fields to ensure no errors and insert the data values for maximum accuracy. If there …

Useful Tools for Technical Consultants and Developers

Here is a quick list of technical consultant and developer tools (free or open-source), which have proven useful over the years to me. Hopefully, this information will be of use to you as well. Text and Code Editors Notepad++ Notepad++, which I have been using for years now, is a free source code editor which supports several programming languages running under the MS Windows environment (governed by GPL License). I have repeatedly found Notepad++ extraordinarily useful. Especially, the language features (e.g. Shell, XML, SQL) or needing to work with files and data without the worry of hidden characters. Image and …

Denodo Virtualization – Useful Links

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 but you may find useful. I have found this useful for several reasons not the least of which is for creating jobs to do maintenance of cached view statistics. Example VQL List Of Cached View Names select name view_name from get_views() where cache_status <> …

Virtualization

Data Catalog Vs. Data Dictionary Vs. Business Glossary

Like this:

Denodo Virtualization – Useful Links

Like this:

Denodo VQL To Get A List Of Cached View Names

Like this:

Virtualization

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this: