Database As A Tool For Hospitality Management

In his discussion - Database As A Tool For Hospitality Management - William O'Brien, Assistant Professor, School of Hospitality Management at Florida International University, O’Brien offers at the outset, “Database systems offer sweeping possibilities for better management of information in the hospitality industry. The author discusses what such systems are capable of accomplishing.” The author opens with a bit of background on database system development, which also lends an impression as to the complexion of the rest of the article; uh, it’s a shade technical. “In early 1981, Ashton-Tate introduced dBase 11. It was the first microcomputer database management processor to offer relational capabilities and a user-friendly query system combined with a fast, convenient report writer,” O’Brien informs. “When 16-bit microcomputers such as the IBM PC series were introduced late the following year, more powerful database products followed: dBase 111, Friday!, and Framework. The effect on the entire business community, and the hospitality industry in particular, has been remarkable”, he further offers with his informed outlook. Professor O’Brien offers a few anecdotal situations to illustrate how much a comprehensive data-base system means to a hospitality operation, especially when billing is involved. Although attitudes about computer systems, as well as the systems themselves have changed since this article was written, there is pertinent, fundamental information to be gleaned. In regards to the digression of the personal touch when a customer is engaged with a computer system, O’Brien says, “A modern data processing system should not force an employee to treat valued customers as numbers…” He also cautions, “Any computer system that decreases the availability of the personal touch is simply unacceptable.” In a system’s ability to process information, O’Brien suggests that in the past businesses were so enamored with just having an automated system that they failed to take full advantage of its capabilities. O’Brien says that a lot of savings, in time and money, went un-noticed and/or under-appreciated. Today, everyone has an integrated system, and the wise business manager is the business manager who takes full advantage of all his resources. O’Brien invokes the 80/20 rule, and offers, “…the last 20 percent of results costs 80 percent of the effort. But times have changed. Everyone is automating data management, so that last 20 percent that could be ignored a short time ago represents a significant competitive differential.” The evolution of data systems takes center stage for much of the article; pitfalls also emerge.

XML storage and retrieval using the semantic binary object -oriented database system (SEM-ODB)

Over the past five years, XML has been embraced by both the research and industrial community due to its promising prospects as a new data representation and exchange format on the Internet. The widespread popularity of XML creates an increasing need to store XML data in persistent storage systems and to enable sophisticated XML queries over the data. The currently available approaches to addressing the XML storage and retrieval issue have the limitations of either being not mature enough (e.g. native approaches) or causing inflexibility, a lot of fragmentation and excessive join operations (e.g. non-native approaches such as the relational database approach). ^ In this dissertation, I studied the issue of storing and retrieving XML data using the Semantic Binary Object-Oriented Database System (Sem-ODB) to leverage the advanced Sem-ODB technology with the emerging XML data model. First, a meta-schema based approach was implemented to address the data model mismatch issue that is inherent in the non-native approaches. The meta-schema based approach captures the meta-data of both Document Type Definitions (DTDs) and Sem-ODB Semantic Schemas, thus enables a dynamic and flexible mapping scheme. Second, a formal framework was presented to ensure precise and concise mappings. In this framework, both schemas and the conversions between them are formally defined and described. Third, after major features of an XML query language, XQuery, were analyzed, a high-level XQuery to Semantic SQL (Sem-SQL) query translation scheme was described. This translation scheme takes advantage of the navigation-oriented query paradigm of the Sem-SQL, thus avoids the excessive join problem of relational approaches. Finally, the modeling capability of the Semantic Binary Object-Oriented Data Model (Sem-ODM) was explored from the perspective of conceptually modeling an XML Schema using a Semantic Schema. ^ It was revealed that the advanced features of the Sem-ODB, such as multi-valued attributes, surrogates, the navigation-oriented query paradigm, among others, are indeed beneficial in coping with the XML storage and retrieval issue using a non-XML approach. Furthermore, extensions to the Sem-ODB to make it work more effectively with XML data were also proposed. ^

Integration and querying of heterogeneous, autonomous, distributed database systems

