Database Documentation Research Articles

Transaction processing in consistency-aware user\u2019s applications deployed on NoSQL databases

NoSQL databases are capable of storing and processing big data which is characterized by various properties such as volume, variety and velocity. Such databases are used in a variety of user applications that need large volume of data which is highly available and efficiently accessible. But they do not enforce or require strong data consistency nor do they support transactions. This paper investigates into the transaction processing in consistency-aware applications hosted on MongoDB and Riak which are two representatives of Document and Key-Value NoSQL databases, respectively. It develops new transaction schemes in order to provide NoSQL databases with transactional facilities as well as to analyze the effects of transactions on data consistency and efficiency in user’s applications. The proposed schemes are evaluated using the YCSB + T benchmark which is based on Yahoo! Cloud Services Benchmark (YCSB). Experimental results show that using the proposed schemes, strong consistency can be achieved in MongoDB and Riak without severely affecting their efficiency. We also conduct experiments in order to analyse the level of consistencyof MongoDB and Riak transactional systems.

Morphological characterization of geographical indication litchi crops and released varieties grown in Bangladesh

Four Geographical Indication litchi genotypes (GIs) viz., Kadmi Lichu, Mongalbari Lichu, Deshi/Ati/Rajshahi Local (BARI Lichu-1) and Bedana Lichu, and three released varieties viz., BARI Lichu-2, 3 and 4) were characterized morphologically during July 2012 to June 2013 with a view to identifying the degree of morphological and genetic variation of litchi within cultivars, and to establish a permanent database for documentation of litchi. Morphological characterization data were recorded from standing trees of the most concentrated areas of cultivation for GIs and the respective stations from where the variety was released viz., Kadmi from Sonargaon, Narayanganj; Mongalbari from Pakundia, Kishoreganj; Rajshahi Local from Mohanpur village of Shyampur union under Rajshahi district; Bedana from Masimpur, Dinajpur; BARI Lichu-2 and BARI Lichu-3 from RARS, Akbarpur and BARI Lichu-4 from BSPC, Debiganj. Historical background of geographical indication crops of litchi as described by aged people of their most concentrated areas of cultivation indicated that the cultivars were originated naturally in those areas. The cultivars were very location specific. They do not perform well in respect of yield and quality outside their areas of origin indicating their very narrow adaptability range. It was another indication regarding location of origin of the GI crops. On the other hand, the exotic cultivars grown in the country such as BARI Lichu-2, BARI Lichu-3 etc. possess country wide adaptability. Wide variations were observed among the GI crops and released varieties included in this study for plant, leaf, inflorescence, flower and fruit characters. Variation was also recorded in respect of incidence of biotic and abiotic stresses like insect pests, mites, diseases, sunburn, fruit cracking and fruit drop. Each GI/released variety possesses some unique characters, which distinguish it from all other genotypes.Bangladesh J. Agril. Res. 42(1): 103-120, March 2017

WBS-based dynamic multi-dimensional BIM database for total construction as-built documentation

Abstract As-built documentation is valuable to assist decision-making in project control, and building operation and maintenance applications. Given the importance of as-built documentation, the quickly maturing technology of building information modeling (BIM), an object-oriented information-integration platform, has led to the emergence of concurrent as-built documentation during the construction phase. However, in the current practice, integrating construction records into BIM remains a challenge due to their heterogeneous and unstructured data formats. This paper presents a work breakdown structure (WBS)-based database design to enable the creation of a dynamic multi-dimensional BIM database to incorporate construction records in a timely manner. In this study, the construction records were defined as additional dimension, and a WBS code-based automated linking mechanism between construction project tasks and BIM objects was created to generate the multi-dimensional BIM database. The automatic linking mechanism and the WBS-based dynamic multi-dimensional BIM database were tested and verified through the implementation of a real construction project schedule and a BIM model. The test results illustrate that the newly created method is successful in incorporating construction records collected during the construction phase to generate a dynamic BIM database for generating complete as-built documentation.

Designing priority databases for QMS according to ISO 9001: 2015 standard

The international ISO 9001:2015 standard for quality management system (QMS) is widely implemented in this country, especially in business organisations and in public administration. The Standard was created in 1987; it was revised and amended in 1994, 2000 and 2008, the latest amendments being of the largest scope. Compared to the previous ISO 9001:2008 standard, this standard does not require a complicated manual to be devised: instead of six, it needs no documented procedures now and only 18 prescribed reports are required in comparison with 21 in the previous version. The organisations that have already certified their standards to comply to the earlier ISO 2001:2008 standard have to adopt the new standard now, and no later than 2018. One of the greatest problems in this transition is designing the required databases necessary for the practical implementation of the new standard. The solution proposed by the authors is a general model with six priority databases: Documented information database; Measuring, control and testing equipment database; Qualified personnel database; Complaints on process output nonconformity database; Costs of process output nonconformity database and Plant and work equipment maintenance database.

