The big data upgrade : new dimensions in data analysis - risks and opportunities [das big data upgrade : neue dimensionen der datennutzung – chancen und risiken]

Summary: More than ever before contemporary societies are characterised by the huge amounts of data being transferred. Authorities, companies, academia and other stakeholders refer to Big Data when discussing the importance of large and complex datasets and developing possible solutions for their use. Big Data promises to be the next frontier of innovation for institutions and individuals, yet it also offers possibilities to predict and influence human behaviour with ever-greater precision

Water Sensitive Urban Design (WSUD) application auditing

Background WSUD implementation in the Gold Coast City Council area commenced more than a decade ago. As a result, Council is expected to be in possession of WSUD assets valued at over tens of million dollars. The Gold Coast City Council is responsible for the maintenance and long-term management of these WSUD assets. Any shortcoming in implementation of best WSUD practices can potentially result in substantial liabilities and ineffective expenditure for the Council in addition to reduced efficiencies and outcomes. This highlights the importance of periodic auditing of WSUD implementation. Project scope The overall study entailed the following tasks: * A state-of-the-art literature review of the conceptual hydraulic and water quality treatment principles, current state of knowledge in relation to industry standards, best practice and identification of knowledge gaps in relation to maintenance and management practices and potential barriers to the implementation of WSUD. * Council stakeholder interviews to understand current practical issues in relation to the implementation of WSUD and the process of WSUD application from development application approval to asset management. * Field auditing of selected WSUD systems for condition assessment and identification of possible strengths and weaknesses in implementation. * Review of the Land Development Guidelines in order to identify any gaps and to propose recommendations for improvement. Conclusions Given below is a consolidated summary of the findings of the study undertaken. State-of-the-art literature review Though the conceptual framework for WSUD implementation is well established, the underlying theoretical knowledge underpinning the treatment processes and maintenance regimes and life cycle costing are still not well understood. Essentially, these are the recurring themes in the literature, namely, the inadequate understanding of treatment processes and lack of guidance to ensure specificity of maintenance regimes and life cycle costing of WSUDs. The fundamental barriers to successful WSUD implementation are: * Lack of knowledge transfer – This essentially relates to the lack of appropriate dissemination of research outcomes and the common absence of protocols for knowledge transfer within the same organisation. * Cultural barriers – These relate to social and institutional factors, including institutional inertia and the lack of clear understanding of the benefits. * Fragmented responsibilities – This results from poor administrative integration within local councils in relation to WSUDs. * Technical barriers – These relate to lack of knowledge on operational and maintenance practices which is compounded by model limitations and the lack of long-term quantitative performance evaluation data. * Lack of engineering standards – Despite the availability of numerous guidelines which are non-enforceable and can sometimes be confusing, there is a need for stringent engineering standards. The knowledge gaps in relation to WSUDs are only closing very slowly. Some of the common knowledge gaps identified in recent publications have been recognised almost a decade ago. The key knowledge gaps identified in the published literature are: * lack of knowledge on operational and maintenance practices; * lack of reliable methodology for identifying life cycle issues including costs; * lack of technical knowledge on system performance; * lack of guidance on retrofitting in existing developments. Based on the review of barriers to WSUD implementation and current knowledge gaps, the following were identified as core areas for further investigation: * performance evaluation of WSUD devices to enhance model development and to assess their viability in the context of environmental, economic and social drivers; establishing realistic life cycle costs to strengthen maintenance and asset management practices; * development of guidelines specific to retrofitting in view of the unique challenges posed by existing urban precincts together with guidance to ensure site specificity; establishment of a process for knowledge translation for enhancing currently available best practice guidelines; * identification of drivers and overcoming of barriers in the areas of institutional fragmentation, knowledge gaps and awareness of WSUD practices. GCCC stakeholder interviews Fourteen staff members involved in WSUD systems management in the Gold Coast City Council, representing four Directorates were interviewed using a standard questionnaire. The primary issues identified by the stakeholders were: * standardisation of WSUD terminology; * clear protocols for safeguarding devices during the construction phase; * engagement of all council stakeholders in the WSUD process from the initial phase; * limitations in the Land Development Guidelines; * ensuring public safety through design; * system siting to avoid conflicts with environmental and public use of open space; * provision of adequate access for maintenance; * integration of social and ecosystem issues to ensure long-term viability of systems in relation to both, vandalism and visual recreation; * lack of performance monitoring and inadequacy of the maintenance budget; * lack of technical training for staff involved in WSUD design approvals and maintenance; incentives for developers for acting responsibly in stormwater management. Field auditing of WSUD systems A representative cross section of WSUD systems in the Gold Coast were audited in the field. The following strengths and weaknesses in WSUD implementation were noted: * The implementation of WSUD systems in the field is not consistent. * The concerns raised by the stakeholders during the interviews in relation to WSUD implementation was validated from the observations from the field auditing, particularly in relation to the following: * safeguarding of devices during the construction phase * public safety * accessibility for maintenance * lack of performance monitoring by Council to assess system performance * inadequate maintenance of existing systems to suit site specific requirements. * A treatment train approach is not being consistently adopted. * Most of the systems audited have satisfactorily catered for public safety. Accessibility for maintenance has been satisfactorily catered for in most of the systems that were audited. * Systems are being commissioned prior to construction activities being substantially completed. * The hydraulic design of most systems appears to be satisfactory. * The design intent of the systems is not always clear. Review of Land Development Guidelines The Land Development Guidelines (TDG) was extensively reviewed and the following primary issues were noted in relation to WSUD implementation: * the LDG appears to have been prepared primarily to provide guidance to developers. It is not clear to what extent the guidelines are applicable to Council staff involved in WSUD maintenance and management; * Section 13 is very voluminous and appears to be a compilation of a series of individual documents resulting in difficulties in locating specific information, a lack of integration and duplication of information; * the LDG has been developed with a primary focus on new urban precinct development and the retrofitting of systems in existing developments has not been specifically discussed; * WSUDs are discussed in two different sections in the LDG and it is not clear which section takes precedence as there are inconsistencies between the two sections; there is inconsistent terminology being used; * there is a need for consolidation of information provided in different sections in the LDG; * there are inconsistencies in the design criteria provided; * there is a need for regular updating of the LDG to ensure that the information provided encompasses the state-of-the-art; * there is limited guidance provided for the preparation of maintenance plans and life cycle costing to assist developers in asset handover and to assist Council staff in assessment. * Based on these observations, eleven recommendations have been provided which are discussed below. Additionally, the stakeholder provided the following specific comments during the interviews in relation to the LDG: * lack of flexibility to cover the different stages of the life cycle of the systems; * no differentiation in projects undertaken by developers and Council; * inadequate information with regards to safety issues such as maximum standing water depth, fencing and safety barriers and public access; * lack of detailed design criteria in relation to Crime Prevention through Environmental Design, safety, amenity, environment, surrounding uses and impacts on surroundings; * inadequate information regarding maintenance requirements specific to the assessment and compliance phases; * recommendations for plantings are based primarily on landscape requirements rather than pollutant uptake capability. Recommendations With regards to the Land Development Guidelines, the following specific recommendations are provided: 1. the relevant sections and their extent of applicability to Council should be clearly identified; 2. integration of the different subsections within Section 13 and re-formatting the document for easy reference; 3. the maintenance guidelines provided in Section 13 should be translated to a maintenance manual for guidance of Council staff; 4. should consider extending the Guidelines to specifically encompass retrofitting of WSUD systems to existing urban precincts; 5. Section 3 needs to be revised to be made consistent with Section 13, to ensure priority for WSUD practices in urban precincts and to move away from conventional stormwater drainage design such as kerb and channelling; 6. it would also be good to specify as to which Section takes predominance in relation to stormwater drainage. It is expected that Section 13 would take predominance over the other sections in the LDG; 7. terminology needs to be made consistent to avoid confusion among developers and Council staff. Water Sensitive Urban Design is the term commonly used in Australia for stormwater quality treatment, rather than Stormwater Quality Improvement Devices. This once again underlines the need for ensuring consistency between Section 3 and Section 13; 8. it would also be good if there is a glossary of commonly used terms in relation to WSUD for use by all stakeholders and which should also be reflected in the LDG; 9. consolidation of all WSUD information into one section should be considered together with appropriate indicators in other LDG Sections regarding the availability of WSUD information. Ensuring consistency in the information provided is implied; 10. Section 13 should be updated at regular intervals to ensure the incorporation of the latest in research outcomes and incorporating criteria and guidance based on the state-of-the-art knowledge. The updating could be undertaken, say, in five year cycles. This would help to overcome the current lack of knowledge transfer; 11. the Council should consider commissioning specialised studies to extend the current knowledge base in relation to WSUD maintenance and life cycle costing. Additionally, Recommendation 10 is also applicable in this instance. The following additional recommendations are made based on the state-of-the-art literature review, stakeholder interviews and field auditing of WSUD systems: 1. Performance monitoring of existing systems to assess improvements to water quality, identify modifications and enhancements to improve performance; 2. Appropriate and monitored maintenance during different phases of development of built assets over time is needed to investigate the most appropriate time/phase of development to commission the final WSUD asset. 3. Undertake focussed investigations in the areas of WSUD maintenance and asset management in order to establish more realistic life cycle costs of systems and maintenance schedules; 4. the engagement of all relevant Council stakeholders from the initial stage of concept planning through to asset handover, and ongoing monitoring. This close engagement of internal stakeholders will assist in building a greater understanding of responsibilities and contribute to overcoming constraints imposed by fragmented responsibilities; 5. the undertaking of a public education program to inform the community of the benefits and ecosystem functions of WSUD systems; 6. technical training to impart state-of-the-art knowledge to staff involved in the approval of designs and maintenance and management of WSUD projects; 7. during the construction phase, it is important to ensure that appropriate measures to safeguard WSUD devices are implemented; 8. risks associated with potential public access to open water zones should be minimised with the application of appropriate safety measures; 9. system siting should ensure that potential conflicts are avoided with respect to public and ecosystem needs; 10. integration of social and ecosystem issues to ensure long-term viability of systems; provide incentives to developers who are proactive and responsible in the area of stormwater management.

