1 / 22

Developing Sophisticated Applications in SIR

Developing Sophisticated Applications in SIR. Unsophisticated. I’m the only user I’m only go to do this once anyway I know what these codes mean If anyone wants any of this stuff they have to come to me anyway You can do anything with a spreadsheet. Sophisticated Applications.

fionan
Download Presentation

Developing Sophisticated Applications in SIR

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. Developing Sophisticated Applications in SIR New York Conference 2005

  2. Unsophisticated • I’m the only user • I’m only go to do this once anyway • I know what these codes mean • If anyone wants any of this stuff they have to come to me anyway • You can do anything with a spreadsheet

  3. Sophisticated Applications • Other People Use It • Reliable • Repeatable • Long Lived • Changes in People • Changes in Application • Understand Requirements • Implementation may not be the problem

  4. Data, Processes and Interfaces • Database Design • Driven by data • Data Analysis from existing/proposed documents or systems • Records and Keys • Coding systems • Processes – who, what, when? • Regular Data Input • Standard Tasks • Interfaces to other systems • Queries and analyses

  5. Data, Processes and Interfaces • User Interface • Easy to use • Easy to learn • Consistent • Implementation Issues • Test Database • Data Base Administration • Long Term Maintenance • Documentation

  6. Building Sophisticated Applications in SIR • ‘Cooking with SIR’ • Known Ingredients • Possibly some old favorites • Fresh Ideas • Four presenters • Tony Reardon & David Baxter • SIR developers • Dave Doulton and Tom Shriver • Long term sophisticated SIR users

  7. Timetable • Day 1 12:30 Overview Creating and Maintaining a Database 14:30 Building User Interfaces – David Baxter • Day 2 9:00 Building Sophisticated Processes 10:30 – 11.00 Converting from earlier versions of SIR – David Baxter 13:00 Exchanging Data between SIR and other Systems – Dave Doulton 14:30 A Case Study – Tom Shriver

  8. Creating and Maintaining a Database • New Database • Logical Design • Normalization • Eliminate redundant data • Identify data dependencies – keys • SIR Schemas • PQL Schema Functions • Simple Data Dictionary

  9. Internals of SIR database • Structure of records • Structure of blocks • Structure of index • Loading Factor

  10. Concurrent Update • Master • General Principles • Database Access • Lock Management • ‘Difference File’ • Managing Master

  11. Backup and Restore • Unload/Reload • Journals • Restructuring • Export/Import • Verify

  12. Building User Interfaces in SIR • Menus & Dialogs • Generic Database Applications • Spreadsheet & Forms • Other Interface Possibilities

  13. Menus and Dialogs • Menu Overview • Writing and Running Menu Programs • Menu Tips • Dialog Overview • Dialog Programs • Dialog Painter • Dialog Tips & Tricks

  14. Generic Database Applications • Programs and Retrievals • Schema Functions • Generating Code • Example Applications

  15. Spreadsheet & Forms • PQLForms • Writing Forms • Generating Forms • Forms Painter • SPREADSHEET DBMS command • GRID PQL Command • PQL+Forms+Grid

  16. Other Interface Possibilities • GUI vs Console Interfaces • ODBC/SIRSQLs Interface • CGI Interface • API Interface

  17. Building Sophisticated Processes • Review of SIR Structure • Command Processing ‘scripts’ • Use of Globals • PQL as development tool • Review of Syntax • Recent Commands

  18. PQL • EXECUTE DBMS • GUI commands outside Dialogs • Current capabilities for file and directory processing • ARRAY Processing • GRID command • LOOKUP command • PQLForms

  19. Converting from Earlier Versions of SIR • EXPORT/IMPORT • PQL Programs • ICE Procedures • FULLSCREEN PQL • SIR3.2 Menus • SIRFORMS • HELP Tabfiles • Tips & Tricks

  20. Exchanging Data between SIR and Other Systems • ODBC • Setting up ODBC sources • ODBC import • ODBC PQLl • ODBC members • Using sirweb.cgi • ODBC and sirweb.cgi • ODBC and PQLServer

  21. Case Study • Implementation Philosophies & Strategies for Sophisticated Applications • Brief description of the MNYR database • Database Management on Remote Control • A Model for End-User Database Navigation Systems • Useful End-User Features

  22. Developing Sophisticated Applications in SIR New York Conference 2005

More Related