Opensource databases such as MySQL and PostgreSQL supports non standard SELECT extension for limiting number of returned rows from query. You can see description in PostgreSQL manual. Look for keywords LIMIT and OFFSET. LIMIT specifies the maximum number of rows to return, while OFFSET specifies the number of rows to skip before starting to return…Continue
Once you get past the simple case of copying changed data from one system to another, the next most common replication solution is data distribution. In this scenario, you distribute data from a central database to two or more databases, maybe even 100's, that are likely remote. An example is sending changes from a corporate headquarters to branch offices or retail locations. You may only need the data to flow one way - from a central database to others. Or, you may also need some data to…Continue
Added by david t on February 15, 2010 at 4:00pm — No Comments
You may have heard about several different capabilites available with pureQuery such as Client Optimization, Annotated Method and In-Line. Some questions that I have had about these options would include what is the difference between these methods and where do I use each? I wanted to just quickly write a few paragraphs to answer these two primary questions.
In answer to the first question, both Annotated Method and In-Line are part of the pureQuery API. Annotated Method uses…Continue
I often get asked if it's easy to set up IBM cache tables and whether they can be set up with scripts instead of a GUI The answer I give is yes to both questions. Cache tables, a form of distributed caching, are very easy to set up and you can do it with scripts. The challenges are that (1) IBM's documentation could be better and (2) a good sample is needed. I'm hoping a few pictures, a little text, and a small sample are all that's needed to improve the situation…Continue
Added by david t on February 5, 2010 at 9:00pm — No Comments
Added by Lohith on February 3, 2010 at 5:52am — No Comments