XML Database Research Articles

A Comparison and Benchmarking on Data Storage and Query Retrieval for Native XML Databases

A Comparison and Benchmarking on Data Storage and Query Retrieval for Native XML Databases

An approach to support model based definition by PMI annotations

ABSTRACTPMI annotations are widely used to support the Model Based Design within modern companies. In particular, the introduction of digital annotations marks the transition from the 2D drawings to the 3D representation in many manufacturing and design companies. However, today the implementation of the PMI technology presents some limits, such as the lack of functions to generate structure templates to be applied to similar CAD models. The proposed approach aims to overcome the limits of traditional tools which are not able to add a PMI annotation’s structure from one model to another one. The paper describes a method to reuse digital PMI annotations in a new model during the design phase, where the annotations are inherited from similar CAD documents. The proposed approach is based on two levels of geometric analysis: the searching of similar template models from an XML database, and the identification of the related geometric entities, which are used as associated objects for the definition of 3D anno...

The arc of Mass Spectrometry Exchange Formats is long, but it bends toward HDF5.

The evolution of data exchange in Mass Spectrometry spans decades and has ranged from human‐readable text files representing individual scans or collections thereof (McDonald et al., 2004) through the official standard XML‐based (Harold, Means, & Udemadu, 2005) data interchange standard (Deutsch, 2012), to increasingly compressed (Teleman et al., 2014) variants of this standard sometimes requiring purely binary adjunct files (Römpp et al., 2011). While the desire to maintain even partial human readability is understandable, the inherent mismatch between XML's textual and irregular format relative to the numeric and highly regular nature of actual spectral data, along with the explosive growth in dataset scales and the resulting need for efficient (binary and indexed) access has led to a phenomenon referred to as “technical drift” (Davis, 2013). While the drift is being continuously corrected using adjunct formats, compression schemes, and programs (Röst et al., 2015), we propose that the future of Mass Spectrometry Exchange Formats lies in the continued reliance and development of the PSI‐MS (Mayer et al., 2014) controlled vocabulary, along with an expedited shift to an alternative, thriving and well‐supported ecosystem for scientific data‐exchange, storage, and access in binary form, namely that of HDF5 (Koranne, 2011). Indeed, pioneering efforts to leverage this universal, binary, and hierarchical data‐format have already been published (Wilhelm et al., 2012; Rübel et al., 2013) though they have under‐utilized self‐description, a key property shared by HDF5 and XML. We demonstrate that a straightforward usage of plain (“vanilla”) HDF5 yields immediate returns including, but not limited to, highly efficient data access, platform independent data viewers, a variety of libraries (Collette, 2014) for data retrieval and manipulation in many programming languages and remote data access through comprehensive RESTful data‐servers. © 2016 The Authors. Mass Spectrometry Reviews published by Wiley Periodicals, Inc. Mass Spec Rev 36:668–673, 2017

Hybridation of Labeling Schemes for Efficient Dynamic Updates

<p>With XML as the leading standard for data representation over the Web, it is crucial to store and query XML data. However, relational databases are the dominant database technology in most organizations. Thus, replacing relational database with a pure XML database is not a wise choice. One most prominent solution is to map XML into relational database. This paper introduces a robust labeling scheme which is a hybrid labeling scheme combining the beauty features of extended range and ORDPATH schemes to supports dynamic updates. In addition, we also proposed a mapping scheme based on the hybrid labeling scheme. Our proposed approach is evaluated in terms of (i) loading time, (ii) storage size, (iii) query retrieval time, and (iv) dynamic updates time, as compared to ORDPATH and ME schemes. The experimental evaluation results shows that our proposed approach is scalable to support huge datasets and dynamic updates.</p>

Lexicographic Tools to Build New Encyclopaedia of the Czech Language

