ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '498471' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '498471' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '498471']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 498471 AND InstitucionPropia = 'S'
UNION
SELECT Adscripciones.Entidad FROM PublicacionesObras
JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion
JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado
WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 498471]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Proceedings - 2017 5th International Conference In Software Engineering Research And Innovation, Conisoft 2017 Título del capítulo: Finding Core Crosscutting Concerns from Object Oriented Systems Using Information Retrieval
Autores UNAM: FRANCISCO VALDES SOUTO;
Autores externos: Idioma: InglésAño de publicación: 2017Palabras clave:
Concerns; Crosscutting concerns; Information retrieval
Resumen:
During the software development cycle, software products can undergo
many changes in requirements and design. In one of those products, the
source code of the system, these changes can impact the original
specifications and design, leading to tangled and scattered code that
affects the design and maintenance processes. Research efforts have been
made to analyze the scattered code for concerns identification and
extraction. In object oriented systems, these concerns can be
distributed across many classes, leading to the definition and
identification of crosscutting concerns. Many methods have been proposed
to identify, extract and separate crosscutting concerns. In this paper,
a method for crosscutting concerns identification using information
retrieval techniques is presented. This work aims to identify the core
crosscutting concerns, which are the main tasks a system has to satisfy
whose code is scattered over the different classes of the system.
Information retrieval provides advantages over common parsing techniques
since the code is treated as unstructured text, making the method
programming language independent.
Entidades citadas de la UNAM:
Fuente:
ISBN: 9781538639566 Editorial: Institute of Electrical and Electronics Engineers Inc.