Thursday, 13 June 2013

What are the types of Indexes in dbms

INDEX STRUCTURES FOR FILES :

TYPES OF INDEXES :

Different types of single-level ordered indexes are,
  • Primary index
  • Secondary index
  • Clustering index

Primary Index : 

  • Primary index is an ordered file whose records are of fixed length with two fields.The first field is of the same data type as the ordering key field called as Primary Key of the data file and the second field is a pointer to a disk block.
  • There is one index entry in the index file for eavh block in th data file.Each index entry has the value of the primary key field for the first record in a block and a pointer to that block as its two field values.
  • An index entry i will be referred using two field values (ie)<(K(i).P(i)>.
  • The first record in each block of the data file is called the anchor record of the block.
  • Indexes can also be characterized as
  1. Dense Index
  2. Sparse Index
1. Dense Index : It has an index entry for each search key value in the data file.
2. Sparse Index or Non-dense Index : It has index outries for only some of the search values.A primary index is hence a non-dense index,since it includes an entry for each disk block of the data file rather than for every search value.

Secondary Index :

  • It is also an ordered file with two fields.The first field is of the same type as some non-ordering field of the data file that is an indexing field.The second field is either a block pointer or a record pointer.
  • Secondary index usually needs more storage space and longer search time than does a primary index.This is because of its large number of entries.

Clustering index :

  • It records of a file are physically ordered on a non-key field which does not have a distinct value for each record that field is called clustering field.
  • Clustering index is to speed up retrieval of records that have the same value for the clustering field.
  • This differs from the primary index,which requires that ordering field is of the data file have a distinct value for each record.
  • A clustering index is also an ordered file with two fields;The first field is of the same type as the clustering field of the data file,and the second field is is a block pointer.


What is meant by Query Language | Define Query Language

Query Language Data Base Management System:

A query language is a language in which a user requests a information from the database.

Query language can be divided into two,they are
  • Procedural language
  • Non-Procedural language

Procedural language : 

In this language , the user instructs the system to perform a sequence of operations on the database to compute the desired result.

Non-Procedural language :

In this non-procedural language , the user describes the desired information without giving a specific procedure for obtaining that information.

This is the short description about meaning of query language in the database management systems DBMS.

Tuesday, 11 June 2013

TNEA 2013 - RANK LIST ANNOUNCED FOR ENGINEERING COUNSELLING

TNEA 2013 - Rank List 2013 is to publish on 12-06-2013.Already the TNEA 2013 Random Number was published on 05-06-2013.Before that we have updated the date of TNEA 2013 Issue of Application forms and last date of submitting filled in application form details.You can get all the details about Tamil Nadu Engineering Admission 2013 in our website StudentsBlog100.

TNEA 2013 Full Details --> Click here


TNEA 2013
TNEA 2013 - Rank List
The TNEA Rank List will be published on 12-06-2013.You can get your rank by entering your application number in the textbox that we have provided below.You will be called for the Engineering Counselling fully based on your cut-off marks.But for example many of the students may scored 170.5 cut-off mark in 12th standard.All these students will be called in same date for engineering councelling,but which students to be call first for couselling and which student to call second and so on..will  be based on the TNEA 2013 Rank List.

Tamil Nadu Engineering Counselling Rank List is based on your cut-off mark, if your cut-off mark is same,then your fourth subject marks will be taken.If all these are same then they will publish the Rank List  based on your Date of Birth.

How to see my Rank List which is published on 12-06-2013.

The students who applied for Anna university Engineering counselling can get your Rank which is published on 12-06-2013 in this StudentsBlog100 website.



 TNEA 2013 RANK LIST

Click Here to Check Your Rank List 


TNEA 2013 - FULL DETAILS


TNEA 2013 Full Details --> Click here 

--------------------------------------------------------------------------------------------------------------------
Related Tags:
  • TNEA 2013 - Rank List Check
  • Tnea Rank List 2013
  • TNEA Rank List Checking Website
  • TNEA Rank List Announced
  • How to check TNEA 2013 Rank List
  • Anna University Official Website - TNEA 2013 Rank list
  • Rank List enquiry.
  • Anna university chennai councelling Rank List 2013
  •  Anna university chennai counselling Rank List 2013 
  • Tamil Nadu Engineering Counselling  Rank List 2013

Monday, 10 June 2013

TAMILNADU 12TH STANDARD HIGHER SECONDARY SUPPLEMENTARY EXAMINATION TIMETABLE JUNE/JULY-2013

GOVERNMENT OF TAMILNADU
DEPARTMENT OF GOVERNMENT EXAMINATIONS
HIGHER SECONDARY SPECIAL SUPPLEMENTARY EXAMINATION, JUNE/JULY-2013

The Higher Secondary Special Supplementary Examination of June / July 2013 will be conducted in the order of
date, day, and subject shown in the table mentioned below:-


Note:
(1) In the event of any holiday being declared after the publication of the Time-Table, the Higher Secondary Examination will
be conducted as scheduled unless and otherwise notified and intimated by the Director of Government Examinations,
Chennai.
(2) Question papers will be issued to candidates at 10.00 a.m. Ten minutes is provided for reading the question paper.
Answer sheets will be issued at 10.10 a.m. Five minutes is provided for filling up of the particulars on the answer sheet.
Duration of the examination is three hours i.e., from 10.15 a.m. to 1.15 p.m. except Typewriting for which duration will be
2½ hours from 10.00 a.m. to 12.30 p.m.,
(3) Candidates arriving after the expiration of the first fifteen minutes will not be admitted (Both for Theory and Practical)


TIME TABLE


Click here to download the Time Table

THEORY OF FOLLOWING VOCATIONAL SUBJECTS

AGRICULTURE AREA :

1. Agricultural Practices
HOME SCIENCE AREA:

1.Textiles and Dress Designing 
2. Food Management and Child Care
COMMERCE AND BUSINESS AREA :

1. Office Management 
2. Accountancy & Auditing
ENGINEERING AND TECHNOLOGY AREA :

1. General Machinist 
2. Electrical Machines and Appliances
3. Electronic Equipments
4. Draughtsman Civil
5. Auto Mechanic
6. Textile Technology
HEALTH AREA:

1. Nursing (Vocational)