Gartner Details a Thriving EDW Segment - TDWI
Finally, Gartner charts another intriguing niche player — SAND Technology, which is hardly a DW newcomer. Thanks to the growing popularity of columnar databases, however, Sand is enjoying a surprising surge in popularity.
SAP INFO: Powerful Corporate Memory: Data management using nearline storage
Nearline storage systems are a type of midway house between a relational online database and an offline archive. The data stored in these systems can be called up very quickly without impacting on the database. A special type of data storage compresses the storage volume, allowing queries to be processed more quickly and cut costs.
SAP INFO: Dieting for Databases: ENTEGA Service uses nearline solution from SAND to store SAP data
By Roland Markowski
ENTEGA Service is channeling its growing data volumes in SAP NetWeaver Business Intelligence with a nearline storage solution from SAND Technology. The german company uses the solution to store all data that is not immediately required, but which still needs to be accessible for audit purposes. As a result, the database stays lean while storage costs and run times for queries and backups are reduced.
The Next Generation of Enterprise Data Warehousing
By Jürgen Haupt, SAP AG, Regional Implementation Group (RIG), EMEA and Dr. Michael Hahne, SAND Technology
Recent technological developments have made it possible to overcome – or in the cases where the data explosion has not yet “hit”, to proactively avoid – the challenges described above. Specifically, SAND Technology, an SAP® Software Partner, has successfully integrated SAND/DNA 2.3 with SAP NetWeaver BI as a nearline storage component. The SAP Certified Integration of SAND/DNA enables customers using SAP NetWeaver BI to implement an efficient nearline repository that can keep massive volumes of less frequently used data (as held in DataStore Objects in the Data Acquisition layer and the Data Propagation layer of the EDW) in a tiny footprint, in a format that permits rapid, easy access. Based on practical experience in the production environments of several customers using SAND/DNA with SAP NetWeaver BI (both with SAP Business Information Warehouse Release 3.1/3.5 and with SAP NetWeaver BI 7.0), it is realistic to expect between 85% and 95% compression, depending on InfoObject type, data volume and data diversity.
Near-Line Storage Keeps Static Data Available - SAP NetWeaver Magazine
By Michael Hahne
Near-line components allow the data warehouse to scale cost-effectively to hold many TB — even petabytes (PB) — of accessible data. However, near-line data storage doesn’t necessarily replace archival storage. For one thing, it may not qualify as a compliance-certified “point of record” creation for original data (see “Meeting Compliance Regulations” below). In some cases, the data stored in near-line storage is not in its original form, but is a representation or transformation of the original data. You still need archival, certified storage to keep the originals and to guarantee the retention of old data that you’re unlikely to ever require for reporting or analysis again. In these cases, it’s appropriate — and may be less expensive — to use archival storage instead of near-line storage.
Data warehouse for AOL Germany built on SAND
By Hannah Smalltree
Every night, the different source systems push data to a staging area. An extract, transform and load (ETL) tool with embedded data quality checks (from Lexington, Mass.-based Ab Initio Software Corp.) then delivers cleansed data to the SAND Analytic Server. From there, Türling’s team uses a layer of front-end analysis tools, such as Business Objects and SPSS, to create rich customer profiles and support marketing campaigns. Creating enriched customer profiles with accurate, up-to-date and complete data has enabled sophisticated segmentation and propensity modeling, Türling said.
Techworld.com - Ninety percent data compression at VW - and it’s not de-dupe
The ability of SAND/DNA to compress selected data to an extremely high degree (approximately 90 percent on average) while making it available for use in reporting or as the basis for new DataStore objects or InfoCubes was the key factor in Volkswagen Financial Services’ decision. The low total cost of ownership, due to the need for far less administrative support as compared with standard archiving solutions, was also very appealing.
Volkswagen to Implement SAND/DNA Storage for SAP - TMCNet
By David Sims
The first customer worldwide to use the newest version of the SAP NetWeaver product, Volkswagen Financial Services, chose SAND/DNA for what SAND officials describe as “maximum nearline functionality enabling the company to store and effectively manage its rapidly growing volumes of data.”
NCR Exits the Data Warehouse Market: See You Later, Teradater? | ZDNet.com
By Joshua Greenbaum
Finally, there’s the third way, data archiving. One of the smarter ways to save a bundle on the Teradata model is to off-load your non-essential data warehouse data (i.e. most of it, in most cases) into an archival system that, if well-designed, can be orders of magnitude cheaper and easier to manage as well. One good example of this is SAND Technology’s data-archiving solution. Again, the watchwords are faster, better, cheaper. And, in this case, SAND offers a reasonable solution to the sanitary landfill problem: dump the data in a cheap and highly acessible archive, and at a minimum stop paying the big bucks to store information you may never need to user.
SAP INFO: From 650 to 25 GB in One Go: RI Solution moves SAP data to nearline store:
By Michael Hahne
The IT service provider RI Solution GmbH has achieved a compression rate of 96 percent for its data in SAP NetWeaver Business Intelligence. Thanks to nearline storage, the company is saving on archiving costs and at the same time has lower administration expense. In addition, users can access InfoCubes and PSA objects without any loss in performance.