DOCTOR ICT

Your Shopping Cart




Your Cart is currently empty.

   

You are here: Home Contact Us Blog
Decrease font size  Default font size  Increase font size 
PDF Print E-mail
Written by Saeed Shadlou   
Friday, 20 January 2012 00:00

The DB2  Database  Optimizer

Query Rewrite: Predicate Pushdown Example

Original query:

  • CREATE VIEW lineitem_group(suppkey, partkey, total)
  • AS SELECT l_suppkey, l_partkey, sum(quantity)
  • FROM tpcd.lineitem
  • GROUP BY l_suppkey, l_partkey;
  • SELECT *
  • FROM lineitem_group
  • –WHERE suppkey = 1234567;

 Rewritten query:

  • CREATE VIEW lineitem_group(suppkey, partkey, total)
  • AS SELECT l_suppkey, l_partkey, sum(quantity)
  • FROM tpcd.lineitem
  • WHERE l_suppkey = 1234567
  • GROUP BY l_suppkey, l_partkey;
  • SELECT *
  • FROM lineitem_group;

Query Rewrite: Subquery-to-Join Example

Original Query:
  • SELECT ps.*
  • FROM tpcd.partsupp ps
  • WHERE ps.ps_partkey IN
  • (SELECT p_partkey
  • FROM tpcd.parts
  • WHERE p_name LIKE 'forest%');
