A call to arms: Revisiting database design

SIGMOD Record

Volumn 40, Issue 3, 2011, Pages 61-69

  Badia, Antonio ^a   Lemire, Daniel ^b  

^a UNIVERSITY OF LOUISVILLE   (United States)

^b UNIVERSITÉ DU QUÉBEC À MONTRÉAL   (Canada)

Author keywords

[No Author keywords available]

Indexed keywords

APPLICATION SYSTEMS; DATA INTEGRATION; DATABASE DESIGN; DATABASE QUERIES; END USERS; FUNCTIONAL DEPENDENCY; INTEROPERATIONS; LOGICAL DESIGN; NORMAL FORM; PHYSICAL DESIGN;

LOGIC DESIGN;

DATABASE SYSTEMS;

EID: 84858423063     PISSN: 01635808     EISSN: None     Source Type: Journal    
DOI: 10.1145/2070736.2070750     Document Type: Article

References (63)

1. S. Abiteboul et al. The Lowell database research self-assessment. Communications of the ACM, 48:111-118, May 2005. (Pubitemid 40672592)
2. R. Agrawal et al. The Claremont report on database research. SIGMOD Record, 37:9-19, September 2008
3. S. Agrawal, S. Chaudhuri, L. Kollar, A. Marathe, V. Narasayya, and M. Syamala. Database tuning advisor for Microsoft SQL Server 2005: demo. In Proceedings of the 2005 ACM SIGMOD international conference on Management of data, SIGMOD '05, pages 930-932, New York, NY, USA, 2005. ACM. (Pubitemid 43039013)
4. P. Andritsos, R. J. Miller, and P. Tsaparas. Information-theoretic tools for mining database structure from large data sets. In Proceedings of the 2004 ACM SIGMOD international conference on Management of data, SIGMOD '04, pages 731-742, New York, NY, USA, 2004. ACM.
5. D. E. Avison and G. Fitzgerald. Where now for development methodologies? Communications of the ACM, 46:78-82, January 2003.
6. D. Barbosa, J. Freire, and A. O. Mendelzon. Designing information-preserving mapping schemes for XML. In Proceedings of the 31st international conference on Very large data bases, VLDB '05, pages 109-120. VLDB Endowment, 2005. (Pubitemid 43990997)
7. T. Berners-Lee. Linked data. International Journal on Semantic Web and Information Systems, 4(2), 2006.
8. P. Bernstein et al. The Asilomar report on database research. SIGMOD Record, 27:74-80, December 1998.
9. K. Beyer, F. özcan, S. Saiprasad, and B. Van der Linden. DB2/XML: designing for evolution. In Proceedings of the 2005 ACM SIGMOD international conference on Management of data, SIGMOD '05, pages 948-952, New York, NY, USA, 2005. ACM. (Pubitemid 43039019)
10. T. Bray. Don't Invent XML Languages. http://bit.ly/364VEy [last checked on 10/07/2011], 2006.
11. M. L. Brodie and J. T. Liu. The power and limits of relational technology in the age of information ecosystems. Keynote at On The Move Federated Conferences, 2010.
12. R. Cattell. Scalable SQL and NoSQL data stores. Sigmod Record, 39(2):12-27, 2010.
13. S. Chauduri and V. Nrasayya. Self-tuning database systems: A decade of progress. In Proceedings of VLDB. VLDB Endowment, September 2007.
14. H. Chen, H. Liao, and Z. Gao. Functional dependencies for XML. In Proceedings of the 2010 international conference on Web-age information management, WAIM'10, pages 110-115, Berlin, Heidelberg, 2010. Springer-Verlag.
15. P. Chen. The entity-relationship model - toward a unified view of data. ACM Transactions on Database Systems, 1(1):9-36, 1976.
16. P. Chen. Suggested research directions for a new frontier: Active conceptual modeling. In D. Embley, A. Olivé, and S. Ram, editors, Conceptual Modeling - ER 2006, volume 4215 of Lecture Notes in Computer Science, pages 1-4. Springer Berlin / Heidelberg, 2006. (Pubitemid 44850558)
17. E. F. Codd. A relational model of data for large shared data banks. Commun. ACM, 13:377-387, June 1970.
18. J. Cohen, B. Dolan, M. Dunlap, J. M. Hellerstein, and C. Welton. MAD skills: new analysis practices for big data. Proc. VLDB Endow., 2:1481-1492, August 2009.
19. N. Dalvi, C. Ré, and D. Suciu. Probabilistic databases: diamonds in the dirt. Commun. ACM, 52:86-94, July 2009.
20. A. Doan, P. Domingos, and A. Y. Halevy. Learning to match the schemas of data sources: A multistrategy approach. Machine Learning, 50(3), 2003.
21. R. Elmasri and S. Navathe. Fundamentals of Database Systems. Addison Wesley, 6th edition, 2010.
22. W. Fan, F. Geerts, J. Li, and M. Xiong. Discovering conditional functional dependencies. IEEE Transactions on Knowledge and Data Engineering, 23:683-698, 2011.
23. G. Fitzgerald, A. Philippides, and S. Probert. Information systems development, maintenance and enhancement: findings from a UK study. International Journal of Information Management, 19(4):319-328, 1999. (Pubitemid 129589699)
24. K. E. Gebaly and A. Aboulnaga. Robustness in automatic physical database design. In Proceedings of the 11th international conference on Extending database technology: Advances in database technology, EDBT '08, pages 145-156, New York, NY, USA, 2008. ACM. (Pubitemid 351661698)
25. S. Gilbert and N. Lynch. Brewer's conjecture and the feasibility of consistent, available, partition-tolerant web services. ACM SIGACT News, 33(2):59, 2002.
26. L. Golab, H. J. Karloff, F. Korn, and D. Srivastava. Data auditor: Exploring data quality and semantics using pattern tableaux. PVLDB, 3(2):1641-1644, 2010.
27. A. Halevy, M. Franklin, and D. Maier. Principles of dataspace systems. In Proceedings of the twenty-fifth ACM SIGMOD-SIGACTSIGART symposium on Principles of database systems, PODS '06, pages 1-9, New York, NY, USA, 2006. ACM. (Pubitemid 46946461)
28. A. Halevy, P. Norvig, and F. Pereira. The unreasonable effectiveness of data. IEEE Intelligent Systems, 24:8-12, 2009.
29. T. Halpin. Conceptual Schema and Relational Database Design. Prentice Hall, 1989.
30. P. Helland. Normalization is for sissies. In Conference on Innovative Database Systems Research (CIDR), 2009.
31. J. Iivari, H. Isomäki, and S. Pekkola. The user, the great unknown of systems development: reasons, forms, challenges, experiences and intellectual contributions of user involvement. Information Systems Journal, 20(2):109-117, 2010.
32. I. F. Ilyas, V. Markl, P. Haas, P. Brown, and A. Aboulnaga. Cords: automatic discovery of correlations and soft functional dependencies. In Proceedings of the 2004 ACM SIGMOD international conference on Management of data, SIGMOD '04, pages 647-658, New York, NY, USA, 2004. ACM.
33. J. Impagliazzo. Computing curricula 2005. ACM SIGCSE Bulletin, 38(3):311-311, 2006.
34. M. Jarke, C. Quix, D. Calvanese, M. Lenzerini, E. Franconi, S. Ligoudistianos, P. Vassiliadis, and Y. Vassiliou. Concept based design of data warehouses: the DWQ demonstrators. In Proceedings of the 2000 ACM SIGMOD international conference on Management of data, SIGMOD '00, pages 591-, New York, NY, USA, 2000. ACM.
35. C. Jones. Intelligence reform: The logic of information sharing. Intelligence & National Security, 22(3):384-401, 2007.
36. J. Kang and J. Naughton. Schema matching using interattribute dependencies. IEEE Transactions on Knowledge and Data Engineering, 20(10), October 2008.
37. G. Kiely and B. Fitzgerald. An investigation of the use of methods within information systems development projects. The Electronic Journal of Information Systems in Developing Countries, 22, 2005.
38. S. Kolahi and L. Libkin. An informationtheoretic analysis of worst-case redundancy in database design. ACM Transactions on Database Systems, 35:5:1-5:32, February 2008.
39. H. Kwak, C. Lee, H. Park, and S. Moon. What is Twitter, a social network or a news media? In Proceedings of the 19th international conference on World wide web, WWW '10, pages 591-600, New York, NY, USA, 2010. ACM.
40. N. Leavitt. Will NoSQL databases live up to their promise? Computer, 43(2):12-14, 2010.
41. Q. Luo and H.Wu. System design issues in sensor databases. In Proceedings of the 2007 ACM SIGMOD international conference on Management of data, SIGMOD '07, pages 1182-1185, New York, NY, USA, 2007. ACM. (Pubitemid 47630921)
42. S. Madden, M. J. Franklin, J. M. Hellerstein, and W. Hong. The design of an acquisitional query processor for sensor networks. In Proceedings of the 2003 ACM SIGMOD international conference on Management of data, SIGMOD '03, pages 491-502, New York, NY, USA, 2003. ACM.
43. M. Magnani and D. Montesi. A survey on uncertainty management in data integration. J. Data and Information Quality, 2:5:1-5:33, July 2010.
44. E. Meijer, B. Beckman, and G. Bierman. LINQ: reconciling object, relations and XML in the .NET framework. In Proceedings of the 2006 ACM SIGMOD international conference on Management of data, SIGMOD '06, pages 706-706, New York, NY, USA, 2006. ACM.
45. R. Meredith and P. O'Donnell. A functional model of social media and its application to business intelligence. In Proceeding of the 2010 conference on Bridging the Socio-technical Gap in Decision Support Systems: Challenges for the Next Decade, pages 129-140, Amsterdam, The Netherlands, The Netherlands, 2010. IOS Press.
46. F. Millerand and K. Baker. Who are the users? Who are the developers? Webs of users and developers in the development process of a technical standard. Information Systems Journal, 20(2):137-161, 2010.
47. C. Monash. Details of the JPMorgan Chase Oracle database outage. http://bit.ly/ckWLfq [last checked on 10/07/2011], 2010.
48. S. Nagarajan. Guest editor introduction. Data Storage Evolution, Special Issue of Computing Now, March 2011. IEEE Press.
49. A. Olivè. Conceptual Modeling of Information Systems. Springer, 2007.
50. J. Parsons, M. Saeki, P. Shoval, C. C.Woo, and Y. Wand, editors. Conceptual Modeling - ER 2010, 29th International Conference on Conceptual Modeling, Lecture Notes in Computer Science 6412, Vancouver, BC, Canada, November 2010. Springer.
51. R. Ramakrishnan and J. Gehrke. Database Management Systems. McGraw-Hill, 3rd edition, 2002.
52. J. F. Roddick, A. Ceglar, D. De Vries, and S. La-Ongsri. Active conceptual modeling of learning. In P. Chen and L. Y. Wong, editors, Postponing schema definition: low instance-toentity ratio (LItER) modelling, pages 206-216, Berlin, Heidelberg, 2007. Springer-Verlag.
53. E. Sciore, M. Siegel, and A. Rosenthal. Using semantic values to falilitate interoperability among heterogeneous information systems. ACM Trans. Database Syst., 19(2):254-290, 1994.
54. P. Shvaiko and J. Euzenat. A survey of schemabased matching approaches. Tech report dit- 04-087, University of Trento, 2005. Also: Journal of Data Semantics, LNCS 3730, pp. 146- 171, 2005.
55. S. Siersdorfer and S. Sizov. Social recommender systems for web 2.0 folksonomies. In Proceedings of the 20th ACM conference on Hypertext and hypermedia, HT '09, pages 261-270, New York, NY, USA, 2009. ACM.
56. A. Silberschatz, H. Korth, and S. Sudarshan. Database System Concepts. McGraw-Hill, 6th edition, 2010.
57. Y. L. Simmhan, B. Plale, and D. Gannon. A survey of data provenance in e-science. SIGMOD Record, 34:31-36, September 2005. (Pubitemid 43152529)
58. E. Stolte, C. von Praun, G. Alonso, and T. Gross. Scientific data repositories: designing for a moving target. In Proceedings of the 2003 ACM SIGMOD international conference on Management of data, SIGMOD '03, pages 349-360, New York, NY, USA, 2003. ACM.
59. M. Stonebraker and R. Cattell. 10 rules for scalable performance in 'simple operations' datastores. Communications of the ACM, 54(6):72-80, 2011.
60. T. J. Teorey, S. S. Lightstone, T. Nadeau, and H. V. Jagadish. Database Modeling and Design, Fifth Edition: Logical Design. Morgan Kaufmann, 5th edition, 2011.
61. B. Thalheim. Fundamentals of Entity- Relationship Modeling. Springer-Verlag, 2000.
62. D. Tunkelang. Design for interaction. In Proceedings of the 35th SIGMOD international conference on Management of data, SIGMOD '09, pages 969-970, New York, NY, USA, 2009. ACM.
63. O. Udrea, L. Getoor, and R. J. Miller. Leveraging data and structure in ontology integration. In Proceedings of SIGMOD, pages 449- 460, 2007. (Pubitemid 47630828)