Abstract The first edition of the Encyclopaedia of the Czech Language was published in 2002 and since that time it has established as one of the basic reference books for the study of the Czech language and related linguistic disciplines. However, many new concepts and even new research areas have emerged since that publication. That is why a preparation of a complete new edition of the encyclopaedia started in 2011, rather than just re-printing the previous version with supplements. The new edition covers current research status in all concepts connected with the linguistic studies of (prevalently, but not solely) the Czech language. The project proceeded for five years and it has finished at the end of 2015, the printed edition is currently in preparation. An important innovation of the new encyclopaedia lies in the decision that the new edition will be published both as a printed book and as an electronic on-line encyclopaedia, utilizing the many advantages of electronic dictionaries.In this paper, we describe the lexicographic platform used for the Encyclopaedia preparation and the process behind the work flow consisting of more than 3,000 pages written by nearly 200 authors from all over the world. The paper covers the process of managing entry submissions, the development of tools to convert word processor files to an XML database, tools to cross-check and connect bibliography references from free text to structured bibliography entries, and the preparation of data for the printed publication.

Privacy-Preserving Publishing of Hierarchical Data

Many applications today rely on storage and management of semi-structured information, for example, XML databases and document-oriented databases. These data often have to be shared with untrusted third parties, which makes individuals’ privacy a fundamental problem. In this article, we propose anonymization techniques for privacy-preserving publishing of hierarchical data. We show that the problem of anonymizing hierarchical data poses unique challenges that cannot be readily solved by existing mechanisms. We extend two standards for privacy protection in tabular data ( k -anonymity and ℓ-diversity) and apply them to hierarchical data. We present utility-aware algorithms that enforce these definitions of privacy using generalizations and suppressions of data values. To evaluate our algorithms and their heuristics, we experiment on synthetic and real datasets obtained from two universities. Our experiments show that we significantly outperform related methods that provide comparable privacy guarantees.

Securing native XML database-driven web applications from XQuery injection vulnerabilities

Database-driven web applications today are XML-based as they handle highly diverse information and favor integration of data with other applications. Web applications have become the most popular way to deliver essential services to customers, and the increasing dependency of individuals on web applications makes them an attractive target for adversaries. The adversaries exploit vulnerabilities in the database-driven applications to craft injection attacks which include SQL, XQuery and XPath injections. A large amount of work has been done on identification of SQL injection vulnerabilities resulting in several tools available for the purpose. However, a limited work has been done so far for the identification of XML injection vulnerabilities and the existing tools only identify XML injection vulnerabilities which could lead to a specific type of attack. Hence, this work proposes a black-box fuzzing approach to detect different types of XQuery injection vulnerabilities in web applications driven by native XML databases. A prototype XQueryFuzzer is developed and tested on various vulnerable applications developed with BaseX as the native XML database. An experimental evaluation demonstrates that the prototype is effective against detection of XQuery injection vulnerabilities. Three new categories of attacks specific to XQuery, but not listed in OWASP are identified during testing.

Fuzzy-Based XML Knowledge Retrieval Methods in Edaphology

In this paper, we propose a proficient method for knowledge management in Edaphology to assist the edaphologists and those related with agriculture in a big way. The proposed method mainly consists two sections of which the first one is to build the knowledge base using XML and the latter part deals with information retrieval by searching using fuzzy. Initially, the relational database is converted to the XML database. The paper discusses two algorithms, one is when the soil characteristics are inputted to have the plant list and in the other, plant names are inputted to have the soil characteristics suited for the plant. While retrieving the query result, the crisp numerical values are converted to fuzzy using the triangular fuzzy membership function and matched to those in database. And those which satisfy are added to the result list and subsequently the frequency is found out to rank the result list so as to obtain the final sorted list. Performance metrics used in order to evaluate the method and compare it to baseline paper are number of plants retrieved, ranking efficiency, and computation time and memory usage. Results obtained proved the validity of the method and the method obtained average computation time of 0.102 seconds and average memory usage of 2486 Kb, which all are far better than the previous method results.

