Accessing Relational and NF2 Databases Through Database Set Predicates

Draxler, Christoph

doi:10.1007/978-1-4471-3546-3_9

Cited by 13 publications

(9 citation statements)

References 2 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Draxler's work offers the most details and is most similar to ours, in describing a translation process from a subset of general-purpose Prolog syntax into SQL [10]. He also offers a survey of other earlier literature describing the translation process.…”

Section: Other Related Workmentioning

confidence: 90%

“…The relationship between the expressive powers of Datalog and relational algebra has long been recognized [1,6,18], although few systems that analyze the practical use of Datalog or Prolog together with database management systems have actually been built [7,10,11,13]. Draxler's work offers the most details and is most similar to ours, in describing a translation process from a subset of general-purpose Prolog syntax into SQL [10].…”

Section: Other Related Workmentioning

confidence: 93%

“…Translating classical Datalog rules into SQL statements has been well-studied in the past [10,11] and we took a similar approach for our prototype, in which we compile a set of TD rules into a set of SQL view definitions. These view definitions can then be added to the database and used normally, with no additional overhead.…”

Section: Strategymentioning

confidence: 99%

See 2 more Smart Citations

Implementing Reflective Access Control in SQL

Olson

Gunter

Cook

et al. 2009

Data and Applications Security XXIII

View full text Add to dashboard Cite

Abstract. Reflective Database Access Control (RDBAC)is a model in which a database privilege is expressed as a database query itself, rather than as a static privilege in an access control matrix. RDBAC aids the management of database access controls by improving the expressiveness of policies. The Transaction Datalog language provides a powerful syntax and semantics for expressing RDBAC policies, however there is no efficient implementation of this language for practical database systems. We demonstrate a strategy for compiling policies in Transaction Datalog into standard SQL views that enforce the policies, including overcoming significant differences in semantics between the languages in handling side-effects and evaluation order. We also report the results of evaluating the performance of these views compared to policies enforced by access control matrices. This implementation demonstrates the practical feasibility of RDBAC, and suggests a rich field of further research.

show abstract

Section: Other Related Workmentioning

confidence: 90%

Section: Other Related Workmentioning

confidence: 93%

See 1 more Smart Citation

Implementing Reflective Access Control in SQL

Olson

Gunter

Cook

et al. 2009

Data and Applications Security XXIII

View full text Add to dashboard Cite

show abstract

“…The SQL code in particular is generated using a Prolog to SQL translator based on the excellent work of Draxler [12]. Modifications were made to the code of [12] so that the compiler can deal with the different idioms used by different databases, the different types supported, etc.…”

Section: External Database Implementationmentioning

confidence: 99%

A Generic Persistence Model for (C)LP Systems (and Two Useful Implementations)

Fernández

Gómez

Carro

et al. 2004

Practical Aspects of Declarative Languages

View full text Add to dashboard Cite

“…This approach does not exploit query optimization and causes many requests involving large amounts of data. Alternatively, one could either write a mixture of Prolog and SQL or automate part of this process, as covered by the Prolog to SQL converter of Draxler [3]. Our own (unpublished) experiences indicate a simple database query is at best 100 and in practice often over 1,000 times slower than using the internal Prolog database.…”

Section: Storage Optionsmentioning

confidence: 99%

Prolog-Based Infrastructure for RDF: Scalability and Performance

Wielemaker

Schreiber

Wielinga

2003

Lecture Notes in Computer Science

View full text Add to dashboard Cite

Abstract:The semantic web is a promising application-area for the Prolog programming language for its non-determinism and pattern-matching. In this paper we outline an infrastructure for loading and saving RDF/XML, storing triples, elementary reasoning with triples and visualization. A predecessor of the infrastructure described here has been used in various applications for ontology-based annotation of multimedia objects using semantic web languages. Our library aims at fast parsing, fast access and scalability for fairly large but not unbounded applications upto 40 million triples.The RDF parser is distributed with SWI-Prolog under the LGPL Free Software licence. The other components will be added to the distribution as they become stable and documented.

show abstract

Accessing Relational and NF2 Databases Through Database Set Predicates

Cited by 13 publications

References 2 publications

Implementing Reflective Access Control in SQL

Implementing Reflective Access Control in SQL

A Generic Persistence Model for (C)LP Systems (and Two Useful Implementations)

Prolog-Based Infrastructure for RDF: Scalability and Performance

Contact Info

Product

Resources

About