Organization of the equine immunoglobulin heavy chain constant region genes; III. Alignment of c mu, c gamma, c epsilon and c alpha genes.

Previous restriction analysis of cloned equine DNA and genomic DNA of equine peripheral blood mononuclear cells had indicated the existence of one c epsilon, one c alpha and up to six c gamma genes in the haploid equine genome. The c epsilon and c alpha genes have been aligned on a 30 kb DNA fragment in the order 5' c epsilon-c alpha 3'. Here we describe the alignment of the equine c mu and c gamma genes by deletion analysis of one IgM, four IgG and two equine light chain expressing heterohybridomas. This analysis establishes the existence of six c gamma genes per haploid genome. The genomic alignment of the cH-genes is 5' c mu/(/) c gamma 1/(/) c gamma 2/(/) c gamma 3/(/) c gamma 4/(/) c gamma 5/(/) c gamma 6/(/) c epsilon-c alpha 3', naming the c gamma genes according to their position relative to c mu. For three of the c gamma genes the corresponding IgG isotypes could be identified as IgGa for c gamma 1, IgG(T) for c gamma 3 and IgGb for c gamma 4.

Modes of Supply for US Exports of Services

We examine the choice of modes of delivery in services based on US data, including both cross-border exports and sales through foreign affiliates. We focus on characteristics of destination markets and how this impacts on mode choice. We find that market size, distance and policy all play a role in where firms establish, and in how many markets firms enter. The importance of sales through affiliates relative to total foreign sales also depends on factors like market size, geographic and economic distance and the policy regime in place. Precisely, how important these factors are depends on the sector in question.

GENETIC ORGANIZATION OF THE STRUCTURAL GENES FOR NITRATE REDUCTASE (TN5)

Nitrate reductase in Escherichia coli is a membrane-bound anaerobic enzyme that is repressed by oxygen and induced by nitrate. The genetic organization of the structural genes for the two larger subunits of nitrate reductase ((alpha) and (beta)) was determined by immunoprecipitation analysis of the formation of these proteins in nitrate reductase-deficient mutants resulting from transposon Tn5 mutagenesis. The results suggested that the genes encoding the (alpha) and (beta) subunits (narG and H) were arranged in an operon with transcription in the direction promoter(--->)(alpha)(--->)(beta). Segments of the chromosome containing the Tn5 inserts from several of the mutants were cloned into plasmid pBR322 and the positions of the transposons determined by restriction mapping. The Tn5 insertion sites were localized on two contiguous EcoRI fragments spanning about 6.6 kilobases of DNA. The narI gene (proposed to encode the (gamma) subunit) was positioned immediately downstream from the (beta)-gene (narH) by Southern analysis of Tn10 insertions into the narI locus. A Tn10 insertion into the narK locus, proposed to encode a nitrate-sensitive repressor of other anaerobic enzymes, was located about 1.5 kilobases upstream from the narGHI operon promoter. The narL locus, proposed to encode a nitrate-sensitive positive regulator of the narGHI operon and known to be genetically linked to the other nar genes, was demonstrated to lie outside a 19.3-kilobase region of the chromosome which encompasses the other nar genes. The physical limit of the narGHI promoter was defined by studying the effect of Tn5 insertions into a hybrid plasmid containing the functional operon. The points of origin of the coding regions for the (alpha) and (beta) genes were deduced by alignment of the chromosomal map of Tn5 insertion sites with the sizes of (alpha) and (beta) subunit fragments produced by plasmids carrying these Tn5 inserts in the nar operon. The coding region for the (alpha) subunit (143,000 daltons) begins about 250 nucleotides downstream from the deduced limit of the promoter region and includes about 4.0 kilobases of DNA; the region encoding (beta) (60,000 daltons) lies immediately downstream from the (alpha)-gene and is approximately 1.6 kilobases in length. The adjacent region encoding the (gamma) subunit (19,000 daltons) is approximately 0.5 kilobase in length. ^

THE ULTRASTRUCTURAL ORGANIZATION OF THE HYPOGLOSSAL NUCLEUS IN THE RAT (SYNAPTOLOGY, CRANIAL NERVES)

