Red Brick Systems Inc, Los Gatos, California has a data access technology called Gold Mine that, it claims, fundamentally changes the way businesses can use data to perform analysis and make business decisions. Gold Mine is claimed to accelerate the query processing speed of traditional relational database management systems a minimum of 10 times, and enhance the expression capabilities of industry standard Structured Query Language databases. Gold Mine can be implemented in three ways: as a stand-alone server, attached to an existing relational database management system or integrated into future relational databases – it supports existing standards, including relational table structure and SQL, without affecting existing relational database technology, Gold Mine is a software technology that can be implemented on any hardware system that can support a relational database, including IBM mainframes, DEC VAXs and Unix machines. Red Brick has developed a set of SQL extensions called Reduced-Instruction SQL – RISQL – that addresses the difficulty of expressing basic business questions in SQL and provides access to Gold Mine. The extensions embodied in RISQL simplify the composition of queries appropriate to data analysis and decision support. Relational data is often inaccessible because SQL queries are too difficult to compose or too complex to debug and maintain. Reduced SQL off-loads to the server many calculations required for data analysis, improving system performance by eliminating network traffic and cutting application memory and processor needs.
Content from our partners
