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

    Unanswered: Developing a database system

    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
    Provided Answers: 11
    Is the answer not in the back of the book?

  3. #3
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Check here for more information.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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