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
Link To Document :
بازگشت