Schema architecture and their relationships to transaction processing in distributed database systems [PDF]
, 1991 We discuss the different types of schema architectures which could be supported by distributed database systems, making a clear distinction between logical, physical, and federated distribution. We elaborate on the additional mapping information required
Apers, P.M.G., Scheuermann, P.
core +2 more sources
Schema Versioning in Databases: A Literature Review
Computing OpenChanges involving the database schema are unavoidable events that sometimes occur in data-centric systems, due to many reasons like evolution of user requirements, corrective maintenance, improvement of the current schema with the addition of new ...
Zouhaier Brahmia +2 more
doaj +1 more source
Hierarchical Schema Representation for Text-to-SQL Parsing With Decomposing Decoding
IEEE Access, 2019 Most of existing studies on parsing natural language (NL) for constructing structured query language (SQL) do not consider the complex structure of database schema and the gap between NL and SQL query.
Meina Song, Zecheng Zhan, Haihong E.
doaj +1 more source
Applying TSSL in database schema modeling: Visualizing the syntax of gradual transitions
Journal of Technology and Science Education, 2018 Since database conceptual modeling is a complex cognitive activity, finding an appropriate pedagogy to deliver the topic to novice database designers is a challenge for Information Systems (IS) educators.
Adi Katz
doaj +1 more source
A formal definition of the Users View (UV) of the Graphical Object Query Language (GOQL) [PDF]
, 2002 In this paper we provide a brief formal definition of the Users View (UV) of the Graphical Object Query Language(GOQL). The UV provides a graphical representation for object-oriented database schemas and hides from end-users most of the perplexing ...
Keramopoulos, E. +5 more
core +1 more source
Methodology for modeling a column-oriented database with Cassandra
International Journal of Computer Engineering and Data Science, 2021 Cassandra data model is based on a dynamic schema, with a column-oriented data model. This means that, unlike a relational database, it is not necessary to model all the columns since a row potentially does not have the same set of columns.
Ahmed DOURHRI +2 more
doaj +4 more sources
Structured Query Translation in Peer to Peer Database Sharing Systems
Data Science Journal, 2009 This paper presents a query translation mechanism between heterogeneous peers in Peer to Peer Database Sharing Systems (PDSSs). A PDSS combines a database management system with P2P functionalities. The local databases on peers are called peer databases.
Mehedi Masud, Fazel Keshtkar
doaj +1 more source
An Investigation of Alternatives to Transform Protein Sequence Databases to a Columnar Index Schema
Algorithms, 2021 Mass spectrometers enable identifying proteins in biological samples leading to biomarkers for biological process parameters and diseases. However, bioinformatic evaluation of the mass spectrometer data needs a standardized workflow and system that ...
Roman Zoun +7 more
doaj +1 more source
RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parsers [PDF]
Annual Meeting of the Association for Computational Linguistics, 2019 When translating natural language questions into SQL queries to answer questions from a database, contemporary semantic parsing models struggle to generalize to unseen database schemas.
Bailin Wang +4 more
semanticscholar +1 more source
A Rule-Based Approach to Analyzing Database Schema Objects with Datalog
, 2017 Database schema elements such as tables, views, triggers and functions are typically defined with many interrelationships. In order to support database users in understanding a given schema, a rule-based approach for analyzing the respective dependencies
A Behrend +13 more
core +1 more source