A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2019; you can also visit the original URL.
The file type is application/pdf
.
Filters
Procedural languages for database queries and updates
1990
Journal of computer and system sciences (Print)
Relational database transformations, encompassing database queries and updates, are studied. ...
A completeness criterion for database languages is introduced, based on their capability to express database transformations. ...
ACKNOWLEDGMENTS The authors thank Ashok Chandra, Erik Simon, and Moshe Vardi for useful discussions on this paper. ...
doi:10.1016/0022-0000(90)90036-k
fatcat:6gzgrvzwhzbsdlenaofqkawru4
Query Optimization through Cached Queries for Object-Oriented Query Language SBQL
[chapter]
2010
Lecture Notes in Computer Science
e.g. update, delete, insert, etc.), procedures. ...
-SBQL In SBQL a query is: Literal, name of variable, function, view e.g. 2, "Smith", a, Dept σ q, where q is a query and σ is an unary operator q 1 θ q 2 where q 1 , q 2 are queries, and θ is ...
Similar subschemas are generated for each database
update operations (create, insert, update, delete). ...
doi:10.1007/978-3-642-11266-9_26
fatcat:lgnzif72crbilgb5hyegek56ku
SBQL Views - Prototype of Updateable Views
2004
Symposium on Advances in Databases and Information Systems
The SBQL Views prototype is implemented on top of the SBQL query language for the XML DOM model. ...
The prototype follows a novel approach to view updates based on the Stack-Based Approach to object-oriented and XMLoriented query languages. ...
No similar solution exists for objectoriented and XML-oriented databases. ...
dblp:conf/adbis/KozankiewiczS04
fatcat:sok55uvt65auhgcyxc7bclrth4
Object-Oriented Wrapper for Relational Databases in the Data Grid Architecture
[chapter]
2005
Lecture Notes in Computer Science
In our solution we use the stack-based approach to query languages, its query language SBQL, updateable object-oriented virtual views and the query modification technique. ...
Then, in the resulting SBQL query the wrapper looks for patterns that correspond to optimizable SQL queries. Such patterns are then substituted by dynamic SQL execute immediately statements. ...
In our opinion, the Stack-Based Approach and its query language SBQL offer the first and universal solution to the problem of updateable object-oriented database views. ...
doi:10.1007/11575863_56
fatcat:dg3b3e6zinc4rgt2jcncvovqjy
Multilingual Data Management In Database Environment
2009
Malaysian Journal of Computer Science
Global E-Commerce and E-Governance programs have brought into sharp focus for the need of database systems to store and manipulate data efficiently in a suite of multiple languages. ...
While existing database systems provide some means of storing and querying multilingual data, they suffer from redundancy proportional to the number of language support. ...
Analysis of Multilingual Update Procedure Multilingual update procedure involves querying the records. After retrieving the records update operation will be performed. ...
doi:10.22452/mjcs.vol22no1.4
fatcat:s2pw7fyijnfs7i5d6xuxjg5qau
Comparison of Stored Procedures on Relational Database Management System
2021
Tech-E
Store procedure is a group of query stored in database catalogue which allows it to be recalled. Insert, update and delete data could performed using store procedure. ...
This research provides an overview implementation of stored procedure insert, update and deleting in two DBMS, MariaDB and PostgreSQL. ...
LITERATURES REVIEW
Structured Query Language (SQL) The main components database are tables, field/columns and data/records. ...
doi:10.31253/te.v4i2.529
fatcat:7b5uvidsu5eo7iabbyo4y6wc2y
Compiling Integrity Checking into Update Procedures
1991
International Joint Conference on Artificial Intelligence
The paper introduces a (procedural) update language, and describes how constraints are compiled into procedures expressed in this language. ...
The compilation yields conditions on the original database state that guarantee safety of the update. ...
My thanks to the above and to 1CL, Bull and Siemens for their funding of ECRC. ...
dblp:conf/ijcai/Wallace91
fatcat:cinnkgrjnbeaflyb5yvzhv7yb4
Updateable Views for an XML Query Language
2003
International Conference on Advanced Information Systems Engineering
We present an approach to updateable XML views, which is based on the Stack-Based Approach to query languages. ...
Due to procedures we support full algorithmic power of view definitions, which is essential for writing sophisticated wrappers and mediators. ...
The information has a form of procedures (written in a query language) which dynamically overload generic view (updating) operations. ...
dblp:conf/caise/KozankiewiczLS03
fatcat:mqsxwpqdyras3phdq2jv3pocay
Security Management Through Overloading Views
[chapter]
2004
Lecture Notes in Computer Science
The model is based on updateable object views built within the stack-based approach to objectoriented query languages. ...
The model of overloading views is a facility allowing the programmer to separate some kinds of crosscutting concerns that occur during design, implementation and maintenance of database applications. ...
For these models we have defined and implemented the query language SBQL (Stack-Based Query Language), which is much more powerful than ODMG OQL [13] and XML-oriented query languages such as XQuery ...
doi:10.1007/978-3-540-30469-2_1
fatcat:5nwlqprmajb2lg4oqh4i4lhuqy
Intelligent Data Integration Middleware Based on Updateable Views
[chapter]
2005
Lecture Notes in Computer Science
The approach is based on a very simple and universal architecture and on the stack-based approach (SBA) to object-oriented query languages. ...
Views are used in two ways: (1) as wrappers of local servers that adopt local schemata to the federated database requirements; (2) as a facility for intelligent data integration and transformation into ...
Views are defined in the query language SBQL that is integrated with imperative constructs (e.g. updating) and abstractions (functions, methods, procedures). ...
doi:10.1007/11558637_4
fatcat:2n4zvz4cljho7axtzbs6pgswfu
Optimization of Distributed Queries in Grid Via Caching
[chapter]
2005
Lecture Notes in Computer Science
Caching can highly improve performance of query processing in distributed databases. ...
Views integrate data from heterogeneous sources and provide users with their integrated form. ...
There have been also proposed algorithms for answering queries using views that were developed for the context of data integration and distributed database systems [5, 15, 20] . ...
doi:10.1007/11575863_58
fatcat:7lrwrstfm5gmlpu4ioktxq72qa
Database Model for Military Operational Information System
1988
Defence Science Journal
This paper proposes a network of field computer systems with hierarchical database which includes organic data of various units as well as battlefield activity data. ...
ACKNOWLEDGEMENTS This project was the combined effort of a team of five officers ffom Defence and one scientist froin DRDO while undergoing a course of real-time design at TIFR, Bombay in August 1981. ...
To meet this requirement a suitable choice of a query language should be made from a wide variety of database query languages available. ...
doi:10.14429/dsj.38.4832
fatcat:ojqnqmlq6nac5dm5o3323vqcia
Using UML to model relational database operations
2007
Computer Standards & Interfaces
Many existing software applications involve complex application layer implemented in object-oriented programming languages and at the same time use relational database systems as the back-end data store ...
Atomic database operations are modeled based on our framework and are used as building blocks to model more complex database operations. ...
The Structured Query Language (SQL) is the most widely used language for relational databases. SQL is broadly categorized into Data Definition Language (DDL) and Data Manipulation Language (DML). ...
doi:10.1016/j.csi.2006.05.006
fatcat:zu6x2atwjfekvd3jgzoqndryji
RBE: A Rule-by-example Active Database System
1997
Software, Practice & Experience
In other words, the system applies a production system and a special production system program to the task of query rewrite trigger processing. ...
In an active database system, rules are used to monitor and respond to events that happen inside the database. This paper presents the implementation of an active database system called RBE. ...
TRIGGER trig2 UPDATE OF order num, stock num ON items FOR EACH ROW(EXECUTE PROCEDURE proc2) ...
doi:10.1002/(sici)1097-024x(199704)27:4<365::aid-spe81>3.0.co;2-w
fatcat:44l34a5t3reg5d6bcfksnxr7c4
Page 2051 of Mathematical Reviews Vol. , Issue 2003C
[page]
2003
Mathematical Reviews
complete query languages; real polynomial constraint databases; and geometrical query languages.” ...
Milan) ;
Tanca, Letizia (I-MILANP-EI; Milan)
Operational and abstract semantics of the query language G-Log. ...
« Previous
Showing results 1 — 15 out of 66,399 results