Learning Center
Plans & pricing Sign in
Sign Out



									Business Information Systems


                        Winter 2011

                      Mike Pangburn
My info.
     Mike Pangburn

     phone: 346-3407

     office: 488 Lillis

     office hours: except when noted...
           Wednesday 2:30-4:30pm
           Tue/Th 4-4:30pm
‗Shift happens‘
  ―Did you know?‖ video... a modern classic
    focus: technology and education

  Original version has been updated
    Let‘s take a look (4min video)

―May you live in interesting times.‖
- Chinese proverb
Shift happens to business leaders
  This “telephone” has too many shortcomings to be
   seriously considered as a means of communication. The
   device is inherently of no value to us.
    Western Union internal memo, 1876

  I think there is a world market for maybe five computers.
    Thomas Watson, chairman of IBM, 1943

  There is no reason anyone would want a computer in their
    Ken Olson, president, chairman, and founder of Digital
     Equipment Corp., 1977

  Dell has a great business model, but that dog won’t scale.
    John Shoemaker, head of Sun‘s server division, 2000
Why we are here
  Information systems and information
   technologies are integral to your lives

  Information systems are used by all
   functional areas in an organization

  Information systems offer career
Companies are shifting
 If you think you don‘t want to work with technology…
  you will. Avoid the Lloyd Dobler syndrome.
Professionals who directly computers
in their jobs, vs. those who do not

              For college grads, data shows a 20%
              to 30% average increase (roughly) in
              income related to computer use
% of jobs that are computer
intensive (trend over time)
This course…   Textbook‘s

          T     Additional
               class notes,
                 and HW
 Information Systems by John Gallaugher. FlatWorld Knowledge,

 To see the text, visit and click the
  ‗Find My Class‘ button and then enter Pangburn.

 There are different options for accessing the book:
     Read online (Free)
     Buy pdf download and print yourself
     Buy black-and-white copy
     Buy color copy.

 Additional readings will be provided in class or available online.
    Schedule overview

Week   Topic                               HW due          Ch. readings
1      Internet addresses, domain names,                   Tue: Ch. 4
       bits & bytes and data types,
       Moore‘s Law
2      Understanding Software; server      HW#1 due        Tue: Ch. 9
       access, FTP, SSH, text editors,     Thurs.          Thurs: Ch. 10
       static HTML
3      Social networking, Sharing data     HW#2 due        Tue: Ch. 6
       (XML, RSS), Styling information     Thurs.
       (.css and .xsl)
4      Network effects, Online search      HW#3 due        Tue: Ch. 5
       advertising, spreadsheets (Google   Thurs.          Thurs: Ch. 8
       Docs), Forms
5      IT Strategy; Mini-case (Zara)       Midterm          Tue: Ch. 1 and 2
                                           Thurs., in class
     Schedule overview

Week   Topic                                 HW due     Other
6      Data visualization, VBA, Business                Thurs: Ch. 11
7      Mini-case (Netflix), Data Tables,                Tue: Ch. 3
       Spreadsheet simulations
8      Adv. Spreadsheet functions,           HW#4 due
       creating an online database, intro.   Thurs.
       to SQL
9      SQL and Relational DB design          HW#5 due
10     Networking, security, and privacy     HW#6 due   Tue: Ch. 7
Six HW assignments
 HW is to be submitted individually

 Scoring:
  Excellent: No errors (~100%), submitted properly and on-
  Good: Contains error
  Needs work: Has multiple (small) errors
  Late or lacking answers (incomplete)—or submitted in
    wrong format (e.g., via email)
  0: lf not turned in.
     HW scoring

  Note that I will count
  (in your favor) two or
  more scores of any
  level as one of the
  next highest level

Example: a person‘s scores on HW#1-#6 are N, L, E, L, E, L (less than ideal). Before
   applying the table above, we note 3 L scores counts as one N. So, effectively, there
   are now 2 N scores, which in turn count as 1 G score. Thus, this person has the
   equivalent of 2 E and 1 G scores. Applying the table, we see 2 E and 1 G = 50%
Overall Grading Weights
 Class participation, 10%

 6 Homeworks, 30%

 Midterm, 25%

 Final, 35%
   you can bring an 8 ½ x 11 double-sided notes sheet to the

 Bring a calculator and a #2 pencil to both the midterm
  and final test.
Domain Names
What is a domain name?
 As far as the Internet's machines are concerned, an IP
  address is all that you need to talk to a server. For
  example, you can type in your browser the URL


 …and you arrive at ?

 Domain names are strictly a human convenience, like
  maintaining a contact list with names and their
  associated phone numbers.
Domain Name examples
 - a popular EDU name

 - a Web server that does not start
  with www

 - a name using four parts rather than

 - an FTP server rather than a Web