Transforming Data for Reuse and Re-publication with XML and XSL

This tutorial will provide you with the ability to convert or transform historical data from an XML database (whether a single file or several linked documents) into a variety of different presentations—condensed tables, exhaustive lists or paragraphed narratives—and file formats.

Transforming Data for Reuse and Re-publication with XML and XSL

This tutorial will provide you with the ability to convert or transform historical data from an XML database (whether a single file or several linked documents) into a variety of different presentations—condensed tables, exhaustive lists or paragraphed narratives—and file formats.

Share Market Management System Based Keyword Query Processing on XML Data

Nowadays, many research has been focused on XML database systems. In share market, the value of a share changes over time. For managing market values of a share, traditional databases are commonly used. Main such example is relational database. But use of such databases are not efficient since it cannot handle more complex applications and do not have the ability to be scalable. In this paper we implement a Share Market Management System using an XML database. The main function of Share Market Management System ( SMMS ) is to store, retrieve and update the information about share market values. Keyword-based query solution is implemented to obtain the results. Then its performance is evaluated by considering the compilation, parsing and execution metric as total time.

Extensible Markup Language Databases: A Study

Recent years have perceived a theatrical increase in the fame and acceptance of XML - eXtensible Markup Language. This impulsive growth is determined by its ability to offer a standardized, extensible means of involving semantic content within documents describing semi-structured data in database management systems. It enables to address the limitations of existing markup languages and support data exchange in relational databases. Most of the information systems that work on relational databases today are to suffer a lack of both performance and inter-operability or migration issues especially when the information systems work on different databases at different nodes of operations. The XML Native Databases also known as NXD cater to this issue, as XML has emerged into the most powerful markup language that can effectively store, carry or even transform data and its unique feature of encoding independent, platform independent nature. Hence, the paper discusses the survey of earlier works and addresses the need for XML databases as compared to relational databases and further, an insight into the document centric feature of the NXD required by present day use case scenarios.

A Comparison and Benchmarking on Data Storage and Query Retrieval for Native XML Databases

Objectives: Native XML Databases (NXD) is one of the technologies for storing and retrieving XML documents. Basically, a good database should cater for efficient storage and fast retrieval. Methods/Statistical Analysis: In NXD, it creates a logical model to store and retrieve XML documents with no mapping required. In another words, the storage and retrieval operation are most optimized in its native format. Findings: NativeGine is a simulation engine to compare the performances of three existing open source native XML database products through handling several basic database operations. In distinct, Xindice, eXist and Sedna will be examined in terms of storing and query retrieval speed. Based on the results obtained, Sedna has the best performance for database creation and data insertion. Yet, eXist gains the outstanding performance on query retrieval as it has the minimum response time for all types of queries. Application/Improvements: The results generated by the engine are beneficial to aid the community to choose the appropriate database system.

Designing and Implementation of Retina Image Drawing System and Automatic Report Generation from Retina Examinations.

Introduction:Electronic medical records as one of major parts of electronic health records is an important application of Medical Informatics. EMR includes different types of data, Graphical items being one of these data types. To this end, a standard structure for storing and recovering and finally exchanging this data type is required. In order to standardize information items in this research, UMLS standard is used. In this research, graphical information from fondues designing in retina surgery forms is used for the task of implementation.Implementation:Three-layer software architecture is used for implementation of this system, which includes user interface, data base access and business logic. XML database is used for storing and exchanging of data. User interface is designed by the means of Adobe Flash. Also in the user interface for eye examinations, appropriate icons compatible with current pathologies in retina examinations are considered and UMLS codes are used for standardizations purposes.Results:As this project is independently implemented in Adobe Flash, it can be run in most of electronic patient records software. For evaluation purposes of this research, an EMR system for eye clinics is used. Tree structure is used for data entry and finally a text report based on the entered data will be generated. By storing graphical items in this software editing and searching in medical concepts and also comparing features will be available.Conclusion:One of the data items that we encounter in various medical records is graphical data. In order to cover the patient’s complete electronic medical records, the Electronic Implementation of this information is important. For this purpose, graphical items in retina surgery forms were used and finally a software application for drawing retina picture was developed. Also, XML files were used for the purpose of storing valuable medical data from the pictures, and also UMLS were applied for the standardization purpose. The developed software is currently being used in some of eye clinics in Iran.

