1 / 14

Matrikulasi Basis Data

Matrikulasi Basis Data. Teguh Bharata Adji. Model E-R. Model E-R mudah dimengerti karena dikembangkan sesuai dengan kondisi dunia nyata, yang selalu melihat segala hal berdasarkan obyek. Komponen-komponen dari Model E-R yang utama adalah: Entitas Atribut Relasi

zinnia
Download Presentation

Matrikulasi Basis Data

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. Matrikulasi Basis Data Teguh Bharata Adji

  2. Model E-R • Model E-R mudah dimengerti karena dikembangkan sesuai dengan kondisi dunia nyata, yang selalu melihat segala hal berdasarkan obyek. • Komponen-komponen dari Model E-R yang utama adalah: • Entitas • Atribut • Relasi • Model E-R digambarkan dengan Diagram E-R, suatu diagram yang menggunakan simbol-simbol seperti pada Gb. • Entitas diwakili persegi panjang, atribut diwakili elips dan relasi diwakili diamond.

  3. Notasi E-R

  4. Notasi E-R lain

  5. Simbol pada Diagram E-R

  6. Contoh Entitas

  7. Inter-module Communications • There are 2 places of internal interaction between 3 sub-systems: • Front End ↔ Back End. • Back End ↔ SCADA Engine. • There are 2 points of external interaction with the 3 sub-systems: • User ↔ Front End. • SCADA Engine ↔ Attached Peripheral.

  8. Inter-module Communications Schema Figure 3:

  9. Front End ↔ Back End • A text based TCP protocol called “Front end listener” will be develop as a module in the back end dedicated to communicate with the front end. • The communication protocol is based on plain, line based ASCII, using a server socket which waits for connections. The front end is always the initiator of a conversation. • Requests which can be made by the front end via this channel: • find out SCADA Engine status. • send a message to SCADA Engine. • Plain ASCII is used such that it is easy to work with and debug the system. • The text is transferred in XML format as it gives the benefit of uniformity, scalability, and ease of use of other developer.

  10. Back End ↔ SCADA Engine • This communication has 2 interfaces, the data channel and the control channel. Both are TCP connections. • Control Channel: • ?. • Data Channel: • SCADA Engine connects to the Back End on the port specified during initial conversation. • Messages are sent back and forth through data channel at the request of the user. • A message is defined as a sequence of ASCII characters terminated by a line-feed(\n) character, because of the easy testing.

  11. User ↔ Front End • It is implemented using a web interface.

  12. SCADA Engine ↔ Peripheral • It will be dependent on the particular peripheral attached. • Many peripherals will use basic digital/analogue IO, or RS-232 (with help from the compiler’s RS-232 library) together with the available DB-9 serial port.

  13. 4. Implementation • Equipment: • SCADA Engine board, which can be purchased. • PIC programmer. • DB-25 printer cables to connect the computer to the PIC programmer. • GPRS or CDMA data packet capable mobile phone or modem and an account with a mobile network service provider. • A PC: • must be connected to the Internet and have a globally accessible IP address (non private). • having some software (1) for development of this project, and (2) installed on the PC when used as a server (see Table).

  14. 5. Degree of Success • The system achieves the basic goals: • simple to use. • simple to maintain. • adaptable. • more real time than the previous project (Mayer, 2002). • more robust solution than the previous system. • The system can be used in a real life situation.

More Related