Interested to Buy Any Domain ? << Click Here >> for more details...
How cache is implemented in web application for DB queries?
- 2 Answers
- 5040 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / bhanu, patna(bihar)
Many e-Business applications today are being developed and
deployed on multi-tier environments involving browser-based
clients, web application servers and backend databases. The
dynamic nature of these applications necessitates
generating web pages on-demand, making middle-tier database
caching an effective approach to achieve high scalability
and performance [3]. In the DBCache project, we are
incorporating a database cache feature in DB2 UDB by
modifying the engine code and leveraging existing federated
database functionality. This allows us to take advantage of
DB2's sophisticated distributed query processing power for
database caching. As a result, the user queries can be
executed at either the local database cache or the remote
backend server, or more importantly, the query can be
partitioned and then distributed to both databases for cost
optimum execution.DBCache also includes a cache
initialization component that takes a backend database
schema and SQL queries in the workload, and generates a
middle-tier database schema for the cache. We have
implemented an initial prototype of the system that
supports table level caching. As DB2's functionality is
extended, we will be able to support subtable level
caching, XML data caching and caching of execution results
of web services.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a static in c#?
What .exe means?
What's the difference between a method and a procedure?
What is the use of generics in c#?
What is exe in c#?
Distinguish between system.string and system.text.stringbuilder classes?
Why do we need to serialize data?
What is the real use of interface in c#?
If the interface in c# only contains the declaration of the methods and we need to define those methods in the class, then why we use the interface?
Can we inherit a private class in c#?
What is data type c#?
Define c# i/o classes? List the commonly used classes?
Can scriptable objects have methods?
What is a static field?
What is var c#?
