Close
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database

    Hybrid Database Replication Tool Wins Patent

    By
    Lisa Vaas
    -
    November 17, 2005
    Share
    Facebook
    Twitter
    Linkedin

      eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.

      A patent has been granted to WorldSync for its method of gluing together the best of peer-to-peer and centralized database replication.

      WorldSync Inc. makes FileMaker database replication and synchronization tools, the cornerstone technology for which received the patent, the company announced on Tuesday.

      The companys SyncDek tool remotely synchronizes multiple copies of a file. It takes the place of other options such as putting remote offices onto one FileMaker Server and using a VPN (Virtual Private Network) or point-to-point T-1 lines to share the same database.

      The patent applies to SyncDeks bi-directional asynchronous data replication technique for database management and synchronization across a peer-to-peer network.

      Jonathan Spira, an analyst and CEO of Basex Inc. as well as the author of “Managing the Knowledge Workforce,” said that while patents are nice, whats crucial is that WorldSync is one of the companies addressing the need to solve the problem of knowledge workers tapping into outdated—or just plain wrong—information.

      “The importance of file replication … is often overlooked,” he said in an e-mail conversation. “In todays increasingly mobile world, its hard for knowledge workers to share information—and share the latest information.”

      Its a challenge, particularly since vendors who make knowledge-sharing tools have failed to pick up on the example of Lotus Notes, even 14 years later, Spira said.

      “…the companies havent necessarily learned from what Lotus taught us in 1991 with the introduction of Lotus Notes,” which featured replication and synchronization, Spira said.

      But why a patent? Database synchronization and management are nothing new. Progress Software Corp., for example, last month rolled out a line of products called DataXtend that covers heterogeneous database replication and synchronization for mobile users and those with unreliable network connections and includes an enterprise database caching product for distributed applications.

      Jason Erickson, WorldSync CEO, acknowledged that while centralized replication has been represented in prior inventions, as has peer-to-peer replication, WorldSyncs patent protects the methodology that brings together the best of these two methods.

      “Thats pretty momentous for an industry requiring flexible solutions,” he said in an e-mail conversation.

      WorldSync uses a multi-hub-and-spoke architecture, with each unique record owned at only one node, though any node can own unique records, Erickson said.

      When a record is modified by a non-owner, a sync object is created and transmitted to the records owner node for qualification and distribution to appropriate subscribers.

      “Our method provides both single-point consistency in conflict detection, resolution and distribution, but also diverse non-centric data sharing communities,” Erickson said.

      Also, sync objects can be sent and received at any time, he said, providing greater flexibility and fault-tolerance and allowing all nodes to join and exit the network without consequence.

      Before such a technique was invented, either a centralized or peer-to-peer approach was required, he said—each of which has its own issues.

      To wit: While the centralized approach allows for a single point of authority for conflict detection, resolution and distribution, it places high CPU and memory demands on the hub, since they require any shared data to be shared with the hub computer.

      For their part, peer-to-peer approaches can account for disparate data sets at any and all nodes but suffer either from much greater networking demands, as each node must communicate directly with each other node, or from threats to data consistency, as each node makes its own conflict detection and resolution decisions, Erickson said.

      “SyncDek allows any node to own any data and control with whom it is shared, but still enforces a centralized point of authority for data consistency (on a record-level basis),” he said. “This offers both inherent load-balancing advantages and political advantages.”

      Vivek Singhal, vice president of technology for Progress Real-Time Division, said that much of what WorldSync and Progress are doing in terms of data replication are similar.

      /zimages/3/28571.gifCompellent advances remote data replication. Click here to read more.

      Both support P2P networks—which is crucial when mobile databases lack the ability to connect to a central server—and both use replication as opposed to synchronization.

      “Rather than two databases each shipping their entire content to the other guy in order to figure out what data has changed, they instead are keeping track in each database of what have been the changes,” he said.

      “Thats important because a lot of times the bandwidth available to mobile databases is limited. If you can be smart about the amount of data youre sending, thats good. It makes the system more viable.”

      Both companies have also added to those two elements with partitioning and data transformation features.

      Partitioning allows discrete subsections of a database to be sent to various mobile databases, thus allowing for data to go only to those database users for whom its relevant.

      Data transformation allows for central database information to be changed to suit a mobile database. For example, truncating characters in a description field or censoring out Social Security numbers.

      The two products dont compete directly, as WorldSync caters to FileMaker users. Progress caters to the more traditional enterprise databases, such as SQL Server and Oracle.

      Editors Note: This story was updated to include input from Progress and to note that SyncDek also features partitioning and data transformation capabilities.

      /zimages/3/28571.gifCheck out eWEEK.coms for the latest database news, reviews and analysis.

      Lisa Vaas
      Lisa Vaas is News Editor/Operations for eWEEK.com and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on eWEEK.com, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Applications

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×