This website has been translated by machine translation software and has not been subsequently revised by translators. Further information at: link. Hide
the accesskey _ mod _ content
-

- Disability service march Government

  • Functional description

    The main functionality of DSCP (service of Disabilities) is scheduling and launch a process of importing data into PDF format to database, which opens the service SPD. This process is to obtain information specific data requested by the service as defined in brokering Platform MHAP. Also provides access to such data.

    Much of the application logic is at the grassroots level data, being implemented by means of programming of stored procedures (PL-SQL). The reason is due to the data manipulation of high level.

    A continuación se describe genéricamente las partes que intervienen en el proceso de importación
    1. Application Java:

    • Component CORE : se encarga de leer los ficheros en formato DBF ubicados en la carpeta indicada, procesando y calculando parámetros a partir de los datos leídos del fichero para su posteriormente llamar a los procedimientos almacenados entregando los datos previamente calculados y normalizados. .
    • Component ADMIN: Administration portal for DSCP, to configure and configure both the CORE component as the ADMIN.

    1. Stored Procedures:

    • Import logic : is responsible for import into the tables of the database data already calculated that delivers the CORE component of the application JAVA. Some personal data of high level are encrypted following different strategies. Personal data imported into the payee tables are encrypted through the algorithm AES192, while personal data imported into the table quicksearch encrypted are generating a HASH of the algorithm MD5.
    • Logic for the consultation of disability data : some procedures provide consultation service disability data so that they can be invoked by any application consultant. In this case the application consultant would be SPD (data Service Provider).
    • Logic audit of data: procedure for auditing both data requests as responses generated an application consultant, as SPD performed to obtain the certificate of disability. The request and response SOAP will be encrypted through the algorithm AES192 in a table where they are all trace.

    In order to use the application requires a series of requirements:

    • Three files DBFs with data of certificates of disability in the correct format (a file with personal data, another with data from certificate and other associated with files).
    • Aplicaciones invocantes: Permisos de ejecución de los PL/SQL de la base de datos
    • Admin: Discharged into SIU and PAU.
    • High in SGA.

    Technical Description

    Para el diseño de la arquitectura del sistema DSCP se han seguido los patrones de diseño más extendidos como son las arquitecturas J2EE en diferentes capas. Las capas de la aplicación son las siguientes:

    • Layer of Presentation: to interact with the user and presenting information. to this layer has chosen the framework Struts2 which implements the widespread pattern of design MVC or Modelo-Vista-Controlador. Still:
    • View: JSP's
    • Model: different Actions defined
    • Driver: Dispatcher provided by the framework Struts2
    • Capa de Negocio-Servicios: para la capa de negocio se utiliza el framework de Spring para inyectar las dependencias. Para la generación de los servicios web de administración se utiliza CXF.
    • Capa de Acceso a Datos: para la gestión de la capa de datos se utiliza el framework Hibernate con la utilización del patrón de diseño DAO.

    For the correct functioning of the PL/SQL implemented, it is necessary that the database and the user has enabled the following module:
    - DBMS _ CRYPTO

    External components that interacts with the are:

    • Platform of Electronic Signature (ASF)
    • System of identification of users (SIU)
    • Platform for authorization of users (PAU)
    • Management system Alerts (SGA)
    • System of Data provider (SPD)

    The application has been developed according to the technical characteristics of environments where they are as follows:

    • Sun Solaris systems
    • Application server Oracle Application Server 10g Release 3
    • Database server Oracle Database 10g Release 2 RAC
    • Driver thin JDBC of Database Connection: Oracle JDBC Driver 10.1.0

    DSCP requiere que la máquina virtual de java sobre la que se ejecuta el servidor de aplicaciones sea jdk1.5.0_22, con J2EE v1.4, JSP 2.0 y Servlet 2.4. En concreto DSCP se ha desplegado y probado con jdk1.5.0_22 sobre Oracle Application Server y la base de datos Oracle.
    For more information please consult:

    • Manual of exploitation
    • Installation Manual
    • User Manual

    CTT-IMAGEN _ DSCP _ ARAGON

General access point
General access point
Maintainer