Extensional annotations
http://obdasystems.com/books/publisher-{_}
http://obdasystems.com/books/person-{_}
http://obdasystems.com/books/author-{_}
http://obdasystems.com/books/book-{_}
http://obdasystems.com/books/edition-{_}
{_}
http://obdasystems.com/books/book-{_}-revision-{_}
SELECT tb_affiliated_writers.wr_code AS wr_code, tb_affiliated_writers.wr_name AS wr_name
FROM tb_affiliated_writers
select tb_books.bk_code AS bk_code, tb_books.bk_title AS bk_title, tb_books.is_classic AS is_classic
from tb_books
select tb_editor.ed_code AS ed_code, tb_editor.ed_name AS ed_name
from tb_editor
select tb_bk_gen.id_bk AS id_bk, tb_bk_gen.gen_name AS gen_name
from tb_bk_gen
select tb_on_prob_wr.wr_code AS wr_code, tb_on_prob_wr.wr_name AS wr_name
from tb_on_prob_wr
SELECT
bk_code as code
FROM
tb_books
WHERE
not exists (
SELECT
1
FROM
tb_edition
WHERE
bk_id = bk_code
)
select tb_authors.bk_code AS bk_code, tb_authors.wr_id AS wr_id
from tb_authors
http://obdasystems.com/books/book-{bk_code}
books(bk_code, bk_title, is_classic)
EQUALS(is_classic, '1'^^xsd:decimal)
select books.bk_code AS bk_code, books.bk_title AS bk_title, books.is_classic AS is_classic
from books
where books.is_classic = 1
select tb_edition_audio.ed_code AS ed_code, tb_edition_audio.duration AS duration
from tb_edition_audio
select tb_edition.ed_code AS ed_code, tb_edition.ed_type AS ed_type, tb_edition.pub_date AS pub_date, tb_edition.n_edt AS n_edt, tb_edition.editor AS editor, tb_edition.bk_id AS bk_id, tb_edition.e_book AS e_book, tb_edition.price AS price
from tb_edition
http://obdasystems.com/books/edition-{ed_code}
editions(ed_code, ed_type, pub_date, n_edt, editor, bk_id, e_book, price)
audio_book_editions(ed_code, __x9)
SELECT editions.ed_code AS ed_code, editions.ed_type AS ed_type, editions.pub_date AS pub_date, editions.n_edt AS n_edt, editions.editor AS editor, editions.bk_id AS bk_id, editions.e_book AS e_book, editions.price AS price
FROM editions JOIN audio_book_editions on editions.ed_code = audio_book_editions.ed_code
http://obdasystems.com/books/edition-{ed_code}
editions(ed_code, __x1, __x2, __x3, __x4, __x5, '1'^^xsd:decimal, __x7)
SELECT editions.ed_code AS ed_code
FROM editions
WHERE editions.e_book = 1
http://obdasystems.com/books/edition-{ed_code}
editions(ed_code, 'E'^^xsd:string, __x2, __x3, __x4, __x5, __x6, __x7)
SELECT editions.ed_code AS ed_code
FROM editions
WHERE editions.ed_type = 'E'
select tb_edition_printed.ed_code AS ed_code, tb_edition_printed.pages AS pages
from tb_edition_printed
http://obdasystems.com/books/edition-{ed_code}
editions(ed_code, ed_type, pub_date, n_edt, editor, bk_id, e_book, price)
printed_book_editions(ed_code, __x9)
SELECT editions.ed_code AS ed_code, editions.ed_type AS ed_type, editions.pub_date AS pub_date, editions.n_edt AS n_edt, editions.editor AS editor, editions.bk_id AS bk_id, editions.e_book AS e_book, editions.price AS price
FROM editions JOIN printed_book_editions on editions.ed_code = printed_book_editions.ed_code
http://obdasystems.com/books/edition-{ed_code}
editions(ed_code, 'S'^^xsd:string, __x2, __x3, __x4, __x5, __x6, __x7)
SELECT editions.ed_code AS ed_code
FROM editions
WHERE editions.ed_type = 'S'
http://obdasystems.com/books/book-{bk_id}
http://obdasystems.com/books/edition-{ed_code}
editions(ed_code, ed_type, pub_date, n_edt, editor, bk_id, e_book, price)
select editions.ed_code AS ed_code, editions.ed_type AS ed_type, editions.pub_date AS pub_date, editions.n_edt AS n_edt, editions.editor AS editor, editions.bk_id AS bk_id, editions.e_book AS e_book, editions.price AS price
from editions
http://obdasystems.com/books/edition-{ed_code}
http://obdasystems.com/books/publisher-{editor}
editions(ed_code, ed_type, pub_date, n_edt, editor, bk_id, e_book, price)
IS_NOT_NULL(n_edt)
select editions.ed_code AS ed_code, editions.ed_type AS ed_type, editions.pub_date AS pub_date, editions.n_edt AS n_edt, editions.editor AS editor, editions.bk_id AS bk_id, editions.e_book AS e_book, editions.price AS price
from editions
where editions.n_edt is not null
http://obdasystems.com/books/book-{bk_code}
http://obdasystems.com/books/author-{wr_id}
written_by(bk_code, wr_id)
select written_by.bk_code AS bk_code, written_by.wr_id AS wr_id
from written_by
http://obdasystems.com/books/edition-{ed_code}
pub_date
editions(ed_code, ed_type, pub_date, n_edt, editor, bk_id, e_book, price)
select editions.ed_code AS ed_code, editions.ed_type AS ed_type, editions.pub_date AS pub_date, editions.n_edt AS n_edt, editions.editor AS editor, editions.bk_id AS bk_id, editions.e_book AS e_book, editions.price AS price
from editions
http://obdasystems.com/books/edition-{ed_code}
n_edt
editions(ed_code, ed_type, pub_date, n_edt, editor, bk_id, e_book, price)
select editions.ed_code AS ed_code, editions.ed_type AS ed_type, editions.pub_date AS pub_date, editions.n_edt AS n_edt, editions.editor AS editor, editions.bk_id AS bk_id, editions.e_book AS e_book, editions.price AS price
from editions
http://obdasystems.com/books/edition-{ed_code}
pages
printed_book_editions(ed_code, pages)
select printed_book_editions.ed_code AS ed_code, printed_book_editions.pages AS pages
from printed_book_editions
http://obdasystems.com/books/edition-{ed_code}
price
editions(ed_code, ed_type, pub_date, n_edt, editor, bk_id, e_book, price)
select editions.ed_code AS ed_code, editions.ed_type AS ed_type, editions.pub_date AS pub_date, editions.n_edt AS n_edt, editions.editor AS editor, editions.bk_id AS bk_id, editions.e_book AS e_book, editions.price AS price
from editions
http://obdasystems.com/books/book-{bk_code}
bk_title
books(bk_code, bk_title, is_classic)
select books.bk_code AS bk_code, books.bk_title AS bk_title, books.is_classic AS is_classic
from books
select tb_employees.employee_id AS employee_id, coalesce(tb_employees.vat, tb_employees.employee_id, tb_employees.employee_name) AS vat, tb_employees.profession AS profession, tb_employees.employee_name AS employee_name, tb_employees.retired AS retired, tb_employees.date_birth AS date_birth
from tb_employees
http://obdasystems.com/books/edition-{ed_code}
duration
audio_book_editions(ed_code, duration)
select audio_book_editions.ed_code AS ed_code, audio_book_editions.duration AS duration
from audio_book_editions
http://obdasystems.com/books/book-{id_bk}
gen_name
genres(id_bk, gen_name)
IS_NOT_NULL(gen_name)
select genres.id_bk AS id_bk, genres.gen_name AS gen_name
from genres
where genres.gen_name is not null
http://obdasystems.com/books/person-{vat}
employee_name
employees(__x0, vat, __x2, employee_name, __x4, __x5)
IS_NOT_NULL(vat)
IS_NOT_NULL(employee_name)
SELECT employees.vat AS vat,
employees.employee_name AS employee_name
FROM employees
WHERE employees.vat IS NOT NULL AND employees.employee_name IS NOT NULL
http://obdasystems.com/books/person-{vat}
http://obdasystems.com/books/author-{employee_id}
employees(employee_id, vat, 'AUTHOR'^^xsd:string, __x3, __x4, __x5)
writers(employee_id, __x7)
SELECT employees.vat AS vat,
employees.employee_id AS employee_id
FROM employees
JOIN writers
ON writers.wr_code = employees.employee_id
WHERE employees.profession = 'AUTHOR'
http://obdasystems.com/books/person-{vat}
http://obdasystems.com/books/publisher-{employee_id}
employees(employee_id, vat, 'EDITOR'^^xsd:string, __x3, __x4, __x5)
publisher(employee_id, __x7)
SELECT employees.vat AS vat,
employees.employee_id AS employee_id
FROM employees
JOIN publisher
ON publisher.ed_code = employees.employee_id
WHERE employees.profession = 'EDITOR'
http://obdasystems.com/books/person-{vat}
date_birth
employees(__x0, vat, __x2, __x3, __x4, date_birth)
IS_NOT_NULL(vat)
SELECT employees.vat AS vat,
employees.date_birth AS date_birth
FROM employees
WHERE employees.vat IS NOT NULL
http://obdasystems.com/books/person-{vat}
vat
employees(__x0, vat, __x2, __x3, __x4, __x5)
IS_NOT_NULL(vat)
SELECT employees.vat AS vat
FROM employees
WHERE employees.vat IS NOT NULL
select
employee_id as employee_id,
substring_index(group_concat(vat separator '|'), '|', 1) as vat,
substring_index(
group_concat(employee_name separator '|'),
'|',
1
) as name,
substring_index(group_concat(date_birth separator '|'), '|', 1) as birth_date
from
tb_employees
group by
employee_id
having
employee_id is not null
http://obdasystems.com/books/book-{code}
unedited_book(code)
select unedited_book.code AS code
from unedited_book
select tb_scientific_books.bk_id AS bk_id, tb_scientific_books.revision AS revision, tb_scientific_books.topic AS topic, tb_scientific_books.title AS title
from tb_scientific_books
http://obdasystems.com/books/book-{bk_id}
http://obdasystems.com/books/book-{bk_id}-revision-{revision}
scientific_books(bk_id, revision, topic, title)
select scientific_books.bk_id AS bk_id, scientific_books.revision AS revision, scientific_books.topic AS topic, scientific_books.title AS title
from scientific_books
http://obdasystems.com/books/book-{bk_id}-revision-{revision}
revision
scientific_books(bk_id, revision, topic, title)
select scientific_books.bk_id AS bk_id, scientific_books.revision AS revision, scientific_books.topic AS topic, scientific_books.title AS title
from scientific_books
http://obdasystems.com/books/book-{bk_id}
topic
scientific_books(bk_id, revision, topic, title)
select scientific_books.bk_id AS bk_id, scientific_books.revision AS revision, scientific_books.topic AS topic, scientific_books.title AS title
from scientific_books
http://obdasystems.com/books/book-{bk_id}
title
scientific_books(bk_id, revision, topic, title)
select scientific_books.bk_id AS bk_id, scientific_books.revision AS revision, scientific_books.topic AS topic, scientific_books.title AS title
from scientific_books
http://obdasystems.com/books/author-{employee_id}
name
employees(employee_id, __x1, __x2, __x3, __x4, __x5)
writers(employee_id, name)
NOT_EQUALS(__x3, name)
SELECT employees.employee_id AS employee_id,
writers.wr_name AS name
FROM employees
JOIN writers
ON writers.wr_code = employees.employee_id
WHERE employees.employee_name <> writers.wr_name
http://obdasystems.com/books/book-{bk_code}Outline of the book with code {bk_code} the book is titled {bk_title}books(bk_code, bk_title, is_classic)select books.bk_code AS bk_code, books.bk_title AS bk_title, books.is_classic AS is_classic
from bookshttp://obdasystems.com/books/edition-{ed_code}Outline description of the edition with code {ed_code} of book with title {bk_title}: the date is {ed_date} the type is {ed_type}editions(ed_code, ed_type, ed_date, __x3, __x4, __x5, __x6, __x7)books(__x5, bk_title, __x10)SELECT editions.ed_code AS ed_code,
editions.pub_date as ed_date,
editions.ed_type as ed_type,
books.bk_title as bk_title
FROM editions, books
where editions.bk_id=books.bk_codehttp://obdasystems.com/books/author-{wr_code}http://www.w3.org/2000/01/rdf-schema#label{wr_name}writers(wr_code, wr_name)select writers.wr_code AS wr_code, writers.wr_name AS wr_name
from writershttp://obdasystems.com/books/author-{wr_code}http://www.w3.org/2000/01/rdf-schema#label{wr_name}emerging_writers(wr_code, wr_name)select emerging_writers.wr_code AS wr_code, emerging_writers.wr_name AS wr_name
from emerging_writershttp://obdasystems.com/books/book-{bk_code}http://www.w3.org/2000/01/rdf-schema#label{bk_title}books(bk_code, bk_title, is_classic)select books.bk_code AS bk_code, books.bk_title AS bk_title, books.is_classic AS is_classic
from bookshttp://obdasystems.com/books/book-{bk_id}http://www.w3.org/2000/01/rdf-schema#label{title}scientific_books(bk_id, revision, topic, title)select scientific_books.bk_id AS bk_id, scientific_books.revision AS revision, scientific_books.topic AS topic, scientific_books.title AS title
from scientific_bookshttp://obdasystems.com/books/edition-{ed_code}http://www.w3.org/2000/01/rdf-schema#labelEdition-{ed_code}editions(ed_code, __x1, __x2, __x3, __x4, __x5, __x6, __x7)SELECT editions.ed_code AS ed_code
FROM editions
http://obdasystems.com/books/person-{vat}http://www.w3.org/2000/01/rdf-schema#label{vat}employees(__x0, vat, __x2, __x3, __x4, __x5)SELECT employees.vat AS vat
FROM employees
http://obdasystems.com/books/publisher-{ed_code}http://www.w3.org/2000/01/rdf-schema#label{ed_name}publisher(ed_code, ed_name)select publisher.ed_code AS ed_code, publisher.ed_name AS ed_name
from publisherhttp://obdasystems.com/books/book-{bk_id}-revision-{revision}http://www.w3.org/2000/01/rdf-schema#label{title}-revision{revision}scientific_books(bk_id, revision, topic, title)select scientific_books.bk_id AS bk_id, scientific_books.revision AS revision, scientific_books.topic AS topic, scientific_books.title AS title
from scientific_books