You are Browsing DBMS News

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

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...

by E-Computer Concepts 10 months ago

Database Security Issues

Database introduce a number of unique security requirements for their users and administrators. On one hand, databases are designed to promote open and flexible access to data. On the other hand, it’s this same open access that makes...

by E-Computer Concepts 10 months ago

Functions of DBMS

The function performed by a typical DBMS are the following: Data Definition The DBMS provides functions to define the structure of the data in the application. These include defining and modifying the record structure, the type and...

by E-Computer Concepts 10 months ago

Data Schemes

The schemes (schemas) define categories of data and their properties. The different schemas reflect different views of the database. External Schema Each user of the database is concerned with only a small portion of the database....