Fundamentos de las Bases de Datos. Teoría2 conceptos y ejercicios (curso 2012-2013)

La segunda hora de las sesiones de teoría se centra en el modelo relacional y tiene un carácter más práctico, de resolución de problemas de aplicación de lo anterior.

Fundamentos de las Bases de Datos. 2011C1 Exámenes finales (curso 2012-2013)

En ese curso, este examen se hizo en la última sesión de teoría por lo que se prepararon varias versiones ligeramente diferentes para cada grupo de teoría.

Fundamentos de las Bases de Datos. 2011C2 Exámenes finales (curso 2012-2013)

El examen consta de 3 partes: Test de teoría, problemas de teoría y SQL. Hay dos versiones, una para informática y otra para multimedia.

Fundamentos de las Bases de Datos. 2012C1 Examen final (curso 2012-2013)

En el curso 2011-12 este examen de problemas de aplicación de la teoría se realizó en la fecha asignada por la Universidad de Alicante y en aulas comunes para Informática y Multimedia.

Fundamentos de las Bases de Datos. 2012C2 Examen (curso 2012-2013)

Examen de segunda convocatoria del curso 2011-12. Consta de 3 partes: test y problemas de teoría, y SQL.

Fundamentos de las Bases de Datos. Presentaciones Teoría1 (curso 2012-2013)

Presentaciones de la primera hora de las sesiones de teoría (TEORÍA1).

Perspective maternelle de la consultation anténatale pour travail préterme : une approche relationnelle

Une femme à risque d’un accouchement prématuré vit un enjeu de santé très éprouvant et stressant ; elle sera souvent hospitalisée pour recevoir des traitements médicaux visant à prolonger la grossesse et améliorer le pronostic du bébé. Dans ce contexte, une consultation avec un néonatalogiste est demandée. Plusieurs associations professionnelles médicales ont émis des lignes directrices sur cette consultation, insistant sur le besoin d’informer les parents au sujet des complications potentielles de la prématurité pour leur enfant. Ces recommandations s’inspirent du point de vue médical, et très peu d’études ont examiné la perspective, les attentes et les besoins des parents à risque d’un accouchement prématuré. Ce projet de thèse a pour objectif de proposer un modèle de relation médecin-patient informé de la perspective maternelle de la consultation anténatale, pour développer une approche clinique répondant à leurs besoins. Afin d’examiner cette problématique de façon complète, un travail constant de va-et-vient a été effectué entre la recension de données empiriques et une réflexion normative bioéthique féministe. Un projet de recherche empirique a d’abord permis d’explorer les attentes et le vécu de ces femmes. Les participantes espéraient recevoir plus que de l’information sur les complications de la prématurité. Elles souhaitaient que le néonatologiste soit attentif à leur situation particulière et qu’il développe une relation de confiance avec elles, leur permettant d’explorer leurs futurs rôles de mères et les encourageant à formuler leurs propres questions. Le cadre théorique féministe d’autonomie relationnelle a ensuite permis de proposer une approche de soin qui sache répondre aux besoins identifiés par les patientes, tout en adressant des enjeux de pouvoir intrinsèques à la clinique, qui influencent la santé et l’autonomie de ces femmes. Cette approche insiste sur l’importance de la relation de soin en clinique, contrastant avec un modèle encourageant une vision réductrice de l’autonomie, dans laquelle un simple transfert de données scientifiques serait équivalent au respect de la norme médicolégale du consentement éclairé. Ce modèle relationnel propose des actions concrètes et pratiques, encourageant les cliniciens à entrer en relation avec chaque patiente et à considérer l’influence qu’ils exercent sur l’autonomie relationnelle de leurs patientes.

Leadership, self, and identity: A review and research agenda

This article reviews empirical research on the role of follower self-conception in leader-ship effectiveness. and specifies an agenda for future research in this area. The review shows that several aspects of follower self-conception (i.e., self-construal, self-efficacy, self-esteem, and self-consistency) may be affected by leadership. and may mediate the effects of leadership on follower behavior. There also is consistent evidence that follower self-construal moderates the impact of leadership on follower attitudes and behavior. Two key themes for future research are defined. First, future research should focus on the development of theory about the role of relational self-construal in the leadership process. Second, it seems particularly valuable to develop theory about the interplay of different aspects of follower self-conception in leadership effectiveness. including the interactive effects of these aspects of self Working backwards from these theoretical models of follower self-conception, specific leader behavior relevant to these aspects of self should then be identified. (C) 2004 Elsevier Inc. All rights reserved.

Selecting optimal instantiations of data models - Theory and validation of an ex ante approach

The schema of an information system can significantly impact the ability of end users to efficiently and effectively retrieve the information they need. Obtaining quickly the appropriate data increases the likelihood that an organization will make good decisions and respond adeptly to challenges. This research presents and validates a methodology for evaluating, ex ante, the relative desirability of alternative instantiations of a model of data. In contrast to prior research, each instantiation is based on a different formal theory. This research theorizes that the instantiation that yields the lowest weighted average query complexity for a representative sample of information requests is the most desirable instantiation for end-user queries. The theory was validated by an experiment that compared end-user performance using an instantiation of a data structure based on the relational model of data with performance using the corresponding instantiation of the data structure based on the object-relational model of data. Complexity was measured using three different Halstead metrics: program length, difficulty, and effort. For a representative sample of queries, the average complexity using each instantiation was calculated. As theorized, end users querying the instantiation with the lower average complexity made fewer semantic errors, i.e., were more effective at composing queries. (c) 2005 Elsevier B.V. All rights reserved.

