WorkShop 7

ITC382 Client Server Applications
Tutorial 7

Creating an Online Store II

WorkShop 6

ITC382 Client Server Applications
Tutorial 6

Creating an Online Store I

1. Connect to P200 server and login into MYSQL. Create some tables to be used in conjunction with the online store.

WorkShop 5

ITC382 Client Server Applications
Tutorial 5

Interacting with MYSQL

WorkShop 4

ITC382 Client Server Applications
Tutorial 4

MANIPULATING FILES and DIRECTORIES

Introduction

Hi, my name is Shiming Xu, I am in my first trimester of my Master of IT degree at Charles Sturt University. The portfolio has been created for CSU subject ITC 594 E-systems Infrastructure development. The purpose of my blog is to document my progress through the subject that is a part of my mater of Information technology degree with Charles Sturt University. The subject is all about the technologies that support e-business. It outlines issues and procedures in online business application development. As part of the subject it is also necessary to learn the Ruby on Rails application development framework to assist in developing an e-commerce application.


This subject covers the following topics:
1. E-commerce, distributed applications and the internet
2. Clients, servers and distributed paradigms
3. Database servers
4. Web application servers
5. XML – eXtensible Markup Language
6. Distributed objects – RMI and CORBA
7. Internet security
8. Concurrency and transactions
9. Designing distributed systems
10. Bots, agents, spiders and mobile computing
11. Case studies – Further case studies for investigation
12. Systems integration
Well, now to it...

Workshop 3

ITC382 Client Server Applications
Tutorial 3

STRINGS, DATES, FORMS and SESSIONS

Working with Strings

Workshop 2

ITC382 Client Server Applications
Tutorial 2

BEGINNING PHP CODING

1. All PHP files have an extension of .php
2. All PHP will start with the following code

<?php
code
?>


Exercise 8: XML introduction

Create an XML document for an online catalogue of cars where each car has the child elements of make, model, year, colour, engine, number_of_doors, transmission_type and accessories. The engine has child elements called number_of_cylinders and fuel_system.


XML code

Exercise 7 : Application server platforms in e-commerce

1. Why is the perception getting stronger that integration will become a critical factor in coming days?

There are a variety of application frameworks and a broad range of programming languages and the ability to integrate them is crucial. As systems rely more and more on a range of third-party services the need for simple and effective integration is vital. Service-orientated architecture (SOA) aims to assist in integration by providing loose coupling of services for consumption. XML is providing the mechanism for structure communication between services.

Elevator pitch 1

Hi everyone, welcome to my Blog that I have created to document what I have learn from the subject E-systems infrastructure development. The subject is all about the technologies that support e-business. It outlines issues and procedures in online business application development. It invites students to explore the technologies that support e-systems infrastructure development in an e-commerce context.

Until I started this subject, I have never been exposed to e-commerce application development and have little experience about web technologies and language. Blog, PHP, Perl, HTML, XHTML, XML, convention over configuration. As this is my first taste of blogging and Blogspot I anticipate that the look and feel of this will change regularly as I play about with the features,I am really enjoy it.

Exercise 6: Web form design and processing: A basis for e commerce interaction

1. Design the form
'Retrofit' the form data string above:

name=Evan+Burke&card=Visa&number=8443261344895544&order=French+perfume

for buying some French perfume into the HTML form fields and submit button on the Web page form.

Exercise 5: Database case study

Do EITHER Case A or Case B as your database case study for this exercise.

On your own machine, setup and test either database system and report your findings.
Case A: Microsoft SQL server
The relational DBMS uses Structured Query Language (SQL) as a standard. Microsoft SQL Server 2008 has support for .NET Framework, so that stored procedures can used be in any of the .NET languages. Microsoft Dreamspark at dreamspark.com is an interesting site for the student/developer using Microsoft products.

Exercise 4: Network and Web programming frameworks

1. Describe the important and distinguishing properties of Peer to Peer computing with the client/server architecture?

Exercise 3: From DNS and DHCP to Clouds and Grids

1. Explain DNS and DHCP. How does DNS differ from DCHP configuration?

