Click on our Sponsors to help Support SunWorld

Database delirium? Not quite

Plain old databases don't excite our readers,
but Web technologies and Java do

By Carolyn W.C. Wong

SunWorld
May  1996
[Next story]
[Table of Contents]
[Search]
Subscribe to SunWorld, it's free!

Mail this
article to
a friend
Our April survey on databases didn't exactly strike a chord with our readers. While our past survey on readers' plans for Windows NT elicited 341 responses, and our questions on the possibility of a Sun/Apple merger garnered an even more impressive 532 responses, the latest database poll tallied up a measly 55 responses.

92 percent of those who did feel compelled to reply are directly involved in the development or management of a relational, object-oriented, or large flat-file databases. And Oracle still reigns among them. 35 percent say Oracle is the primary engine for transaction-oriented databases at their organizations. Sybase and Informix follow at 21 percent and 19 percent, respectively. The largest transaction database with which they are involved falls in the range of one to five gigabytes (40 percent), and 20 percent develop or manage transaction databases of 20 to 100 gigabytes.

Oracle is also the primary engine for query-style databases (42 percent), while Sybase (19 percent) and Informix (17 percent) again lag behind. 28 percent of these query-style databases are one to five gigabytes, and 23 percent are less than a gigabyte.

According to our readers, Oracle will keep enjoying its success. 56 percent say that the company will see even more success in the coming years. Others who will experience a bright or even brighter future include Microsoft SQL server (52 percent see more success) and object-oriented DBMS vendors (51 percent say such vendors will gain popularity). Who will be less successful? 51 percent say XBase, followed by CA/Ingres (47 percent), DB2 (42 percent), and Sybase and RDB (both 39 percent).

60 percent of the respondents say plans for linking their existing databases to Web servers involve connection to both internal and external 'nets. Three-tier databases will also become important to their companies in the future (48 percent).

But the real changes surrounding databases will be the emergence of new Web technologies and the continued fascination with and implementation of Java. 84 percent believe Web technologies will change the way their organizations' users access databases. 55 percent say new Web technologies have already affected user access. 52 percent of the respondents agree that Java will change the presentation of information in their databases. An overwhelming 94 percent plan to learn more about Java, and 83 percent plan to learn Java or JavaScript programming.

Even though they see Microsoft SQL Server being more successful in the future (perhaps in other companies), our readers aren't examining it seriously themselves now. Only 18 percent are testing or are planning to test it, while 76 percent are not testing it. 13 percent have actually deployed Microsoft SQL Server, and a majority (64 percent) have absolutely no plans to deploy it.

These respondents' organizations are using Solaris 2 on most of their database servers (40 percent) and Windows and Win '95 (58 percent) on their desktops. Only 28 percent have deployed a data warehouse, but 58 percent are in the planning stage.
--Carolyn W.C. Wong


Advertisements

SunWorld Online April 1996 Reader Survey Results

Tell us about your organization's use of databases