An ultrastructural study of the hypoglossal nucleus (XII) in the rat has revealed two distinct neuronal populations. Hypoglossal motoneurons comprised the largest population of neurons in XII and were identified following injection of horseradish peroxidase (HRP) into the tongue. Motoneurons were large (25-50(mu)m), multipolar in shape and distributed throughout XII. The nucleus was large, round and centrally located, and the cytoplasm was characterized by dense lamellar arrays of rough endoplasmic reticulum. In contrast, a second population of small (10-18(mu)m), round to oval shaped neurons was found restricted to the ventral and dorsolateral regions of XII. The nucleus was markedly invaginated and eccentric, the cytoplasm scant and filled with free ribosomes, and the absence of lamellar arrays of rough endoplasmic reticulum was conspicuous. Neurons of this type were never found to contain HRP reaction product. These results demonstrate that the hypoglossal nucleus does not consist solely of motoneurons, but includes a distinctly separate, presumably non-motoneuronal pool. Arguments are presented in favor of this second neuron population being interneurons. The functional significance of these findings in relation to tongue control is discussed. ^

Cognitive Comparative Advantage and the Organization of Work: Lessons from Herbert Simon's Vision of the Future

In a marvelous but somewhat neglected paper, 'The Corporation: Will It Be Managed by Machines?' Herbert Simon articulated from the perspective of 1960 his vision of what we now call the New Economy the machine-aided system of production and management of the late twentieth century. Simon's analysis sprang from what I term the principle of cognitive comparative advantage: one has to understand the quite different cognitive structures of humans and machines (including computers) in order to explain and predict the tasks to which each will be most suited. Perhaps unlike Simon's better-known predictions about progress in artificial intelligence research, the predictions of this 1960 article hold up remarkably well and continue to offer important insights. In what follows I attempt to tell a coherent story about the evolution of machines and the division of labor between humans and machines. Although inspired by Simon's 1960 paper, I weave many other strands into the tapestry, from classical discussions of the division of labor to present-day evolutionary psychology. The basic conclusion is that, with growth in the extent of the market, we should see humans 'crowded into' tasks that call for the kinds of cognition for which humans have been equipped by biological evolution. These human cognitive abilities range from the exercise of judgment in situations of ambiguity and surprise to more mundane abilities in spatio-temporal perception and locomotion. Conversely, we should see machines 'crowded into' tasks with a well-defined structure. This conclusion is not based (merely) on a claim that machines, including computers, are specialized idiots-savants today because of the limits (whether temporary or permanent) of artificial intelligence; rather, it rests on a claim that, for what are broadly 'economic' reasons, it will continue to make economic sense to create machines that are idiots-savants.

The Old Ball Game: Organization of Nineteenth Century Professional Base Ball Clubs

The first professional base ball clubs came in two varieties: stock clubs, which paid their players fixed wages, and player cooperatives, in which players shared the proceeds after expenses. We argue that stock clubs were formed with players of known ability, while co-ops were formed with players of unknown ability. Although residual claimancy served to screen out players of inferior ability in co-ops, the process was imperfect due to the team production problem. Based on this argument, we suggest that co-ops functioned as an early minor league system where untried players could seek to prove themselves and eventually move up to wage teams. Empirical analysis of data on player performance and experience in early professional base ball provides support for the theory.

The Organization of Consumption

No abstract available.

Organization of the inferotemporal cortex in the macaque monkey: Connections of areas PITv and CITvp

