Creació de taules d'una base de dades relacional a partir del diagrama de classes d'anàlisi d'UML

És ben sabut que les úniques etapes del cicle de vida del programari que necessàriament s'han d'especificar són les de recollida de requisits i l'anàlisi o l'especificació del programari. La resta (disseny, implementació i prova) es pot generar d'una manera més o menys automàtica a partir de l'anàlisi. En aquest PFC hem volgut estudiar la viabilitat de la construcció automàtica de codi SQL a partir de diagrames de classes d'anàlisi UML. S'ha estès l'eina de modelatge UML Poseidon amb un connector, de manera que amb una interfície molt simple es pot obtenir molt ràpidament l'esquema bàsic d'una base de dades, incloent-hi les taules, les seves columnes, claus rimàries i foranes, i també els disparadors (i les claus úniques) necessaris per a garantir les restriccions de cardinalitat de les associacions.

Anàlisi, disseny i implementació d'una aplicació de consulta de equivalències entre referències OE-AM

En aquest document s'hi descriuen totes les etapes necessàries per el desenvolupament de l'aplicació: anàlisi i especificació de requisits, disseny i implementació. Detallant a cada fase les tasques i decisions presses, Aixa com els resultats obtinguts.

Gestión postventa

Proyecto final de carrera en el que una empresa, especializada en el segmento de los electrodomésticos, se ve en la necesidad de cambiar el sistema que tiene para gestionar la postventa de sus productos. Se han analizado los requerimientos del nuevo sistema, así como implementado la base de datos que satisface estos requerimientos junto con los procedimientos necesarios para la gestión que proporcionaran el único método de acceso. A parte de la gestión diaria de las incidencias, se han consolidado datos para generar estadísticas que permitan mejorar la eficiencia de la empresa.

On the use of QoS requirements as base of multicast charging

We propose a charging scheme for cost distribution along a multicast tree when cost is the responsibility of the receivers. This scheme focuses on QoS considerations and it does not depend on any specific type of service. The scheme has been designed to be used as a bridge between unicast and multicast services, solving the problem of charging multicast services by means of unicast charging and existing QoS routing mechanisms. We also include a numerical comparison and discussions of the case of non-numerical or relative QoS and on the application to some service examples in order to give a better understanding of the proposal

Resource dimensioning aspect of heterogeneous traffic with different service requirements: Integration versus segregation

In this paper, we consider the ATM networks in which the virtual path concept is implemented. The question of how to multiplex two or more diverse traffic classes while providing different quality of service requirements is a very complicated open problem. Two distinct options are available: integration and segregation. In an integration approach all the traffic from different connections are multiplexed onto one VP. This implies that the most restrictive QOS requirements must be applied to all services. Therefore, link utilization will be decreased because unnecessarily stringent QOS is provided to all connections. With the segregation approach the problem can be much simplified if different types of traffic are separated by assigning a VP with dedicated resources (buffers and links). Therefore, resources may not be efficiently utilized because no sharing of bandwidth can take place across the VP. The probability that the bandwidth required by the accepted connections exceeds the capacity of the link is evaluated with the probability of congestion (PC). Since the PC can be expressed as the CLP, we shall simply carry out bandwidth allocation using the PC. We first focus on the influence of some parameters (CLP, bit rate and burstiness) on the capacity required by a VP supporting a single traffic class using the new convolution approach. Numerical results are presented both to compare the required capacity and to observe which conditions under each approach are preferred

Refinement criteria for global illumination using convex funcions

