Related Solutions
Many enterprises suffer from data mart sprawl as individual departments seek dedicated support for specific analytics and reporting purposes. A staggering 35%-70% of data mart costs are unnecessary according to research by Gartner. Consider that 20-45% of any data mart is stored elsewhere, and utilization of data mart server machines is often well below 10%. This results in overly complex data architectures that incur extra costs for duplicate data, unnecessary effort to replicate and load data, underutilized hardware, and multiple versions of the truth.
With its unique PlexQ architecture, Sybase IQ offers a different approach that bands together physical servers into virtual groups that can be dedicated to certain users or processes. Logical Servers within a PlexQ grid allow IT staff to create many virtual data marts on one physical grid. Each Logical Server can have its own set of compute resources, separate data if so desired, and separate security. The performance of each virtual data mart is not impacted by any others on the grid. This isolates the impact of different analytic workloads, ad hoc queries, and users from each other.
Virtual data marts have all of the benefits of a physical data mart while reducing overall data mart costs by up to 70% by eliminating duplicate data, simplifying maintenance, and reducing hardware and software costs. Furthermore, each virtual data mart can access any of the data on the grid, if given permission, and additional compute resources can be dynamically reassigned as workloads change. In essence, Sybase IQ with PlexQ technology allows you to:
- Simplify your EDW architecture
- Eliminate redundant data marts
- Quickly scale resources as demand grows
- Reduce IT administration burden
|
Support many user groups 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
