Web-enabling Cache Daemon for Complex Data

Voras, Ivan; ┼Żagar, Mario
December 2008
Journal of Computing & Information Technology;Dec2008, Vol. 16 Issue 4, p317
Academic Journal
One of the most common basic techniques for improving the performance of web applications is caching frequently accessed data in fast data stores, colloquially known as cache daemons. In this paper we present a cache daemon suitable for storing complex data while maintaining fine-grained control over data storage, retrieval and expiry. Data manipulation in this cache daemon is performed via standard SQL statements so we call it SQLcached. It is a practical, usable solution already implemented in several large web sites.


Related Articles

  • Two Common Mistakes to Avoid When Handling Large Amounts of SQL Server Memory. Moran, Bdan // SQL Server Magazine;Mar2005, Vol. 7 Issue 3, p11 

    The article presents information on two common mistakes that users can avoid when handling large amounts of SQL server memory. One shouldn't assume that Address Windowing Extensions (AWE) is working in SQL Server unless they verify that it's enabled and using the amount of memory they expect....

  • Tempdb Affects Query Performance During Autogrow.  // SQL Server Magazine;Mar2005, Vol. 7 Issue 3, p11 

    The article discusses the tempdb's effect on query performance. People neglect to manually set tempdb to an adequate size, so tempdb autogrows to whatever size it needs as the application runs. Unfortunately, the default size for tempdb is 8MB and it shrinks to this size when one restarts the...

  • MAXIMIZE STORAGE PERFORMANCE. Campbell, Michael K. // SQL Server Magazine;Apr2009, Vol. 11 Issue 4, p35 

    The article discusses the ways on how to maximize storage performance without increase in cost. It notes that some types of storage and hardware are considered as better choices for SQL Server use. It points out that premium disk capabilities vary. Harnessing and utilizing controllers and disks...

  • Context Ontology Construction For Cricket Video. Abburu, Sunitha // International Journal on Computer Science & Engineering;2010, p2593 

    Content based video retrieval systems are not complete in semantic sense. To improve the efficiency and the effectiveness of the retrieval system the content based retrieval systems must be equipped with the semantic based retrieval. In view of end users retrieval demands, content based or...

  • Need to Find an Object But You Don't Know Its Exact Name? Try this Search Engine. Khaldtiance, Shaunt // SQL Server Magazine;May2009, Vol. 11 Issue 5, p10 

    The article offers advice on how to efficiently specifying an object in a database. It provides details on the use of sp ObjectSearch, a search engine that helps a user find the object he does not know the exact name. It also offers information on the functionality of sp ObjectSearch and its...

  • Making Sense of the Editions. Otey, Michael // SQL Server Magazine;Sep2006, Vol. 8 Issue 9, p3 

    The author focuses on the different editions of Structured Query Language (SQL) Server 2005, and describes its capabilities. The SQL Server 2005 consists of the Enterprise Edition, Standard Edition, Workgroup Edition, Express Edition, and Express Edition with Advanced Services. With the 2005...

  • Avoid Referential Integrity Errors When Deleting Records from Databases: Let this script or stored procedure do the work for you. Pathivada, Chandra Sekhar // SQL Server Magazine;Jun2009, Vol. 11 Issue 6, p15 

    The author discusses the approach he developed and used in deleting records from databases without having any referential integrity errors. He explains his PR_HIERARCHIAL_DATA approach for deleting of records in the database without disabling the foreign keys by determining the hierarchical...

  • Migrate FileMaker Databases to Your SQL Server.  // SQL Server Magazine;Dec2004, Vol. 6 Issue 12, p7 

    The article informs that .com Solutions announced FmPro Migrator 2.24 Enterprise Edition for MacOS X and Windows, a graphical application that documents and migrates FileMaker Pro databases and stand alone solution files to eight different database servers, including SQL Server, Microsoft...

  • Delivering Analysis Services Data with Reporting Services. Utley, Craig // SQL Server Magazine;Jul2006, Vol. 8 Issue 7, p35 

    The article features the SQL Server 2000 Reporting Services computer program language. The program addresses the problem of some companies having difficulty in accessing Analysis Service 2005. This has been taken account by the Reporting Services considering the capacity of Analysis Services to...


Read the Article


Sorry, but this item is not currently available from your library.

Try another library?
Sign out of this library

Other Topics