In several computer graphics areas, a refinement criterion is often needed to decide whether to goon or to stop sampling a signal. When the sampled values are homogeneous enough, we assume thatthey represent the signal fairly well and we do not need further refinement, otherwise more samples arerequired, possibly with adaptive subdivision of the domain. For this purpose, a criterion which is verysensitive to variability is necessary. In this paper, we present a family of discrimination measures, thef-divergences, meeting this requirement. These convex functions have been well studied and successfullyapplied to image processing and several areas of engineering. Two applications to global illuminationare shown: oracles for hierarchical radiosity and criteria for adaptive refinement in ray-tracing. Weobtain significantly better results than with classic criteria, showing that f-divergences are worth furtherinvestigation in computer graphics. Also a discrimination measure based on entropy of the samples forrefinement in ray-tracing is introduced. The recursive decomposition of entropy provides us with a naturalmethod to deal with the adaptive subdivision of the sampling region

Engineering the thermal emission of macroporous silicon

Todos los cuerpos emiten luz espontaneamente al ser calentados. El espectro de radiacion es una funcion de la temperatura y el material. Sin embargo, la mayoria de los materiales irradia, en general, en una banda espectral amplia. Algunas matereiales, por el contrario, son capaces de concentrar la radiacion termica en una banda espectral mucho mas estrecha. Estos materiales se conocen como emisores selectivos y su uso tiene un profundo impacto en la eficiencia de sistemas sistemas tales como iluminacion y conversion de energia termofotovoltaica. De los emisores selectivos se espera que sean capaces de operar a altas temperaturas y que emitan en una banda espectral muy concisa. Uno de los metodos mas prometedores para controlar y disenar el espectro de emision termico es la utilizacion de cristales fotonicos. Los cristales fotonicos son estructuras periodicas artificiales capaces de controlar y confinar la luz de formas sin precedentes. Sin embargo, la produccion de dichas estructuras con grandes superficies y capaces de soportar altas temperaturas sigue siendo una dificil tarea. Este trabajo esta dedicada al estudio de las propiedades de emision termica de estructuras 3D de silicio macroporoso en el rango espectral mid-IR (2-30 m). En particular, este trabajo se enfoca en reducir la elevada emisividad del silicio cristalino. Las muestras estudiadas en este trabajo tienen una periodicidad de 4 m, lo que limitan los resultados obtenidos a la banda del infrarrojo medio, aunque estructuras mucho mas pequenas son tecnologicamente realizables con el metodo de fabricacion utilizado. Hemos demostrado que el silicio macroporoso 3D puede inhibir completamente la emision termica en su superficie. Mas aun, esta banda se puede ajustar en un amplio margen mediante pequenos cambios durante la formacion de los macroporos. Tambien hemos demostrado que tanto el ancho como la frecuencia de la banda de inhibicion se puede doblar mediante la aplicacion de tecnicas de postprocesado adecuadas. Finalmente hemos mostrado que es posible crear bandas de baja emisividad arbitrariamente anchas mediante estructuras macroporosas aperiodicas.

Adaptive business intelligence for an open negotiation environment

Engineering of negotiation model allows to develop effective heuristic for business intelligence. Digital ecosystems demand open negotiation models. To define in advance effective heuristics is not compliant with the requirement of openness. The new challenge is to develop business intelligence in advance exploiting an adaptive approach. The idea is to learn business strategy once new negotiation model rise in the e-market arena. In this paper we present how recommendation technology may be deployed in an open negotiation environment where the interaction protocol models are not known in advance. The solution we propose is delivered as part of the ONE Platform, open source software that implements a fully distributed open environment for business negotiation

Aplicació web per a gestió de pressuposts a Ncora

El projecte que s’ha presentat correspon a la titulació d’Enginyeria en Informàtica i conté diversos aspectes relacionats al desenvolupament d’una aplicació web per a gestionar els pressupostos de l’empresa Ncora. Es presenta un estudi i anàlisi de requeriments, una compra de servidors, una instal·lació i configuració dels servidors en l’entorn hardware del núvol de Ncora, un anàlisi i disseny de la base de dades i un desenvolupament a mida de l’aplicació software. L’objectiu principal del projecte és l’estalvi de temps en la creació de pressupostos i la ràpida cerca de pressupostos fets així com dels seus components.

Assessment and reuse of contents in the competence-based educational platform InterMediActor