Model and technology of lingware support in tasks of the nuclear knowledge management system

Model and technology of lingware application in the tasks of the knowledge management are presented. The used model of thesauri paradigmatic relationships allows measuring semantic similarity of documents. An algorithm for compiling a semantic intersection of conceptual patterns based on the coinciding maximum principle is described. The semantic neighborhood construction in accordance with the value of semantic similarity measure and descriptors ranking allows using in the expansion of the search query the descriptors, whose semantics are closer due to the links, which reflect the common semantics of genus-species and associative relationships. An algorithm for thesauri used in automatic classification tasks is considered. The technology of conceptual hierarchical dynamic formation of structures is proposed. The proposed method of constructing a terminological network structure with hierarchical relationships for the collection of texts of a particular subject area is based on the sequential formation of lexicographical neighborhoods of “nuclear” terms, which are used as high-frequency nouns. To build up a conceptual structure a documental databases are used.

Tabernacles of memory revisited

The study assessed the oral history projects undertaken between 1994 and 2014 within the Pietermaritzburg Cluster of Theological Libraries to ascertain the depth and breadth of their collections in as far as documenting the voice of the indigenous clergy is concerned. Data collection instruments used for the study were interviews, both face-to-face and telephonically, documentary analysis, email correspondence and database checks. The findings revealed that the School of Theology, now the School of Religion, Philosophy and Classics (SRPC), at the University of KwaZulu-Natal, was at the forefront in this collection drive and that theological libraries were generally lagging behind; that ethnographical, literacy and content challenges are prevalent and that there is a dearth of material pertaining to religious archives on the National Register of Oral Sources (NAROS) database, which does not bode well with regards to the management of this ecclesiastical heritage. The study also revealed that there was a need for a co-ordinated oral history collection strategy to avoid duplication of effort. The study recommended that for religious archives to be effectively managed, private archives need to be properly legislated like their public counterparts, hence the need for a new national model in this regard irrespective of the perceived institutional imperatives.

De lo crudo a lo cocinado: sobre el léxico fundamental de la culinaria en la historia del español (siglos XIII a XVII)

In this paper, we shall reconstruct the foundations of cooking vocabulary in Medieval and Renaissance Spanish by analyzing the verbs referring to culinary methods and the substantives naming the principal types of dishes. These substantives belong to two word groups: nominalizations of culinary verbs and metonymic use of designations of cooking vessels. The documentary database consists of historical cookbooks, treatises on medicine and on agriculture as well as data of the CORDE corpus.

History of the common bean crop: its evolution beyond its areas of origin and domestication

The common bean (Phaseolus vulgaris L.) is the most important grain legume for direct human consumption on a global scale. Current bean germplasm collections show a wide variation of phenotypes, although genetic erosion is gradually affecting this species as in many countries local traditional varieties are being replaced by elite cultivars. This crop has spread to every continent over the past few centuries, which has resulted in a complex genetic structure of bean germplasm outside its areas of origin and domestication (South and Central America). Some evidence indicates that this germplasm is more complex than previously thought and contains additional, as yet unexplored, diversity. This is especially the case in southern Europe, particularly in the Iberian Peninsula, where it was introduced in the early sixteenth century and has been documented as a secondary focus of domestication of the species. The integration of omic data into bean germplasm documentation databases and its combination with genotypic, phenotypic and agro-ecological data is opening a new era for the enhancement and efficient use of common bean genetic resources as the main grain legume in Europe and worldwide.

A Free Access, Automated Law Citator with International Scope: The LawCite Project

