Aggregation Everywhere
نویسنده
چکیده
This paper describes the Phoenix system, which loads a data warehouse and then reports against it. Between the raw atomic data of the source system and the business measures presented to users there are many computing environments. Aggregation occurs everywhere: initial bucketing by the natural keys on the mainframe, loading the fact table using a mapping table, maintaining aggregate tables and reporting tables in the data base, in the GUI, in SQL queries issued on behalf of client tools by the web server, and inside the client tools themselves. Producing the desired business measures required writing a complex SQL query, and post-processing an Excel pivot table.
منابع مشابه
Smoothing Demand by Aggregation with Respect to Wealth
We sugges! in this paper to treat the problem of smoothing demand by aggregation in a two-step procedure, corresponding to the two different constituents of consumption characteristics. wealth and preferences. Instead of imposing a manifold structure on preferences we exploit the nice structure of wealth-space. The first step of this procedure, aggregation with respect to wealth. is carried out...
متن کاملA game-theoretic mechanism for aggregation and dispersal of interacting populations
We adapt a fitness function from evolutionary game theory as a mechanism for aggregation and dispersal in a partial differential equation (PDE) model of two interacting populations, described by density functions u and v. We consider a spatial model where individuals migrate up local fitness gradients, seeking out locations where their given traits are more advantageous. The resulting system of...
متن کاملRule of Law on the Go: New Developments of Mobile Governance
This paper offers an overview of the emerging domain of mobile governance as an offspring of the broader landscape of e-governance. Mobile governance initiatives have been deployed everywhere in parallel to the development of crowdsourced, open source software applications that facilitate the collection, aggregation, and dissemination of both information and data coming from different sources: ...
متن کاملChallenge Problem: Agent-Mediated Decentralized Information Mechanisms
Pervasive computing, driven by faster, cheaper and smaller devices, and wireless networking technology, promises to make people perpetual users of a massive and decentralized computational system. Pervasive computing blurs the boundary between the physical and the virtual. Information, always cheap to duplicate, now becomes cheap to generate everywhere. At once both the opportunities, such as f...
متن کاملWhodunit: An Auditing Tool for Detecting Data Breaches
Commercial database systems provide support to maintain an audit trail that can be analyzed offline to identify potential threats to data security. We present a tool that performs data auditing that asks for an audit trail of all users and queries that referenced sensitive data, for example “find all queries and corresponding users that referenced John Doe’s salary in the last six months”. Our ...
متن کامل