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., leon@cs.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.
	
Bibliography	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%.