|
|
Survey results
These
results are based on 120 complete answers collected between Feb. 8, 2005 and
Mar. 12, 2005. This
survey has been sponsored by Emic Networks. |
1. What industry is your organization in? |
|
|
Telecom |
16% |
|
eCommerce |
10% |
|
Financial services |
13% |
|
Computer Hardware/Software |
37% |
|
Consulting |
11% |
|
Publishing |
3% |
|
Retail |
3% |
|
Pharmaceuticals |
1% |
|
Education |
9% |
|
Government |
2% |
|
None (indidivual,
student, etc) |
8% |
2. What country are you located in? |
|
|
US & |
30% |
|
EMEA |
36% |
|
Other |
34% |
3. Are you currently using C-JBDC? |
|
|
Yes |
18% |
|
Not using at this time/not
planning to use |
7% |
|
Considering using |
60% |
|
Will start to use |
14% |
|
Will stop using |
1% |
4. Is your use? |
|
|
Production |
23% |
|
Evaluation using an
existing application or application data |
28% |
|
Evaluation for a new
application |
23% |
|
Testing |
14% |
|
Just kicking the tires |
2% |
|
Lab |
5% |
5. Who will the users of your application be? Check all that apply? |
|
|
Internal |
44% |
|
Customers |
88% |
|
Partners |
22% |
|
Suppliers |
9% |
|
Others |
6% |
6. What features are you most interested in?
|
|||||
|
|
No Interest |
Some Interest |
Moderate Interest |
Significant Interest |
Critical to me |
|
1. Availability |
3% |
2% |
6% |
20% |
69% |
|
2. Performance
scalability |
3% |
4% |
13% |
32% |
49% |
|
3. Database
independence |
9% |
14% |
23% |
21% |
32% |
|
4. Transparency (no
modification to existing applications) |
4% |
10% |
14% |
33% |
39% |
|
5. Heterogeneity
support (multiple database engines in the same cluster) |
27% |
29% |
21% |
12% |
11% |
|
6. Caching |
5% |
20% |
39% |
18% |
19% |
|
7. SQL execution
profiling |
12% |
17% |
45% |
21% |
5% |
|
8. Text console |
17% |
18% |
39% |
19% |
7% |
|
9. Graphical console |
17% |
21% |
33% |
16% |
13% |
|
10. Manageability
through JMX |
14% |
18% |
28% |
27% |
14% |
|
11. Tunable
replication (partitioning, partial replication, full replication) |
1% |
4% |
16% |
43% |
35% |
7. What operating system and JDK are you using for the application server? Check all that apply |
|
|
Linux |
85% |
|
Windows |
50% |
|
Solaris |
17% |
|
MacOS X |
7% |
|
Other operating system |
9% |
|
JDK 1.3 |
6% |
|
JDK 1.4 |
74% |
|
JDK 1.5 |
52% |
8. What platform are you using for your database server? Check all the apply |
|
|
Linux |
86% |
|
Windows |
40% |
|
Solaris |
19% |
|
MacOS X |
4% |
|
Other operating system |
10% |
9. What technology is used by your client applications? Check all that apply |
|
|
POJO (Plain Old Java
Objects |
55% |
|
JBoss |
35% |
|
JOnAS |
17% |
|
WebSphere |
8% |
|
WebLogic |
10% |
|
Other J2EE |
15% |
|
Tomcat |
62% |
|
Jetty |
15% |
|
Resin |
10% |
|
Hibernate |
39% |
|
PHP |
14% |
|
Perl |
5% |
|
Ruby |
0% |
|
Python |
4% |
|
JDO |
5% |
|
Other |
15% |
10. What is your average ratio of reads/writes? |
|
|
Greater than 80% reads |
36% |
|
About 60-80% reads |
42% |
|
About 50% reads |
13% |
|
MacOS X |
9% |
|
Less than 50% reads |
100% |
11. What is your database size? |
|
|
<100MB |
9% |
|
100MB-1GB |
30% |
|
1-10GB |
24% |
|
50-150GB |
23% |
|
>150GB |
3% |
12. What is the number of tables in your database? |
|
|
<10 |
5% |
|
11-50 |
37% |
|
51-100 |
27% |
|
101-500 |
27% |
|
>501 |
3% |
13. How many machines do you have (or plan to have) in your database cluster? |
|
|
1-2 |
29% |
|
3-4 |
50% |
|
5-8 |
10% |
|
>8 |
10% |
14. Do you use Stored Procedures in your application? |
|
|
Yes |
50% |
|
No |
50% |
15. Do you use Transactions in your application? |
|
|
Yes |
84% |
|
No |
16% |
16. Do you use Views in your application? |
|
|
Yes |
63% |
|
No |
37% |
17. Do you use Triggers in your application? |
|
|
Yes |
49% |
|
No |
51% |
18. What is the maximum query latency your application can tolerate? |
|
|
10 seconds or over |
4% |
|
Between 5-9 seconds |
15% |
|
Between 1-4 seconds |
33% |
|
Between 500-999
milliseconds |
22% |
|
Between 100-500
milliseconds |
20% |
|
Under 100 milliseconds |
7% |
19. What is your peak throughput in queries/minute? |
|
|
<100 |
13% |
|
100-1,000 |
39% |
|
1,001-10,000 |
35% |
|
10,001-100,000 |
10% |
|
100,001-500,000 |
1% |
|
>500,001 |
3% |
20. What type of data replication are you using? |
|
|
Partial Replication |
27% |
|
Full Replication |
63% |
|
Partitioning |
10% |
21. How many database clusters do you have (or plan to have)? |
|
|
1 cluster |
41% |
|
2 clusters |
34% |
|
3 clusters |
10% |
|
>3 |
14% |
22. What database are you using or will you use? Check all that apply if you will be using more than one. |
|
|
MySQL |
48% |
|
SAP DB/MySQL
MaxDB |
9% |
|
PostgreSQL |
63% |
|
Cloudscape/Derby |
10% |
|
HypersonicSQL |
17% |
|
McKoi |
3% |
|
Firebird |
10% |
|
DB2 |
15% |
|
Oracle |
51% |
|
Sybase |
12% |
|
Microsoft SQL Server |
23% |
|
Other |
7% |
23. Rank the following as features you might require:
|
|||||
|
|
No Interest |
Some Interest |
Moderate Interest |
Significant Interest |
Critical to me |
|
1. ODBC driver (PHP,
.Net support) |
48% |
19% |
15% |
7% |
11% |
|
2. Distributed joins |
9% |
22% |
32% |
23% |
13% |
|
3. Updatable ResultSets |
17% |
23% |
21% |
28% |
10% |
|
4. JDBC 3.0 extensions
|
6% |
20% |
32% |
27% |
16% |
|
5. Stored procedures
with IN/OUT parameters |
25% |
22% |
24% |
18% |
12% |
|
6. Row level locking |
9% |
14% |
28% |
25% |
25% |
|
7. Reconciliation of
cluster partitions in WAN environments |
22% |
25% |
22% |
13% |
19% |
|
8. Better
documentation |
3% |
11% |
29% |
29% |
28% |
|
9. Integration of
database native tools for backup/recovery |
8% |
18% |
27% |
26% |
20% |
|
10. Hardware resources
monitoring |
12% |
23% |
32% |
21% |
12% |
|
11. Packaging/certification
for specific databases |
23% |
28% |
31% |
13% |
5% |
|
12. Support for table
partitioning (splitting a table on several nodes) |
14% |
22% |
31% |
20% |
13% |
24. What kind of support services do you need? Check all that apply. |
|
|
No support required,
in-house expertise |
40% |
|
Free community mailing list |
74% |
|
Configuration/Design/Deployment
specific support |
25% |
|
1st level support |
18% |
|
Development/3rd level
support |
14% |
|
C-JDBC/Database combined
support |
18% |
|
Other |
3% |
25. What kind of support services do you need? Check all that apply. |
|
|
Custom development (application/database
specific, automated administration, …) |
18% |
|
End-to-end support
(Apache/PHP/J2EE/C-JDBC/Database) |
17% |
|
Training |
27% |
|
Consulting |
30% |
|
Tuning |
44% |
|
Certification/Validation |
15% |
|
None |
24% |
|
Other |
2% |
26. What’s your overall opinion of C-JDBC? |
|
|
Love it |
21% |
|
Like it |
52% |
|
It’s OK |
17% |
|
Didn’t like it |
1% |
|
Would like it if it had
some more features/services |
9% |