CDR-Data Warehouse Developer

Product description

CDR-Data Warehouse Developer offers all the necessary Toolkits for the efficient design and development of the WEB-Based Analysis and Reports within a Decision Support and  Data Warehouse System. Our Product is strongly connected with the Oracle Database Systems and it complements and offers new features for the Oracle Data Server and for other Oracle.

	Parallel load from several Oracle Source files and presentation of the data in a common consolidated view
	Dimensional Model Planning
	OLAP (On-Line Analytic Processing)
	Outstanding performance and flexibility
	Central Administration and Manipulation of the Parts and Services
	Integration of the up to date Standard technologies within the products
	Simpler, quicker and more flexible access of the tables, charts and reports to comply with the different needs of the users.

Transformation

CDR-Developer allows the Extraction and transformation of Data and the propagation of Data Marts from several different Systems (Oracle, DB2...). Through an advanced Multithreading Architecture is achieved a higher degree of the Parallelizing. The Realization based on "in-memory" transformations, which are grounded on the Parallel processing and dataflow optimization.

The CDR Data Mart is a scaleable Multi-tier client/server technology. The client component gives the user the functionality, which are necessary to query the data and analyze them. The application server communicates with the data sources, handles the metadata, serves as a robust Calculation platform and centralizes the information for the future distribution in the enterprise. The Multi Tier Technology is a necessary prerequisite to reach a higher performance for the CDR-Developer.

The new Data Tracer Technology is the heart our e-Business Intelligence Solution. The Data Tracer is a Graphical User Interface, which offers a complex data manipulation, data cleaning and transformation solution. Through the Data Tracer will be the limits of the SQL-tier broken down. Should it be a data load from source system to the Data Mart or should it be a data load from Data Mart to the end-user, through our  Drag&Drop technology will it  be easier and more flexible.

Architecture

The CDR-Developer is for the development of the "Architected Data  Marts" and it is Star-Schemata optimized. It is based very strongly on the recommended "bottom-up" methods of the worldwide recognized experts: Ralph Kimball and it combines the flexibility of the specific Data Marts with the benefits of an enterprise wide Data Warehouse. Hereby plays the additional functionality of the CDR-Developer in supporting the Star-Schemata a very huge role, while the Star Schema is a basic prerequisite to achieving a connection of the Data Marts to an enterprise wide Data Warehouse.

OLAP Analyses and Reports

The CDR OLAP Analysis - and Reporting Tools are offered in Front End for Queries and Reports to give an access for the Employees to the data. The most simpler manipulation is realized through an Drag&Drop interface and through an WEB-Browser Plug in.

Due to the modern "drill-through" technology is a very quick connection of the data from Cross Tables and Reports  to other Information possible. This fast connection allows the user a direct, context dependent and hereby time saving access to further Data, so thus the composition of the necessary Business Information is notably faster and easier. Through an OLE DB interface allows the CDR-Solution the use of the Analysis tools of other companies.

Scalability and System Stability

The intelligent caching methods and the "fail-over" technology of the CDR-Developer allow the high scalability and the permanent and continuous accessibility of the system. Hereby will be offered a stable access to the different information and Reports for the thousands of WEB-Users at the same time. The central monitoring system of the CDR ensures by each Data query, that the connection will be divided among the different servers.

Top of page

CDR-Developer Administration

High End Server Application makes the central Administration of the User-Profiles (Security and User Rights), physical repositories in the net. Single Point of Administration.

Top of page

CDR-Data Analyzer

The Data Analyzer gives a server based analytical computing facility and a huge bandwidth of statistical functions (160 pc.), which allow a complex data manipulating opportunity. The tool makes it easier to process the Data, to load the Data from Data Marts and to presenting the Data to the End-user. It provides server-based analytical computing to deliver a wide range of statistical functions that apply advanced manipulations to data. The CDR-Data Analyzer makes it easy to create powerful expressions that refine data, whether it is for loading data marts or delivering information to end users.

Multi-tier Statistical Analysis

