http://www.engineeringnews.co.za
  SEARCH
Login
R/€ = 17.88Change: -0.10
R/$ = 15.88Change: -0.04
Au 1237.82 $/ozChange: 0.47
Pt 955.50 $/ozChange: -4.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 About Us
 
 
 
RSS Feed
Article   Comments   Other News   Research   Magazine  
 
 
Aug 17, 2012

Cross-company database integration for production analysis

Back
Anytech|Efficiency|Industrial|Kuka Roboter|Microsoft SQL Server 2012 Enterprise|Safety|Screens|System|Technology|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
Efficiency|Industrial|Safety|Screens|System|Technology||Equipment|Manufacturing|Service|Infrastructure|
anytech|efficiency|industrial|kuka-roboter|microsoft-sql-server-2012-enterprise|safety|screens|system|technology|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

To subscribe email subscriptions@creamermedia.co.za or click here
To advertise email advertising@creamermedia.co.za or click here
 
Comment Guidelines (150 word limit)
 
 
 
 
 
 
 
 
Other Instrumentation News
Article contains comments
Automation company ABB is on schedule to complete automation for the first 800 MW generating unit at State-owned enterprise Eskom’s Kusile power station, in Mpumalanga. “With record timing as a key deliverable of such an intrinsically complex project, there is...
LIGHTWEIGHT The HygroCal100 weighs 3.2 kg, making it less than 25% of the weight of its closest competitor
High-precision sensing company Michell Instruments’ lightweight humidity verification system for humidity probes saves space as it is designed with portability in mind. Michell Instruments says the HygroCal100, with a battery life of up to eight hours, weighs 3.2 kg,...
HANO OELOFSE Our vision is to equip the African people with knowledge, experience and tools to protect their lives and investments
Lightning and surge protection, and safety equipment supplier Dehn Africa launched its Dehncademy, in Johannesburg, last month to transfer its knowledge and experience to customers across Africa. This will help curb the effects of lightning strikes, and ensure that...
More
 
 
Latest News
The Competition Tribunal on Friday gave a conditional go-ahead for mobile operators Cell C, MTN and Vodacom to buy out their respective subscriber bases, as South Africa’s last independent service provider Altech Autopage calls it a day. The Allied Electronics...
The drought in Southern Africa could become one of the worst on record should the current below-normal rainfall continue, the United Nations (UN) World Food Programme said this week. The El Niño conditions presently being experienced in the region had resulted in a...
Kelibone Masiyane has been appointed the new MD of PPC Zimbabwe, succeeding Njombo Lekula, who had recently been redeployed as MD of PPC’s international operations. Masiyane would be supported by new PPC commercial director Iain Sheasby and new PPC GM of finance...
More
 
 
Recent Research Reports
Construction 2016: A review of South Africa's construction industry (PDF Report)
Creamer Media’s Construction 2016 Report examines South Africa’s construction industry over the past 12 months. The report provides insight into the business environment; key participants; local demand; geographic diversification; corporate activity; black economic...
Energy Roundup – February 2016 (PDF Report)
The February 2016 roundup covers activities across South Africa for December 2015 and January 2016 and includes details of a Government Gazette notice that confirms Cabinet’s decision to move ahead with the 9 600 MW nuclear procurement programme; State-owned power...
Energy Roundup - December 2015 (PDF Report)
The December 2015 roundup includes details of State-owned utility Eskom’s application to claw back R22.8-billion; South Africa’s ranking as an investment destination for renewable energy; and a nuclear expert’s thoughts on reactor designs for South Africa’s nuclear...
Water 2015: A review of South Africa's water sector (PDF Report)
Creamer Media’s Water 2015 Report considers the aforementioned issues, not only in the South African context but also in the African and global context in terms of supply and demand, water stress and insecurity, and access to water and sanitation, besides others.
Input Sector Review: Pumps 2015 (PDF Report)
Creamer Media’s 2015 Input Sector Review on Pumps provides an overview of South Africa’s pumps industry with particular focus on pump manufacture and supply, aftermarket services, marketing strategies, local and export demand, imports, sector support, investment...
Liquid Fuels 2015: A review of South Africa's liquid fuels sector (PDF Report)
Creamer Media’s Liquid Fuels 2015 Report examines these issues in the context of South Africa’s business environment; oil and gas exploration; fuel pricing; the development of the country’s biofuels industry; the logistics of transporting liquid fuels; and...
 
 
 
 
 
This Week's Magazine
WIDENING FLEXIBILITY The trailers have a 3-m-wide (2-file) and 4.3-m-wide (2-file) configuration
Lifting, transporting, installing and ballasting solutions provider Ale has expanded its global fleet of trailers and invested in the latest range of widening trailers that can be mechanically widened from 3 m to the desired width for any project. Ale ordered 48 axle...
The market for the BMW 7 Series in South Africa differs quite significantly from the rest of the world. China, the US and the Middle East almost exclusively buy the long-wheel-base version, using the German manufacturer’s luxury high-end sedan as a chaffeur-driven...
January new-vehicle sales fell by 6.9%, to 48 615 units, compared with the same month last year. Statistics released by the Department of Trade and Industry show that the domestic new passenger-car market declined by 6.1%, to 34 936 units, compared with 12 months ago.
Information technology (IT) equipment and infrastructure multinational Dell is providing open infrastructure systems for clients so that they can use any systems, including innovative new systems, that suit their business needs, says Dell Europe, Middle East and...
South Africa’s State-owned defence industrial group, Denel, has set up another international partnership, based in Hong Kong. This new subsidiary is Denel Asia and it is a joint venture (JV) with South African private sector company VR Laser.
 
 
 
 
 
 
 
 
 
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 $149 Close
Subscribe Now for $149