Twelve free access and non-profit providers of legal information from across the common law world have collaborated to produce an automated international citator for case law and legal scholarship, access to end-users free of any user charges. This context imposes constraints on project development: only modest grant funding for development; open source plus purpose-developed software; no significant editorial input to develop application data, only automation; very limited maintenance funds; and no user charges or advertising revenue. The LawCite citator is the principal output to date of the LawCite Project, developed by the Australasian Legal Information Institute (AustLII) for the consortium of participating legal information institutes (LIIs). LawCite currently contains index records of the citation histories of almost five million cases, law journal articles, law reform documents and treaties. The citator is international, containing citation records in significant numbers from court decisions in 75 countries (primarily but not exclusively from common law countries).The purpose of this paper is to explain how the components of the LawCite project work, in some technical detail, and to outline the applications that have already resulted (both the citator and others), and future applications that are planned and possible. Our goal is for the LawCite project to play a key role in future global development of free access to legal information, provided collaboratively by free access providers across the globe.The LawCite project has developed and uses 3 main databases in an iterative fashion to produce its applications (the citator and other applications). They are: (i) The Citations database (basic information related to a citation); (ii) The Series database (information about each series of law reports, law journals, treaties, or law reform reports recognised by LawCite); and (iii) The Document database (an XML record for each recorded case or journal article). Oracle Berkeley DB (database software) is used for data mining and markup, and for construction of the Citations and Series databases. The Series and Document databases are used to generate the Citations database. The Series database is manually updated periodically. The Document and Citations databases are recreated automatically during each iteration of the data mining and ‘unmining’ processes. Raw citation lists are gathered from participating LII and non-LII data sources by the Citation Miner. Once collected, these are analysed, combined and normalised by the “Unminer” and from the combined list, the LawCite databases are generated. These databases are used both by the LawCite Citator as well as for the markup of text. The article explains these processes.The article concludes with a brief account of the citator from the user perspective, other outputs from the project (the publicly accessible LawCite Automated Markup Tool, and the markup tools used by LIIs), and potential future applications (informing policy debates through citation information; data visualisation of citation flows; and contextual ranking).

Performance Analysis of NoSQL Databases

couple of years working on big data is a challenge. Currently there are lot of document oriented tools, we have to choose best tool from them, and so they are need to be compared. We compared CouchDB, and RavenDB to know which one of them is good. NoSQL derived from relational database, information can be retrieved fast and is portable database. RDBMS is not flexible enough to handle the variety of data. Couch dB is also considered in web world. RavenDB is a transactional, open-source Document Database written in .NET, and offering a flexible data model designed to address requirements coming from real-world systems. Using RDBMSs for Big Data is prohibitively expensive. Each one of these database has advantages and limitation hence, If a query is executed enough times, those indices are promoted to be permanent (auto-generated) indices. Even a simple query requires significant programming expertise, and commonly used BI tools do not provide connectivity to NoSQL. Databases are analyzed on the basis of their time complexities and space and finally in the end we found out of which one has real ability to get used in different situation. And also which is more efficient.

Model of Learning Objects Exchange between LCMS Platforms through Intelligent Agents1

Currently, there are a variety of digital resources hosted on the Internet, based on access points such as digital libraries and repositories. The majority of strategies to store information are used by specialized documentation centers, academic institutions, and databases of regional development policies. These entities have been directing their efforts to improve the access over a collection of digital resources for academic and professional purposes. There is still a lot of educational material that is hosted on content management tools known as Learning Content Management System (LCMS); however, those tools do not perform the corresponding indexing of digital resources for the use of repositories. In fact, this requirement reduces the access to digital resources even from the inside of each academic institution, losing coverage and recognition in other learning environments. Moreover, this factor also limits the enrichment and linking of related academic material. Then, strategies such as Linked Data cannot be extensively used to share digital resources. Therefore, this article aims to devise an indexing strategy to manage digital resources hosted in different LCMS by defining services that facilitate the exchange of digital resources and their reuse. Case Study: Efront and Moodle platforms.

New features in the MOGADOC database

The development of the Molecular Gas-Phase Documentation database is briefly described. It has been developed from a unique literature compilation via the first client programs on computer mainframes and personal computers to a versatile HTML-based version, which can be run platform-independently by common Web browsers. In the database, the structural parameters for about 9200 organic, metalorganic, and inorganic compounds studied in the gas phase mainly by electron diffraction and microwave spectroscopy are given numerically, and the molecular structures can be visualized in many ways, particularly in three-dimensional representation. Moreover, the spectroscopic parameters (such as rotational and centrifugal distortion constants, dipole moments, nuclear quadrupole coupling constants, and barriers of hindered rotation) can be retrieved by keywords.

Measuring Violations of Human Rights: An Empirical Analysis of Awards in Respect of Non-Pecuniary Damage Under the European Convention on Human Rights

This is the first study to examine the awards made by the European Court of Human Rights in respect of non-pecuniary damage from an empirical perspective. It uses a multiple regression analysis based on data (929 cases) drawn from the Council of Europe’s Human Rights Documentation (HUDOC) database. By legal analysis we identified three elements of the “equity principle” used by the Court for the calculation of awards made in respect of non-pecuniary damage (seriousness of the violation, applicant- and overall context-related factors), which we used in our regression analysis. Our empirical results show that there is a statistically significant association between the amount awarded in respect of non-pecuniary damage and the intensity of the violation, the existence of a separate opinion, the respondent state and the fact of whether the applicant is a legal or a natural person. Our study therefore contradicts the view voiced in the literature that awards made in respect of non-pecuniary damage under the ECHR are “unpredictable” and “inconsistent”.