Today, databases have become an integral part of information systems. In the past two decades, we have seen different database systems being developed independently and used in different applications domains. Today's interconnected networks and advanced applications, such as data warehousing, data mining & knowledge discovery and intelligent data access to information on the Web, have created a need for integrated access to such heterogeneous, autonomous, distributed database systems. Heterogeneous/multidatabase research has focused on this issue resulting in many different approaches. However, a single, generally accepted methodology in academia or industry has not emerged providing ubiquitous intelligent data access from heterogeneous, autonomous, distributed information sources. This thesis describes a heterogeneous database system being developed at Highperformance Database Research Center (HPDRC). A major impediment to ubiquitous deployment of multidatabase technology is the difficulty in resolving semantic heterogeneity. That is, identifying related information sources for integration and querying purposes. Our approach considers the semantics of the meta-data constructs in resolving this issue. The major contributions of the thesis work include: (i.) providing a scalable, easy-to-implement architecture for developing a heterogeneous multidatabase system, utilizing Semantic Binary Object-oriented Data Model (Sem-ODM) and Semantic SQL query language to capture the semantics of the data sources being integrated and to provide an easy-to-use query facility; (ii.) a methodology for semantic heterogeneity resolution by investigating into the extents of the meta-data constructs of component schemas. This methodology is shown to be correct, complete and unambiguous; (iii.) a semi-automated technique for identifying semantic relations, which is the basis of semantic knowledge for integration and querying, using shared ontologies for context-mediation; (iv.) resolutions for schematic conflicts and a language for defining global views from a set of component Sem-ODM schemas; (v.) design of a knowledge base for storing and manipulating meta-data and knowledge acquired during the integration process. This knowledge base acts as the interface between integration and query processing modules; (vi.) techniques for Semantic SQL query processing and optimization based on semantic knowledge in a heterogeneous database environment; and (vii.) a framework for intelligent computing and communication on the Internet applying the concepts of our work.

Design and Development of Geographical Information System (GIS) Map for Nuclear Waste Streams

A nuclear waste stream is the complete flow of waste material from origin to treatment facility to final disposal. The objective of this study was to design and develop a Geographic Information Systems (GIS) module using Google Application Programming Interface (API) for better visualization of nuclear waste streams that will identify and display various nuclear waste stream parameters. A proper display of parameters would enable managers at Department of Energy waste sites to visualize information for proper planning of waste transport. The study also developed an algorithm using quadratic Bézier curve to make the map more understandable and usable. Microsoft Visual Studio 2012 and Microsoft SQL Server 2012 were used for the implementation of the project. The study has shown that the combination of several technologies can successfully provide dynamic mapping functionality. Future work should explore various Google Maps API functionalities to further enhance the visualization of nuclear waste streams.

Étude des méthodes de saisie informatique relatives au forage de données appliquées à la prise de décision en urbanisme

Mémoire numérisé par la Direction des bibliothèques de l'Université de Montréal.

Controlo e avaliação das características antropométricas e capacidades físicas: caracterização ao longo de uma época desportiva e desenvolvimento de uma plataforma para avaliação

Os objetivos do presente estudo foram: (i) analisar a evolução das características antropométricas e capacidades físicas ao longo de uma época desportiva (comparação entre sub-15, sub-17 e sub-19) e (ii) desenvolver uma plataforma informática para auxiliar o controlo e avaliação. No primeiro trabalho a amostra foi constituída por um total de 50 jogadores portugueses de elite Sub-15 (idade de 14.0 ± 0.1 anos; n=16), Sub-17 (idade de 15.6 ± 0.5 anos; n=14) e Sub-19 (idade de 17.2 ± 0.7 anos; n=20) e foram controlados em três (3) momentos de avaliação; após o período de preparação geral (avaliação pré época), após a 1ª fase do quadro competitivo (avaliação meio época) e após a 2ª fase do quadro competitivo (avaliação pós época). Para a análise antropométrica foi avaliada a altura, massa corporal, índice de massa corporal, massa muscular, massa gorda e perímetros do bicípite, tronco, abdómen, coxa e perna. Para a análise da capacidade física foi avaliada a resistência aeróbia, o trabalho desenvolvido pelos membros inferiores durante o salto vertical, a potência dos membros inferiores durante a corrida, a agilidade e a flexibilidade. Para as características antropométricas encontrou-se para os três (3) escalões um aumento na massa corporal e uma estabilização da massa gorda explicado pelo aumento da massa muscular. As capacidades físicas melhoraram para os três (3) escalões principalmente da avaliação da pré época para o meio da época existindo uma estagnação do meio da época para o final da época. Tendo por base o tempo despendido e a logística necessária aquando da recolha de dados para o primeiro trabalho, desenvolveu-se uma plataforma de forma a auxiliar e simplificar todo o processo. Utilizou-se o software Visual Studio 2013 da Microsoft® sendo usada a linguagem programática vb.net com auxílio a uma base de dados em SQL. Foi definido um diagrama lógico para agilização dos diferentes exercícios com a base de dados no qual se incluiu os testes de agilidade, resistência, flexibilidade, velocidade, altura de salto e análise antropométrica. O entendimento das variações existentes ao longo de uma época desportiva de acordo com o quadro competitivo de cada equipa, as suas idades de desenvolvimento e a inclusão das novas tecnologias para auxiliar o complexo processo de treino, podem contribuir como uma ferramenta fundamental na avaliação e controlo do treino desportivo.

