http://www.engineeringnews.co.za
  SEARCH
Login
R/€ = 13.85Change: 0.03
R/$ = 10.93Change: 0.05
Au 1231.31 $/ozChange: -0.06
Pt 1248.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 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
© Reuse this Comment Guidelines (150 word limit)
 
 
 
 
 
 
 
 
Other Instrumentation News
SABINE DALL’OMO You will be challenged regardless of gender, especially in South Africa, where having a woman at the helm of an organisation is not that unusual
Sabine Dall'Omo, Siemens South Africa CEO, talks to Tracy Hancock of Engineering News about her career and moving to South Africa for love. For the first time in 150 years, there is a woman at the helm of Siemens South Africa – German-born Sabine Dall'Omo, who has...
EASY PRINTING The PRO-Mark LCD pin-marking machine uses programmable marking and component identification
Stainless steel clamping and identification systems distributor Banding & Identification Solutions Africa (Bisa) acquired a PRO-Mark liquid crystal display (LCD) pin-marking machine at the end of last year and demonstrated the machine’s capabilities at the Electra...
SIMPLE DESIGN The innovative design of the MOVI4R-U frequency inverters allows for the quick and easy removal or replacement of parts
Drive engineering company SEW-Eurodrive launched its MOVI4R-U frequency inverters at trade show Electra Mining Africa, which was held at the Nasrec Expo Centre, in Johannesburg, in September.
More
 
 
Latest News
Swedish Ambassador to South Africa Christian Meuwly will next week inaugurate the final roll-out of the new vertical shaft brick kiln (VSBK) at clay brick manufacturer Langkloof Bricks’ facility in Jeffrey’s Bay. The VSBK formed a part of economic, social and...
Hot on the heels of the launch of Rustenburg’s rapid transport system’s brand name and logo last week, a negotiation framework agreement (NFA) has been formally agreed to and signed by the Rustenburg Local Municipality (RLM) and taxi and bus operators affected by the...
The runway at the George Airport, in the Western Cape, has been rehabilitated to improve safety, in terms of run-off and storm water drainage, and the structural capacity of the pavement surface. The scope of work comprised the extension of Runway 11/29, the...
More
 
 
Recent Research Reports
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.
Real Economy Insight: Construction 2014 (PDF Report)
This five-page brief covers key developments in the construction industry over the past 12 months. It provides an overview of the sector and includes details of employment in the sector, infrastructure and municipal spending, as well as insight into companies’...
Real Economy Insight: Electricity 2014 (PDF Report)
This five-page brief covers key developments in the electricity industry over the past 12 months, including details of State-owned power utility Eskom’s generation activities, funding and tariffs, independent power producers and prospects for the sector.
 
 
 
 
 
This Week's Magazine
Integrated energy and chemical company Sasol has partnered with Unisa Graduate School of Business Leadership (SBL) professor and founder and CEO of PanAvest Partnership Dr Douglas Boateng to publish a series of books on executive supply chain management aimed at...
MORNÉ DU PLESSIS Increased urgency and burgeoning awareness of the importance of these issues are beginning to change political risks and, thus, State responses to environmental concerns
The World Wide Fund for Nature’s (WWF’s) 2014 Living Planet Index (LPI) indicates that there has been a 52% decline in vertebrate species since 1970. The Index tracked the trends of 10 000 discrete populations of over 3000 vertebrate species between 1970 and 2010.
Rwanda has joined a number of East African countries seeking to import electricity from Ethiopia as its demand grows. After it became apparent several generation project it is implementing will not come on stream early enough, now plans to import 400 MW from Ethiopia...
Metrorail’s first new passenger train will arrive in November next year, says Passenger Rail Agency of South Africa (PRASA) CEO Lucky Montana. “Next year we will be able to put our hands around the infrastructure and equipment we have been talking about for so long.”
The Competition Commission has launched an investigation into what it says are “price fixing, market division and collusive tendering in the market for the manufacture and supply of automotive components to original equipment manufacturers” (OEMs, or vehicle...
 
 
 
 
 
 
 
 
 
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