Showing posts with the label Database Tips

Database Development Process - Softkhazana

The database is the fundamental component of the information system of an organization. In a computerized environment, the information system includes the resources such as data, DBMS software, compu…

Record Locking and Deadlocking - Softkhazana

Record locking mechanism is the most common method to implement the concurrency control in DBMS. Locking means record must be locked (i.e. access disallowed) for other users, when any user opens it f…

Database Security, Authorization and Encryption rules - Softkhazana

Database security is concerned with authorization rules, user-defined procedures, data encryption and authentication schemes etc. Let's have a detailed overview of these concepts:  Authentication…

Different File Type from Storage point of view - Softkhazana

File organization is a technique for storing and arranging data on secondary storage devices so that it can be retrieved easily when needed. It includes the physical order and layout of records on se…

Phases in Database Development Life Cycle. - Softkhazana

The database development process comprises a series of phases. The major phases in information engineering are: Planning Analysis Design DBMS Selection Implementation Maintenance Database planning Th…

Function of Client and Server environment - Softkhazana

In client and server database systems, the server contains the whole DBMS and controls all of DBMS at a center point, while all the users send and receive all information using database server via th…

Database Backups - Hot Backup vs. Cold Backup - Softkhazana

Data and information are as important for an organization as blood in human body. In case data and information become unavailable due to any reason, all the working of the organization stops and it b…

Rolling Back and Roll forward Database Recovery - Softkhazana

Database can fail due to some reasons like media failure, operating system failure, accidental damage, and intentional damage to the database. When database stops working due to any above reasons, it…

Softkhazana - Database Tips

What is database?  A database is a collection of related data stored in an efficient and compact manner.  The word “efficient” means that stored data can be accessed very easily and quickly. Similarl…
Subscribe Our Newsletter