March 08, 2007
seeMore makes order out of data chaos
Virtual Database Server gathers multiple databases under one relational roof, accessible via standard interfaces
3 RecommendationsImagine if you will: you are the chief database administrator for a large corporation. Your organization's databases are on different continents, which has never been a problem. What is a problem is that those databases have been written by different divisions, using different database technologies: Oracle here, Sybase there, some Cobol down there, and so on.
[ See also: InfoWorld Technology of the Year Awards Application and Middleware winners ]
You have been charged with providing a single point through which all those databases can be accessed and managed — and no read-only, screen-scraping, funny stuff, either. Your superiors want honest-to-goodness, read/write access to all that data, regardless of its location and structure. Oh, and don't forget security.
Before you descend into full cardiac arrest, I'm happy to tell you that seeMore Technologies may have a solution that can rustle all those wandering databases into a single corral. Welcome to the Virtual Database zone.
Grand central server
SeeMore's Virtual Database Server is sort of like a database Grand Central Station, with you at the master controls. You connect the Virtual Database Server to all your data sources, and it provides a single access point through which database clients interact with those databases. The seeMore server isn't really a database server itself; it is a combination database multiplexer and selector, with ODBC, JDBC, and OLEDB connectors on both input (where the databases connect) and output (where the users/clients connect).
 Click for larger view. |
You can, for example, connect the Virtual Database Server to a Cobol database, thereby enabling an ODBC (or JDBC or OLEDB) client to access that Cobol database as though it were a set of relational tables. The same is true of a CTree database, C-ISAM (indexed sequential access method) database, or even XML and flat file databases. Once you make the data available through ODBC or JDBC, then literally every application or development environment or third-party tool that has anything to do with databases can get at it.
Furthermore, if that Cobol database includes structured items – which would not otherwise map readily to relational rows – seeMore can "flatten" the data structures (creating pseudo-columns in the process) so that SQL queries can digest what would be otherwise indigestible. The result isn't terribly pretty, but the conversion is completely automated and it works.
| Test Center Scorecard | |||||||
|---|---|---|---|---|---|---|---|
 |  |  |  |  |  |  | |
| 20% | 20% | 20% | 15% | 15% | 10% | ||
| seeMore Virtual Database Server version 2.8.0 | 9 | 10 | 9 | 8 | 9 | 9 |
9.1
Excellent
|
White Paper
D2D Virtual Tape Library Replication Primer
This whitepaper explains the terminology and concepts behind Data Replication technologies and establishes some sizing rules through worked examples. Learn the new paradigm in disaster tolerance—protect data anywhere.
Download now »
White Paper
An Alternative to Virtualization for Datacenter Cost Savings
Server virtualization is a popular option for dealing with mounting datacenter costs. Another equally promising approach is the use of an Application Delivery Controller. Citrix NetScaler provides a low-cost way for organizations to reduce their server count and accrue cost savings from a reduction in space, cooling, power and personnel.
Download now »
White Paper
Why Your Firewall, VPN, and IEEE 802.11i Aren't Enough to Protect Your Network
The emergence of WLANs has created a new breed of security threats to enterprise networks.
Included in HP ProCurve WLAN solutions is security technology that alleviates threats from WLANs through:
* Monitoring wireless activity inside and out of the enterprise
* Classifying WLAN transmissions into harmful and harmless
* Preventing transmissions that pose a security threat to the enterprise network
* Locating participating devices for physical remediation
White Paper
Bringing the Edge to the Data Center
Effectively address data protection challenges, implementing solutions that help store and protect business–critical data while cutting costs and improving efficiency and reliability.
Download now »
- How Zscaler Tackles Emerging Web Threats with High Speed, Real-Time Content Inspection in the Cloud | White Paper
- Upgrading to VMware vSphere with vWire | White Paper
- Removing Barriers To Better Server Virtualization Efficiency | White Paper
- Windows Phones and Unified Communications | White Paper
- Lower the Cost and Complexity of a Mobile Workforce through Automation | Webcast
Sign up to receive Data Management Resource Alerts
Make IT work as one. Register for Novell BrainShare 2010. Complimentary Energy Efficiency Kit - Cut Energy Costs NowRestrict internet access with GFI WebMonitor™. Now 30% Off! www.gfi.com/web-filterToday’s IT means business. New eBook shows you how to align your IT investments.A new level of interoperability. Make IT Work As One at novell.comLimited-time offer: Save up to $100 on Polycom phones. 64-page prescriptive guide to security, compliance, and IT operations.Learn about Foundations of Green IT, from CTO Marty Poniatowski802.11n Drives an Architectural EvolutionSee IBM CloudBurst's self-service user interface in action
Return on Information: Google Enterprise Search pays you back. Get the facts.Analytics: Use your data to drive insights that enable better decisions.See how AT&T can help protect your network. Make IT Work As One at novell.comHP ProLiant G6 Servers. Perform like a superstar, Save like an accountant.HP ProLiant G6 Servers. Perform like a superstar, Save like an accountant.Unified Communications: Thoughts, Strategies and Predictions. Join the discussion.Increase UPS efficiency without sacrificing protectionIn less than 45 minutes, Palisade Systems protects your dataA smarter approach to IT is needed. That smarter approach is IBM CloudBurst.