What is an IP address?
 The IP address specifies a network device‘s(e.g., a laptop
  computer, or a server) ―location‖ on a network.

 How to look up your IP address?

 Two types of IP addresses:
  1.       Public IP: Addresses accessible via the Internet.
  2.       Private IP: Any address in the ranges:
        -
        -
        -
  Routers (data forwarders) on the Internet are
     programmed to kill data attempting to travel to an
     IP address in these ranges.
Domain Name System
 The Domain Name System (DNS) is the ―phone book for
  the Internet‖
   Translates human-friendly hostnames into IP addresses

 The Domain Name System distributes the responsibility
  of assigning domain names and mapping those names to
  IP addresses be designating authoritative Domain Name
  Servers (DNS)
   DNS accepts requests from programs to convert domain
    names into IP addresses
   DNS accepts requests form other name servers to conver
    domain names into IP addresses
Domain Name System
 Every domain name within each top-level domain must
  be unique

 There is a single organization that controls the list
  and makes sure that no duplicates arise

 The .com list is managed by the firm Network Solutions

 Lower-level domains are controlled independently. For
  example, Microsoft has hundreds of thousands of IP
  addresses and host names. Microsoft maintains its own
  Domain Name Server (DNS) for the
  domain name space.
               Root level

Domain Name System has
   ―tree structure‖
       Top-level (first-level)
     domains: .com, .edu, .gov,
       .mil, .net, .org, etc.

Domain Name System has
   ―tree structure‖
    Second-level domains:,,, etc.

Domain Name System has
   ―tree structure‖
DNS – Domain Name ―Server‖
 Amazing aspect of the DNS system -- it is completely
  distributed throughout the world on millions of
  machines, yet behaves like a single, integrated

 How does it work?

 ―How do you search a name in the phone book?‖

 It starts with your local DNS.

 Local DNS: The name server that is your machine‘s first
  contact when converting domain names to IP addresses.
  Domain name resolution process

Step 1: IP address         Step 2: IP address
 of ?           of ?

                                                         Root name
                                   Step 3: IP address    server
                                    of ?

              Local name                        I don‘t know but I‘ll
Here‘s the IP server                             tell you
                                    Step 4: IP address the server
Response: I
                                                  that handles
                                     of ?.edu
 don‘t know                                           server
  but let me
                 Here is theI don‘t know but I‘ll
 look for it…
                uoregon.edutell you the server
                webserver IP that handles
                  address! names
Web server basics
 A standard web-server needs:

1. A public IP address (one outside of the 3
   aforementioned private-IP ranges);

…and, assuming the server will be accessible via a domain

2. a corresponding domain name registered within the
    Domain Name System

3. software that listens for and responds to requests for
    web-page files
Choosing a domain name

 Consider          making your company‘s website
     ―extensible‖
        e.g.,   what does have to do with books?
   memorable
   short

 The     top level domain (TLD) is very significant
   Country Code Domains (.uk, .de, .jp, .us, etc.)
   Generic Domains (.aero, .asia, .biz, .cat, .com, .coop, .edu,
    .gov, .info, .jobs, .mobi, .int, .mil, .museum, .name, .net,
    .org, .pro, .tel and .travel)
   ―the marketplace has spoken‖ - .com is best
Choosing a domain name
   Generally people advise avoiding:
     Trademarks
     Hyphens

     Numbers

   One may not be enough
       Multiple markets may imply multiple names/sites

   Choose/register the name(s) sooner rather than
       It‘s a global market, with lots of names, but lots of
        interested parties as well
Buying the name
   Buying a domain name is referred to as ―registering the
      It‘s actually a lease, not a purchase
      You register the domain via a company called a
       domain name registrar
   Lease timeframe ranges from 1 year to 99 years
      Price per year ranges from ~$5 to ~$20

   Research the registrar before you choose (avoid scams)
Registrars by name volume

        Largest registrars by #-registered-
Buying the name
   Current lessee has the option to renew name
    before end of lease
   And, most good names are already being leased!
   How do you check if a name is available?
       Any registrar‘s site will have a ―WHO-IS‖ search
        capability that searches the DNS for top-level domains
   How do you check details of lessee?
       Check registration details within ―WHOIS‖ search
       Lessee can pay for private registration, in which case
        you won‘t see their details
Possible to get already-taken
 Option 1: negotiate directly with lessee
     use WHOIS search to make contact
 Option 2: domain name marketplace
     Several varieties: auction style, fixed-price
      style, make-an-offer style.
     Examples:,,
Managing domain names
 When in a company, be aware of who is listed as the
  contact person/registrant for the domain name

 What if that person leaves the company or is fired?
   If you don‘t managed such transitions well, that person can
    make it very difficult for you to get your domain name
    back under your control

 If you are thinking about having your own company, you
  should registering your domains(s), not an IT person

To top