Étude des méthodes de saisie informatique relatives au forage de données appliquées à la prise de décision en urbanisme

Mémoire numérisé par la Direction des bibliothèques de l'Université de Montréal.

IMPROVING THE PERFORMANCE OF DATABASE-CENTRIC APPLICATIONS THROUGH PROGRAM ANALYSIS

Modern software applications are becoming more dependent on database management systems (DBMSs). DBMSs are usually used as black boxes by software developers. For example, Object-Relational Mapping (ORM) is one of the most popular database abstraction approaches that developers use nowadays. Using ORM, objects in Object-Oriented languages are mapped to records in the database, and object manipulations are automatically translated to SQL queries. As a result of such conceptual abstraction, developers do not need deep knowledge of databases; however, all too often this abstraction leads to inefficient and incorrect database access code. Thus, this thesis proposes a series of approaches to improve the performance of database-centric software applications that are implemented using ORM. Our approaches focus on troubleshooting and detecting inefficient (i.e., performance problems) database accesses in the source code, and we rank the detected problems based on their severity. We first conduct an empirical study on the maintenance of ORM code in both open source and industrial applications. We find that ORM performance-related configurations are rarely tuned in practice, and there is a need for tools that can help improve/tune the performance of ORM-based applications. Thus, we propose approaches along two dimensions to help developers improve the performance of ORM-based applications: 1) helping developers write more performant ORM code; and 2) helping developers configure ORM configurations. To provide tooling support to developers, we first propose static analysis approaches to detect performance anti-patterns in the source code. We automatically rank the detected anti-pattern instances according to their performance impacts. Our study finds that by resolving the detected anti-patterns, the application performance can be improved by 34% on average. We then discuss our experience and lessons learned when integrating our anti-pattern detection tool into industrial practice. We hope our experience can help improve the industrial adoption of future research tools. However, as static analysis approaches are prone to false positives and lack runtime information, we also propose dynamic analysis approaches to further help developers improve the performance of their database access code. We propose automated approaches to detect redundant data access anti-patterns in the database access code, and our study finds that resolving such redundant data access anti-patterns can improve application performance by an average of 17%. Finally, we propose an automated approach to tune performance-related ORM configurations using both static and dynamic analysis. Our study shows that our approach can help improve application throughput by 27--138%. Through our case studies on real-world applications, we show that all of our proposed approaches can provide valuable support to developers and help improve application performance significantly.

Mobil individanpassad realtidsinformation i kollektivtrafiken : En fallstudie på Tågkompaniet