The CDR-Data Analyzer leverages CDR's multi-tier architecture to provide high performance statistical functionality. CDR's architecture focuses processing tasks on a 32-bit, multithreaded application server. The CDR-Data Analyzer uses the application server to execute advanced computations to refine data and perform in-depth analysis. The seamless integration of the CDR-Data Analyzer's capabilities within the CDR-Data Mart Builder gives users the power to embed complex statistical expressions into Data Tracer Plans, whether those plans load data marts or deliver information to end users. When underlying data in a Data Tracer Plan changes, persistent statistical analyses are automatically updated with the most current data.

Wide Range of Statistical Calculations

The CDR-Data Analyzer provides over 160 functions that handle everything from simple arithmetic, to random number generation, to complex multi step statistical functions. Expressions can be built from a long list of mathematical operators, mathematical functions, statistical functions, probability functions, and data management functions. Please see the Features section for a detailed list of functions.

Expression Building

The CDR-Data Analyzer is designed with an elegant user interface to ease the creation of complex expressions. Features such as smart typing, drag-and-drop expression building, and automatic syntax checking simplify the process of developing advanced statistical analysis expressions. The CDR-Data Analyzer makes it easy to create powerful expressions that refine data, whether it is for loading data marts or delivering information to end users..

Features

	Multi-tier Statistical Analysis
	Add Group Break
	Smart Typing
	Drag and Drop Expression Creation
	Syntax Checking
	Statistical Functions
	Probability Functions
	Mathematical Functions
	Random Numbers Functions
	Series Functions
	Trigonometric Functions
	Logical Functions
	Date/Time Function s
	Special Purpose Functions
	Coercion Functions

Top of page

CDR-Data Design Studio

The CDR Design Studio is a Developer tool to design dataflow respectively generation of the Star-Schemata. The processing of the Meta-Data is flexible and easy due to the Graphical User Interface and the fore defined Transformations and the Drag&Drop Technology.

CDR-Data Mart Builder

The CDR data Mart Builder is an advanced 32-Bit application with a high degree of parallelization through Multithreading Architecture. The implementation is based on "in-memory"-Transformations, which are grounded on Parallel processing and Dataflow optimization

Top of page

CDR- Data Presentations

The CDR-Data Presentation is a classical OLAP-Analysis Tool with a GUI for queries, Exchange, Save, Data access. The easy operability is ensured through the Drag&Drop Technology is a graphical tool that lets end users quickly and easily access and share information stored in CDR-Developer-controlled data marts.

CDR- Data Presentations provides an intuitive environment for end-users to access information in CDR-Developer -controlled data marts. Users build requests for information by choosing from a list of business terms in MetaViews-business representations of data stored in databases. They don't need to understand where the information is stored or how it is related, and they are shielded from the complexities of the database structure. A user can then sort, filter, aggregate and manipulate the result set, using live data. Since a data mart can contain a large number of columns or Parts, CDR- Data Presentations includes a search engine to help users easily find the information they need. Key words can be associated with Plans and Snaps to help organize and easily find items of interest.

Plans and Snaps

CDR- Data Presentations provides two methods for users to save information requests. First they can save the requests or Plans for gathering the information. Plans can be executed at any time to get the most recent data from the data mart. In addition, Plans can be shared with other users and can be scheduled to run at specified times. A CDR-Developer user can also save the results as a Snap. Snaps are snapshots of data from a particular point in time. Snaps deliver huge performance and productivity gains. By saving the results of a request as a Snap, users can quickly access data without having to run their request again. Snaps can also be distributed to other users and can be used as a starting point for further analysis. Since Snaps are stored in relational database tables, they can be re-queried against-just as with any database table.

Powerful Information Access

CDR- Data Presentations also features powerful utilities for delivering critical information to end users in flexible and efficient new ways. Using the CDR-DATA Design Studio 's Data Tracer Plans, power users can specify actions that would be difficult, if not impossible, to do with SQL.

Top of page

CDR-Developer Reports

The CDR Developer Reports offers a fast access to the Meta-Data, which are situated in Repositories. The reports gives the user the opportunity to use the Built-In Report-Models, which are making the documentation and management of the data warehouses notably easier.

CDR-Direct to Oracle 8i, Oracle 9i

CDR gives the opportunity for a direct connection to the Oracle Databases and hereby an advanced supplement of the Oracle Developer Tools

Top of page

CDR-WEB Tool

CDR-WEB Tool is a Web interface for the Browser based data queries and for the delivered CDR-OLAP functions. The user can access the Reports end Queries comfortable over an Internet Browser.