 |
Using BlueQuery
Business Intelligence Query the user just needs to have the least
basic knowledge on data source and data structure other than any knowledge
on complicated database language, data dictionary and programming
language. And it can convert the query into graphics for visual revelation,
enabling the decision-maker, market analyzer and other related personnel
to share the first-hand information quickly.
Firstly,
it can easily realize cross-platform arrangement of Web enquiry, suitable
to application in ASP, .NET, J2EE, PHP and CGI. It also provides interactive
Web interface for the user to perform real-time and quick control of the
enterprise ocean information.
|
|
Powerful Functions: |
- Query is
available based on data source, information field, SQL language,
generated query, file, Excel, database storage and many other
ways. The query is generated by means of pull-drag other than
by programming of SQL language.
- One query
can cross multiple data sources, e.g. Oracle, SQL, DB2, Informix,
Progress, Sybase and other RDBMS.
- Script
programming is supported within query.
- Visualized
editing of query conditions and use of natural language during
editing of conditions.
- Web-based
interactive query interface provides the functions including
search, filter, input parameters, sequencing and conversion
into graphics, etc.
- Query parameters
are set from Web, enabling the client to input different parameters.
Parameter interface design function is provided to meet the
design all query parameter interfaces.
- The Web
can refresh the query result any moment, enabling the user to
acquire the real-time data.
- Web alarm
function is provided for sending of e-mail and windows message
or startup of other systems based on pre-defined conditions.
Alarm run log is available for easy check by the user.
- The Web
provides independent printing mechanism free from the influence
of form change during I.E. printing.
- Web output
functions including such common formats including Microsoft
Excel, pdf, html and text.
- From Web
interface, the user can recall other ActiveX components, e.g.
WinFax, Windows Media Player. This has greatly enhanced the
demo and system functions, far beyond the general enquiry services.
|
Problem
Solved (1): Increase the query efficiency
|
Problem
Solved (2): Inconvenient to enquire the service process
|
  Enlarged |
 Enlarged |
|
If there are a lot of associated reports in database, do
you still use the traditional ultra-slow SQL to access the
data?
How to increase the speed to generate the report? x1,000?
x1,000,000?
Click
View to find the reason of ultra-fast query.
Click
View to find the BlueQuery query develop process.
|
The
query seems simple. But how to enquire the title of sales
manager, Class 2 or higher? How to process the information
on sex, education background and nationality?
Do you use program for direct computation? How to program
if the contents of Class and Name are dynamic?
Click
View
to find the BlueQuery query develop process.
|
|
| Performance
Optimization Technology: |
- Refresh
data over 1 million, a breakthrough to the general traditional
developing tools, e.g. VB, Delphi, etc that the scrollbars do
not move even for several minutes. Viewed from Web, the data
on the first line can scroll to 1 million line within 2 seconds
or shorter.
- A breakthrough
to the shortcomings that the general BI products will result
in continued increase of server internal memory. This greatly
reduces the loads on hardware and hence optimizes the speed
of query.
- Providing
of relative high-speed interface for different database, hence
to optimize the speed to access the data, e.g. OLE DB, Oracle
OCI Driver, Progress 4GL, etc.
|
|
