http://www.engineeringnews.co.za
  SEARCH
Login
R/€ = 13.56Change: -0.04
R/$ = 12.17Change: 0.15
Au 1172.65 $/ozChange: -5.90
Pt 1077.50 $/ozChange: -1.00
 
 
Note: Search is limited to the most recent 250 articles. Set date range to access earlier articles.
Where? With... When?








Start
 
End
 
 
And must exclude these words...
Close Main Search
Close Main Login
My Profile News Alerts Newsletters Logout Close Main Profile
 
Agriculture   Automotive   Chemicals   Competition Policy   Construction   Defence   Economy   Electricity   Energy   Environment   ICT   Metals   Mining   Science and Technology   Services   Trade   Transport & Logistics   Water  
What's On Press Office Tenders Suppliers Directory Research Jobs Announcements Letters Contact Us
 
 
 
RSS Feed
Article   Comments   Other News   Research   Magazine  
 
 
Aug 17, 2012

Cross-company database integration for production analysis

Back
Anytech|Industrial|Kuka Roboter|Microsoft SQL Server 2012 Enterprise|Safety|Screens|System|Column Store Indices|Automation Software|Data Acquisition Software Program|Equipment|Evaluation Tools|Manufacturing|Manufacturing Environments|Respective Equipment Infrastructure|Service|Ben Liebenberg|Harald Reif|Infrastructure|Microsoft SQL Server|SQL
Industrial|Safety|Screens|System||Equipment|Manufacturing|Service|Infrastructure|
anytech|industrial|kuka-roboter|microsoft-sql-server-2012-enterprise|safety|screens|system|column-store-indices|automation-software|data-acquisition-software-program|equipment|evaluation-tools|manufacturing|manufacturing-environments|respective-equipment-infrastructure|service|ben-liebenberg|harald-reif|infrastructure|microsoft-sql-server|sql
© Reuse this



Real-time production reporting program Zenon Analyser enables users to integrate other databases – even from vendors – within a single database, says South African Zenon service provider Anytech.

Anytech supervisory control and data acquisition (Scada) specialist Ben Liebenberg says it is relatively simple to use linked servers in programming language SQL statements. “This also gives users the ability to access different types of data from various database servers within a single database,” he says.

The Zenon Analyser is a module of the flagship Zenon automation, control and data acquisition software program. A mix of real-time data, directly from processes and historical data from a database, is its defining characteristic.

“The Microsoft SQL Server 2012 Enterprise version now offers highly increased query performance, using the new Microsoft SQL Server 2012 feature ‘Column store Indices’. This is critical for many of our customers in manufacturing environments,” says Austrian automation software and Zenon developer Copa-Data SQL development expert Harald Reif.

Depending on the respective equipment infrastructure, companies can construct their data sources in a decentralised manner, or gather all data centrally in an SQL database by using Zenon Analyzer.

“Historical data for use in evaluations, for example, can be obtained from many different sources, such as Microsoft SQL Server and other databases over a linked server. “The data is prepared by Zenon Analyzer and provided to the user in the form of tables or graphics. Users have the option to use modern tools to generate their reports, or even write their own statistics. Naturally, we also provide a comprehensive set of evaluation tools as standard,” notes Reif.

Further, Microsoft SQL Server 2012 has significantly improved performance, compared with its previous release, to meet current trends in the data technology world, he says.

For example, multicore central processing units (CPUs), which have become more prevalent, are used more effectively. Microsoft SQL Server 2008 Release 2 was limited to four CPUs, whereas Microsoft SQL Server 2012 runs on up to 16 CPUs, with a limitation of four sockets. This means that 16-CPU-usage can be achieved by using four Quad-Core-CPUs, says Liebenberg.

Meanwhile, Copa-Data and industrial robot manufacturer Kuka Roboter have standardised on Zenon as the visualisation solution for the operation of Kuka robots in improving efficient industrial production and processing.

“The more complex production processes become, the more important it becomes to operate machines and equipment intuitively and efficiently. As part of their cooperation, the companies now offer the option of using Zenon as visualisation software to industrial and manufacturing companies for automated production; thus guaranteeing maximum efficiency and user-friendliness for the operation, control and monitoring of industrial robots,” he explains.

Further, Zenon Scada runs on the new PC-based KR C4 control platform. The control system is used to control robots, movement, workflows and processes. It also provides complete safety control.

“Its primary characteristic features are minimal hardware requirements, intelligent software function, openness and reliability. The operator uses the visualisation solution by means of the Kuka SmartPads, which are control units with 21-cm touch-screens. Users have all the functionalities they need and their tasks are available on a user-friendly interface,” he concludes.

