Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
skip to main content
10.1145/1807167.1807229acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
research-article

Ajax-based report pages as incrementally rendered views

Published: 06 June 2010 Publication History

Abstract

While Ajax-based programming enables faster performance and higher interface quality over pure server-side programming, it is demanding and error prone as each action that partially updates the page requires custom, ad-hoc code. The problem is exacerbated by distributed programming between the browser and server, where the developer uses JavaScript to access the page state and Java/SQL for the database. The FORWARD framework simplifies the development of Ajax pages by treating them as rendered views, where the developer declares a view using an extension of SQL and page units, which map to the view and render the data in the browser. Such a declarative approach leads to significantly less code, as the framework automatically solves performance optimization problems that the developer would otherwise hand-code. Since pages are fueled by views, FORWARD leverages years of database research on incremental view maintenance by creating optimization techniques appropriately extended for the needs of pages (nesting, variability, ordering), thereby achieving performance comparable to hand-coded JavaScript/Java applications.

References

[1]
S. Abiteboul, J. McHugh, M. Rys, V. Vassalos, and J. L. Wiener. Incremental maintenance for materialized views over semistructured data. In VLDB, pages 38--49, 1998.
[2]
D. Agrawal, A. E. Abbadi, A. K. Singh, and T. Yurek. Efficient view maintenance at data warehouses. In SIGMOD, pages 417--427, 1997.
[3]
M. A. Ali, A. A. A. Fernandes, and N. W. Paton. Movie: An incremental maintenance system for materialized object views. Data Knowl. Eng., 47(2):131--166, 2003.
[4]
Backbase enterprise ajax framework, 2009. http://www.backbase.com/products/enterprise-ajax/.
[5]
F. Bancilhon, S. Cluet, and C. Delobel. A query language for the o2 object-oriented database system. In DBPL, pages 122--138, 1989.
[6]
J. A. Blakeley, P.-Å. Larson, and F. W. Tompa. Efficiently updating materialized views. In SIGMOD, pages 61--71, 1986.
[7]
K. S. Candan, D. Agrawal, W.-S. Li, O. Po, and W.-P. Hsiung. View invalidation for dynamic content caching in multitiered architectures. In VLDB, pages 562--573, 2002.
[8]
S. Ceri, P. Fraternali, and A. Bongio. Web modeling language (webml): a modeling language for designing web sites. Computer Networks, 33(1-6):137--157, 2000.
[9]
L. S. Colby, T. Griffin, L. Libkin, I. S. Mumick, and H. Trickey. Algorithms for deferred view maintenance. In SIGMOD, pages 469--480, 1996.
[10]
K. Dimitrova, M. El-Sayed, and E. A. Rundensteiner. Order-sensitive view maintenance of materialized xquery views. In ER, pages 144--157, 2003.
[11]
Echo web framework, 2009. http://echo.nextapp.com/site/.
[12]
M. F. Fernández, D. Florescu, A. Y. Levy, and D. Suciu. Declarative specification of web sites with strudel. VLDB J., 9(1):38--55, 2000.
[13]
J. N. Foster, R. Konuru, J. Siméon, and L. Villard. An algebraic approach to view maintenance for xquery. In PLAN-X, 2008.
[14]
G. Fourny, M. Pilman, D. Florescu, D. Kossmann, T. Kraska, and D. McBeath. Xquery in the browser. In WWW, pages 1011--1020, 2009.
[15]
J. J. Garrett. Ajax: A new approach to web applications. http://adaptivepath.com/ideas/essays/archives/000385.php, February 2005. {Online; Stand 18.03.2008}.
[16]
Google widget toolkit, 2009. http://code.google.com/webtoolkit/.
[17]
T. Griffin and L. Libkin. Incremental maintenance of views with duplicates. In M. J. Carey and D. A. Schneider, editors, SIGMOD, pages 328--339. ACM Press, 1995.
[18]
A. Gupta and I. S. Mumick. Maintenance of materialized views: Problems, techniques, and applications. IEEE Data Eng. Bull., 18(2):3--18, 1995.
[19]
A. Gupta, I. S. Mumick, and V. S. Subrahmanian. Maintaining views incrementally. In P. Buneman and S. Jajodia, editors, SIGMOD, pages 157--166. ACM Press, 1993.
[20]
M. A. Habib and M. Abrams. Analysis of sources of latency in downloading web pages. In WebNet, pages 227--232, 2000.
[21]
Icefaces, 2009. http://www.icefaces.org/main/home/.
[22]
B. Johnson. Reveling in constraints. Queue, 7(6):30--37, 2009.
[23]
I. S. Mumick, D. Quass, and B. S. Mumick. Maintenance of data cubes and summary tables in a warehouse. In SIGMOD, pages 100--111, 1997.
[24]
C. W. of America. 2009 report on internet speeds in all 50 states, 2009. http://cwafiles.org/speedmatters/state_reports_2009/CWA_Report_on_Internet_Speeds_2009.pdf.
[25]
C. O'Hanlon. A conversation with werner vogels. Queue, 4(4):14--22, 2006.
[26]
K. A. Ross, D. Srivastava, and S. Sudarshan. Materialized view maintenance and integrity constraint checking: Trading space for time. In SIGMOD, pages 447--458, 1996.
[27]
K. Salem, K. S. Beyer, R. Cochrane, and B. G. Lindsay. How to roll a join: Asynchronous incremental view maintenance. In SIGMOD, pages 129--140, 2000.
[28]
A. Sawires, J. Tatemura, O. Po, D. Agrawal, and K. S. Candan. Incremental maintenance of path expression views. In SIGMOD, pages 443--454, 2005.
[29]
L. Simon. Minimizing browser reflow. http://code.google.com/speed/articles/reflow.html, June 2009.
[30]
The dojo toolkit, 2009. http://www.dojotoolkit.org/.
[31]
Wikipedia. Asp.net, 2009. Accessed Nov 04 2009. http://en.wikipedia.org/w/index.php?title=ASP.NET&oldid=323456166.
[32]
F. Yang, N. Gupta, N. Gerner, X. Qi, A. J. Demers, J. Gehrke, and J. Shanmugasundaram. A unified platform for data driven web applications with automatic client-server partitioning. In WWW, pages 341--350, 2007.
[33]
F. Yang, J. Shanmugasundaram, M. Riedewald, and J. Gehrke. Hilda: A high-level language for data-driven web applications. In ICDE, page 32, 2006.
[34]
K. Yi, H. Yu, J. Yang, G. Xia, and Y. Chen. Efficient maintenance of materialized top-k views. In ICDE, pages 189--200, 2003.
[35]
Yui library, 2009. http://developer.yahoo.com/yui/.
[36]
Y. Zhuge and H. Garcia-Molina. Graph structured views and their incremental maintenance. In ICDE, pages 116--125, 1998.
[37]
Y. Zhuge, H. Garcia-Molina, J. Hammer, and J. Widom. View maintenance in a warehousing environment. In SIGMOD, pages 316--327, 1995.
[38]
Zk direct ria, 2009. http://www.zkoss.org/.

