Cache Database: Introduction to a New Generation Database

Transcription

1 Cache Database: Introduction to a New Generation Database Amrita Bhatnagar Department of Computer Science and Engineering, Birla Institute of Technology, A 7, Sector 1, Noida UP Abstract -- This paper explores a new generation database i.e. cache database. Cache is a new generation of ultra-highperformance database technology. It combines an object database, high-performance SQL, and powerful multidimensional data access all of which can simultaneously access the same data. Data is only described once in a single integrated data dictionary and is instantly available using all access methods. Cache provides levels of performance, scalability, rapid programming, and ease of use unattainable by relational technology. The objective of this paper is to discuss features & benefits of cache database. Keywords: Unified data architecture, Multidimensional data engine, Traditional bit map indexing. I. INTRODUCTION TO CACHE EARLY in the process of designing a new application, developers must decide upon their approach towards data modeling. For most, this comes down to a choice between the traditional modeling of data as relational tables and the newer approach of modeling as objects. Faced with the need to handle complex data, many developers believe that modeling with objects is a more effective approach. When first introduced in the late 1960s, object technology was revolutionary. By the late 1980s it was becoming mainstream, for good reasons. Not only did it simplify interface development, it provided a more flexible and capable way to deal with data that fundamentally changed the way applications are built. Instead of representing data in rigid tables the way relational databases do, object technology describes data in terms of classes. An object is an instance of a class in the same way that a specific oak tree is an instance of the class of oak trees. Object technology contributed the concept of inheritance, allowing classes to be arranged hierarchically. The class of oak trees could inherit data structures and behaviors from the more general class of trees. Object technology maps well to the way we see the world, and OO languages proved to be more versatile in most areas of programming. They brought programming languages closer to natural language and dominated thinking in most areas of software development. OO was referred to as the new paradigm and its influence stretched far and wide. Cache is a new generation of ultra-high-performance database technology. It combines an object database, high-performance SQL, and powerful multidimensional data access all of which can simultaneously access the same data. Data is only described once in a single integrated data dictionary and is instantly available using all access methods. Cache provides levels of performance, scalability, rapid programming, and ease of use unattainable by relational technology.intersystem develop this software. But Cache is much more than a pure database technology. Cache includes an application server with advanced object programming capabilities, the ability to easily integrate with a wide variety of technologies, and an extremely highperformance runtime environment with unique data caching technology. Cache, data can be simultaneously accessed as objects, relational tables, and multidimensional arrays. II. OF CACHE Caché Data Server Features: When it comes to transaction processing, performance is critical. Caché s data server technology lets you scale applications up to serve tens of thousands of users without sacrificing speed. Multidimensional Data Engine All data is stored in sparse multidimensional arrays that eliminate the processing overhead related to the joins common to relational databases. Multidimensional Data Engine High performance. Massive scalability. Realistic modeling of complex data. Efficient data storage consumes less disk space, and requires less hardware. 28

3 Allows Caché to access data from relational databases. COM Gateway Allows Caché applications to use COM objects. High performance link to the popular GUI development tool, Visual Basic. Reduces application-server to database-server network traffic by creating shared data caches on the middle tier of distributed architectures. Connectivity to data stored in relational databases. COM Gateway Enhanced flexibility for Caché applications. Better integration with Microsoft products. Enables rapid GUI development. Dramatically increases the scalability and performance of thin-client systems. Cache Web Features When it comes to enabling the creation of sophisticated highperformance Web applications, Caché is in a class by itself. Caché Web technology brings all the capabilities of Caché to the demanding environment of the Internet, where rapid development and adaptability are as important as database speed and scalability. Automatic XML Mapping Caché can automatically generate XML documents and their corresponding DTD s or XML schemas from Caché classes. Web Services Wizard Allows any Caché method to be published as a Web Service. Caché automatically generates the WSDL descriptor and, when the service is invoked, responds with SOAP-formatted XML. Caché Server Pages Caché Server Pages reside and execute on the Caché data server, taking advantage of speedy intra-process communications. Connection to the Web server is made using fast standard APIs. Caché Application Tags Caché Application Tags execute functions on the Caché data server and/or the browser. They can be incorporated into Caché Server Pages using any text editor or off-theshelf Web page creation tool. Caché Application Tags are extensible, so they can be custom-built to fit the needs of any Web application. Automatic XML Mapping Rapid development of XML-compatible applications. XML enables application to application data sharing. Web Services Wizard Allows sharing of functionality over a network. Enables the integration of legacy applications. Caché Server Pages High-speed Web access, compatible with all major Web servers. Boosts performance and scalability by offloading business logic processing to the powerful Caché data server. Centralized application logic enables fast and easy application changes. Caché Application Tags Fast Web application development. Components are reusable, and developers can work with familiar tools. Promotes cooperative Web design i.e.: Web page designers craft the screens through which users will navigate; application programmers code the tags that give the pages functionality. 30

