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 = '619264' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '619264' 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 = '619264' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '619264' 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 = '619264']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '619264'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 619264 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= 619264]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 619264 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= 619264

Título del libro: 2021 Mexican International Conference On Computer Science, Enc 2021
Título del capítulo: Identification of potential adverse drug reactions using random walk on network models

Autores UNAM:
GUILLERMO DE ANDA JAUREGUI;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2021

---

Palabras clave:

Database systems; Drug interactions; Adverse drug reactions; Health consequences; High-throughput; Higher order effects; Network models; Omics technologies; Public database; Random Walk; Random walk on network; Second orders; Random processes

---

Resumen:

Adverse drug event or adverse drug reactions (ADRs) are known to result from off-target pharmacological interactions and higher order effects. ADRs have been often 'discovered' only after clinical events are reported and archived in databases such as FAERS. Off-target interactions and higher order effects are mostly reported at the pairwise and second order levels, respectively. Hence, many likely-ADRs are overlooked for a long time, leading to a multitude of potential morbi-mortality events with enormous public and individual health consequences. With the advent of high throughput omic technologies and large public databases, an enormous corpus of biochemical and phenotypic data is available to study ADRs. Detailed analyses of such data corpora may allow us to develop a deeper understanding of these relevant, higher order interactions, leading to a better assessment of potential ADRs. However, extracting useful information from such large data conglomerates is a challenging endeavor for the data sciences. Here, we applied methods from knowledge discovery in databases, network pharmacology, supervised and semi-supervised statistical learning, to tackle the problem of identifying potential adverse drug reactions. By analyzing a set of 500 drugs, including 67 systemic anti-infective agents, we identified over 27,000 potential adverse drug reactions based on activity on well-known biological function sets. © 2021 IEEE.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781665426121
Editorial:
Institute of Electrical and Electronics Engineers Inc.

Tipo de producto:
Conference Paper

DOI:
10.1109/ENC53357.2021.9534826