Query Classification
Ten useful queries have been identified in the case study. All queries have been implemented successfully and are listed in Appendix 4.The queries asked for an LRS will be subset of queries possible in nationwide LRS. The queries required for nationwide information system will further enlarge the list of queries. The possible classification of queries for nationwide system will be as under:
- plot specific queries
- owner specific queries
- tenant specific queries
- basic amenities related queries
- division specific queries
- district specific queries
- queries useful for state govt.
- queries useful for central govt.
- queries form planning and development
point of view One interesting and most important query may be
“Find all plots owned by a particular person in the whole
country”. The answer of this query will expose the people having
disproportionate land in favour of their names. To implement the
query the owner should be identifiable at national level just like
a vehicle or voter card number. Few queries for nationwide system
are listed in Appendix 5.

Fig. 4 Proposed ER diagram for nationwide LRS
Implementation
The case study made of LRS for district Hamirpur (HP) is implemented using Access 2000 RDBMS [24]. There are seven entity tables, three relationship tables (for many-to-many relationships) and ten queries in the implementation. One –to-one and one-to-many relationships are implemented using the concept of foreign key. OLE data type is used to represent map of a plot as an image. Forms are used for displaying results. Queries implemented are listed in Appendix 4. Welcome screen and results of few queries are shown in Appendix 6. Detail steps of implementation of database using Access are discussed in [20].
Conclusions and Future Work
Case study of LRS for district Hamirpur (HP) is implemented successfully. All queries implemented are working properly. Map of a plot is represented as an image using OLE data type. In order to make uniformity in management of land records throughout the country, the proposed nationwide LRS is very useful. The system is suggested for further extension to include information like population, literacy, soil type, crop, sex ratio, rain fall, school, hospital, bank, post office etc. This extended system can be termed as Nationwide Information System to satisfy the needs of district administration, state and central govts. The consistent structure of information can be made with the consultation of district, state and central govt. concerned officials. The system will help to the district administration to have a close watch on balance development of the district. The nationwide latest data will help the governments to make macro level planning for balance development of the country. The accessibility of the system through Internet will solve a number of land disputes generally take place in rural areas of Bihar and Uttar Pradesh. It will also provide transparency in government functioning. The system can also be converted for on line sale and purchase of land through internet. There is need to have cooperation among various departments of government at different levels to take initiatives for developing Nationwide LRS / Information System.
In context of future work the present case study may be converted into applications as discussed in [21, 22], in context of Indian environment. At present case study implemented does not have internet accessibility. The accessibility of database through internet can be provided by generating web pages dynamically as given in [9]. Instead of writing CGI program to generate HTML code, various forms of annotated HTML embed scripting commands included within an HTML document can be used. The popular approaches PHP, Active Server Pages, JavaServer Pages and Java Servlets are discussed in [15, 16, 17, 18]. In [6] a survey of tools required for data intensive web applications development is given. In [8] study is made showing that mod_perl, an Apache Server module can improve performance of CGI script at least 10 times by making persistent database connection. FastCGI [19] is also a solution to improve the performance of CGI.
Acknowledgements
The authors would like to thank Vikas, Aditya and Mahindra for collecting data and concerned district officials for cooperating them.