Presentation VB Script

VB Script: 

VB Script

What is VB Script?: 

What is VB Script? Language for creating web browsers Based on Visual Basic Developed by Microsoft Lightweight and active programming language Supported only by Internet Explorer Executed by host Still developed as part of ASP

3 Tier architecture: 

3 Tier architecture Tier 1: Client server contains the presentation logic. Tier 2: Application server provides the business processes logic. Tier 3: Data server provides the business data. Presentation Business logic Database

Slide 4: 

3 Tier advantages: 3 Tier disadvantages: More complex structure Difficult to set up and maintain The separation of business logic and database server may affect performance Easy to replace or modify any tier without affecting the other tiers Improved performance and better load balancing Application servers can be deployed on many machines Improved security

Link between 3 Tier architecture, VBScript and a Student Record Database: 

Link between 3 T ier architecture, VBScript and a Student Record Database VBScript can be found in the Business Logic / Application layer of the three tier architecture. It can be used to create some common features found in a student record database .

Student Record Database: 

Student Record Database The features found in the database include : Personal Details Webmail / Mailbox Examination records Programme of Study details Enrolment details

VBScript and the Student Record Database: 

VBScript and the Student Record Database Research has shown that VBScript can perform the following tasks needed for a Student Record Database : Create users and manage groups Create Mailboxes Encryption and Decryption of the Confidential data in the database . Validation

Supplier Advantages: 

Supplier Advantages No need for expensive software to run it Simple: written in plain language – easy to use No installation needed ( comes with Microsoft) Not case sensitive = less syntax errors It can access everything in the data base

Client Advantages: 

Client Advantages Form validation It can be used to act upon an action ( e.g a click) Makes the webpage more interactive with - forms - forums - applications - etc..

Disadvantages: 

Disadvantages Plain simple language = wordy and awkward VB script must be specified as the language on a webpage Proprietary language Limited to Internet explorer only

Scenario: Oracle database : 

Definition: object relational database management system. Features: Powerful and popular relational database Runs on major platforms ( L inux, Windows, mac os ) Own network component Data objects accesses through Structured Query Language Transparency Flexible data networks Scenario: Oracle database

Scenario: Oracle database and VBScript : 

Scenario: Oracle database and VBScript VBScript language can be used with Oracle database to retrieve information from the database server

JavaScript vs VBScript Similarities: 

JavaScript vs VBScript Similarities Both are easy to learn and use Both make webpages more interactive Both have security issues

JavaScript VS VBScript Differences: 

JavaScript VS VBScript Differences Java is the default scrippting language on webpages – VB script must be specified Java Script works with all popular web browsers – VB script only functions with Internet Explorer Java Script is case sensitive where as VB script is not

Additional Information: 

Additional Information http://answers.oreilly.com/topic/234-is-vb-extinct-as-a-language/

Conclusion and Recommendations: 

Conclusion and Recommendations VBScript was one of the top 20 languages used in 2009 (as seen on the previous graph) Supports client side and web development and can be used with Oracle database However , VBScript is not an ideal solution when used in the Application server, mainly because it is limited to Internet Explorer only . More logical solution would be JavaScript