Physical Sciences and Mathematics Commons^™

Inferring A Hierarchical Input Type For An Sql Query, Santosh Aryal

All Graduate Theses and Dissertations, Fall 2023 to Present

SQL queries are a common method to retrieve information from databases, much like asking a detailed question and getting a precise answer. Plug-and-play queries simplify the process of querying. In a Plug-and-play SQL query a programmer sketches the shape of the input to the query as a hierarchy. But the programmer could make a mistake in specifying the hierarchy and it takes programmer time and effort to specify the hierarchy. A better solution is to automatically infer the hierarchy from a query. This thesis presents a system to infer a hierarchical input type for an SQL query. We consider two …

The Plants Database: Providing Basic Plant Information, J S. Peterson, J F. Henson, W Oaks, J T. Kartesz

IGC Proceedings (1997-2023)

The PLANTS database provides basic plant information to the United States Department of Agriculture (USDA), Natural Resources Conservation Service (NRCS), its clients, cooperators, and the general public via the World Wide Web (Fig. 1). The foundation of PLANTS is a taxonomic backbone (checklist) of the vascular and nonvascular plants of North America (north of Mexico) and United States territories in the Caribbean and Pacific regions. Attribute data are appended to this backbone pertaining to distribution, vegetative specifications, nativity, federal and state status, crop data, growth form, growth parameters, species abstracts, and images.

Forage Data Hub – A Platform For Sharing Valuable Datasets For Resilience, Amanda J. Ashworth, L. Marshall, J. J. Volenec, M. Berti, E. Van Santen, C. Williams, V. Gopakumar, J. Foster, V. Picasso, J. Su

IGC Proceedings (1997-2023)

In accord with the necessity to enhance ecosystem services and productivity in food systems, is the increase of data availability at multiple scales and over time. To help meet this need, we discuss the development of a National Forage Data Hub which will act as a platform to curate, share, and analyze data pertaining to forage systems. This centralized hub will leverage existing datasets by bridging multiple sources including forage crop—soil, water, and nutrient availability—yield (animal and crop) potential (and gaps)— climate—management systems at high spatial and temporal resolution enabling system interaction assessments through next-generation analytics. This novel approach to …

The Impact Of Accessible Data On Cyberstalking, Elise Kwan

The Journal of Purdue Undergraduate Research

No abstract provided.

Implementing Impact: A Lesson On Mysql Databases And Accessibility, Abigayle Peterson, Yasmine Elglaly

WWU Honors College Senior Projects

15% of the world’s people have a disability that could potentially hinder their access to digital information such as bank portals and medical insurance. Digital accessibility, the practice of creating user-friendly technology, helps mitigate these challenges. Despite this fact, college Computer Science (CS) programs fail to recognize the importance of including digital accessibility courses as a degree requirement. Consequently, these CS graduates lack sufficient knowledge to build accessible software when they enter the technology industry, leading to potential company lawsuits for the unethical design of technology. Our research aims to bridge the gap between accessibility knowledge and the CS college …

On Hierarchical Clustering-Based Approach For Rddbs Design, Hassan I. Abdalla, Ali A. Amer, Sri Devi Ravana

All Works

Distributed database system (DDBS) design is still an open challenge even after decades of research, especially in a dynamic network setting. Hence, to meet the demands of high-speed data gathering and for the management and preservation of huge systems, it is important to construct a distributed database for real-time data storage. Incidentally, some fragmentation schemes, such as horizontal, vertical, and hybrid, are widely used for DDBS design. At the same time, data allocation could not be done without first physically fragmenting the data because the fragmentation process is the foundation of the DDBS design. Extensive research have been conducted to …

A Review On Antibacterial Activity Of Nanoparticles, Badr-Edine Sadoq, Mohammed Reda Britel, Adel Bouajaj, Ramzi Maâlej, Ahmed Touhami, Marwa Abid, Hanen Douiri, Fakhita Touhami, Amal Maurady

Physics and Astronomy Faculty Publications and Presentations

The increasing resistance of bacteria to antibiotic agents is a main global public health problem. The use of nanoparticles is one of the promising ways to overcome microbial resistance to antimicrobial agents. Metal nanoparticles are increasingly used to target bacterial strains. Advances in nanotechnology, in particular the ability to synthesize nanoparticles of specific size and shape, are likely to lead to the development of new antibacterial agents. The antibacterial activities of nanoparticles are largely influenced by their sizes and large surface area/mass ratio. The antibacterial mechanisms of nanoparticles are poorly understood, but the currently accepted mechanisms include oxidative stress induction, …

