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

    Sybase Enhances Mobile Database

    By
    Lisa Vaas
    -
    June 23, 2003
    Share
    Facebook
    Twitter
    Linkedin

      Sybase Inc. subsidiary iAnywhere Solutions Inc.s latest update of SQL Anywhere Studio will bring sophisticated technologies to the small devices that run the mobile database.

      SQL Anywhere Studio 9, unveiled on Monday, includes XML import and export capabilities, SQLx functionality, and HTTP server and SOAP support that enable the creation of database-powered Web services. It is also picking up support for Mac OS X and 64-bit Itanium platforms, officials said.

      Performance has been polished, with a new Index Consultant feature that guides administrators through index selection and thereby eases performance optimization. New query processing algorithms also enable many complex queries to run quicker. Other performance upgrades include an advanced cache management system that improves concurrency and scalability for environments that have hundreds of simultaneous users.

      iAnywhere, of Dublin, Calif., also targeted developer productivity with SQL Anywhere Studio 9. Some features aimed at that group include server-initiated synchronization, faster synchronization speeds and other new synchronization features that are designed to give developers greater flexibility in designing enterprise applications for deployment in wired, public wireless and Wi-Fi environments.

      Another goodie meant for developers is the introduction of UltraLite Dynamic SQL for mobile devices, a feature designed to ease the work of SQL programmers who are developing for that arena. Support for advanced SQL functionality includes OLAP features such as ROLLUP and RECURSIVE UNION queries. Enhancements to graphical administration tools include a query editor, integrated stored procedure debugger, profiler and synchronization monitoring tool.

      Larry Trainer, vice president of engineering at Shelflink Inc. and a beta tester, found quite a few features of the update appealing. One such feature is support for Microsoft Corp.s .Net Framework and .Net Compact Framework. The .Net Compact Framework application enables access to iAnywheres Adaptive Server Enterprise—a process that, prior to this release, required developers to write their own interface.

      That will save Trainer and his company a good four or five weeks, the time it took to build Shelflinks original access layer. “It will certainly be a piece of software we can take advantage of out of the box rather than having to design our own [interface],” said Trainer, in Cambridge, Mass.

      The updates new language support for SQL also carries great weight with Shelflink. The enhanced support will enable dynamic queries, an important feature to have when input is unknown ahead of when Shelflinks engineers write queries. “We allow flexibility into the application where we can call into a database stored procedures and change that value on the fly,” Trainer said. When sorting on a grid, for example, a sort value can be passed and a query built and executed on the fly, without the need to prewrite, he said.

      Another “huge” element of the update is improved performance, Trainer said. His company develops for Pocket-PC-based devices, where cramming information in is always a problem. The Index Consultant in SQL Anywhere Studio 9 is a key benefit in this regard, as it allows users to tune database queries so they use the appropriate indexes. “If you design a database, its hit or miss whether you hit indexes or have the right ones,” he said. “This will help you figure out whether you have the right ones on the database. Thats an extremely helpful tool to have, and its built right into the product.”

      SQL Anywhere Studio 9 will be available on Windows this fall and on Mac OS X and Unix by years end, priced at $399. It ships with a single deployment license for another $119.

      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
      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
      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
      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.

      ×