Cited By

View all
  • (2019)Impact of technology evolution on the materialised viewsInternational Journal of Business Information Systems10.1504/ijbis.2019.09930530:4(427-462)Online publication date: 16-Apr-2019
  • (2018)ViDeTTe Interactive NotebooksProceedings of the Workshop on Human-In-the-Loop Data Analytics10.1145/3209900.3209907(1-7)Online publication date: 10-Jun-2018
  • (2017)Object-Relational event (ORE) middleware for push-based content delivery from the application tier2017 8th IEEE International Conference on Software Engineering and Service Science (ICSESS)10.1109/ICSESS.2017.8342950(439-442)Online publication date: Nov-2017
  • Show More Cited By

Index Terms

  1. Ajax-based report pages as incrementally rendered views

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    SIGMOD '10: Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
    June 2010
    1286 pages
    ISBN:9781450300322
    DOI:10.1145/1807167
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Sponsors

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 06 June 2010

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. ajax
    2. sql
    3. view maintenance

    Qualifiers

    • Research-article

    Conference

    SIGMOD/PODS '10
    Sponsor:
    SIGMOD/PODS '10: International Conference on Management of Data
    June 6 - 10, 2010
    Indiana, Indianapolis, USA

    Acceptance Rates

    Overall Acceptance Rate 785 of 4,003 submissions, 20%

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)2
    • Downloads (Last 6 weeks)0
    Reflects downloads up to 02 Sep 2024

    Other Metrics

    Citations

    Cited By

    View all
    • (2019)Impact of technology evolution on the materialised viewsInternational Journal of Business Information Systems10.1504/ijbis.2019.09930530:4(427-462)Online publication date: 16-Apr-2019
    • (2018)ViDeTTe Interactive NotebooksProceedings of the Workshop on Human-In-the-Loop Data Analytics10.1145/3209900.3209907(1-7)Online publication date: 10-Jun-2018
    • (2017)Object-Relational event (ORE) middleware for push-based content delivery from the application tier2017 8th IEEE International Conference on Software Engineering and Service Science (ICSESS)10.1109/ICSESS.2017.8342950(439-442)Online publication date: Nov-2017
    • (2014)ForwardProceedings of the VLDB Endowment10.14778/2733004.27330527:13(1649-1652)Online publication date: 1-Aug-2014
    • (2012)Declarative web application developmentProceedings of the 2012 ACM SIGMOD International Conference on Management of Data10.1145/2213836.2213969(863-863)Online publication date: 20-May-2012
    • (2011)Object-relational event middleware for web applicationsProceedings of the 2011 Conference of the Center for Advanced Studies on Collaborative Research10.5555/2093889.2093914(215-228)Online publication date: 7-Nov-2011

    View Options

    Get Access

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Media

    Figures

    Other

    Tables

    Share

    Share

    Share this Publication link

    Share on social media