A Research of SQL-Based Web Services Automatic Generating Strategy

Chi, Qiang; Zhu, Yonghua; Zhu, Huaiyang

doi:10.1109/apscc.2010.33

Cited by 2 publications

(1 citation statement)

References 3 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Si la herramienta mostrada permite generar un SQL bien formado, es posible proponer luego proyectos de generación de servicios web personalizados basados en estas consultas SQL que están bien formadas [6].…”

Section: Conclusiones Y Trabajo Futurounclassified

Arquitectura para la generación de consultas SQL usando lógica de conjuntos

Silva¹,

Palacios²

2018

Vis. Electron.

View full text Add to dashboard Cite

Historia del artículo:El presente artículo muestra, la arquitectura implementada en el desarrollo de una herramienta generadora de código SQL, concretamente código de consulta entre varias tablas, en donde se desean hacer operaciones que guardan relación con las operaciones de JOIN entre tablas. La herramienta explota el uso de LEFT JOIN, RIGHT JOIN, INNER JOIN Y FULL OUTHER JOIN. La arquitectura propuesta funciona para una gran cantidad de tablas, sin embargo, la herramienta por razones de eficiencia computacional en esta versión permite hasta tres tablas. La metáfora que sigue el generador de código SQL, es la metáfora impuesta por los diagramas de Venn, la cual es útil en múltiples aplicaciones computacionales y en este artículo se usó para la construcción de un generador de código en donde el usuario selecciona un diagrama de Venn concreto. Al final del artículo se muestran las modificaciones que se hace necesario implementar a la arquitectura para agregar otras funcionalidades.This article shows the architecture implemented in the development of an SQL code generating tool (query code) between several tables, where it is desired to perform operations that are related to JOIN operations between tables. The tool exploits the use of LEFT JOIN, RIGHT JOIN, INNER JOIN and FULL OUTHER JOIN. The proposed architecture works for a large number of tables; however, the tool for reasons of computational efficiency in this version, allows up to three tables. The metaphor that follows the SQL code generator, is the metaphor imposed by Venn diagrams, which is useful in multiple computational applications and, in this article, it was used for the construction of a code generator, in which the user selects a concrete Venn diagram. At the end of the article, we show the modifications that are necessary to implement in the architecture, to add other functionalities. Palabras clave: Algebra relacional Generador de códigos Herramientas case Lógica de conjuntos Sentencias SQL Keywords: Relational algebra Code generator Tools case Logic set SQL statements Citar este artículo como: L. F. Wanumen y D. J. Mosquera, "Arquitectura para la generación de consultas SQL usando lógica de conjuntos". Visión Electrónica, algo más que un estado sólido, Vol. 12, No. 2, 307-318, julio-diciembre 2018. https://doi.

show abstract

Section: Conclusiones Y Trabajo Futurounclassified

Arquitectura para la generación de consultas SQL usando lógica de conjuntos

Silva¹,

Palacios²

2018

Vis. Electron.

View full text Add to dashboard Cite

show abstract

A Framework for the Evaluation of Semantics-Based Service Composition Approaches

Silva

Pires

Sinderen³

2009

2009 Seventh IEEE European Conference on Web Services

View full text Add to dashboard Cite

The benefits of service composition are being largely acknowledged in the literature nowadays. However, as the amount of available services increases, it becomes difficult to manage, discover, select and compose them, so that automation is required in these processes. This can be achieved by using semantic information represented in ontologies. Currently there are many different approaches that support semantics-based service composition. However, still little effort has been spent on creating a common methodology to evaluate and compare such approaches. In this paper we present our initial ideas to create an evaluation framework for semantics-based service composition approaches. We use a collection of existing services, and define a set of evaluation metrics, confusion matrix-based and time-based. Furthermore, we present how composition evaluation scenarios are generated from the collection of services and specify the strategy to be used in the evaluation process. We demonstrate the proposed framework through an example. Currently there are mechanisms and initiatives to address the evaluation of the semantics-based service discovery and matchmaking approaches. However, still few efforts have been spent on the creation of comprehensive evaluation mechanisms for semantics-based service composition approaches.

show abstract

A Research of SQL-Based Web Services Automatic Generating Strategy

Cited by 2 publications

References 3 publications

Arquitectura para la generación de consultas SQL usando lógica de conjuntos

Arquitectura para la generación de consultas SQL usando lógica de conjuntos

A Framework for the Evaluation of Semantics-Based Service Composition Approaches

Contact Info

Product

Resources

About