R/€ = 15.44Change: -0.12
R/$ = 13.56Change: -0.10
Au 1168.87 $/ozChange: 3.52
Pt 990.00 $/ozChange: 0.00
Note: Search is limited to the most recent 250 articles. Set date range to access earlier articles.
Where? With... When?

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

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
Creamer Media Senior Deputy Editor
© Reuse this Comment Guidelines (150 word limit)
Other Manufacturing News
Creditors being briefed ahead of the vote on October 13
Evraz Highveld Steel and Vanadium (Highveld) creditors on Tuesday voted in favour of a business rescue plan, which includes a buy-out offer from International Resources Limited (IRL), of Hong Kong, China. The vote, attended by some 300 people, took place at a hall on...
South Africa's National Treasury could "in the extreme" try and block the $106-billion takeover of SABMiller by the world's largest brewer, Anheuser-Busch InBev, a senior treasury official said on Tuesday. "We subject those applications to subjective criteria – the...
Anheuser-Busch InBev raised its takeover offer for SABMiller on Monday, as the world's largest brewer tries to win over its smaller rival to the idea of creating a giant that would make nearly a third of the world's beer. The maker of Budweiser and Stella Artois is...
Latest News
Rural Development and Land Reform Minister Gugile Nkwinti
Agri SA is calling for urgent clarification of the correct wording and interpretation of the governing party’s decision, whereby the 50/50 proposal, which requires farmers to hand over half their land to their workers, has been accepted as African National Congress...
South Africa should not be allowed to create new coal-fired power stations if it is to tackle its carbon emissions and meet the global goal of keeping temperature increases below 2 °C, says South African environmental and antinuclear organisation Earthlife Africa...
Integrated information and communications technology (ICT) systems provider Datacentrix has lifted earnings attributable to shareholders for the six months ended August 31, by 15.4% to R54.5-million and headline earnings per share (HEPS) by 14% to 27.7c, benefitting...
Recent Research Reports
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...
Road and Rail 2015: A review of South Africa's road and rail sectors (PDF Report)
Creamer Media’s Road and Rail 2015 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 infrastructure and network, the funding and maintenance of these respective networks, and...
Defence 2015: A review of South Africa's defence sector (PDF Report)
Creamer Media’s Coal 2015 report examines South Africa’s coal industry with regards to the business environment, the key participants in the sector, local demand, export sales and coal logistics, projects being undertaken by the large and smaller participants in the...
Real Economy Year Book 2015 (PDF Report)
There are very few beacons of hope on South Africa’s economic horizon. Economic growth is weak, unemployment is rising, electricity supply is insufficient to meet demand and/or spur growth, with poor prospects for many of the commodities mined and exported. However,...
Real Economy Insight: Automotive 2015 (PDF Report)
Creamer Media’s Real Economy Year Book comprises separate reports under the banner Real Economy Insight and investigates key developments in the automotive, construction, electricity, road and rail, steel, water, gold, iron-ore and platinum sectors.
This Week's Magazine
Engen Driver Wellness, the mobile health awareness initiative, continues to make a tangible difference to the lives of the country’s bulk truck operators with increased driver participation in voluntary screenings and improved health scores. Now in its fifth year,...
BUSINESS LEADERS PANEL Adam Craker, Ivor Chipkin, Alan Hosking and Allon Raiz at the 6th IQ Business Active Growth conference
At the sixth IQ Business conference held in Sandton last month, a panel of business leaders and academics advocated that business reclaims the initiative to spur growth in South Africa amid fragmented and haphazard political direction. Management consulting firm IQ...
The building industry is an essential component of the South African economy as it contributes about 15% to the gross fixed investment that drives the economy. However, with the country’s economy going through a tough time currently, this, in turn, reflects on the...
The recipients of the 2015 South African National Energy Association (Sanea)/South African National Energy Development Institute Energy (Sanedi) Awards were announced at a ceremony and banquet in Sandton last month. Sanea chairperson Brian Statham named Exxaro CEO...
ASHER BOHBOT EOH’s corporate goals were originally aspirations, but the company is relevant and is making a difference in the territories it operates in
As South African information technology (IT) firm EOH posted another full year of strong growth, CEO Asher Bohbot, known for his frank words, people-centric management style and stoic humanism, attributed the company’s continued South African and African growth to...
Alert Close
Embed Code Close
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
Engineering News
Completely Re-Engineered
Experience it now. Click here
*website to launch in a few weeks
Subscribe Now for $96 Close
Subscribe Now for $96