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 = '384875' 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 = '384875' 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 = '384875' 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 = '384875' 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 = '384875']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '384875'

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

Título del libro: Proceedings Of Special Session - Revised Papers, 11th Mexican International Conference On Artificial Intelligence 2012: Advances In Artificial Intelligence And Applications, Micai 2012
Título del capítulo: Improving the body mass index (BMI) formula with heuristic search

Autores UNAM:
MIGUEL MURGUIA ROMERO; JOSE RAFAEL JIMENEZ FLORES; ADOLFO RENE MENDEZ CRUZ;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2012

---

Palabras clave:

Best first search; Body mass index; Heuristic search; Metabolic syndromes; obesity; Prolog; Artificial intelligence; Blood pressure; Glucose; Health; Heuristic algorithms; Metabolism; Modular robots; Nutrition; Sensitivity analysis

---

Resumen:

The body mass index (BMI) is nowadays the most used tool to evaluate obesity, involving only two anthropometric measures easy to obtain, the weight and the height (BMI=weight/height2). The BMI is valuable because it evaluates obesity, classifying people into 'underweight', 'normal weight', and 'overweight' classes. The value of the BMI means that through a classification of the weight condition, it implicitly estimates the possible alteration in metabolic parameters, such as blood glucose, blood pressure, and cholesterol, among others. Because it is widely used, a little variation in the accuracy of the classification of the BMI may involve thousands of individuals misclassified. The aim of this work was to evaluate variations of the BMI formula searching for one which increases the specificity and sensitivity, respect to metabolic alterations. We applied heuristic search of algebraic and constant variation to the original BMI formula, for example, a rule to generate new variations of the BMI formula is increasing the exponent of the denominator by 0.1. The heuristic function used was the intersection of specificity and sensitivity of the particular formula evaluated, i.e., the maximum values of the two statistics. To evaluate the specificity and sensitivity a database of a sample of 4,308 young Mexicans (17-24 years old), including the parameters of the metabolic alterations evaluated, and weight and height was used. The heuristic search can be applied to adjust formulae that evaluate other clinical alterations, such as the atherogenic index. Also, we propose to use the variations of the BMI formula found in this study, with the high sensitivity and specificity when evaluate obesity of young Mexican as a risk to present metabolic alterations. © 2012 IEEE.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9780769549040
Editorial:

Tipo de producto:
Conference Paper

DOI:
10.1109/MICAI.2012.24