Related Solutions
Many enterprise data warehouses (EDWs) are not delivering their promise to be the central store of an enterprise?s data. In fact, Gartner research indicates that over 70% of enterprise data warehouses serve only the needs of a specific department. This places a huge limitation on the benefits enterprises are gaining from their expensive data warehouse investments.
The problem is that the performance of current EDW solutions suffer badly under concurrent, mixed workloads. Yet supporting multiple workloads is fundamental to the role of the data warehouse as a central repository accessed across the enterprise!
Enterprises have been overcoming these limitations by creating complex infrastructures that are expensive to build and maintain. In some cases, enterprises are building mirror data warehouses that synchronize together, essentially doubling their IT costs. In other cases, enterprises are offloading access to local data marts, unnecessarily investing in additional servers that can store duplicated data.
With its unique PlexQ architecture, Sybase IQ offers a different approach that will reduce IT investment by replacing complex EDW and data mart architectures with an elastic grid of analytics servers. With PlexQ IT departments can support many workloads on a single grid, dynamically adding, removing, and reassigning resources as required. As a result IT departments can:
- Simplify EDW architecture
- Eliminate redundant data marts
- Quickly scale resources as demand grows
- Reduce IT administration burden
|
Support many workloads on a single grid
|
- Grid nodes can be grouped into logical server groups isolating workloads from each other
- Create separate logical servers for different users, groups, applications or for data loading
- Single query can span multiple nodes and disks using Distributed Query Processing (DQPTM)
- Workloads are automatically balanced within logical server maximizing concurrent access
|
|
Add, remove, reassign server resources
|
- Shared-everything architecture decouples compute resources from data storage
- Easily add, remove or reasign nodes within and across logical servers
|
|
Control access to sensitive data
|
- Place sensitive data in separate DBSpaces with controlled access
- Assign different user groups to different logical servers
- Authenticate using IQ user security features or with single sign-on using Kerberos systems
- FIPS 140-2 certified, AES compliant encryption of columns, tables, or entire database
|
|
Simplify data management
|
- Reduce DBA tasks to one central database
- Independent scale out of compute and storage
- Scale out compute nodes or data storage without re-tuning queries
- Integrated, browser-based administration and monitoring
|
|
Integrate data from across the organization
|
- Accelerate data loading with grid-based multi-table parallel loads
- Load data using Extract, Transform, Load (ETL) or Extract, Load, Transform (ELT) methods
- Replicate data directly into Sybase IQ from ASE, Oracle, DB2, or Microsoft SQL Server databases
|
|
Consolidate with discipline using information architecture models and metadata management
|
- Establish a single version of key information assets
- Implement data governance best practices by managing the flow of information between all phases of IT and Business
- Capture, articulate manage and share all levels of metadata
- Provide consistent information, when and where needed, to improve decision making
- Enforce governance and accountability for key information assets in support of compliance
- Enable information to be shared and exchanged, with appropriate safeguards
|
Sybase?s product offerings for virtual data marts include:
Learn More
Back to Top
