We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

GDB of CS403 will be launched on 15th of July 2013 (15-07-2013) and will last for 48 hours only.

GDB_CS403_1 Dated: Jul 09, 13

Dear Students!

Please Note that GDB of CS403 will be launched on 15th of July 2013 (15-07-2013) and will last for 48 hours only.

The topic will be as follows:



A company is developing a database system containing information about cities, towns, and villages in the country. The number of cities, towns, and villages are in thousands and the database program should allow users to search a particular place by name. Users should also be able to search all places that match a particular value or range of values for attributes such as location or population size. This particular feature is known as a range query.



A reasonable database system must answer queries quickly enough to satisfy a typical user. For an exact-match query, a few seconds is satisfactory. If the database is meant to support range queries that can return many cities that match the query specification, the entire operation may be allowed to take longer. To meet this requirement, it will be necessary to support operations that process range queries efficiently by processing all cities in the range as a batch, rather than as a series of operations on individual cities.



Different indexing methods can be used to perform this operation. What will be your choice if:



a) database is created once and has no change over a period of time

b) database is created once and database is changed over a period of time





Justify your answer with appropriate logic.




Note: Try to provide precise, to the point answer and avoid irrelevant details.


+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)


Views: 6090

Replies to This Discussion

case a) database change ni hogi over a period of time means k we need only search and retrieve the records which filters (suppose in city manner) ab city me bohat se records hoge jo k filter ho ker aayege to time lega cluster indexes do this work easily... ........
case b) Non clustering use because database changes over a period of time and re-indexing happens if we use clustering...

a)database is created once and has no change over a period of time......................(Clustered Indexes)

b)      database is created once and database is changed over a period of time...............................(.Non-clustered Indexes).

 what all of u think about 

Dynamic indexing: the file grows or shrinks to adapt to the volume of data good space utilization and good performance

a Clustered Index only reorganizes the data pages so that the rows are logically sorted in Clustered Index order. The pages are not guaranteed to be ordered physically. SQL Server doesn’t necessarily store the data physically on the disk in clustered-index order, but while creating an index, SQL Server attempts to physically order the data as close to the logical order as possible. Each page in an index’s leaf level has a pointer to the page that logically precedes the current page and to the page that logically follows the current page, thereby creating a doubly linked list. The sysindexes table contains the address of the first leaf-level page. Because the data is guaranteed to be logically in clustered-index order, SQL Server can just start at the first page and follow the index pointers from one page to the next to retrieve the data in order.

So its not guaranteed about the physical ordering of records/rows if a table has Clustered Index on it. It is a common misconsecption among people that Clustered Index sorts data physically & Non Clustered Index sorts data logically.

plz chk this

Please select one option and give justification logically.

I suspect the reasoning behind this advice is the idea that the clustered index stores the data in order of the clustering key (ack) and hence it’s ‘logical’ that such a structure would be best for range scans as SQL can simply start at the beginning of the range and read sequentially to the end.cluster 4 a 

nd non cluster 4 b option because chnging doesn;t effect this mettr

.

NON-Clustered Is my answer 

which is wrong

teacher have asked a tricky question

choice of different Different indexing methods

if 

a) database is created once and has no change over a period of time

b)  database is created once and database is changed over a period of time

RSS

Latest Activity

+M.Tariq Malik replied to +M.Tariq Malik's discussion FIN623 Taxation Management GDB No 01 Fall 2020 Solution / Discussion Last Date: 27-11-2020 in the group FIN623 Taxation Management
5 minutes ago
+M.Tariq Malik liked +M.Tariq Malik's discussion FIN623 Taxation Management GDB No 01 Fall 2020 Solution / Discussion Last Date: 27-11-2020
5 minutes ago
+M.Tariq Malik added a discussion to the group FIN623 Taxation Management
5 minutes ago
+M.Tariq Malik replied to Imtiaz Waqar's discussion COST AND MANAGEMENT ACCOUNTING (MGT402) ASSIGNMENT NO. 01 in the group MGT402 Cost & Management Accounting
8 minutes ago
Muhammad Munir liked +M.Tariq Malik's discussion FIN625 GDB No 01 Fall 2020 Solution / Discussion Last Date: 27-11-2020
12 minutes ago
Muhammad Munir liked +M.Tariq Malik's discussion FIN624 GDB No 01 Fall 2020 Solution / Discussion
13 minutes ago
Muhammad Munir liked +M.Tariq Malik's discussion FIN624 GDB No 01 Fall 2020 Solution / Discussion
13 minutes ago
Muhammad Munir replied to +M.Tariq Malik's discussion FIN624 GDB No 01 Fall 2020 Solution / Discussion in the group FIN624 Islamic Mode of Financing
14 minutes ago
Muhammad Munir joined +M.Tariq Malik's group
15 minutes ago
Muhammad Munir liked +M.Tariq Malik's discussion FIN624 GDB No 01 Fall 2020 Solution / Discussion
15 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion ISL201 Islamic Studies Assignment 01 Fall 2020 Solution / Discussion in the group ISL201 Islamic Studies
19 minutes ago
Usman Khan posted a discussion
20 minutes ago

Looking For Something? Search Here

© 2020   Created by +M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.