This paper describes a failure alert system and a methodology for content reuse in a new instructional design system called InterMediActor (IMA). IMA provides an environment for instructional content design, production and reuse, and for students’ evaluation based in content specification through a hierarchical structure of competences. The student assessment process and information extraction process for content reuse are explained.

FGF signaling controls caudal hindbrain specification through Ras-ERK1/2 pathway

Background: During early steps of embryonic development the hindbrain undergoes a regionalization process along the anterior-posterior (AP) axis that leads to a metameric organization in a series of rhombomeres (r). Refinement of the AP identities within the hindbrain requires the establishment of local signaling centers, which emit signals that pattern territories in their vicinity. Previous results demonstrated that the transcription factor vHnf1 confers caudal identity to the hindbrain inducing Krox20 in r5 and MafB/Kreisler in r5 and r6, through FGF signaling [1].Results: We show that in the chick hindbrain, Fgf3 is transcriptionally activated as early as 30 min after mvHnf1 electroporation, suggesting that it is a direct target of this transcription factor. We also analyzed the expression profiles of FGF activity readouts, such as MKP3 and Pea3, and showed that both are expressed within the hindbrain at early stages of embryonic development. In addition, MKP3 is induced upon overexpression of mFgf3 or mvHnf1 in the hindbrain, confirming vHnf1 is upstream FGF signaling. Finally, we addressed the question of which of the FGF-responding intracellular pathways were active and involved in the regulation of Krox20 and MafB in the hindbrain. While Ras-ERK1/2 activity is necessary for MKP3, Krox20 and MafB induction, PI3K-Akt is not involved in that process.Conclusion: Based on these observations we propose that vHnf1 acts directly through FGF3, and promotes caudal hindbrain identity by activating MafB and Krox20 via the Ras-ERK1/2 intracellular pathway.

Collage, a Collaborative Learning Design Editor Based on Patterns

This paper introduces Collage, a high-level IMS-LD compliant authoring tool that is specialized for CSCL (Computer-Supported Collaborative Learning). Nowadays CSCL is a key trend in elearning since it highlights the importance of social interactions as an essential element of learning. CSCL is an interdisciplinary domain, which demands participatory design techniques that allow teachers to get directly involved in design activities. Developing CSCL designs using LD is a difficult task for teachers since LD is a complex technical specification and modelling collaborative characteristics can be tricky. Collage helps teachers in the process of creating their own potentially effective collaborative Learning Designs by reusing and customizing patterns, according to the requirements of a particular learning situation. These patterns, called Collaborative Learning Flow Patterns (CLFPs), represent best practices that are repetitively used by practitioners when structuring the flow of (collaborative) learning activities. An example of an LD that can be created using Collage is illustrated in the paper. Preliminary evaluation results show that teachers, with experience in CL but without LD knowledge, can successfully design real collaborative learning experiences using Collage.

Applying recommendations to aligncompetences, methodology and assessment in Telematics, Computing and Electronic Engineering courses

The alignment between competences, teaching-learning methodologies and assessment is a key element of the European Higher Education Area. This paper presents the efforts carried out by six Telematics, Computer Science and Electronic Engineering Education teachers towards achieving this alignment in their subjects. In a joint work with pedagogues, a set of recommended actions were identified. A selection of these actions were applied and evaluated in the six subjects. The cross-analysis of the results indicate that the actions allow students to better understand the methodologies and assessment planned for the subjects, facilitate (self-) regulation and increase students’ involvement in the subjects.

The role of the Teaching Quality and Innovation Support Unit in the ICT Engineering Studies at Universitat Pompeu Fabra

One of the strategies of Universitat Pompeu Fabra to support Quality Learning has been the creation of Units for the Support of Teaching Quality and Innovation within each faculty. In the seminar we will present the role and activities of the Polytechnic School Unit in charge or coordinating the efforts towards quality learning in the Information and Communication Technologies (ICT) Engineering Studies. We will also discuss how these activities are informed to relevant academic stakeholders.