Visual cortex of macaque monkeys consists of a large number of cortical areas that span the occipital, parietal, temporal, and frontal lobes and occupy more than half of cortical surface. Although considerable progress has been made in understanding the contributions of many occipital areas to visual perceptual processing, much less is known concerning the specific functional contributions of higher areas in the temporal and frontal lobes. Previous behavioral and electrophysiological investigations have demonstrated that the inferotemporal cortex (IT) is essential to the animal's ability to recognize and remember visual objects. While it is generally recognized that IT consists of a number of anatomically and functionally distinct visual-processing areas, there remains considerable controversy concerning the precise number, size, and location of these areas. Therefore, the precise delineation of the cortical subdivisions of inferotemporal cortex is critical for any significant progress in the understanding of the specific contributions of inferotemporal areas to visual processing. In this study, anterograde and/or retrograde neuroanatomical tracers were injected into two visual areas in the ventral posterior and central portions of IT (areas PITv and CITvp) to elucidate the corticocortical connections of these areas with well known areas of occipital cortex and with less well understood regions of inferotemporal cortex. The locations of injection sites and the delineation of the borders of many occipital areas were aided by the pattern of interhemispheric connections, revealed following callosal transection and subsequent labeling with HRP. The resultant patterns of connections were represented on two-dimensional computational (CARET) and manual cortical maps and the laminar characteristics and density of the projection fields were quantified. The laminar and density features of these corticocortical connections demonstrate thirteen anatomically distinct subdivisions or areas distributed within the superior temporal sulcus and across the inferotemporal gyrus. These results serve to refine previous descriptions of inferotemporal areas, validate recently identified areas, and provide a new description of the hierarchical relationships among occipitotemporal cortical areas in macaques. ^

THE EFFECTS OF COST-SHARING ON USE OF SERVICES AND CONSUMER CHARACTERISTICS IN A STATE'S CRIPPLED CHILDREN'S DIVISION

The present study analyzed some of the effects of imposing a cost-sharing requirement on users of a state's health service program. The study population consisted of people who were in diagnosed medical need and included, but was not limited to, people in financial need.^ The purpose of the study was to determine if the cost-sharing requirement had any detrimental effects on the service population. Changes in the characteristics of service consumers and in utilization patterns were analyzed using time-series techniques and pre-post policy comparisons.^ The study hypotheses stated that the distribution of service provided, diagnoses serviced, and consumer income levels would change following the cost-sharing policy.^ Analysis of data revealed that neither the characteristics of service users (income, race, sex, etc.) nor services provided by the program changed significantly following the policy. The results were explainable in part by the fact that all of the program participants were in diagnosed medical need. Therefore, their use of "discretionary" or "less necessary" services was limited.^ The study's findings supported the work of Joseph Newhouse, Charles Phelps, and others who have contended that necessary service use would not be detrimentally affected by reasonable cost-sharing provisions. These contentions raise the prospect of incorporating cost-sharing into programs such as Medicaid, which, at this writing, do not demand any consumer payment for services.^ The study concluded with a discussion of the cost-containment problem in health services. The efficacy of cost-sharing was considered relative to other financing and reimbursement strategies such as HMO's, self-funding, and reimbursement for less costly services and places of service. ^

THE FUNCTIONAL ORGANIZATION OF SYNAPTIC VESICLE POOLS IN A RETINAL BIPOLAR NEURON

Ribbon synapses are found in sensory systems and are characterized by ‘ribbon-like’ organelles that tether synaptic vesicles. The synaptic ribbons co-localize with sites of calcium entry and vesicle fusion, forming ribbon-style active zones. The ability of ribbon synapses to maintain rapid and sustained neurotransmission is critical for vision, hearing and balance. At retinal ribbon synapses, three vesicle pools have been proposed. A rapid pool of vesicles that are docked at the plasma membrane, and whose fusion is limited only by calcium entry, a releasable pool of ATP-primed vesicles whose size also correlates with the number of ribbon-tethered vesicles, and a reserve pool of non-ribbon-tethered cytoplasmic vesicles. However evidence of vesicle fusion at sites away from ribbon-style active zones questions this organization. Another fundamental question underlying the mechanism of vesicle fusion at these synapses is the role of SNARE (Soluble N-ethylmaleimide sensitive factor Attachment Protein Receptor) proteins. Vesicles at conventional neurons undergo SNARE complex-mediated fusion. However a recent study has suggested that ribbon synapses involved in hearing can operate independently of neuronal SNAREs. We used the well-characterized goldfish bipolar neuron to investigate the organization of vesicle pools and the role of SNARE proteins at a retinal ribbon synapse. We blocked functional refilling of the releasable pool and then stimulated bipolar terminals with brief depolarizations that triggered the fusion of the rapid pool of vesicles. We found that the rapid pool draws vesicles from the releasable pool and that both pools undergo release at ribbon-style active zones. To assess the functional role of SNARE proteins at retinal ribbon synapses, we used peptides derived from SNARE proteins that compete with endogenous proteins for SNARE complex formation. The SNARE peptides blocked fusion of reserve vesicles but not vesicles in the rapid and releasable pools, possibly because both rapid and releasable vesicles were associated with preformed SNARE complexes. However, an activity-dependent block in refilling of the releasable pool was seen, suggesting that new SNARE complexes must be formed before vesicles can join a fusion-competent pool. Taken together, our results suggest that SNARE complex-mediated exocytosis of serially-organized vesicle pools at ribbon-style active zones is important in the neurotransmission of vision.