The growing demand for emergency healthcare

Emergency health is a critical component of health systems; one increasingly congested from growing demand and blocked access to care. The Emergency Health Services Queensland (EHSQ) study aimed to identify the factors driving increased demand for emergency healthcare. This study examined data on patients treated by the ambulance service and Emergency Departments across Queensland. Data was derived from the Queensland Ambulance Service’s (QAS) Ambulance Information Management System and electronic Ambulance Report Form and from the Emergency Department Information System (EDIS). Data was obtained for the period 2001-02 through to 2009-10. A snapshot of users for the 2009-10 year was used to describe the characteristics of users and comparisons made with the year 2003-04 to identify trends. Per capita demand for EDs has increased by 2% per annum over the decade and for ambulance by 3.7% per annum. The growth in ED demand is most significant in more urgent triage categories with decline in less urgent patients. The growth is most prominent amongst patients suffering injuries and poisoning, amongst both men and women and across all age groups. Patients from lower socioeconomic areas appear to have higher utilisation rates and the utilisation rate for indigenous people exceeds those of other backgrounds. The utilisation rates for immigrant people is less than Australian born however it has not been possible to eliminate the confounding impact of age and socioeconomic profiles. These findings contribute to an understanding of the growth in demand for emergency health. It is evident that the growth is amongst patients in genuine need of emergency healthcare and public rhetoric that congested emergency health services is due to inappropriate attendees is unsustainable. The growth in demand over the last decade reflects not only on changing demographics of the Australian population but also changes in health status, standards of acute health care and other social factors.

