EIS or SAS Software
SAS Institute has added new capabilities to the business object library software SAS / EIS, for business applications. The new objects in the program make possible the development of applications such as reports of expansion, clustered bar charts, multicolumn reports , organization charts, etc.
In addition, SAS has announced the availability of a set of interfaces for the systems R / 2 and R / 3, SAP.
The market for decision support tools is evolving at a rapid pace. Each month brought to market innovative new tools and existing products are changing rapidly. Analysts differentiate five categories of decision support, even though the borders are fast disappearing. Still, you can analyze reporting tools, management consulting, executive information systems (EIS), online analytical processing (OLAP) and data mining.
Each tool is designed to help end users to explore in greater detail the basis of data from the company to collect and analyze data from the various angles required to respond to the various trade issues.
We must provide for a restructuring and significant changes in the market over the next two years, so that the winners will absorb niche products to offer versatile tools and multi-purpose supports a variety of decision support operations. A key differentiator between the various tools is its ability to support high-performance interactive queries on the entire World Wide Web system.
There are five categories of decision support, though the lines separating them are rapidly disappearing. The following is an analysis of these categories and a sample of some of the leading vendors in each of them:
- Query Management
- Executive Information Systems (EIS)
- Online Analytical Processing (OLAP)
- Data Mining
Reporting tools. The reporting tools can be divided into reporting tools of production and desktop report generators. The production reporting tools enable companies to generate regular operational reports or support high-volume batch jobs, such as calculating and printing checks. The production reporting tools include third generation languages such as Cobol, fourth-generation specialized languages such as Focus from Information Builders, tools and client / server high level.
Report generators, meanwhile, are low-priced desktop tools designed for end users. Generally, report generators and graphics interfaces have pictures and graphics functions built in, and can extract data from a variety of data sources and integrate them into a specific report. The main generators of reports are Crystal Reports, Actuate Actuate Reporting System Software Corp., IQ Software IQ Objects, and InfoReports of Platinum Technology. In this sense, marketers are trying to increase the scalability of report generators supporting three-tier architecture in which the reporting process is performed on a Windows NT or Unix server.
The report generators are also beginning to provide interfaces to design mode and manipulate objects and modules reports to ad hoc query and analysis OLAP (Online Analytical Processing).
The query management tools to protect end users deal with the complexities of SQL language and database structures, inserting a "meta-level" between users and the database. This meta-level is a layer or layer of software that offers views of a database-oriented subject and supports the creation point-and-click SQL language. Some vendors such as Business Objects, call this level a "universe", while others, such as Cognos, call it a "catalog." Query tools have become very popular because they can access corporate data without IT department intervention. Most architectures have adopted three-tier architecture to improve scalability, support the implementation of asynchronous data requests and integrate with Web servers. The query tool vendors are also rushing to add support for OLAP processing and data mining capabilities.
Some producers of tools adopt an approach of all-in-one, as in the case of Business Objects, which integrates OLAP functionality in its core product, while others, such as Cognos, Information Builders Platinum Technologies and adopt an approach of "best of each class "offering similar packages to Microsoft Office, consisting of query tools, OLAP and data mining.
Other important tools are Decision Server Query IBM Esperant of Speedware (sold earlier by Software AG) and Oracle Discoverer/2000.
Tools of Executive Information Systems (EIS) predated report generators and query tools, and settled first in mainframes. EIS tools allow developers to create applications for decision support and adapted as graphics, which give managers and executives a high level view of the company, and access to external sources, such as special online news services. EIS applications indicate the exceptions to the activity or the rules of normal commercial activity, using color-coded graphics.
Among the tools are popular EIS Pilot Lightship Software, Forest and Trees of Platinum Technology, Commander of Comshare Decision, Oracle Express Analyzer and SAS / EIS SAS Institute.
EIS vendors are moving in two directions. Many are adding management capabilities to compete head-on consultations with other decision support tools, while others are aimed at producing packaged applications horizontal functions such as sales, marketing budgets, or vertical industries like financial services.
OLAP tools provide an intuitive way to view corporate data. These tools collect data across subjects or common business dimensions, and then allow users to navigate through the hierarchies and dimensions using a click of the mouse. Users can change the level of detail increasing it, sliding in the transverse or decrease in each dimension, spin and exchange dimensions to change how they see the data.
Some tools such as Arbor Software's Essbase and Oracle Express, previously accumulated data in special multidimensional databases. Other tools work directly with relational data and accumulate data on the fly, as in the case of MicroStrategy's DSS Agent. Some OLAP tools process data on the desktop rather than a server. Desktop OLAP tools including Cognos PowerPlay and BrioQuery of Brio Technology.
Many of the differences between OLAP tools are disappearing. Vendors are modifying the architecture of their products to give users more control over the balance between flexibility and performance that is inherent in OLAP tools. For example, these hybrid OLAP products can store data in a database or a specialized OLAP relational database. They can also gather data on the fly or precalculate dimensions to improve performance of data queries. Can be expected that many OLAP vendors rewrite parts of their products in the Java language.
The database vendors would eventually become the main suppliers of OLAP, and most important of them have plans to incorporate OLAP functionality in database kernels. Oracle, Informix Software and more recently Microsoft, have taken the first step towards this end through the acquisition of OLAP vendors (IRI Software, Stanford Technology Group and Panorama, respectively).
A Red Brick Warehouse Red Brick Systems has always supported SQL extensions that perform OLAP simple classifications such as moving averages. Red Brick Warehouse 5.0 also supports data mining algorithms.
The data mining tools are becoming very topical products as possible to obtain in-depth views of corporate data that are not easily detectable by query or OLAP tools. The data mining tools use a variety of statistical algorithms to analyze the correlation of variables in the data and extract trends, patterns and interesting correlations to investigate.
The tools of traditional data mining, such as IBM Intelligent Miner, are expensive and their implementation and management requires the involvement of specialists in statistics. However, we must take account of emerging tools that are currently on the market that promise to remove the mystery of data mining.
These tools include Business Objects and SAS Institute which can provide user interfaces simple and easy to use that plug directly into tools or OLAP databases already exist and which can also be executed directly with data stores.
Selecting the right tool
User Activity Tools
Single pumping Administration 4GL
Reports of emergency EIS Executive
Simple analysis OLAP Director
Commercial Analyst Data mining complex analysis