Babes-Bolyai University of Cluj-Napoca
Faculty of Mathematics and Computer Science
Study Cycle: Master

SUBJECT

Code
Subject
MIH1002 Databases in Internet
Section
Semester
Hours: C+S+L
Category
Type
Databases
1
2+0+2
speciality
compulsory
Distributive Systems in Internet
1
2+0+2
speciality
compulsory
Teaching Staff in Charge
Prof. ŢÂMBULEA Leon, Ph.D.,  leoncs.ubbcluj.ro
Aims
To introduce to the student to develop applications of database in Internet.
Content
1. Client/server technology on the Web.
2. HTML and DHTML. Tables.
3. Web services (PWS, IIS, Apache).
4. Forms in HTML.
5. Visual Basic Script and Java Script.
6. Active Server Page. Creating Active Server Pages. Object Model (Application, Session, Server, Request, Response, ASPError, ObjectContext). Installable Components for ASP.
7. Using ASP with Visual Basic Script and Java Script.
8. Server-side scripting and client-side scripting.
9. Database (Oracle, Microsoft Access, Microsoft SQL Server). Database on Web.
10. Accessing and updating database with SQL, ADO, ODBC, JDBC and ASP.
11. Transaction. Creating and controlling transactions.
12. Controlling access and monitoring.
13. Using XML in Web applications.
14. Securing applications.
References
Manual for the MySQL Database System, Version 5.0, http://www.mysql.com/.

Jesus Castagnetto, Harish Rawat, Sascha Schumann, Chris Scollo, Deepak Veliath, Professional PHP Programming 1999 Wrox Press.

Stig Sæther Bakken, Alexander Aulbach, Egon Schmid, Jim Winstead, Lars Torben Wilson, Rasmus Lerdorf, Andrei Zmievski, Jouni Ahto, PHP Manual, http://www.php.net.

Documentatia on-line de pe CD-urile MSDN (Microsoft Visual Studio).

Tutoriale la: http://www.webreference.com/, http://javascript.internet.com/tutorials/, http://www.ipl.org/div/subject/browse/com70.00.00/

Jason Butler and Tony Caudill, ASP.NET Database Programming, Hungry Minds 2002.

KevinWilliams, Michael Brundage, Patrick Dengler, Jeff Gabriel,Andy Hoskinson,Michael Kay, Professional XML Databases, Wrox Press, 2000 .

Jay Greenspan and Brad Bulger, MySQL/PHP Database Applications, M&T Books, 2001 .

Hugh E. Williams, David Lane, Web Database Applications with PHP & MySQL, O’Reilly, 2002.

PhpWebSite project, Appalachian State University, 2004-2006, http://phpwebsite.appstate.edu.

A. Bonifati, S. Ceri, P. Fraternali, A. Maurino, Building multi-device, content-centric applications using WebML and the W3I3 Tool Suite, in Proceedings of Conceptual Modeling for E-business and the Web, Lecture Notes in Computer Science, vol. 1921, 2000, pp. 64-75.

E. Bozsak, M. Ehrig, S. Handschuh, A. Hotho, Al. Maedche, B. Motik, D. Oberle, Ch. Schmitz, St. Staab, L. Stojanovic, N. Stojanovic, R. Studer, G. Stumme, Y. Sure, J. Tane, R. Volz, V. Zacharias, KAON - Towards a large scale Semantic Web, Proc. of the 3rd Intl. Conf. on E-Commerce and Web Technologies (EC-Web 2002), 2002, pp. 304-313.

Y. Jin, S. Decker, G. Wiederhold, OntoWebber: model-driven ontology-based web site management, in Proceedings of the first international semantic web working symposium (SWWS '01), Stanford University, Stanford, CA, 29 July-1 August 2001

L. Tâmbulea, H. F. Pop, A formal approach of web sites management, Proceedings of the Symposium "Zilele Academice Clujene", Faculty of Mathematics and Computer Science, Babes-Bolyai University, Cluj-Napoca, June 2006, p. 66-72.

Assessment
A project - 50% and a practical exam - 50%.
Links: Syllabus for all subjects
Romanian version for this subject
Rtf format for this subject