notebook.community

Edit and run

Manual publication DB insertion from raw text using syntax features

Publications and conferences of Dr. AVRAM Sanda, Profesor Universitar

http://www.cs.ubbcluj.ro/~sanda





In [1]:



    


class HelperMethods:
    @staticmethod
    def IsDate(text):
#         print("text")
#         print(text)
        for c in text.lstrip():
            if c not in "1234567890 ":
                return False
        return True



    











In [2]:



    


import pandas
import requests



    











In [3]:



    


page = requests.get('http://www.cs.ubbcluj.ro/~sanda/html/publications/')



    











In [4]:



    


data = page.text



    











In [5]:



    


from bs4 import BeautifulSoup



    











In [6]:



    


soup = BeautifulSoup(data)



    











In [7]:



    


pubs = []
for e in soup.find_all('li'):
    if "value" in e.attrs:
#         print(e.contents)
        line = e.contents
        authors = line[0].lstrip('\n ').rstrip('\n ')
        print("authors: ", authors)
        title = line[2]
        print("title: ", title.text)
        affiliation = line[5]
        print("affiliation: ", affiliation.contents[0])
        url = line[5].attrs["href"] if "href" in line[5].attrs else line[5]
        print("url: ", url)
        year = ""
        try:
            year_line = line[8].split()
        
            for i in year_line:
                val = i.split(',')[0]
                if HelperMethods.IsDate(val):
                    year = val
            print("year: ", year)
        except:
            pass
        #year = [k[0] for k in line[8].split(" ") if HelperMethods.IsDate(k[0])][0]
        #print("year: ", year)
        pubs.append((authors, title, affiliation, url, year))
print(len(pubs))



    


















    






authors:  Sanda (Dragoș) Avram, Diana Șotropa, and Diana Troancă,
title:  Highlighting Trend-Setters in Educational Platforms by Means of Formal Concept Analysis and Answer Set Programming
affiliation:   IFIP Advances in Information and Communication Technology
url:  https://link.springer.com/chapter/10.1007/978-3-319-92928-6_5
year:  2018
authors:  Sanda (Dragoș) Avram, Christian Săcărea, and Diana Șotropa,
title:  Investigating Educational Attractors and Life Tracks in e-Learning Environments Using Formal Concept Analysis
affiliation:  The 25th International Conference on Software, Telecommunications and Computer Networks (SoftCOM)
url:  http://softcom2017.fesb.unist.hr/
year:  2017
authors:  Sanda (Dragoș) Avram, Christian Săcărea, and Diana Troancă,
title:  Using Pattern Structures for Mining Student Behaviour in E-learning Platforms on specific Triggers
affiliation:  The 25th International Conference on Software, Telecommunications and Computer Networks (SoftCOM)
url:  http://softcom2017.fesb.unist.hr/
year:  2017
authors:  Sanda (Dragoș) Avram, Christian Săcărea, and Diana Șotropa,
title:  An investigation of user behavior in educational platforms using Temporal Concept Analysis
affiliation:  The 14th International Conference on Formal Concept Analysis (ICFCA)
url:  https://icfca2017.irisa.fr/
year:  2017
authors:  Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,
title:  Analysing the Effect of Changing the Educational Methods by Using FCA
affiliation:  The 24th International Conference on Software, Telecommunications and Computer Networks (SoftCOM)
url:  http://marjan.fesb.hr/SoftCOM/2016/
year:  2016
authors:  Sanda (Dragoș) Avram, Diana Haliță, and Diana Troancă,
title:   Investigating Trend-setters in E-learning Systems using Polyadic Formal Concept Analysis and Answer Set Programming
affiliation:  The 4th International Workshop on Artificial Intelligence for Knowledge Management (AI4KM)
url:  http://emlconseil.free.fr/eml/?page_id=104
year:  2016
authors:  Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,
title:  Distilling Conceptual Structures from Weblog Using Polyadic FCA
affiliation:  The 22nd International Conference on Conceptual Structures (ICCS)
url:  https://www.irit.fr/ICCS2016/
year:  2016
authors:  Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,
title:  Attractors in Web Based Educational Systems. A Conceptual Knowledge Processing Grounded Approach
affiliation:  The 8th International Conference on Knowledge Science, Engineering and Management (KSEM)
url:  http://ksem2015.swu.edu.cn/
year:  2015
authors:  Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,
title:  Behavioral pattern mining in web based educational system
affiliation:  23rd International Conference on Software, Telecommunications and Computer Networks (SoftCOM)
url:  http://marjan.fesb.hr/SoftCOM/2015/
year:  2015
authors:  Sanda (Dragoș) Avram, Diana Haliță, Christian Săcărea, and Diana Troancă,
	
title:  An FCA grounded study of user dynamics through log exploration
affiliation:  Studia Universitatis Babeș-Bolyai Series Informatica
url:  http://www.cs.ubbcluj.ro/~studia-i/
year:  2014
authors:  Sanda (Dragoș) Avram, Diana Haliță, Christian Săcărea, and Diana Troancă,
title:  Applying Triadic FCA in Studying Web Usage Behaviors
affiliation:  The 7th International Conference on Knowledge Science, Engineering and Management
url:  http://conferences.ulbsibiu.ro/ksem2014/
year:  2014
authors:  Sanda (Dragoș) Avram and Alina Mihaela Beldean,
	
title:  Analysing Web Usage with Force-Directed Graphs
affiliation:  Studia Universitatis Babeș-Bolyai Series Informatica
url:  http://www.cs.ubbcluj.ro/~studia-i/
year:  2013
authors:  Ovidiu Parvu and Sanda (Dragoș) Avram,
	
title:  Building Intelligent Knowledge Management Systems
affiliation:  Studia Universitatis Babeș-Bolyai Series Informatica
url:  http://www.cs.ubbcluj.ro/~studia-i/
year:  2012
authors:  Sanda (Dragoș) Avram and Christian Săcărea,
	
title:  Analysing the Usage of Pulse Portal with Formal Concept Analysis
affiliation:  Studia Universitatis Babeș-Bolyai Series Informatica
url:  http://www.cs.ubbcluj.ro/~studia-i/
year:  2012
authors:  Sanda (Dragoș) Avram and Christian Săcărea,
title:  Web Analytics with Formal Concept Analysis
affiliation:  Zilele Academice Clujene (ZAC)
url:  
year:  2012
authors:  Parvu Ovidiu and Sanda (Dragoș) Avram,
title:  Interactive and intelligent doctorate theses administration platform
affiliation:  Zilele Academice Clujene (ZAC)
url:  
year:  2012
authors:  Rareș Boian, Sanda (Dragoș) Avram, and Claudiu Cobârzan,
	
