scholarly journals Analisis Alat Bantu Tuning Fisikal Basis Data pada Sql Server 2008

2014 ◽  
Vol 5 (1) ◽  
pp. 334
Author(s):  
Marlene Martani ◽  
Hanny Juwitasary ◽  
Arya Nata Gani Putra
Keyword(s):  
Information Technology ◽  
Query Processing ◽  
Query Optimization ◽  
Business Processes ◽  
Database System ◽  
Sql Server ◽  
Process Data ◽  
Analysis Of Technique ◽  
Tuning Methods ◽  
Application Tuning

Nowadays every company has been faced with a business competition that requires the company to survive and be superior to its competitors. One strategy used by many companies is to use information technology to run their business processes. The use of information technology would require a storage which commonly referred to as a database to store and process data into useful information for the company. However, it was found that the greater the amount of data in the database, then the speed of the resulting process will decrease because the time needed to access the data will be much longer. The long process of data can cause a decrease in the company’s performance and the length of time needed to make decisions so that this can be a challenge to achieve the company’s competitive advantage. In this study performed an analysis of technique to improve the performance of the database system used by the company to perform tuning on SQL Server 2008 database physically. The purpose of this study is to improve the performance of the database used by speeding up the time it takes when doing query processing. The research methodology used was the method of analysis such as literature studies, analysis of the process and the workings of tuning tools that already exist in SQL Server 2008, and evaluation of applications that have been created, and also tuning methods that include query optimization and create index. The results obtained from this study is an evaluation of the physical application tuning tools that can integrate database functionality of other tuning tools such as SQL Profiler and Database Tuning Advisor.

scholarly journals PERANCANGAN ENTERPRISE ARCHITECTURE PLANNING DENGAN ZACHMAN FRAMEWORK (STUDI KASUS : CV.RIA KENCANA UNGU)

2020 ◽  
Vol 1 (2) ◽  
pp. 59-68
Author(s):  
Deby Tri Sundari ◽  
Novri Hadinata
Keyword(s):  
Information Technology ◽  
Enterprise Architecture ◽  
Business Processes ◽  
Process Data ◽  
Data Services ◽  
Technology Investment ◽  
Transaction Process ◽  
Data Source ◽  
Zachman Framework

well- organized data in one managed data source is the goal of company development to make this happen, strategy and planning are needed. It is known  that  Cv. Ria Kencana Ungu requires  management in the development  of information technology. One problem faced by RKU Computer is the application of business process design, most of which have not used the system and are still manually recording to copy transaction process data as well as reporting  data  services  so  that  the  data  processing  is  not  yet  used.  effective  and  not  sustainable.  The implementation of enterprise architecture planning with the zachman framework results achieved in the implementation of enterprise architecture planning to produce a blueprint that can serve as a guideline that can illustrate designing architecture in Cv. Ria Kencana Ungu is proven to be very important for an enterprise. With the proposed application candidates can improve information systems based on current business processes so that the need for information technology that supports business needs can be a reference in long-term technology investment in Cv. Ria Kencana Ungu. Pentingnya sebuah data yang terintegrasi didalam perusahaan disebut enterprise adanya data yang tesusun baik dalam satu sumber data yang dikelola merupakan tujuan pengembangan perusahaan untuk mewujudkan hal tersebut diperlukan strategi dan perencanaan. Diketahui bahwa Cv. Ria Kencana Ungu memerlukan pengelolaan dalam pengembangan teknologi informasi satu masalah  yang dihadapi pada RKU Computer yaitu penerapan perancangan proses bisnis sebagian besar di setiap bagian belum menggunakan sistem dan masih melakukan pencatatan secara manual untuk menyalin data proses transaksi juga pelaporan data service sehingga menjadikan proses pengolahan data belum efektif dan tidak berkesinambungan. Penerapan rancangan enterprise architecture planning dengan  zachman framework hasil yang dicapai dalam pelaksanaan  enterprise architecture planning menghasilkan  sebuah  cetak biru yang dapat dijadikan  sebagai pedoman  yang dapat menggambarkan  dengan merancang architecture di Cv.Ria Kencana Ungu terbukti menjadi hal yang sangat penting bagi sebuah enterprise. Dengan kandidat aplikasi yang di usulkan dapat memperbaiki sistem informasi berdasarkan proses bisnis yang sedang berjalan saat ini sehingga kebutuhan teknologi informasi yang mendukung kebutuhan bisnis yang bisa menjadi acuan dalam investasi teknologi jangka panjang di Cv. Ria Kencana Ungu