Compilation Of A Database Of Research Information On Legume Based Grazing Systems; A Part Of The Leggraze Research Project, J. J. Rochon, G. Molle, A. Hopkins, J. M. Greef

IGC Proceedings (1997-2023)

The establishment of a publicly accessible web-resident database of published and current European research on agronomy, animal production and environmental impact of legume based grazing systems is reported. This database facilitates the sharing of information among the partners of the "Low input animal production based on forage legumes for grazing systems" (Leggraze), a research project funded by the UE (QL K5 CT-2001-02328). It also forms an important tool for transferring the results of the project to the wider research community and to end users in the agricultural sector and to policy makers at national and community level.

Information-Theoretic Model Diagnostics (Infomod), Armin Esmaeilzadeh

UNLV Theses, Dissertations, Professional Papers, and Capstones

Model validation is a critical step in the development, deployment, and governance of machine learning models. During the validation process, the predictive power of a model is measured on unseen datasets with a variety of metrics such as Accuracy and F1-Scores for classification tasks. Although the most used metrics are easy to implement and understand, they are aggregate measures over all the segments of heterogeneous datasets, and therefore, they do not identify the performance variation of a model among different data segments. The lack of insight into how the model performs over segments of unseen datasets has raised significant challenges …

Ghostparty Video Game, Tyler Remlinger Hart

Computer Science and Software Engineering

GhostParty is a Unity game that uses a MongoDB database to store players' gameplay values. These values are used to create "Ghosts" that players can compete with in various mini-games. I found that this form of multiplayer using ghosts can create a good gameplay experience without live multiplayer interactions.

Visual Analytics And Modeling Of Materials Property Data, Diwas Bhattarai

LSU Doctoral Dissertations

Due to significant advancements in experimental and computational techniques, materials data are abundant. To facilitate data-driven research, it calls for a system for managing and sharing data and supporting a set of tools for effective data analysis and modeling. Generally, a given material property M can be considered as a multivariate data problem. The dimensions of M are the values of the property itself, the conditions (pressure P, temperature T, and multi-component composition X) that control the concerned property, and relevant metadata I (source, date).

Here we present a comprehensive database considering both experimental and computational sources …

Optimization Opportunities In Human In The Loop Computational Paradigm, Dong Wei

Dissertations

An emerging trend is to leverage human capabilities in the computational loop at different capacities, ranging from tapping knowledge from a richly heterogeneous pool of knowledge resident in the general population to soliciting expert opinions. These practices are, in general, termed human-in-the-loop (HITL) computations.

A HITL process requires holistic treatment and optimization from multiple standpoints considering all stakeholders: a. applications, b. platforms, c. humans. In application-centric optimization, the factors of interest usually are latency (how long it takes for a set of tasks to finish), cost (the monetary or computational expenses incurred in the process), and quality of the completed …

Trophish: Building A Global Database Of Freshwater Trophic Interactions, Jacob M. Ridgway

Honors Thesis

Freshwater management and research frequently use the trophic data of freshwater fishes. Despite this fact, it is difficult to perform a simple search of dietary information for any one fish species. FishBase represents, to our knowledge, the largest compilation of freshwater dietary information to date. However, it excludes a large portion of the ecological literature due to its development taking place prior to the creation of most modern scientific search engines. Our project (TroPhish) is building upon FishBase by digitizing approximately 130 years of data from the fish predation literature. Data from the primary and grey (e.g. theses, dissertations, reports) …

College Of Education Filemaker Extraction And End-User Database Development, Andrew Tran

Electronic Theses, Projects, and Dissertations

The College of Education (CoE) at the California State University San Bernardino (CSUSB) developed a system to keep track of both state and national accreditation requirements using FileMaker 5, a database system. This accreditation data is crucial for reporting and record-keeping for the CSU Chancellor’s Office as well as the State of California. However, the database system was developed several decades ago, and software support has long since been dropped, causing the CoE’s legacy accreditation data to be at risk of being lost should the software or hardware suffer permanent failure. The purpose of this project was to perform extraction …

Preprocessing Of Astronomical Images From The Neowise Survey For Near-Earth Asteroid Detection, Rachel Meyer

Scholar Week 2016 - present

