Answer / 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.

Answer / amar&venky

1)Memory or disk caching can be used directly to avoid running duplicate queries. A complex data report, for example, can have its result sets serialized to disk for reuse in multiple page templates. Caching has its own overhead, such as the expense of reading and parsing data on disk, so simple and inexpensive queries are most often best left for the database to process.
2)ORM modules can be built to retain objects in memory. For the first request, the data object is loaded into memory. Any updates or further requests can be managed in memory, with data written back to the database immediately or later, such as during system shutdown. In this way the ORM is effectively a buffer between the web application logic and the database server.
3)Caching partial page content can help avoid rerunning queries when that content is required multiple times.

Why do we use stringbuilder in c#?

0 Answers  

---

How big is int16?

0 Answers  

---

What is the .NET collection class that allows an element to be accessed using a unique key?

0 Answers   Siebel,

---

What are methods in C#?

0 Answers   Winsol Solutions,

---

Define assert() method? How does it work?

0 Answers   Siebel,

---

Why we use delegates in c#?

0 Answers  

---

Explain the different ways a method can be overloaded?

0 Answers  

---

What are the principles of delegation?

0 Answers  

---

directcast(123.34,integer) - should it throw an error? Why or why not?

2 Answers   Wipro,

---

What is the Signification of the "new " keyword in C#? example

0 Answers   Wipro,

---

What are the advantages of constructor?

0 Answers  

---

Where’s global assembly cache located on the system?

0 Answers  

---