269,486 research outputs found

    SODA: Generating SQL for Business Users

    Full text link
    The purpose of data warehouses is to enable business analysts to make better decisions. Over the years the technology has matured and data warehouses have become extremely successful. As a consequence, more and more data has been added to the data warehouses and their schemas have become increasingly complex. These systems still work great in order to generate pre-canned reports. However, with their current complexity, they tend to be a poor match for non tech-savvy business analysts who need answers to ad-hoc queries that were not anticipated. This paper describes the design, implementation, and experience of the SODA system (Search over DAta Warehouse). SODA bridges the gap between the business needs of analysts and the technical complexity of current data warehouses. SODA enables a Google-like search experience for data warehouses by taking keyword queries of business users and automatically generating executable SQL. The key idea is to use a graph pattern matching algorithm that uses the metadata model of the data warehouse. Our results with real data from a global player in the financial services industry show that SODA produces queries with high precision and recall, and makes it much easier for business users to interactively explore highly-complex data warehouses.Comment: VLDB201

    The lingua franca of Nominalism. Sellars on Leibniz

    Get PDF
    The paper is not built upon a single central thesis. It has been composed as an attempt to investigate a virtually unexplored theme of inquiry. A kind of historiographical thesis may be put in the following terms: Leibniz can be counted among the remote, but still significant, sources of Sellars's philosophy. Such thesis, however, is meaningless unless its conceptual relevance is displayed. Therefore, it will be immediately added that Sellars's relation with Leibniz is focused on three main fundamental issues, which respectively concern (1) the concept of nature, (2) the concept of truth and (3) the concept itself of nominalism. Besides, there are other seemingly minor topics, which actually refers to the definition of abstract entities, of predicates, of proper names and to the datum/factum distinction. Another challenge the paper is faced with, regards the fact that Sellars does not consider Leibniz only in himself, given that he very often positions him in a close relation to Kant: it is as though there were multifaceted issues brought forward by Leibniz and Kant together forming a complex theoretical unity (over and above their differences). According to Sellars, in fact, they both undermine some of the most solid epistemological principles of the early modern times (mainly founded upon the subject- object lexicon and the idea of veritas as adaequatio rei et intellectus) and they both reshape the meaning of expressions such as \u201cbeing actual\u201d or \u201cbeing true\u201d

    The Julius Caesar objection

    Get PDF
    This paper argues that that Caesar problem had a technical aspect, namely, that it threatened to make it impossible to prove, in the way Frege wanted, that there are infinitely many numbers. It then offers a solution to the problem, one that shows Frege did not really need the claim that "numbers are objects", not if that claim is intended in a form that forces the Caesar problem upon us

    Ada style guide (version 1.1)

    Get PDF
    Ada is a programming language of considerable expressive power. The Ada Language Reference Manual provides a thorough definition of the language. However, it does not offer sufficient guidance on the appropriate use of Ada's powerful features. For this reason, the Goddard Space Flight Center Ada User's Group has produced this style guide which addresses such program style issues. The guide covers three areas of Ada program style: the structural decomposition of a program; the coding and the use of specific Ada features; and the textural formatting of a program
    • …
    corecore