• DocumentCode
    3307209
  • Title

    How the database update must affect the responses being produced by the active continuous queries

  • Author

    Buza, A.

  • Author_Institution
    Inst. of Informatics, Coll. of Dunaujvaros
  • fYear
    2004
  • fDate
    Aug. 30 2004-Sept. 1 2004
  • Firstpage
    401
  • Lastpage
    404
  • Abstract
    The CQL, Continuous Query Language is an expressive SQL-based declarative language for registering continuous queries against streams and updatable relations. CQL is suitable for data stream queries. There are situations when the queries operate on relational databases and on the data streams simultaneously. The execution of CQL suitable for the user when the database is updated during the execution of CQL query. For example, when we wish to keep an eye on changing the value of an account while the official rates are updated, then CQL system must calculate with the retroactive effect of this update. Another semantic is reasoned when the prices are changed while we using CQL query for observing the trade of a supermarket. In this case the effect of the update is valid from the moment of update. In this paper we give a short description of CQL, characterization of update-problems, and we give possible suggestions for the semantically extension of CQL. Additional interesting question is the explanation of the consistent state. In classical database theory it is a usually requirement that the "normal" state of a database is the consistent state. The consistency is not a permanent state, during the updates it may be damaged for a short time. Investigations were performed to find out what the effect of the inconsistent state on the currently operating CQL queries is
  • Keywords
    SQL; database theory; query processing; relational databases; CQL query system; Continuous Query Language; Standard Query Language; active continuous query; continuous query registering; data stream query; database theory; database update problem; expressive SQL-based declarative language; relational database; updatable relation; Database languages; Educational institutions; Electronic mail; Feeds; Manufacturing processes; Monitoring; Query processing; Relational databases; Telecommunication traffic;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Computational Cybernetics, 2004. ICCC 2004. Second IEEE International Conference on
  • Conference_Location
    Vienna
  • Print_ISBN
    0-7803-8588-8
  • Type

    conf

  • DOI
    10.1109/ICCCYB.2004.1437761
  • Filename
    1437761