Sistem Informasi Berbasis Web Membangun Sistem Informasi Berbasis

Sistem Informasi Berbasis Web Membangun Sistem Informasi Berbasis Web Priyo SS

Sistem Informasi Berbasis Web Overview ª Introduction to Decision Support Systems ª Building a Web-Enabled Decision Support System ª Integrating DSS in Business Curriculum 2

Sistem Informasi Berbasis Web Decision Support Systems (DSS) ª A decision support system is an information system that assists the user in decision-making. Knowledge Base Database Model Base GUI User 3

Sistem Informasi Berbasis Web Developing Interactive Systems ª Practical decision making requires developing man-machine interactive systems. Input Data The Model Output, Reports User Interface, Re-optimization 4

Sistem Informasi Berbasis Web Importance of DSS Development Skills ª Help us package models and algorithms. ª Combine modeling with human experience ª Highly desirable for consulting jobs for students ª Useful for academics to get industry grants ª New consulting opportunities for faculty members 5

Sistem Informasi Berbasis Web DSS Development Process ª Data Storage Mechanism ª MS Excel, Lotus 123 ª MS Access, Oracle, MS SQL Server, Dbase ª Data Manipulation ª Visual Basic for Applications (VBA) ª Visual Basic. NET (VB. NET) ª Java, C/C++ ª Data Presentation ª VBA, VB. NET, MS Access, ASP. NET ª Java Applets 6

Sistem Informasi Berbasis Web Two Common Ways to Develop DSS ª Spreadsheet-Based Decision Support Systems ª Spreadsheets ª Excel features ª VBA for Excel ª Web-Enabled Decision Support Systems ª Databases ª Microsoft Access ª VB. NET ª ASP. NET JULY 9, 2004 7

Sistem Informasi Berbasis Web Overview ª Introduction to Decision Support Systems ª Building a Web-Enabled DSS ª Integrating DSS in the Business Curriculum 8

Sistem Informasi Berbasis Web Components of a Web-Enabled DSS ª Databases ª Database Management System (Access DBMS) Users Database Application DBMS ª Developing GUI ª Web-Enabling the Application Database 9

Sistem Informasi Berbasis Web Data Modeling ª Systematically converts E-R Diagram into Relations Company Name Date. Added Symbol Type PID PORTFOLIO STOCK Has Object Data Model Quantity Portfolio PID Portfolio Details PID Name Date. Added Symbol Quantity Relational Data Model Stock Symbol Company Type 10

Sistem Informasi Berbasis Web Access DBMS: Developing Environment ª Access Environment: Facilitates development process. Toolbar Main Menu Database Window Object Bar Table Objects Database View 11

Sistem Informasi Berbasis Web Tables and Relationships ª Tables: Stores data ª Relationships Window: Relates data Database Tables Attributes 12

Sistem Informasi Berbasis Web Queries ª Queries: Processes data Table Pane Design Grid Query Output 13

Sistem Informasi Berbasis Web Data Manipulation using SQL ª Structured Query Language (SQL) is the most powerful and commonly used query language. Sample SQL Command: SELECT Porfolio. ID, Name, Type FROM tbl. Portfolio WHERE Type Like “Auto*” OR Like “Insurance*” 14

Sistem Informasi Berbasis Web Components of a Web-Enabled DSS ª Databases ª Database Management System (DBMS) ª Developing GUI (VB. NET) ª Web-Enabling the Application (ASP. NET) Users Database Application DBMS Database 15

Sistem Informasi Berbasis Web What is. NET ? ª. NET is a set of Microsoftware technologies for connecting information, people, systems, and devices. ª. NET Framework is a common layer between. NET applications and Windows OS. . Net Applications VC++ VB C# Other Components Class Library Common Language Runtime (CLR) Windows Operating System . NET Frame work ª. NET Applications are VB / VC++ / C# programs written on. NET Framework. 16

Sistem Informasi Berbasis Web VB. NET Developing Environment ª Visual Studio. NET is the Interactive Development Environment (IDE) for. NET applications. Design Window 17

Sistem Informasi Berbasis Web Exploring VS. NET IDE Features … ª Create new/open existing projects. (Open the existing portfolio application. ) ª Solution explorer lists all the files for the current solution. (Double click ‘Welcome. vb’ file to view its design. ) 18

Sistem Informasi Berbasis Web Exploring VS. NET ID Features (Contd…) ª Design Window is the actual work place; displays form design and VB. NET code. (Double click anywhere on this form to open its code window. ) ª Tool. Box is a gazette of controls: forms building blocks. (Add a button and label controls to the form. ) 19

