1 / 179

Progress Database Admin

Progress Database Admin. Jeffrey A. Brown - Technical Support Consultant (jefbrown@nxtrend.com). 1. Introduction:. 2. Agenda:. Lecture - Database Concepts Lunch Database Workshop (hands-on). 3. NxTrend & Progress:. NxTrend & Progress NxTrend runs on products we sell. 4.

klaus
Download Presentation

Progress Database Admin

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. Progress Database Admin Jeffrey A. Brown - Technical Support Consultant (jefbrown@nxtrend.com) 1

  2. Introduction: 2

  3. Agenda: • Lecture - Database Concepts • Lunch • Database Workshop (hands-on) 3

  4. NxTrend & Progress: • NxTrend & Progress • NxTrend runs on products we sell. 4

  5. What Is Progress? • Not an O/S • Database engine • 4GL Programming language 5

  6. Licensing • Enterprise DB • Appserver • 4GL • Provision (PC Client side) • Client Networking • Query/Results (being replaced by SX.explorer) • Merant (ODBC) 6

  7. Progress Database Concepts: • Physical Parts of a Database • .db - database • .bi – before image file • .lg – log file • .lk – lock file (only there when Broker is up) 7

  8. .db .bi .lg 8

  9. Starting The Database Broker • Unix Process • Shared memory • virtual tables • lock file (.lk) 9

  10. _mprosrv .db .bi .lg 10

  11. Shared Memory _mprosrv .db .bi .lg 10

  12. Shared Memory Virtual tables User id Lock TTY PID 11

  13. Shared Memory Virtual tables u l t p _mprosrv .db .bi .lg 12

  14. Shared Memory Virtual tables u l t p _mprosrv .db .bi .lg .lk 12

  15. User Login • Unix Process • Logs into virtual tables • Logged in the log file (.lg) 13

  16. User 1 Shared Memory Virtual tables u l t p _mprosrv .db .bi .lg .lk 14

  17. User 1 _progres Shared Memory Virtual tables u l t p _mprosrv .db .bi .lg .lk 14

  18. User 1 _progres Shared Memory Virtual tables u l t p u1 _mprosrv .db .bi .lg .lk 14

  19. Shared Memory Virtual tables User id Lock TTY PID User 1 tty/01 12345 15

  20. User 1 _progres Shared Memory Virtual tables u l t p u1 _mprosrv .db .bi .lg .lk 16

  21. User 1 _progres Shared Memory Virtual tables u l t p u1 _mprosrv .db .bi .lg .lk 16

  22. Data-Flow Discussion • Data gets pulled into memory • User reads from memory • User never read from the database 17

  23. User 1 _progres Shared Memory Virtual tables u l t p u1 _mprosrv a b c .db .bi .lg .lk 18

  24. User 1 _progres Shared Memory Virtual tables u l t p a b c u1 _mprosrv a b c .db .bi .lg .lk 18

  25. User 1 _progres Shared Memory Virtual tables a b c u l t p a b c u1 _mprosrv a b c .db .bi .lg .lk 18

  26. Data-Flow Discussion • User Updates data • lock table 19

  27. User 1 _progres Shared Memory Virtual tables a b d u l t p a b c u1 c _mprosrv a b c .db .bi .lg .lk 20

  28. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv a b c .db .bi .lg .lk 20

  29. Data-Flow Discussion • Before-Image File • BIW • Data gets written to disk (.bi file) 21

  30. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv a b c .db .bi .lg .lk 22

  31. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv a b c .db biw .bi .lg .lk 22

  32. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv a b c .db biw .bi bt .lg .lk 22

  33. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv a b c .db biw .bi bt c .lg .lk 22

  34. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv a b c .db biw .bi bt c .lg .lk 22

  35. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv a b c .db biw .bi bt c d .lg .lk 22

  36. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv a b c .db biw .bi bt c d et .lg .lk 22

  37. Data-Flow Discussion • Review 23

  38. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv a b c .db biw .bi bt c d et .lg .lk 24

  39. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv a b c .db biw .bi bt c d et .lg .lk 24

  40. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv a b c .db biw .bi bt c d et .lg .lk 24

  41. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv a b c .db biw .bi bt c d et .lg .lk 24

  42. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv a b c .db biw .bi bt c d et .lg .lk 24

  43. Data-Flow Discussion • After-Imaging File • AIW 25

  44. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv a b c .db biw .ai .bi bt c d et .lg .lk 26

  45. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv aiw a b c .db biw .ai .bi bt c d et .lg .lk 26

  46. Data-Flow Discussion • Asynchronous Page Writer • APW • Data gets written to .db 27

  47. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv apw aiw a b d .db biw .ai .bi bt c d et .lg .lk 28

  48. Data-Flow Discussion • Final Review 29

  49. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv apw aiw a b d .db biw .ai .bi bt c d et .lg .lk 30

  50. User 1 _progres Shared Memory Virtual tables a b d u l t p a b d u1 _mprosrv apw aiw a b d .db biw .ai .bi bt c d et .lg .lk 30

More Related