Regulatory Impact Assessment of Potential Duplication of Governance and Reporting Standards for Charities

On 25 January 2013, the Council of Australian Governments (COAG) released a Regulatory Impact Assessment (RIA) for consultation on ways to reduce regulatory duplication between the proposed Commonwealth governance and reporting standards and existing state and territory requirements.

Clinical data integration approach using SAS clinical data integration server (CDI) tools

The decisions people make about medical treatments have a great impact on their lives. Health care practitioners, providers and patients often make decisions about medical treatments without complete understanding of the circumstances. The main reason for this is that medical data are available in fragmented, disparate and heterogeneous data silos. Without a centralised data warehouse structure to integrate these data silos, it is highly unlikely and impractical for the users to get all the information required on time to make a correct decision. In this research paper, a clinical data integration approach using SAS Clinical Data Integration Server tools is presented.

Developing and delivering a software internationalisation subject

This paper describes the content and delivery of a software internationalisation subject (ITN677) that was developed for Master of Information Technology (MIT) students in the Faculty of Information Technology at Queensland University of Technology. This elective subject introduces students to the strategies, technologies, techniques and current development associated with this growing 'software development for the world' specialty area. Students learn what is involved in planning and managing a software internationalisation project as well as designing, building and using a software internationalisation application. Students also learn about how a software internationalisation project must fit into an over-all product localisation and globalisation that may include culturalisation, tailored system architectures, and reliance upon industry standards. In addition, students are exposed to the different software development techniques used by organizations in this arena and the perils and pitfalls of managing software internationalisation projects.

A systematic review of the literature comparing the practices of dispensing and non-dispensing doctors