Cost -effectiveness of services and treatments for ambulatory dually diagnosed CMHC clients: Implications for managed care

This paper reports a cost-effectiveness analysis of standard therapeutic interventions received by ambulatory dually diagnosed clients of a Community Mental Health Center (CMHC). For the purposes of this study dually diagnosed was defined as a DSM-III-R or IV diagnosis of a major mental disorder and a concomitant substance abuse disorder. The prevalence of dually diagnosed people among the mentally ill and their unique and problematic nature continues to challenge and encumber CMHCs and poses grave public health risks. An absence of research on these clients in community-based settings and the cost-effectiveness of their standard CMHC care has hindered the development of effective community-based intervention strategies. This exploratory and descriptive effort is a first step toward providing information on which to base programmatic management decisions.^ Data for this study were derived from electronic client records of a CMHC located in a large Southwestern, Sun-belt metropolitan area. A total of 220 records were collected on clients consecutively admitted during a two-and-one-half year period. Information was gathered profiling the clients' background characteristics, receipt of standard services and treatments, costs of the care they received, and length of CMHC enrollment and subsequent psychiatric hospitalizations. The services and treatments were compared with regard to their costs and predicted contributions toward maintaining clients in the community and out of public psychiatric hospitals.^ This study investigated: (1) the study groups' background, mental illness, and substance abuse characteristics; (2) types, extent, and patterns of their receipt of standard services and treatments; (3) associations between the receipt of services and treatments, community tenure, and risk of psychiatric hospitalization; and, (4) comparisons of average costs for services and treatments in terms of their contributions toward maintaining the clients in the community.^ The results suggest that substance abuse and other lifestyle factors were related to the dually diagnosed clients' admissions to the CMHC. The dually diagnosed clients' receipt of care was associated strongly with their insurability and global functioning. Medication Services were the most expensive yet effective service or treatment. Supported Education was the third most expensive and second most effective. Psychosocial Services, the second most expensive, were only effective in terms of maintaining clients in the community. Group Counseling, the fourth most expensive, had no effect on community maintenance and increased the risk of hospitalization when accompanied by Medication Services. Individual Counseling, the least expensive, had no effect on community maintenance. But it reduced the risk of hospitalization when accompanied by Medication Services. Networking/Referral, the fifth most expensive service or treatment, was ineffective.^ The study compared the results with findings in the literature. Implications are discussed regarding further research, study limitations, practical applications and benefits, and improvements to theoretical understandings, in particular, concepts underscoring Managed Care. ^

Search, matching, and self-organization of a marketplace

In many developing countries, clusters of small shops are the typical market-place. We investigate an economic model in which, between buyers and sellers in a marketplace, a circular causality including the search process produces agglomeration forces, given the initial location of the marketplace location exogenously in a linear city. We conclude that initial number of buyers and sellers is important in forming a large marketplace.

Collective Organization of Complex Networks: Emergent Scales, Vulnerability, and Targeting of Desired Dynamics