4 CACHE DATABASE Hyper-Events Hyper-events allow events occurring on a browser (mouse clicks, mouse movements, field value changes, timeouts, etc.) to invoke server-side operations and to update the current page without repainting it. Caché Web Form Wizard Automatically generates ready-to-run HTML forms from Caché Object classes. Hyper-Events Browser events can trigger database responses without waiting for a page to be submitted. Web applications are much more interactive and responsive. Caché Web Form Wizard Rapid Web development. Applications are instantly Webenabled. 20X Faster SQL IN CACHE Customers who switch to Caché from relational databases report that their average performance is up to 20 time faster, running on the same hardware, with no changes to the application. What is it about Caché that lets applications run so fast? Multidimensional Data Engine: Caché stores data in the form of multidimensional arrays instead of in a series flat tables. Data stored in a multidimensional structure is, by definition, already cross-referenced by as many parameters as the programmer chooses. It is possible to access or update data in a multidimensional database without performing the complicated and time consuming joins required by relational database systems. Processing overhead is greatly reduced, so applications run much faster. Intersystem makes the multidimensional data engine even more efficient by employing the concept of sparse arrays. Null cells within the Caché database do not take up any disk space. Less time is required to search for data or load it into local memory, because there are no empty data cells. Transactional Bit-Map Indexing : In a bit-map index, a property of a class (column of a table) is described by an array of bits: for every possible value there is a string of bits representing each object in the class (row in the table). The bit is 1 if the object has that property value, 0 if it does not. The advantage of bit map indexes is that complex queries can be processed by performing Boolean operations (AND, OR) on the indexes creating a temporary index that says exactly which instances (rows) fit the query conditions, without searching through the entire database. Although bit-map indexes are known to significantly improve complex query response, they traditionally have been slow to build, and thus too cumbersome to use in anything other than data warehousing applications. However, Cache s new bit-map indexing capability is nimble enough to use even with rapidly changing transactional data. Enterprise Cache Protocol: InterSystems Enterprise Cache Protocol (ECP) can increase application performance in distributed systems. It is optimized for the thin-client architectures that are most commonly used today. When information is requested across the network, the reply data package includes not only the desired piece of data, but also the entire database block where that data was stored. The natural data relationships inherent to objects and Caché s multidimensional data model make it likely that this extra data is related in some way to the original request. The extra data is cached on the application server, where it is available to satisfy subsequent requests from the client, or in fact from any client connected to the application server. ECP automatically takes care of maintaining database locks, propagating changes back to the data server, etc. The performance and scalability benefits of ECP are dramatic. Clients enjoy faster responses because they frequently use locally cached data. And network traffic is greatly reduced, so any given network can support many more application servers and clients. ADVANTAGES OF CACHE DATABASE Performance Scalability Rapid Development Cost effectiveness flexibility faster SQL response compatibility with existing tools simplified maintenance APPLICATION OF CACHE DATABASE Health care Applications Web Applications Financial Applications Telecommunication Government 31

INTERSYSTEMS CACHÉ AS AN ALTERNATIVE TO IN-MEMORY DATABASES David Kaaret InterSystems Corporation INTERSYSTEMS CACHÉ AS AN ALTERNATIVE TO IN-MEMORY DATABASES Introduction To overcome the performance limitations

Page 1 de 9 What Is the Java TM 2 Platform, Enterprise Edition? This document provides an introduction to the features and benefits of the Java 2 platform, Enterprise Edition. Overview Enterprises today

4D and SQL Server: Powerful Flexibility OVERVIEW MS SQL Server has become a standard in many parts of corporate America. It can manage large volumes of data and integrates well with other products from

the Availability Digest Raima s High-Availability Embedded Database December 2011 Embedded processing systems are everywhere. You probably cannot go a day without interacting with dozens of these powerful