Sistem Informasi Berbasis Web Exploring VS. NET ID Features (Contd…) ª Properties Window sets properties for controls and in a way their appearance and behavior. (Set Name, Text, Font, Back Color properties on these controls. ) ª Menu bar and Toolbars are handy for supporting operations like save, run, add items. (Save the project and run the application. ) 20

Sistem Informasi Berbasis Web VB. NET Programming Language ª Like other programming languages VB. NET supports: ª Interaction with user (user input / output) ª Arithmetic, logical, and string operations ª Control structures ª Modules, Classes, Procedures, Methods ª Data structures like arrays A A Loop False True Conditio n Else Condition If B True False B 21

Sistem Informasi Berbasis Web Programming…Interactive Process ª VB. NET is event driven programming. (Double click the button control and add following code for its On. Click event. ) Event List ª Code window lists all the controls and their events for us. (Browse the combo boxes on top of the code window. ) 22

Sistem Informasi Berbasis Web Programming. . . Interactive Process (Contd) ª Programming is even more fun now. Get all the help online as you code. Intelli. Sense Online tip ª Organize your code in nice and neat format using region feature of IDE. (Browse through to play with these features. ) 23

Sistem Informasi Berbasis Web ADO. NET: Database Connectivity ª ADO. NET structure makes is easy to: ª Connect to a database ª Run SQL queries against it ª Store and further process query results ª Add/Update/Delete records from database Databases Connection Data Adaptor (SQL Query) Datasets (Stores query output) VB. NET Forms & Controls 24

Sistem Informasi Berbasis Web ADO. NET: Database Connectivity (Contd. . ) ª Steps for querying a database and showing results on VB. NET form: ª Connect to a database (once for a project) ª Create a data adaptor with desired SQL statement ª Create a dataset to store query results ª Bind the control to the dataset ª Run the query by writing VB. NET code 25

Sistem Informasi Berbasis Web Connection, Adaptor, and Dataset ª Server Explorer makes it easy to connect to a database. (Connect to the Portfolio database. ) Drag & Drop ª Toolbox assists in the creation of data adaptors, and data sets. (Portal form: Add an adaptor and a dataset to get the list of portfolios. ) 26

Sistem Informasi Berbasis Web Binding Controls to Dataset ª We then bind controls to datasets to show query results on forms using property window for a control. (Bind the dataset created to the list box on Portal form. ) 27

Sistem Informasi Berbasis Web Writing Code to Execute a Query? ª Next we run the query and display the data. It is done by writing 2 lines of VB. NET code. (Write this code for list box control on page load event. ) 28

Sistem Informasi Berbasis Web VB. NET Events and Data Retrieval ª Data retrieval (using adaptor and datasets) and VB. NET events can be combined together for interesting functionalities. (On selection of portfolio from list display its details in the data grid control. ) 29

Sistem Informasi Berbasis Web VB. NET Events & Data Retrieval (Contd. . ) Steps: ª Create adaptors and datasets and bind them to respective controls. (Bind to list box and data grid. ) ª Execute a parameter query for second control on some event of first control. (Here we execute parameter query for data grid on selection change event of list box. ) 30

Sistem Informasi Berbasis Web Add/Update/Delete Records from DB ª Data adaptor, dataset and their methods makes altering database very easy. (Add these one liners to On. Click event of respective buttons. ) Me. Binding. Context(Ds. Inv. Info, "tbl. Investor"). Cancel. Current. Edit() Me. Binding. Context(Ds. Inv. Port, "tbl. Portfolio"). Remove. At (lst. Port. Selected. Index) Ole. Db. Inv. Info. Update(Ds. Inv. Info) 31

Sistem Informasi Berbasis Web Using VB. NET’s Advance Controls ª We can use advance controls like Check List Box, Trees controls for nice functionalities. (Use check list box to display list of stocks allowing multiple selections, then display data for all selected stocks in the data grid. ) 32

Sistem Informasi Berbasis Web Using VB. NET’s Advance Controls (Contd. . ) ª We can use advance controls line Date Time Picker for professional looks. (Use this control to allow user choose year for performance graph. ) 33

Sistem Informasi Berbasis Web VB. NET and OOPS ª VB. NET is a complete Object Oriented Programming Language (OOPL). ª VB. NET with its Class structure now supports all three basic OOP principles: ª Encapsulation ª Inheritance ª Polymorphism ª What it is good for? ª Data hiding and data encapsulation ª Code reusability ª Split the development task into independent modules 34

Sistem Informasi Berbasis Web Other Supported Features ª Exception Handling: Preparing for worse!! (Browse through the code for portfolio form for Try. . . Catch. . . End Try blocks. ) ª Code Debugging: Towards perfection! (Press F 5 and click for optimization, debugging window pops up, press F 8 to step through. ) 35

