DBMS (database Management Systems)

1. DBMS (database Management Systems) Information Technology For Management 6th Edition Turban, Leidner, McLean, Wetherbe Lecture Slides by L. Beaubien, Providence College John Wiley & Sons, Inc. Data Management: Data, Databases and Warehousing Pengampu: TaufikHidayat, S.Kom, MMSI, LektorKepala

2. Data Life Cycle Process

3. Transactional VS Analytical Processing • Transactionalprocessing takes place in operational systems (TPS) that provide the organization with the capability to perform business transactions and produce transaction reports. The data are organized mainly in a hierarchical structure and are centrally processed. This is done primarily for fast and efficient processing of routine, repetitive data. • Supplementary activity to transaction processing is calledanalytical processing, which involves the analysis of accumulated data. Analytical processing, sometimes referred to as business intelligence, includes data mining, decision support systems (DSS), querying, and other analysis activities. These analyses place strategic information in the hands of decision makers to enhance productivity and make better decisions, leading to greater competitive advantage.

4. Hierarchy of Data

5. Web-based Data Management Systems – content and information

6. Introduction to Database • File-Based Approach • Limitation of File Based Approach • Database Approach • The Database

7. File-Based Approach • File Based System is a collection of application programs that perform services for the end-users as the production of reports. Each program defines and manages its own data

8. Aspects • Computerization: • Hardware • Software • Data • Information Needed: • Programmer • Users • Database Administrator

9. Database System Component • Data: • Shared Data • Integrated • Hardware • Data Capacity • Software: • Creating File, Insert, Retrieving Data, Deleting Data, Security Control, Integrity Control, Recovery Control

10. File-Based Approach

11. Limitation of File Based-Approach • Separation and isolation of data • Duplication of Data • Data Dependence • Incompatible File Format • No Security

12. Database Approach • DBMS: A Software system that enables users to define, create, maintain, and control access to the database Facilities: • Its allows user to define the database through a Data Definition Language • Its allow user to Insert, Update, Retrieve data From The Database through Data Manipulation Language

13. Pemodelan Database • Hierarchical • Top down, like inverted tree • Fields have only one “parent”, each “parent” can have multiple “children” • Fast • Network • Relationships created through linked lists, using pointers • “Children” can have multiple “parents” • Greater flexibility, substantial overhead • Relational • Flat, two-dimensional tables with multiple access queries • Examines relations between multiple tables • Flexible, quick, and extendable with data independence • Object oriented • Data analyzed at conceptual level • Inheritance, abstraction, encapsulation

14. Pemodelan data

15. DBMS • Its provide controlled access to the database. For Example, it may provide: • A security system which prevents unauthorized users accessing the database • An integrity system which maintains the consistency of stored data • A concurrency control system, which allows shared access of the database • A recovery control system • A User control Catalog

16. The Database • Advantages of DBMS: • Control of data Redundancy • Data Consistency • More information from the same amount of data • Sharing of data • Improved Data integrity • Improved Security • Enforcement Standard • Economic of Scale • Balance of Conflicting Requirement • Improved Data Accessibility and responsiveness • Increased Productivity

17. The Database • Advantages of DBMS: • Improved maintenance through data independence • Increase concurrency • Improved Backup and recovery Services

18. The Database • Disadvantages: • Complexity • Size • Cost of DBMS • Additional Hardware Costs • Cost of Conversion • Performance • Higher Impact of a Failure

19. Knowledge Management • Knowledge : kesatuan kumpulan informasi yang diekstraksi dari aktivitas pendidikan, pelatihan, seminar dan sejenisnya, sosialisasi, organisasi, pengalaman, dan aktivitas pembelajaran lainnya yang menghasilkan suatu wawasan, pola pikir yang inovatif serta gagasan untuk membantu pengambilan keputusan dalam memecahkan berbagai permasalahan

20. Delphi Group Research • Kowledge dalam organisasi tersimpan dengan struktur sbb: 42% dalam pikiran (internal memory)/(tacit), 26 % dalam dokumen kertas, 20 % dalam dokomen elektronik, 12% dalam knowledge base elektronik.

21. Pengembangan Knowledge Management • 1. koleksi, organisasi, klasifikasi, dan disemimasi knowledge. • 2. Internet-based database selalu up-to- date. • 3. teknologi yang tepat untuk menangkap knowledge serta proses selanjutnya. • 4. aplikasi expert systems. • 5. hasil analisis informasi disimpan dan diolah kembali untuk diproses selanjutnya. • 6. identifikasi knowledge yang diperlukan. • 7. indeks pencarian knowledge • 8. know-how yang berkualitas. • 9. Pemetaan knowledge.

