scholarly journals Towards a grapho-phonologically parsed corpus of medieval Scots: database design and technical solutions

Corpora ◽  
2018 ◽  
Vol 13 (2) ◽  
pp. 255-269 ◽  
Author(s):  
Joanna Kopaczyk ◽  
Benjamin Molineaux ◽  
Vasilios Karaiskos ◽  
Rhona Alcorn ◽  
Bettelou Los ◽  
...  
Keyword(s):  
Data Collection ◽  
Relational Database ◽  
Systematic Approach ◽  
Analytical Procedure ◽  
Database Design ◽  
Meta Data ◽  
Lexical Information ◽  
Text Type ◽  
Complex Queries ◽  
Technical Solutions

This paper presents a newly constructed corpus of sound-to-spelling mappings in medieval Scots, which stems from the work of the From Inglis to Scots (FITS) project. We have developed a systematic approach to the relationships between individual spellings and proposed sound values, and recorded these mutual links in a relational database. In this paper, we introduce the theoretical underpinnings of sound-to-spelling and spelling-to-sound mappings, and show how a Scots root morpheme undergoes grapho-phonological parsing, the analytical procedure that is employed to break down spelling sequences into sound units. We explain the data collection and annotation for the FITS Corpus (Alcorn et al., forthcoming), drawing attention to the extensive meta-data which accompany each analysed unit of spelling and sound. The database records grammatical and lexical information about the root, the positional arrangement of segments within the root, labels for the nuclei, vowels and consonants, the morphological context, and extra-linguistic detail of the text a given root was taken from (date, place and text type). With this wealth of information, the FITS corpus is capable of answering complex queries about the sound and spelling systems of medieval Scots. We also suggest how our methodology can be transferred to other non-standardised spelling systems.

scholarly journals Onto2DB: towards an eclipse plugin for automated database design from an ontology

2019 ◽  
Vol 9 (4) ◽  
pp. 3298 ◽  
Author(s):  
Morad Hajji ◽  
Mohammed Qbadou ◽  
Khalifa Mansouri
Keyword(s):  
Theoretical Model ◽  
Conceptual Model ◽  
Relational Database ◽  
Information Technologies ◽  
Database Design ◽  
Relational Model ◽  
Automatic Translation ◽  
Data Definition ◽  
Ontological Model ◽  
Automated Database

Ontologies are spreading more and more in the field of information technologies as a privileged solution allowing the formalization of knowledge. The theoretical model of ontologies is most promising. They are increasingly ubiquitous given the benefits they present. Despite the proliferation of research proposing approaches dedicated to the design of a database from an ontology, the tools to design a database from an ontology are rare or inaccessible. Thus, in this contribution, we present our approach for the development of an Eclipse Plug-in, in order to automatically generate a conceptual model of a relational database from an ontology. To evaluate the usefulness of our approach, we used our resulting Eclipse Plug-in to automatically generate a conceptual model of a relational database from an ontology, customize it, and automatically generate the corresponding SQL script for Data Definition. The results of this experiment showed that our Plug-in constitutes a concretization of our approach and a means of automatic translation from the ontological model to the relational model.

A Step-By-Step Guide to Tier 2 Behavioral Progress Monitoring

2018 ◽  
Vol 27 (1) ◽  
pp. 15-27 ◽  
Author(s):  
Allison L. Bruhn ◽  
Sara C. McDaniel ◽  
Ashley Rila ◽  
Sara Estrapala
Keyword(s):  
Data Collection ◽  
Behavioral Problems ◽  
Systematic Approach ◽  
Progress Monitoring ◽  
Tier 2 ◽  
Low Intensity ◽  
Tier 2 Interventions ◽  
Data Collection And Analysis ◽  
Method Of Measurement ◽  
Problem Solving Teams

Students who are at risk for or show low-intensity behavioral problems may need targeted, Tier 2 interventions. Often, Tier 2 problem-solving teams are charged with monitoring student responsiveness to intervention. This process may be difficult for those who are not trained in data collection and analysis procedures. To aid practitioners in these worthwhile tasks, we offer a step-by-step guide to collecting and evaluating Tier 2 behavioral progress monitoring data. This systematic approach includes (a) selecting an appropriate method of measurement, (b) planning for data collection and evaluation, (c) collecting and analyzing data, (d) considering treatment fidelity, and (e) adjusting intervention based on student responsiveness. Each step is described in detail with specific examples and additional resources are provided.

From Conceptual Database Schemas to Logical Database Tuning

2011 ◽  
pp. 52-74
Author(s):  
Jean-Marc Petit ◽  
Mohand-Saïd Hacid
Keyword(s):  
Relational Database ◽  
Database Design ◽  
Relational Model ◽  
A Posteriori ◽  
Entity Relationship ◽  
Database Tuning

This chapter revisits conceptual database design and focuses on the so-called “logical database tuning”. We first recall fundamental differences between constructor-oriented models (like extended Entity-Relationship models) and attribute-oriented models (like the relational model). Then, we introduce an integrated algorithm for translating ER-like conceptual database schemas to relational database schemas. To consider the tuning of such logical databases, we highlight two extreme cases: null-free databases and efficient — though non redundant — databases. Finally, we point out how SQL workloads could be used a posteriori as a help for the designers and/or the database administrators to reach a compromise between these extreme cases. While a lot of papers and books have been devoted for many years to database design, we hope that this chapter will clarify the understanding of database designers when implementing their databases and database administrators when maintaining their databases.

Sign in / Sign up

Export Citation Format

Share Document