scholarly journals Information Technology Strategic Plan Using Ward and Peppard Method (Case Study of the Diploma Program of IPB University)

2019 ◽  
Vol 9 (1) ◽  
pp. 13-26
Author(s):  
Ringga Gilang Baskoro
Keyword(s):  
Information Technology ◽  
Business Process ◽  
Business Processes ◽  
Strategic Plan ◽  
Strategy Formulation ◽  
Process Data ◽  
Implementation Phase ◽  
Vocational College ◽  
Study Results ◽  
Diploma Program

Vocational college Bogor Agricultural University (IPB) have utilized information technology (IT) to support business process. The problem is that existing information technology has not been effective in supporting the main business process. Data processing and information systems become one of the things that need to be improved. To apply information technology to align with the needs of business processes required a plan to minimize the occurrence of failure in the implementation phase. As the guidance and direction of IT Operation in each organization, IT Strategic Plan plays the very important role in organization. Many IT projects fail since there was no adequate IT planning.  The stages of IS strategy formulation are performed based on Ward & Peppard framework. IS and IT strategic plan formulated in this study consist of some components such: application portfolio, IT management and architecture recommendation in Vocational college Bogor Agricultural University (IPB). This study results of IT strategic plan formulation for Vocational College Bogor Agricultural University (IPB).

scholarly journals INFORMATION TECHNOLOGY STRATEGIC PLAN USING WARD AND PEPPARD METHOD (CASE STUDY DIPLOMA PROGRAM OF BOGOR AGRICULTURAL UNIVERSITY)

2019 ◽  
Vol 9 (1) ◽  
pp. 13
Author(s):  
Ringga Gilang Baskoro
Keyword(s):  
Information Technology ◽  
Business Process ◽  
Business Processes ◽  
Strategic Plan ◽  
Strategy Formulation ◽  
Process Data ◽  
Implementation Phase ◽  
Vocational College ◽  
Study Results ◽  
Diploma Program

<span lang="EN-US">Vocational college Bogor Agricultural University (IPB) have utilized information technology (IT) to support business process. The problem is that existing information technology has not been effective in supporting the main business process. Data processing and information systems become one of the things that need to be improved. To apply information technology to align with the needs of business processes required a plan to minimize the occurrence of failure in the implementation phase. As the guidance and direction of IT Operation in each organization, IT Strategic Plan plays the very important role in organization. Many IT projects fail since there was no adequate IT planning.  The stages of IS strategy formulation are performed based on Ward &amp; Peppard framework. IS and IT strategic plan formulated in this study consist of some components such: application portfolio, IT management and architecture recommendation in Vocational college Bogor Agricultural University (IPB). This study results of IT strategic plan formulation for Vocational College Bogor Agricultural University (IPB).</span>

Research on Query Optimization Technology in Distributed Database

2012 ◽  
Vol 433-440 ◽  
pp. 3335-3339
Author(s):  
Bo Zhu Wu
Keyword(s):  
Query Processing ◽  
Query Optimization ◽  
Distributed Database ◽  
Query Time ◽  
Processing Technology ◽  
Database Query ◽  
Processing Program ◽  
Depth Study ◽  
Database Query Processing ◽  
Query Efficiency

Through the in-depth study of the existing distributed database query processing technology, this paper proposes a distributed database query processing program. This program optimizes the existing query processing, stores the commonly used query results according to the query frequency, to be directly used by the subsequent queries or used as intermediate query results, thus avoiding possible transmission of a large number of data, thereby reducing the query time and improving query efficiency.

Sistem Informasi Penjualan Online di Universitas Katolik Santo Thomas (Tokounika) Berbasis Web Menggunakan Metode Feature Driven Development

2021 ◽  
pp. 63-71
Author(s):  
Andy Paul Harianja ◽  
Iwada Grawilser Talunohi
Keyword(s):  
Information Technology ◽  
Information System ◽  
Information Systems ◽  
Communication Networks ◽  
Business Processes ◽  
Business Students ◽  
The Internet ◽  
Online Sales ◽  
Catholic University ◽  
Business Entities

