Fig 2 - available via license: Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported
Content may be subject to copyright.
architecture of data warehousing SQL Server 2008 is used to develop the police intelligence system because it covers not only relational database management service, but also integrated service, analysis service and reporting service. Among them, integration service can help us to integrate data from different heterogeneous data sources, namely providing function of data extraction, transformation and load; analysis services provide us with function of OLAP and data mining which can help us to analyze the current situation and predict the future trend; reporting services provide us with various forms of data report and graphical display of the analysis result.
Source publication
Aiming at the large amounts of data collected by the public security organs, the technologies of data warehouse and OLAP are used to realize the police intelligence decision system based on SQL Server 2008 platform. The multidimensional analysis results reveal some potential regularity between criminal's action and the cases, so as to help the poli...
Citations
... Although there are some variations, most DW authors, scholars, researchers (e.g. Graham 1996;Gatziu and Vavouras 1999;Mohania et al., 1999;Ang and Teo 2000;Ji 2001;Wierda 2003;Aiello 2004 p. 125;Hwang et al., 2004;AbuSaleem 2005 p. 10-11;Conradie 2005 p. 58-59;Malinowski and Zimányi 2008 p. 3;Ong et al., 2011;Shen et al., 2012;Cosma et al., 2013;Kimpel and Morris 2013) share the four salient characteristics of DW by Bill Inmon a leading data warehousing scholar. ...
... In addition, at Hallmark there were large outcomes from using DW, including integrating multiple data sources (both internal and external), conducting complex analyses at any level and the ability of manufacturers to expand their distribution channels by analyzing all of the available data in order to understand the impact of new distribution strategies. Shen et al., (2012), who examined the implementation of DW in public security, found that the DW is very important in improving the comprehensive ability of leadership and decision-making. In addition, it quickly and efficiently integrates heterogeneous data sources. ...
... p. 1), DW has become an important strategy to integrate he terogeneous data sources and to enable OLAP due to the inappropriateness of OLTP for supporting decisions. DSSs place different requirements on database technology, wherein DW and OLAP are the essential elements, which have increasingly become the focus of database industry, in comparison with OLTP applications(Shen et al., 2012).Juergens (2002) claims that OSs do not support the extraction of information out of databases efficiently because they are not designed for that kind of queries. In contrast to OLTP applications which read/write data from the operational databases, a DSS only reads data to get new information from the ...
... In the government area, the data warehouse in China's police intelligence decision system helps the policeman to explore the dynamic crime trends and characteristics from the integrated heterogeneous data sources. It is to help them making the correct judgments (Shen, Liu, Chen, & Wang, 2012). Otherwise, the modelling of data warehouse on food distribution center and reserves in the ministry of agriculture of Indonesia can facilitate monitoring food price in consumers and producers. ...
The goals of the research is to develop a data warehouse loaded from operational database of payment point service in IT business solution provider. The development scope is data analysis using Online Analytical Processing (OLAP) tools for identifying the trends of transaction and agent registration, and create reports and dashboards. The data warehouse was developed with Kimball method as known as the nine-step design methodology. The data and requirement were collected by observation and interview with Chief Technology Officer (CTO). The data warehouse was analyzed by OLAP tool provided by Pentaho Business Analytics software with additional plugin Pivot4J. The obtained results are the trends of transaction
and agent registration between 2014 and 2015. It can be concluded that developed data warehouse can be used as ananalysis tool to know the trends information.
... But if use special police big data system, it may be done by a few hours, which will undoubtedly increase the work efficiency. So the application of big data has an impact on policing [9]. In the era of the big data, police officers need to become digital personnel in order to meet the needs of the development of modern police. ...
... (Ponniah, 2001). Aplikasi OLAP dapat memungkinan pengguna mengamati data secara multidimensional (Shen, Liu, Chen, & Wang, 2012). ...
Abstrak— Analisis data pada perguruan tinggi dapat membantu pihak perguruan tinggi baik dalam melihat perkembangan perguruan tinggi ataupun pengambilan keputusan, analisis data dapat berupa data dari hasil akademik mahasiswa, kontribusi dosen terhadap penilitian ataupun data-data lain, dengan kombinasi datawarehouse dan OLAP (Online Analytical Proccessing) dapat memberikan hasil baik berupa data konkrit ataupun grafik untuk data-data yang diinginkan oleh pengguna aplikasi. Pada penelitian ini aplikasi OLAP dapat dikembangkan dengan metode waterfall yang digabungkan dengan metode evolusioner untuk tujuan pemenuhan kebutuhan pengguna yang optimal dan menghasilkan aplikasi dengan struktur yang baik oleh pengembang aplikasi. Penelitian ini berhasil menerapkan penggabungan metode pengembangan waterfall dan evolusioner dan hasil penelitian ini membuktikan bahwa aplikasi OLAP dapat dibangun dengan struktur dan dokumentasi yang baik serta menerima perubahan dari pengguna dengan dinamis.
... [48] found that all companies, which are studied, recognized some benefits such as cost reduction, reach-out to other markets, increase in sales, time saving in amount and preparation of reports and more effective decision-making based on the obtained information. [49], who conducted two case studies on American Airlines and Hallmark Cards, found the easy to use, speedy information retrieval, more information, better quality information, improved productivity, and better decisions as benefits of DW. [50], who examined the implementation of DW in public security, found that the DW is very important in improving the comprehensive ability of leadership and decision-making. In addition, it quickly and efficiently integrates heterogeneous data sources. ...
... [48] found that all companies, which are studied, recognized some benefits such as cost reduction, reach-out to other markets, increase in sales, time saving in amount and preparation of reports and more effective decision-making based on the obtained information. [49], who conducted two case studies on American Airlines and Hallmark Cards, found the easy to use, speedy information retrieval, more information, better quality information, improved productivity, and better decisions as benefits of DW. [50], who examined the implementation of DW in public security, found that the DW is very important in improving the comprehensive ability of leadership and decision-making. In addition, it quickly and efficiently integrates heterogeneous data sources. ...
The main purpose of conducting this research is to investigate empirically the role and importance of data warehouse (DW) in enhancing the effectiveness of decision-making. It is believed and assumed that meaningful and significant information can be acquired from DW which provides valuable knowledge to support business process and decision-making. A mail questionnaire survey was regarded as the appropriate method for gathering data. The questionnaire was developed based on the findings from related literature and other related research questionnaires. All the firms (277), which were listed on Amman Stock Exchange (ASE), at the time of data collection, were selected. The researchers arrived at scores of significant and remarkable results regarding DW and its role in enhancing the process of decision-making. The survey’s findings showed that the percentage of implementing DW in the Jordanian firms involved is 35 %. In general, the respondents had a positive attitude towards the implementation of DW.
... Although there are some variations, most DW authors, scholars, researchers (e.g. Graham 1996;Gatziu and Vavouras 1999;Mohania et al., 1999;Ang and Teo 2000;Ji 2001;Wierda 2003;Aiello 2004 p. 125;Hwang et al., 2004;AbuSaleem 2005 p. 10-11;Conradie 2005 p. 58-59;Malinowski and Zimányi 2008 p. 3;Ong et al., 2011;Shen et al., 2012;Cosma et al., 2013;Kimpel and Morris 2013) share the four salient characteristics of DW by Bill Inmon a leading data warehousing scholar. ...
... In addition, at Hallmark there were large outcomes from using DW, including integrating multiple data sources (both internal and external), conducting complex analyses at any level and the ability of manufacturers to expand their distribution channels by analyzing all of the available data in order to understand the impact of new distribution strategies. Shen et al., (2012), who examined the implementation of DW in public security, found that the DW is very important in improving the comprehensive ability of leadership and decision-making. In addition, it quickly and efficiently integrates heterogeneous data sources. ...
... p. 1), DW has become an important strategy to integrate he terogeneous data sources and to enable OLAP due to the inappropriateness of OLTP for supporting decisions. DSSs place different requirements on database technology, wherein DW and OLAP are the essential elements, which have increasingly become the focus of database industry, in comparison with OLTP applications(Shen et al., 2012).Juergens (2002) claims that OSs do not support the extraction of information out of databases efficiently because they are not designed for that kind of queries. In contrast to OLTP applications which read/write data from the operational databases, a DSS only reads data to get new information from the ...
The role of activity based costing in decision making
... and better information, improved user ability to produce information and reduced effort by developers to produce information. [41] also maintain that DWs have tremendous potential to present information. The greatest potential benefits of the DW occur when it is used to redesign business processes and to support strategic business objectives [30]. [42] also identified many different measures of success; these include benefits such as data accuracy, useful information, accurate information, ease of use, user satisfaction, time to make decision and increased revenue. However, [43] claims that despite clear evidences that many DW projects have resulted in interesting business benefits, t ...
The main objective of conducting this research is to investigate empirically the role of data warehouse (DW) in enhancing decision-making or, more precisely, the researchers surveyed the top management of Jordanian firms regarding the role and importance of DW in improving the effectiveness of decision-making. It is believed and assumed that meaningful and significant information can be acquired from DW which provides valuable knowledge to support business process and decision-making. A mail questionnaire survey was regarded as the appropriate method for gathering data. The questionnaire was developed based on the findings from related literature and other related research questionnaires. All the firms (277), which were listed on Amman Stock Exchange (ASE), at the time of data collection, were selected over half answered positively. The researchers arrived at scores of significant and remarkable results regarding DW and its role in enhancing the process of decision-making. The survey's findings showed that the percentage of implementing DW in the Jordanian firms involved is 35%. In general, the respondents had a positive attitude towards the implementation of DW.
