o***z
发帖数: 133 | 1 maybe the database password is for MS Access only, not for ODBC
the
in |
|
s****y
发帖数: 95 | 2 Thanks. I think you are right the database password is for MS Access only. But
do you know whether there is an ODBC API which is compatible with this
protocol?
ODBC
like
a |
|
b******a
发帖数: 20 | 3 If the data is static and volume is huge, I don't see any reason that you want
to put them into database. To retrieve data directly from file system is way
more faster than from database.
You might want to try the following architecture,
Web Interface Application
|
Data Services
|
Various Data Sources
The data service tier will be some programs reading raw data from various
source and convert them into standard format, and providing services to web |
|
j**i
发帖数: 419 | 4 I know there is something wrong with this"Connecction" part.
1.Looks like TNSNAMES.ora is not the problem
since I have tested diffrent kind of expression,like IPC,TCP,change server n
ame
to IP,add both port....and the same file works on server.
....
2.the default database ORACLE works well on client machine.
I don't know how/where to check the TNSadmin variable?
3.the listener starts OK and database ZZ can be operated well on server
but the client has some problem and both of them are in the fir |
|
i*******e
发帖数: 2 | 5 I need to work on a project on database and information system. The purpose
of the project is to build an information system using a database. e.g, an
information system for a manufacturing business. I did some research on-line,
and could come up with a good topic. Any DA XIA could give me some
suggestions?
I would grealy appreciate any help. |
|
R******n
发帖数: 160 | 6 我从OTN上download了free的oracle9i personal edition，但是在install时没有看到让
我create seed database的选项。请问怎样才能得到Sybex系列书中提到的seed
database(如HR)呢？ |
|
q**j
发帖数: 10612 | 7 【 以下文字转载自 Internet 讨论区,原文如下 】
发信人: qqzj (atrest), 信区: Internet
标 题: HOW TO UPLOAD A FILE INTO DATABASE
发信站: The unknown SPACE (Mon Jun 9 13:11:18 2003) WWW-POST
不好意思,又要问问题了. 老板让我reseach how to upload a file into database,
using asp.net. 我是刚刚来OFFICE的, 不知道怎么高, 请各为大侠帮忙, 谢谢了!
不知道我说请问题了没有,如果没有, 请回我! 谢谢! |
|
r******e
发帖数: 32 | 8 hi, I am interested in database field. But without any experience, someone
suggest me to go to database developer direction.
Is there anyone can give me some advice to how to prepare for it? What
background knowledge do I need to take? thanks a lot, |
|
g*****g
发帖数: 34805 | 9 Why don't just store xxxxxxxx in database,
trim the "-" before insert into database and
add it in display? The major advantage is
the verification of input. |
|
aw
发帖数: 127 | 10 不嫌初级的话，从ACCESS学起，先把建TABLE，写SQL，作REPORT搞熟了。其实很多工作中
(IT或不IT的)，用ACCESS的时候并不少，尤其是初级的或小活儿。ACCESS比较直观，容易
理解。
水平高点了可以玩玩SQL SERVER，比较容易和前面学的衔接(都是M$的东东嘛)。作为一般
作M$方面的PROGRAMMER来讲，SQL SERVER都要知道不少，而不仅仅是DBA的事。所以工作
中接触的机会会多一些。
ORACLE麻烦一些，一般都有专门DBA来作，经验要求很高。单作DB DEVELOPER的职位很少
。
SYBASE份额不大，且多在银行系统用，一般人不行。
DB2不了解。
MYSQL等还是拿不上台面(俺的偏见)。
本人从未学过系统的DATABASE，也没有经验。现在看来许多数据处理和管理需要DATABASE |
|
j****s
发帖数: 34 | 11 hi, there,
i have long input for the "description" in the database
i want to have 换行in it
what is the 换行 in sql database?
i tried \n
not work
Any idea, thanks! |
|
g***o
发帖数: 297 | 12 Could anybody give me an idea about how to populate database structure from
SQL server 2000 easily? I have several databses and lots of data inside those
database. Thanks. |
|
D****N
发帖数: 430 | 13 You can make a copy of the database, trucate all the tables, then
make a backup of that blank database to restore to other locations... |
|
s*****c
发帖数: 24 | 14
For database use or database implementation? |
|
t***y
发帖数: 22 | 15 【 以下文字转载自 CS 讨论区,原文如下 】
发信人: Teddy (bear), 信区: CS
标 题: Any experience with berkerley database?
发信站: Unknown Space - 未名空间 (Thu Oct 14 19:22:22 2004) WWW-POST
I am installing berkeley database, version 4.1.5 for java API. I can't find
the java/classes directory after the installation. Has anyone have experience
about that? How to set path? Please job me an email. |
|
d*****t
发帖数: 17 | 16 Hi, everyone,
I have a task to design a database in MS SQL Server 2005 for a group. Each
member of the group should have his own schema that is not accessible to
other members while there is a common schema shared by all members. I can
set up a database role for the members. My problem is how to prevent members
from accessing others' schema. Any help will be greatly appreciated.
Thanks. |
|
y********o
发帖数: 2565 | 17 对，我将学校那个Oracle10g的tnsnames.ora中相关的一节如下搬到我的XE之tnsnames.
ora了。
Oracle10g =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle10g.my.univ.edu)(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Oracle10g.my.univ.edu)
)
)
然后我说：
SQL> create database link mylink connect to johndoe identified by wassupman
using 'Oracle10g';
Database link created.
SQL> desc mytable@mylink;
ERROR:
ORA-12170: TNS:Connect timeout occurred
我按这个 h |
|
b*****s
发帖数: 45 | 18 Just want to set up the database mail on the locahhost server. According to
MS document I need to enable it first from surface area configuration. But
I don't see the database engine item after I clicked the surface area
configuration for features. |
|
n****c
发帖数: 13 | 19 You still didn't answer my question in the first paragraph. So I assume that
your database is a transactional database and would make suggestions based
on this assumption.
Based on your additional info, you may want to add at least another table,
let's call it STOCK.
STOCK(STOCK_ID, STOCK_SYMB, STOCK_DESC, LAST_UPDATED)
With another two tables shown below:
TRADER(TRADER_ID, LAST_NAME, FIRST_NAME, STATUS, LAST_UPDATED)
STOCK_TRADE(TRADER_ID, STOCK_ID, TRADE_TIME, TRADE_VOLUME, TRADE_PRICE, LAST
_ |
|
F**e
发帖数: 593 | 20 Really appreciate it!
我没有糖,但你也不用用牙膏皮来换了,送你5个包子略表谢意.呵呵.
OK. back to the question.
Here, assume I'm doing research on stock price history. I have tick data for
1000 stocks, each with 1 million ticks, in separate text(.csv) files, one
file per stock.
I would like to import the data (csv files) into database and run queries on
the DB, and I only run query on one stock at a time. This is not really a
transactional database, if I understand what it is -- the import part
happens very infrequently, whil |
|
E**i
发帖数: 116 | 21 【 以下文字转载自 board 讨论区 】
发信人: xlxie (三老爷), 信区: board
标 题: 申请database版版主
发信站: BBS 未名空间站 (Mon Jul 23 20:43:30 2007)
本人从事database专业。
希望能带给大家一个愉快的讨论空间。
望大家支持。谢谢。 |
|
l*****d
发帖数: 12 | 22 A guy in my company wrote a Microsoft Access Database program. But now, he
forgot the password to enter his original codes. We have a lot of data in it
. How could I crash the password and get this data out of Microsoft Access
Database.
Thanks. |
|
c*******e
发帖数: 8624 | 23 【 以下文字转载自 board 讨论区 】
发信人: cheungche (你不乖), 信区: board
标 题: 申请database版版主
发信站: BBS 未名空间站 (Sun Aug 26 22:32:46 2007), 转信
ID: cheungche
申请职务: database版版主
理由：最近一年来对数据库有点兴趣,平时工作很相关
日期: 8/26/2007
谢谢 |
|
s****h
发帖数: 1329 | 24 consider desktop and laptop categories, using brand names for the
subcategories like HP, Compaq... then I'll have same subcategory names,
although under different categories.
I think all names should be different in a database, but on the website, it
looks better if we just use the brand names under each category, Like
Bestbuy, Circuitcity's websites. So does that mean they are using the brand
names as their subcategory names in the database as well?
I don't know anything about web developing,wo |
|
y********o
发帖数: 2565 | 25 If you are talking about getting data from web pages, just try harvesting
those pages through HTTP connection in your code.
If you are talking about getting data through database objects such as SQL q
ueries or stored procedures, then you need to be able to connect to your uni
versity database.
I used to have access to all students info from our university data warehous
e. It was fun to see what grades they are getting, how old they are, if they
are married, and their consulting records (which r |
|
L****6
发帖数: 31 | 26 Today I learned how to use SAS and SPSS to access and query databases
through ODBC.
Could you please tell me any other ways to access and query databases? |
|
m*****h
发帖数: 18 | 27 I have a database with Full Recovery Model, I need to schedule one Full
backup on every sunday night, and Differential backup on every night and
mutiple Transaction Log backup every 2/3 hours. How should I do it?
When taking about backing up database, should I also back up the log file?
if so, how should i do it? thanks? |
|
l********u
发帖数: 195 | 28 需要同时view data from tables from different databases. how can I create a
view that across different databases?
Thanks |
|
|
x*g
发帖数: 689 | 30 MS SQL server
里面有3个database，如何disable其中的一个
database使得任何login都不能连接到它？
谢谢！ |
|
h**********s
发帖数: 171 | 31 本人cs master，刚毕业，拿到了一个database developer的offer，有如下问题：
1. 这个职位是不是工作相对轻松，routine工作较多？我对待遇、发展什么的要求不高
，能有份比较稳定、不那么累的工作就好了。
2. 以后如果想转成其他developer，比如java, .net还有有可能的吧。本人在学校用C/
C++比较熟练。
3. database developer的职位在市场上还算多吧？
谢谢大家 |
|
i****a
发帖数: 36252 | 32 发文章 maybe data mining?
there are a lot of Database Administrator but most require work experience
database developer are easier to find 1st job with |
|
B*********L
发帖数: 700 | 33
The smtp mail server has an issue. My database server don't have any problem
. The database email service is back to normal now.
Thanks. |
|
l******t
发帖数: 660 | 34 有一个很大的oracle database, 需要和一个sql server database sync, 因为数据很
大，
oracle table里又没有updata date, 有什么工具能incremental syc， 只把上次
oracle里
改动过的数据sync过来吗？ |
|
g*****1
发帖数: 998 | 35 要求database和sql的experience，让后说他们用的是sql server.
我最近才开始看sql server.
然后对方说要进行一个sql test,要是纯粹的sql语句我基本可以应付，不知道这种职位
会不会考t-sql?
总之，我的问题是这种junior level的sql server database职位考sql，就是一般的sql语句呢,还是很可能要考t-sql,stored procedures, function之类的？ |
|
l*********r
发帖数: 674 | 36 【 以下文字转载自 JobHunting 讨论区 】
发信人: HanSolo7 (隼), 信区: JobHunting
标 题: 职业杯上一个DATABASE题目。
发信站: BBS 未名空间站 (Sun Jan 2 22:28:04 2011, 美东)
说：
YOU Have to design a database that can store terabytes of date. It should
support efficient range queries. How
would you do it?
书上答案是
Use B+ tree.
省略一些解释
大家觉得这个回答好么？
为什么ｔｂ级别就要用ｂ+ ｔｒｅｅ?
那pb级别呢？ｂ+ｔｒｅｅ还给力不？上ｍａｐ-ｒｅｄｕｃｅ? |
|
|
s*******n
发帖数: 3 | 38 想请教一下各位的意见
以下是个人的一些背景：女，国内本科计算机系毕业，美国硕士计算机系毕业，因为毕
业的时候工作不好找，而且本来对计算机也不是特别喜欢，在服装行业做了两年多与本
专业完全无关的工作。现在由于经济和身份的问题（毕竟计算机行业工资高一点，而且
需要两个人同时有身份才比较保险），想转回计算机行业。现在其实就是没有实习经验
的毕业生了，身份是Ｈ４，在新泽西地区，离纽约市比较近。有家庭，不能relocate。
在计算机这个行业，我比较感兴趣的是数据库方面的，所以2010年10份的时候就把工作
辞掉了专心在家复习。我看的是SQL Server Database,同时也自学了SSRS, SSIS。自己
认为SQL Programming的水平应该也在中等水平以上。基本上就是微软的一套东西。
我想问一些我能找到在数据库方面的初级工作吗？或者说现在的公司愿意为这些Junior
的Database Developer办Ｈ１签证吗？以我现在这种情况，有没有机会找到工作。如果
我能找的话，通常是什么job title呢？我找了几个月了，都没有什么电话给我。我看
了一下DBA的面试题目，觉得我可... 阅读全帖 |
|
B*****g
发帖数: 34098 | 39 【 以下文字转载自 JobHunting 讨论区 】
发信人: cool66 (小酷), 信区: JobHunting
标 题: 工作机会：Database Developer/Administrator （SAS,SQL)
发信站: BBS 未名空间站 (Fri Apr 15 17:18:17 2011, 美东)
PM me with "Database Developer/Administrator （SAS,SQL)" in the subject line.
leave your email so that I can send job descriptions. the Location is in
downtown Chicago. H-1B ok. |
|
m******y
发帖数: 588 | 40 我们其中一个production database server 的SAN 不够用了，又买了个新的，要把上
面大概600 GB的sql server databases移到新的SAN上，. 这个production db server
是一个active/passive cluster, 因为要minimal downtime，所以不能停了sql server
copy，现在想了两个方案，但是还都没试过，想问问这里有人干过这个吗？有什么好
建议。 |
|
M******9
发帖数: 223 | 41 1. One programmer to maintain the website and add new database. This may
be part time job, which can be done remotely.
Requirement: major in computer science, 2 years relevant website and data
development work experience. If you are interested in it, please send your
resume with the projects (websites) you made to y*******[email protected]. Please
describe your duty briefly on the projects.
2. One programmer to develop a database. This is a full time job. Sponsor
H1B. With good healthy insurance... 阅读全帖 |
|
B*****g
发帖数: 34098 | 42 Think how do you retrieved data on remote machine, what ever you need a user
interface.
If you use oracle, try Oracle SQL Developer
http://www.oracle.com/technetwork/developer-tools/sql-developer
It is "free" and I think you don't need install, similar like eclipse. The
reason I say "free" is free version may not get 100% features, but most
features will be available.
Remember to choose JDBC to connect, otherwise you may need to install oracle
client on remote machine
http://www.roqet.org/SQLDe... 阅读全帖 |
|
J******d
发帖数: 506 | 43 谢谢。
我在remote机器上用你说的办法链接成功了。可以看到server机器上的表和数据。我想
这应该说明我server上的database是没问题的。我链接的时候， server name用的是
server的内网ip address, port和instance都没填, SQL developer仍然可以连上。
现在的问题是我需要在程序里面连到这个database上。connection string应该怎么写
呢？谢谢。
user
oracle |
|
g***l
发帖数: 18555 | 44 我找到了一个SCRIPT LOGIN的
USE master
GO
IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL
DROP PROCEDURE sp_hexadecimal
GO
CREATE PROCEDURE sp_hexadecimal
@binvalue varbinary(256),
@hexvalue varchar (514) OUTPUT
AS
DECLARE @charvalue varchar (514)
DECLARE @i int
DECLARE @length int
DECLARE @hexstring char(16)
SELECT @charvalue = '0x'
SELECT @i = 1
SELECT @length = DATALENGTH (@binvalue)
SELECT @hexstring = '0123456789ABCDEF'
WHILE (@i <= @length)
BEGIN
DECLARE @tempint int
DECLARE @firstint in... 阅读全帖 |
|
G*****r
发帖数: 369 | 45 背景：国内文科专业BA，MA（辅修计算机本科--有毕业证没学位证，10来年前修过
foxpro, C, 离散数学等等课程，现在啥也记不住了。）
美国教育技术专业硕士（博士读了一半跑掉了，所以拿了两个硕士文凭MA，EdM。5，6
年前上过JAVA，PHP，MySQL的课，现在也基本上忘光了。）
读书的时候兼职做过两年webmaster，用html, css, javascript, asp，现在记得的有
限。
在美国上班5年，做网络课程的项目管理。主要做内容，跟技术基本不沾边。因为是在
传统的白人行业，感觉很孤立，没有什么技术在手，又不会吹不会说，前景堪忧。
英语马马虎虎但做事很细心认真有条理，学东西很快（曾经的事，不知道生完两娃以后
智商有没有下降），现在有点时间（工作比较清闲），就想学点东西转行。没有精力和
时间再去考G考T，读CS master了，就想能不能考个Oracle Certification, 然后先从
兼职低薪的做起，积累经验以后慢慢转入database这一行。
请教大牛们：
1.半路出家的30多岁大妈这种想法现实不？只有Oracle Certification，没有C... 阅读全帖 |
|
G*****r
发帖数: 369 | 46 背景：国内文科专业BA，MA（辅修计算机本科--有毕业证没学位证，10来年前修过
foxpro, C, 离散数学等等课程，现在啥也记不住了。）
美国教育技术专业硕士（博士读了一半跑掉了，所以拿了两个硕士文凭MA，EdM。5，6
年前上过JAVA，PHP，MySQL的课，现在也基本上忘光了。）
读书的时候兼职做过两年webmaster，用html, css, javascript, asp，现在记得的有
限。
在美国上班5年，做网络课程的项目管理。主要做内容，跟技术基本不沾边。因为是在
传统的白人行业，感觉很孤立，没有什么技术在手，又不会吹不会说，前景堪忧。
英语马马虎虎但做事很细心认真有条理，学东西很快（曾经的事，不知道生完两娃以后
智商有没有下降），现在有点时间（工作比较清闲），就想学点东西转行。没有精力和
时间再去考G考T，读CS master了，就想能不能考个Oracle Certification, 然后先从
兼职低薪的做起，积累经验以后慢慢转入database这一行。
请教大牛们：
1.半路出家的30多岁大妈这种想法现实不？只有Oracle Certification，没有C... 阅读全帖 |
|
s****y
发帖数: 581 | 47 你们有身份吗？如：绿卡等。如果有，database是个还不错的选择。
如果没有身份，那database administrator很需要经验，一般公司不会为一个entry
level的dba办身份的。
如果实在想走CS，可以考虑developer，特别是java或.net developer， 这种
developer机会比较多。 |
|
p*********t
发帖数: 2690 | 48 我朋友单位,一个会database的,但是没人会java,現在有些java,php的问题没人能解决.
搞database的,比如dba,工作中会要求写java程序吗,哪怕是很短的一段程序? |
|
T4
发帖数: 273 | 49 RMAN> run {
2> set until time "to_date('12-24-2011 12:05:00','mm-dd-yyyy hh24:mi:ss')";
3> restore database;
4> recover database;
5> }
Error:
creating datafile fno=1 name=/data/oradata/myhost/datafile/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/28/2011 23:39:20
ORA-0118... 阅读全帖 |
|
T4
发帖数: 273 | 50 RMAN> run {
2> set until time "to_date('12-24-2011 12:05:00','mm-dd-yyyy hh24:mi:ss')";
3> restore database;
4> recover database;
5> }
Error:
creating datafile fno=1 name=/data/oradata/myhost/datafile/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/28/2011 23:39:20
ORA-0118... 阅读全帖 |
|
