Professor
National Technical Universtity of Athens
School of Electrical and Computing Engineering
Division of Communication, Electronic and Information Engineering
Zographou Campus
Iroon Polytechniou 9
15780 Athens, Greece
E-mail: afrati AT softlab. ece. ntua. gr
Phone: +30-210-7722498 (Office)
Fax: +30-210-7722499
Office: 1.1.14
Building: Electrical and Comp. Engineering, Floor 1
Education
Professional Appointments
Visiting Positions
Boards and Chair of Conferences
Program Committee member
Organizing Committee member
Other Professional Activities
Projects funded by the European Union
Projects funded by the Greek General Secreteriat of Research and Technology
Graduated PhD students
Current PhD students
Current
Alumni
My DBLP entry.
2008
2007
2006
2005
Books
Chapters in books
Papers in Refereed Journals
16. Foto N. Afrati, Hans Leiß, Michel de Rougemont: Definability and Compression. Fundam. Inform. 56(1-2): 155-180 (2003)
15. Irène Guessarian, Eugénie Foustoucos, Theodore Andronikos, Foto N. Afrati: On temporal logic versus datalog. Theor. Comput. Sci. 1(303): 103-133 (2003)
14. Foto N. Afrati, Manolis Gergatsoulis, Francesca Toni: Linearizability on datalog programs. Theor. Comput. Sci. 308(1-3): 199-226 (2003)
13. Foto N. Afrati, Irène Guessarian, Michel de Rougemont: The expressiveness of DAC. Theor. Comput. Sci. 286(1): 3-32 (2002)
12. F. Afrati, E. Bampis, C. Kenyon and I. Milis, A PTAS for the average weighted completion time problem on unrelated machines, Journal of Scheduling 3 (2000) 323-332.
11. Afrati,F., "Bounded Arity Datalog (<>) Queries on Graphs" special issue of Journal of Computer and Systems Sciences, vol 55 1997 on ACM Conference 'Principles of Database Systems'.
10. Afrati, F., Cosmadakis, S.,Yannakakis, M., "Datalog vs. Polynomial Time", Journal of Computer and Systems Sciences (special issue on ACM Conference 'Principles of Database Systems'), October 1995.
9. Afrati,F., "A Polynomial Algorithm for Hamiltonian Grids". RAIRO Theoretical Informatics and Applications, Vol 28, no 6, 1994, pp 567-582.
8. Afrati, F., Stafylopatis, A., "Performance Considerations on a Random Graph Model for Parallel processing", RAIRO Theoretical Informatics and Applications, vol. 27, no. 4, 1993, pp 367-388.
7. Paschos, P., Anagnostou, M., Afrati, F., "Deterministic Access Protocols for Packet radio Networks", International Journal of Digital and Analog Communication Systems, Vol. 6 1993, pp. 151-160.
6. Afrati, F., Papadimitriou, C.H., "The Parallel Complexity of Simple Logic Programs", J.ACM, Vol. 90 No 4 September 1993, pp. 891-916.
5. Afrati, F., "The Parallel Complexity of Single Rule Logic Programs" . Discrtete Applied Mathematics (special issue) 40 (1992) pp 107-126.
4. Afrati, F., Papadimitriou, C.H., Papageorgiou, G., Roussou, A., Sagiv, Y., Ullman, J.D., "On the Convergence of Query Evaluation", Journal of Computer and Systems Sciences, Vol. 38 No 2, April 1989 (special issue), pp. 341-359.
3. Afrati, F., Papadimitriou, C.H., Papageorgiou, G. "The Synthesis of Communication Protocols", Algorithmica Vol 3, 1988 (special issue on distributed computing), pp. 451-472.
2. Afrati, F., Cosmadakis, S., Papadimitriou, C.H., Papageorgiou, G., Papakonsta ntinou "The Complexity of the Travelling Repairman Problem", RAIROTheoretical Informatics and Applications, Vol.20, No.1, 1986, pp.79-87.
1. Afrati, F., Papadimitriou, C.H., Papageorgiou, G., "The Complexity of Cubical Graphs" Information and Control Vol.66, No.1-2, July-August 1985 pp. 53-60.
Papers in Conference Proceedings
50. Foto N. Afrati, Chen Li, Prasenjit Mitra: On Containment of Conjunctive Queries with Arithmetic Comparisons. EDBT 2004: 459-476, 2004
49. Foto N. Afrati, Aristides Gionis, Heikki Mannila: Approximating a collection of frequent sets. KDD 2004: 12-19
48. Foto N. Afrati, Theodore Andronikos, Vassia Pavlaki, E. Foustoukos, Irène Guessarian: From CTL to Datalog. PCK50 2003: 72-85
47. Foto N. Afrati, Chen Li, Prasenjit Mitra: Answering Queries Using Views with Arithmetic Comparisons (ps format). PODS 2002: 209-220
46. F. Afrati, Τ. Aslanidis, E. Bampis and I. Milis, Scheduling in switching networks with set-up delays, In Proc. 4èmes Rencontres Francophones sur les aspects Algorithmiques des Télécommunications (ALGOTEL'2002).
45. Agis Papantoniou, Ezz Hattab, Foto N. Afrati, Eleftherios Kayafas, Vassilis Loumos: Change Management, a Critical Success Factor for e-Government. DEXA Workshop 2001: 402-406
44. F. Afrati and I. Milis, Designing PTASs for MIN-SUM scheduling problems (ps format), In Proc. 13th International Symposium Fundamentals of Computation Theory (FCT'01), Invited paper in the Workshop on Efficient Algorithms (WEA'01), Lecture Notes in Computer Science (Springer Verlag) LNCS-2138 (2001) 432-444.
43. Foto N. Afrati, Chen Li, Jeffrey D. Ullman: Generating Efficient Plans for Queries Using Views (ps format). SIGMOD Conference 2001
42. F. Afrati, E. Bampis, L. Finta and I. Milis, Scheduling trees with large communication delays on two identical processors, In Proc. 6th International Euro-Par Conference (EURO-PAR'00), Lecture Notes in Computer Science (Springer Verlag) LNCS-1900 (2000) 288-295.
41. Foto N. Afrati, Evripidis Bampis, Aleksei V. Fishkin, Klaus Jansen, Claire Kenyon: Scheduling to Minimize the Average Completion Time of Dedicated Tasks (ps format). FSTTCS 2000: 454-464
40. Foto N. Afrati, Hans Leiß, Michel de Rougemont: Definability and Compression (ps format). LICS 2000: 63-73
39 . F. Afrati, E. Bampis, C. Kenyon and I. Milis, Scheduling on a constant number of processors, In Proc. 2nd International Workshop on Approximation Algorithms for Combinatorial Optimization Problems (APPROX’99), Lecture Notes in Computer Science (Springer Verlag) LNCS-1671 (1999) 281-287.
38. F. Afrati, E. Bampis, C. Chekuri, D. Karger, C. Kenyon, S. Khanna, I. Milis, M. Queyranne, M. Skutella, C. Stein and M. Sviridenko, Approximation schemes for minimizing average weighted completion time with release dates (ps format), Ιn Proc. 40th IEEE Symposium on Foundations of Computer Science (FOCS’99) (1999) 32-43.
37. Foto N. Afrati, Manolis Gergatsoulis, Theodoros G. Kavalieros: Answering Queries Using Materialized Views with Disjunctions (ps format). ICDT 1999: 435-452
36. Foto N. Afrati, Eugenie Foustoucos, Theodore Andronikos: Datalog Trees and Their Automata (.PS Format). In proceedings of the 2nd Pan Hellenic Symposium on Logic, Delphi 1999
35 . Foto N. Afrati, I. Karali, Theodoros Mitakos: On Inheritance in Object Oriented Datalog. IADT 1998: 280-289
34. Foto N. Afrati, Theodore Andronikos, Theodore G. Kavalieros: On the Expressiveness of Query Languages with Linear Constraints; Capturing Desirable Spatial Properties (ps format). CDB 1997: 105-115
33. Foto N. Afrati, Francesca Toni: On the Relationsship Between Chain Queries and Linear Datalog Programs (ps format). DDLP 1997
32. Foto N. Afrati, Irène Guessarian, Michel de Rougemont: The Expressiveness of Datalog Circuits (DAC) (ps format). MFCS 1997: 119-128
31. Foto N. Afrati, Phokion G. Kolaitis: Database Theory - ICDT '97, 6th International Conference, Delphi, Greece, January 8-10, 1997, Proceedings Springer 1997
30. Foto N. Afrati: Arity Hierarchies for Fixed-Point Logics (.PS Format)
Panhellenic Symposium on Logic, Cyprus, 199729. Foto N. Afrati, Isambo Karali, Theodoros Mitakos: Datalog, Units and Information Hiding (.PS Format)
Languages and Models with Objects '97, Roscoff France.
28 . Foto N. Afrati, Manolis Gergatsoulis, Maria Katzouraki: On Transformations into Linear Database Logic Programs (ps format). Ershov Memorial Conference 1996: 433-444
27. Afrati, F., Kavalieros, Th., Theodoratos, D., "On the Complexity of Updating Knowledge Bases", Proceedings of Conference of Greek CS Society, Athens, Dec. 1995.
26. Afrati,F., Andronikos,Th., Kavalieros,Th., "On the Expressiveness of Query Languages with Linear Constraints: Considerations on Spatial Data" Proceedings of 2nd workshop on Constraint Databases, Springer Verlag Lecture Notes in CS, 1995.
25. Afrati,F., Cosmadakis,S., Grumbach,S., Kuper,G., "Linear vs. Polynomial Constraints in Database Query Languages", 2nd Workshop on Principles and Practice of Constraint Programming, 1994.
24. Afrati,F., "Bounded Arity Datalog (<>) Queries on Graphs", Proceeding s of the 13th ACM PODS, Symposium on the Principles of Database Systems, 1994.
23. Afrati, F, Kavalieros T., Theodoratos D., "Revising Propositional Horn Clause Knowledge Bases" (.PS Format), ERCIM-11/94-R034, November '94
22. Afrati,F., Cosmadakis,S.,Yannakakis,M., "Datalog vs. Polynomial Time", Proceedings of the 10th ACM PODS, Symposium on the Principles of Database Systems, 1991, pp.13-25; (the final version appears above as a refereed journal entry).
21. Afrati,F., "Finding Strongly Connected Components in Series Parallel Graphs". Proceedings TENCON'91, New Dehli, India,1991.
20. Afrati,F., Coutras,C., "A Hypertext Model Supporting Query Mechanisms&qu ot;, Proceedings of the European Conference on Hypertext 1990, published in volume Hypertext: Concepts, systems and applications by Cambridge University Press.
19. Afrati,F., Cosmadakis,S., "Expressiveness of Restricted Recursive Queries", Proceedings of the 21st ACM STOC, Symposium on Theory of Computing, May 1989, pp. 113-126.
18. Afrati,F., Stafylopatis,A., "Performance Considerations on a Random Graph Model for Parallel Processing". Proceedings of IMACS Conference, Paris 1988.
17. Afrati,F, Papadimitriou,C.H., Papageorgiou,G., "Scheduling Dags to Minimize Time and Communication", Proceedings of the Aegian Workshop on Computing (AWOC), June 1988.
16. Afrati,F., Papadimitriou,C.H., "The Parallel Complexity of Simple Chain Queries", Proceedings of the 6th ACM PODS, Symposium on the Principles of Database Systems, March 1987 pp. 210-213; (the final version appears above as a refereed journal entry).
15. Afrati,F., Papadimitriou,C.H., Papageorgiou,G., Roussou,A., Sagiv,Y.,Ullman,J .D., "Convergence of Sideways Query Evaluation", Proceedings of the 5th ACM PODS, Symposium on the Principles of Database Systems,March 1986 pp. 24-30; (the final version appears above as a refereed journal entry).
14. Afrati,F., Papadimitriou,C.H., Papageorgiou,G. "The Synthesis of Communication Protocols", Proceedings of the 5th ACM PODC. Symposium on the Principles of Distributed Computing, August 1986;(the final version (appears above as a refereed journal entry).
13. Afrati,F., Anagnostou,M., Protonotarios,E.N., "Performance Evaluation of Hybrid ARQ Protocols", Proceedings of IEEE Symposium on Information Theory, June 1985.
12. Afrati,F., Dendrinos,M., "Symmetry and Cyclicity Properties of some Low Complexity Codes", Proceedings of IEEE Symposium on Information Theory, June 1985.
11. Anagnostou,M., Afrati,F., "On the Complexity and Accuracy of Algorithms used for the Performance Evaluation of ARQ Protocols", Proceedings of the IEEE International Conference MELECON, 1985.
10. Afrati,F., Papaspirou,V., "Optimal Extension of a Linear Code", Proceedings of the IEEE International Conference MELECON, 1985.
9. Afrati,F., Papadimitriou,C.H., Papageorgiou,G., "The Complexity of Cubical Graphs", Proceedings of the 11th ICALP, International Colloquium on Automata, Languages and Programming, Lecture Notes in Computer Science appears above as a refereed journal entry),1984.
8. Afrati,F., Dendrinos.M., "Considerations on Low Complexity Codes Concerning Symmetry and Cyclicity", Proceedings DIGITECH, 1984.
7. Afrati,F., Ballas,D., "Analysis of Error Correcting Codes for the Binary Symmetric Channel", Proceedings MECO 1983.
6. Afrati,F., Anagnostou,M., Mikroudis,N., "A Hybrid ARQ Scheme using Convolutional Codes", Proceedings MECO 1983.
5. Afrati,F., Anagnostou,M., Mikroudis,N.,"A Hybrid Scheme for the Improvement of the ARQ Protocols", Proceedings of the IEEE International Conference MELECON, 1983.
4. Afrati,F., "A Random Search Algorithm for the Construction of Ternary Linear Block Codes", Proceedings of the IEEE International Conference MELECON, 1983.
3. Afrati,F., "A Graph-Theoretic Approach to the Binary Linear Block Code Construction", Proceedings of the IEEE International Symposium on Information Theory, 1982.
2. Afrati,F., " A Branch-and-Bound Method for the Construction of Binary Linear Block Codes", Proceedings of the IEEE International Conference MELECON, 1981.
1. Afrati,F., Constantinides,A.G., " The Use of Graph Theory in Binary Block Code Construction", Proceedings of the IEEE International Conference on Digital Signal Processing, 1978.
What is Data Mining, Applications, The Data-Mining Communities, Association-Rule Mining : Association Rules and Frequent Itemsets , MarketBasket Mining, The APriori Algorithm, PCY Algorithm, Low-Support/High Correlation : Min Hashing Algorithm, LSH Algorithm, kMin Hashing Algorithm, Hamming LSH Algorithm, Query Flocks: Query Flock Notation, Execution Strategies, Optimal Query Flock, Searching the Web : Page Rank, Problems With Real Web Graphs, Hubs and Authorities, Google Solution to Dead Ends and Spider Traps, Google AntiSpam Devices, Web Mining :The DICE Engine, Books and Authors, What is Pattern, Finding Data Occurrences Given Data,, Finding Data Occurrences Given Patterns, Clustering : Distance Measure, The Curse of Dimensionality, Approaches to Clustering, The k-Means Algorithm, The BFR Algorithm Fastmap in Clustering Algorithms, Hierarchical Clustering, The GRGPF Algorithm, CURE Algorithm, Matching Sequences : Fourier Transforms as Indexes for Sequences, Matching Queries to Sequences of the Same Length, Queries That are Shorter than the Sequences, Trails, Matching Queries of Arbitrary Length, Mining Event Sequences : Episode Mining, Monotonicity of Episodes and the APriori Algorithm, Checking Parallel Episodes, Checking Serial Episodes, Counting Composite Events.
Introduction to SQL. Relational Algebra. Introduction to Datalog, Stratified Negation, Stable and Well-Founded Models. Conjunctive queries with Negation and Arithmetic. Query Containment. Answering Queries using Views; the Bucket algorithm, the inverse rule algorithm. Data Dependencies, Normalization. Acyclic Hypergraphs, Computing Acyclic Joins. The Universal Relation. Introduction to Magic sets, Rule-goal trees, the magic-sets algorithm.
Online Homeworks: Gradiance