• DocumentCode
    1400681
  • Title

    Selection of indexes to memory-resident entities for semantic data models

  • Author

    Weddell, Grant E.

  • Author_Institution
    Dept. of Comput. Sci., Waterloo Univ., Ont., Canada
  • Volume
    1
  • Issue
    2
  • fYear
    1989
  • fDate
    6/1/1989 12:00:00 AM
  • Firstpage
    274
  • Lastpage
    284
  • Abstract
    A variation of the index selection problem for an extended relational model when all encoding of information is memory resident is discussed. The data model is the relational model extended in two ways that are common with semantic data models. One consequence of memory residence is that the search space of possible indexes is enlarged to the extent that previous methods requiring some consideration of each possibility are no longer possible. An instance of the index selection problem that includes a set of partial match queries in addition to the input schema is given. It is assumed that the set is determined by an initial phase of query optimization when applied to a fixed set of more general forms of queries that characterize the way in which information is accessed for an application. An initial choice of indexes is made, only considering their suitability for answering the partial match queries
  • Keywords
    information retrieval; relational databases; extended relational model; index selection problem; indexes; information encoding; input schema; memory-resident entities; partial match queries; query optimization; search space; semantic data models; Communication switching; Costs; Data models; Encoding; Indexes; Query processing; Relational databases; Software systems; Switches; Telephony;
  • fLanguage
    English
  • Journal_Title
    Knowledge and Data Engineering, IEEE Transactions on
  • Publisher
    ieee
  • ISSN
    1041-4347
  • Type

    jour

  • DOI
    10.1109/69.87966
  • Filename
    87966