Relational Database Design: A Tutorial And Case Study For Egyptologists

Author(s):  
Ernest W. Adams ◽  
Nigel Strudwick
SISFORMA ◽  
2019 ◽  
Vol 6 (1) ◽  
pp. 28
Author(s):  
Shinta Estri Wahyuningrum ◽  
Augustina Sulastri ◽  
Ridwan Sanjaya

In the field of psychology, determining the psychological condition of a person’s can be done using various types of tests. Neuropsychology test is a battery test that means every person should be taken 11 test in a moment. Each test has a different objective, as an example, The Boston Naming test is used to measure a person's ability in the language domain. The data stored for each data in the Boston Naming Test (BNT) is around 130 fields. Each test has different specific data. This makes the data grow rapidly and requires a database design that can accommodate this need.There are many approaches can be done to store the database such a relational database and NoSQL database. When the data are stored using relational methods and amount of data are large, there can be a lack of time in both processing and tracking. This article proposes a system to store the result of the neuropsychological test using the NoSQL database approach with sample data in subtest BNT.


Author(s):  
Morad Hajji ◽  
Mohammed Qbadou ◽  
Khalifa Mansouri

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.


Author(s):  
Demian Katz ◽  
Andrew Nagy

Apache Solr, an open source Java-based search engine, forms the core of many Library 2.0 products. The use of an index in place of a relational database allows faster data retrieval along with key features like faceting and similarity analysis that are not practical in the previous generation of library software. The popular VuFind discovery tool was built to provide a library-friendly front-end for Solr’s powerful searching capabilities, and its development provides an informative case study on the use of Solr in a library setting. VuFind is just one of many library packages using Solr, and examples like Blacklight, Summon, and the eXtensible Catalog project show other possible approaches to its use.


Sign in / Sign up

Export Citation Format

Share Document