Document Summarization and Evaluation using Knowledge based Super Set Features

Document summarization is an important step while clustering the large no. of digital documents data base. Documents are clustered in accordance with their contents using the document text summary. The document summarization involves the knowledge corpus scheme comprising of corpus coverage, sentence coverage and term coverage weight. Further, three new weights are introduced as super sentence coverage weight, super corpus coverage weight and super term coverage weight. Super coverage weight is based on synonyms of the key words. The quality of document summary improves and diversified when synonyms of key words are also given due weightage in the process of text processing. The evaluation for the document summary quality is based on inner content metrics precision, recall, F-measure method.

Relocating a Sense of Place Using the Participatory Geoweb

The interactive capability and ease of use of Geoweb technologies suggest great potential for Aboriginal communities to store, manage, and communicate place-related knowledge. For the Métis, who have a long history of dispossession and dispersion in Canada, the Geoweb offers an opportunity in realizing the desire to articulate a coherent sense of place for their people. This paper reports on a community-based research project involving the University of British Columbia (UBC) and the Métis Nation of British Columbia (MNBC) – the political body representing the Métis people in BC. The project includes the creation of a Geoweb tool specifically designed to facilitate the (self) articulation of a Métis community in contemporary BC. It examines how Geoweb technologies have been used to create a participatory, crowd-sourced Historical Document Database (HDD) that takes meaning through the interface of a map. The paper further explores how the data contributed by members of the Métis community have been used to capture, communicate, and represent community memories in the dispersed membership. It concludes by examining challenges that have emerged related to platform stability and institutional relations related to the ongoing sustainability of the HDD.

Work Zone Safety Analysis and Modeling: A State-of-the-Art Review

Objective: Work zone safety is one of the top priorities for transportation agencies. In recent years, a considerable volume of research has sought to determine work zone crash characteristics and causal factors. Unlike other non–work zone–related safety studies (on both crash frequency and severity), there has not yet been a comprehensive review and assessment of methodological approaches for work zone safety. To address this deficit, this article aims to provide a comprehensive review of the existing extensive research efforts focused on work zone crash-related analysis and modeling, in the hopes of providing researchers and practitioners with a complete overview.Methods: Relevant literature published in the last 5 decades was retrieved from the National Work Zone Crash Information Clearinghouse and the Transport Research International Documentation database and other public digital libraries and search engines. Both peer-reviewed publications and research reports were obtained. Each study was carefully reviewed, and those that focused on either work zone crash data analysis or work zone safety modeling were identified. The most relevant studies are specifically examined and discussed in the article.Results: The identified studies were carefully synthesized to understand the state of knowledge on work zone safety. Agreement and inconsistency regarding the characteristics of the work zone crashes discussed in the descriptive studies were summarized. Progress and issues about the current practices on work zone crash frequency and severity modeling are also explored and discussed. The challenges facing work zone safety research are then presented.Conclusions: The synthesis of the literature suggests that the presence of a work zone is likely to increase the crash rate. Crashes are not uniformly distributed within work zones and rear-end crashes are the most prevalent type of crashes in work zones. There was no across-the-board agreement among numerous papers reviewed on the relationship between work zone crashes and other factors such as time, weather, victim severity, traffic control devices, and facility types. Moreover, both work zone crash frequency and severity models still rely on relatively simple modeling techniques and approaches. In addition, work zone data limitations have caused a number of challenges in analyzing and modeling work zone safety. Additional efforts on data collection, developing a systematic data analysis framework, and using more advanced modeling approaches are suggested as future research tasks.

Análisis comparativo de herramientas de recuperación y análisis de información de acceso libredesde una concepción docente

En el Instituto de Cibernética, Matemática y Física de la República de Cuba se imparte el curso"Bases de datos y biblioteca digital" dentro de la Maestría de Cibernética Aplicada. Parte esencial del curso la constituye la creación de bases de datos documentales a partir de la recuperación de información en Internet. Para poder realizar los laboratorios requeridos para un mejor aprendizaje se requiere seleccionar las herramientas de recuperación de información más idóneas, tanto desde el punto de vista docente como desde las facilidades para su adquisición. Se definieron entonces las características para evaluar esas herramientas y la metodología para realizar la selección. Como resultado, de trece herramientas de recuperación y análisis de la información de software libre analizadas que pudieron ser descargadas se seleccionaron ocho herramientas, Lemur Toolkit con Indri, Sphinx, WebSphinx con Rapid Miner, Solr/Lucene/Hadoop/Mahout, Terrier, Dragon lo cual permitió garantizar la calidad del curso impartido y su concatenación con otros cursos de la misma maestría.

