s*****c
发帖数: 36 | 1 Hi, flashing:
I think it's a good solution for your project:
OS: Win NT Server
Web Server: Microsoft Internet Information Server(IIS)
DBMS: SQL Server
Programming: ASP (using vbscript or javascript)
It is one of the most popular solutions for small business.
It's not expensive and easy to implement. |
|
s*****c
发帖数: 36 | 2 Hi, zzhang:
In SQL Server: Enterprise Manager ->..-> Databases --> xxxdb |
|
f*****c
发帖数: 22 | 3 Yes, for tpc-c benchmark.
I am just wondering why DB2 can achieve sth like this. It is the most
slowest DBMS server in the world, :-)
Tghe server is win2k cluster, which is one of the most advanced technologies
MS boast of. But for ordinary PC wihtoug >16 cpu, NT is good enough.
For ordinary win2k server, it seems it will consume more memory than
its ancestor-winnt4 workstation. So I do not think it will have a better
performance if you have less than 256M memory, :-)
Actually, I runned TPC-H be |
|
w*********n
发帖数: 84 | 4 可是在安装过程中需要 ROOT 权限, 我没有阿, 于是只有 CANCEL.
我只能用自己的帐户 LOGIN 到 NFS 系统而已, 外加 LOCAL 的十几G空间可以私用,
可那也不管用阿. 似乎 INSTALL 时需要往什么我没有写权限的目录写东西,
于是乎只有放弃安装.
请问, ORACLE 有没有小型一点的数据库, 不用非要往我控制不了的目录写东西呢?
其实我只是想建一个 WEB DB 应用, 学习一下而已.
我已经安装了自己的 WEB SERVER (用 APACHE), program language 用 java,
JSP/Servlet.
就少一个可用的DBMS了.
/ Sun OS
求教! |
|
f*****c
发帖数: 22 | 5 Oracle is famous for its extreme slow speed, which is comparable to
IBM's DB2. Don't expect it willl run smoothly on your single machine,
let alone outperform other DBMS servers. |
|
p****s
发帖数: 3184 | 6
Man, this is not an SQL question at all.
I don't believe if you say
WHERE room = 'Room1'
and DBMS will return Room1, Room10, Room12 to you. |
|
p*****e
发帖数: 58 | 7
I don't know how SQL statements work on Access. But in MS
SQL or other dbms, you use '' (two single quotes) in SQL for
the single quote character. Just like in C you use \\ for
\.
Example:
Update table1 set description = 'That''s the big boss' |
|
l******o
发帖数: 25 | 8 hi,
I am a new comer to DBMS .
and my research direction is a kind of spatial and temporal
database. But I don't from where i can
get the papers, information, and progress of database research
can you tell me which conference, jounral and, mailing
list should i keeep an eye or join?
thank you |
|
d******e
发帖数: 2265 | 9 tell us your databse Managerment system.
不知道具体的dbms怎么帮你
并且,你可以检查的东西太多,index,i/o,存储过程的个数.
操作系统,cooked file or raw disk.参考一下你的performance guidance吧. |
|
h*****l
发帖数: 184 | 10 My DBMS is MS SQL Server. |
|
c******r
发帖数: 104 | 11 Maybe u can try some stupid easy way,
using access , save the whole article in memo,
using VB to construct the searching fuction.
If it is just keyword search, u don't need to use SQL or other
advance DBMS. |
|
b***n
发帖数: 2 | 12 I am using Oracle as the DB server. so i create a user APPADMIN to create and
maintain the schema objects (tables, views, and etc). When i access the
database with an application user, say TOM, who is another database user in
the Oracle, I need to use a SQL as "SELECT * from APPADMIN.sometable". that
looks very inconvenient, as I have to use the schema name before the table
names, and it is not portable to other DBMS. on the other hand, if i use
APPADMIN to connect to the database in the applic |
|
k**s
发帖数: 53 | 13 I believe c/c++ is must. Perl and Java is not good for
physical database implementation. Basically, to implement a
search engine, you have to develop a full-text indexed
database engine, which cannot be effiently implemented
by tranditional Relation DBMS. |
|
h****e
发帖数: 204 | 14 memo 是个老概念, 最常见于X-Base家族(dbase, foxbase, foxpro, clipper...)
的确memo type field在 dbf中只占一个pointer的地方, 所有数据存于另一个
文件中. 这个文件大小只跟OS有关. memo是很不适合查询的field, 而且memo文件
的存在使X-Base这种没有DBMS的数据库系统来说是个很不安全不干净的隐患.
SQL Server 的varchar 应该是不大于7000+, 所占字节不固定. 你说的那个例子是
char type. |
|
t********k
发帖数: 808 | 15 我的系统是2000 advance server
我的机器名是daniel
用Net 8 Assistant配置的服务名是orahome
那在database profile内是不是这样配置?
SQLCA.DBMS = "O84 Oracle8/8i (8.x.4+)"
SQLCA.LogPass = <*****>
SQLCA.ServerName = "orahome"
SQLCA.LogId = "scott"
SQLCA.AutoCommit = False
SQLCA.DBParm = "" |
|
|
f***g
发帖数: 10 | 17
A value of NULL indicates the value is unknown. A value of NULL is different
from an empty or zero value. No two null values are equal. Comparisons between
two null values, or between a NULL and any other value, return unknown because
the value of each NULL is unknown.
Null values usually indicate data that is unknown, not applicable, or to be
added at a later time. For example, a customer's middle initial may not be
known at the time the customer places an order. |
|
s**********i
发帖数: 711 | 18
NULL is NULL. null is not unkown. if you know a value
is null, it's not any other value, it's just null.
basically null means no set value. |
|
h****e
发帖数: 204 | 19 nop, NULL is NULL, which means uncomparable "value", if this makes some
sense to you. |
|
l********h
发帖数: 16 | 20 What did you try to do?
Why did you want to compare NULL to NULL?
Could you provide your SQL statement? |
|
h*****n
发帖数: 439 | 21 well, maybe this is useful for dating service, bf/gf search engine. :P
select a.ID, a.FirstName, a.LastName, b.ID, b.FirstName, b.LastName
from Male a, Female b
where ( a.GirlFriendID IS NULL and a.IsGay = FALSE and
b.BoyFriendID IS NULL and b.IsLesbian = FALSE) |
|
j******f
发帖数: 228 | 22 All,
I'm writing a program to dynamically create tables in a Sybase database
through JDBC. Some of the fields of the tables are VARCHAR type. It seems that
the Sybase DBMS doesn't handle it correctly and keeps throwing exceptions. If
I remove those VARCHAR fields, the program executes correctly. Does any one
have any solution?
Many thanks!! |
|
t**s
发帖数: 22 | 23 不懂你的"User"是什么意思，是DB的user还是存在db里的user数目。
Access只有一个用户"admin"。但它用在程序里服务几百上千个user
数目都没问题。比如说，你有个web，用asp和Access连，有1000个用
户访问web，但实际上存取access的只有一个，即admin。其它都是
access里的数据。
很少有dbms支持100个cocurrent用户访问的。 |
|
xt
发帖数: 17532 | 24
so if it has stored procedure you might want to use it.
No offense to open source projects, but I don't think MySQL
is really a good DBMS. |
|
|
n**m
发帖数: 255 | 26 alter table.....
different dbms allow you do different levle of changs.
SQL server may be the most flexable one |
|
R***a
发帖数: 41892 | 27 if you can master oracle, you can master other DBMS also. |
|
u******p
发帖数: 13 | 28 proc import out=_sas_input
data="foo.csv"
dbms=csv;
getnamese=yes;
datarow=2; /*with field name*/
run; |
|
w*r
发帖数: 2421 | 29 by using ODBC connection, you can use ANSI SQL for forxpro DBMs,
it is just a variation of Dbase. |
|
s******n
发帖数: 45 | 30 what do u mean when u say 数据库是16位，or ３２位的数据库XP和JAVA都不支持？
r u using an existing DBMS system? or implementing your own? |
|
a*******t
发帖数: 891 | 31 what are the class descriptions?
wild guess: database managment systems - DBMS application
computerized database systems - theory behind database systems?
other than offical class description, you need to see the professor's syllabus
, and ask other students. the class, different professors can teach it totally
differently.
I had a CS DB class before, the professor taught nothing but the theory on
data logic. totally useless.
看
systems
管
回 |
|
p*******k
发帖数: 488 | 32 如何开始为好？不是CS科班出身，就知道java c++，前面学了点DB 和SQL，现在要学习
DBMS，project就是用C extend PostgreSQL，比如index, aggregate,query. 如何开始
为好？中间有那些triks？
多谢！ |
|
l*****k
发帖数: 587 | 33 for db design? use ERwin or Qdesigner
once you have the db, you can play with it to learn DBMS like oracle
or sybase or mysql, etc. |
|
r*********r
发帖数: 3195 | 34 哪个链接？是伯克利那个？那个是java的，
而且大部分的库是编译后的二进制文件，没有源码。
我想读一读C的源码.
mysql 和 sqlite 有点太大了,
想找个小而全的系统看看.
有什么别的开源DBMS可以推荐的吗? |
|
d****y
发帖数: 701 | 35 这个要看APPLICATION的需要了，对DATABASE本身要求不高的，APPLICAITON本身不
CRITICAL的当然可以用MYSQL，但你不可能想象一个TB级的DB用MYSQL。在对复杂问题进
行处理的时候，更高端的DBMS是需要的。
就是一个性价比的问题。 |
|
I******e
发帖数: 101 | 36 depending on whether ms is doing deferred delete. most dbms are doing it. |
|
y****w
发帖数: 3747 | 37 OO may be a disater when performance is a major measure. I believe OO tables
in relational dbms products are more for marketing than for reality. |
|
v*****r
发帖数: 1119 | 38 工作上没用过PostgreSQL，读书时有一门课是“Object-Oriented Database",就是围绕
PostgreSQL来讲的，PostgreSQL的Object-Oriented设计是很不错的 （所以叫第一个
Object-Oriented DBMS. Oracle 和M$SQLServer的 Objectfeature 是后加上去的, 相
当的 Ugly. 举个例子，PostgreSQL is like Java, Oracle 和M$SQLServer are like
C language with optional object features add-on.
PostgreSQL另一个特点对语言的支持，你可以用多种语言写Stored Procedure, 而且这
种功能很容易扩展到新的语言上。我那门课的Lecturer是个Python programmer, 为了
拍他马屁，我Database的assignments 都是用Python 来写的，基本都拿了满分，哈哈。
至于PostgreSQL商业开发上一直不顺，我觉得有以下几个原因：
1. 运气差，沾了它前 |
|
S*****0
发帖数: 538 | 39 这么多年了，没有一个去做这么方面的？还是，这个投入没有回报？
应该有个自己的产品。说难也难，说不难也没什么，只要走起来，就肯定能完成。 |
|
|
|
S*****0
发帖数: 538 | 42 我看了一下他们的网站，还是有不少用户的。但从文献看，还基本是scripting, 能有
个好的UI，有助益推广。有关技术方面的介绍很少，其实可以公布出来，大家讨论，有
助益产品的优化。还可以开发些相关的utilities. |
|
|
|
|
|
|
b*******y
发帖数: 1240 | 48 博士再读，对数据库可以说很不懂
1. DBMS 数据库管理，这个ms硕士很好找工作，不过博士不好发文章？
2. Data mining 数据挖掘
3. Data privacy, 和数据挖掘现在有些交叉
目的：好发文章，而且以后工作也好找
谢谢 |
|
j******n
发帖数: 108 | 49 目前 xml db 最为人诟病的就是 performance
抛开技术上的困难，xml 作为一个 data model
还是反映了很多实际应用中 relational model 难以处理的cases
比如最有名的就是 data exchange
还有 schema-less/flexible schema，传统 relational model 都是先设计 schema,
normalization, 然后 table partitioning
这在很多 applications 中都是不现实的，
比如 content management systems, messaging system, SaaS
xml 在这些场景就显的非常自然
回到技术上，xml db 也不是所有的都慢
oracle 的 claim 是对于 xml with static schema，性能还是很不错的
但是说回来，如果都是 static schema 的话，为什么还要用 xml 呢
relational model 就很好了呀 (除了需要 exchange)
所以对于 xml 需求并不是不存在
只是现在似... 阅读全帖 |
|
y****w
发帖数: 3747 | 50 but need comparsion before physical update. not acceptable sometimes as it is out of normal sense as you are supposed to update something to be
different.
what you proposed earlier today for the dbms will more likely to be a performance disaster...
80/20,80/20.... |
|