Clustering strategies for object databases

When object databases arrived on the scene some ten years ago, they provided database capabilities for previously neglected, complex applications, such as CAD, but were burdened with one inherent teething problem, poor performance. Physical database design is one tool that can provide performance improvements and it is the general area of concern for this thesis. Clustering is one fruitful design technique which can provide improvements in performance. However, clustering in object databases has not been explored in depth and so has not been truly exploited. Further, clustering, although a physical concern, can be determined from the logical model. The object model is richer than previous models, notably the relational model, and so it is anticipated that the opportunities with respect to clustering are greater. This thesis provides a thorough analysis of object clustering strategies with a view to highlighting any links between the object logical and physical model and improving performance. This is achieved by considering all possible types of object logical model construct and the implementation of those constructs in terms of theoretical clusterings strategies to produce actual clustering arrangements. This analysis results in a greater understanding of object clustering strategies, aiding designers in the development process and providing some valuable rules of thumb to support the design process.

About Methods of Mathematical Modelling in the Development of Information Systems

This article describes the approach, which allows to develop information systems without taking into consideration details of physical storage of the relational model and type database management system. Described in terms of graph model, this approach allows to construct several algorithms, for example, for verification application domain. This theory was introduced into operation testing as a part of CASE-system METAS.

A stable graph-based representation for object recognition through high-order matching

Many Object recognition techniques perform some flavour of point pattern matching between a model and a scene. Such points are usually selected through a feature detection algorithm that is robust to a class of image transformations and a suitable descriptor is computed over them in order to get a reliable matching. Moreover, some approaches take an additional step by casting the correspondence problem into a matching between graphs defined over feature points. The motivation is that the relational model would add more discriminative power, however the overall effectiveness strongly depends on the ability to build a graph that is stable with respect to both changes in the object appearance and spatial distribution of interest points. In fact, widely used graph-based representations, have shown to suffer some limitations, especially with respect to changes in the Euclidean organization of the feature points. In this paper we introduce a technique to build relational structures over corner points that does not depend on the spatial distribution of the features. © 2012 ICPR Org Committee.

Antecedentes do engajamento em boca a boca eletrônico positivo entre turistas

This study examined the influence of the tourism destination image as well as satisfaction and motivation in the intention of engaging in a positive electronic word of mouth (eWOM) by tourists through Facebook. In addition, it was also specifically expected to assess the sociodemographic profile and frequency of eWOM publications from those who answered the questions; it also assessed the adequacy of the manifested variables for composition of the following dimensions: Quality, Satisfaction, Image, Motivations and Positive Electronic Word of Mouth (eWOM). And finally, it analyzed a relational model where there are relationships between Quality, Satisfaction, Image and Motivations in the explanation of engagement in the Positive Electronic Word of Mouth (eWOM). With this aim it was conducted a study, based on a hypothetical-deductive logic, which was descriptive in relation to its goals. The analytical approach was quantitative (a survey). The sampling procedure was non-probabilistic, by the convenience method of sampling specifically, having the choice of the subject been made through the probabilistic systematic method, and using time as a factor of systematization in an attempt of making randomly the selection of the interviewed people. The study sample consisted of 355 tourists. The used instrument to collect information was the structured questionnaire whose answers were collected in the main points of entry, exit and rides of tourists on the Pipa’s Beach/RN. Data analysis was carried out using descriptive and multivariate statistics, mainly exploratory and confirmatory factor analysis and structural equation modeling. Among the main results, it was possible to confirm that the Motivations, Satisfaction and Image strongly affect the intention of engaging in positive electronic word of mouth (eWOM). Emphasis is given to the motivations, as they demonstrate bigger impact in explaining the dependent variable; they are followed by the satisfaction and the image. The latter, however, is inversely proportional. Among the motivations, the one with the highest percentage of variance were the social benefits sought by tourists; and presenting the same percentage appears the desire to help other tourists and to vent Positive Emotions. The manifested variables demonstrate to be fully acceptable to be taken as reflexes of their respective factors.

Endowing NoSQL DBMS with SQL features through standard Call Level Interfaces

To store, update and retrieve data from database management systems (DBMS), software architects use tools, like call-level interfaces (CLI), which provide standard functionalities to interact with DBMS. However, the emerging of NoSQL paradigm, and particularly new NoSQL DBMS providers, lead to situations where some of the standard functionalities provided by CLI are not supported, very often due to their distance from the relational model or due to design constraints. As such, when a system architect needs to evolve, namely from a relational DBMS to a NoSQL DBMS, he must overcome the difficulties conveyed by the features not provided by NoSQL DBMS. Choosing the wrong NoSQL DBMS risks major issues with components requesting non-supported features. This paper focuses on how to deploy features that are not so commonly supported by NoSQL DBMS (like Stored Procedures, Transactions, Save Points and interactions with local memory structures) by implementing them in standard CLI.

Modelos, lenguajes y abstracción (ING)

Every construction process (whatever buildings, machines, software, etc.) requires first to make a model of the artifact that is going to be built. This model should be based on a paradigm or meta-model, which defines the basic modeling elements: which real world concepts can be represented, which relationships can be established among them, and son on. There also should be a language to represent, manipulate and think about that model. Usually this model should be redefined at various levels of abstraction. So both, the paradigm an the language, must have abstraction capacity. In this paper I characterize the relationships that exist between these concepts: model, language and abstraction. I also analyze some historical models, like the relational model for databases, the imperative programming model and the object oriented model. Finally, I remark the need to teach that model-driven approach to students, and even go further to higher level models, like component models o business models.