Severs
Central computer used to facilitate communication and resource sharing between other computers or the network. To function as a server a ...
Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts
May 15, 2020
System analysis
System analysis is used when design a new computer system to replace manual system or an alter computer system. In order to design it is...
Tuesday, May 12, 2020May 12, 2020
What is Database INDEX?
Indexes are special lookup tables that the database search engine can use to speed up data retrieval. simply put, an index is a pointer to d...
May 12, 2020
What is view?
It is a virtual table.. A view in SQL terminology is a single table that is derived from other tables. These other tables can be base t...
Tuesday, May 5, 2020May 05, 2020
DBMS Locking
Locking - A process in which any data that retrieved by a user for updating must be locked (or denied to other user) until the update is co...
May 05, 2020
Backup Recovery facilities
Backup facilities - which provide periodic backup(some time called fallback) copies of portion of entire database. Journalizing facilities...
May 05, 2020
DBMS Concurrency Control
The process of managing simultaneous operation against a database so that data integrity is maintained and operation do not interfere with ...
Monday, May 4, 2020May 04, 2020
Data Models
Data Models There are different types of the data models and now let see each of them in detail... file based model Hierarchical mode...
Tuesday, April 28, 2020April 28, 2020
Advantages of DBMS
Advantages of DBMS Controlling data redundancy Data consistency Integration of data Data security Report writers Backup recovery pr...
April 28, 2020
Type of SQL commands
Type of SQL commands SQL languages its commands on the basis of functionalities performed by them. there are five types of SQL language w...
Subscribe to:
Posts (Atom)
