1 R Agrawal A Ailamaki P A Bernstein
Ενδεικτικά άρθρα 1. R. Agrawal, A. Ailamaki, P. A. Bernstein, E. A. Brewer, M. J. Carey, S. Chaudhuri, A. Doan, D. Florescu, M. J. Franklin, H. Garcia-molina, J. Gehrke, L. Gruenwald, L. M. Haas, A. Y. Halevy, J. M. Hellerstein, Y. E. Ioannidis, H. F. Korth, D. Kossmann, S. Madden, R. Magoulas, B. C. Ooi, T. OReilly, R. Ramakrishnan, S. Sarawagi, M. Stonebraker, A. S. Szalay, and G. Weikum, The claremont report on database research, ” ACM Communications, vol. 52, June 2009 2. Alexandros Labrinidis, H. V. Jagadish, Challenges and opportunities with big data, Journal Proceedings of the VLDB Endowment, Volume 5, Issue 12, August 2012, Pages 2032 -2033 3. D. Agrawal, P. Bernstein, E. Bertino, S. Davidson, U. Dayal, M. Franklin, J. Gehrke, L. Haas, A. Halevy, J. Han, H. V. Jagadish, A. Labrinidis, S. Madden, Y. Papakonstantinou, J. M. Patel, R. Ramakrishnan, K. Ross, C. Shahabi, D. Suciu, S. Vaithyanathan, and J. Widom, Challenges and opportunities with big data” February 2012 4. J. P. Shim et al. , Past, present, and future of decision support technology, Decision Support Systems, 931, 2002 5. Roozbeh Derakhshan, Maria E. Orlowska and Xue Li, RFID Data Management: Challenges and Opportunities, 2007 IEEE International Conference on RFID, Gaylord Texan Resort, rapevine, TX, USA, March 26 -28, 2007 6. Daniele Miorandi Sabrina Sicari, Francesco De Pellegrini, Imrich Chlamta, Internet of things: Vision, applications and research challenges, Survey Paper, Ad Hoc Networks 10, 2012, pp 1497– 1516
Βάση Δεδομένων (database) • A database is an organized collection of data It is the collection of schemes, tables, queries, queries reports, views and other objects. The data is views typically organized to model aspects of reality in a way that supports processes requiring processes information, such as modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. Wikipedia (CC) 11
the world sample database The world sample database https: //dev. mysql. com/doc/world-setup/en/world-setup-installation. html 13
Παράδειγμα (the example of Wordpress) W 3. org: Use Cases and Requirements for Mapping Relational Databases to RDF (http: //www. w 3. org/TR/rdb 2 rdf-ucr/) 14
Data Models Wikipedia (CC) 15
Relations (Ted Codd) Wikipedia (CC) 16
database dataddict. wordpress. com 17
Database Wikipedia (CC) 18
Client server Βλέπε dlsweb. rmit. edu. au (https: //www. dlsweb. rmit. edu. au/toolbox/Database/Certificate 4_DB_Tool box/content/dbsystems/DB_types. htm accessed at 15/10/2015) 19
Client-Server perspective (dbtech (CC)) 5
Client-Server perspective (dbtech (CC)) Client-initiated DB connection / SQL-session DB services used to pass SQL commands as parameters to API functions/methods An SQL command may involve >1 SQL statements SQL commands execute in atomic fashion at the DB server Logical level client-server dialogue, utilizing the SQL language synta DB server generated exceptions and diagnostics facilitate user transaction support at the application level 6
DB applications architecture: conceptual level (dbtech (CC)) 2
Cloud Computind Wikipedia (CC) 23
- Slides: 24