Asteroid detection is a common field in astronomy for planetary defense which requires observations from survey telescopes to detect and classify different objects. The amount of data collected each night is increasing as better designed telescopes are created each year. This amount is quickly becoming unmanageable and many researchers are looking for ways to better process this data. The dominant solution is to implement computer algorithms to automatically detect these sources and to use Machine Learning in order to create a more efficient and accurate classifier. In the past there has been a focus on larger asteroids that create streaks …

Developing An Ios Game Application: Magnet Hockey, Trevor D. Wysong

The Graduate Review

Mobile application development requires mindful and meticulous planning. Application design should be responsive and intuitive so that navigation feels natural for the user. All targeted devices should be offered a relatively consistent experience. To ensure this, app performance needs to be closely monitored and different screen sizes and aspect ratios need to be considered when scaling. For an app to become attractive to many people, it should either be competitive with similar apps or be unique and interesting enough to entice people to download it. A unique app should couple familiar elements with new components or twists [8]. People are …

Law Library Blog (January 2022): Legal Beagle's Blog Archive, Roger Williams University School Of Law

Law Library Newsletters/Blog

No abstract provided.

Data Processing In A Database Management System Using Parallel Processing, Stephen Shears

Williams Honors College, Honors Research Projects

This research project will be focused on parallel processing as it is used with database management systems to process data. Specifically, the goal is to see if creating a database management system with parallel processing at the forefront of its data processing can offer enough of an efficiency increase to warrant using it against a sequential database management system and is it possible to make that system just as reliable as those databases without parallel processing. A parallel processed database will be created with a focus on monitoring its data reliability and consistency. It will then be compared to two …

The Sedimentary Geochemistry And Paleoenvironments Project, Úna C. Farrell, Rifaat Samawi, Savitha Anjanappa, Roman Klykov, Oyeleye O. Adeboye, Heda Agic, Anne Sofie C. Ahm, Thomas H. Boag, Fred Bowyer, Jochen J. Brocks, Tessa N. Brunoir, Donald E. Canfield, Xiaoyan Chen, Meng Cheng, Matthew O. Clarkson, Devon B. Cole, David R. Cordie, Peter W. Crockford, Huan Cui, Tais W. Dahl, Lucas D. Mouro, Keith Dewing, Stephen Q. Dornbos, Nadja Drabon, Julie A. Dumoulin, Joseph F. Emmings, Cecilia R. Endriga, Tiffani A. Fraser, Robert R. Gaines, Richard M. Gaschnig, Timothy M. Gibson, Geoffrey J. Gilleaudeau

Geosciences: Faculty Publications

No abstract provided.

Information Extraction And Classification On Journal Papers, Lei Yu

Department of Computer Science and Engineering: Dissertations, Theses, and Student Research

The importance of journals for diffusing the results of scientific research has increased considerably. In the digital era, Portable Document Format (PDF) became the established format of electronic journal articles. This structured form, combined with a regular and wide dissemination, spread scientific advancements easily and quickly. However, the rapidly increasing numbers of published scientific articles requires more time and effort on systematic literature reviews, searches and screens. The comprehension and extraction of useful information from the digital documents is also a challenging task, due to the complex structure of PDF.

To help a soil science team from the United States …

Enhancing Usability And Explainability Of Data Systems, Anna Fariha

Doctoral Dissertations

The recent growth of data science expanded its reach to an ever-growing user base of nonexperts, increasing the need for usability, understandability, and explainability in these systems. Enhancing usability makes data systems accessible to people with different skills and backgrounds alike, leading to democratization of data systems. Furthermore, proper understanding of data and data-driven systems is necessary for the users to trust the function of the systems that learn from data. Finally, data systems should be transparent: when a data system behaves unexpectedly or malfunctions, the users deserve proper explanation of what caused the observed incident. Unfortunately, …

Using Methanol Masers To Probe High Mass Star Forming Regions, Naomi S. Shechter, Anuj P. Sarma

DePaul Discoveries

Compared to low mass stars, the formation of high mass stars is not well understood. To understand better how high mass stars form, we can utilize masers, naturally amplified point sources of microwave radiation. One example is the methanol maser, which falls into two categories. Class I methanol masers form in the bipolar outflows from the protostar, and Class II masers form in the accretion disk. Their compact size and intensity make them an excellent source of information about the process of high mass star formation. We compiled a modest database of Class I and II methanol masers through a …

Multilateration Index., Chip Lynch

Electronic Theses and Dissertations