XML Database for Hadith and Narrators

Hadith is considered as the second legalization source in Islam after the Holy Quran, it is the sayings, actions and approval of prophet Mohammad (Peace Be Upon Him), many websites and programs introduced Databases to give the required support for solving many problems in Hadith processing, graduation, verification, etc. The main objective of this research is to build and implement a database for all Hadiths and narrators of “Sahih Al-Boukari” as a first step, this database will be extended to cover other Hadith books. This database contains two types of XML documents: Hadith document and narrators document. The tags of the XML documents are the features of the HPSG formalism. This formalism is characterized by rich lexical representations. The information in a lexical entry is not only about the nature of this input but also provides information for determining what elements that can be combined with this entry. To develop this application we used java programming language and XML to ensure the scalability, interoperability and the reusability of resources and developed contents. In its first version, our application use a large database that contains all Hadiths of “Sahih Al-Boukari” and all information about its narrators extracted from “Tahdheeb Altahdeeb” book. This application permits decomposing the entered Isnad and obtain the chain of narrators, add Hadith or narrators in database using graphical user interface, make many types of search like Hadiths of any narrator or speaker, Hadiths of any entered book or part and so on. After decomposition of enter Isnad, the user obtains the chain of narrators in a list and it can visualize the information about any narrator in the chain. All extracted information will be later used in Hadith graduation or in judgment on the validity of the Hadith.

Xml database compression by adaptive huffman coding algorithm techniques

Xml database compression by adaptive huffman coding algorithm techniques

USING PARAMETERS OF DYNAMIC PULSE FUNCTION FOR 3D MODELING IN LOD3 BASED ON RANDOM TEXTURES

Abstract. The pulse function (PF) is a technique based on procedural preprocessing system to generate a computerized virtual photo of the façade with in a fixed size square(Alizadehashrafi et al., 2009, Musliman et al., 2010). Dynamic Pulse Function (DPF) is an enhanced version of PF which can create the final photo, proportional to real geometry. This can avoid distortion while projecting the computerized photo on the generated 3D model(Alizadehashrafi and Rahman, 2013). The challenging issue that might be handled for having 3D model in LoD3 rather than LOD2, is the final aim that have been achieved in this paper. In the technique based DPF the geometries of the windows and doors are saved in an XML file schema which does not have any connections with the 3D model in LoD2 and CityGML format. In this research the parameters of Dynamic Pulse Functions are utilized via Ruby programming language in SketchUp Trimble to generate (exact position and deepness) the windows and doors automatically in LoD3 based on the same concept of DPF. The advantage of this technique is automatic generation of huge number of similar geometries e.g. windows by utilizing parameters of DPF along with defining entities and window layers. In case of converting the SKP file to CityGML via FME software or CityGML plugins the 3D model contains the semantic database about the entities and window layers which can connect the CityGML to MySQL(Alizadehashrafi and Baig, 2014). The concept behind DPF, is to use logical operations to project the texture on the background image which is dynamically proportional to real geometry. The process of projection is based on two vertical and horizontal dynamic pulses starting from upper-left corner of the background wall in down and right directions respectively based on image coordinate system. The logical one/zero on the intersections of two vertical and horizontal dynamic pulses projects/does not project the texture on the background image. It is possible to define priority for each layer. For instance the priority of the door layer can be higher than window layer which means that window texture cannot be projected on the door layer. Orthogonal and rectified perpendicular symmetric photos of the 3D objects that are proportional to the real façade geometry must be utilized for the generation of the output frame for DPF. The DPF produces very high quality and small data size of output image files in quite smaller dimension compare with the photorealistic texturing method. The disadvantage of DPF is its preprocessing method to generate output image file rather than online processing to generate the texture within the 3D environment such as CityGML. Furthermore the result of DPF can be utilized for 3D model in LOD2 rather than LOD3. In the current work the random textures of the window layers are created based on parameters of DPF within Ruby console of SketchUp Trimble to generate the deeper geometries of the windows and their exact position on the façade automatically along with random textures to increase Level of Realism (LoR)(Scarpino, 2010). As the output frame in DPF is proportional to real geometry (height and width of the façade) it is possible to query the XML database and convert them to units such as meter automatically. In this technique, the perpendicular terrestrial photo from the façade is rectified by employing projective transformation based on the frame which is in constrain proportion to real geometry. The rectified photos which are not suitable for texturing but necessary for measuring, can be resized in constrain proportion to real geometry before measuring process. Height and width of windows, doors, horizontal and vertical distance between windows from upper left corner of the photo dimensions of doors and windows are parameters that should be measured to run the program as a plugins in SketchUp Trimble. The system can use these parameters and texture file names and file paths to create the façade semi-automatically. To avoid leaning geometry the textures of windows, doors and etc, should be cropped and rectified from perpendicular photos, so that they can be used in the program to create the whole façade along with its geometries. Texture enhancement should be done in advance such as removing disturbing objects, exposure setting, left-right up-down transformation, and so on. In fact, the quality, small data size, scale and semantic database for each façade are the prominent advantages of this method.