Edited by: Martin Zhuwakinyu
Creamer Media Senior Deputy Editor
© Reuse this Comment Guidelines (150 word limit)
 
 
 
 
 
 
 
 
Other Manufacturing News
Updated 2 hours 23 minutes ago Gauteng Premier David Makhura recommitted the provincial government’s support to the revival of Gauteng’s manufacturing base, telling the second yearly Manufacturing Indaba on Tuesday that policymakers would drive legislation that created an environment in which the...
Updated 6 hours ago Sustained innovation remains central to national efforts to grow the economy and maintain a country’s competitive position and should not be considered a “nice-to-have” but rather a strategic imperative, visiting US-based global innovation policy specialist Professor...
EIUG adviser Shaun Nel
Updated 6 hours ago As South Africa’s electricity dearth looks set to linger well into the next decade, manufacturers are being increasingly encouraged to invest in off-grid, self-generation energy solutions to shift reliance away from the national grid and volatile electricity tariffs...
Article contains comments
More
 
 
Latest News
Updated 2 hours 39 minutes ago Gauteng Premier David Makhura recommitted the provincial government’s support to the revival of Gauteng’s manufacturing base, telling the second yearly Manufacturing Indaba on Tuesday that policymakers would drive legislation that created an environment in which the...
Updated 6 hours ago The Competition Commission has reached a settlement agreement with Japanese shipping liner Nippon Yusen Kabushiki Kaisha (NYK) for contravening the Competition Act in the transportation of motor vehicles to and from South Africa by sea. This settlement followed the...
Updated 6 hours ago State-owned aerospace and defence technology conglomerate Denel on Tuesday launched a book to demystify defence technology to South African learners and attract them to the defence industry’s career opportunities, while creating greater awareness about innovation and...
More
 
 
Recent Research Reports
Real Economy Year Book 2015 (PDF Report)
There are very few beacons of hope on South Africa’s economic horizon. Economic growth is weak, unemployment is rising, electricity supply is insufficient to meet demand and/or spur growth, with poor prospects for many of the commodities mined and exported. However,...
Real Economy Insight: Automotive 2015 (PDF Report)
Creamer Media’s Real Economy Year Book comprises separate reports under the banner Real Economy Insight and investigates key developments in the automotive, construction, electricity, road and rail, steel, water, gold, iron-ore and platinum sectors.
Real Economy Insight: Water 2015 (PDF Report)
Creamer Media’s Real Economy Year Book has been divided into individual reports under the banner Real Economy Insight and investigates key developments in the automotive, construction, electricity, road and rail, steel, water, coal, gold, iron-ore and platinum sectors.
Real Economy Insight: Construction 2015 (PDF Report)
Creamer Media’s Real Economy Year Book has been divided into individual reports under the banner Real Economy Insight and investigates key developments in the automotive, construction, electricity, road and rail, steel, water, coal, gold, iron-ore and platinum sectors.
Real Economy Insight: Electricity 2015 (PDF Report)
Creamer Media’s Real Economy Year Book has been divided into individual reports under the banner Real Economy Insight and investigates key developments in the automotive, construction, electricity, road and rail, steel, water, coal, gold, iron-ore and platinum sectors.
Real Economy Insight: Road and Rail 2015 (PDF Report)
Creamer Media’s Real Economy Year Book has been divided into individual reports under the banner Real Economy Insight and investigates key developments in the automotive, construction, electricity, road and rail, steel, water, coal, gold, iron-ore and platinum sectors.
 
 
 
 
 
This Week's Magazine
JSE-listed Afrimat will make a cash offer to acquire the entire remaining issued share capital of subsidiary Infrasors that it does not already own.
TEAMWORK Aggreko Europe, Middle East & Africa MD David Taylor-Smith; Aggreko Zambia chairperson Dr. Sixtus Mulenga; Aggreko Africa MD James Shepherd
Temporary power generation services provider Aggreko announced earlier this month that it had appointed Dr Sixtus Mulenga as nonexecutive chairperson of Aggreko Zambia, a move it believed was integral to the ongoing expansion of its operations in Zambia and the rest...
Major global aircraft manufacturer Airbus Commercial Aircraft is maintaining a steady course. "I don't have any big news, good or bad," company President and CEO Fabrice Brégier told international aviation journalists in Toulouse, France, at the company’s recent...
MEASURING DEVICES Bosch has released a mobile app that enables the measurements made with measuring devices to be sent and used directly on the app for accuracy and on-site quoting
Industrial tool manufacturer Bosch has increased the compatibility of many batteries in its range of blue industrial power tools and has released mobile-device applications (apps) for users of the tools, says Bosch South Africa training manager Peter du Bruyn. Many...
The new Nissan Navara has been launched onto the global market, but Nissan South Africa (NSA) will only know in August whether the local Rosslyn plant will assemble the one-ton pickup. The NSA plant currently produces the old NP300 Hardbody one-ton bakkie, as well as...
 
 
 
 
 
 
 
 
 
Alert Close
Embed Code Close
content
Research Reports Close
Research Reports are a product of the
Research Channel Africa. Reports can be bought individually or you can gain full access to all reports as part of a Research Channel Africa subscription.
Find Out More Buy Report
 
 
Close
Engineering News
Completely Re-Engineered
Experience it now. Click here
*website to launch in a few weeks
Subscribe Now for $96 Close
Subscribe Now for $96