Forum

Kognitio Console issues, advice, etc.
Contributor
Offline
Posts: 184
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Kognitio Console future features

by MikeAtkinson » Fri Nov 15, 2013 11:04 am

Kognitio Console is under constant development. The features in this presentation are being considered for future versions.

We are particularly interested in feedback on the features.
  • Have we missed any feature you would like to see in Console?
  • What order would you like to see these features implemented in?
  • Do you have particular problems or use cases that need a solution?
console_future.zip
Features being considered for future Console versions
(3.21 MiB) Downloaded 714 times
Reply with quote Top
Single Poster
Offline
User avatar
Posts: 1
Joined: Wed Nov 20, 2013 5:19 pm

Re: Kognitio Console future features

by dzy82f » Wed Nov 20, 2013 5:22 pm

Any plans for a SQL Builder?

All the best

Julian (Macnamara)
Reply with quote Top
Contributor
Offline
Posts: 184
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Re: Kognitio Console future features

by MikeAtkinson » Thu Nov 21, 2013 12:52 pm

Julian,

What do you have in mind as a "SQL Builder"? Do you have a particular program that does SQL query building that you find particularly good?

We have no immediate plans to add a SQL Query Builder to Kognitio Console. A useful prerequisite will be the planned work to add an SQL parser to Console, as ideally the SQL builder would both start from scratch and also take an existing SQL query and modify it.

Do you want a purely text based SQL builder, or do you want a SQL builder that also visualises the query (e.g. tables/views as per the entity diagrams, with the used columns selected and connected by lines indicating the join relationship, etc. Subqueries shown as a separate diagram or as a diagram within the parent diagram)

Do you want a builder mainly for relatively simple queries or more complex ones?


A simple query might consist of selecting columns from a join on simple column relationships:

Code: Select all

select 
    name 
from 
    mike.countries,
    mike.cities
where 
    mike.countries.country_code=mike.cities.country_code and
    mike.cities.capital=1;
More complex queries might involve complex expressions of columns, subqueries, etc. A short example might be:

Code: Select all

select
   cast(to_char(st.usedgb+st.freegb,'999,990.9') as varchar(9)) as "Disk GB",
   cast(to_char(st.usedgb,'999,990.9') as varchar(9)) as "Used GB",
   cast(to_char(st.freegb,'999,990.9') as varchar(9)) as "Free GB",
   cast(to_char(st.availgb,'999,990.9') as varchar(9)) as "Avail GB",
   cast(to_char((st.usedgb*100)/(st.usedgb+st.freegb),'990.9') || '%' as varchar(6)) as "% Used",
   cast(to_char(((st.freegb-st.availgb)*100)/st.freegb,'990.9') || '%' as varchar(6)) as "% Unav"
from
   (select
       sum(xe.data_stored*xe.cu_size)/power(1024,3) as usedgb,
       sum(xe.free_space*xe.cu_size)/power(1024,3) as freegb,
       (min(xe.free_space*xe.cu_size)*count(xe.mpid))/power(1024,3) as availgb
   from 
       sys.ipe_xor_element xe)
   st(usedgb,freegb,availgb);
Reply with quote Top

Who is online

Users browsing this forum: No registered users and 1 guest

cron