Graphical Web based Tool for Generating Query from Star Schema
نویسندگان
چکیده
This paper presents the development of a graphical SQL query tool that allows novice and non-technical users to navigate through database tables and generate their own queries. The tool enables the query output to be presented in graphical and tabular forms, which can help users, especially top management in better understanding and interpreting query results. The algorithms to construct complex SQL query from star schema in databases is also presented. Keyword: SQL Query Generation, Star Schema, Graphical and Tabular forms
منابع مشابه
An Approach for Generating an XML Data Warehouse Schema using Model Transformation Language
Traditionally, the multidimensional schema of the data warehouse is derived from data sources that are mainly the company’s internal data, well-known and structured, by identifying facts, dimensions and numeric measurements through a manual analysis of the operational schemas. With the proliferation of new platforms of communication in today’s information societies, there has been growing numbe...
متن کاملBusiness Rules for Data Warehouse
Business rules and data warehouse are concepts and technologies that impact a wide variety of organizational tasks. In general, each area has evolved independently, impacting application development and decision-making. Generating knowledge from data warehouse is a complex process. This paper outlines an approach to ease import of information and knowledge from a data warehouse star schema thro...
متن کاملSAMSTARplus: An Automatic Tool for Generating Multi- Dimensional Schemas from an Entity-Relationship Diagram
This paper presents a tool that automatically generates multidimensional schemas for data warehouses from OLTP entity-relationship diagrams (ERDs). Based on user’s input parameters, it generates star schemas, snowflake schemas, or a fact constellation schema by taking advantage of only structural information of input ERDs. Hence, SAMSTARplus can help users reduce efforts for designing data ware...
متن کاملNITELIGHT: A Graphical Editor for SPARQL Queries
Query formulation is a key aspect of information retrieval, contributing to both the efficiency and usability of many semantic applications. A number of query languages, such as SPARQL, have been developed for the Semantic Web; however, there are, as yet, few tools to support end users with respect to the creation and editing of semantic queries. In this paper we present NITELIGHT, a graphical ...
متن کاملTransforming XML Schemas into Java Swing GUIs
When designing an XML-based Web Content Management System (WCMS), one usually has to define and maintain two separate entities just for the editorial part: the database schemes (in the form of XML Schema instances) on the one hand and the graphical user interfaces (GUIs) for data maintenance on the other hand. In this paper we present a method for generating the GUIs automatically from the XML ...
متن کامل