Sistem Informasi Berbasis Web Plug-in Optimization/Simulation Packages Some of the available options are: ª Optimization code using VB. NET language. (Illustrated next. ) ª Use VB. NET to connect to C/C++ code. (Using DLL files or through flat text files. ) ª Use MS Excel functionalities. For example, we can use Excel Solver functionality to solve small to medium size optimization problems through VB. NET. 36

Sistem Informasi Berbasis Web Portfolio Optimization Problem Optimization Code Results On Click User Input Dataset has Data From Database 37

Sistem Informasi Berbasis Web Working with Crystal Reports ª Crystal reports are used to produce professional quality reports/graphs to summarize information. (Plot the pie chart for the output of the portfolio optimization result. ) 38

Sistem Informasi Berbasis Web Working with Crystal Reports (Contd. . ) ª Steps for displaying crystal report on VB. NET form: ª Have the data to plot in a dataset. (This might be from database or result of some operation like optimization. ) ª Create the crystal report layout using “Report Expert Wizard” (Select type, fields, format etc. for graph. ) ª Associate the crystal report and the dataset in VB. NET code. (This requires only 3 lines of code. ) 39

Sistem Informasi Berbasis Web Working with Crystal Reports (Contd. . ) Dataset with data to plot VB. NET Code Chart Expert Wizard Final Graph 40

Sistem Informasi Berbasis Web ASP. NET – Web Connectivity ASP. NET = Internet + HTML + VB. NET ª Knowledge of Web Terms and Internet ª Hypertext Manipulation Language (HTML) - for data presentation ª Visual Basic. NET (VB. NET) - code behind web pages, for data manipulation 41

Sistem Informasi Berbasis Web How This Works? 42

Sistem Informasi Berbasis Web Developing ASP. NET Application ª Developing ASP. NET Application is very similar to VB. NET Application development. (Make Portal form of VB. NET application web-enabled using ASP. NET. ) ª We use Web Controls and HTML controls for Windows controls used in VB. NET application. ª VB. NET code with minor additions can be used as ‘code behind’ for ASP. NET pages. ª HTML code is automatically generated by the Visual Studio. NET IDE. 43

Sistem Informasi Berbasis Web Overview ª Introduction to Decision Support Systems ª Building a Web-Enabled DSS ª Integrating DSS in Business Curriculums 44

Sistem Informasi Berbasis Web Teaching DSS Development Courses ª The University of Florida is currently offering two separate courses on DSS Development: ª Developing Spreadsheet-Based DSS ª Developing Web-Enabled DSS ª 3 -credit courses ª Project-oriented courses 45

Sistem Informasi Berbasis Web Course Delivery ª Hands-on course ª Students bring laptops ª Instructor uses LCD Projector ª After basic topics from Power. Point presentations are taught, we do in-class assignments. ª Weekly homework assignments. ª Students do semester-long team projects in which they develop full DSS applications. 46

Sistem Informasi Berbasis Web Outline of Web-Enabled DSS Course ª Part 1: (3 weeks) ª Database design principles ª Microsoft Access, Tables, Queries, SQL ª Part 2: (6 weeks) ª. Net Platform, VB. Net programming Language ª Windows forms and controls, Database connectivity ª Crystal reports ª Part 3: (3 weeks) ª HTML, ASP. Net, Database connectivity in Web forms ª Part 4: (2 weeks) ª Project work ª Developing and presenting DSS applications 47

Sistem Informasi Berbasis Web-Enabled DSS Textbook Abhijit Pol Ravindra K. Ahuja 48

Sistem Informasi Berbasis Web The Book Outline ª Part I: Principles of Database Design ª Part II: MS Access: A DBMS ª Part III: DB Programming using VB. NET ª Part IV: Web-Connectivity using ASP. NET ª Part V: Case Studies 49

Sistem Informasi Berbasis Web Case Studies ª NASA’s Rocket Science ª University Student Information System ª TV Channel Project ª Airline Scheduling ª Portfolio Management ª Online Shopping 50

Sistem Informasi Berbasis Web Additional Course Material ª Power. Point Presentations ª Review Questions and Hands-On Exercises ª Solution Manual for Instructors ª Student Team Projects ª Web Resources 51

Sistem Informasi Berbasis Web Another DSS Textbook ª Michelle M. Hanna ª Ravindra K. Ahuja ª Wayne L. Winston 52

Sistem Informasi Berbasis Web DSS Development Workshop INFORMS TEACHING MS WORKSHOP 2004 53

Sistem Informasi Berbasis Web Additional Information Course material website: www. ise. ufl. edu/IT Workshop website: www. ise. ufl. edu/DSS Interested in course material? Please give us your card or email address. 54