The Domain Name System (DNS) is a hierarchical naming system for computers, services, or any resource connected to the Internet or a private network.
The Dynamic Host Configuration Protocol (DHCP) is a computer networking protocol used by hosts (DHCP clients) to retrieve IP address assignments and other configuration information.
Different between DNS and DHCP
DNS is use to translate URL to IP address, and DHCP is use to assign IP address automatic

Exercise 2: Finding some common ground

Describe the steps involved with the Rapid Evolutionary Prototyping Approach
as it applies to developing a Web application. How is it related to agile development?
As defined by the IEEE, Prototyping is "A type of development in which emphasis is placed on developing prototypes early in the development process to permit early feedback and analysis in support of the development process" (Booth and Kurpis, 1993).

Exercise 1: Analysis of the online communities' paradigm

1. Visit http://yahoo.com and http://facebook.com as examples of online communities.

WorkShop 1

ITC382 Client Server Applications
PHP Tutorial 1

Writing PHP scripts

1. You can download many PHP editors that is freely available online. I recommend PHP Designer which can be downloaded from www.download.com
2. If you prefer you can also write using notepad and naming the file with *.php
3. Lets start using notepad to write a simple PHP script to test the following tasks.
4. Click on Start >> Programs >> Accessories >> Notepad
5. Write the following code
[<?php
echo "Hello World";
?>


6. Save the file with the name helloworld.php. Remember to save it as helloworld.php since by default Notepad can save it as helloworld.php.txt.

Database servers

What is Database server?

A database server is a computer program that provides database services to other computer programs or computers, as defined by the client-server model. The term may also refer to a computer dedicated to running such a program. Database management systems frequently provide database server functionality, and some DBMSs (e.g., MySQL) rely exclusively on the client-server model for database access.

Types of databases

1. Flat file

A flat file database is a simple text file used to store information. Within such a record, the single fields can be separated by delimiters, e.g. commas, or have a fixed length. In the latter case, padding may be needed to achieve this length. Extra formatting may be needed to avoid delimiter collision. There are no structural relationships between the records. Flat file database is most often used when you do not have access to a MySQL database, as they require no server addons other than PHP. They are best for smaller amounts of data than a MySQL database is capable of, and have fewer handling functions.

2. Relational DBMS

A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model. This adds the additional condition that the system supports a tabular structure for the data, with enforced relationships between the tables. This excludes the databases that don't support a tabular structure or don't enforce relationships between tables.
Benefits of RDBMS are that the system is simple, flexible, and productive. Because the tables are simple, data is easier to understand and communicate with others. RDBMS are flexible because users do not have to use predefined keys to input information. Also, RDBMS are more productive because SQL is easier to learn. This allows users to spend more time inputting instead of learning. More importantly, RDBMS’s biggest advantage is the ease with which users can create and access data and extend it if needed. After the original database is created, new data categories can be added without the existing application being changed.

3. Object- oriented DBMS(OODBMS)

An object-oriented database management system (OODBMS) is a database management system (DBMS) that supports the modeling and creation of data as objects. This includes some kind of support for classes of objects and the inheritance of class properties and methods by subclasses and their objects. An object-oriented database system must satisfy two criteria: it should be a DBMS, and it should be an object-oriented system, i.e., to the extent possible, it should be consistent with the current crop of object-oriented programming languages. The first criterion translates into five features: persistence, secondary storage management, concurrency, recovery and an ad hoc query facility. The second one translates into eight features: complex objects, object identity, encapsulation, types or classes, inheritance, overriding combined with late binding, extensibility and computational completeness.


2 and 3 tier database

The 2-tier database model is a standalone application with data tightly bound (mainframe systems and workgroup database systems). In modern two-tier architecture, the server holds both the application and the data. The application resides on the server rather than the client, probably because the server will have more processing power and disk space than the PC.

The 3-tier model is more popular for business where the database backend is an Enterprise Relational Database such as Sybase or Oracle, with generally no direct access to the database. In three-tier architecture, the data and applications are split onto separate servers, with the server-side distributed between a database server and an application server. The client is a front end, simply requesting and displaying data. Reason being that each server will be dedicated to processing either data or application requests, hence a more manageable system and less contention for resources will occur