22. Peningkatan akses terhadap knowledge • 1. Penelusuran informasi dari berbagai sumber. • 2. Penelusuran Informasi melalui MSS. • 3. Refleksi atas tindakan masa lalu. • 4. Kemampuan menyerap. • 5. Kemampuan belajar. • 6. Persepsi positip terhadap aktivitas knowledge Sharing.

23. Perbedaan Manajemen Informasi/pelaporan dari knowledge management

24. Knowledge wajib dan pilihan • Knowledge wajib(relatif): *Language mastery *Topic mastery *Listening, reading, speaking, writing *Time management *Negotiation & debate *Product promotion • Knowledge pilihan(relatif): *Business ethics

25. Sarana komunikasi perusahaan • Rapat berkala • Diskusi berkala • Pertemuan khusus berkala • Intranet • Surat edaran • Surat keputusan (SK) • Papan pengumuman • Internet / media masa

26. Strategi membangun budaya knowledge sharing • Merumuskan budaya kewajiban utk menggali dan saling berbagi knowledge. • Membangun rasa saling percaya dalam perbedaan kedudukan, kecerdasan, kinerja,dll. • Sistem penghargaan atas prestasi pemanfaatan dan berbagi knowledge. • Job enrichment dan job enlargement. • Memfasilitasi sarana melakukan aktivitas berbagi knowledge: ruang diskusi,ruang seminar, presentasi, kolaborasi, learning, dll. • Dukungan pimpinan.

27. Komponen KMS • IT (hardware, software, network) sebagai infrastruktur untuk berlangsungnya knowledge management, termasuk rancangan KM model, groupware, dsb. • Brainware : tersedianya knowledge manager dan knowledge workers. • Knowledge database dan directory. • Proses / prosedur: berbagai jenis proses yang dirancang untuk berjalannya knowledge managemet secara efektif.

28. Analisis Organisasi melalui 7-s McKinsey • Dikembangkan oleh Peters dan Waterman 1982 dlm bukunya ‘In Search of Excellence’ • Pada era 60-70 fokus pd struktur organisasi. • Era 80-saat ini, seharusnya organisasi fokus pada 7 variabel yang harus saling berkaitan dan berinteraksi untuk kesuksesan pencapaian tujuan yang sama (sistem). • 3 hard variables ( mudah diidentifikasi dan didokumentasikan): strategi, struktur, sistem. • 4 soft variables (relatif sukar diidentifikasi, tacit, sulit didokumentasikan rinci &lengkap).

29. 7-s McKinsey model • 7-s Mckinsey model Structure Strategy Systems Shared values Style Skills Staff

30. Definisivariabel 7-s McKinsey • Hard Variables: 1. Strategy : operational, tactical, and strategic planning and strategies. 2. Structure : strukturorganisasidengankoordinasikerangkakerjaparaanggotaorganisasi. 3. System : sistem-sistem yang adadalamorganisasi (sisteminovasi, kompensasi, sim, dll)

31. Definisivariabel 7-s McKensey • Soft Variables : 1. Style: kultur meliputi pola kepemimpinan, pola kerja karyawan, pola komunikasi dan sosialisasi, dsb. 2. Staff: segala aktivitas pengembangan SDM, manajemen karir, dsb. 3. Skill : kemampuan unik yang dimiliki pimpinan dan staff yang menjadikan keunikan positip organisasi sebagai competitive advantage. 4. Shared values : nilai yang dimiliki seluruh personil perusahaan dalam membangun kesadaran dan motivasi untuk terbiasa dengan rasa senang saling berbagi dan bekerjasama.

32. Knowledge – Knowledge Management Systems

33. Data, Knowledge & Information

34. Knowledge – Knowledge Management Systems (Continued) • Knowledge creation or knowledge acquisition is the generation of new insights, ideas, or routines. • Socialization mode refers to the conversion of tacit knowledge to new tacit knowledge through social interactions and shared experience. • Combination mode refers to the creation of new explicit knowledge by merging, categorizing, reclassifying, and synthesizing existing explicit knowledge • Externalization refers to converting tacit knowledge to new explicit knowledge • Internalization refers to the creation of new tacit knowledge from explicit knowledge. • Knowledge sharing is the exchange of ideas, insights, solutions, experiences to another individuals via knowledge transfer computer systems or other non-IS methods. • Knowledge seekingis the search for and use of internal organizational knowledge. Activities or Processes

35. Knowledge Management– Integration

36. Knowledge Management Value Chain

37. Major Types of KMS

38. Ask-Me Enterprise Knowledge Network

39. Requirements of Knowledge work systems

40. Thank you for Your kind attention 40

41. SESI-6 SELESAI THE END The END