1 / 53

DETERMINING SYSTEM REQUIREMENT

Explore how to design, implement, and maintain a data base for server content. Learn planning, selection, and system operation.

vickers
Download Presentation

DETERMINING SYSTEM REQUIREMENT

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DESIGN THE WEB of DATA BASE FOR THE CONTENT OF SERVER DETERMINING SYSTEM REQUIREMENT HOME

  2. Dasar Kejuruan Level I ( Kelas X ) Level III ( Kelas XII ) Level II ( Kelas XI ) 2 3 1 Merakit Personal Komputer Menerapkan teknik elektronika analog dan digital dasar Melakukan instalasi perangkat jaringan lokal (Local Area Network) Melakukan instalasi perangkat jaringan berbasis luas (Wide Area Network) Melakukan instalasi sistem operasi dasar Mendiagnosis permasalahan perangkat yang tersambung jaringan berbasis luas (Wide Area Network) Mendiagnosis permasalahan pengoperasian PC yang tersambung jaringangnosis Menerapkan fungsi peripheral dan instalasi PC Menerapkan K 3 LH Membuat desain sistem keamanan jaringan Mendiagnosis permasalahan pengoperasian PC dan periferal Melakukan perbaikan dan/atau setting ulang koneksi jaringan an Melakukan perbaikan dan/atau setting ulang sistem PC Melakukan instalasi sistem operasi jaringan berbasis GUI (Graphical User Interface) dan Text Melakukan perbaikan dan/atau setting ulang koneksi jaringan berbasis luas (Wide Area Network) Melakukan perbaikan periferal Mengadministrasi server dalam jaringan Melakukan perawatan PC Merancang bangun dan menganalisa Wide Area Network Melakukan instalasi sistem operasi berbasis graphical user interface (GUI) dan command line interface (CLI) Merancang web data base untuk content server Melakukan instalasi software Lulus COMPETENCE MAPING Klik Disini Merancang web data base untuk content server HOME

  3. DETERMINING SYSTEM REQUIREMENT DETERMINING PROCEDURE RECOVERY DESIGN THE ARCHITECTURE of DATA BASES CLARIFYING USE of DATA BASES Modul 19 Design The Web of Data Base For Content Of Server

  4. Target Activity of Study 1. Competitor diklat able to design database according the target 2. Competitor diklat able to implementation database system Modul 19 Design The Web of Data Base For Content Of Server

  5. In determining requirement system of Data bases is not quit of how in fact that data bases is designed Modul 19 Design The Web of Data Base For Content Of Server

  6. Target of database Scheme • To fulfill information comprising requirement user peculiarly and its applications • Facilitating congeniality of information structure • Supporting process requirement and some obyek appearance ( response time, processing time, and storage space Modul 19 Design The Web of Data Base For Content Of Server

  7. Database Systems Definition Requirements Collection And Analysis Database Design Conceptual DBMS Selection Application Design Logical Design Physical Design Implementation Data Loading And Conversion Prototyping Testing Operational Maintenance S I K L U S HI D U P SISTEM B A SI S D A TA Modul 19 Merancang Web Data Base Untuk Content Server

  8. Activities of which deal with database as micro life cycle Database Planning Application Conversion System definition Testing and Validation Design Operation Implementation Monitoring and Maintenance Loading atau Data Conversion Modul 19 Design The Web of Data Base For Content Of Server

  9. Phase 1: Requirements Collection and analysis Data requirements Processing requirements Transaction design (DBMS-independent) Conceptual & external Schema design (DBMS-Independent Phase 2: Conceptual Design Phase 3: Choice of DBMS Phase 4: Data Model Mapping (logical design) Conceptual & external Schema design (DBMS-dependent Frequencies, performance constraint Phase 5: Physical Design Internal Schema design (DBMS-dependent Phase 6: Implementation Transaction Implementation DDL-statements SQL-statements PHASE of DATABASE SCHEME Modul 19 Design The Web of Data Base For Content Of Server

  10. Peculiarly process the scheme comprise 2 parallel activity Scheme from content of data and database structure Scheme of Process of and database software application Modul 19 Design The Web of Data Base For Content Of Server

  11. Process the Database Scheme I Data collecting and analyze II Database scheme conceptually III Election DBMS IV Database scheme logically ( data model mapping ) V Database scheme in physical VI System implementation Database Modul 19 Design The Web of Data Base For Content Of Server

  12. I. Data collecting and analyze Activities of data collecting and analyze - Activities of data collecting and analyze - ExistingDocumentation sighting - Environmental analysis operate for and data process - Questionnaire and interview Modul 19 Design The Web of Data Base For Content Of Server

  13. II. Database scheme conceptually Phase of database Scheme conceptually have two parallel activity - Conceptual Scheme - Transaction scheme Modul 19 Design The Web of Data Base For Content Of Server

  14. III. Election DBMS Economic factors and organization influencing one another in election DBMS - Data structure - Personal which have accustomed to an system - The available of seller service Modul 19 Design The Web of Data Base For Content Of Server

  15. Result from this phase hence comands DDL in Ianguage DBMS IV. Database scheme logically ( mapping model data ) Its mapping can be processed in 2 level - mapping System-Independent - Scheme adjustment to specific DBMS Modul 19 Design The Web of Data Base For Content Of Server

  16. V.Database scheme in physical Some guide in election database scheme in physical - Response time - Space utility - Transaction throughput Modul 19 Design The Web of Data Base For Content Of Server

  17. VI. System Implementation Database Specification is conceptually tested and attributed to [by] a code program with the commands from embedded DML which have been writted and tested Modul 19 Design The Web of Data Base For Content Of Server

  18. Question : Mentioning process – process scheme of database ! Modul 19 Design The Web of Data Base For Content Of Server

  19. DESIGN THE WEB of DATA BASE FOR THE CONTENT OF SERVER DETERMINING PROCEDURE RECOVERY HOME

  20. Target Activity of Study 1. Competitor diklat able to determine the correct procedure of recovery 2. Competitor diklat knew the technique in procedure recovery HOME Modul 19 Design The Web of Data Base For Content Of Server

  21. Transaction Recognition and the Process TRANSACTION REPRESENT THE LOGIC UNIT [of] FROM DATABASE PROCESS INCLUDING ONE OR MORE OPERATE FOR TO ACCESS THE DATABASE COVER THE INSERT, DELETE, MODIFICATION OR OPERATE FOR RETRIEVE Modul 19 Design The Web of Data Base For Content Of Server

  22. Status of Transaction and Additional Operation - BEGIN_TRANSACTION - READ or WRITE - COMMIT_TRANSACTION - ROLLBACK (or ABORT) Modul 19 Design The Web of Data Base For Content Of Server

  23. Read, Write Begin Transaction End Trancaction Partially Committed Commit Active Commited Abort Abort Failed Terminated Transaction Process Modul 19 Design The Web of Data Base For Content Of Server

  24. Recovery Concept Recovery from a transaction failure usually mean database in restore to consistent status to time before happened failure Modul 19 Design The Web of Data Base For Content Of Server

  25. Especial Technique In Recovery I. Deferred update II. Immediate update Modul 19 Design The Web of Data Base For Content Of Server

  26. I. Deferred update Idea from protocol update delayed A transaction cannot change the database at disk till reach the dot point A transaction cannot reach the dot point till all operation update kept in logarithm and writed to disk Modul 19 Design The Web of Data Base For Content Of Server

  27. Two Operation Recovery At Deferred Update Recovery updated is delayed at single-user Recovery update delayed executed is concurrent at multi-user Modul 19 Design The Web of Data Base For Content Of Server

  28. Procedure of REDO Operate for the REDO have the nature of idempotent, that is execute recurring that happened- repeat is equal to once just execute Modul 19 Design The Web of Data Base For Content Of Server

  29. Excess of Method REDO Advantage from method or algorithm NO-UNDO / redo is transaction operation have never been required not to become executed Modul 19 Design The Web of Data Base For Content Of Server

  30. Reason Transaction do not note all changes in in database at disk reach the point commit Transaction will never read the value writted by transaction which not yet commit Modul 19 Design The Web of Data Base For Content Of Server

  31. II. Immediate update In this technique, database will be updated by some transaction before transaction reach the point Modul 19 Design The Web of Data Base For Content Of Server

  32. Shadow Paging This scheme Recovery do not require the logarithm use at single-user. At multiuser, a logarithm required for the method of concurrent control Modul 19 Design The Web of Data Base For Content Of Server

  33. Question : Mentioning status of transaction and additional operation in process recovery ! Modul 19 Design The Web of Data Base For Content Of Server

  34. DESIGN THE WEB of DATA BASE FOR THE CONTENT OF SERVER DESIGN THEARCHITECTURE OF DATA BASES HOME

  35. Target Activity of Study 1.Competitor diklat able to comprehend the type of data independence 2. Competitor diklat knew levels in data bases HOME Modul 19 Design The Web of Data Base For Content Of Server

  36. Target of System Data Bases Especial target from system of data bases is provide the wearer of through an abstraction view of concerning data, by hiding detail from how data kept and manipulate Modul 19 Design The Web of Data Base For Content Of Server

  37. Level of Architecture of data Bases - External Level - Conseptual Level - Internal Level Modul 19 Design The Web of Data Base For Content Of Server

  38. VIEW 1 VIEW 1 VIEW 1 EXTERNAL LEVEL CONSEPTUAL LEVEL INTERNAL LEVEL Level Architecture of data Bases Modul 19 Design The Web of Data Base For Content Of Server

  39. Independence Data Especial target from 3 architecture level is look after the independence data Type of Independence Data - Physical Data Independence - Logical Data Independence Modul 19 Design The Web of Data Base For Content Of Server

  40. External Schema External Schema External Schema External / Conceptual Mapping Logical Data Independence Conseptual Schema External / Conceptual Mapping Logical Data Independence Internal Schema Scheme of Data Bases Modul 19 Design The Web of Data Base For Content Of Server

  41. Principle of Data independence is one of matter which must be applied in management of system of data bases with reason • DBA can alter the content, location, materialization in organization of data bases without bothering application program • Factory / equipments agent / software of data processing can introduce the new product without bothering application program • To remove the application program growth Modul 19 Design The Web of Data Base For Content Of Server

  42. Question : There is 3 level in architecture of data bases aim to differentiate the way of wearer approach to data bases and way of making data bases in physical Mentioning and decripcting level of the data bases architecture ! Modul 19 Design The Web of Data Base For Content Of Server

  43. DESIGN THE WEB of DATA BASE FOR THE CONTENT OF SERVER CLARIFYING USE OF DATA BASES HOME

  44. Target Activity of Study 1. Competitor of diklat can implementation data bases in the Multimedia and Internet HOME Modul 19 Design The Web of Data Base For Content Of Server

  45. Application of Data Bases I Data bases for the Multimedia II Data bases for the internet - Universal Resource Locator (URL) - Web Server - Web Display Language Modul 19 Design The Web of Data Base For Content Of Server

  46. I. Data bases for the Multimedia Condition which must be full filed by if on file data multimedia in data bases • Data bases have to can accommodate the big object • Existence of facility for the intake of data of pursuant to looking like ( similarity-based retrieval) what is needed by a lot of application of basisdata multimedia Modul 19 Design The Web of Data Base For Content Of Server

  47. II. Data bases for the Internet World Wide Web ( WWW) represent the system of distribution information being based on hypertext. Document becoming especial unsure in web can be expressed in a few type. most type of popular is document hypertext Modul 19 Design The Web of Data Base For Content Of Server

  48. Universal Resource Locator (URL) System Hypertext contain the consequence of about existence of depository of pointer ( indicative [of] location) to document place reside in. In web, this function pointer is given by Universal of Resource Locator ( URL) Example : http://www.smkn5malang.sch.id Modul 19 Design The Web of Data Base For Content Of Server

  49. Web Server When a server HTTP accept demand for certain document intake, server execute the program and deliver the document HTML yielded by a the program. Farther, client web can deliver the additional argument to be used by program at the (time) of executing Modul 19 Design The Web of Data Base For Content Of Server

  50. Web Display Language Language for the text of markup language, like Standard of Generalized Markup Language ( SGML), develop, build to fill the blankness of among artless text and description page yard by order of formatting text Modul 19 Design The Web of Data Base For Content Of Server

More Related