07-23-2002
Importing a Unix file dump into SQL Server
The vendor is getting back to me on the size of the full file (right now I'm working with a sample).
I do know that there are approximately 100,000 products listed in field:value pairs.
In terms of database design, this data is going to be used to create a web store that will allow users to compare products in the same category by searching, filtering, or viewing the products' specifications.
Do you think it would be better to:
(a) Have one Product_Details table that had the fields present in all categories and "Field1", "Field2", etc. with XML defining the names of the fields based on the category in the web front-end
OR
(b) Have multiple Product_Details tables with all of the common product detail field and category-specific fields.
(Each product would be related to only one Product_Details table, in this case, so this latter method SHOULDN'T take up any more space)
Thank you for your help in advance.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i am a unix-super-beginner (swaddled and weaned on windows) and am trying to import a database from a unix directory into winnt. can someone help me or am i a hopeless case? (4 Replies)
Discussion started by: sadiecutie
4 Replies
2. UNIX for Advanced & Expert Users
what is a flat file in unix?
i have to import a unix flat files from windows based programme.
my question is not to export from unix but only to import from windows only.
how to build that flat files?
how to create export to windows
how to import from windows (3 Replies)
Discussion started by: tunirayavarapu
3 Replies
3. UNIX for Advanced & Expert Users
I want to collect the database tables(Ex: Emp,Sal,Bonus...etc)
in a file & give this file at the command prompt, when prompted for the tables list at command prompt. How can i do that ?
Ex:- Import jason/jason1 tables=emp,sal,bonus log=j1.log
i want to change this into
Ex:- Import... (3 Replies)
Discussion started by: dreams5617
3 Replies
4. Shell Programming and Scripting
Hi,
I am trying to import 22 .dmp files but facing the problem with the last table file it never ends the import command, only the table is created but the rows of the table don't get imported.
This is the problem with only ine table rest 21 tables are being imported properly.
Thanks in... (2 Replies)
Discussion started by: anushilrai
2 Replies
5. Shell Programming and Scripting
can i make a dump to happen from my script in a databse.and download that dump.
I want to schedule a script i cron so that i will make a dump and download that inot my server. (1 Reply)
Discussion started by: arunkumar_mca
1 Replies
6. UNIX for Dummies Questions & Answers
Hi...
I have dump in unix machine...How can I this import dump to Oracle database?
Many thanks in advance. (2 Replies)
Discussion started by: agarwal
2 Replies
7. UNIX for Dummies Questions & Answers
I really need help in this :(
I have a file and would like to calculate the cosine similarity of the values in it...
For now I do use R which has an easy function for doing so
test <- as.matrix(read.csv(file="file.csv", sep=",", header=FALSE))
result<- cosine(t(test))
I am using unix of... (3 Replies)
Discussion started by: A-V
3 Replies
8. Boot Loaders
1)It is a great experience to achieve what I got today. I had downloaded GParted iso file (135 MB size). Now to make a bootable usb of it, I used unetbootin and to surprise I succeded in entering Gparted application and modified my partitions.
Earlier I was in a notion that it is used only for... (0 Replies)
Discussion started by: ravisingh
0 Replies
9. AIX
Hi All,
I am facing one problem related to importing Oracle Dump file.
We have two different version of AIX boxes with oracle (version 10.2.0.4.0) installed.
On one AIX box (version 6.1) we are creating oracle dump file (*.dmp) using oracle exp utility and importing it onto another AIX box... (1 Reply)
Discussion started by: gunjan_thakur
1 Replies
10. UNIX for Advanced & Expert Users
Hi,
I want your help to see if there is a way wherein we can load a set of files which are lying in unix server into my database using sql loader.
Also the person who will be running sql loader does not have access to unix system.
So is there a way i can provide any sql loader script wherein... (1 Reply)
Discussion started by: Vivekit82
1 Replies
SAVECORE(8) System Manager's Manual SAVECORE(8)
NAME
savecore - save a core dump of the operating system
SYNOPSIS
savecore dirname [ system ]
DESCRIPTION
Savecore is meant to be called at the end of the /etc/rc file. Its function is to save the core dump of the system (if one was made) and
to write a reboot message in the shutdown log.
It saves the core image in the file dirname/core.n and its corresponding namelist in dirname/unix.n. The second argument is the namelist
for the system which made the core image; the current system is always assumed to be /unix. The trailing ".n" in the pathnames is replaced
by a number which grows every time savecore is run in that directory.
Before savecore writes out a core image, it reads a number from the file dirname/minfree. If there are fewer free blocks on the file sys-
tem which contains dirname than the number obtained from the minfree file, the core dump is not done. If the minfree file does not exist,
savecore always writes out the core file (assuming that a core dump was taken).
Savecore also writes a reboot message in the shut down log. If the system crashed as a result of a panic, savecore records the panic
string in the shut down log too.
If savecore detects that the system time is wrong because of a crash (the time in the core image is after the current time), it will reset
the system time to its best estimate of the time, which is the time in the core image plus the elapsed time since the reboot. It announces
the time that it set when this occurs.
FILES
/usr/adm/shutdownlogshutdown log
/unix current UNIX
BUGS
The method used to determine whether a dump is present, and to prevent the same core image from being saved multiple times, is not elegant.
This information should be passed to init by the system; however, this is difficult because the system may have to be rebooted a second
time if the root filesystem is patched.
3rd Berkeley Distribution SAVECORE(8)