Sistem Informasi *)
*)Oleh : Solikin WS.,M.T.
[email protected] Kadir,Abdul & Triwahyuni, Terra Ch. “Pengantar Teknologi Informasi, edisi Revisi”. Yogyakarta: Andi Offset
6/14/2016
handout-SI-032204 KSI -by:sol's-
1
6/14/2016
handout-SI-032204 KSI -by:sol's-
2
Pengertian
Data dan Informasi
Data : “Streams of raw facts representing events occurring in organizations or the physical environment before they have been organized and arranged into a form that people can understand and use”, 4.p8-9). (adalah aliran dari fakta yang direpresentasikan melalui kejadian dalam organisasi atau lingkungan fisik sebelum diorganisasi dan di susun ke dalam bentuk yang dapat dimengerti dan digunakan oleh user).
Data adalah fakta / sebagian fakta yang mengandung arti berupa angka, huruf, symbol khusus atau gabungan darinya.
6/14/2016
handout-SI-032204 KSI -by:sol's-
3
Informasi
(1)
“Data have been shaped into form that is meaningful and useful to human beings”. (Informasi adalah data yang disusun kedalam bentuk yang dapat dimengerti dan bermanfaat bagi user) atau.
Informasi adalah “hasil dari kegiatan pengolahan data yang memberikan bentuk yang lebih berarti berupa suatu informasi” atau
Informasi adalah data yang mempunyai nilai (berarti) bagi penerimanya dan dapat digunakan untuk dasar pengambilan keputusan.
6/14/2016
handout-SI-032204 KSI -by:sol's-
4
Data
6/14/2016
vs Informasi
handout-SI-032204 KSI -by:sol's-
5
Informasi(2)
Untuk menjadi informasi,umumnya data perlu mengalami proses pengolahan. Data
Process
Informasi
Sifat informasi dapat perfect (sempurna, tidak mengandung unsur ketidakpastian) dan dapat pula imperfect (tidak sempurna, mengandung unsur ketidakpastian).
6/14/2016
handout-SI-032204 KSI -by:sol's-
6
Informasi(3)
Sumber Informasi :
6/14/2016
Pengamatan lapangan (observasi) Kuesioner Kejadian / event (pencatatan, perekaman ataupun penangkapan sinyal digital secara langsung). Pemodelan (forecasting, econometric, operational research, simulation, heuristic, dsb). handout-SI-032204 KSI -by:sol's-
7
Informasi(4)
1. 2.
3.
Kualitas Informasi ditentukan oleh 3 Faktor (Burch dan Gurudnitski,1989) : Relevansi Tepat waktu Akurasi
6/14/2016
handout-SI-032204 KSI -by:sol's-
8
Informasi(5)
Informasi disampaikan kepada pengguna (user) dapat direpresentasikan dalam media :
Kertas/hardcopy Tampilan/display-monitor/video Suara/audio
Informasi yang dibutuhkan manajemen umumnya dalam bentuk laporan. Ada banyak variasi dan tipe laporan antara lain :
6/14/2016
Loran Periodik Laporan Indikator Kunci Laporan berdasarkan permintaan (on-call report) Laporan Khusus Laporan Penyimpangan (exception report) handout-SI-032204 KSI -by:sol's-
9
Informasi(6)
Laporan dapat di representasikan dengan berbagai bentuk, antara lain yang umum digunakan :
6/14/2016
Narasi Tabel Grafik dan Gambar Kombinasi Kertas/hardcopy
handout-SI-032204 KSI -by:sol's-
10
• System ? “A group of elements or parts that are integrated and coordinated for the purpose of achieving a goal” (Sekumpulan komponen atau bagian yang terintegrasi dan dikoordinir untuk maksud mencapai suatu tujuan / gol)
System
Input
Output
Feedback
6/14/2016
handout-SI-032204 KSI -by:sol's-
11
information system menurut Alter (1992)
“kombinasi antar prosedur kerja, infromasi, orang dan teknologi informasi yang diorganisasikan untuk mencapai tujuan dalam sebuah organisasi “
6/14/2016
handout-SI-032204 KSI -by:sol's-
12
Types of Information Systems Information Systems
Operations
Management
Support
Support
Systems
Systems
Transaction
Process
Enterprise
Management
Decision
Executive
Processing
Control
Collaboration
Information
Support
Information
Systems
Systems
Systems
Systems
Systems
Systems
6/14/2016
handout-SI-032204 KSI -by:sol's-
20
A transaction processing system (TPS) is an information system that captures and processes data about business transactions. A management information system (MIS) is an information system that provides for management-oriented reporting based on transaction processing and operations of the organization.
A decision support system (DSS) is an information system that either helps to identify decision making opportunities or provides information to help make decisions. 6/14/2016
handout-SI-032204 KSI -by:sol's-
21
An expert system is an information system that captures the expertise of workers and then simulates that expertise to the benefit of nonexperts. A communications and collaboration system is an information system that enables more effective communications between workers, partners, customers, and suppliers to enhance their ability to collaborate.
An office automation system is an information system that supports the wide range of business office activities that provide for improved work flow between workers. 6/14/2016
handout-SI-032204 KSI -by:sol's-
22
Other Categories of Information Systems Expert Systems
Knowledge Management Systems Functional Business Systems Strategic Information Systems Cross-Functional Information Systems 6/14/2016
handout-SI-032204 KSI -by:sol's-
23
Hybrid System ? Disebut juga Sistem informasi terintegrasi vertikal “Sistem informasi yang disediakan suatu organisasi umumnya gabungan dari beberapa sistem informasi “
6/14/2016
handout-SI-032204 KSI -by:sol's-
24
The Information Systems Development Process
6/14/2016
handout-SI-032204 KSI -by:sol's-
25
Management Challenges of the E-Business Enterprise •Business Strategies •Business Processes •Business Needs
•IS Human Resources •IS Development
•Customer Relationships •Business Partners •Suppliers •Business Customers
•IT Infrastructure •IS Performance
Ethical Considerations Potential Risks? Potential Laws? Possible Responses?
•Organization Structure •and Culture •User Acceptance
6/14/2016
handout-SI-032204 KSI -by:sol's-
26
Chapter Summary (cont)
IS Resources:
Hardware Resources Software Resources People Resources Data Resources Network Resources
Products:
6/14/2016
Paper Reports Visual Displays Multimedia Documents Electronic Messages Graphics images Audio Responses
handout-SI-032204 KSI -by:sol's-
29
Chapter Summary (cont)
Information systems perform three vital roles in business firms. They support:
Business processes and operations, Business decision making; and Strategic competitive advantage
Major application categories of information systems include:
6/14/2016
Operations Support Systems; and Management Support Systems
handout-SI-032204 KSI -by:sol's-
30
Data
: Tipe Data
Lima tipe utama data pada sistem informasi yang sekarang yaitu : 6.p132-177) 1. 2. 3. 4. 5.
predefined data item, images, text, audio, dan video
Pada sistem informasi tradisional hanya berisi predefined data item dan text. Pada saat ini, akibat pesatnya kemajuan ilmu pengetahuan dan teknologi IT data dapat dibuat dalam bentuk gambar, suara dengan menggunakan teknik seperti digitization, voice messaging dan video conference 6/14/2016
handout-SI-032204 KSI -by:sol's-
31
Predefined data item
Predefined data item tediri dari numeric atau alphabetical item, yang mempunyai arti dan format khusus yang jelas dan selanjutnya digunakan untuk mengendalikan kalkulasi dan transaksi yang menggunakan data. Sebagai contoh credit card number, transaction date, purchase account, dan merchant ID.
6/14/2016
handout-SI-032204 KSI -by:sol's-
32
Text
Text terdiri dari letters, numbers, dan karakter lainnya yang pengertiannya dikombinasikan tidak hanya bergantung pada bentuk yang ditentukan (prespecified format) atau definisi dari item individual (defined of individual items).
6/14/2016
handout-SI-032204 KSI -by:sol's-
33
Images
Images adalah data dalam bentuk gambar, baik dalam bentuk photographs, gambar yang dibuat tangan (hand-drawn pictures), atau grafik yang dihasilkan dari data numerik. Images dapat disimpan, dimodifikasi, dan di kirim (transmitted) dalam banyak cara yang sama seperti text.
6/14/2016
handout-SI-032204 KSI -by:sol's-
34
Audio
Audio adalah data dalam bentuk suara.
Video
6/14/2016
Video adalah kombinasi gambar dan suara yang ditampilkan secara bersamaan. Penggunaannya misalnya melalui video conference.
handout-SI-032204 KSI -by:sol's-
35
Satuan Data
Bit Byte Word Double Word Data Record Field Table Library Database
6/14/2016
satuan terkecil data satu karakter=8 bit satu kata=2 byte=16 bit satu kata=4 byte=32 bit satu data=beberapa byte yang punya arti satu baris data satu lajur/kolom data satu table data (baris dan kolom) satu kumpulan file data satu bank data (kumpulan semua data)
handout-SI-032204 KSI -by:sol's-
36
Evolution of DB Systems
6/14/2016
Flat files - 1960s - 1980s Hierarchical – 1970s - 1990s Network – 1970s - 1990s Relational – 1980s - present Object-oriented – 1990s - present Object-relational – 1990s - present Data warehousing – 1980s - present Web-enabled – 1990s - present
handout-SI-032204 KSI -by:sol's-
37
Data, Informasi dan Sistem Informasi (..catatan tambahan)
SI sudah merupakan bagian dari perusahaan untuk mendukung usaha dengan CBIS (Computer Base Information System) Resources : 5M + I Man Machine Money Material Method and Information
6/14/2016
handout-SI-032204 KSI -by:sol's-
50
Kenapa SI perlu dimenej?, karena resources terbatas, karena terbatas maka perlu di optimalkan pemanfaatannya Sistem pasti mempunyai tujuan, komponen sistem apa saja, tergantung sistem apa, bisa metode, barang, dll
Karakteristik sistem :
1.
Transformasi input ke output (retrieve, update, representation) Representasi : Text,suara,gambar, dll
2. 3. 4. 5. 6.
7. 8.
6/14/2016
Interdisiplinair yang tergabung dalam satu kesatuan Holistik (menyeluruh) Dapat dibedakan dengan yang lainnya (lingkungannya) Sinergi Hierarki Ada aturan (regulasi) Harus punya tujuan (objective) handout-SI-032204 KSI -by:sol's-
51
Information Systems Architecture (ISA)
Overall blueprint for organization’s information systems Consists of:
6/14/2016
Data (Enterprise Data Model – simplified ER Diagram) Processes – data flow diagrams, process decomposition, etc. Data Network – topology diagram (like fig 1.8) People – people management using project management tools (Gantt charts, etc.) Events and Points in Time (when processes are performed) Reasons for events and rules (e.g. decision tables) handout-SI-032204 KSI -by:sol's-
52
Information Engineering
A data-oriented methodology to create and maintain information systems
Top-down planning approach.
Four steps:
6/14/2016
Planning Results in an Information Systems Architecture Analysis Results in functional specifications…i.e. what we want Design Results in design specifications…i.e. how we’ll do it Implementation Results in final operational system handout-SI-032204 KSI -by:sol's-
53
Information Systems Planning
Strategy development
IT Planning to meet Corporate strategy
Three steps: 1.
2. 3. 6/14/2016
Identify strategic planning factors Identify corporate planning objects Develop enterprise model handout-SI-032204 KSI -by:sol's-
54
Identify Strategic Planning Factors (table 2.1)
Organization goals – what we hope to accomplish Critical success factors – what MUST work in order for us to survive Problem areas – weaknesses we now have
6/14/2016
handout-SI-032204 KSI -by:sol's-
55
Identify Corporate Planning Objects (table 2.3)
Organizational units Organizational locations Business functions – these might become the users Entity types – the things we are trying to model Information (application) systems
6/14/2016
handout-SI-032204 KSI -by:sol's-
56
Develop Enterprise Model
Decomposition of business functions
Enterprise data model
See figure 2.2 See figure 2.1
Planning matrixes
6/14/2016
See figure 2.3
handout-SI-032204 KSI -by:sol's-
57
Enterprise Data Model
First step in database development Specifies scope and general content Overall picture of organizational data, not specific design Entity-relationship diagram Descriptions of entity types Relationships between entities Business rules
6/14/2016
handout-SI-032204 KSI -by:sol's-
58
Informasi Data yang mempunyai nilai (berarti) bagi penerimanya dan dapat digunakan untuk dasar pengambilan keputusan Untuk menjadi informasi umumnya data perlu mengalami proses pengolahan Sifat informasi :
1. 2.
6/14/2016
Perfect (tidak mengandung unsur ketidakpastian) Imperfect (mengandung unsur ketidakpastian)
handout-SI-032204 KSI -by:sol's-
59
INPUT
PROSES
OUTPUT
Data
Proses
Informasi
- Bisa sangat simple - Bisa dapat complicated
• Suatu data jika akan menghasilkan informasi yang baik, maka datanya harus bersih. • prosesnya meliputi : 1. Verifikasi 2. Validasi 3. Duplication data
6/14/2016
handout-SI-032204 KSI -by:sol's-
60
Macam-macam atribut suatu data :
1. 2. 3. 4. 5.
Identifier (sebagai identifikasi) Locater (sebagai penunjuk lokasi) Temporal Classifier Relational
Faktor yang mempengaruhi ‘nilai suatu informasi’ :
1. 2. 3. 4.
6/14/2016
Tepat ISI dan TELITI (accuracy) Tepat WAKTU (timeliness) Tepat GUNA (relevancy) Tepat SAJI (presentation)
handout-SI-032204 KSI -by:sol's-
61
Manfaat Informasi
Terhadap Proses :
1. 2. 3. 4. 5. 6.
Terhadap Produk :
1. 2. 3. 4.
6/14/2016
Menghemat Tenaga Meningkatkan Efisiensi Mempercepat Proses Perbaikan Dokumentasi Pencapaian Standar Perbaikan Keputusan
Peningkatan “feature” Perubahan Karakteristik Peningkatan Fasilitas Penyampaian Produk Inovasi Produk barang atau jasa
handout-SI-032204 KSI -by:sol's-
62
Terhadap Kualitas :
1. 2.
Komponen SI :
1. 2. 3. 4.
6/14/2016
Peningkatan kualitas proses (JIT,Feedback, dsb) Peningkatan kualitas produk (standarisasi produk, peningkatan pelayanan, dsb)
Technoware (S/W,H/W, Jaringan) Infoware (Database) Organware (Organisasi dan Prosedur) Brainware (humanware)
handout-SI-032204 KSI -by:sol's-
63
Technoware (S/W,H/W, Jaringan) Merupakan sistem komputer dan jaringan
Infoware (Database) DBMS (Data Base Management System) DBA (Database Administrator) Kegagalan DBMS pada umumnya pada updating karna faktor SDM Jika data tidak diupdate, maka cutomer kecewa, ini akan sangat berbahaya. Oleh karena itu perlu dijaga kedisiplinan agar data tetap up-to-date.
6/14/2016
handout-SI-032204 KSI -by:sol's-
64
Organware (Organisasi dan Prosedur)
Mencakup Organisasi dan Prosedur Prosedur :
1.
2. 3. 4. 5.
6/14/2016
Prosedur Penyiapan Data Prosedur Perekaman Data Prosedur Pemrosesan Data Prosedur Pengamanan Data Dsb
Jika sistem sudah “menyimpang terlalu jauh”, maka perlu di “Re-Design” Dengan adanya prosedur baru, terdapat cara kerja baru dan ini harus disosialisasikan Kalau mau mengembangkan SI harus mengacu kepada rencana induk perusahaan Dulu EDP sekarang IT Division atau IS Division
handout-SI-032204 KSI -by:sol's-
65
Brainware
Mengatur Brainware paling sulit dibandingkan dengan 3 komponen yang lainnya Contoh job dalam bidang IT:
1. 2. 3. 4. 5.
6. 7. 8. 9.
6/14/2016
Operator Perekam Data Teknisi Perangkat Kerja dan Jaringan Pemrogram APlikasi Sistem (Programmer) Analis Sistem (Analyst) Administrator Database (Database Administrator) Perancang Sistem (System Designer) Perekayasa Perangkat Lunak (S/W Engineering) Perekayasa Jaringan (Network Engineering) Pengelola Proyek SI (IS Project Manager)
handout-SI-032204 KSI -by:sol's-
66
Karakteristik Sistem Environment
Sub Sistem
Sub Sistem
Output
Input
Goals
Sub Sistem
Sub Sistem
Boundary (batas sistem)
Interface (penghubung) Input
6/14/2016
Process
Output
handout-SI-032204 KSI -by:sol's-
67
Siklus Pengolahan Data PROSES (Model)
OUTPUT (Informasi)
ENTRI DATA BASIS DATA
USER (Penerima)
CAPTURING DATA
HASIL TINDAKAN
6/14/2016
KEPUTUSAN TINDAKAN
handout-SI-032204 KSI -by:sol's-
68
Understanding Systems from Business Viewpoint
Amazon.com : An Evolving Business Models The Need for Frameworks and Models The Work System Framework Work System Principles Relationships Beetwen Work Systems and IS The Principle Based Systems Analysis Method Measurement Work System Performance
Clasification Related to
6/14/2016
handout-SI-032204 KSI -by:sol's-
69
Amazon.com : An Evolving Business Models (Work System Snapshot, Amazon.com provides a different way to shop for books)
6/14/2016
handout-SI-032204 KSI -by:sol's-
70
The Work System Framework 6/14/2016
The Customer The Product and Services The Business Process The Participant The Information The Technology Context Infrastructure handout-SI-032204 KSI -by:sol's-
71
The Customer People
who use and receive direct benefit from the products and services
6/14/2016
handout-SI-032204 KSI -by:sol's-
72
The Product and Services
6/14/2016
The combination of physical things information and services that the work system produces for to customer handout-SI-032204 KSI -by:sol's-
73
The Business Process
6/14/2016
The sets of the steps or activities that are performed within the work system
handout-SI-032204 KSI -by:sol's-
74
The Participant
6/14/2016
People who perform the work step in the business process
handout-SI-032204 KSI -by:sol's-
75
The Information
6/14/2016
The information used by the participants to perform their work
handout-SI-032204 KSI -by:sol's-
76
The Technology
6/14/2016
The hardware, software and the other tools and equipment used by the participants handout-SI-032204 KSI -by:sol's-
77
Context
6/14/2016
The organizational, competitive, technical and regulatory realm within which the work system operates handout-SI-032204 KSI -by:sol's-
78
Infrastructure
6/14/2016
Is share human and technical resources that the work system rellies on even through these resources exist and are managed outside of it. handout-SI-032204 KSI -by:sol's-
79
CUSTOMER
People who purchases books Whosellers that supply the books Amazon.com Shipping departement
PRODUCTS AND SERVICES
Information about books that might be purchased information describing cash book order books that are eventually delivered
BUSINESS PROCESS
Purchaser log on www.amazon.com Purchaser identifies desired books or gives search criteria Purchaser looks at book related information and desides what to order Purchaser enter order Amazon.com finds the books in it inventory and packs thm fpr dhipping, if the book are no in its inventory, Amazon order them from a wholeseller and ships them to the customer after they arrive at the Amazon werehouse Shipping departement packages order and sends it to the purchaser
PARTICIPANTS
People interested in purchasing books order fullfillment department of wholeseller Shipping department Amazon.com
TECHNOLOGY
INFORMATION
Order for books price and other information about each book purchase hidtory and related information for each customer
Personel computers used by purchaser computers and networks use by Amazon.com for order processing the internet (infrastructure)
Work System Snapshot Amazon.com provides a different way to shop for books 6/14/2016
handout-SI-032204 KSI -by:sol's-
80
Data and Knowledge Management (KM) I. 1. 2.
3. 4.
5. 6. 6/14/2016
Data Management : A Critical Success Faktor (CSF) Data Life Cyle Process and Knowledge Discovery Data Source and Collection Data Quality (DQ) Multimedia and OO Databases Document Management handout-SI-032204 KSI -by:sol's-
81
Data Warehousing, Mining and Analysis :
II.
1.
2. 3.
6/14/2016
Transaction Vs Analytical Processing Data Warehousing and Marts Knowledge Discovery, Analysis and Mining
handout-SI-032204 KSI -by:sol's-
82
III.
1. 2.
3.
6/14/2016
Data Visualization and Technology Data Visualization Multidimensionality GIS
handout-SI-032204 KSI -by:sol's-
83
IV. 1.
2.
Marketing Databases in Action The Marketing Transaction Database Implementation in Example
KM
V. 1.
2. 6/14/2016
Knowledge Base and Organizational Learning Implementing KM Systems handout-SI-032204 KSI -by:sol's-
84
I. I.
Data Management A Critical Success Faktor (CSF) The Difficulties
6/14/2016
The Amount of data increases exponentially Collected by many individuals, using several methods and devices Organization’s data are relevant for specific decision Raw Data my be stored in different computing systems, databases, formats, and human and computer languages Data Security, Quality, and integrity handout-SI-032204 KSI -by:sol's-
85
These difficulties and the critical need for
Data management
6/14/2016
Timely and Accurated information Search effective and efficient
Support TPS Relational Databases Client/Server Environment Finding Data Quiqly and Easly
Creation of Data Warehouse handout-SI-032204 KSI -by:sol's-
86
2.
Data Life Cyle Process and Knowledge Discovery
6/14/2016
Trace how and where data flows in organization Business do not run on data, They run on information and their knowledge of how to put that information to uses successfully. The transformation of data into knowledge mybe accomplished in several ways handout-SI-032204 KSI -by:sol's-
87
Converting Data to Knowledge Data Warehousing
Collection
Selection
Preprocessing
Data Source
Transformation
Data Analysis Data mining
Interpretation / Evaluation iMac
Data Sorage
Target Data
Preprocessing Data
Transformed Data
Patterns
Use
Knowledge Storage, Knowledge Base
6/14/2016
handout-SI-032204 KSI -by:sol's-
88
3.
Data Source and Collection
6/14/2016
The Data life cycle begins with the acquisition of data from data sources. Data can include : Documents Pictures Maps Sound and
handout-SI-032204 KSI -by:sol's-
89
Data Source :
6/14/2016
Animation Concepts Opinions Raw or Summarized or extrated data Internal Data Personal Data External Data handout-SI-032204 KSI -by:sol's-
90
Internal Data :
Personal Data
6/14/2016
are organizational internal data are stored in one or more places About : people, product, services, and processes IS user or other coorporate employees by creating personal data handout-SI-032204 KSI -by:sol's-
91
External Data :
6/14/2016
Data are available on : CD-ROM Internet Server (film, music or voice) Pictures (diagram, atlases) Television Large amounts of external data are available on the internet. The internet and commercial databases services -> Electronic Data Interchange (EDI) handout-SI-032204 KSI -by:sol's-
92
Methods For Collection Raw Data
6/14/2016
Can be collected : Manually or Instruments or sensors Scanned or Transferred Electronically Manual Data Collected : Time studies Surveys Observations and Constributions from experts handout-SI-032204 KSI -by:sol's-
93
4.
Data Quality (DQ)
6/14/2016
Data are frequently found to be : Inaccurate Incomplete Ambiguous The economical and social damage from poor quality data costs billions of dollars
handout-SI-032204 KSI -by:sol's-
94
Problem Data :
DQ Problem divide into four catagories and dimension : 1.
2.
3.
4.
6/14/2016
Instrinsic DQ : Accuracy, objectivity, believability, reputation Accessability DQ : Accessability and security Contextual DQ : Relevance, Value Added, timeliness, completeness, amount data Representasion DQ: Interpretability, ease of understanding, concise representation, consistent representation handout-SI-032204 KSI -by:sol's-
95
Problem Data (cont..):
6/14/2016
Data are not correct Data are not timely Data are not measured or index properly Needed data simply do not exist
One of the major issues of DQ is DATA INTEGRITY
handout-SI-032204 KSI -by:sol's-
96
6/14/2016
OOD are sometimes referred to as multimedia databases and are manage special Multimedia Databases Management Systems (MDMS) These manage data in variety of formats in additional to standard text or numeric fields. The formats include Images such as digitized photographs or forms of bit-mapped graphics handout-SI-032204 KSI -by:sol's-
97
6.
Document Management (DM)
6/14/2016
Document Management Systems (DMS) provide information to decision makers in an electronic format DM is the automated control of electronic document, page images, spreadsheet, word processing document, and complex, compound documents through their entire life cycle within an organization, from initial creation to final archiving. DMS usually include computerized imaging systems
handout-SI-032204 KSI -by:sol's-
98
Data Warehousing, Mining and Analysis :
II.
I.
Transaction Vs Analytical Processing
6/14/2016
Data processing in organizations can be viewed either as transactional or analytical Transactional Processing, in the routine daily processing of the transactional of the organizations such as ordering or billing handout-SI-032204 KSI -by:sol's-
99
A good data delivery system therefore should be able to support :
6/14/2016
Easy data access by the end users themselve Quicker decision making More accurate and effective decision making Flexible decision making handout-SI-032204 KSI -by:sol's-
100
This improved option of analytical processing involves three concepts : A business representation of data for end users 2. A client/server enviroment that gives the user query and reporting capabilities 3. A server-base repository, the data warehouse, that allows centralized security and control over the data 1.
6/14/2016
handout-SI-032204 KSI -by:sol's-
101
2.
Data Warehousing and Marts
6/14/2016
Data Warehouse, benefits : 1. To reach data quickly 2. To do it easly The purpose of data warehouse is to establish a data repository that makes operational data accessable in a form rapidly acceptable for analytical processing activities such as decision support, EIS, and other user application.
handout-SI-032204 KSI -by:sol's-
102
6/14/2016
Data Warehouses allow for the storage of metadata, which include data summaries that are easier to index and search, especially with web tools
handout-SI-032204 KSI -by:sol's-
103
Data Warehouse Framework and Views
Replication
Legacy Select
Metadata Reposition
OLTP
Transform Integrate Maintain
External
Preparation
Target Database(s) (RDB, MDDB)
Application EIS / DSS Custom-Built Application (4GL Tools) Flat screen
Data Mart
Marketing
Extract Enterprise Data Warehouse
Access
Data Mart
Risk Management
Opeparational System / Data Data Mart
A P I S M I d l e w a r e
Production Reporting Tools Flat screen
Relation Query Tools Flat screen
OLAP / ROLAP Flat screen
Web Browses
Flat screen
Data Mining
Engineering Flat screen
6/14/2016
handout-SI-032204 KSI -by:sol's-
104
Characteristic of Data Warehousing Organization : data are organized by detailed subject, containingly information relevant for decision support 2. Consistency Data in different operational databases my be encoded differently, e.g gender data ‘0’, ‘1’ or ‘m’, ‘f’ and consistent manner 1.
6/14/2016
handout-SI-032204 KSI -by:sol's-
105
Time variant The data are kept for 5 to 10 years so they can be used for trends, forecasting and comparisons over time 4. Nonvolatile Once entered into the warehouse, data are not update (Tdk dpt diubah) 3.
6/14/2016
handout-SI-032204 KSI -by:sol's-
106
Relational Typically the data warehouse uses a relational structure 6. Clent/Server The data warehouse uses the client/server architecture mainly to provide the end user an easy access to its data 5.
6/14/2016
handout-SI-032204 KSI -by:sol's-
107
6/14/2016
Data Marts is a replicated subset of the data warehouse and is dedicated to a functional or regional area.
handout-SI-032204 KSI -by:sol's-
108
Summary of strategic Uses of Data Warehousing
Industry
Functional Area of Use
Strategic Use
Airline
Operations and Marketing
Banking
Product Development, operation and marketing
Healt Care
Operation
analysis of route profitability Customer service, trend analysis, product and service promotion. Reduction of IS expenses reduction of operational expenses
6/14/2016
handout-SI-032204 KSI -by:sol's-
109
3.
Knowledge Discovery, Analysis and Mining
6/14/2016
The program of extracting useful knowledge from volumes of data is known as knowledge discovery in databases (KDD) or just knowledge discovery. KDD’s objective is to identify valid, novel, potensially usefull, and ultimatelly understandable patterns in data handout-SI-032204 KSI -by:sol's-
110
KDD support by three technologies :
1. 2. 3.
Tools and Techniques of KDD KDD tools over time can be divided into four major stage :
1. 2.
3. 4.
6/14/2016
Massive data collection Powerfull multiprocessor computers Data Mining Algorithms
Data Collection (1960s) Data Acess (1980s) Data Warehousing and Decion Support (1990s) Intelligence Data Mining (l-1990)
handout-SI-032204 KSI -by:sol's-
111
6/14/2016
The problem with the data collection and access techniques is that they are not suitable for a large volume of data, nor can they be used effectively by end user. Even though Structured Query Language (SQL) use is becaming more user friendly.
handout-SI-032204 KSI -by:sol's-
112
6/14/2016
OLAP (On Line Analytical Processing) OLAP refers to such end-user activities as DSS modeling using spreadsheets and grahics, which are done online. Unlike online transaction online processing (OLTP) application.
handout-SI-032204 KSI -by:sol's-
113
6/14/2016
Data Mining Data mining derives is name from the similarities between searching for valuable business information in a large database and mining a mountain for a vein of valuable are.
handout-SI-032204 KSI -by:sol's-
114
IMPACT OF IT ON ORGANIZATIONS, INDIVIDUALS AND SOCIETY I. II.
III.
6/14/2016
Impact on Organizations Impact on Individuals at Work Societal Impacts and The Internet Community handout-SI-032204 KSI -by:sol's-
115
I.
IMPACTs ON ORGANIZATIONS 1. 2. 3. 4.
6/14/2016
Structure Authority Power and Job Content handout-SI-032204 KSI -by:sol's-
116
II.
IMPACTs ON INDIVIDUALS AT WORK 1. 2.
3.
6/14/2016
Job Satisfaction Dehumanization and Psychological Impacts Impacts On Health and Safety handout-SI-032204 KSI -by:sol's-
117
III.
1.
2. 3.
6/14/2016
SOCIETAL IMPACTS AND THE INTERNET COMMUNITY
Opportunitis For People With Disabilities Quality of Life Improvements Other Impacts
handout-SI-032204 KSI -by:sol's-
118
IMPACTs ON ORGANIZATIONS
1.1. Structure Structure,Authority,Power and Job Content
a. b.
c. d. e. f. g.
6/14/2016
Flatter Organizational Hierarchies Staff-To-Line Ratio Special Units Centralization of Authority Power and Status Job Contens Role Ambiguity and Conflict
handout-SI-032204 KSI -by:sol's-
119
A. Flatter Organizational Hierarchies (FOH)
Increased Productivity and increased span of control Decreased number of experts FOH result from :
6/14/2016
reduction in the total number of employees, reengineering of business process, and ability of lower-level employee to perform higher – level job
handout-SI-032204 KSI -by:sol's-
120
B. Staff-To-Line Ratio
6/14/2016
The number of professional and specialists could decline in relation to the total number of employees in the organizations.
handout-SI-032204 KSI -by:sol's-
121
C. Special Units
6/14/2016
Creating a technology centre Internet/electronic commerce unit Decision support system departement Intelligent system departement
handout-SI-032204 KSI -by:sol's-
122
D. Centralization of Authority
6/14/2016
Because of the trend toward smaller and flatters organizations, centralization become more popular. Example : introduction of expert systems in general electric’s maintenance area increased the power of the desentarlization units because they become less dependent on the companys headquarters. handout-SI-032204 KSI -by:sol's-
123
E. Power and Status
6/14/2016
Knowledge is power Changing the power structure within organization Example : expert system may reduce the power of certain professional group, becaise their knowledge will be in the public domain.
handout-SI-032204 KSI -by:sol's-
124
F. Job Contens
6/14/2016
Job Conten is important not only because it is
related to organizational structure, but also becase it is interrelated with employee satisfaction, compensation, status, and productivity. Changes in job content occuur when work is redesigned. Example : when BPR (Business Process Reenginerring) is attempted or when electronic commerce changes the marketing system. handout-SI-032204 KSI -by:sol's-
125
IMPACTs ON ORGANIZATIONS
1.2. Personnel Issues
6/14/2016
Employee Career Ladders Changes in Supervision Other Considerations
The Manager’s Job
handout-SI-032204 KSI -by:sol's-
126
IMPACTs ON ORGANIZATIONS
1.3. The Manager’s Job
6/14/2016
Automation of routin decision Less expertise required for many decisions Less reliance on experts to provide support to top executive Power distribution among managers Electronic support of complex decision (intelligent agents, DSS) handout-SI-032204 KSI -by:sol's-
127
Impacts On Health and Safety
6/14/2016
Job Stress Repetitive Strain Injuries Lessening The Negative Impact on Health and Safety Other Impacts handout-SI-032204 KSI -by:sol's-
128
Dehumanization and Psychological Impacts
Dehumanization :
6/14/2016
Negative effect on people’s individuality, such : many people feel loss of identity. Expert systems or artificial intelligence are increasingly replacing people in the creative arena.
handout-SI-032204 KSI -by:sol's-
129
Dehumanization and Psychological Impacts(2)
Psychological Impacts :
6/14/2016
Isolating influence : depression and loneliness Distance learning : lack of social impact.
handout-SI-032204 KSI -by:sol's-
130
IS and Individual Department Store
Drug Store
Hotel Reservation Theater and Entertainment
Supermarket Money Card Real Estate Stocks Integrated Financial Database
Consumer System
Financial System
Laisure Time System
Travel Reservation
E-funds transfer Library The Individual The Individual
Educational and Adm Record Computer Assisted Education
Education and Medical System
Accounting and Legal
Home Informatio n System
Hospital Adm and treatment Centre Medical Database
6/14/2016
e-Commerce
Entertainment business and education
Environment and application
Police and Fire
Public and Private Service System
Insurance and Brokerage Security
handout-SI-032204 KSI -by:sol's-
131