The total traveling with different types of transportation has increased drastically since the 50´s. Despite this increase, the use of the public transportation has decreased in percentage which has its explanation in the overall increased use of cars as transportation. Many researchers believes that better traffic information in the public transport can lead to increased use. Therefore this study aims to investigate how mobile personalized real-time information can increase customer satisfaction in the public transport in order to maintain and attract more travelers. The study addresses the problem through a case study at the Swedish transit agency Tågkompaniet, where customers and staff are studied in order to map the present situation regarding information in the public transport. The case study also sets out to investigate which type of real-time information that is considered to be most important for the travelers. At last the study also investigate which types of technical solutions that is needed, and how the needs of travelers can be considered to be able to offer mobile personalized real-time information. The findings are that there is a dissatisfaction regarding the transit information among both travelers and staff, and that their needs and demands must be met to a greater extent in order to increase the customer satisfaction. Furthermore, the findings are also that information attributes regarding delays and disruptions in the public transport is considered to be most important by travelers. Functions such as subscribe to information, push notifications and information associated with the transit ticket are necessary to be able to provide travelers with mobile personalized real-time information. Lastly the study provides a tool to consider traveler needs in development and evaluation of mobile personalized information systems within the public transport.

Värdering av kriterier vid stora investeringar : En jämförelse mellan olika intressenters uppskattningar av kriterier

In what way does different stakeholders assess a decision and its consequences, and how do these assessments differ? When a company stands before a big decision, they need to consider aspects that are economic, ecologic and social. To make a good decision they need to consider the society and its different stakeholder groups. This study examined how different groups values and weights different criteria. The study has been done with the project Sundsvall logistics park as a case, with criteria related to that project. The goal of the study was to find a way to value and weight different criteria and then compare how the company and the stakeholders assesses these criteria. This has been done through interviews with relevant people that has got extra knowledge about the project Sundsvall logistics park, and through a survey that has been sent out to residents of Sundsvall. The informants and respondents got to assess values and weights to the criteria relative to an indirect alternative where the logistics park isn’t built. The data was then compiled using multi attribute utility theory as a tool to present the comparison. The result of the study suggests that the differences between the valuations and weightings of the criteria is partly due to an uncertainty in how the logistics park would affect the criteria, but that the biggest reason probably depends on what perspective the person is viewing the logistics park from. If the person is viewing the logistics park from an industrial perspective, the criteria related to industrial development is getting more important and is going to take up more room in the analysis. If the person is viewing the logistics park from an individual and social perspective, the criteria related to that is more important and takes up more room in the analysis.

Lärplattor i matematikundervisningen : En intervjustudie med lärare inom f-3

I och med att det nu finns teknologi som kan ta oss bortom de gränser som våra biologiska förutsättningar sätter uppstod en nyfikenhet för mig kring digitala verktyg i matematikundervisningen. Denna studie riktar sig mot lärare och på användandet av lärplattor i matematikundervisningen. Metoden som användes i undersökningen var en kvalitativ forskningsinriktning med intervjuer av lärare arbetandes inom åldrarna f-3. Fem stycken lärare på fem olika skolor inom Sundsvalls kommun intervjuades. Studien kommer fram till att lärare ser positivt på användandet av lärplattor i matematikundervisningen. Resultatet visar att de intervjuade lärarna anser att det bland annat är viktigt att lärare använder sig av ett tydligt arbetssätt som innehar ett syfte så att elever förstår lärplattornas roll i klassrummet. Lärarna ser att det finns en rad olika för- och nackdelar med lärplattor i matematikundervisningen. Exempelvis menar lärarna att lärplattor bidrar till ett lustfyllt lärande där elever får färdighetsträning och begreppsförståelse. En annan positiv aspekt var att lärarna menade att eleverna får träna samarbetsförmågan när barnen kommunicerar med varandra kring aktiviteterna med lärplattan. Nackdelarna kunde enligt lärarna vara att nätet krånglar, att lärplattor används till fel saker av eleverna, samt att elever inte ser lärplattan som ett undervisningsverktyg utan som en spelkonsol. Vidare upptäcktes en skillnad huruvida i vilken omfattning lärplattor användes utav de intervjuade lärarna. Två av fem lärare använde lärplattan som ett kontinuerligt förekommande hjälpmedel i matematikundervisningen, medan de tre resterande lärarna använde lärplattan som ett komplement.

Sean Banan och Frost-Elsa sjunger sig in i förskolan : En kvalitativ studie om hur förskollärare resonerar kring populärmusikens betydelse för barn gällande lärande och identitetsskapande.