Comparison of XReal and XDMA for Keyword Search in XML Databases: A Case Study

More research works have been carried out in the area of keyword search on XML databases. This is mainly because of the fact that users do not require knowledge of database schema and query language to search XML databases based on keyword queries. In the recent past, XReal and XDMA are the most prominent keyword search approaches for XML databases. Both XReal and XDMA make use of the numerical facts and hierarchical structure of XML databases. Never the less, these approaches are not reliant on schema information of XML data. In XReal, term frequency and document frequency have been mainly utilized. However, XDMA employs dual indices and mutual summation with the use of the frequency of keyword matching tags and data. In this paper, we discuss briefly the very important aspects of these approaches. Also, we compare these two keyword search approaches based on their methodologies and experimental results. It is found that both XReal and XDMA are generally effective XML keyword search approaches. Moreover, XDMA is comparatively slower than XReal for larger XML datasets. Notably, XDMA has identified a new keyword ambiguity and also addressed all ambiguities.

Standardized Storage of Sports Data Based on XML

Sports data feature strong timeliness, multiple types, many specifications, large data amount and very complex storage. The information technology has been more widely applied in sports data storage, and also achieved a wealth of research findings. In terms of sports data, the paper proposes a standardized data storage solution based on XML, makes a brief description of the methods and principles of various data concerning sports training programs, and then puts forward the logical structure of data storage. The XML data file system and database system grounded on XML storage sports in- dustry is simply discussed and a high efficient, standardized storage solution is raised for sports data.

DATABASE CONNECTOR: A TOOL FOR MANIPULATION ON DIFFERENT DATABASES

A database is an organized list of facts and information that can easily be accessed, managed, and updated. Database management system is a software application that interacts with the user and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. There are many well-known DBMSs which include MySQL, MS Access Database, MS SQL Server, Oracle etc. A database is not generally portable across different DBMSs, but different DBMSs can interoperate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one DBMS. This paper presents the salient features of developed DataBase Connector tool. The developed tool allows the user to perform DDL (Data Definition Language) and DML (Data Manipulation Language) command on different DBMSs including MS Access Database, SQL Server Database, SQL Express Database, XML Database and Oracle Server Database. The user has no need to have different software application to perform data definition and data manipulation operation on these different DBMSs.