We present an alternative method for pre-processing and storing point data, particularly for Geospatial points, by storing multilateration distances to fixed points rather than coordinates such as Latitude and Longitude. We explore the use of this data to improve query performance for some distance related queries such as nearest neighbor and query-within-radius (i.e. “find all points in a set P within distance d of query point q”). Further, we discuss the problem of “Network Adequacy” common to medical and communications businesses, to analyze questions such as “are at least 90% of patients living within 50 miles of a covered emergency …

Plug-And-Play Sql, Shubham Swami

All Graduate Theses and Dissertations, Spring 1920 to Summer 2023

We present an efficient model to retrieve data from a database by implementing plug-and-play queries using the query guards. The model is efficient in the sense that it saves time when writing a query and promotes query portability and reuse. A plug-and-play query is a freestanding query that can couple to any data socket and self determine whether it can be evaluated reliably on the data. We use hierarchies to improve SQL querying in a way that eliminates the need to write a view to construct virtual tables or a set of tables to run a query. The hierarchy is …

Metaxmorph: Hierarchical Transformation Of Data With Metadata, Shubham Airan

All Graduate Theses and Dissertations, Spring 1920 to Summer 2023

This research is about transforming data. Data comes in different shapes; it can be structured as a graph, a tree, a collection of tables, or some other shape. In this thesis, we focus on data structured as a tree, which is known as hierarchical data. The same data could be structured in many different tree shapes. Previously it was shown how to transform data from one tree shape, one hierarchy to another without losing any information. But sometimes the pieces of the hierarchy are annotated or associated with metadata, that is, with data about the data itself. The metadata can …

Using Big Data Analytics To Optimize Practical Large Databases, Po-Chun Lu

Master of Science in Computer Science Theses

Big data analytics is gaining popularity for enterprises in optimizing their business processes ranging from retailers, supply chains, to online shopping stores. Existing practical raw data are far from usable to achieve the goal. Therefore, a good data pre-processing approach is required and is a key step to success. We propose to research on the effectiveness of data pre-processing and the business process based on a real world database. Our methodology involves natural language processing. Our key goal is to study appropriate methods with big data analysis techniques that can handle errors, ambiguity, and repeated descriptions caused by human languages. …

Beyond Streamflow: Call For A National Data Repository Of Streamflow Presence For Streams And Rivers In The United States, Kendra E. Kaiser

Geosciences Faculty Publications and Presentations

Observations of the presence or absence of surface water in streams are useful for characterizing streamflow permanence, which includes the frequency, duration, and spatial extent of surface flow in streams and rivers. Such data are particularly valuable for headwater streams, which comprise the vast majority of channel length in stream networks, are often non-perennial, and are frequently the most data deficient. Datasets of surface water presence exist across multiple data collection groups in the United States but are not well aligned for easy integration. Given the value of these data, a unified approach for organizing information on surface water presence …

Accelerating Aggregation Efficiency: Using Postgres As A Cache With Mongodb, Mason Q. Porter-Brown

Senior Projects Fall 2021

For decades now relational databases, namely SQL, have been the industry standard. However, recently MongoDB and other NoSQL databases have been growing in popularity due to their flexibility and scalability. SQL still has the upper hand in a variety of areas, including data consistency, advanced and established analytics functions, and efficient “JOIN” functions. This project focuses on MongoDB’s shortcomings when it comes to replicating “JOIN” operations using MongoDB’s aggregate functions. “JOIN” operations refer to the action of comparing data from one or more collections of data and joining similar data together in order to analyze and draw statistics from the …

Football’S Future: An Analytical Interpretation Of The Premier League, Hunter Witeof

Williams Honors College, Honors Research Projects

This project looks to take the statistics of soccer players and run them through an algorithm to determine how well a player is performing. The system that will be designed in the project will look to accomplish 3 main goals: allow the user to enter new statistics, store the data for all 38 game weeks for all 20 teams, and compute a score for each player’s performance for each game as well as the average of all of the player's scores.

A Deductive Database For Knot Colourings, Dong Hyun Han

Senior Projects Spring 2021

This work constitutes progress toward the development of a knowledge base for braids, knots, and their colourings. The main result of this development is the creation of a logical model for storing data pertaining to braids, two-dimensional projections of three dimensional knots, finite quandles, and colorings of braids and knots by quandles. It uses the Entity Relationship data reference model as its starting point and makes the original design there. In addition, it includes a conversion of the Entity Relationship Diagram (ERD) to SQL queries that define tables corresponding to the ERD entity sets. Finally this work demonstrates how to …