Objectives: Some doctors perform the dual roles of prescribing and dispensing pharmaceuticals. The dispensing doctors (DDs) role may give rise to prescribing behaviours that vary from those of non-DDs. The aim of this review was to systematically and comparatively appraise the research evidence related to the practices of DDs. Methods: A systematic search of bibliographic databases and reference lists from selected papers were the sources of the data. Inclusion criteria were papers published in English, between 1970 and 2008 that provided quantitative data comparing the practices of DDs and non-DDs. At least two of the authors abstracted data from all eligible papers using a purpose-made data extraction form. Results: Twenty-one papers were included in this review. Evidence indicated that DDs prescribed more pharmaceutical items and less often generically than non-DDs. There was limited evidence to suggest that DDs prescribed less judiciously and were associated with poor dispensing standards. Patient convenience and access to pharmaceuticals were main reasons for doctors to dispense. Conclusion: DDs can fill an important gap in the provision of pharmaceuticals for their patients especially where health workforce shortages exist. There was evidence the dispensing role influenced prescribing. Patient convenience should be balanced against scarce medical resources, being utilised for dispensing.

How to Improve Cardiac Surgery Decision Making? In Data Warehousing Perspective

The health system is one sector dealing with very large amount of complex data. Many healthcare organisations struggle to utilise these volumes of health data effectively and efficiently. Therefore, there is a need for very effective system to capture, collate and distribute this health data. There are number of technologies have been identified to integrate data from different sources. Data warehousing is one technology can be used to manage clinical data in the healthcare. This paper addresses how data warehousing assist to improve cardiac surgery decision making. This research used the cardiac surgery unit at the Prince Charles Hospital (TPCH) as the case study. In order to deal with other units efficiently, it is important to integrate disparate data to a single point interrogation. We propose implementing a data warehouse for the cardiac surgery unit at TPCH. The data warehouse prototype developed using SAS enterprise data integration studio 4.2 and data was analysed using SAS enterprise edition 4.3. This improves access to integrated clinical and financial data with, improved framing of data to the clinical context, giving potentially better informed decision making for both improved management and patient care.

Over time assessment data analysis tracking a school's on-going performance

In Australia, as in some other western nations, governments impose accountability measures on educational institutions (Earl, 2005). One such accountability measure is the National Assessment Program - Literacy and Numeracy (NAPLAN) from which high-stakes assessment data is generated. In this article, a practical method of data analysis known as the Over Time Assessment Data Analysis (OTADA) is offered as an analytical process by which schools can monitor their current and over time performances. This analysis developed by the author, is currently used extensively in schools throughout Queensland. By Analysing in this way, teachers, and in particular principals, can obtain a quick and insightful performance overview. For those seeking to track the achievements and progress of year level cohorts, the OTADA should be considered.

Data warehousing model for integrating fragmented electronic health records from disparate and heterogeneous clinical data stores

This research was a step forward in developing a data integration framework for Electronic Health Records. The outcome of the research is a conceptual and logical Data Warehousing model for integrating Cardiac Surgery electronic data records. This thesis investigated the main obstacles for the healthcare data integration and proposes a data warehousing model suitable for integrating fragmented data in a Cardiac Surgery Unit.

P.I.C.U., H.D.U., A.O.A. What treatment do we provide?: Current descriptions of the function of intensive care for inpatient Psychiatric Health Care.

Purpose – This paper adds to growing research of psychiatric intensive care units (PICU) by recounting descriptions of psychiatric intensive care settings and discusses the perceptions held by nurses of the organisational interfaces, arrangements and provisions of care in these settings. Design/methodology/approach – Data gathered from focus groups held with nurses from two PICUs was used to establish terminology, defining attributes, related concepts, antecedents, values, processes and concepts related to current practices. A literature search was conducted to permit a review of the conceptual arrangements and contemporary understanding of intensive care for people experiencing acute psychiatric illness based on the perspectives held by the nurses from the focus groups. Findings – Dissonance between service needs and the needs and management of individual patients overshadow strategies to implement comprehensive recovery-oriented approaches. Three factors are reported in this paper that influence standards and procedural practice in PICU; organisational structures; physical structures; and subtype nomenclature. Practical implications – Acute inpatient care is an important part of a comprehensive approach to mental health services. Commonly intensive acute care is delivered in specialised wards or units co-located with acute mental health inpatient units mostly known as PICU. Evidence of the most effective treatment and approaches in intensive care settings that support comprehensive recovery for improved outcomes is nascent. Originality/value – Current descriptions from nurses substantiate wide variations in the provisions, design and classifications of psychiatric intensive care. Idiosyncratic and localised conceptions of psychiatric intensive care are not adequately entailing effective treatment and methods in support of recovery principles for improved and comprehensive outcomes. The authors suggest that more concrete descriptions, guidelines, training and policies for provision of intensive psychiatric health care encompassing the perspective of nursing professionals, would reinforce conceptual construction and thus optimum treatments within a comprehensive, recovery-oriented approach to mental health services.

Standardisation of plant and machinery valuation practices in Malaysia