Research on XML Documents and Relational Database Mapping Based on XML Schema

In order to implement the mapping between XML documents and relational database, this paper proposes the mapping method based on XML documents and relational database. On the basis of keeping documents ’hierarchy, order and uniqueness, this method can mapping XML documents to the corresponding relational database very quickly and implement the reconstruction of XML documents.

Tu1559 Validation of Automated Colonoscopic Findings From an Endoscopic Documentation Database (Provation) Against Manually Collected Data

examination. We aimed to evaluate a computed assessment of cleansing. We included 40 CCE-examinations performed in individuals with positive immunochemical-fecal-occult-blood test. Two readers rated segmental and overall cleansing levels using existing scales. Computed assessment of cleansing was performed by measuring the intensities in color channels of the CCE-examination. Associations between the conventional and computed scores were investigated using ANOVA, intraclass correlation coefficient (ICC), receiver operating characteristics curve (ROC) analysis, and Pearson correlation coefficient. The mean segmental computed 4-point score were as follows: poor: 2.3; fair: 4.8; good: 5.3; excellent: 5.9 (ICC: 0.715, p!0.0001). The mean computed score was 5.3 for segments judged adequate and 4.2 for segments judged inadequate (area under the ROC: 0.78, p!0.0001). The lowest mean overall computed 4-point score were as follows: poor: 1.8; fair 4.5; good: 4.8; excellent 4.8 (ICC: 0.709, p!0.0001). For examinations judged adequate on the 2-point scale the mean of the lowest segmental computed score was 4.8, for examination judged inadequate this was 3.8 (are under the ROC: 0.73, p!0.009). The correlation between the summation of the three conventional segmental scores and the summation of the three computed segmental scores was good (Pearson correlation coefficient 0.701, p!0.001). Our study indicates that computed assessment of cleansing in CCE is feasible, and shows good agreement with the conventional assessments of cleansing. Automated analysis could be more reliable and timeefficient than conventional assessments of cleansing.

Validation of Automated Colonoscopic Findings from an Endoscopic Documentation Database (Provation) against Manually Collected Data

Purpose: Many endoscopy units are now using computer-based endoscopic documentation software such as Provation (Wolters Kluwer, Minneapolis). Such software can generate sophisticated outcomes data on large numbers of patients automatically, resulting in a growing number of published studies based on endoscopic databases. However, no published study has yet validated endoscopic software data against manually collected data. To this end, we compared the colonoscopic findings reported by Provation against manually collected findings from two similar cohorts of patients in the same endoscopy unit. Methods: In November 2011, our endoscopy unit switched from a dictation-based documentation system to the Provation system. As part of a long-term quality control initiative, we had collected data on 9,714 patients who had undergone elective colonoscopies from January 2010 to November 2011, using manual chart review involving a trained data abstractor. We compared these findings against those generated by Provation on 7,091 patients who underwent colonoscopy from November 2011 to March 2013. Results: The Provation cohort was similar to the Manual cohort with regard to mean age (59.2 vs 58.8 years; p=0.31), gender distribution (49.5% male vs 48.3%; p=0.13), and indications (48.9% screening, 30.6% surveillance and 20.5% diagnostic vs 46.4%, 30.8% and 22.9% respectively; p=0.10). The incidence of poor bowel preparation was similar between the two groups, as were the percentages of patients with one or more large polyp(s) (≥1 cm) or mass lesion(s). However, the Manual cohort had a higher prevalence of diverticulosis and hemorrhoids, while the Provation cohort had a lower colonoscopy completion rate, and a higher prevalence of polyps of any size (Table). If we restrict our analysis to screening patients, the Manual cohort showed a polyp prevalence of 45.2%, large polyp prevalence of 7.1% and mass prevalence of 0.2%, while the Provation cohort had prevalences of 45.7%, 7.6% and 0.3% respectively (all p-values >0.05).TableConclusion: Data generated by Provation are slightly different from data from manual chart review, although the large polyp and mass prevalence are similar. If we consider manual collected chart review to be the “gold standard”, this study partially validates the Provation data, but caution is advised when using endoscopic data for outcomes research.