Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2013
    Posts
    3

    Unanswered: Developing a database system

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    a)
    1) Create database, tables, and indexes.
    2) Populate tables
    3) perform RUNSTATS on all tables

    b)
    1) Create database, tables, and indexes.
    2) Populate tables
    3) perform RUNSTATS on all tables
    4) perform RUNSTATS periodically after new data is loaded

    Andy

  3. #3
    Join Date
    Jul 2013
    Posts
    3

    clustered index

    I think for clustered index should be used when the database is created once and not change over time. It is because in clustered index data is sorted physically. When ever you insert or delete data from table, the whole data is sorted physically which provide extra overhead and decrease performance.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    and index is always sorted. with clustered index db2 tries to keep data in same order as clustered index
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •