CS349 Documentation and Links

Glossaries of Internet Terms
General e-commerce sources
Internet, Client/server model
Databases and SQL
NEW! McKoi Database
Cryptography and Security
Electronic Payment Systems
LINUX References
Programming Resources: Java 2, JDBC, Servlets, etc.
On a lighter side...

To CS349 students and everyone interested in electronic commerce: If you know a good link on one of the existing topics or on a topic which is not included here, but you feel that it should, please let me know. Also, please let me know if any links don't work or are not particularly helpful for the class.

The list of references will be updated throughout the semester, please check it out often!

Glossaries of Computer Terms

• Webopedia: Online Dictionary for Computer and Internet Terms. Accurate technical definitions, crossreferences, and links to more detailed information. An excellent source!
• whatis.com. A good source of definitions and references.

General e-commerce sources

• Electronic Commerce Terms and Definitions at McMaster University. Informative and concise.
• Webmonkey | e-business A lot of material on how to design a successful commercial web site. Check out their Java programming section, too!
• Ecommerce Technology links at Institute for eCommerce at Carnegie Melon University. List of links on all aspects of e-commerce, but some links are outdated.
• Managing a Digital Enterprise by Prof. Michael Rappa. An open online course on designing and managing a commercial web site.
• Philip and Alex's Guide to Web Publishing by Philip Greenspun. While this link is not necessarily about commercial web sites, it provides a very convincing view of what constitutes a good (i.e. interesting, popular) web site.

Internet, Client/server model

• How Web Servers and the Internet Work at www.howstuffworks.com. A nice introduction to Internet and Client-Server Technology, a lot of crossreferences.
• How Does the Internet Work? A very good introduction to Internet protocols.
• An Overview of TCP/IP protocols and the Internet at Hill Associates (a telecommunication training center). Very detailed history of Internet, description of Internet protocols.

Databases and SQL

• A very informative series of short articles by Bob Angell at www.itworld.com/nl/db_mgr, in particular:
  • Overview of Databases
  • Overview of The Relation Model
  • Codd's 12 Rules
  • SQL History/Overview Click here for another brief overview of SQL and another opinion on prononciation and origins of the name "SQL".
• Glossary of Database Terms at about.com. A good source of information on relational databases.
• Entry level SQL Tutorial with an interactive SQL interpreter and a more advanced tutorial at internet.com.
• Another SQL tutorial
• A complete SQL reference. Has everything you need to know about SQL and much more! In particular, read about granting and revoking privileges.
• Database Resources at www.unifx.com. Tons of links! Caution: Sometimes the text on this page is not visible when you first load it, you might need to scroll up and down on to see the text.
• An article Relational versus Object Databases - Contention or Coexistence? by Leszek A. Maciaszek.

McKoi Database

• Instructions on how to install Mckoi driver and use JDBC Query tool.
• Mckoi SQL database home page
• McKoi SQL Syntax with examples. Note: it is slightly different from the version of SQL that we have covered in class!

Cryptography and Security

• MIT site on Cryptography and Security. Check out their references for Algorithms and Protocols as well as other fascinating links!
• Cryptography: an overview. A very well written and well organized site on cryptography.
• NEW! Basics of cryptography and encryption and A detailed overview and a proof of RSA cryptography by Tom Davis (.pdf documents).
• Identity Authentication and 'E-Commerce'. A long article by Mathew Ford published in "The Journal of Information, Law, and Technology" in 1998. A great detailed overview!
• State of the Practice of Intrusion Detection Technologies
• The EPIC (Electronic Privacy Information Center) Cookies Page A good page on various legal and technical issues related to cookies.
• The metaphor is the key: cryptography, the clipper chip, and the Constitution by Michael Froomkin. An very interesting discussion of history and technical and legal aspects of modern cryptography. You might not agree with the author's opinions, but you must read it (will keep you entertained during a summer break)! A good well-organized reference, too!
• History:World War II Codes and Ciphers. History, science, and engineering of cryptanalysis in WWII.
• NEW! Cracking a Medieval Code A story of decrypting a book written by Johannes Trithemius (1462-1516), an abbot in Spanheim, Germany. The book turned out to contain encrypted messages and has been recently by cryptanalist Jim Reeds. A fascinating story!

Electronic Payment Systems

LINUX and Emacs References

• Introduction to Linux and Emacs written by Lyn Turbak for CS251 (a .pdf document)
• The Linux Users' Guide by Larry Greenfield (also in pdf).
• Linux Documentation Project. The official LINUX web site.
• GNU Emacs Manual
• Emacs Reference Card

Programming Resources: Java 2, JDBC, Servlets, etc.

• Webmonkey | programming: Java . A good plain-English overview of modern Java technologies in e-commerce.
• JavaTM 2 Platform, Standard Edition, v 1.4.0 API . APIs of some packages and classes you will be using:
  • java.lang.Thread
  • javax.swing
  • ActionListener
  • java.sql
  • NEW!JavaTM 2 Platform, Enterprise Edition, v 1.3.1 API, in particular Java servlets package API, including classes: HttpServlet and Cookie.
• Java threads:
  • Thread tutorial at java.sun.com
  • An overview of threads with examples by Neel Kumar at IBM Java Developers.
• Tutorials at java.sun.com:
  • Swing Tutorial
  • Event Handling and Writing Event Listeners
  • JDBC, in particular Retrieving Values from Result Sets (gives the list of methods to convert from SQL types to Java types).

On a lighter side...

• The Twelve Networking Truths