Skip to main content

ibaAnalyzer-DB

Integrazione di dati di processo di base nella gestione della produzione e della qualità

ibaAnalyzer-DB, l’interfaccia banca dati per ibaAnalyzer, consente di aggregare i dati misurati in relazione alla lunghezza o al tempo e di immagazzinarli nella banca dati insieme ai valori caratteristici calcolati.

ibaAnalyzer DB a colpo d’occhio

Integration of basic process data - ibaAnalyzer-DB

  • Estrazione nella banca dati tramite provider ODBC/OLE DB
  • Calcolo ed estrazione trasparenti ed esaustivi di dati di qualità e valori caratteristici (KPI) da dati grezzi ad alta risoluzione in banche dati
  • Utilizzare ibaAnalyzer e ibaAnalyzer-Reportgenerator in base alle ricerche di banca dati
  • Rispondere a domande relative ai processi tramite analisi di banca dati
  • Drill-down flessibile dei dati grezzi

Calculation of Quality Data

With the iba system, production and quality data can be generated directly from data recorded with high resolution taking into account the above-mentioned requirements. For this purpose, high-resolution data must first be prepared appropriately with ibaAnalyzer, then aggregated with ibaAnalyzer-DB and afterwards loaded into a database.

Before data is loaded into the database, it can be fully „pre“-processed with the well-known analysis functions of ibaAnalyzer. In this process, existing analysis specifications can be used to extract a variety of data into the database, such as, for example:

measured signals

derived and calculated signals
(virtual signals)

statistic values,
such as maxima, minima, averages, standard deviations

characteristics calculated related to the product,
such as violations of limits, product blocking note, customer IDs, length calculations (e.g. undercoating length, prime piece length), etc.

Standard interface for databases

ibaAnalyzer-DB uses ADO.net for communication with the databases. Based on this concept, ibaAnalyzer can work with many different databases, such as, for example:

Caratteristiche del prodotto

Layer Model is broken

The classic layer model of communication in production automation is consciously broken through in order to be able to offer the following advantages:

  • versatile connectivity
  • fast data acquisition
  • data pre-processing right after generation
  • calculation of KPIs direct at the source
  • source of KPI data is known and traceable
  • drill down to raw data possible
  • flexibility in case of changes - if different or more data have to be extracted into the database, only the configuration but not the communication interfaces between the individual levels need to be adapted.
Automated Data Extraction

Although ibaAnalyzer-DB uses completed measurement files as a source, analysis and extraction can be automated in a very process-oriented way. Using the post-processing function in ibaPDA or ibaLogic, the analysis can be started immediately after a measurement file has been created. Additional utilities, such as ibaDatCoordinator or batch files, are available for more sophisticated solutions.

Product Features

Loading data into database – scalable extraction

The user can define any number of archiving profiles for extraction in order to reduce the data volume to a small but informative amount. Each measured signal can be individually assigned to an archiving profile.

Topology – from local to plant-wide analyses

When using ibaAnalyzer-DB with a local database, e.g. quality data of a plant can be analyzed, traced and managed clearly. MSSQL Express or MS Access databases are often used for such systems.

Database query

The standard query wizard of ibaAnalyzer-DB assists the user during database query or in searching for specific data using different criteria. Queries can be saved for later use and managed with ibaAnalyzer.

Database analysis

The read data can be viewed and analyzed in used way with ibaAnalyzer-DB. It is particularly interesting to note that analyses can also be carried out directly on the basis of the prepared characteristic values of the database.

This software is one of many useful add-ons of ibaAnalyzer

ibaAnalyzer è caratterizzato da esaustive funzionalità per l’analisi e la valutazione. L’applicazione offre un funzionamento intuitivo con un complesso spettro di funzioni. La licenza per modificare file di misurazione generati con il sistema iba è gratuita.

Scopri di più

Estensioni per ibaAnalyzer

Il sistema ibaAnalyzer può essere ampliato in modo modulare con una serie di utili add-on con funzioni aggiuntive

Offline vibration analysis - ibaAnalyzer-InSpectra
ibaAnalyzer-InSpectra

Detailed offline Vibration Analysis

Automated generation of reports - ibaAnalyzer-Reportgenerator
ibaAnalyzer-Report­generator

Generazione automatica di report

Detailed offline analysis of cyclic processes - ibaAnalyzer-InCycle
ibaAnalyzer-InCycle

Detailed offline analysis of cyclic processes

Display geographic positions and movement - ibaAnalyzer-Maps
ibaAnalyzer-Maps

Display of GPS positions and routes

Parla con un esperto

Compila il modulo e ti contatteremo immediatamente.

Privacy policy

Scegliendo un paese, la mia richiesta sarà inoltrata alla filiale nazionale di iba AG responsabile delle vendite e dell'assistenza.

Risorse

Contattare il proprio partner commerciale locale.

Order no.NameDescription
33.010.000ibaAnalyzerOffline analysis tool*
33.010.003ibaAnalyzer-DB-ReadOffline analysis: read data from SQL databases
33.010.008ibaAnalyzer-DB-Read-5Offline analysis: read data from SQL databases, 5 users
33.010.410ibaAnalyzer-InSpectra+Offline vibration analysis: trend and output of InSpectra results in
ibaAnalyzer
33.010.411ibaAnalyzer-InCycle+Offline analysis of cyclic processes: trend and output of InCycle
results in ibaAnalyzer
33.010.445ibaAnalyzer-E-DatOffline analysis for external data formats
33.010456ibaAnalyzer-Add-On-TDMS-ExtractOffline data extraction from an original DAT file into a TDMS format
(free of charge)

* Software is licensed free of charge for analyzing measurement data generated with the iba system.