Vårt syfte är att få syn på hur förskollärare resonerar kring populärmusikens betydelse för barn gällande lärande och identitetsskapande. Vi har valt att utgå ifrån förskollärares perspektiv på fenomenet. Som metod valde vi att göra en kvalitativ studie där vi intervjuade förskollärare från olika slumpmässigt utvalda förskolor. Det insamlade materialet har vi analyserat med hjälp av ett sociokulturellt perspektiv. Studiens resultat visar på att förskollärarna anser att populärmusiken har en stor betydelse för barnet som lärande och identitetsskapande. Den spelar enligt förskollärarna en betydelsefull roll i skapandet av sociala möten i förskolan. Även populärmusikens möjligheter som pedagogiskt redskap lyftes fram i intervjuerna. Slutligen diskuterades populärmusiken som ett verktyg i arbetet med normer och värderingar i förskolan.

MatteLEKtion : En studie i fem lärares tankar om att använda lek vid matematikundervisning utanför matematikboken

Syftet med min studie var att undersöka hur leken används som verktyg i matematikundervisningen och hur fem lärare ser på lekens roll i den tidiga matematikinlärningen. Jag har även tittat på hur leken har förändrats genom tiderna och tagit del av aktuell forskning som behandlar lek och matematikundervisning.   Jag har kommit fram till att styrd lek används i den tidiga matematik-undervisningen med goda resultat. Däremot finns det ett flertal faktorer att ta hänsyn till där val av läromedel, elevgrupp, lärarens arbetssituation samt tillgång till resurser påverkar hur fördelningen sker mellan bokstyrda matematiklektioner och lektioner utanför matematikboken. Styrd lek som verktyg i matematikundervisningen är överlag mer förekommande i de tidiga åren i skolan men ersätts av laborationer och elektroniska hjälpmedel som till exempel IPad för färdighetsträning allt eftersom eleverna blir äldre. 

Fysisk aktivitet påverkar elevers skolresultat : Möjligt samband mellan elevers fysiska aktivitet och deras skolresultat

Uppsatsens syfte var att analysera och tolka tidigare forskning om elevers fysiska aktivitet kan bidra till förbättrat skolresultat. Med hjälp av systematisk litteratursökning tolkades tidigare forskningsresultat för att hitta eventuellt samband mellan fysisk aktivitet och förbättrat skolresultat. 39 av 700 artiklar plockades ut som granskades och djupare analyserades, där 8 artiklar slutligen ansågs vara mest relevant för den här litteraturstudien. Analyserade forskningsartiklar anses visa resultat på att fysisk aktivitet påverkar elevers skolresultat. Resultatet visade att fysisk aktivitet är en faktor som troligen påverkar elevers skolresultat med neutralt eller positivt utfall. Få indikationer visade på negativa associationer mellan fysisk aktivitet och skolresultat. Analyserat och tolkat forskningsresultat visar att fysisk aktivitet kan vara ett viktigt verktyg till att förbättra elevers skolresultat genom förbättrat provresultat och betyg, där mest positiva förbättringar sker inom matematik och engelska.

Musik som en omvårdnadsåtgärd i det dagliga livet för omvårdnad av personer med demenssjukdom : En litteraturstudie

Musik som verktyg för att lindra oro och stress är en tilltalande omvårdnadsåtgärd då den kan anpassas direkt till individen. Den är utan biverkningar samt kostnadseffektiv. Syfte: Att undersöka effekten av musikåtgärder i omvårdnad av personer med demenssjukdom. Metod: Föreliggande studie är en litteraturstudie omfattande båda kvantitativa och kvalitativa studier från databaserna Web of Science, PubMed och CINAHL. 13 artiklar skrivna på engelska utgjorde resultatunderlaget. Resultat: Resultatet är baserat på empiriska studier varav tio stycken var kvantativa studier och två stycken var kvalitativa studier. Resultatet redovisas under sammanlagt fyra teman: Musik och minskning av agitation, Musik och förbättring av kognition, Musik och ökning av välbefinnande samt Musik och höjning av socialt engagemang. Slutsats: Musik som en omvårdnadsåtgärd av personer med demenssjukdom kan med fördel användas av sjuksköterskor som ett moment i den personcentrerade omvårdnaden, som underhållning samt som ett medel att knyta samman människor.