title:  Aport: web portal for assisting teaching
affiliation:  Studia Universitatis Babeș-Bolyai Series Informatica
url:  http://www.cs.ubbcluj.ro/~studia-i/
year:  2011
authors:  Sanda-Maria (Dragoș) Avram,
title:  Why Google Analytics Cannot Be Used For Educational Web Content
affiliation:  International Conference on Next Generation Web Services Practices (NWeSP)
url:  http://www.mirlabs.org/nwesp11/
year:  2011
authors:  Sanda-Maria (Dragoș) Avram,
title:  Hierarchical QoS Routing by Using Multi-Constrained Macro-Routing
affiliation:  International Conference on Next Generation Web Services Practices (NWeSP)
url:  http://www.mirlabs.org/nwesp11/
year:  2011
authors:  Sanda-Maria (Dragoș) Avram,
title:  Why integrated E-learning Analytics are the best solution?
affiliation:  IEEE International Conference on Intelligent Computer Communication and Processing (ICCP)
url:  http://www.iccp.ro/iccp2011/
year:  2011
authors:  Rares Boian, Sanda (Dragoș) Avram, and Claudiu Cobarzan,
title:  THE APORT WEB PORTAL: ADVANCED E-LEARNING FEATURES
affiliation:  Knowledge Engineering Principles and Techniques (KEPT)
url:  http://www.cs.ubbcluj.ro/kept2011/
year:  2011
authors:  
title:  Author(s):
affiliation:  Title:
url:  <div class="blue">Title:</div>
authors:  Sanda (Dragoș) Avram,
	
title:  Current Extensions on PULSE
affiliation:  Studia Universitatis Babeș-Bolyai Series Informatica
url:  http://www.cs.ubbcluj.ro/~studia-i/
year:  2010
authors:  Radu-Calin Dragoș and Sanda-Maria (Dragoș) Avram,
title:  Implementation of a layer 7 BSD firewall
affiliation:  9th Roedunet International Conference (RoEduNet)
url:  http://www.iaria.org/conferences2009/ICIW09.html
year:  2010
authors:  Sanda (Dragoș) Avram,
title:  The new face of PULSE
affiliation:  Zilele Academice Clujene (ZAC)
url:  
year:  2010
authors:  Sanda (Dragoș) Avram and Radu Dragoș,
	
title:  WATEC: a Web Analytics Tool for Educational Content
affiliation:  KEPT2009 Knowledge Engineering Principles and Techniques
url:  http://www.cs.ubbcluj.ro/kept2009/
year:  2009
authors:  Sanda (Dragoș) Avram and Martin Collier,
	
title:  Macro-Routing. Performance evaluation
affiliation:  Studia Universitatis Babeș-Bolyai Series Informatica
url:  http://www.cs.ubbcluj.ro/~studia-i/
year:  2009
authors:  Sanda (Dragoș) Avram and Radu Dragoș,
	
title:  Web Analytics for Educational Content
affiliation:  Studia Universitatis Babeș-Bolyai Series Informatica
url:  http://www.cs.ubbcluj.ro/~studia-i/
year:  2009
authors:  Sanda (Dragoș) Avram,
title:  PULSE Extended
affiliation:  The Fourth International Conference on Internet and Web Applications and Services
url:  http://www.iaria.org/conferences2009/ICIW09.html
year:  2009
authors:  Sanda (Dragoș) Avram,
title:  PULSE - a PHP Utility used in Laboratories for Student Evaluation
affiliation:  International Conference on Informatics Education Europe II (IEEII)
url:  http://www.seerc.org/ieeii2007/
year:  2007
authors:  Sanda (Dragoș) Avram and Radu Dragoș,
	
title:  SINE - a System with Interactive ackNowledgement and Evaluation of students work during laboratory sessions
affiliation:  Didactica Mathematica
url:  http://math.ubbcluj.ro/~didactica/
year:  2007
authors:  Sanda (Dragoș) Avram and Radu Dragoș,
	
title:  WinNet - a network tool
affiliation:  International Journal of Computers, Communications & Control  (IJCCC)
url:  http://www.journal.univagora.ro/
year:  2006
authors:  Sanda (Dragoș) Avram and Martin Collier,
title:  Multi-constraint Macro-routing by using the Extended Full-Mesh aggregation technique
affiliation:  2nd International Conference on Intelligent Computer Communication and Processing (ICCP)
url:  
year:  2006
authors:  Radu Dragoș and Sanda (Dragoș) Avram,
title:  A graph theoretical approach to traffic management in ISP networks using the overlay MPLS network
affiliation:  2nd International Conference on Intelligent Computer Communication and Processing (ICCP)
url:  
year:  2006
authors:  Sanda (Dragoș) Avram and Radu Dragoș,
title:  WinNet - a network tool
affiliation:  International Conference on Computers, Communications and Control (ICCCC)
url:  http://www.iccc.univagora.ro/
year:  2006
authors:  Radu Dragoș and Sanda (Dragoș) Avram,
title:  Dirijare 'inteligenta' a traficului de date cu cerinte specifice ('Smart' QoS routing)
affiliation:  Zilele Academice Clujene (ZAC)
url:  
year:  2006
authors:  Sanda (Dragoș) Avram and Radu Dragoș,
title:  MPLS - o realitate actuala sau de viitor? (MPLS - present or future?)
affiliation:  Zilele Academice Clujene (ZAC)
url:  
year:  2006
authors:  Sanda (Dragoș) Avram and Radu Dragoș,
title:  SINE - Sistem Informatic de Notare si Evaluare a Activitatii de Laborator
affiliation:  Conferinta Nationala Didactica Matematicii
url:  
year:  2006
authors:  Sanda (Dragoș) Avram,
title:  Scalable QoS routing in MPLS networks using mobile code
affiliation:  PhD thesis
url:  <i>PhD thesis</i>
year:  
authors:  Sanda (Dragoș) Avram and Radu Dragoș,
	
title:  Modern routing techniques for future QoS enabled networks
affiliation:  Carpathian Journal of Mathematics,
		seria B, fascicola Matematica-Informatica
url:  http://carpathian.ubm.ro/
year:  2005
authors:  Sanda (Dragoș) Avram and Martin Collier,
title:  Macro-routing: a new hierarchical routing protocol
affiliation:  IEEE Global Telecommunications Conference (GLOBECOM)
url:  http://www.ieee-globecom.org/2004/
year:  2004
authors:  Sanda (Dragoș) Avram and Martin Collier,
title:  A proposed architecture for integrating Active Networks and MPLS
affiliation:  10th IEEE International Conference on Software, Telecommunications and Computer Networks (SoftCOM)
url:  http://marjan.fesb.hr/SoftCOM/2002/
year:  2002
authors:  Radu Dragoș, Sanda (Dragoș) Avram, and Martin Collier,
title:  Design and implementation of an MPLS based load balancing architecture for Web switching
affiliation:  15th Internet Traffic Engineering and Traffic Management (ITC)
url:  http://www.itcspecialistseminar.com/
year:  2002
authors:  Sanda (Dragoș) Avram,
title:  Active Networks and MPLS integration for better access networks: Framework and Applicability
affiliation:  transfer report (for master degree)
url:  <i>transfer report (for master degree)</i>
year:  
authors:  Sanda (Dragoș) Avram, Radu Dragoș, and Martin Collier,
title:  Bandwidth Management in MPLS Networks
affiliation:  First Joint IEI/IEE Symposium on Telecommunications Systems Research
url:  
year:  2001
authors:  Sanda (Dragoș) Avram,
title:  Aplicatii specifice INTRANET (INTRANET applications)
affiliation:  Dissertation thesis
url:  <i>Dissertation thesis</i>
year:  
authors:  Sanda (Dragoș) Avram,
title:  Limbajul JavaScript: aplicatii in programarea distribuita (JavaScript: distributed applications)
affiliation:  bachelor thesis
url:  <i>bachelor thesis</i>
year:  
47

















