Black Box

Environment

Over 323.839 lines or source code

Over 1.000 unit files

Debug lifecycle since 1995

Analysis

bbeproject1995@libero.it

Fax ref:(Italy) 02 700432967

Analysis

BBE Analysis shows data stored by IPC Server Engine:

On click film mold machine (invention)

On click film jobs (invention)

On click film plant (invention)

BBE Analysis studies data stored by IPC Server Engine and all database with:

Query Handler (invention)

Chart Laboratory

Report Laboratory

BBE Analysis provide S.P.C. calculation

Chart X, Chart R, Chart S

Normal distribution

Capability calculation of CP, CPk.

BBE Analysis provides data entry for extra information not available on real time.

BBE Analysis provide “system pcom inspector” for correct and manage the stored data.

BBE Analysis can access external databases

BBE Analysis import and export data:

Paradox and dbase tables

XML

CSV, Text files

Clipboard

ODBC Drivers

Interbase and Firebird format.

With analysis showing and studying the stored data and add new tools and study models.

Some possibilities offered by the program are taken back in this document. Listing all the capacities of this application is difficult.

BBE Analysis show data stored by IPC Server Engine:

Easy and fast access to stored data. With “films” user can see the entire situation of plant, machine or job.

Film mold machine is our idea.

We assume to be on 06/15/2003 and click on mold machine button see below:

Come into view the film of a mold machine “S5002” (between 2003-june-08 and 2003-june-15).

Appears undergone visible the trend of the production of the week.

In the first chart the green bars represent the work sheets and the amount produced in the sheet on the mold machine considered.

The states of the machine are represented in the second chart.

This picture shows other two charts:

The changes of the physical state of the mold machine are represented in the first chart.

In the second graphic the logical state.

- Status machine

Status Machine

In this Page of Film machine: production history / machine cycle time

Top chart show production history.

Bottom chart show: time of theoretical cycle, average cycle of the sheet, cycle time measures sampled.

Machine cycle time

In this Page of Film machine: measures

Temperatures, times, positions, speeds, pressures (configurable)

Filling time, pressure Other misures temperature

Total amount of status machine in the range considered

Film Jobs (invention)

Not available in this document (see BBE_Screen.pdf)

. Link

Film Plant (invention)

. Link

Not available in this document (see BBE_Screen.pdf)

Query Handler

With query handler the user can search data like SQL queries can do, but with an easy visual mode.

The data can extract from a single table or joined tables or views.

Normally this relations is included in the program menu, but it also be created.

User can select fields in the result set, the order of rows and can declare expressions.

Query also supports groups and statistical calculation on groups (min, max, average, count).

QBB queries are easy and powerful. They were born from our idea.

Query handler can also process SQL command text.

The example shows how to find for every mold the number of times that the mold was mounted on the mold machine.

2- select “order/hob” 1- type of enquiring

3- define query QBB. Very Easy!

4- the result of the query

Now you can see data on chart laboratory:

5- Chart based on data

It is possible to create reports with Report Builder enterprise edition.

Reports provide wizards and include a language compiler.

For more detail refer to www.digital-metaphors.com .

6- report manager

Or you can export data, copy to clipboard, store into repository, save templates, and so on…

Ok, now restart with query handler.

The dataset result may appear like this in a “dbrid” mode.

Query handler manage:

Query QBB (our invention/ idea).

Query in a SQL format (for expert users)

The result of the query, may be:

Showed into query handler viewer (see picture above)

Copied to clipboard

Managed by chart laboratory

Managed by report laboratory

Exported

Imported

Managed with direct SQL commands

Edited and applied to server database

Saved as query template into repository

QBB Queries

QBB query is a new format invented by Gruppo Q.

You can see in the picture below a visual QBB.

QBB features:

Select fields in the result

Order rows in the result

Define search criteria in easy and expert mode

Grouping data with statistical operator

Expressions

Show SQL command text generated.

QBB query is translated into corresponding SQL command text.

QBB query can manage sql command text and in particular:

Select

Order by

Group By

Joins like left outer join, inner join, right join, cross join…

Having in group by clause

For administrators/supervisor it is also possible to:

Use “delete” command

Use “update” command

Use other commands like “create table”, “alter table”… and so on.

For more information there is a specific document that explains QBB queries.

From the “Query Handler” it is possible to manage QBB queries:

Save QBB template in a file

Open QBB template from a file

Copy QBB template into clipboard

Save the template into repository

Save the data into local repository

Free creation of templates

Query SQL

It is possible to manage SQL commands directly.

From the “Query Handler” it is possible to manage SQL queries:

Save SQL command in a file

Open SQL command from a file

Copy SQL command into clipboard

Save SQL command into repository

Create SQL view based on current sql command

Export data

From the “Query handler” it is possible to:

Export data in CSV format

Export data in Paradox format

Export data in Dbase format

Export data in local repository

Export data in XML format

Process data with internal “data pump”

Clipboard

Features:

Copy data into clipboard

Copy single row

Copy single row as variables

Copy schema

Generate sql template

Generate schema and first n rows examples

Edit/change the result dataset

It is possible to:

Modify the data only in memory to execute a print, a chart or exports the modified data

Apply the changes directly to the source database.

Features:

Edit data with dbrid in place editor

Live queries

Delete the records included in the result dataset from database server

Data pump

Data pump run only with BDE engine.

Features:

Create a new table based on dataset result.

Append records into another table

Append/update records into another table

Delete records in another table

Repository

Analysis provide a repository where users can:

Save QBB templates

Save templates of report

Save chart templates

Save SQL command text.

Import templates from email

Repository organizes queries, reports and charts with groups, titles and easy classification.

The user can make query, save it into repository and make visible to all users.

Repository

Chart laboratory

Laboratory features:

Complete chart editor

Over 20 Functions (like trend…)

Export chart to WMF, GIF, EMF, JPG, BMP, PNG

Save templates in external files

Save templates in repository

Direct email chart or chart data

Linked directly to QBB or SQL queries.

Some chart gallery:

Complete chart editor

Application example:

Pressure and relation time of filling (more than 20000 measures).

Filling time (seconds) Pressure (bar)

Application example:

Pressure and relation time of filling (more than 20000 measures).

The color of the dots represents the mold machine.

The single point represents a sampling during the production.

Filling time (seconds) Pressure (bar)

Application example:

Pressure of injection mold machine.

Every series represents a different article/part

Pressure (bar) Number of samplings

Report laboratory

Analysis include Report Builder Enterprise edition, developed by Digital Metaphors.

This version of Report Builder includes RAP. The user can write source code in an embedded report.

It also includes “DADE”. It is possible to make data modules with powerful queries wizards.

BBE Analysis provide S.P.C. calculation

Chart X, Chart R, Chart S

Normal distribution

Capability calculation of CP, CPk.

BBE Analysis provide data entry

for extra information not available on real time.

User can save extra information not available on real time.

BBE Analysis PROVIDES “system pcom inspector” for correct and manage the stored data.

With System pcom inspector user can manage the sheets

BBE Analysis can study external databases

User can use Analysis with external databases.

Query Handler, QBB, reports and chart can access on data stored in external databases.

BlackBox Envinronment

Matteo Tosato

2004-06-09T16:28:00

giannina marc