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

    SQL Anywhere Studio Gets Faster

    By
    Timothy Dyck
    -
    December 31, 2001
    Share
    Facebook
    Twitter
    Linkedin

      Organizations looking for a branch-office database and software developers who want to store data in custom applications will find iAnywhere Solutions Inc.s SQL Anywhere Studio 8.0 database an excellent choice. (iAnywhere Solutions is a subsidiary of Sybase Inc.)

      SQL Anywhere is a mature, polished product and offers a lot of sophistication for a database that targets markets where its important to be good enough while staying as small as possible.

      Developers writing applications for laptops or personal digital assistants will find SQL Anywhere a good fit because it runs on many platforms, has both synchronous (network-based) and asynchronous (e-mail-based) data replication options, and comes in several configurations so developers can match the softwares footprint to what it needs to do.

      Mobile database offerings from IBM, Microsoft Corp. and Oracle Corp. are adequate for connecting to these companies server databases. However, SQL Anywhere supports more platforms, offers more communication flexibility and can replicate data with all of these server databases—all at a comparable price.

      SQL Anywhere Studio costs $399 for one user or $999 for 10 users. Client licenses are $119 per concurrent connection or named user, or $149 if the client also uses database replication. UltraLite is free to deploy to unlimited devices, but if users want database replication with UltraLite, that costs $119 per seat (this license is for named users only).

      The update, which went gold Dec. 7, includes several performance enhancements for the database itself and for more efficient communication between client and server systems. Security is tighter, too: This release supports the National Institute of Standards and Technologys new Advanced Encryption Standard for database files and public key-based encryption for network traffic.

      SQL Anywhere runs on Windows and Windows CE, NetWare, and several Unix operating systems. Support for Compaq Computer Corp.s Tru64 Unix is new in this release. UltraLite runs on Palm Inc.s Palm OS, Windows CE, Java 1.1.4 or higher, and Wind River Systems Inc.s VxWorks.

      The software includes Sybases PowerDesigner 8 PhysicalArchitect database modeling and management tool and its InfoMaker 8 reporting tool.

      Fully Equipped Database

      The network server version of SQL Anywhere is competitive with the big players. Those considering Sybases higher-end Adaptive Server Enterprise could do fine with SQL Anywhere (as could Microsoft Corp. SQL Server users).

      ASE and SQL Anywhere are particularly compatible: We ran all of the stored procedures we wrote as part of our ASE benchmark kit as is with SQL Anywhere because it supports the same Transact-SQL language ASE uses. SQL Anywhere also supports Java stored procedures (Java support is separately licensed but is free) and uses ASEs management console.

      SQL Anywheres full-featured Java and T-SQL stored procedure debugger were a big help when we had to figure out why a stored procedure wasnt working. A new profiler allowed us to find slow spots in stored procedures, and a new ability to display graphical query plans made performance-tuning SQL queries simpler (see screen, Page 39).

      The administration tools had some problems—we got a Java error in the Interactive SQL tool, and the administration tool lacked a central folder for managing indexes. We had to visit each affected table in a series to drop a set of indexes.

      West Coast Technical Director Timothy Dyck can be reached at timothy_dyck@ziffdavis.com.

      SQL Anywhere Studio 8

      .0″>

      SQL Anywhere Studio 8.0

      USABILITY

      B

      CAPABILITY

      A

      PERFORMANCE

      B

      INTEROPERABILITY

      B

      MANAGEABILITY

      B

      iAnywhere Solutions SQL Anywhere is an all-around good performer for organizations that need to deploy databases to branch offices or to mobile workers using laptops or PDAs that only connect back to headquarters once or twice a day.

      SHORT-TERM BUSINESS IMPACT // Priority-based replication lets users be connected for less time while still synchronizing key data, lowering communication costs.

      LONG-TERM BUSINESS IMPACT // Deploying sophisticated database engines to mobile users enables them to do more complex analysis tasks without being connected, making them more mobile and better informed.

      PROS: Supports many platforms; sophisticated database engine; very programmable; stronger encryption and more flexible replication; profiler and graphical query plan display.

      CONS: Management tools lack simple ways to administer indexes; some interface bugs.

      Sybase Inc., Emeryville, Calif.; (510) 922-3500; www.sybase.com/products/mobilewireless/anywhere

      Timothy Dyck
      Timothy Dyck is a Senior Analyst with eWEEK Labs. He has been testing and reviewing application server, database and middleware products and technologies for eWEEK since 1996. Prior to joining eWEEK, he worked at the LAN and WAN network operations center for a large telecommunications firm, in operating systems and development tools technical marketing for a large software company and in the IT department at a government agency. He has an honors bachelors degree of mathematics in computer science from the University of Waterloo in Waterloo, Ontario, Canada, and a masters of arts degree in journalism from the University of Western Ontario in London, Ontario, Canada.
      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
      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
      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
      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.

      ×