Plant and machinery valuation is important to every company.s annual financial reporting. It is reported under the non-current assets section, and the valuers are generally employed to provide the up to date valuation of the non-current assets valuation such as property, plant and equipment that can make up to 80% of the total assets of a company. The valuation of plant and machinery is also important for other purposes such as securing loan facilities, sales, takeover, insurance and auction. The application of 2005 International Financial Reporting Standard (IFRS) has a subsequent impact on the financial sector, as a whole. The accountants have to choose between the Historical Cost approach and Market Value approach in determining the value of the client.s assets. In Malaysia, the implementation of IFRS has a domino effect on the financial system, especially for plant and machinery valuation for financial reporting. The comparison data for plant and machinery valuation is limited unlike land and building valuation. The question of Malaysian valuer.s ability to comply with the IFRS standard keeps rising every day, not just to the accountants, but also other related parties such as financial institutions, government agencies and the clients. This is happening because of different interpretations of premise of value for plant and machinery, as well as methods been used and differences in standards of reporting among the valuers conducting plant and machinery valuation. The root of the problem lies in the lack of practical guidelines governing plant and machinery valuation practices and different schools of thought among the valuers. Some follow the United Kingdom.s RICS guidelines, whilst some valuers are more comfortable with the United State.s USPAP rules, especially on the premise of value. This research is to investigate the international best practices of plant and machinery valuation and to establish the common valuation concept, awareness and application of valuation methodology and valuation process for plant and machinery valuation in Malaysia. This research uses a combination of the qualitative and quantitative research approach. In the qualitative approach, the content analyses were conducted from the international practices and current Malaysian implementation of plant and machinery valuation. A survey (quantitative approach) via questionnaire was implemented among the registered and probationary valuers in Malaysia to investigate their understanding and opinion relating to plant and machinery valuation based on the current practices. The significance of this research is the identification of international plant and machinery practices and the understanding of current practices of plant and machinery valuation in Malaysia. It is found that issues embedding plant and machinery valuation practices are limited numbers of resources available either from scholars or practitioner. This is supported by the general finding from the research survey that indicates that there are immediate needs for practical notes or guidelines to be developed and implemented to support the Malaysian valuers practising plant and machinery valuation. This move will lead to a better understanding of plant and machinery valuation, reducing discrepancies in valuation of plant and machinery and increased accuracy among practising valuers.

Improved earthwork allocation planning for fuel consumption and emissions reduction in linear infrastructure construction – case study data

This document provides data for the case study presented in our recent earthwork planning papers. Some results are also provided in a graphical format using Excel.

Energy efficient virtual machine placement in data centers

Electricity cost has become a major expense for running data centers and server consolidation using virtualization technology has been used as an important technology to improve the energy efficiency of data centers. In this research, a genetic algorithm and a simulation-annealing algorithm are proposed for the static virtual machine placement problem that considers the energy consumption in both the servers and the communication network, and a trading algorithm is proposed for dynamic virtual machine placement. Experimental results have shown that the proposed methods are more energy efficient than existing solutions.

Assessing the suitability of existing spatial data for disaster planning and mitigation in Queensland

The Council of Australian Governments (COAG) in 2003 gave in-principle approval to a best-practice report recommending a holistic approach to managing natural disasters in Australia incorporating a move from a traditional response-centric approach to a greater focus on mitigation, recovery and resilience with community well-being at the core. Since that time, there have been a range of complementary developments that have supported the COAG recommended approach. Developments have been administrative, legislative and technological, both, in reaction to the COAG initiative and resulting from regular natural disasters. This paper reviews the characteristics of the spatial data that is becoming increasingly available at Federal, state and regional jurisdictions with respect to their being fit for the purpose for disaster planning and mitigation and strengthening community resilience. In particular, Queensland foundation spatial data, which is increasingly accessible by the public under the provisions of the Right to Information Act 2009, Information Privacy Act 2009, and recent open data reform initiatives are evaluated. The Fitzroy River catchment and floodplain is used as a case study for the review undertaken. The catchment covers an area of 142,545 km2, the largest river catchment flowing to the eastern coast of Australia. The Fitzroy River basin experienced extensive flooding during the 2010–2011 Queensland floods. The basin is an area of important economic, environmental and heritage values and contains significant infrastructure critical for the mining and agricultural sectors, the two most important economic sectors for Queensland State. Consequently, the spatial datasets for this area play a critical role in disaster management and for protecting critical infrastructure essential for economic and community well-being. The foundation spatial datasets are assessed for disaster planning and mitigation purposes using data quality indicators such as resolution, accuracy, integrity, validity and audit trail.