Filters








66,399 Hits in 2.4 sec

Procedural languages for database queries and updates

Serge Abiteboul, Victor Vianu
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]

Piotr Cybula, Kazimierz Subieta
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

Hanna Kozankiewicz, Kazimierz Subieta
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]

Kamil Kuliberda, Jacek Wislicki, Radoslaw Adamus, Kazimierz Subieta
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

Abu Sayed Md. Latiful Hoque, Mohammad Shamsul Arefin
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

Nahrun Hartono, Erfina Erfina
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

Mark Wallace
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

Hanna Kozankiewicz, Jacek Leszczylowski, Kazimierz Subieta
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]

Radosław Adamus, Kazimierz Subieta
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]

Hanna Kozankiewicz, Krzysztof Stencel, Kazimierz Subieta
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]

Piotr Cybula, Hanna Kozankiewicz, Krzysztof Stencel, Kazimierz Subieta
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

Sarbjit Singh
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

Eunjee Song, Shuxin Yin, Indrakshi Ray
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

YE-IN CHANG, FWO-LONG CHEN
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