You are Browsing Database News

by E-Computer Concepts 8 months ago

Normalization

Normalization is a design technique that is widely used as a guide in designing relational databases. Normalization is essentially a two step process that puts data into tabular form by removing repeating groups and then removes duplicated...

by E-Computer Concepts 8 months ago

E-R Modeling

Entity Relationship Modeling (ER Modeling) is by far the most common way to express the analytical result of an early stage in the construction of a new database. E-R Diagram are the way to achieve this. Entity Relationship diagram...

by E-Computer Concepts 8 months ago

What is MySQL ?

MySQL is a cross platform open source database server software. It is used extensively in web development. MySQL is a multithreaded, multi-user, SQL relational database server (RDBMS) with an estimated six Query installations. MySQL AB...

by E-Computer Concepts 9 months ago

Relational Algebra Operators

The Eight Relational Algebra Operators are: 1 Select To retrieve specific tuples/rows from a relation. 2 Project To retrieve specific attributes/columns from a relation. 3 Product To obtain all possible combination...

relational model
by E-Computer Concepts 9 months ago

Relational Model

The Relational Model was a huge step forward, as it allowed files to be related by means of a common field. In order to relate any two files, they simply need to have a common field, which makes the model extremely flexible. Relational...

by E-Computer Concepts 9 months ago

What is Digital Signature?

A digital signature is an example of using encryption techniques to provide authentication services in electronics commerce applications. Like a handwritten signature, a digital signature is a means of associating a mark unique to an individual...

by E-Computer Concepts 9 months ago

What is Encryption?

Encryption is a means of maintaining secure data in an insecure environment. Encryption consists of applying an encryption algorithm to data using some prespecified encryption key. The resulting data has to be decrypted using a decryption...

by E-Computer Concepts 9 months ago

Characteristics of Data Warehouse

Data warehouses have the following distinctive characteristics: Multidimensional Conceptual View Generic Dimensionality Unlimited Dimensions and Aggregation Levels Unrestricted Cross-Dimensional Operations Dynamic Sparse...

by E-Computer Concepts 9 months ago

Data Warehousing

The increasing processing power and sophistication of analytical tools and techniques have resulted in the development of what are known as Data Warehouses. These data warehouses provide storage, functionality, and responsiveness to...

by E-Computer Concepts 9 months ago

Data Constraints

Oracle allows data constraints to be attached to columns with the help of SQL syntax that checks data for integrity prior storage. Once data constraints are part of a table column construct, the oracle database engine checks for the data...