Aug 17, 2012
Cross-company database integration for production analysisBack
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
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© Reuse this Comment Guidelines (150 word limit)
Other Manufacturing News
Acting Transnet CEO Siyabonga Gama, who was appointed to the position following the surprise secondment of Brian Molefe to Eskom, has placed revenue diversification at the top of his list of immediate priorities, with the weak commodity outlook seen as having the...
Heineken NV, the world's third largest brewer, and Africa-focused trading firm CFAO will invest 100-billion CFA francs ($163.52-million) to build a brewery in Côte d'Ivoiret, a Heineken company official said on Wednesday. "We'll be operational in a year and a half...
Following his first 100 days as CEO of cement producer PPC, Darryll Castle reports that action plans have been put in place to more aggressively win back market share within South Africa, while pressing ahead with its high-potential African expansion strategy. A...
Recent Research Reports
Steel 2015: A review of South Africa's steel sector (PDF Report)
Creamer Media’s Steel 2015 report provides an overview of the key developments in the global steel industry and particularly of South Africa’s steel sector over the past year, including details of production and consumption, as well as the country's primary carbon...
Projects in Progress 2015 - First Edition (PDF Report)
In fact, this edition of Creamer Media’s Projects in Progress 2015 supplement tracks developments taking place under the Renewable Energy Independent Power Producer Procurement Programme, which has had four bidding rounds. It appears to remain a shining light on the...
Electricity 2015: A review of South Africa's electricity sector (PDF Report)
Creamer Media’s Electricity 2015 report provides an overview of State-owned power utility Eskom and independent power producers, as well as electricity planning, transmission, distribution and the theft thereof, besides other issues.
Construction 2015: A review of South Africa’s construction sector (PDF Report)
Creamer Media’s Construction 2015 Report examines South Africa’s construction industry over the past 12 months. The report provides insight into the business environment; the key participants in the sector; local construction demand; geographic diversification;...
Liquid Fuels 2014 - A review of South Africa's Liquid Fuels sector (PDF Report)
Creamer Media’s Liquid Fuels 2014 Report examines these issues, focusing on the business environment, oil and gas exploration, the country’s feedstock supplies, the development of South Africa’s biofuels industry, fuel pricing, competition in the sector, the...
Water 2014: A review of South Africa's water sector (PDF Report)
Creamer Media’s Water 2014 report considers the aforementioned issues, not only in the South African context, but also in the African and global context, and examines the issues of water and sanitation, water quality and the demand for water, among others.
This Week's Magazine
Forest products group Sappi has confirmed the selection of its 25 MW biomass-to-power project, to be erected at its Ngodwana mill, in Mpumalanga, as a preferred bidder under the South African government’s Renewable Energy Independent Power Producer Procurement...
Information and communications technology (ICT) distributor DCC is making Windows- and Android-operating systems tablets available through retailers and education equipment suppliers to provide school children with affordable, high-performance education tools. The...
Another cement manufacturer is set to enter the Ugandan market, raising hopes that prices will come down and spur growth in the construction industry. National Cement, a Kenyan manufacturer, has unveiled plans to invest $195-million in a new manufacturing plant in...
With growth rates exceeding that in the developed world – at an average of between 4% and 5% between 2002 and 2014 – African countries provide investors with ample reason to tap into booming consumer demand says Manufacturing Circle executive director Coenraad...
The South African Chamber of Commerce and Industry’s (Sacci’s) Business Confidence Index (BCI) decreased by 3.7 index points month-on-month to 89.1 in March.