s**********o 发帖数: 14359 | 1 你去问问是不是SQL SERVER DATABASE的BACKUP,没扩展名么,BAK?最新的版本SQL软
件是什么,SQL是门语言,不是软件,问清楚是什么软件存的吧,别是SYBASE |
|
|
b*****r 发帖数: 239 | 3 As I know, Oracle GoldenGate, Sybase Replication server both support master-
master replication. |
|
M*****r 发帖数: 1536 | 4 informix
sybase
sqlite
also, MPP dbs: netezza/greenplume/vertica/... |
|
y*****g 发帖数: 677 | 5 没放弃。这不还在给大家准备MYSQL的报告嘛。
开发这些数据库的一帮人该死,搞这么多种类,让人学不完。 |
|
p*****u 发帖数: 214 | 6 等oracle说,mysql不再免费了,那你就少一项麻烦 |
|
w*r 发帖数: 2421 | 7 oracle/sqlserver/sybase implement this. Not IBM/Teradata/mysql/informix... |
|
s**********o 发帖数: 14359 | 8 公司就这德行,啥都有,DB2, SYBASE,ACCESS,SSRS, SIEBEL, OBIEE, BO, CRYSTAL
REPORT什么样的REPORT都有,我被重新分组去搞REPORT去了,估计要合并一些REPORT,
淘汰一些系统 |
|
|
s**********o 发帖数: 14359 | 9 被分去了DATA GROUP,有人要我去做DATA MODEL
有人要我去搞REPORTING,其实哪一个摊子都很烂,
DATA MODEL,公司数据多而杂,谁也搞不清楚哪个DATA SOURCE准,LOAD PROCESS是怎
样的,要搞出个标准的MODEL,估计有无数的人要质疑,失败的可能巨大。
REPORING,需要整合很多不同的系统,比如DB2, SYBASE, ACCESS, ORACLE,SSRS,还有
好多跨系统的REPORT,需要整合淘汰,不过也有可能被派去搞OBIEE的EDW,这个肯定会以
失败告终。
我实在就是想混碗饭吃不想卷入政治斗争啊,大家看看我做啥好。 |
|
s**********o 发帖数: 14359 | 10 如果偶公司都不考虑的话,TERA的MARKETING比较危险了,
偶这有ORACLE SQL SERVER DB2 SYBASE MYSQL HADOOP每个
系统都有,没考虑TERADATA
teradata |
|
s******7 发帖数: 350 | 11 在Production环境用了PostgreSQL将近10年,很稳很好用,9以上版本加了不少东西。
如果自己能支持的话,在LINUX上跑PostgreSQL是很棒的。
10年前使用SQL Server和SYBASE ASE.微软的东西大家都知道,入门容易,出事可以找
人。 |
|
s*******e 发帖数: 261 | 12 Oracle
MySQL (or MariaDB)
SQL Server
其他的如Sybase, DB2, etc.
还有大数据
请问各自应用前景如何? 如果有机会,个人往哪个方向走更有前途? |
|
s*******e 发帖数: 261 | 13 Oracle
MySQL (or MariaDB)
SQL Server
其他的如Sybase, DB2, etc.
还有大数据
请问各自应用前景如何? 如果有机会,个人往哪个方向走更有前途? |
|
n****f 发帖数: 905 | 14 因為甲骨文的數據庫比較專業。 功能強大。 我個人認為, 假如用大貨櫃來形容甲骨
文的數據庫, 微軟的SQL可以比成小皮卡。
這不是比較數據的承擔能力, 這是指全方位功能的比較。
Don't know about Sybase, DB2 |
|
m******t 发帖数: 2416 | 15 How do you connect to the Internet? Two possible reasons I can
think of:
1. port is conflicting with some other app.
2. you have different ip addr when you connect to the net.
The second one is more likely. Try ipconfig /all to see what's
your ip when you are connected/disconnected. |
|
y***e 发帖数: 39 | 16 转自: http://www.phpchina.com
PHP是一种没有前途的嵌入式脚本语言。原因是多方面的。
一,PHP缺乏规模支持。与之类似的嵌入语言,一个是ASP,一个是JS
P前者可以通过
Microsoft Windowsd的COM/DCOM获得ActiveX支持,后者可以通过SUN
Java的Java
Class和EJB获得支持
二,缺乏多层结构支持。对于大负荷站点,解决方法只有一个:分布
计算。数据库、应
用逻辑层、表示逻辑层彼此分开,而且同层也可以根据流量分开,组
成二维阵列。ASP
可以通过DCOM和微软的Transcation Server来获得
这种结构支持,JSP可以通过EJB/CORBA以及众多厂商的Application
Server来获得这种
结构支持,但PHP没有这样的条件。
三,PHP极其没有道理地实现了一个混乱的不能统一的数据库接口支
持,比如对Oracle,
MySQL, Sybase的接口,彼此都不一样。这一点让人感觉不可思议,
而且也使它在电子
商务中运用受阻----连PERL都通过DBI而获得一个抽象的数据库接口
!
美国现在电子商务非常流行 |
|
xt 发帖数: 17532 | 17
我一贯使用VI,不过也难怪,我们开发GUI不是直接使用JAVA Frame. 而是做Sybase
Central的plug in.好象没多少人会做. //strut |
|
xt 发帖数: 17532 | 18
Juse Sybase Central Java Ed., then I will tell you how to do
it. :) |
|
xt 发帖数: 17532 | 19
if
Oracle JDBC driver, especially the Oracle:thin driver, is the worst I know
amoungst
major DBMS's. It has many many problems. For example, if you define a CHAR[40]
field
in your schema, then set it to "hello". It works fine if you do a direct SQL
search
for WHERE field='hello'. However if you use JDBC with the very same string,
you will
never get the record back. You have to use "hello" padded with 34 spaces to
get the
record back. Talking about consistency! IMHO, Sybase has the best SQL
comp |
|
xt 发帖数: 17532 | 20
Yes, this is the way we do the job. MS SQL Server has some other
JDBC problems such as stored procedure support etc. The SQL itself
is very similar to Sybase because MS bought their source code. |
|
xt 发帖数: 17532 | 21
Swing is good enough to build simple GUI. You can try Sybase Central.
I wouldn't say it is good enough to write an MS Office. :-) |
|
xt 发帖数: 17532 | 22
It does not have trial version. It comes with Sybase
database products, and is not sold separately. |
|
c**g 发帖数: 274 | 23 The one I am using is 3.2, I guess what I am talking about is
the database management plug-in written by sybase, which is
pretty primitive. I am going to use dbartisan. |
|
xt 发帖数: 17532 | 24
Is that the SC for ASE? I never used it, but I don't think
people in California do good GUI any way. hehe
I used SC for ASA before. It is very handy.
Sybase Central is now a pure Java application. Again, it is only
a viewer. So the quality of GUI really depends on the quality
of the plug-in. |
|
c**g 发帖数: 274 | 25
yes, actually when I used it the first time, I told myself what a
lousy job xt did, for I had this impression that that your company had been
doing java gui for sybase. |
|
xt 发帖数: 17532 | 26
据我所知Sybase是可以通过JDBC建数据库的.DB2肯定可以,因为
现在的db2cc好象是java写的.问题是怎么做你需要他们的doc.
这些doc可能是内部使用的 |
|
xt 发帖数: 17532 | 27
Quit complaining about Sybase. If you like Oracle, you should try
this:
define a table with a field like "foo CHAR(32)"
then use your JDBC to insert a row, set foo to be "hello".
Then use Oracle JDBC driver to retrieve it, with foo='hello'
See what you get.
We have been using JConnect5 all the time, except before
2001. We never had any surprises like this. DB2 has some,
Oracle has some. |
|
xt 发帖数: 17532 | 28
ignored?
Sybase, DB2, Oracle all suck in JDBC documentation.
Maybe that problem is already fixed. Try Oracle thin driver. What happens is
that
if you insert a string less than 32 long, the DBMS will automatically append
white
space to that string and then store into DB. There is nothing wrong with this
behaviour. However, when you query that table with the original string you
used,
you will not get anything back, unless you append white space to make that
string
32 long.
OK, there is nothing wr |
|
w*r 发帖数: 2421 | 29 HOHO... It is TeraData... not TeraByte yah.. well, the problem for
our company is that the data is HUGE.... none of DB2/Ora/Sybase would
be able to accomodate the performance need to host the data and the
daily queries run through it.. |
|
xt 发帖数: 17532 | 30
Let me explain what CHAR(32) means. CHAR(32) means a fixed length string
field as opposed what is defined by VARCHAR or CLOB etc. However, CHAR(32)
does not mean you have to make your value 32 long, but you cannot go beyond
32. In case you do not have 32 characters, DBMS will append white space
to it - which is what Oracle is doing as well. However, that does not mean
that when you retrieve the data, it should give you the white space it adds.
Obviously MS, IBM, Sybase and even Oracle SQL Plus |
|
x***n 发帖数: 39 | 31 Eventually got a chance to test Oracle, but forgot to test the so-called
"inconsistency".
Below are my observations:
CREATE TABLE T1 (N CHAR(10)); INSERT INTO T1 VALUES ('ABC');
SELECT LENGTH(N) FROM T1;
MySQL, MS SQL Server: 3 3
Oracle, DB2, Sybase: 10 10
CREATE TABLE T2 (N CHAR(20)); INSERT INTO T2 VALUES ('ABC ');
SELECT COUNT(*) FROM T1, T2 WHERE T1.N = T2.N
ALL: 1
Basically the rationale is here:
Since CHAR dose not have an indicator for the length of this field, (not |
|
n***i 发帖数: 84 | 32 Think Sybase has similiar features.
What app server you using? If servlet you can
consider try pushlets or streamlets with JMS. |
|
c**g 发帖数: 274 | 33 最基本的,JVM run 起来的时候, 一般都有个class loading的过程.
比如你敲command line java -classpath xxx xxxVM会把一些最基本的Class
比如java.lang的load进来, 如果需要到其他的class就会在系统的classpath
里和自己设定的classpath. 又比如Tomcat需要load JVM for a web application,
也是从设定的路径一一load 起来. 然后JVM里的Objects你用的时候用的是
interface, 实际的implementation是实际的Classes.
再回到你的问题, 如果其他人程序里用A的时候是这么一句: A a = new B(),
那自然没问题, 系统自然会知道用到B. 你的疑问产生大概是因为有些时候
根本没提到B, 比如java.sql, 把Connection, Statement之类的用来用去好象
没B (比如com.sybase.jdbc2.jdbc.SybDriver等)啥事. 其实不然, 你裸用java.sql
的时候一定还有一行, Clas |
|
m**c 发帖数: 192 | 34 环境为spring + hibernate 数据库为mysql 访问数据库之前
在log中总是看到这个
XmlBeanDefinitionReader - Loading XML bean definitions from class path
resource [org/springframework/jdbc/support/sql-error-codes.xml]
然后就开始load 八种数据库的一些属性 会打出很多log信息
每次运行都会这样 全部八种都load完以后出现:
SQLErrorCodesFactory - SQLErrorCodes loaded: [DB2, HSQL, MS-SQL, MySQL,
Oracle, Informix, PostgreSQL, Sybase]
然后开始找mysql的SQL error codes 但实际上我只用mysql 跟其它数据库无关
但是它为什么每次都load这些信息呢? 能不能让它不load这些东西?
是不是要修改spring.jar中的东西?
我的应用是一个最简单的spring + hibernate的应用 |
|
|
l*****b 发帖数: 82 | 36 The whole error log is:
INFO [org.springframework.jdbc.support.SQLErrorCodesFactory] SQLErrorCodes
loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase]
ERROR [STDERR] com.active.dao.DAOException: An exception occurred during
database access: PreparedStatementCallback; uncategorized SQLException for
SQL [SELECT * FROM transactions WHERE transaction_id = (SELECT refenence_
tran_id FROM transactions WHERE transaction_id = ?) or transaction_id = (
SELECT original_transaction_id F |
|
w****r 发帖数: 945 | 37 Fixed Income Java Developer
We require a strong Java Developer with 5-8 years of experience, with a high
level of financial expertise and the ability to work on various
technologies and projects.
Java Developer
Required:
Computer Science Major.
Expert level Java/OOP.
SQL/Database Design.
Experience in the financial services industry.
Highly Technical with the ability to pick up any project and run with it.
College level math proficiency. This role requires understanding of
financial models and i... 阅读全帖 |
|
y****e 发帖数: 23939 | 38 我们公司最近刚聘用了一个Sybase的合同工,过了60了 |
|
z******s 发帖数: 322 | 39 【 以下文字转载自 Programming 讨论区 】
发信人: zjurules (东方剑桥), 信区: Programming
标 题: 我来跟新手说说怎么分辨真牛人和嘴皮牛人吧
发信站: BBS 未名空间站 (Sun Feb 16 14:42:01 2014, 美东)
本版不少学生找工作的,或者是新入门的,这个阶段,最怕的不是没好好学,而是被胡
说八道的人带到坑里。而新人最头疼的就是,水平不够没有经验,怎么知道别人说的对
错?我这篇帖子就是针对新人的,告诉你一个最简单地分辨真假牛人的办法。其实简单
程度远远超出你想象,就是看他对领域内的产品的细节了解多少。
网上赵括最大的特点就是特能吹,大嘴一张,什么IO呀,什么瓶颈呀,什么磁头扇区读
写呀,连每秒多少都信手拈来,把新人哄的五迷三道的,以为遇到真神了。其实你仔细
看看,他对领域内产品根本不了解,他对自己胡吹的东西的细节也不敢说。现代社会是
个合作的社会,你要成为牛人,最重要的一点就是知道完成什么任务用什么工具,而每
个工具的优缺点又是什么。举个例子,有个特定的任务,我想知道是用DB2好,还是
Sybase, 还是KDB+。真正懂... 阅读全帖 |
|