Cuando una colectividad de sistemas dinámicos acoplados mediante una estructura irregular de interacciones evoluciona, se observan dinámicas de gran complejidad y fenómenos emergentes imposibles de predecir a partir de las propiedades de los sistemas individuales. El objetivo principal de esta tesis es precisamente avanzar en nuestra comprensión de la relación existente entre la topología de interacciones y las dinámicas colectivas que una red compleja es capaz de mantener. Siendo este un tema amplio que se puede abordar desde distintos puntos de vista, en esta tesis se han estudiado tres problemas importantes dentro del mismo que están relacionados entre sí. Por un lado, en numerosos sistemas naturales y artificiales que se pueden describir mediante una red compleja la topología no es estática, sino que depende de la dinámica que se desarrolla en la red: un ejemplo son las redes de neuronas del cerebro. En estas redes adaptativas la propia topología emerge como consecuencia de una autoorganización del sistema. Para conocer mejor cómo pueden emerger espontáneamente las propiedades comúnmente observadas en redes reales, hemos estudiado el comportamiento de sistemas que evolucionan según reglas adaptativas locales con base empírica. Nuestros resultados numéricos y analíticos muestran que la autoorganización del sistema da lugar a dos de las propiedades más universales de las redes complejas: a escala mesoscópica, la aparición de una estructura de comunidades, y, a escala macroscópica, la existencia de una ley de potencias en la distribución de las interacciones en la red. El hecho de que estas propiedades aparecen en dos modelos con leyes de evolución cuantitativamente distintas que siguen unos mismos principios adaptativos sugiere que estamos ante un fenómeno que puede ser muy general, y estar en el origen de estas propiedades en sistemas reales. En segundo lugar, proponemos una medida que permite clasificar los elementos de una red compleja en función de su relevancia para el mantenimiento de dinámicas colectivas. En concreto, estudiamos la vulnerabilidad de los distintos elementos de una red frente a perturbaciones o grandes fluctuaciones, entendida como una medida del impacto que estos acontecimientos externos tienen en la interrupción de una dinámica colectiva. Los resultados que se obtienen indican que la vulnerabilidad dinámica es sobre todo dependiente de propiedades locales, por tanto nuestras conclusiones abarcan diferentes topologías, y muestran la existencia de una dependencia no trivial entre la vulnerabilidad y la conectividad de los elementos de una red. Finalmente, proponemos una estrategia de imposición de una dinámica objetivo genérica en una red dada e investigamos su validez en redes con diversas topologías que mantienen regímenes dinámicos turbulentos. Se obtiene como resultado que las redes heterogéneas (y la amplia mayora de las redes reales estudiadas lo son) son las más adecuadas para nuestra estrategia de targeting de dinámicas deseadas, siendo la estrategia muy efectiva incluso en caso de disponer de un conocimiento muy imperfecto de la topología de la red. Aparte de la relevancia teórica para la comprensión de fenómenos colectivos en sistemas complejos, los métodos y resultados propuestos podrán dar lugar a aplicaciones en sistemas experimentales y tecnológicos, como por ejemplo los sistemas neuronales in vitro, el sistema nervioso central (en el estudio de actividades síncronas de carácter patológico), las redes eléctricas o los sistemas de comunicaciones. ABSTRACT The time evolution of an ensemble of dynamical systems coupled through an irregular interaction scheme gives rise to dynamics of great of complexity and emergent phenomena that cannot be predicted from the properties of the individual systems. The main objective of this thesis is precisely to increase our understanding of the interplay between the interaction topology and the collective dynamics that a complex network can support. This is a very broad subject, so in this thesis we will limit ourselves to the study of three relevant problems that have strong connections among them. First, it is a well-known fact that in many natural and manmade systems that can be represented as complex networks the topology is not static; rather, it depends on the dynamics taking place on the network (as it happens, for instance, in the neuronal networks in the brain). In these adaptive networks the topology itself emerges from the self-organization in the system. To better understand how the properties that are commonly observed in real networks spontaneously emerge, we have studied the behavior of systems that evolve according to local adaptive rules that are empirically motivated. Our numerical and analytical results show that self-organization brings about two of the most universally found properties in complex networks: at the mesoscopic scale, the appearance of a community structure, and, at the macroscopic scale, the existence of a power law in the weight distribution of the network interactions. The fact that these properties show up in two models with quantitatively different mechanisms that follow the same general adaptive principles suggests that our results may be generalized to other systems as well, and they may be behind the origin of these properties in some real systems. We also propose a new measure that provides a ranking of the elements in a network in terms of their relevance for the maintenance of collective dynamics. Specifically, we study the vulnerability of the elements under perturbations or large fluctuations, interpreted as a measure of the impact these external events have on the disruption of collective motion. Our results suggest that the dynamic vulnerability measure depends largely on local properties (our conclusions thus being valid for different topologies) and they show a non-trivial dependence of the vulnerability on the connectivity of the network elements. Finally, we propose a strategy for the imposition of generic goal dynamics on a given network, and we explore its performance in networks with different topologies that support turbulent dynamical regimes. It turns out that heterogeneous networks (and most real networks that have been studied belong in this category) are the most suitable for our strategy for the targeting of desired dynamics, the strategy being very effective even when the knowledge on the network topology is far from accurate. Aside from their theoretical relevance for the understanding of collective phenomena in complex systems, the methods and results here discussed might lead to applications in experimental and technological systems, such as in vitro neuronal systems, the central nervous system (where pathological synchronous activity sometimes occurs), communication systems or power grids.

