http://www.engineeringnews.co.za
  SEARCH
Login
R/€ = 14.49Change: 0.10
R/$ = 10.50Change: 0.05
Au 1294.90 $/ozChange: -0.67
Pt 1407.50 $/ozChange: -21.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
 
Nelson Mandela 1918 - 2013   Agriculture   Automotive   Chemicals   Competition Policy   Construction   Defence   Economy   Electricity   Energy   Environment   ICT   Metals   Mining   Science & Technology   Services   Trade   Transport & Logistics   Water  
What's On Press Office Suppliers Directory Research Jobs Announcements Contact Us
 
 
 
RSS Feed
Article   Comments   Other News   Research   Magazine  
 
 
Aug 17, 2012

Cross-company database integration for production analysis

Back
Anytech|Kuka Roboter|Microsoft SQL Server 2012 Enterprise|Column Store Indices|Automation Software|Data Acquisition Software Program|Evaluation Tools|Manufacturing Environments|Respective Equipment Infrastructure|Ben Liebenberg|Harald Reif|Microsoft SQL Server|SQL
anytech|kuka-roboter|microsoft-sql-server-2012-enterprise|column-store-indices|automation-software|data-acquisition-software-program|evaluation-tools|manufacturing-environments|respective-equipment-infrastructure|ben-liebenberg|harald-reif|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
© Reuse this Comment Guidelines
 
 
 
 
 
 
 
 
Other Instrumentation News
Industrial automation giant Festo has been displaying some of the its ongoing research projects and latest automation developments and products at the Hannover industrial fair from April 7 to 11, as part of its Integrated Automation – The Next Steps theme. The...
ROOM CONTROL The new SE8000 series of room controllers can enhance operational efficiency
Global energy management specialist Schneider Electric last month introduced a new series of room controllers, which provides a solution that integrates a thermostat/temperature sensor and programmable room controller in a single unit. “The SE8000 series room...
SMART CHECK A key function of Schaeffler’s new SmartCheck system is to monitor machine vibrations
Germany-based manufacturer Schaeffler Group’s FAG brand SmartCheck measuring system, for the monitoring of machines and plants, makes a valuable contribution to optimising processes and ultimately reduces life-cycle cost (LCC) and the total cost of ownership (TCO),...
More
 
 
Latest News
Few would argue with the notion that unemployment, which stands at around 25% on the narrow definition as reported by Statistics South Africa, remains one of the country’s most pressing challenges. Fewer still could contest the view that South Africa’s education...
Renewable-energy projects, such as this Northern Cape solar farm, seen as key to low‐carbon energy supply.
Upfront investment costs will and should remain a critical consideration as South Africa moves to upscale and accelerate its infrastructure programmes. But one of the lead authors of the latest Intergovernmental Panel on Climate Change (IPCC) argues that the...
The barrier to efficient water service delivery in South Africa was not of a technological nature but rather related to legal and Constitutional challenges, Water Research Commission (WRC) CEO Dhesigen Naidoo said on Thursday. Opening a WRC debate under the theme...
More
 
 
Recent Research Reports
Steel 2014: A review of South Africa's steel sector (PDF Report)
Creamer Media’s Steel 2014 report provides an overview of 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 steel and stainless...
Projects in Progress 2014 - First Edition (PDF Report)
This publication contains insight into progress at the delayed Medupi and Kusile coal-fired projects, in Mpumalanga and Limpopo respectively, as well as at the Ingula pumped-storage scheme, which is under construction on the border between the Free State and...
Automotive 2014: A review of South Africa's automotive sector (PDF Report)
The report provides insight into the business environment, the key participants in the sector, local construction demand, geographic diversification, competition within the sector, corporate activity, skills, safety, environmental considerations and the challenges...
Construction 2014: A review of South Africa's construction sector (PDF Report)
Construction data released during 2013 hints at a halt to the decline in the industry during the last few years, with some commentators averring that the industry could be poised for recovery. However, others have urged caution, noting that the prospects for a...
Electricity 2014: A Review of South Africa's Electricity Sector (PDF Report)
This report provides an overview of the state of electricity generation and transmission in South Africa and examines electricity planning, investment in generation capacity, electricity tariffs, the role of independent power producers and demand-focused initiatives,...
Defence 2013: A review of South Africa's defence industry (PDF Report)
Creamer Media’s 2013 Defence Report examines South Africa’s defence industry, with particular focus on the key players in the sector, the innovations that have come out of the defence sector, local and export demand, South Africa’s controversial...
 
 
 
 
 
This Week's Magazine
The Electronic Systems Laboratory (ESL) of the Department of Electrical and Electronic Engineering at Stellenbosch University is strongly reaffirming its position as one of South Africa’s leading centres for satellite technology and expertise. It is currently...
MORE IN SA Phase 2 should see local content on the mainline locomotive increase from 65% to 80% by the end of 2014
The world’s lowest-cost diesel-electric locomotive is not made in China, but in Pretoria, at RRL Grindrod Locomotives’ newly upgraded 30 000 m2 plant. The company’s locomotive pricing is “more competitive than any other original-equipment manufacturer (OEM)...
The South African Defence Review 2012, released to the public at the end of last month (despite the year given in its title) recommends the creation of the post of Chief Defence Scientist. This official would be responsible for the management of defence technology...
AltX-listed engineering technology company Ansys has been awarded an R188-million contract by Transnet to supply integrated dashboard display systems to the freight rail utility’s locomotives. Black-owned and controlled Ansys developed the bespoke integrated system...
South Africa’s sole nuclear power station Koeberg, which is located in the Western Cape, breached a major operations milestone on April 4, which marked the thirtieth anniversary of Unit 1 having been connected to the grid. Eskom, which operates the two-unit plant,...
 
 
 
 
 
 
 
 
 
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