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
Article contains comments
Engineering software specialist company Autodesk has implemented special prices, including rental options, to make its widely used engineering design and manufacturing software programs available to small business in Africa. The most significant reason why companies...
Evraz Group SA, a unit of Russia's largest steelmaker, Evraz, said on Monday it would repurchase up to $750-million of its notes due in 2015 to reduce its US dollar debt exposure. The early tender purchase price was set at $1 005 per $1 000 in principal amount of...
The month-long strike in the metal sector knocked back the third-quarter growth rate of the South African economy by more than half of what it could have been, the SA Reserve Bank (SARB) said on Monday. In its latest Quarterly Bulletin, the bank said the annualised...
Recent Research Reports
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.
Defence 2014: A review of South Africa's defence industry (PDF Report)
Creamer Media’s Defence 2014 report examines South Africa’s defence industry, with particular focus on the key participants in the sector, the innovations that have come out of the sector, local and export demand, South Africa’s controversial multibillion-rand...
Road and Rail 2014: A review of South Africa's road and rail infrastructure (PDF report)
Creamer Media’s Road and Rail 2014 report examines South Africa’s road and rail transport system, with particular focus on the size and state of the country’s road and rail network, the funding and maintenance of these respective networks, and the push to move road...
Real Economy Year Book 2014 (PDF Report)
This edition drills down into the performance and outlook for a variety of sectors, including automotive, construction, electricity, transport, steel, water, coal, gold, iron-ore and platinum.
Real Economy Insight: Automotive 2014 (PDF Report)
This four-page brief covers key developments in the automotive industry over the past 12 months, including an overview of South Africa’s automotive market, trade figures, production and the policies influencing the sector.
This Week's Magazine
South Africa remains an important manufacturing and export platform for Ford Motor Company, says executive chairperson Bill Ford. However, he adds that other countries on the continent are “becoming interesting”, and that the US carmaker is casting its net wider for...
Germany’s Max-Planck-Society (MPG) and the Max-Planck-Institute for Radio Astronomy (MPlfR) are investing €11-million (about R150-million) into South Africa’s MeerKAT radio telescope array programme. The money will be used to design, build and install S-band radio...
Infrastructure spend in sub-Saharan Africa will grow from $70-billion in 2013 to $180-billion by 2025, says PwC capital projects and infrastructure Africa leader Jonathan Cawood. This is one of the findings of PwC’s Capital Projects & Infrastructure report on East...
Private-owned defence and aerospace manufacturer Paramount Group and the Ichikowitz Family Foundation unveiled its Anti-Poaching Skills and K9 Training Academy in Magaliesburg last month.
The inclusion of Bluetooth to provide sub-three meter accuracy and heightened functionality for users is one of the ways to change existing wireless networks into engagement networks. An engagement network differs from common wireless networks in that it enables the...