Number of respondents: 55
as of 12:00 p.m. on April 29, 1996

  1. Are you involved in the development or management of a relational database, object-oriented database, or large flat-file database?
        Yes:                                              92.2% 
        No:                                                7.8%
    
  2. What is your primary engine for transaction-oriented databases?
        We don't use a transaction-oriented database:      8.3% 
        Access:                                            2.1% 
        CA/Ingres:                                         2.1% 
        DB2:                                               0.0% 
        Empress:                                           0.0% 
        Informix:                                         18.8% 
        Microsoft SQL Server:                              0.0% 
        Object Design:                                     2.1% 
        Objectivity:                                       0.0% 
        Oracle:                                           35.4% 
        Perl (or shell scripts):                           0.0% 
        Progress:                                          4.2%
        RDB:                                               0.0% 
        SAP:                                               0.0% 
        Sybase:                                           20.8% 
        XBase:                                             0.0% 
        Other:                                             6.2% 
    
  3. What is the largest transaction database with which you are involved at your organization?
        less than 1 gigabyte:                             15.6% 
        1 to 5 gigabytes:                                 40.0% 
        6 to 20 gigabytes:                                17.8% 
        20 to 100 gigabytes:                              20.0% 
        more than 100 gigabytes:                           6.7% 
    
  4. What is your primary engine for query-style databases?
        We don't use a query-oriented databases:           0.0% 
        Access:                                            4.2% 
        CA/Ingres:                                         2.1% 
        DB2:                                               0.0% 
        Empress:                                           0.0% 
        Informix:                                         16.7% 
        Microsoft SQL Server:                              0.0% 
        Object Design:                                     2.1% 
        Objectivity:                                       0.0% 
        Oracle:                                           41.7% 
        Perl (or shell scripts):                           4.2% 
        Progress:                                          2.1% 
        RDB:                                               0.0% 
        SAP:                                               0.0% 
        Sybase:                                           18.8% 
        XBase:                                             0.0% 
        Other:                                             8.3% 
    
  5. What is the largest query-style database with which you are involved at your organization?
        less than 1 gigabyte:                             23.4% 
        1 to 5 gigabytes:                                 27.7% 
        6 to 20 gigabytes:                                19.1% 
        20 to 100 gigabytes:                              19.1% 
        more than 100 gigabytes:                           4.3% 
    
  6. How much success do you think each of the following will enjoy in the future?
        CA/Ingres
          More:                                            4.4% 
          Same:                                            4.4% 
          Less:                                           46.7%  
          I don't know:                                   44.4%
    
        DB2
          More:                                            4.4% 
          Same:                                           28.9% 
          Less:                                           42.2% 
          I don't know:                                   24.4% 
    
        Empress
          More:                                            0.0% 
          Same:                                            0.0% 
          Less:                                           22.2%
          I don't know:                                   77.8% 
    
        Informix
          More:                                           42.2% 
          Same:                                           35.6% 
          Less:                                            8.9% 
          I don't know:                                   13.3% 
    
        Microsoft SQL server
          More:                                           52.2% 
          Same:                                           17.4% 
          Less:                                           15.2% 
          I don't know:                                   15.2% 
    
        OO DBMS vendors
          More:                                           51.1% 
          Same:                                           11.1% 
          Less:                                            6.7% 
          I don't know:                                   31.1% 
    
        Oracle
          More:                                           56.2% 
          Same:                                           27.1%
          Less:                                            4.2% 
          I don't know:                                   12.5% 
    
        Progress
          More:                                            4.4% 
          Same:                                            6.7% 
          Less:                                           24.4%
          I don't know:                                   64.4% 
    
        RDB
          More:                                            0.0% 
          Same:                                            4.5% 
          Less:                                           38.6% 
          I don't know:                                   56.8% 
    
        SAP
          More:                                           17.8% 
          Same:                                           24.4% 
          Less:                                           24.4% 
          I don't know:                                   34.1% 
    
        Sybase
          More:                                           22.7% 
          Same:                                           22.7% 
          Less:                                           38.6% 
          I don't know:                                   15.9% 
    
        XBase
          More:                                            2.2% 
          Same:                                            0.0% 
          Less:                                           51.1% 
          I don't know:                                   47.7% 
    
  7. What are your plans for linking your existing databases to Web servers?
        No plans:                                         14.6% 
        Connect to internal intranets:                    22.9% 
        Connect to external intranets:                     2.1% 
        Connect to both internal and external 'nets:      60.4% 
        I don't know:                                      0.0% 
    
  8. Offer your opinions on the following statements:
        Two-tier databases are important to my organization now
          Agree:                                          51.0% 
          Disagree:                                       15.7% 
          Don't know:                                     33.3% 
    
        Two-tier databases will become important to my organization in in the future
          Agree:                                          51.0% 
          Disagree:                                       14.3% 
          Don't know:                                     34.7% 
    
        Three-tier databases are important to my organization now
          Agree:                                          43.1% 
          Disagree:                                       19.6% 
          Don't know:                                     37.3% 
    
        Three-tier databases will become important to my organization in in the 
          future
          Agree:                                          48.0% 
          Disagree:                                        8.0% 
          Don't know:                                     44.0% 
    
        Web technologies will change the way my organization's users access our 
          database(s)
          Agree:                                          84.0% 
          Disagree:                                       10.0% 
          Don't know:                                      6.0% 
    
        Web technologies have already changed the way my organization's users access
          our database(s)       
          Agree:                                          55.1% 
          Disagree:                                       38.8% 
          Don't know:                                      6.1% 
    
        Java will change the way my organization presents information in our 
          database(s)
          Agree:                                          51.9% 
          Disagree:                                       17.3% 
          Don't know:                                     30.8% 
    
        Java has already changed the way my organization presents information in our
          database(s)   
          Agree:                                          16.7% 
          Disagree:                                       64.6% 
          Don't know:                                     18.8% 
    
        I plan to learn more about Java
          Agree:                                          93.9% 
          Disagree:                                        2.0% 
          Don't know:                                      4.1% 
    
        I plan to learn how to program with Java or JavaScript
          Agree:                                          82.7% 
          Disagree:                                        7.7% 
          Don't know:                                      9.6% 
    
        We are testing, or plan to test Microsoft SQL Server
          Agree:                                          18.0% 
          Disagree:                                       76.0% 
          Don't know:                                      6.0% 
    
        We have deployed Microsoft SQL Server
          Agree:                                          12.5% 
          Disagree:                                       79.2% 
          Don't know:                                      8.3% 
    
        My organization has no plans to deploy Microsoft SQL Server
          Agree:                                          64.0% 
          Disagree:                                       22.0% 
          Don't know:                                     14.0% 
    
        My organization is planning a data warehouse
          Agree:                                          58.0% 
          Disagree:                                       26.0% 
          Don't know:                                     16.0% 
    
        My organization has deployed a data warehouse
          Agree:                                          28.0% 
          Disagree:                                       62.0% 
          Don't know:                                     10.0% 
    
  9. Which operating system are you using...
        on most of your database servers?
          Solaris 1/SunOS 4.1.x:                          13.5% 
          Solaris 2:                                      40.4% 
          HP-UX:                                          23.1% 
          AIX:                                             5.8% 
          IRIX:                                            0.0% 
          Digital Unix:                                    0.0% 
          Windows NT:                                      9.6% 
          Novell NetWare:                                  1.9%
          Other:                                           5.8%
    
        on most of your desktops?
          Solaris 1/SunOS 4.1.x:                           8.0% 
          Solaris 2:                                      12.0% 
          HP-UX:                                           6.0% 
          AIX:                                             2.0% 
          IRIX:                                            0.0% 
          Digital Unix:                                    0.0% 
          Windows & Win 95:                               58.0% 
          DOS:                                             0.0% 
          Windows NT:                                      6.0% 
          OS/2:                                            0.0% 
          Macintosh:                                       2.0% 
          Other:                                           6.0% 
    
  10. How many people are employed by your department?
        1 - 9:                                            13.5% 
        10 - 29:                                          15.4% 
        30 - 99:                                          30.8% 
        100 - 499:                                        32.7% 
        Not applicable:                                    7.7% 
    
  11. How many people are employed by your entire organization?
        1 - 9:                                             1.9% 
        10 - 29:                                           3.8% 
        30 - 99:                                           3.8% 
        100 - 499:                                        17.3% 
        500 - 1999:                                       28.8% 
        2000 - 9999:                                      19.2% 
        more than 10,000:                                 25.0% 
        Not applicable:                                    0.0% 
        I don't know:                                      0.0% 
    
  12. Which best describes your primary job duties?
        Systems administrator:                            13.5% 
        Programmer or developer:                          13.5% 
        Network administrator:                             3.8% 
        Database administrator:                           32.7% 
        Systems analyst:                                   3.8% 
        Webmaster:                                         3.8% 
        Consultant:                                       11.5% 
        Systems integrator:                                1.9% 
        Other technical professional:                      3.8% 
        Other manager:                                     7.7% 
        Student:                                           0.0% 
        Other:                                             3.8% 
    


Click on our Sponsors to help Support SunWorld

What did you think of this article?
-Very worth reading
-Worth reading
-Not worth reading
-Too long
-Just right
-Too short
-Too technical
-Just right
-Not technical enough
 
 
 
    

SunWorld
[Table of Contents]
Subscribe to SunWorld, it's free!
[Search]
Feedback
[Next story]
Sun's Site

[(c) Copyright  Web Publishing Inc., and IDG Communication company]

If you have technical problems with this magazine, contact webmaster@sunworld.com

URL: http://www.sunworld.com/swol-05-1996/swol-05-db.results.html
Last modified: