StarProbe OLAP Business Intelligence SOA Server

StarProbe BI is a web-based business intelligence platform. It provides extended OLAP-plus functions over the web using user-written html pages such as executive dashboards, management reports, etc. Analytic features include charting, reporting, predictive modeling, rule-based evaluation, and so on. For free downloads, please visit Downloads.

Rapid analytic application development!

BI server provides an advanced platform for BI reporting and analytics. Typical BI applications consist of hundreds of simple and complex reports or dashboards that may contain complex charts with predictive statistics. Developing such systems can require huge manpower and time. BI server platform provides an advanced platform on which complex applications can be developed and deployed very rapidly, resulting not only significant cost reduction but also with sophisticated analytics!

What is Web-based Business Intelligence (BI) and OLAP?

Conventional OLAP Business Intelligence (BI) software systems are in general single-user stand-alone desktop programs or they require such client programs to be installed on each user's computers. Furthermore, the types of reports and dashboards are largely pre-determined by system's design. There are very little rooms to customize according to user's requirements. Web-based OLAP, on the other hand, uses web technology to deliver analytic information to multiple users simultaneously, overcoming the limitations of conventional OLAP systems. Data is centrally stored on database systems and processed dynamically when user visits web pages containing analytic information. Analytic information is embedded into html pages, specially written for the needs of special users, such as executives, managers, analysts, specialists, and so on.

How SOA Business Intelligence works?

SOA - Service Oriented Architectures - refers to the approach delivering compartmentalized information to web pages. SOA is a new trend for Business Intelligence (BI) and OLAP. StarProbe OLAP consists of a number of programs that can be used in HTML <A HREF="..."> and <IMG SRC="..."> tags. In addition, embedded html pages provide powerful report-formatting capability that may include charts and advanced predictive analytics. Analytic components can be operated in multiple modes;

  • Interactive mode: users select fields and options for analytic reports and charts interactively. This is somewhat similar to common statistical packages!
  • Embedded pages: A number of analytic report tables and charts are embedded into html pages, and executed dynamically when users make visits.
  • Direct links: A report or chart page is created dynamically.
  • Image links: chart images are called from <IMG SRC="..."> links dynamically, showing charts based on latest information dynamically.

For more, please read SOA Business Intelligence - How does it work?

Benefits of SOA Business Intelligence

The main purpose of using SOA Business Intelligence is to make your application infrastructure more agile and flexible. This offers the following benefits;

  • Simple, fast and easy implementation of dashboards and analytic reports.
  • Changing requirements can be addressed more quickly.
  • Lower maintenance efforts.
  • High performance.
  • Lower total cost.
Why SOA based on SOAP/XML will be limited?

SOA can be implemented in various ways. StarProbe BI is based on HTML URL Tags. It provides the benefits described above in full. Another much hyped method is SOAP/XML. Business intelligence provides more than XML text-based information. For example, visualization charts, predictive models, dashboard reports, etc. SOAP/XML-based implementations require extensive programming. Furthermore, the use of XML for data exchange can be very limiting for business intelligence. Therefore, SOA based on SOAP/XML is likely to have very limited usage!

Quality Data Visualization and Charts

StarProbe OLAP produces high-quality graphics and reports that can be used in executive dashboards analytic reports. For more examples, please read Dashboards, Reports and Charts.

olap database chart - bar olap database chart - bar

Confluence of Business Intelligence and Data Mining

StarProbe OLAP is incorporated with Rule-based Modeling Environment (RME). RME provides a platform where advanced predictive models can be incorporated with rules and mathematical formulas. Predictive models include decision trees, neural networks and regression formulas. This enables advanced analytical decision models and forecasting systems to be developed very easily.

Real-time Executive/Operational Dashboard

Executive dashboards provide up-to-date management information for executives and managers. Literally, dashboards resemble the same kind of automobile dashboards. Dashboards consist of essential business indicators showing where they are and where they are headed. Most BI/OLAP systems show only current status. Predictive analytics of StarProbe can improve this with intelligent forecasting and predictions. The followings show dashboard examples generated using iText and JSP. For more, please see Dashboards, Reports and Charts.

Trend Analysis and Forecasting - Dashboards

Timely identification of newly emerging trends is very important to businesses. Sales patterns of various customer segments indicate market trends. Upward and downward trends in sales signify new market trends. Rule-based modeling and predictive analytics of StarProbe OLAP provides powerful tools for developing dashboards for trend analysis. The following figure shows an example of segment-by-segment trend charts. For more, please read Trend Analysis and Forecasting.

market segmentation and trend analysis.

Massive speed with embedded large-memory-optimized database

StarProbe OLAP supports all major database systems. In addition, it is embedded with Rosella DBMS. Rosella is a large main-memory optimized high performance relational DBMS. It can exploit up to 512GB database main-memory buffers, performing sorting at the rate of 1 million records in average about 3~15 seconds. In addition, embedded operation removes the long bi-directional communication intervals, providing ultra-fast services! For more, please read Rosella DBMS.

Full Support for SOA and Java/J2EE/J2SE

StarProbe OLAP is based on Java/J2SE/J2EE featuring;

  • Runs on any J2EE compliant server: Resin, Tomcat, JBoss, etc.
  • Embedded large main-memory optimized high-performance DBMS.
  • Supports all major database systems: Ingres, MS Access, MS SQL Server, Oracle, DB2, MySQL, Sybase, ...
  • Runs on all major operating systems: Windows, Mac OS X, Linux, FreeBSD, Unix, Solaris, AIX, ...
  • Supports all major web browsers: MS Internet Explorer (IE), Opera, Firefox, Netscape, Safari, ...

Main features include;

  • SQL query and reports: HTML-based formatting/subtotals/grand totals.
  • Visual charts: pie charts, line charts, bar charts, gauge charts.
  • Report tables: group-by tables and cross tables (may include charts in cells).
  • Rule-based modeling: rules, mathematical formulas, predictive models.
  • Predictive models: decision trees, neural networks, regression functions.
  • Time-series forecasting and trend analysis.

Case: Healthcare Fraud Analytics

Robustness of StarProbe OLAP is proven with healthcare fraud detection analytics. It is entirely written in html pages only with embedded StarProbe OLAP analytic components! It shows how easily complex custom analytics can be configured. For more on this topic, please read healthcare fraud detection.

Free Downloads

For free or evaluation copies, click StarProbe OLAP Download.