The development of the field of information technology is very rapid, therefore many companies, industries, shops and other business entities are using information systems to increase their business. Online sales information systems are used to carry out business processes such as distribution, sales, purchasing, marketing of goods or services by using communication networks and the internet. Online sales information systems can help people who do not have a place or shop to carry out their business. Students in this case, especially at the Catholic University of Santo Thomas, are an opportunity to take advantage of this facility in carrying out their business, especially if they do not have a place or shop to carry out their business. For this reason, an online sales information system was built that can be accessed through the website.

scholarly journals Methodology of synchronization among strategy and operation. A standards-based modeling approach

2017 ◽  
Vol 37 (2) ◽  
pp. 111-119
Author(s):  
VICTOR EDWIN COLLAZOS ◽  
HELGA DUARTE AMAYA
Keyword(s):  
Information Technology ◽  
Information System ◽  
Enterprise Architecture ◽  
Business Processes ◽  
Modeling Approach ◽  
Operational Level ◽  
Alignment Process ◽  
Level Design ◽  
High Level ◽  
Help Model

Enterprise Architecture (EA) has gained importance in recent years, mainly for its concept of “alignment” between the strategic and operational levels of organizations. Such alignment occurs when Information Technology (IT) is applied correctly and timely, working in synergy and harmony with strategy and the operation to achieve mutually their own goals and satisfy the organizational needs.Both the strategic and operational levels have standards that help model elements necessary to obtain desired results. In this sense, BMM and BPMN were selected because both have the support of OMG and they are fairly well known for modelling the strategic level and operational level, respectively. In addition, i* modeling goal can be used for reducing the gap between these two standards. This proposal may help both the high-level design of the information system and to the appropriate identification of the business processes that will support it.This paper presents a methodology for aligning strategy and the operation based on standards and heuristics. We have made a classification for elements of the models and, for some specific cases, an extension of the heuristics associated between them. This allows us to propose methodology, which uses above-mentioned standards and combines mappings, transformations and actions to be considered in the alignment process.

Factors Influencing Performance of ITES Firms in India

2012 ◽  
Vol 25 (4) ◽  
pp. 46-64 ◽  
Author(s):  
Soni Agrawal ◽  
Kishor Goswami ◽  
Bani Chatterjee
Keyword(s):  
Information Technology ◽  
Developing Countries ◽  
Service Provider ◽  
Business Processes ◽  
Developed Countries ◽  
Offshore Outsourcing ◽  
Competitive Advantages ◽  
Improve Quality ◽  
Factors Influencing

Firms from developed countries are increasingly offshore outsourcing services to developing countries to have cost as well competitive advantages. Although this is a growing practice, there has been limited empirical attention in understanding the outsourcing phenomenon, particularly from the perspective of service provider firms that execute important business processes for their overseas clients. Despite growing trends to outsource, only a few service provider firms report success. This puts the service provider firms under increasing pressure to add value and improve quality of relationship. They have to depend not only on tangible factors but some intangible factors also play an important role in their performance. In this paper, the authors try to find out factors that influence performance of service provider firms. Multiple regressions using four indicators of firm performance are carried out to see the influence of certain factors on information technology enabled service (ITES) firms’ performance.

scholarly journals Enterprise Architecture Repository to Support the Company IT-Strategic

2019 ◽  
Vol 8 (4) ◽  
pp. 8736-8742
Keyword(s):  
Information Technology ◽  
Enterprise Architecture ◽  
Business Processes ◽  
Business Strategies ◽  
The Future ◽  
Implementation Method ◽  
New Applications ◽  
Role Of Information

The objective of this study is to identify the role of information technology in companies. The use of IT should create a synergy between business strategies, business processes and technologies to achieve the vision, mission and objectives of the company, and to offer excellence in the future. For this reason, the study uses the EA framework, where there are artifacts that are stored digitally in the repository. This study uses the EA implementation method when the main points of the EA development steps are implemented. The results achieved are the integration of new applications that are expected to be properly implemented so that companies can read their strategies to deal with competitors. The conclusion is that the proposed application can help the company achieve its vision, mission and objectives. And all business processes can be managed effectively and efficiently so that the company can compete with its competitors today and in the future.

Sign in / Sign up

Export Citation Format

Share Document