What is Data Optimization
Data Optimization is a process that prepares the logical schema from the data view schema. It is the counterpart of data de-optimization. Data optimization is an important aspect in database managem...
Author Archives: Editorial Team
What is Data Naming Convention
Data Naming Convention refers to a convention established to resolve problems with Traditional data names. Many of these conventions are in use today, such as the Of Language
What is Data Generalization
Data Generalization is the process of creating successive layers of summary data in an evaluational database. It is a process of zooming out to get a broader view of a problem, trend or situation. It...
What is Data Entity
Data Entity represents a data subject from the common data model that is used in the logical data model. A Data Model has three theoretical components. The first is the structural component which is...
What is Data Derivation
Data Derivation refers to the process of creating a data value from one or more contributing data values through a data derivation algorithm. Almost all business organizations in today's environment...
SQL Perl/PL Overview
Procedural languages provide the fundamental method for programming within an SQL database. In other articles in this series, we have covered the SQL-based procedural languages, but those are general...
What is Consistent Data Quality
Consistent Data Quality refers to the state of a data resource where the quality of existing data is thoroughly understood and the desired quality of the data resource is known. It is a state where d...
What is Connectivity
Computer networks are the main connectivity mechanism for passing data in an electronic environment. A network is composed of several computers connected by a wired or wireless medium so data and oth...
What is Conceptual Schema
Conceptual Schema In any data warehouse implementation there are many different considerations which should in place before the final physical setting up. This is to avoid in problems related to qual...
SQL Functions
SQL Programming Overview In the article SQL Programming, we discussed creating the “Hello, World!” function in PostgreSQL, MySQL, and Oracle. In this article, we take “Hello, World!...