A unified view of data-intensive flows in business intelligence systems : a survey

Data-intensive flows are central processes in today’s business intelligence (BI) systems, deploying different technologies to deliver data, from a multitude of data sources, in user-preferred and analysis-ready formats. To meet complex requirements of next generation BI systems, we often need an effective combination of the traditionally batched extract-transform-load (ETL) processes that populate a data warehouse (DW) from integrated data sources, and more real-time and operational data flows that integrate source data at runtime. Both academia and industry thus must have a clear understanding of the foundations of data-intensive flows and the challenges of moving towards next generation BI environments. In this paper we present a survey of today’s research on data-intensive flows and the related fundamental fields of database theory. The study is based on a proposed set of dimensions describing the important challenges of data-intensive flows in the next generation BI setting. As a result of this survey, we envision an architecture of a system for managing the lifecycle of data-intensive flows. The results further provide a comprehensive understanding of data-intensive flows, recognizing challenges that still are to be addressed, and how the current solutions can be applied for addressing these challenges.Peer ReviewedPostprint (author's final draft

BCAS: A Web-enabled and GIS-based Decision Support System for the Diagnosis and Treatment of Breast Cancer

For decades, geographical variations in cancer rates have been observed but the precise determinants of such geographic differences in breast cancer development are unclear. Various statistical models have been proposed. Applications of these models, however, require that the data be assembled from a variety of sources, converted into the statistical models’ parameters and delivered effectively to researchers and policy makers. A web-enabled and GIS-based system can be developed to provide the needed functionality. This article overviews the conceptual web-enabled and GIS-based system (BCAS), illustrates the system’s use in diagnosing and treating breast cancer and examines the potential benefits and implications for breast cancer research and practice

Examining Trends in the Nonresidential Building Construction Producer Price Indexes (PPIs)

In 2004, the Bureau of Labor Statistics (BLS) unveiled the Producer Price Index (PPI) nonresidential building construction initiative with the publication of an index for new warehouse building construction. PPI has since added nonresidential building construction indexes for schools, offices, industrial buildings, and health care buildings. This construction sector initiative is noteworthy as it expanded coverage into an important sector of the U.S. economy not previously measured by the PPI, and allowed the examination of different drivers of building construction inflation. According to Bureau of Economic Analysis (BEA) data, in the first quarter of 2005, the value of private fixed investment in structures totaled $1.137 trillion, representing about 8.9 percent of total gross domestic product (GDP). Of private fixed investment in structures, nonresidential structures alone represented$330.8 billion, or about 2.6 percent of total GDP. By the fourth quarter of 2013, nonresidential structures investments grew to $473.4 billion, or 2.8 percent of total GDP

The Workforce Investment Act of 1998: Performance Management and People With Disabilities

The primer outlines the various components of the Workforce Investment Act of 1998 (WIA). It also suggests ways that people with disabilities can fully access WIA systems and services.The report was prepared for the Rehabilitation Research and Training Center on Employment Policy for Persons with Disabilities and funded by the United States Department of Education, National Institute on Disability and Rehabilitation Research

XML content warehousing: Improving sociological studies of mailing lists and web data

In this paper, we present the guidelines for an XML-based approach for the sociological study of Web data such as the analysis of mailing lists or databases available online. The use of an XML warehouse is a flexible solution for storing and processing this kind of data. We propose an implemented solution and show possible applications with our case study of profiles of experts involved in W3C standard-setting activity. We illustrate the sociological use of semi-structured databases by presenting our XML Schema for mailing-list warehousing. An XML Schema allows many adjunctions or crossings of data sources, without modifying existing data sets, while allowing possible structural evolution. We also show that the existence of hidden data implies increased complexity for traditional SQL users. XML content warehousing allows altogether exhaustive warehousing and recursive queries through contents, with far less dependence on the initial storage. We finally present the possibility of exporting the data stored in the warehouse to commonly-used advanced software devoted to sociological analysis

Why Buffalo Needs Inclusionary Zoning: Affordability, Job Access, Inclusion, and Quality Housing

Buffalo’s housing market faces four severe challenges: affordability, job access, inclusiveness, and quality. Inclusionary zoning is a proven tool for addressing all four issues. Inclusionary zoning asks that when a developer creates new housing units, it reserve a certain percent for affordable housing. Thus, inclusionary zoning leverages the power of the market to create more high-quality affordable housing units, often near job centers and transit lines, and to make neighborhoods more inclusive and less segregated. In 2014, recognizing the need for more affordable housing, the City of Buffalo committed to “lobby for regional acceptance of inclusionary zoning provisions.” In 2016, hundreds of Buffalo residents submitted comments supporting the adoption of inclusionary zoning as part of the City’s new Green Code. In passing the Green Code, Common Council members promised to promptly take up and pass inclusionary zoning legislation. This brief presents data demonstrating Buffalo’s need for such legislation

Benchmarking performance management systems

The Balanced Scorecard and associated performance management approaches, has become a widely practiced and popular management reporting method in recent times. Moreover, enabling technology, which assists in the delivery and personalisation of corporate performance information, is having a deeper and more rapid impact than ever before. This paper presents a brief comparative benchmarking study of leading enterprise performance management systems. Also, the author discusses the merits of bespoke internet technology development and out-of-the-box portal functionalities. An analysis of key business drivers and implementation risks of such approaches is highlighted via a case study example, and concludes the paper