A collection of information technology and consulting knowledge
Using Version Control is a denodo Virtual DataPort (VDP) recommended best practice. Version 7.0 of denodo virtualization supports three Version Control Systems (VCS):
Related References:
A Denodo virtualization project typically classifies the project duties of the primary implementation team into four Primary roles.
While the denodo project is grouped into security permissions and a set of duties, it is import to note that the assignment of the roles can be very dynamic as to their assignment among project team members. Which team member who performs a given role can change the lifecycle of a denodo project. One team member may hold more than one role at any given time or acquire or lose roles based on the needs of the project.
The knowledge, responsibilities, and duties of a denodo data virtualization architect, include:
The knowledge, responsibilities, and duties of a Denodo Platform Administrator, Include:
The Data Virtualization Developer role is divided into the following sub-roles:
the knowledge, responsibilities, and duties of a Denodo Data Virtualization Developer, by sub-role, Include:
The denodo data engineer’s duties include:
The denodo business developer’s duties include:
The denodo application developer’s duties include:
The Denodo Platform Java Programmer role is an optional, specialized, role, which:
The denodo data virtualization internal support team’s duties include
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 detail naming guidance recommends.
Different layers are identified when creating logical folders hierarchies within each Data Virtualization project. The recommended high-Level project folders are:
Additional more detailed naming convention and Virtual Dataport organization guidance are available in the donodo Community Knowledge Base, under Operations:
Here are some denodo Virtualization references, which may be useful.
| Reference Name | Link |
| denodo Home Page | https://www.denodo.com/en/about-us/our-company |
| denodo Platform 7.0 Documentation | https://community.denodo.com/docs/html/browse/7.0/ |
| denodo Knowledge Base and Best Practices | https://community.denodo.com/kb/ |
| denodo Tutorials | https://community.denodo.com/tutorials/ |
| denodo Express 7.0 Download | https://community.denodo.com/express/download |
| Denodo Virtual Data Port (VDP) | https://community.denodo.com/kb/download/pdf/VDP%20Naming%20Conventions?category=Operation |
| JDBC / ODBC drivers for Denodo | https://community.denodo.com/drivers/ |
| Denodo Governance Bridge – User Manual | https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Governance%20Bridge%20-%20User%20Manual |
PostgreSQL – Useful Links
Here are some PostgreSQL references, which may be useful.
| Reference Type | Link |
| PostgreSQL Home page & Download | https://www.postgresql.org/ |
| PostgreSQL Online Documentation | https://www.postgresql.org/docs/manuals/ |
| Citus – Scalability and Parallelism Extension | https://github.com/citusdata |
| Free PostgreSQL Training | https://www.enterprisedb.com/free-postgres-training |
PostgreSQL is an open-source database, which was released in 1996. So, PostgreSQL has been around a long time. So, among the many companies and industries which know they are using PostgreSQL, many others are using PostgreSQL and don’t know it because it is embedded as the foundation in some other application’s software architecture.
I hadn’t paid much attaint to PostgreSQL even though it as been on the list leading databases used by business for years. Mostly I have been focused on the databases my customer were using (Oracle, DB2, Microsoft SQL Server, and MySQL/MariaDB). However, during a recent meeting I was surprised to learn that io had been using and administering PostrgresSQL embedded as part of another software vendors application, which made me take the time to pay attention to PostgreSQL. Especially, who is using PostgreSQL and what opportunities that may provide for evolving my career?
According to enlyft, the major using the PostgreSQL are Computer Software and Information Technology And services companies.
Here is the link to enlyft page, which provides additional information companies and industries using PostgreSQL:
If you are looking to learn a Structured Query Language (SQL) skills and have marketable database knowledge, then it is time to talk about which are the most important business databases.
Well, I assume that you are reading this article with an eye toward improving your employment prospects. If improving your employment prospects is what you are after, then why waste time learning databases skills, learning advanced SQL language chrematistics of a database, or get after a certification, which will have a small market? The most important or most used databases, if you like, to business will likely be where the most work opportunities will be no matter whether you plan to be a company employee, independent contractor, consultant or like me have moved through all of these at one time or another.
The top five databases have a solid 85% of the market, so, this allows a person to build their skill is a database which will have employment opportunities. While there are non-business users of databases of other databases not discussed here, most of us will, thorough out our careers, be working in work for or with business to earn our living.
Now to the heart of this article, in 2019 the top five databases used in a business are listed in order of most popular to least popular are:
| Database Name | Percent of market |
| Oracle | 25.31% |
| MySQL | 24.04% |
| Microsoft SQL Server | 20.39% |
| PostgreSQL | 9.06% |
| MongoDB | 7.71% |
