MI352 | Databases in Internet |
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.
2. HTML and DHTML. Styles. 3. Client scripts. 4. Web programming. Internet services. Server scripts. 5. Database systems (Oracle, Microsoft SQL Server, MySQL). Database management with server scripts. 6. Server scripts in PHP and ASP.NET. 7. Database management with SQL using ADO, ODBC, JDBC and ADO.NET. 8. Tranzactions. Creation and control of transactions in Web applications. 9. Controlling access to databases and monitoring access 10. Using XML in Internet applications. Support XML in client and server scripts. 11. Security of internet applications. 12. Web sites management. 13. Semantic web. 14. Knowledge management. |
References |
Darie, C., Barnett, W., Build Your Own ASP.NET 3.5 Web Site Using C# & VB, SitePoint Pty. Ltd., 2008.
Kevin, W., Brundage, M., Dengler, P., Gabriel, J., Hoskinson, A., Kay, M., Professional XML Databases, Wrox Press, 2000. Hugh E. W., Lane, D., Web Database Applications with PHP & MySQL, O’Reilly, 2002. 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. 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. 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. PhpWebSite project, Appalachian State University, 2004-2006, http://phpwebsite.appstate.edu. Manual for the MySQL Database System, Version 5.0, http://www.mysql.com/. SPARQL Services, http://sparql.org/ RDF documents, http://pingthesemanticweb.com/ RDF Data Access and Data Management (2008), http://docs.openlinksw.com/virtuoso/rdfandsparql.html |
Assessment |
1. Building a Personal pages.
2. Essay with a topic related to course topics 3. Creating a software application used in the Internet, which manages a database. 4. Laboratory activities. 5. Solving a problem in the day of exam. The value of each component in calculating the final grade is 20%. |
Links: | Syllabus for all subjects Romanian version for this subject Rtf format for this subject |