Jitterbit allows you to easily integrate Microsoft Dynamics CRM with any cloud, mobile or on premise application. Jitterbit s intuitive Studio delivers the easiest way of designing and running modern integrations

Managing Big Data with Hadoop & Vertica A look at integration between the Cloudera distribution for Hadoop and the Vertica Analytic Database Copyright Vertica Systems, Inc. October 2009 Cloudera and Vertica

Rapidly build, test and deploy Web, Web services and Java applications with an IDE that is easy to learn and use IBM Rational Web Developer for WebSphere Software Version 6.0 Highlights Accelerate Web,

COMP 378 Database Systems Notes for Chapter 1 of Database System Concepts Introduction A database management system (DBMS) is a collection of data and an integrated set of programs that access that data.

www.raima.com Scott Meder Senior Regional Sales Manager scott.meder@raima.com Short Introduction to Raima What is Data Management What are your requirements? How do I make the right decision? - Architecture

4D and Oracle: Powerful Flexibility OVERVIEW Oracle has become a very pervasive product throughout corporate America. It is an extremely strong tool for managing large volumes of data in a high-transaction

Product Brochure Actuate e.report Designer Professional Actuate e.report Designer Professional is a powerful development environment with which professional developers create tightly integrated, highly

Qint Software - Technical White Paper Improved Reporting and Document Generation via Object-Oriented Data Access and Enterprise Information Integration Objects do not only change the way in which we develop

LABVANTAGE Architecture 2012 LABVANTAGE Solutions, Inc. All Rights Reserved. DOCUMENT PURPOSE AND SCOPE This document provides an overview of the LABVANTAGE hardware and software architecture. It is written

CASE STUDIES IN PERFORMANCE Executive Summary The best way to compare the performance of database products is in a head-to-head test using a real application, preferably one of your own. This is especially

ORACLE DATABASE 10G ENTERPRISE EDITION OVERVIEW Oracle Database 10g Enterprise Edition is ideal for enterprises that ENTERPRISE EDITION For enterprises of any size For databases up to 8 Exabytes in size.

4D as a Web Application Platform 4D is a powerful, flexible, and very scalable Web application platform. This white paper examines the common requirements for Web application servers, and discusses the

Jet Data Manager 2012 User Guide Welcome This documentation provides descriptions of the concepts and features of the Jet Data Manager and how to use with them. With the Jet Data Manager you can transform

Part I EAI: Foundations, Concepts, and Architectures 5 Example: Mail-order Company Mail order Company IS Invoicing Windows, standard software IS Order Processing Linux, C++, Oracle IS Accounts Receivable

Using DataDirect Connect for JDBC with Oracle Real Application Clusters (RAC) Introduction In today's e-business on-demand environment, more companies are turning to a Grid computing infrastructure for

Oracle Net Services for Oracle10g An Oracle White Paper May 2005 Oracle Net Services INTRODUCTION Oracle Database 10g is the first database designed for enterprise grid computing, the most flexible and

Building Web Applications, Servlets, JSP and JDBC Overview Java 2 Enterprise Edition (JEE) is a powerful platform for building web applications. The JEE platform offers all the advantages of developing

Jitterbit allows you to easily integrate Microsoft Dynamics AX with any cloud, mobile or on premise application. Jitterbit s intuitive Studio delivers the easiest way of designing and running modern integrations

Available Online at www.ijcsmc.com International Journal of Computer Science and Mobile Computing A Monthly Journal of Computer Science and Information Technology IJCSMC, Vol. 4, Issue. 2, February 2015,

Data Management for Portable Media Players Table of Contents Introduction...2 The New Role of Database...3 Design Considerations...3 Hardware Limitations...3 Value of a Lightweight Relational Database...4

Open EMS Suite by Nokia Software Development Kit Functional Overview Version 1.3 Nokia Siemens Networks 1 (21) Software Development Kit The information in this document is subject to change without notice

The EMSX Platform A Modular, Scalable, Efficient, Adaptable Platform to Manage Multi-technology Networks A White Paper November 2002 Abstract: The EMSX Platform is a set of components that together provide

ENSEMBLE WHITE PAPER EVALUATING INTEGRATION SOFTWARE INTRODUCTION We created this white paper to help senior IT leaders and business managers who are evaluating integration software. On the following pages

What is Middleware? Application Application Middleware Middleware Operating System Operating System Software that functions as a conversion or translation layer. It is also a consolidator and integrator.