NFC based remote control of services for interactive spaces

Ubiquitous computing (one person, many computers) is the third era in the history of computing. It follows the mainframe era (many people, one computer) and the PC era (one person, one computer). Ubiquitous computing empowers people to communicate with services by interacting with their surroundings. Most of these so called smart environments contain sensors sensing users’ actions and try to predict the users’ intentions and necessities based on sensor data. The main drawback of this approach is that the system might perform unexpected or unwanted actions, making the user feel out of control. In this master thesis we propose a different procedure based on Interactive Spaces: instead of predicting users’ intentions based on sensor data, the system reacts to users’ explicit predefined actions. To that end, we present REACHeS, a server platform which enables communication among services, resources and users located in the same environment. With REACHeS, a user controls services and resources by interacting with everyday life objects and using a mobile phone as a mediator between himself/herself, the system and the environment. REACHeS’ interfaces with a user are built upon NFC (Near Field Communication) technology. NFC tags are attached to objects in the environment. A tag stores commands that are sent to services when a user touches the tag with his/her NFC enabled device. The prototypes and usability tests presented in this thesis show the great potential of NFC to build such user interfaces.

Advanced system of planning and organization of classes at the university

This document is the result of a process of web development to create a tool that will allow to Cracow University of Technology consult, create and manage timetables. The technologies chosen for this purpose are Apache Tomcat Server, My SQL Community Server, JDBC driver, Java Servlets and JSPs for the server side. The client part counts on Javascript, jQuery, AJAX and CSS technologies to perform the dynamism. The document will justify the choice of these technologies and will explain some development tools that help in the integration and development of all this elements: specifically, NetBeans IDE and MySQL workbench have been used as helpful tools. After explaining all the elements involved in the development of the web application, the architecture and the code developed are explained through UML diagrams. Some implementation details related to security are also deeper explained through sequence diagrams. As the source code of the application is provided, an installation manual has been developed to run the project. In addition, as the platform is intended to be a beta that will be grown, some unimplemented ideas for future development are also exposed. Finally, some annexes with important files and scripts related to the initiation of the platform are attached. This project started through an existing tool that needed to be expanded. The main purpose of the project along its development has focused on setting the roots for a whole new platform that will replace the existing one. For this goal, it has been needed to make a deep inspection on the existing web technologies: a web server and a SQL database had to be chosen. Although the alternatives were a lot, Java technology for the server was finally selected because of the big community backwards, the easiness of modelling the language through UML diagrams and the fact of being free license software. Apache Tomcat is the open source server that can use Java Servlet and JSP technology. Related to the SQL database, MySQL Community Server is the most popular open-source SQL Server, with a big community after and quite a lot of tools to manage the server. JDBC is the driver needed to put in contact Java and MySQL. Once we chose the technologies that would be part of the platform, the development process started. After a detailed explanation of the development environment installation, we used UML use case diagrams to set the main tasks of the platform; UML class diagrams served to establish the existing relations between the classes generated; the architecture of the platform was represented through UML deployment diagrams; and Enhanced entity–relationship (EER) model were used to define the tables of the database and their relationships. Apart from the previous diagrams, some implementation issues were explained to make a better understanding of the developed code - UML sequence diagrams helped to explain this. Once the whole platform was properly defined and developed, the performance of the application has been shown: it has been proved that with the current state of the code, the platform covers the use cases that were set as the main target. Nevertheless, some requisites needed for the proper working of the platform have been specified. As the project is aimed to be grown, some ideas that could not be added to this beta have been explained in order not to be missed for future development. Finally, some annexes containing important configuration issues for the platform have been added after proper explanation, as well as an installation guide that will let a new developer get the project ready. In addition to this document some other files related to the project are provided: - Javadoc. The Javadoc containing the information of every Java class created is necessary for a better understanding of the source code. - database_model.mwb. This file contains the model of the database for MySQL Workbench. This model allows, among other things, generate the MySQL script for the creation of the tables. - ScheduleManager.war. The WAR file that will allow loading the developed application into Tomcat Server without using NetBeans. - ScheduleManager.zip. The source code exported from NetBeans project containing all Java packages, JSPs, Javascript files and CSS files that are part of the platform. - config.properties. The configuration file to properly get the names and credentials to use the database, also explained in Annex II. Example of config.properties file. - db_init_script.sql. The SQL query to initiate the database explained in Annex III. SQL statements for MySQL initialization. RESUMEN. Este proyecto tiene como punto de partida la necesidad de evolución de una herramienta web existente. El propósito principal del proyecto durante su desarrollo se ha centrado en establecer las bases de una completamente nueva plataforma que reemplazará a la existente. Para lograr esto, ha sido necesario realizar una profunda inspección en las tecnologías web existentes: un servidor web y una base de datos SQL debían ser elegidos. Aunque existen muchas alternativas, la tecnología Java ha resultado ser elegida debido a la gran comunidad de desarrolladores que tiene detrás, además de la facilidad que proporciona este lenguaje a la hora de modelarlo usando diagramas UML. Tampoco hay que olvidar que es una tecnología de uso libre de licencia. Apache Tomcat es el servidor de código libre que permite emplear Java Servlets y JSPs para hacer uso de la tecnología de Java. Respecto a la base de datos SQL, el servidor más popular de código libre es MySQL, y cuenta también con una gran comunidad detrás y buenas herramientas de modelado, creación y gestión de la bases de datos. JDBC es el driver que va a permitir comunicar las aplicaciones Java con MySQL. Tras elegir las tecnologías que formarían parte de esta nueva plataforma, el proceso de desarrollo tiene comienzo. Tras una extensa explicación de la instalación del entorno de desarrollo, se han usado diagramas de caso de UML para establecer cuáles son los objetivos principales de la plataforma; los diagramas de clases nos permiten realizar una organización del código java desarrollado de modo que sean fácilmente entendibles las relaciones entre las diferentes clases. La arquitectura de la plataforma queda definida a través de diagramas de despliegue. Por último, diagramas EER van a definir las relaciones entre las tablas creadas en la base de datos. Aparte de estos diagramas, algunos detalles de implementación se van a justificar para tener una mejor comprensión del código desarrollado. Diagramas de secuencia ayudarán en estas explicaciones. Una vez que toda la plataforma haya quedad debidamente definida y desarrollada, se va a realizar una demostración de la misma: se demostrará cómo los objetivos generales han sido alcanzados con el desarrollo actual del proyecto. No obstante, algunos requisitos han sido aclarados para que la plataforma trabaje adecuadamente. Como la intención del proyecto es crecer (no es una versión final), algunas ideas que se han podido llevar acabo han quedado descritas de manera que no se pierdan. Por último, algunos anexos que contienen información importante acerca de la plataforma se han añadido tras la correspondiente explicación de su utilidad, así como una guía de instalación que va a permitir a un nuevo desarrollador tener el proyecto preparado. Junto a este documento, ficheros conteniendo el proyecto desarrollado quedan adjuntos. Estos ficheros son: - Documentación Javadoc. Contiene la información de las clases Java que han sido creadas. - database_model.mwb. Este fichero contiene el modelo de la base de datos para MySQL Workbench. Esto permite, entre otras cosas, generar el script de iniciación de la base de datos para la creación de las tablas. - ScheduleManager.war. El fichero WAR que permite desplegar la plataforma en un servidor Apache Tomcat. - ScheduleManager.zip. El código fuente exportado directamente del proyecto de Netbeans. Contiene todos los paquetes de Java generados, ficheros JSPs, Javascript y CSS que forman parte de la plataforma. - config.properties. Ejemplo del fichero de configuración que permite obtener los nombres de la base de datos - db_init_script.sql. Las consultas SQL necesarias para la creación de la base de datos.