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 = '546959' 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 = '546959' 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 = '546959']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 546959 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= 546959]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Acm International Conference Proceeding Series Título del capítulo: Fully Compact Routing in Low Memory Self-Healing Trees
Autores UNAM: ARMANDO CASTAÑEDA ROJANO;
Autores externos: Idioma: Año de publicación: 2020Palabras clave:
Low Memory Distributed Algorithms; Self-Healing; Compact Tree Routing; Low Memory Preprocessing; Half-full Tree
Resumen:
The paper (Compact Routing Messages in Self-Healing Trees, TCS 2017)
introduced CompactFTZ, the first self-healing compact routing algorithm
that works in a distributed network with each node using only O(log n)
words (i.e. O(log(2) n) bits) memory and thus O(log n) sized messages.
The routing uses only O(1) and O(log n) words routing table and packet
labels respectively on a self-healing tree that also works using only
O(1) words repairing the network in face of a strong adversary deleting
nodes. This deterministic algorithm sets up its data structures in a
preprocessing phase and then updates the required data structures in
only O(1) parallel time per healing round during execution of the
algorithm.
However, CompactFTZ has no constraints in its preprocessing phase which
could be done in distributed large memory or even centrally. In this
paper, we correct that by developing the algorithms for preprocessing of
CompactFTZ in a fully distributed manner using only O(log n) words
memory in optimal time. In fact, the preprocessing for the self-healing
tree (ForgivingTree) component takes only O(1) memory. We develop a
local function which each node invokes to instantly compute and then
relay its repair instructions (known as its Will) in only O(1) time.
We formalise the low memory CONGEST model setting used in previous low
memory algorithms (e.g.[24]); nodes' working memory is restricted to
be much smaller (in our case, O(log n)) than the numbers of their
neighbours to whom they communicate through their I/O ports. We expand
the model to allow for non-contiguous ports (e.g. empty ports or
neighbours unmarked or lost in dynamic settings) and adversarial order
of inputs from neighbours. Besides the Wills, we set up the tree
structures and traversals for the routing scheme using only O(log n)
memory and O(D) parallel time, where D is the diameter. Thus, we devise
the first self-healing compact routing algorithm that can be fully set
up and executed in low memory.
Entidades citadas de la UNAM:
Fuente:
ISBN: 9781450377515 Editorial: Association for Computing Machinery