In [8]:



    


for pub in pubs:
    print(pub)



    


















    






('Sanda (Dragoș) Avram, Diana Șotropa, and Diana Troancă,', <b><i>Highlighting Trend-Setters in Educational Platforms by Means of Formal Concept Analysis and Answer Set Programming</i></b>, <a href="https://link.springer.com/chapter/10.1007/978-3-319-92928-6_5"> IFIP Advances in Information and Communication Technology</a>, 'https://link.springer.com/chapter/10.1007/978-3-319-92928-6_5', '2018')
('Sanda (Dragoș) Avram, Christian Săcărea, and Diana Șotropa,', <b><i>Investigating Educational Attractors and Life Tracks in e-Learning Environments Using Formal Concept Analysis</i></b>, <a href="http://softcom2017.fesb.unist.hr/">The 25th International Conference on Software, Telecommunications and Computer Networks (SoftCOM)</a>, 'http://softcom2017.fesb.unist.hr/', '2017')
('Sanda (Dragoș) Avram, Christian Săcărea, and Diana Troancă,', <b><i>Using Pattern Structures for Mining Student Behaviour in E-learning Platforms on specific Triggers</i></b>, <a href="http://softcom2017.fesb.unist.hr/">The 25th International Conference on Software, Telecommunications and Computer Networks (SoftCOM)</a>, 'http://softcom2017.fesb.unist.hr/', '2017')
('Sanda (Dragoș) Avram, Christian Săcărea, and Diana Șotropa,', <b><i>An investigation of user behavior in educational platforms using Temporal Concept Analysis</i></b>, <a href="https://icfca2017.irisa.fr/">The 14th International Conference on Formal Concept Analysis (ICFCA)</a>, 'https://icfca2017.irisa.fr/', '2017')
('Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,', <b><i>Analysing the Effect of Changing the Educational Methods by Using FCA</i></b>, <a href="http://marjan.fesb.hr/SoftCOM/2016/">The 24th International Conference on Software, Telecommunications and Computer Networks (SoftCOM)</a>, 'http://marjan.fesb.hr/SoftCOM/2016/', '2016')
('Sanda (Dragoș) Avram, Diana Haliță, and Diana Troancă,', <b><i> Investigating Trend-setters in E-learning Systems using Polyadic Formal Concept Analysis and Answer Set Programming</i></b>, <a href="http://emlconseil.free.fr/eml/?page_id=104">The 4th International Workshop on Artificial Intelligence for Knowledge Management (AI4KM)</a>, 'http://emlconseil.free.fr/eml/?page_id=104', '2016')
('Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,', <b><i>Distilling Conceptual Structures from Weblog Using Polyadic FCA</i></b>, <a href="https://www.irit.fr/ICCS2016/">The 22nd International Conference on Conceptual Structures (ICCS)</a>, 'https://www.irit.fr/ICCS2016/', '2016')
('Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,', <b><i>Attractors in Web Based Educational Systems. A Conceptual Knowledge Processing Grounded Approach</i></b>, <a href="http://ksem2015.swu.edu.cn/">The 8th International Conference on Knowledge Science, Engineering and Management (KSEM)</a>, 'http://ksem2015.swu.edu.cn/', '2015')
('Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,', <b><i>Behavioral pattern mining in web based educational system</i></b>, <a href="http://marjan.fesb.hr/SoftCOM/2015/">23rd International Conference on Software, Telecommunications and Computer Networks (SoftCOM)</a>, 'http://marjan.fesb.hr/SoftCOM/2015/', '2015')
('Sanda (Dragoș) Avram, Diana Haliță, Christian Săcărea, and Diana Troancă,\n\t', <b><i>An FCA grounded study of user dynamics through log exploration</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2014')
('Sanda (Dragoș) Avram, Diana Haliță, Christian Săcărea, and Diana Troancă,', <b><i>Applying Triadic FCA in Studying Web Usage Behaviors</i></b>, <a href="http://conferences.ulbsibiu.ro/ksem2014/">The 7th International Conference on Knowledge Science, Engineering and Management</a>, 'http://conferences.ulbsibiu.ro/ksem2014/', '2014')
('Sanda (Dragoș) Avram and Alina Mihaela Beldean,\n\t', <b><i>Analysing Web Usage with Force-Directed Graphs</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2013')
('Ovidiu Parvu and Sanda (Dragoș) Avram,\n\t', <b><i>Building Intelligent Knowledge Management Systems</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2012')
('Sanda (Dragoș) Avram and Christian Săcărea,\n\t', <b><i>Analysing the Usage of Pulse Portal with Formal Concept Analysis</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2012')
('Sanda (Dragoș) Avram and Christian Săcărea,', <b><i>Web Analytics with Formal Concept Analysis</i></b>, <a href="">Zilele Academice Clujene (ZAC)</a>, '', '2012')
('Parvu Ovidiu and Sanda (Dragoș) Avram,', <b><i>Interactive and intelligent doctorate theses administration platform</i></b>, <a href="">Zilele Academice Clujene (ZAC)</a>, '', '2012')
('Rareș Boian, Sanda (Dragoș) Avram, and Claudiu Cobârzan,\n\t', <b><i>Aport: web portal for assisting teaching</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2011')
('Sanda-Maria (Dragoș) Avram,', <b><i>Why Google Analytics Cannot Be Used For Educational Web Content</i></b>, <a href="http://www.mirlabs.org/nwesp11/">International Conference on Next Generation Web Services Practices (NWeSP)</a>, 'http://www.mirlabs.org/nwesp11/', '2011')
('Sanda-Maria (Dragoș) Avram,', <b><i>Hierarchical QoS Routing by Using Multi-Constrained Macro-Routing</i></b>, <a href="http://www.mirlabs.org/nwesp11/">International Conference on Next Generation Web Services Practices (NWeSP)</a>, 'http://www.mirlabs.org/nwesp11/', '2011')
('Sanda-Maria (Dragoș) Avram,', <b><i>Why integrated E-learning Analytics are the best solution?</i></b>, <a href="http://www.iccp.ro/iccp2011/">IEEE International Conference on Intelligent Computer Communication and Processing (ICCP)</a>, 'http://www.iccp.ro/iccp2011/', '2011')
('Rares Boian, Sanda (Dragoș) Avram, and Claudiu Cobarzan,', <b><i>THE APORT WEB PORTAL: ADVANCED E-LEARNING FEATURES</i></b>, <a href="http://www.cs.ubbcluj.ro/kept2011/">Knowledge Engineering Principles and Techniques (KEPT)</a>, 'http://www.cs.ubbcluj.ro/kept2011/', '2011')
('', <div class="blue">Author(s):</div>, <div class="blue">Title:</div>, <div class="blue">Title:</div>, '')
('Sanda (Dragoș) Avram,\n\t', <b><i>Current Extensions on PULSE</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2010')
('Radu-Calin Dragoș and Sanda-Maria (Dragoș) Avram,', <b><i>Implementation of a layer 7 BSD firewall</i></b>, <a href="http://www.iaria.org/conferences2009/ICIW09.html">9th Roedunet International Conference (RoEduNet)</a>, 'http://www.iaria.org/conferences2009/ICIW09.html', '2010')
('Sanda (Dragoș) Avram,', <b><i>The new face of PULSE</i></b>, <a href="">Zilele Academice Clujene (ZAC)</a>, '', '2010')
('Sanda (Dragoș) Avram and Radu Dragoș,\n\t', <b><i>WATEC: a Web Analytics Tool for Educational Content</i></b>, <a href="http://www.cs.ubbcluj.ro/kept2009/">KEPT2009 Knowledge Engineering Principles and Techniques</a>, 'http://www.cs.ubbcluj.ro/kept2009/', '2009')
('Sanda (Dragoș) Avram and Martin Collier,\n\t', <b><i>Macro-Routing. Performance evaluation</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2009')
('Sanda (Dragoș) Avram and Radu Dragoș,\n\t', <b><i>Web Analytics for Educational Content</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2009')
('Sanda (Dragoș) Avram,', <b><i>PULSE Extended</i></b>, <a href="http://www.iaria.org/conferences2009/ICIW09.html">The Fourth International Conference on Internet and Web Applications and Services</a>, 'http://www.iaria.org/conferences2009/ICIW09.html', '2009')
('Sanda (Dragoș) Avram,', <b><i>PULSE - a PHP Utility used in Laboratories for Student Evaluation</i></b>, <a href="http://www.seerc.org/ieeii2007/">International Conference on Informatics Education Europe II (IEEII)</a>, 'http://www.seerc.org/ieeii2007/', '2007')
('Sanda (Dragoș) Avram and Radu Dragoș,\n\t', <b><i>SINE - a System with Interactive ackNowledgement and Evaluation of students work during laboratory sessions</i></b>, <a href="http://math.ubbcluj.ro/~didactica/">Didactica Mathematica</a>, 'http://math.ubbcluj.ro/~didactica/', '2007')
('Sanda (Dragoș) Avram and Radu Dragoș,\n\t', <b><i>WinNet - a network tool</i></b>, <a href="http://www.journal.univagora.ro/">International Journal of Computers, Communications &amp; Control  (IJCCC)</a>, 'http://www.journal.univagora.ro/', '2006')
('Sanda (Dragoș) Avram and Martin Collier,', <b><i>Multi-constraint Macro-routing by using the Extended Full-Mesh aggregation technique</i></b>, <a href="">2nd International Conference on Intelligent Computer Communication and Processing (ICCP)</a>, '', '2006')
('Radu Dragoș and Sanda (Dragoș) Avram,', <b><i>A graph theoretical approach to traffic management in ISP networks using the overlay MPLS network</i></b>, <a href="">2nd International Conference on Intelligent Computer Communication and Processing (ICCP)</a>, '', '2006')
('Sanda (Dragoș) Avram and Radu Dragoș,', <b><i>WinNet - a network tool</i></b>, <a href="http://www.iccc.univagora.ro/">International Conference on Computers, Communications and Control (ICCCC)</a>, 'http://www.iccc.univagora.ro/', '2006')
('Radu Dragoș and Sanda (Dragoș) Avram,', <b><i>Dirijare 'inteligenta' a traficului de date cu cerinte specifice ('Smart' QoS routing)</i></b>, <a href="">Zilele Academice Clujene (ZAC)</a>, '', '2006')
('Sanda (Dragoș) Avram and Radu Dragoș,', <b><i>MPLS - o realitate actuala sau de viitor? (MPLS - present or future?)</i></b>, <a href="">Zilele Academice Clujene (ZAC)</a>, '', '2006')
('Sanda (Dragoș) Avram and Radu Dragoș,', <b><i>SINE - Sistem Informatic de Notare si Evaluare a Activitatii de Laborator</i></b>, <a href="">Conferinta Nationala Didactica Matematicii</a>, '', '2006')
('Sanda (Dragoș) Avram,', <b><i>Scalable QoS routing in MPLS networks using mobile code</i></b>, <i>PhD thesis</i>, <i>PhD thesis</i>, '')
('Sanda (Dragoș) Avram and Radu Dragoș,\n\t', <b><i>Modern routing techniques for future QoS enabled networks</i></b>, <a href="http://carpathian.ubm.ro/">Carpathian Journal of Mathematics,
		seria B, fascicola Matematica-Informatica</a>, 'http://carpathian.ubm.ro/', '2005')
('Sanda (Dragoș) Avram and Martin Collier,', <b><i>Macro-routing: a new hierarchical routing protocol</i></b>, <a href="http://www.ieee-globecom.org/2004/">IEEE Global Telecommunications Conference (GLOBECOM)</a>, 'http://www.ieee-globecom.org/2004/', '2004')
('Sanda (Dragoș) Avram and Martin Collier,', <b><i>A proposed architecture for integrating Active Networks and MPLS</i></b>, <a href="http://marjan.fesb.hr/SoftCOM/2002/">10th IEEE International Conference on Software, Telecommunications and Computer Networks (SoftCOM)</a>, 'http://marjan.fesb.hr/SoftCOM/2002/', '2002')
('Radu Dragoș, Sanda (Dragoș) Avram, and Martin Collier,', <b><i>Design and implementation of an MPLS based load balancing architecture for Web switching</i></b>, <a href="http://www.itcspecialistseminar.com/">15th Internet Traffic Engineering and Traffic Management (ITC)</a>, 'http://www.itcspecialistseminar.com/', '2002')
('Sanda (Dragoș) Avram,', <b><i>Active Networks and MPLS integration for better access networks: Framework and Applicability</i></b>, <i>transfer report (for master degree)</i>, <i>transfer report (for master degree)</i>, '')
('Sanda (Dragoș) Avram, Radu Dragoș, and Martin Collier,', <b><i>Bandwidth Management in MPLS Networks</i></b>, <a href="">First Joint IEI/IEE Symposium on Telecommunications Systems Research</a>, '', '2001')
('Sanda (Dragoș) Avram,', <b><i>Aplicatii specifice INTRANET (INTRANET applications)</i></b>, <i>Dissertation thesis</i>, <i>Dissertation thesis</i>, '')
('Sanda (Dragoș) Avram,', <b><i>Limbajul JavaScript: aplicatii in programarea distribuita (JavaScript: distributed applications)</i></b>, <i>bachelor thesis</i>, <i>bachelor thesis</i>, '')

47 pubs obtained

DB Storage (TODO)

Time to store the entries in the papers DB table.





In [9]:



    


import mariadb
import json



    











In [10]:



    


with open('../credentials.json', 'r') as crd_json_fd:
    json_text = crd_json_fd.read()
    json_obj = json.loads(json_text)



    











In [11]:



    


credentials = json_obj["Credentials"]
username = credentials["username"]
password = credentials["password"]



    











In [13]:



    


table_name = "publications_cache"
db_name = "ubbcluj"



    











In [14]:



    


mariadb_connection = mariadb.connect(user=username, password=password, database=db_name)
mariadb_cursor = mariadb_connection.cursor()



    











In [16]:



    


print(table_name)



    


















    






publications_cache

















In [38]:



    


for paper in pubs:
    
    title = ""
    pub_date = ""
    affiliations = ""
    authors = ""
    print(paper)
    print()
    try:
        pub_date = paper[4].lstrip()
        pub_date = str(pub_date) + "-01-01"
        if len(pub_date) != 10:
            pub_date = ""
    except:
        pass
    
    try:
        authors = paper[0].lstrip()
    except Exception as e:
        print(e)
    
    try:
        affiliations = paper[2].text.lstrip()
    except Exception as e:
        print(e)
    
    try:
#         print(type(paper[1]))
        title = paper[1].text
        if ('\'') in title:
            title = title.split('\'')[0]
    except AttributeError:
        pass
    
    
    
    insert_string = "INSERT INTO {0} SET ".format(table_name) # OK
    insert_string += "Title=\'{0}\', ".format(title) # OK
    insert_string += "ProfessorId=\'{0}\', ".format(6) # OK
    if pub_date != "":
        insert_string += "PublicationDate=\'{0}\', ".format(str(pub_date)) # TODO
    insert_string += "Authors=\'{0}\', ".format(authors) # OK
    insert_string += "Affiliations=\'{0}\' ".format(affiliations) # OK
    print(insert_string) 

    
    try:
        mariadb_cursor.execute(insert_string)
    except mariadb.ProgrammingError as pe:
        print("Error")
        raise pe
    except mariadb.IntegrityError:
        continue



    


















    






('Sanda (Dragoș) Avram, Diana Șotropa, and Diana Troancă,', <b><i>Highlighting Trend-Setters in Educational Platforms by Means of Formal Concept Analysis and Answer Set Programming</i></b>, <a href="https://link.springer.com/chapter/10.1007/978-3-319-92928-6_5"> IFIP Advances in Information and Communication Technology</a>, 'https://link.springer.com/chapter/10.1007/978-3-319-92928-6_5', '2018')

INSERT INTO publications_cache SET Title='Highlighting Trend-Setters in Educational Platforms by Means of Formal Concept Analysis and Answer Set Programming', ProfessorId='6', PublicationDate='2018-01-01', Authors='Sanda (Dragoș) Avram, Diana Șotropa, and Diana Troancă,', Affiliations='IFIP Advances in Information and Communication Technology' 
('Sanda (Dragoș) Avram, Christian Săcărea, and Diana Șotropa,', <b><i>Investigating Educational Attractors and Life Tracks in e-Learning Environments Using Formal Concept Analysis</i></b>, <a href="http://softcom2017.fesb.unist.hr/">The 25th International Conference on Software, Telecommunications and Computer Networks (SoftCOM)</a>, 'http://softcom2017.fesb.unist.hr/', '2017')

INSERT INTO publications_cache SET Title='Investigating Educational Attractors and Life Tracks in e-Learning Environments Using Formal Concept Analysis', ProfessorId='6', PublicationDate='2017-01-01', Authors='Sanda (Dragoș) Avram, Christian Săcărea, and Diana Șotropa,', Affiliations='The 25th International Conference on Software, Telecommunications and Computer Networks (SoftCOM)' 
('Sanda (Dragoș) Avram, Christian Săcărea, and Diana Troancă,', <b><i>Using Pattern Structures for Mining Student Behaviour in E-learning Platforms on specific Triggers</i></b>, <a href="http://softcom2017.fesb.unist.hr/">The 25th International Conference on Software, Telecommunications and Computer Networks (SoftCOM)</a>, 'http://softcom2017.fesb.unist.hr/', '2017')

INSERT INTO publications_cache SET Title='Using Pattern Structures for Mining Student Behaviour in E-learning Platforms on specific Triggers', ProfessorId='6', PublicationDate='2017-01-01', Authors='Sanda (Dragoș) Avram, Christian Săcărea, and Diana Troancă,', Affiliations='The 25th International Conference on Software, Telecommunications and Computer Networks (SoftCOM)' 
('Sanda (Dragoș) Avram, Christian Săcărea, and Diana Șotropa,', <b><i>An investigation of user behavior in educational platforms using Temporal Concept Analysis</i></b>, <a href="https://icfca2017.irisa.fr/">The 14th International Conference on Formal Concept Analysis (ICFCA)</a>, 'https://icfca2017.irisa.fr/', '2017')

INSERT INTO publications_cache SET Title='An investigation of user behavior in educational platforms using Temporal Concept Analysis', ProfessorId='6', PublicationDate='2017-01-01', Authors='Sanda (Dragoș) Avram, Christian Săcărea, and Diana Șotropa,', Affiliations='The 14th International Conference on Formal Concept Analysis (ICFCA)' 
('Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,', <b><i>Analysing the Effect of Changing the Educational Methods by Using FCA</i></b>, <a href="http://marjan.fesb.hr/SoftCOM/2016/">The 24th International Conference on Software, Telecommunications and Computer Networks (SoftCOM)</a>, 'http://marjan.fesb.hr/SoftCOM/2016/', '2016')

INSERT INTO publications_cache SET Title='Analysing the Effect of Changing the Educational Methods by Using FCA', ProfessorId='6', PublicationDate='2016-01-01', Authors='Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,', Affiliations='The 24th International Conference on Software, Telecommunications and Computer Networks (SoftCOM)' 
('Sanda (Dragoș) Avram, Diana Haliță, and Diana Troancă,', <b><i> Investigating Trend-setters in E-learning Systems using Polyadic Formal Concept Analysis and Answer Set Programming</i></b>, <a href="http://emlconseil.free.fr/eml/?page_id=104">The 4th International Workshop on Artificial Intelligence for Knowledge Management (AI4KM)</a>, 'http://emlconseil.free.fr/eml/?page_id=104', '2016')

INSERT INTO publications_cache SET Title=' Investigating Trend-setters in E-learning Systems using Polyadic Formal Concept Analysis and Answer Set Programming', ProfessorId='6', PublicationDate='2016-01-01', Authors='Sanda (Dragoș) Avram, Diana Haliță, and Diana Troancă,', Affiliations='The 4th International Workshop on Artificial Intelligence for Knowledge Management (AI4KM)' 
('Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,', <b><i>Distilling Conceptual Structures from Weblog Using Polyadic FCA</i></b>, <a href="https://www.irit.fr/ICCS2016/">The 22nd International Conference on Conceptual Structures (ICCS)</a>, 'https://www.irit.fr/ICCS2016/', '2016')

INSERT INTO publications_cache SET Title='Distilling Conceptual Structures from Weblog Using Polyadic FCA', ProfessorId='6', PublicationDate='2016-01-01', Authors='Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,', Affiliations='The 22nd International Conference on Conceptual Structures (ICCS)' 
('Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,', <b><i>Attractors in Web Based Educational Systems. A Conceptual Knowledge Processing Grounded Approach</i></b>, <a href="http://ksem2015.swu.edu.cn/">The 8th International Conference on Knowledge Science, Engineering and Management (KSEM)</a>, 'http://ksem2015.swu.edu.cn/', '2015')

INSERT INTO publications_cache SET Title='Attractors in Web Based Educational Systems. A Conceptual Knowledge Processing Grounded Approach', ProfessorId='6', PublicationDate='2015-01-01', Authors='Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,', Affiliations='The 8th International Conference on Knowledge Science, Engineering and Management (KSEM)' 
('Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,', <b><i>Behavioral pattern mining in web based educational system</i></b>, <a href="http://marjan.fesb.hr/SoftCOM/2015/">23rd International Conference on Software, Telecommunications and Computer Networks (SoftCOM)</a>, 'http://marjan.fesb.hr/SoftCOM/2015/', '2015')

INSERT INTO publications_cache SET Title='Behavioral pattern mining in web based educational system', ProfessorId='6', PublicationDate='2015-01-01', Authors='Sanda (Dragoș) Avram, Diana Haliță, and Christian Săcărea,', Affiliations='23rd International Conference on Software, Telecommunications and Computer Networks (SoftCOM)' 
('Sanda (Dragoș) Avram, Diana Haliță, Christian Săcărea, and Diana Troancă,\n\t', <b><i>An FCA grounded study of user dynamics through log exploration</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2014')

INSERT INTO publications_cache SET Title='An FCA grounded study of user dynamics through log exploration', ProfessorId='6', PublicationDate='2014-01-01', Authors='Sanda (Dragoș) Avram, Diana Haliță, Christian Săcărea, and Diana Troancă,
	', Affiliations='Studia Universitatis Babeș-Bolyai Series Informatica' 
('Sanda (Dragoș) Avram, Diana Haliță, Christian Săcărea, and Diana Troancă,', <b><i>Applying Triadic FCA in Studying Web Usage Behaviors</i></b>, <a href="http://conferences.ulbsibiu.ro/ksem2014/">The 7th International Conference on Knowledge Science, Engineering and Management</a>, 'http://conferences.ulbsibiu.ro/ksem2014/', '2014')

INSERT INTO publications_cache SET Title='Applying Triadic FCA in Studying Web Usage Behaviors', ProfessorId='6', PublicationDate='2014-01-01', Authors='Sanda (Dragoș) Avram, Diana Haliță, Christian Săcărea, and Diana Troancă,', Affiliations='The 7th International Conference on Knowledge Science, Engineering and Management' 
('Sanda (Dragoș) Avram and Alina Mihaela Beldean,\n\t', <b><i>Analysing Web Usage with Force-Directed Graphs</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2013')

INSERT INTO publications_cache SET Title='Analysing Web Usage with Force-Directed Graphs', ProfessorId='6', PublicationDate='2013-01-01', Authors='Sanda (Dragoș) Avram and Alina Mihaela Beldean,
	', Affiliations='Studia Universitatis Babeș-Bolyai Series Informatica' 
('Ovidiu Parvu and Sanda (Dragoș) Avram,\n\t', <b><i>Building Intelligent Knowledge Management Systems</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2012')

INSERT INTO publications_cache SET Title='Building Intelligent Knowledge Management Systems', ProfessorId='6', PublicationDate='2012-01-01', Authors='Ovidiu Parvu and Sanda (Dragoș) Avram,
	', Affiliations='Studia Universitatis Babeș-Bolyai Series Informatica' 
('Sanda (Dragoș) Avram and Christian Săcărea,\n\t', <b><i>Analysing the Usage of Pulse Portal with Formal Concept Analysis</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2012')

INSERT INTO publications_cache SET Title='Analysing the Usage of Pulse Portal with Formal Concept Analysis', ProfessorId='6', PublicationDate='2012-01-01', Authors='Sanda (Dragoș) Avram and Christian Săcărea,
	', Affiliations='Studia Universitatis Babeș-Bolyai Series Informatica' 
('Sanda (Dragoș) Avram and Christian Săcărea,', <b><i>Web Analytics with Formal Concept Analysis</i></b>, <a href="">Zilele Academice Clujene (ZAC)</a>, '', '2012')

INSERT INTO publications_cache SET Title='Web Analytics with Formal Concept Analysis', ProfessorId='6', PublicationDate='2012-01-01', Authors='Sanda (Dragoș) Avram and Christian Săcărea,', Affiliations='Zilele Academice Clujene (ZAC)' 
('Parvu Ovidiu and Sanda (Dragoș) Avram,', <b><i>Interactive and intelligent doctorate theses administration platform</i></b>, <a href="">Zilele Academice Clujene (ZAC)</a>, '', '2012')

INSERT INTO publications_cache SET Title='Interactive and intelligent doctorate theses administration platform', ProfessorId='6', PublicationDate='2012-01-01', Authors='Parvu Ovidiu and Sanda (Dragoș) Avram,', Affiliations='Zilele Academice Clujene (ZAC)' 
('Rareș Boian, Sanda (Dragoș) Avram, and Claudiu Cobârzan,\n\t', <b><i>Aport: web portal for assisting teaching</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2011')

INSERT INTO publications_cache SET Title='Aport: web portal for assisting teaching', ProfessorId='6', PublicationDate='2011-01-01', Authors='Rareș Boian, Sanda (Dragoș) Avram, and Claudiu Cobârzan,
	', Affiliations='Studia Universitatis Babeș-Bolyai Series Informatica' 
('Sanda-Maria (Dragoș) Avram,', <b><i>Why Google Analytics Cannot Be Used For Educational Web Content</i></b>, <a href="http://www.mirlabs.org/nwesp11/">International Conference on Next Generation Web Services Practices (NWeSP)</a>, 'http://www.mirlabs.org/nwesp11/', '2011')

INSERT INTO publications_cache SET Title='Why Google Analytics Cannot Be Used For Educational Web Content', ProfessorId='6', PublicationDate='2011-01-01', Authors='Sanda-Maria (Dragoș) Avram,', Affiliations='International Conference on Next Generation Web Services Practices (NWeSP)' 
('Sanda-Maria (Dragoș) Avram,', <b><i>Hierarchical QoS Routing by Using Multi-Constrained Macro-Routing</i></b>, <a href="http://www.mirlabs.org/nwesp11/">International Conference on Next Generation Web Services Practices (NWeSP)</a>, 'http://www.mirlabs.org/nwesp11/', '2011')

INSERT INTO publications_cache SET Title='Hierarchical QoS Routing by Using Multi-Constrained Macro-Routing', ProfessorId='6', PublicationDate='2011-01-01', Authors='Sanda-Maria (Dragoș) Avram,', Affiliations='International Conference on Next Generation Web Services Practices (NWeSP)' 
('Sanda-Maria (Dragoș) Avram,', <b><i>Why integrated E-learning Analytics are the best solution?</i></b>, <a href="http://www.iccp.ro/iccp2011/">IEEE International Conference on Intelligent Computer Communication and Processing (ICCP)</a>, 'http://www.iccp.ro/iccp2011/', '2011')

INSERT INTO publications_cache SET Title='Why integrated E-learning Analytics are the best solution?', ProfessorId='6', PublicationDate='2011-01-01', Authors='Sanda-Maria (Dragoș) Avram,', Affiliations='IEEE International Conference on Intelligent Computer Communication and Processing (ICCP)' 
('Rares Boian, Sanda (Dragoș) Avram, and Claudiu Cobarzan,', <b><i>THE APORT WEB PORTAL: ADVANCED E-LEARNING FEATURES</i></b>, <a href="http://www.cs.ubbcluj.ro/kept2011/">Knowledge Engineering Principles and Techniques (KEPT)</a>, 'http://www.cs.ubbcluj.ro/kept2011/', '2011')

INSERT INTO publications_cache SET Title='THE APORT WEB PORTAL: ADVANCED E-LEARNING FEATURES', ProfessorId='6', PublicationDate='2011-01-01', Authors='Rares Boian, Sanda (Dragoș) Avram, and Claudiu Cobarzan,', Affiliations='Knowledge Engineering Principles and Techniques (KEPT)' 
('', <div class="blue">Author(s):</div>, <div class="blue">Title:</div>, <div class="blue">Title:</div>, '')

INSERT INTO publications_cache SET Title='Author(s):', ProfessorId='6', Authors='', Affiliations='Title:' 
('Sanda (Dragoș) Avram,\n\t', <b><i>Current Extensions on PULSE</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2010')

INSERT INTO publications_cache SET Title='Current Extensions on PULSE', ProfessorId='6', PublicationDate='2010-01-01', Authors='Sanda (Dragoș) Avram,
	', Affiliations='Studia Universitatis Babeș-Bolyai Series Informatica' 
('Radu-Calin Dragoș and Sanda-Maria (Dragoș) Avram,', <b><i>Implementation of a layer 7 BSD firewall</i></b>, <a href="http://www.iaria.org/conferences2009/ICIW09.html">9th Roedunet International Conference (RoEduNet)</a>, 'http://www.iaria.org/conferences2009/ICIW09.html', '2010')

INSERT INTO publications_cache SET Title='Implementation of a layer 7 BSD firewall', ProfessorId='6', PublicationDate='2010-01-01', Authors='Radu-Calin Dragoș and Sanda-Maria (Dragoș) Avram,', Affiliations='9th Roedunet International Conference (RoEduNet)' 
('Sanda (Dragoș) Avram,', <b><i>The new face of PULSE</i></b>, <a href="">Zilele Academice Clujene (ZAC)</a>, '', '2010')

INSERT INTO publications_cache SET Title='The new face of PULSE', ProfessorId='6', PublicationDate='2010-01-01', Authors='Sanda (Dragoș) Avram,', Affiliations='Zilele Academice Clujene (ZAC)' 
('Sanda (Dragoș) Avram and Radu Dragoș,\n\t', <b><i>WATEC: a Web Analytics Tool for Educational Content</i></b>, <a href="http://www.cs.ubbcluj.ro/kept2009/">KEPT2009 Knowledge Engineering Principles and Techniques</a>, 'http://www.cs.ubbcluj.ro/kept2009/', '2009')

INSERT INTO publications_cache SET Title='WATEC: a Web Analytics Tool for Educational Content', ProfessorId='6', PublicationDate='2009-01-01', Authors='Sanda (Dragoș) Avram and Radu Dragoș,
	', Affiliations='KEPT2009 Knowledge Engineering Principles and Techniques' 
('Sanda (Dragoș) Avram and Martin Collier,\n\t', <b><i>Macro-Routing. Performance evaluation</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2009')

INSERT INTO publications_cache SET Title='Macro-Routing. Performance evaluation', ProfessorId='6', PublicationDate='2009-01-01', Authors='Sanda (Dragoș) Avram and Martin Collier,
	', Affiliations='Studia Universitatis Babeș-Bolyai Series Informatica' 
('Sanda (Dragoș) Avram and Radu Dragoș,\n\t', <b><i>Web Analytics for Educational Content</i></b>, <a href="http://www.cs.ubbcluj.ro/~studia-i/">Studia Universitatis Babeș-Bolyai Series Informatica</a>, 'http://www.cs.ubbcluj.ro/~studia-i/', '2009')

INSERT INTO publications_cache SET Title='Web Analytics for Educational Content', ProfessorId='6', PublicationDate='2009-01-01', Authors='Sanda (Dragoș) Avram and Radu Dragoș,
	', Affiliations='Studia Universitatis Babeș-Bolyai Series Informatica' 
('Sanda (Dragoș) Avram,', <b><i>PULSE Extended</i></b>, <a href="http://www.iaria.org/conferences2009/ICIW09.html">The Fourth International Conference on Internet and Web Applications and Services</a>, 'http://www.iaria.org/conferences2009/ICIW09.html', '2009')

INSERT INTO publications_cache SET Title='PULSE Extended', ProfessorId='6', PublicationDate='2009-01-01', Authors='Sanda (Dragoș) Avram,', Affiliations='The Fourth International Conference on Internet and Web Applications and Services' 
('Sanda (Dragoș) Avram,', <b><i>PULSE - a PHP Utility used in Laboratories for Student Evaluation</i></b>, <a href="http://www.seerc.org/ieeii2007/">International Conference on Informatics Education Europe II (IEEII)</a>, 'http://www.seerc.org/ieeii2007/', '2007')

INSERT INTO publications_cache SET Title='PULSE - a PHP Utility used in Laboratories for Student Evaluation', ProfessorId='6', PublicationDate='2007-01-01', Authors='Sanda (Dragoș) Avram,', Affiliations='International Conference on Informatics Education Europe II (IEEII)' 
('Sanda (Dragoș) Avram and Radu Dragoș,\n\t', <b><i>SINE - a System with Interactive ackNowledgement and Evaluation of students work during laboratory sessions</i></b>, <a href="http://math.ubbcluj.ro/~didactica/">Didactica Mathematica</a>, 'http://math.ubbcluj.ro/~didactica/', '2007')

INSERT INTO publications_cache SET Title='SINE - a System with Interactive ackNowledgement and Evaluation of students work during laboratory sessions', ProfessorId='6', PublicationDate='2007-01-01', Authors='Sanda (Dragoș) Avram and Radu Dragoș,
	', Affiliations='Didactica Mathematica' 
('Sanda (Dragoș) Avram and Radu Dragoș,\n\t', <b><i>WinNet - a network tool</i></b>, <a href="http://www.journal.univagora.ro/">International Journal of Computers, Communications &amp; Control  (IJCCC)</a>, 'http://www.journal.univagora.ro/', '2006')

INSERT INTO publications_cache SET Title='WinNet - a network tool', ProfessorId='6', PublicationDate='2006-01-01', Authors='Sanda (Dragoș) Avram and Radu Dragoș,
	', Affiliations='International Journal of Computers, Communications & Control  (IJCCC)' 
('Sanda (Dragoș) Avram and Martin Collier,', <b><i>Multi-constraint Macro-routing by using the Extended Full-Mesh aggregation technique</i></b>, <a href="">2nd International Conference on Intelligent Computer Communication and Processing (ICCP)</a>, '', '2006')

INSERT INTO publications_cache SET Title='Multi-constraint Macro-routing by using the Extended Full-Mesh aggregation technique', ProfessorId='6', PublicationDate='2006-01-01', Authors='Sanda (Dragoș) Avram and Martin Collier,', Affiliations='2nd International Conference on Intelligent Computer Communication and Processing (ICCP)' 
('Radu Dragoș and Sanda (Dragoș) Avram,', <b><i>A graph theoretical approach to traffic management in ISP networks using the overlay MPLS network</i></b>, <a href="">2nd International Conference on Intelligent Computer Communication and Processing (ICCP)</a>, '', '2006')

INSERT INTO publications_cache SET Title='A graph theoretical approach to traffic management in ISP networks using the overlay MPLS network', ProfessorId='6', PublicationDate='2006-01-01', Authors='Radu Dragoș and Sanda (Dragoș) Avram,', Affiliations='2nd International Conference on Intelligent Computer Communication and Processing (ICCP)' 
('Sanda (Dragoș) Avram and Radu Dragoș,', <b><i>WinNet - a network tool</i></b>, <a href="http://www.iccc.univagora.ro/">International Conference on Computers, Communications and Control (ICCCC)</a>, 'http://www.iccc.univagora.ro/', '2006')

INSERT INTO publications_cache SET Title='WinNet - a network tool', ProfessorId='6', PublicationDate='2006-01-01', Authors='Sanda (Dragoș) Avram and Radu Dragoș,', Affiliations='International Conference on Computers, Communications and Control (ICCCC)' 
('Radu Dragoș and Sanda (Dragoș) Avram,', <b><i>Dirijare 'inteligenta' a traficului de date cu cerinte specifice ('Smart' QoS routing)</i></b>, <a href="">Zilele Academice Clujene (ZAC)</a>, '', '2006')

INSERT INTO publications_cache SET Title='Dirijare ', ProfessorId='6', PublicationDate='2006-01-01', Authors='Radu Dragoș and Sanda (Dragoș) Avram,', Affiliations='Zilele Academice Clujene (ZAC)' 
('Sanda (Dragoș) Avram and Radu Dragoș,', <b><i>MPLS - o realitate actuala sau de viitor? (MPLS - present or future?)</i></b>, <a href="">Zilele Academice Clujene (ZAC)</a>, '', '2006')

INSERT INTO publications_cache SET Title='MPLS - o realitate actuala sau de viitor? (MPLS - present or future?)', ProfessorId='6', PublicationDate='2006-01-01', Authors='Sanda (Dragoș) Avram and Radu Dragoș,', Affiliations='Zilele Academice Clujene (ZAC)' 
('Sanda (Dragoș) Avram and Radu Dragoș,', <b><i>SINE - Sistem Informatic de Notare si Evaluare a Activitatii de Laborator</i></b>, <a href="">Conferinta Nationala Didactica Matematicii</a>, '', '2006')

INSERT INTO publications_cache SET Title='SINE - Sistem Informatic de Notare si Evaluare a Activitatii de Laborator', ProfessorId='6', PublicationDate='2006-01-01', Authors='Sanda (Dragoș) Avram and Radu Dragoș,', Affiliations='Conferinta Nationala Didactica Matematicii' 
('Sanda (Dragoș) Avram,', <b><i>Scalable QoS routing in MPLS networks using mobile code</i></b>, <i>PhD thesis</i>, <i>PhD thesis</i>, '')

INSERT INTO publications_cache SET Title='Scalable QoS routing in MPLS networks using mobile code', ProfessorId='6', Authors='Sanda (Dragoș) Avram,', Affiliations='PhD thesis' 
('Sanda (Dragoș) Avram and Radu Dragoș,\n\t', <b><i>Modern routing techniques for future QoS enabled networks</i></b>, <a href="http://carpathian.ubm.ro/">Carpathian Journal of Mathematics,
		seria B, fascicola Matematica-Informatica</a>, 'http://carpathian.ubm.ro/', '2005')

INSERT INTO publications_cache SET Title='Modern routing techniques for future QoS enabled networks', ProfessorId='6', PublicationDate='2005-01-01', Authors='Sanda (Dragoș) Avram and Radu Dragoș,
	', Affiliations='Carpathian Journal of Mathematics,
		seria B, fascicola Matematica-Informatica' 
('Sanda (Dragoș) Avram and Martin Collier,', <b><i>Macro-routing: a new hierarchical routing protocol</i></b>, <a href="http://www.ieee-globecom.org/2004/">IEEE Global Telecommunications Conference (GLOBECOM)</a>, 'http://www.ieee-globecom.org/2004/', '2004')

INSERT INTO publications_cache SET Title='Macro-routing: a new hierarchical routing protocol', ProfessorId='6', PublicationDate='2004-01-01', Authors='Sanda (Dragoș) Avram and Martin Collier,', Affiliations='IEEE Global Telecommunications Conference (GLOBECOM)' 
('Sanda (Dragoș) Avram and Martin Collier,', <b><i>A proposed architecture for integrating Active Networks and MPLS</i></b>, <a href="http://marjan.fesb.hr/SoftCOM/2002/">10th IEEE International Conference on Software, Telecommunications and Computer Networks (SoftCOM)</a>, 'http://marjan.fesb.hr/SoftCOM/2002/', '2002')

INSERT INTO publications_cache SET Title='A proposed architecture for integrating Active Networks and MPLS', ProfessorId='6', PublicationDate='2002-01-01', Authors='Sanda (Dragoș) Avram and Martin Collier,', Affiliations='10th IEEE International Conference on Software, Telecommunications and Computer Networks (SoftCOM)' 
('Radu Dragoș, Sanda (Dragoș) Avram, and Martin Collier,', <b><i>Design and implementation of an MPLS based load balancing architecture for Web switching</i></b>, <a href="http://www.itcspecialistseminar.com/">15th Internet Traffic Engineering and Traffic Management (ITC)</a>, 'http://www.itcspecialistseminar.com/', '2002')

INSERT INTO publications_cache SET Title='Design and implementation of an MPLS based load balancing architecture for Web switching', ProfessorId='6', PublicationDate='2002-01-01', Authors='Radu Dragoș, Sanda (Dragoș) Avram, and Martin Collier,', Affiliations='15th Internet Traffic Engineering and Traffic Management (ITC)' 
('Sanda (Dragoș) Avram,', <b><i>Active Networks and MPLS integration for better access networks: Framework and Applicability</i></b>, <i>transfer report (for master degree)</i>, <i>transfer report (for master degree)</i>, '')

INSERT INTO publications_cache SET Title='Active Networks and MPLS integration for better access networks: Framework and Applicability', ProfessorId='6', Authors='Sanda (Dragoș) Avram,', Affiliations='transfer report (for master degree)' 
('Sanda (Dragoș) Avram, Radu Dragoș, and Martin Collier,', <b><i>Bandwidth Management in MPLS Networks</i></b>, <a href="">First Joint IEI/IEE Symposium on Telecommunications Systems Research</a>, '', '2001')

INSERT INTO publications_cache SET Title='Bandwidth Management in MPLS Networks', ProfessorId='6', PublicationDate='2001-01-01', Authors='Sanda (Dragoș) Avram, Radu Dragoș, and Martin Collier,', Affiliations='First Joint IEI/IEE Symposium on Telecommunications Systems Research' 
('Sanda (Dragoș) Avram,', <b><i>Aplicatii specifice INTRANET (INTRANET applications)</i></b>, <i>Dissertation thesis</i>, <i>Dissertation thesis</i>, '')

INSERT INTO publications_cache SET Title='Aplicatii specifice INTRANET (INTRANET applications)', ProfessorId='6', Authors='Sanda (Dragoș) Avram,', Affiliations='Dissertation thesis' 
('Sanda (Dragoș) Avram,', <b><i>Limbajul JavaScript: aplicatii in programarea distribuita (JavaScript: distributed applications)</i></b>, <i>bachelor thesis</i>, <i>bachelor thesis</i>, '')

INSERT INTO publications_cache SET Title='Limbajul JavaScript: aplicatii in programarea distribuita (JavaScript: distributed applications)', ProfessorId='6', Authors='Sanda (Dragoș) Avram,', Affiliations='bachelor thesis' 

















In [68]:



    


mariadb_connection.close()

Conclusion

In the end, the DB only required ~2 manual modifications (1 deletion, 1 edit) with this code.

45 new insertions.

Content source: p0licat/university

Similar notebooks:

notebook.community | gallery | about