Open Access. Powered by Scholars. Published by Universities.®
Articles 1 - 24 of 24
Full-Text Articles in Entire DC Network
Evaluation Of Sql Performance Tuning Features In Oracle Database Software, Katarzyna Marta Dobies
Evaluation Of Sql Performance Tuning Features In Oracle Database Software, Katarzyna Marta Dobies
Regis University Student Publications (comprehensive collection)
Timely access to data is one of the most important requirements of database management systems. Having access to data in acceptable time is crucial for efficient decision making. Tuning inefficient SQL is one of the most important elements of enhancing performance of databases. With growing repositories and complexity of underlying data management systems, maintaining decent levels of performance and tuning has become a complicated task. DBMS providers acknowledge this tendency and developed tools and features that simplify the process. DBAs and developers have to make use of these tools in the attempt to provide their companies with stable and efficient …
Oracle Cost Based Optimizer Correlations, Robert Apple
Oracle Cost Based Optimizer Correlations, Robert Apple
Regis University Student Publications (comprehensive collection)
Database systems use optimizers on queries to select execution pathways that are supposed to provide optimal performance. The Oracle database version of this technology is called the Cost Based Optimizer (CBO). Researchers have studied whether Oracle optimizer estimates could be correlated to execution speeds with a high degree of confidence, but have found that correlating optimizer cost estimates with actual execution speed to be problematic and unreliable. If possible, however, such correlations would be helpful to developers who are tasked with query creation and optimization. Although much has been written on databases, the academic literature on optimizers was sparse. To …
A Study Of Mongodb And Oracle In An E-Commerce Environment, Aaron Ploetz
A Study Of Mongodb And Oracle In An E-Commerce Environment, Aaron Ploetz
Regis University Student Publications (comprehensive collection)
As worldwide e-commerce expands, businesses continue to look for better ways to meet their evolving needs with web solutions that scale and perform adequately. Several online retailers have been able to address scaling challenges through the implementation of NoSQL databases. While architecturally different from their relational database counterparts, NoSQL databases typically achieve performance gains by relaxing one or more of the essential transaction processing attributes of atomicity, consistency, isolation, and durability (ACID). As with any emerging technology, there are both critics and supporters of NoSQL databases. The detractors claim that NoSQL is not safe and is at a greater risk …
Development Of An Api As A Solution To Data Insularity Amongst Dietary-Need Applications, Raphael Lapuma
Development Of An Api As A Solution To Data Insularity Amongst Dietary-Need Applications, Raphael Lapuma
Regis University Student Publications (comprehensive collection)
When multiple competing applications in the same field use only their own sets of user-generated review data and do not collaborate with other applications, data is used in isolation. This factor, which the author will refer to as "data insularity," segregates each application's community of users from other applications' communities, thus creating a limited and fragmented set of data, which discourages the creation of new applications in the industry, and adversely affects the end user. This study will propose a prototype API for applications in the restaurant industry as a solution to the limited and insular use of data amongst …
Agile And Evm For The Dod: A Review Of The Challenges And A New Approach To Solve Them, Roberta Winterowd
Agile And Evm For The Dod: A Review Of The Challenges And A New Approach To Solve Them, Roberta Winterowd
Regis University Student Publications (comprehensive collection)
Department of Defense (DoD) acquisitions must improve program performance while working within budgetary constraints. The DoD community shows an interest in utilizing Agile methodologies, but struggles to reap Agile's benefits. They encountered challenges including the historically built up processes that enforce heavy-weight oversight; the outdated, manufacturing focused Work Breakdown Structures (WBS) provided in DoD Handbook: Work Breakdown Structures (WBS) for Defense Material Items (MIL-STD-881C); and the inability of the traditional waterfall based processes to accommodate iterative development. The author used the scientific method to review the documented issues encountered when using Agile on a DoD program within the constraints of …
Software Requirements As Executable Code, Karen Eileen Wasielewski Morand
Software Requirements As Executable Code, Karen Eileen Wasielewski Morand
Regis University Student Publications (comprehensive collection)
This project analyzed the effectiveness of using Story Testing frameworks to create an application directly from user specifications. It did this by taking an example business application with "traditional" specifications and rewriting those specifications in three different Story Testing Frameworks - Cucumber, FitNesse, and JBehave. Analysis of results drew the following conclusions: 1) Story Testing can help prove a project's completeness, 2) Specifications are still too technical, 3) Implementation is not overly complex, and 4) Story Testing is worth it. It proposed future research around evaluating natural languages and seeking more user-friendly ways of writing specifications in a natural language.
Data Integration: A Case Study In The Financial Services Industry, Louis Epie
Data Integration: A Case Study In The Financial Services Industry, Louis Epie
Regis University Student Publications (comprehensive collection)
Current economic conditions result in banks participating in multiple mergers and acquisitions. This results in banks inheriting silo and heterogeneous systems. For banks to remain competitive, they must create a strategy to integrate data from these acquired systems in a dynamic, efficient, and consumable manner. This research considers a case study of a large financial services company that has successfully integrated data from different sources. In addition this research investigates endeavors that experts in the field have undertaken to develop architectures that address the problems with data integration and appropriate solutions.
A Guide To Documenting Software Design For Maximum Software Portability For Software Defined Radios, Joseph Snively
A Guide To Documenting Software Design For Maximum Software Portability For Software Defined Radios, Joseph Snively
Regis University Student Publications (comprehensive collection)
The use of software defined communications systems is growing incredibly fast. The field of software engineering as a discipline has not adequately addressed the subject of software portability which makes large and costly software development efforts less ready to port to future platforms. By understanding the causes of portability problems, they can either be avoided altogether in development or very well documented so that they are easier to overcome in future efforts. Literature, case studies, and surveys are used to collect opinions and information about large software programs where portability is a desirable characteristic in order to best establish the …
Extended Bridge Software Design Pattern, Andrew J. Haigh
Extended Bridge Software Design Pattern, Andrew J. Haigh
Regis University Student Publications (comprehensive collection)
Software engineers are taught that they should separate form and function. This allows a user interface or front-end to be designed and implemented independently of the engine or back-end. Using an abstracted interface class provides the opportunity to develop different user interfaces for the same back-end, as each new user interface will all be derived from this agreed upon abstracted interface. Using the Bridge pattern allows the user to also decouple the abstraction from its implementation, providing additional flexibility as they developed multiple user interfaces. However, user interfaces are typically designed as a single unit, the renderer, even the Bridge …
Introduction Of Key Performance Indicators To The Dynamics Of Planned Change: A Modern Study, Tommy Wells
Introduction Of Key Performance Indicators To The Dynamics Of Planned Change: A Modern Study, Tommy Wells
Regis University Student Publications (comprehensive collection)
A private High Technology firm whose headquarters are located in the Midwest has just completed several upgrades to replace an in-house legacy application system in which the primary use was to track defects of the firm's custom made software. The firm's implementation of a third party's software suite to replace the in-house legacy application was studied using a case study method, which implemented key performance indicators to the change theory called "The Dynamics of Planned Change" introduced by Lippitt, Watson, and Westley. The key performance indicators were introduced as a way to determine if the firm's actions could be validated …
Transitioning From Relational To Nosql: A Case Study, John Mcphillips
Transitioning From Relational To Nosql: A Case Study, John Mcphillips
Regis University Student Publications (comprehensive collection)
Data storage requirements have increased dramatically in recent years due to the explosion in data volumes brought about by the Web 2.0 era. Changing priorities for database system requirements has seen NoSQL databases emerge as an alternative to relational database systems that have dominated this market for over 40 years. Web-enabled, always on applications mean availability of the database system is critically important as any downtime can translate in to unrecoverable financial loss. Cost is also hugely important in this era where credit is difficult to obtain and organizations look to get the maximum from their IT infrastructure from the …
Analysis Of Windows Cardspace Identity Management System, Thomas Hanrahan
Analysis Of Windows Cardspace Identity Management System, Thomas Hanrahan
Regis University Student Publications (comprehensive collection)
The Internet, which was originally developed for academic purposes, has expanded and been applied to commercial and business enterprises. It is possible to purchase airline tickets, check bank balances and communicate through e-mail with each other through the Internet. These services can all be performed relatively easily with the proliferation of Internet Service Providers and the lower cost of Personal Computers. The development of the Internet has also had a huge impact on businesses with the growth of e-commerce, e-banking and the tremendous growth in email traffic. There is however a negative impact to this development of the Internet with …
Automated Database Refresh In Very Large And Highly Replicated Environments, Eric King
Automated Database Refresh In Very Large And Highly Replicated Environments, Eric King
Regis University Student Publications (comprehensive collection)
Refreshing non-production database environments is a fundamental activity. A non-productive environment must closely and approximately be related to the productive system and be populated with accurate, consistent data so that the changes before moving into the production system can be tested more effectively. Also if the development system has more related scenario as that of a live system then programming in-capabilities can be minimized. These scenarios add more pressure to get the system refreshed from the production system frequently. Also many organizations need a proven and performant solution to creating or moving data into their nonproduction environments that will neither …
A Fuzzy Logic Stock Trading System Based On Technical Analysis, Sammy Zeigenbein
A Fuzzy Logic Stock Trading System Based On Technical Analysis, Sammy Zeigenbein
Regis University Student Publications (comprehensive collection)
Technical analysis of financial markets involves analyzing past price movements in order to identify favorable trading opportunities. The objective of this research was to demonstrate that a fuzzy logic stock trading system based on technical analysis can assist average traders in becoming successful by optimizing the use of technical indicators and trading rules that experts use to identify when to buy and sell stock. Research of relevant literature explored the current state of knowledge in methodologies for developing and validating trading systems using technical indicators and fuzzy logic trading systems, providing guidelines for the development and evaluation of the system. …
Effecting Data Quality Through Data Governance: A Case Study In The Financial Services Industry, Patrick Egan
Effecting Data Quality Through Data Governance: A Case Study In The Financial Services Industry, Patrick Egan
Regis University Student Publications (comprehensive collection)
One of the most significant challenges faced by senior management today is implementing a data governance program to ensure that data is an asset to an organization's mission. New legislation aligned with continual regulatory oversight, increasing data volume growth, and the desire to improve data quality for decision making are driving forces behind data governance initiatives. Data governance involves reshaping existing processes and the way people view data along with the information technology required to create a consistent, secure and defined processes for handling the quality of an organization's data. In examining attempts to move towards making data an asset …
Test-Driven Web Application Development: Increasing The Quality Of Web Development By Providing Framework With An Emphasis On Test-Driven Design And Development Methodologies, Jason Hall
Regis University Student Publications (comprehensive collection)
Web applications , especially those based on interpreted programming languages , are quickly becoming more utilized and more commonplace than traditional client applications. Despite this growth, no open solution has yet fulfilled the need of a risk-reducing development framework that supports test-driven methodologies and tools designed to coordinate the resources responsible for the most effective development of web applications based on interpreted programming languages. This research paper presents a test-driven development framework consisting of openly available components that can be used by development teams writing web applications based on interpreted programming languages based on the methodologies and tools used by …
The Use Of Olap Reporting Technology To Improve Patient Care Services Decision Making Within The University Health Center, Carlos M. Gonzalez
The Use Of Olap Reporting Technology To Improve Patient Care Services Decision Making Within The University Health Center, Carlos M. Gonzalez
Regis University Student Publications (comprehensive collection)
The purpose of this paper is to demonstrate that it is feasible for the student health center to leverage existing clinical data in a data warehouse by using OLAP reporting in order to improve patient care and health care services decision making. Historically, University health care centers have relied mainly on operational data sources for critical health care decision making. These sources of data do not contain enough information to allow health officials to recognize trends or predict how future changes in health care services might vastly improve overall heath care. Four proof of concept artifacts are constructed through design …
Databases In Courts: The Kenyan Experience, Samwel Otieno Oyuuh
Databases In Courts: The Kenyan Experience, Samwel Otieno Oyuuh
Regis University Student Publications (comprehensive collection)
One of the most significant challenges faced by courts today is managing the performance of their case management system to meet growing case loads efficiently and effectively. There are many different types of technology to help in developing an electronic courtroom, but the underlying technology is the database. Databases are used by courts for maintaining case records, personnel and other court management data. But many conditions such as training and technological infrastructure need to be in place to support successful systems. This work presents the results of a survey of case management operations and practices in Kenya. Current state of …
Realizing The Technical Advantages Of Star Transformation, Karen L. Darling
Realizing The Technical Advantages Of Star Transformation, Karen L. Darling
Regis University Student Publications (comprehensive collection)
Data warehousing and business intelligence go hand in hand, each gives the other purpose for development, maintenance and improvement. Both have evolved over a few decades and build upon initial development. Management initiatives further drive the need and complexity of business intelligence, while in turn expanding the end user community so that business change, results and strategy are affected at the business unit level. The literature, including a recent business intelligence user survey, demonstrates that query performance is the most significant issue encountered. Oracle's data warehouse 10g.2 is examined with improvements to query optimization via "best practice" through Star Transformation. …
Creation And Implementation Of An It Governance Compliant It Asset Management Framework For Wexford County Council, Alan O'Rourke
Creation And Implementation Of An It Governance Compliant It Asset Management Framework For Wexford County Council, Alan O'Rourke
Regis University Student Publications (comprehensive collection)
IT Governance has evolved from Corporate Governance over time as a means to enforce security and control over information systems and put in place best practices for organisations. There are accredited standards, such as ISO, CobiT, and Information Technology Infrastructure Library (ITIL) to help organisations create, and conform to best practices for information technology security. Currently there is very little IT asset governance specific literature. This study was conducted to research best practices for IT asset management, and proposes a set of guidelines for Wexford County Council to implement for IT asset management. This study also proposes how to physically …
Designing And Implementing A Distributed Database For A Small Multi-Outlet Business, Joseph Grech
Designing And Implementing A Distributed Database For A Small Multi-Outlet Business, Joseph Grech
Regis University Student Publications (comprehensive collection)
Data is a fundamental and necessary element for businesses. During their operations they generate a certain amount of data that they need to capture, store, and later on retrieve when required. Databases provide the means to store and effectively retrieve data. Such a database can help a business improve its services, be more competitive, and ultimately increase its profits. In this paper, the system requirements of a distributed database are researched for a movie rental and sale store that has at least two outlets in different locations besides the main one. This project investigates the different stages of such a …
Runtime Automated Detection Of Out Of Process Resource Management In The X Windowing System, Caolan Mcnamara
Runtime Automated Detection Of Out Of Process Resource Management In The X Windowing System, Caolan Mcnamara
Regis University Student Publications (comprehensive collection)
Software applications typically allocate and deallocate resources during their lifetime. Resources can be categorized into two broad groups, in-process and out-of-process resources where in-process resources are local resources directly managed by a client, while out-of-process resources are remotely managed by a client which instructs a server to allocate and deallocate the resource on its behalf. Out-of-process resources do not reside in a clients address space which poses an extra layer of complexity in attempting to debug their misuse. This thesis presents an automatic run-time solution to the problem of detecting and reporting source code locations of application client mismanagement of …
An Investigation Into The Development Of A Practical Gis Mapping Tool Supporting Emissions Inventory Information, Elizabeth J. Davis-Noland
An Investigation Into The Development Of A Practical Gis Mapping Tool Supporting Emissions Inventory Information, Elizabeth J. Davis-Noland
Regis University Student Publications (comprehensive collection)
Environmental Protection Agency (EPA) regulations call for States to submit for EPA review and approval State Implementation Plans (SIPs) which establish goals and emission reduction strategies for improving air quality in national parks and wilderness areas. State and tribe air quality analysts therefore need the ability to display and analyze emissions inventory data in relation to geographic locations. However, due to budget and other constraints, traditional Graphical Information Systems (GIS) tools are often not available. Today, traditional GIS are being challenged in various domains by a variety of free or low-cost internet accessible services. Leveraging the availability of the Google …
Development Of A Data Acquisition System For An Ecommerce Website, Paul Hughes
Development Of A Data Acquisition System For An Ecommerce Website, Paul Hughes
Regis University Student Publications (comprehensive collection)
First Stop Sports (http://www.firststopsports.com) is a small sports collectibles and memorabilia eCommerce company, specializing in NFL and NCAA collectible football helmets and other sports memorabilia. First Stop Sports current web site has shown some inadequacies and limited capabilities with historical customer ordering information capture. "They are struggling to advance business development and increase revenue.? It is the scope of this project to investigate, design, and develop a prototype data acquisition system for First Stop Sports. This prototype would only focus on one specific product line, but it would need to have the same look, feel and functionality as the existing …