Database Management Systems Solutions Manual Third Edition

[Berniece Domnick]

Industrialmetrology is essential to deliver reliable product quality to your customers. Our ZEISS PiWeb reporting and quality data management software helps to connect metrology results coming from different measuring technologies to shop floor decisions. This way, you can efficiently track your production quality.

You do not have to be a metrology pro to work with ZEISS PiWeb. The intuitive handling and drag & drop functionalities make it easy to quickly navigate to the exact result you need or to make any changes in your reports.

With ZEISS PiWeb, you can analyze your measurement data very easily and quickly without being a software expert. The simple filtering, sorting and grouping options save you time and enable you to create tailored reports according to your needs.

ZEISS PiWeb is highly flexible and customizable in order to get the best results, tailored to your specific requirements. You can easily digitize manual processes such as data entry, customer reporting requirements, first article inspection and many more. Create your report exactly how you need it.

Track your production quality on all levels. Statistics made with ZEISS PiWeb provide information about the quality of measuring systems and measurement results as well as the production process itself: perform GR&R studies, report machine capability or create statistical overviews of your manufacturing process.

Static reports such as PDFs are often not enough to make timely and confident decisions. With ZEISS PiWeb, there are endless possibilities to interact with real-time data. Learn how you can always easily find the information you need.

The monitor is your visualization module for reports and therefore the most often used module. Here the interactive reports come to life, you can view your reports, click through data or manually enter data.

If you don't have ZEISS systems, this module comes in very handy for you. With Auto Importer you can import data from third party devices. It supports formats like DMIS, QDAS, FARO, Metrolog and many types of CSV/Excel.

Users inspect rejected parts from an automated CT cell. They designate whether the part can be reworked or if a change in production is necessary. The decision is then forwarded to the production ERP system via the PiWeb API.

A quality manager looks at the production overview to quickly get some information on the quality of production. It is possible to take a look at single parts and their statistics as well as their measurement history

Some parts require to be measured manually. A metrologist uses PiWeb Monitor to add those results to the data base. They can be added manually or by using a digital caliper and can directly be used in reports.

Regular releases provide numerous software improvements and new features. Discover the most important changes and new features, for example, for working with ballooned drawings, generation of bar codes or new notification features.

BVMS Lite, BVMS Plus and BVMS Professional provide seamless management of digital video, audio and data across an IP network. BVMS Lite is a fully functional demo version. It includes eight camera channels free of charge and can be expanded to up to 42 cameras. BVMS Plus addresses mid-sized applications such as offices or warehouses, allowing you to manage up to 256 cameras. BVMS Professional is the suitable solution for larger applications like airports or commercial enterprises with a maximum number of 2,000 camera channels. BVMS allows you to deploy a Bosch video surveillance solution for applications with unique features:

BVMS Enterprise enables the connection of multiple BVMS systems (Lite, Plus, Professional) and / or DIVAR IP all-in-one units. This can be used to connect multiple sites across different time-zones or split up a single site into sub-systems. The Enterprise edition supports monitoring up to 10,000 sites by a single operator and 200,000 cameras by the total system. One operator is able to access up to 100 sub-systems simultaneously.

A transportation hub, like and airport or train station, needs to be able to operate 24 hours a day, 365 days a year. This also applies to the video surveillance system: when operators, for whatever reason, are not able to view live and/or recorded video the transportation hub could be shut-down. This in turn would result in mayor delays for potentially millions of passengers.

Now, the high resilient system architecture of BVMS protects against multiple failure scenarios. For example, with BVMS installed in a metro, failures of important system components do not affect the monitoring within the stations and in the operations control centre (OCC). The system operates independently even when communication lines are disrupted.

BVMS can integrate other systems such as radar and face recognition. This allows the operator to have one interface to receive alarms, process them, and ensure that security guards can effectively follow-up. Alternatively, BVMS can be fully integrated into external systems, like a Physical Security Information Management system (PSIM), using the OPC interface or BVMS SDKs.

A video surveillance system enables operators to spot incidents and prevent operational downtime of the facilities. BVMS allows an operator to do his job without any disruptions. The high resilient system architecture of BVMS protects against multiple failures in system components, so these will not impact the basic functionalities of the video surveillance system.

Perimeter protection systems, like Bosch cameras equipped with Intelligent Video Analytics, fence detection or radar systems, enable the operator to process all the alarms from a single user interface. The built-in alarm management capabilities ensure that operators have access to the right information at the right time. Alternatively, a Physical Security Information Management (PSIM) system can be used to fully control BVMS.

Reducing shrinkage improves business performance, contributing to the bottom line of a retailer. There are many types of shrinkage such as theft, vandalism and supplier fraud. Being able to effectively investigate case-by-case enables retailers to optimize their processes and prevent future losses. Additionally, intelligent alarms enable local security guards to intervene whenever it is required.

BVMS allows a loss prevention manager to effectively access up to 10,000 sites from a single operator client, of which he can connect up to 20 sites simultaneously. Dynamic Transcoding is used to ensure access to High Definition images even when limited small bandwidth is available.

Providing a reliable logistic service is a real challenge. Customers require an on-time delivery and expect the shipments to be complete. Additionally, a lot of high-value goods are stored in a warehouse, which makes it an attractive target for thieves.

BVMS allows warehouse operators to effectively reduce the effort in tracking down theft by combining the alarms coming from intelligent cameras with the information which is stored within their warehouse management system. This same interface, between BVMS and the warehouse management system, can be used to ease the investigation into customer complaints.

While other systems require you to add redundant components to create a resilient system, the BVMS offers several levels of resilience out of the box. As a result, cameras keep recording and streaming live video even when multiple system components fail simultaneously.

At the rate that video cameras are evolving, keeping track of an ever-growing amount of high-resolution video data is becoming even more challenging. In places like metro stations and airports where many cameras are needed, the burden on a workstation is very high. If a workstation is overloaded, the client application will often lag. This is a great obstacle for security operators who need to view many cameras at once in order to maintain a complete and uninterrupted overview of a location, such as an airport terminal.

With BVMS a superior client performance is possible by accelerating the decoding capacities of the graphics processing unit (GPU). In this way, multiple ultra-high resolution (UHD) videos can be displayed in parallel without consuming CPU (Central Processing Unit) power.

With the technology "streamlining", a BVMS user is able to keep multiple Ultra High Definition (UHD) cameras open without having to worry about slowing down the application. This technology automatically shows the optimal video resolution on the screen. If an operator needs to view many cameras simultaneously, BVMS automatically uses a lower-resolution stream. When enhanced pictures are required to zoom in or view on a full screen, for instance, a higher-resolution stream is automatically chosen. This feature uses the multi-stream capabilities available on Bosch IP video cameras and runs on existing workstations.

BVMS is designed to work best with Bosch cameras and storage devices. For example, the edge-based analytics that resides within Bosch cameras can be fully utilized for Live (alarming) and recording (Forensic Search). Bosch storage devices are fully tested by the BVMS test-team and their performance is guaranteed and backed by the Bosch technical support teams all over the world.

To handle access commands and events directly in the video management system, the Access Management System can be integrated into BVMS (version 10.1 and higher). Moreover, the integration allows for manual video verification to increase the security level at doors.

Also, it is possible to establish a direct communication with the Bosch Praesideo public address system, which allows the operator to warn intruders by starting pre-recorded announcements in, for example, a specific zone of the perimeter.

Thanks to the certification as an ONVIF Profile S client, BVMS ensures smooth operation with Profile S cameras and encoders. Over 500 camera models are continuously tested to ensure compatibility between the latest firmware and BVMS release.

3a8082e126