Author: Sunny Singh

Pro Members SQL Server Standard Members

Database and Hashing Technique – Part 4

Advantages of Database Management System (DBMS) Utilizing a Database Management System (DBMS) to manage data has numerous points of interest: Decrease of Redundancy: This is maybe the hugest favorable advantage of utilizing Database Management System (DBMS). Repetition is the issue of storing similar data in more than one place. Redundancy makes a few issues like requiring additional storage space, entering...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

Database and Hashing Technique – Part 3

CHARACTERISTICS OF DATABASE Simultaneous Use – A database system enables multiple clients to get access to the database simultaneously. Answering various questions from various clients with the similar (base) data is a focal part of an information system. Such simultaneous utilization of data expands the economy of a system. A case of simultaneous utilization is the tour and travel database...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

Database and Hashing Technique – Part 2

Database: It is a collection of related tables or relations. Consider the subsequent collection of tables or relations: Table – 1 Customer_ID Name Age 001 X 12 009 B 13 100 A 14 Table – 2 Customer_ID Account_No 001 S100 009 S200 100 CA200 Table – 3 Account_No Type S100 Savings S200 Savings CA200 Current Account Table – 4 Type...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

Database and Hashing Technique – Part 1

HASH FILES ORGANIZATION Hashing (hash addressing) is a procedure for giving quick direct access to a particular record based on a given estimation of some field. When two (2) or more (n) key values hash to a similar disk address, at that time it cause an impact. The hash function ought to convey the area of the key conceivably equitably...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

File Organization & Indexing – Part 5

DIRECT FILE ORGANIZATION In the index – sequential file organization as it can be considered with the earlier sections, the mapping from the search – key value to the storage location is by means of index entries. In direct file organization, the key value is mapped with the storage location. The same old technique of direct mapping is by performing...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

File Organization & Indexing – Part 4

SECONDARY INDEXES A secondary index is also an ordered file with two (2) fields, and, as within the alternative indexes, the second field may be a pointer to a disk block. The first field is of identical data type as some non – ordering field of the information file. The field on that the secondary index is built is named...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

File Organization & Indexing – Part 3

PRIMARY INDEXES A primary index is an ordered file whose records are of fixed length with two (2) fields. The very first field is of identical data types because the ordering key field of the information file, and also the second field may be a pointer to a disk block – a block address. The ordering key field is termed...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

File Organization & Indexing – Part 2

INDEXED – SEQUENTIAL ORGANIZATION In the indexed-sequential files technique, records are physically hold on in sequential order on a magnetic disc or alternative direct access memory device based on the key field of each and every record. Every file contains an index that references one or additional key fields of each and every information record to its storage location address....

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

File Organization & Indexing – Part 1

Sequential Organization In the sequential organization, records are physically put away in a predefined order as indicated by a key field in each and every record. The most general method for organizing the collection of records that from a file is to make use of sequential organization. In a sequentially organized file records are composed consecutively when the file is...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

Database and File System Organization – Part 5

REDUNDANT ARRAY of INDEPENDENT DISKS (RAID) RAID is short for Redundant Array of Independent (or Inexpensive) Disks. It is a classification of disk drives that utilize at least two (2) drives in blend for adaptation to non-critical failure and execution. Redundant Array of Independent (or Inexpensive) Disks (RAID) disk circle drives are utilized habitually on servers yet aren’t for the...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register