Technology Questions

Catalog views return information that is used by the SQL Server Database Engine. Catalog Views are the most general interface to the catalog metadata and provide the most efficient way to obtain, transform, and present customized forms of this information. All user- available catalog metadata is exposed through catalog views.

Cloud data center doesn’t require experts to operate it, but it requires skilled people to see the maintenance, maintain the workloads and to keep the track of the traffic. The labor cost is 6% of the total cost to operate the cloud data center. Power distribution and cooling of the datacenter cost 20% of the total cost. Computing cost is at the end and is the highest as it is where lots of resources and installation has to be done. It costs the maximum left percentage.

There are many algorithms that can be used to analyze the database to check the maintenance of all the data sets that are already present. The different types of cluster models include as follows:

- Connectivity models: these are the models that connect one cluster to another cluster. This includes the example of hierarchical clustering that is based on the distance connectivity of one model to another model. 

- Centroid models: these are the models that are used to find the clusters using the single mean vector. It includes the example of k-means algorithm.

- Distribution models: it includes the specification of the models that are statistically distributed for example multivariate normal distribution model.

- Density models: deals with the clusters that are densely connected with one another in the regions having the data space. 

- Group models: specifies the model that doesn’t provide the refined model for the output and just gives the grouping information

Some of the rules which should be followed while naming a variable in VB are as follows: 

1) Characters should be less than 255.

2) Space between characters should be allowed.

3) A variable should begin with a number.

4) Period may not be permitted.

There are 2 documents: 

FRD (functional requirement document) 

SDD (system design document) which can also be called TRS (Technical requirements specifications) 

One of the main causes of congestion is that traffic is often busy. If hosts could be made to transmit at a uniform rate, congestion would be less common. Another open loop method to help manage congestion is forcing the packet to be transmitted at a more predictable rate. This is called traffic shaping.

<?php
$file = fopen("file.txt","r");
?>

Bitmap indexes make use of bit arrays (bitmaps) to answer queries by performing bitwise logical operations.

Bitmap indexes are useful in the data warehousing applications.

Bitmap indexes have a significant space and performance advantage over other structures for such data.

Tables that have less number of insert or update operations can be good candidates.

The advantages of Bitmap indexes are:

   - They have a highly compressed structure, making them fast to read.

   - Their structure makes it possible for the system to combine multiple indexes together so that they can      access the underlying table faster.

The Disadvantage of Bitmap indexes is:

  - The overhead on maintaining them is enormous.