Write short note on Indexing .

-

 Indexing 

 Indexing is used to optimize the performance of a database by minimizing the number of disk accesses required when a query is processed. The index is a type of structure having only two columns. The first column comprises a copy of the primary or candidate Key of a table. The Second Column contains a set of pointers for holding the address of the disk block where Specific key values are stored.

Advantages of indexing

  •  Better performance of queries.
  • Fast Searching from the database.
  • Fast retrieval of data 
  • Increase performance in SELECT query.

Disadvantages of indexing

  • Indexing takes more space.
  • Decrease performance in INSERT, DELETE, and UPDATE query.
Figure: Structure of index











Comments

Post a Comment

Popular posts from this blog

What is the cloud cube model? Explain in context to the Jericho cloud cube model along with its various dimensions.

-
Image
Cloud Cube model   The Cloud Cube model helps classify a four-dimensional factor cloud network. Its concentration is on protecting and safeguarding the cloud network. This cloud cube model lets you securely pick cloud formation. This model serves to provide a safe and secured Internet network for IT administrators enterprises, and business leaders. Jericho cloud cube model  Jericho Forum is an international independent group of information security leaders & their focus is on how to protect and secure cloud networks. They put forward a model that helps to categorize a cloud network based on four-dimensional factors. The Jericho Cloud Cube Model describes the multidimensional elements of cloud computing, framing not only cloud use cases, but also how they are deployed and used. The Cloud Cube Model, established and developed by the Jericho Forum, assists in categorizing cloud networks based on four dimensions: Internal/External Proprietary/Open Perimeterised/De-perimet...
Read more

Short note on E-Government Architecture

-
Image
1)  Presentation layer The presentation layer identifies and describes the system users, who require access to government information at different capacities, and the channels through which information can be accessed.  During system development, one is required to explicitly identify the government user, the system is intended to serve, and also the means through which this information is to be accessed so that the system can be tailored to meet these requirements. It manages the user’s interface with the system. If a pro- project is to be successful, different stakeholders need to be identified at the beginning, involved in the initial stages and kept involved throughout development and implementation. 2) E-government layer E-government public services utilize very specialized applications that are only available to certain agencies and not all agencies participating in the consortium. The main goal of the e-government layer is to achieve a government that;  does not as...
Read more

Explain cloud computing reference model .

-
Image
 CLOUD COMPUTING REFERENCE MODEL The cloud computing reference model is a general high-level architecture and is meant for a cloud computing reference architecture provided, which outlines the primary performer/actor and the understanding of the cloud computing needs, uses, features, and standards. An overview of the NIST primary players, as indicated in the figure below. Each performer is an entity that might be a person or a cloud computing activity and role. The NIST cloud computing reference architecture identifies five organization that takes part in a transaction or process and complete duties in cloud computing. 1. Cloud consumer:  The cloud consumer is the cloud computing service's most significant stakeholder. A cloud consumer is a person or organization who has a commercial connection with a cloud provider and consumes its services. A cloud consumer browses a cloud provider's service catalog, requests the right service, establishes service contracts with the cloud pr...
Read more