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 Information Technology News
JSE-listed Huge Group has moved to reduce the cost of installing router equipment at its customers’ premises through the adoption of newly acquired intellectual property (IP). This emerged as Huge, which provided a full outbound and inbound telephony service over a...
South Africa will join the Worldwide LHC Computing Grid (WLCG) in December. The WLCG processes and stores the immense amounts of data produced by the world's biggest and most powerful particle accelerator, the Large Hadron Collider (LHC), which is an instrument of...
Since the launch of asset management and consumer solutions provider QCIC’s vehicle tracking device QIC-SUR in June 2012, the company has received overwhelmingly positive feedback from the market, says QCIC director Brian McKenzie. “The device has proven to be...
Updated 2 minutes ago JSE-listed African Oxygen (Afrox) on Thursday reported a 4.5% decline in profit for the six months ended June 30, to R169-million, while headline earnings a share were down 10.2% year-on-year to 49.5c. Afrox stated that its results for the first half of 2014 were...
Updated 27 minutes ago Freight and logistics service provider Grindrod was disposing of its financial services arm, Grindrod Financial Holdings, also known as Grindrod Bank, because it was no longer “part of its core strategy”, said CEO Alan Olivier on Thursday. Speaking at the...
Updated 1 hour 30 minutes ago As the public battle over the tolling of Gauteng’s highways continued, with users refusing to pay their bills and the Gauteng Provincial Government reviewing the system, South Africa National Roads Agency Limited (Sanral) CEO Nazir Alli appealed to South Africans...
Recent Research Reports
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...
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.
Real Economy Insight: Road and Rail 2014 (PDF Report)
This six-page brief covers key developments in the road and rail industries over the past 12 months, including details of South Africa’s road and rail network and prospects for both sectors.
This Week's Magazine
The Built Environment unit at the Council for Scientific and Industrial Research (CSIR) has developed a cost-competitive ultrathin concrete pavement surface that, for the upgrading of unpaved roads to paved roads, is more durable than many other pavement alternatives...
The Southern African Large Telescope (SALT), based at Sutherland in the Karoo region in the Northern Cape province, is promising to become an important instrument for research into dark matter. "SALT is shaping up to be very important for answering questions about...
The South African tool, die and mouldmaking (TDM) industry is being revitalised to locally produce the tools, dies, moulds and fixtures required by the manufacturing sector. Local TDM capability is key to enable the manufacturing industry to remain competitive, says...
Misfortune often finds its roots in the smallest of things. Such as a centimetre or two. Or is that in inch? Perhaps a foot? Swedish or Dutch? The French had reason to blush in May as it became apparent that national rail operator SNCF had ordered 2 000 trains that...
The repositioning of the Fibre Processing & Manufacturing Sector Education and Training Authority (FP&M Seta) and its business processes will ensure improved performance in reaching strategic targets and in providing customer service.