Rewritten Query:
  • SELECT ps.*
  • FROM parts, partsupp ps
  • WHERE ps.ps_partkey = p_partkey AND
  • p_name LIKE `forest%';
  • NOTE: Unlike Oracle, DB2 can do this transform,
  • even if p_partkey is NOT a key!

Query Rewrite - Shared Aggregation Example

Original Query:

  • SELECT SUM(O_TOTAL_PRICE) AS OSUM,
  • AVG(O_TOTAL_PRICE) AS OAVG
  • FROM ORDERS; 
  • Rewritten Query:
  • SELECT OSUM, OSUM/OCOUNT AS OAVG
  • FROM (SELECT SUM(O_TOTAL_PRICE) AS OSUM,
  • COUNT(O_TOTAL_PRICE) AS OCOUNT
  • FROM ORDERS) AS SHARED_AGG;

Reduces query from 2 sums and 1 count to 1 sum and 1 count!


Query Rewrite - Correlated Subqueries Example

Original Query:

  • SELECT PS_SUPPLYCOST FROM PARTSUPP
  • WHERE PS_PARTKEY <> ALL
  • (SELECT L_PARTKEY FROM LINEITEM
  • WHERE PS_SUPPKEY = L_SUPPKEY)

  Rewritten Query:

  • SELECT PS_SUPPLYCOST FROM PARTSUPP
  • WHERE NOT EXISTS
  • (SELECT 1 FROM LINEITEM
  • WHERE PS_SUPPKEY = L_SUPPKEY
  • AND PS_PARTKEY = L_PARTKEY)
Last Updated on Friday, 24 February 2012 22:07
 
PDF Print E-mail
Written by Dr Saeed Shadlou   
Sunday, 11 March 2012 00:00

 

Top jQuery Table Plugins

 

jQuery let you to create stylus and flexible tables with its magnificent Plugins. In this post you will get a peek a boo of 20 jQuery Table Plugins that are among the best of the lot. These plugins help you to create superb tables which are easy to code for you and easy to understand for your readers. Thus both the sides are equally happy. Lets have a look on these jQuery Table Plugins.

Collapser

Jquery collapser is a multi purpose collapser plugin made for expanding and collapsing elements. Can create a accordion, list collapser using this plugin.

Collapser

More Information On Collapser

jExpand

jExpand is ultra lightweight jQuery plugin that will make your tables expandable. Typical for line of business applications, this feature can help you organize tables better. This way, tables can hold more information such as images, lists, diagrams and other elements.

jExpand

More Information On jExpand

Fixed Header Tables

Fixed Header Tables takes valid table HTML and builds a fixed header as done in Microsoft excel and a scrolling body with optional footer.

Fixed Header Tables

More Information On Fixed Header Tables

treeTable

The treeTable plugin allows you to display a tree in a table, i.e. a directory structure or a nested list. Each branch in this tree can be collapsed and expanded, just like in a file explorer in most modern operating systems.

treeTable

More Information On treeTable

Flexigrid

Lightweight but rich data grid with resizable columns and a scrolling data to match the headers, plus an ability to connect to an xml based data source using Ajax to load the content.

Flexigrid

More Information On Flexigrid

Table Drag and Drop

This TableDnD plugin allows the user to reorder rows within a table, for example if they represent an ordered list. Individual rows can be marked as non-draggable and/or non-droppable. Rows can have as many cells as necessary and the cells can contain form elements.

Table Drag and Drop

More Information On Table Drag and Drop

BI Grid

BI Grid is designed to present your data, especially in the reports for enterprises. It would be able to edit data easily, drill down to details easily and ajax enabled.

BI Grid

More Information On BI Grid

jQuery charToTable plugin

With this plugin you can convert characters to tables using jQuery.

jQuery charToTable plugin

More Information On jQuery charToTable plugin

Alternate Plugin

Assign alternating class names to selected elements to allow CSS assignment of colors or other styles of your choice. Excellent plugin for alternating row colors in tables! As a bonus, it will assign a “hover” class to elements if you set hover:true

Alternate Plugin

More Information On Alternate Plugin

Add Table Rows Count

This plugin automatically adds a column with row count. Thus making your tables more readable and keeping your markup/metadata clean.

Add Table Rows Count

More Information On Add Table Rows Count

Chromatable JQuery Plugin

jQuery plugin that creates either a resizable table or a scrollable table with a fixed position header, (the header will stay put while you scroll down the table content). It allows the user to define the table dimensions as a fixed pixel amount, auto, or 100%.

Chromatable JQuery Plugin

More Information On Chromatable JQuery Plugin

Animated table sort

This plugin allows you to animatedly sort a table based on a column’s td’s, or on the content/value of a child/descendant element within those td’s. The various td’s fly to their new homes, giving a nice effect. It also supports sorting on REGEXP matches.

Animated table sort

More Information On Animated table sort

ColdFusion Query to Table

Create a dynamic Table from a ColdFusion Query Json. Or a JavaScript Array

ColdFusion Query to Table

More Information On ColdFusion Query to Table

Table Pagination

This jquery plugin is used to create a pagination element under a table element. You can customize your pagination needs through various settings.

Table Pagination

More Information On Table Pagination

DataTables

DataTables is a plug-in for the jQuery Javascript library. It is a highly flexible tool, based upon the foundations of progressive enhancement, which will add advanced interaction controls to any HTML table.

DataTables

More Information On DataTables

Tablesorter

tablesorter is a jQuery plugin for turning a standard HTML table with THEAD and TBODY tags into a sortable table without page refreshes. tablesorter can successfully parse and sort many types of data including linked data in a cell.

Tablesorter

More Information On Tablesorter

uiTableFilter

uiTableFilter is a jquery plugin for filtering table rows.

uiTableFilter

More Information On uiTableFilter

columnManager

A jQuery-plugin to toggle the visibility of table columns (collapsing and expanding them) and to save the state until the next visit. It’s supporting tables with colspans and rowspans, too

columnManager

More Information On columnManager

Ingrid

Ingrid is an unobtrusive jQuery component that adds datagrid behaviors (column resizing, paging, sorting, row and column styling, and more) to your tables.

Ingrid

More Information On Ingrid

columnHover

A jQuery-plugin that highlights whole columns in a table when hovering over them. It’s supporting tables with colspans and rowspans, too.

columnHover

More Information On columnHover


Last Updated on Sunday, 11 March 2012 20:58
 
Doctor ICT Website Design PDF Print E-mail
Doctor ICT Website Design
Web Site Development

Doctor ICT is a company that can manage all of your web page development needs! We offer services in web page development and design, web page hosting, Domain Name Registration. It is our privilege to provide a service that is reliable and can take the worries of web page development off your shoulders.

Custom Web Design

The requirements for each website are unique, and many require a custom design in either the technical area or graphic nature of the site; we are well equipped to complete the task quickly and efficiently. Allow us with our years of experience developing standard and custom websites to serve your needs

 

Graphic Design

Whether you need a face lift for your website, or a new company brochure, we can make your company shine. Our professional designers will make your company stand out from your competition.

Programming

Our team of software engineers has extensive experience developing complex web applications. Whether you want a simple web form or a sophisticated CRM system, our team is ready. We use all of the latest programming languages and technologies on Windows environments.

Maintenance

Every website needs constant attention, yet not every company has the resources or the expertise to maintain their sites changes. We can handle all of your site maintenance needs.

Web Hosting

Doctorict has always been at the forefront of best value Australian web hosting, but we want to do even better. We have upgraded all of our web hosting plans to include all the latest features at great prices, with instant setup, easy to use control panel and excellent support.

 
<< Start < Prev 1 2 Next > End >>

Page 1 of 2

Who's Online

We have 98 guests online

VirtueMart Search