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
LEARN ABOUT SUNOS
setup.types
setup.types(5) Easy Software Products setup.types(5)
NAME
setup.types - epm gui setup types file format.
DESCRIPTION
The EPM setup program normally presents the user with a list of software products to install, which is called a "custom" software installa-
tion.
If a file called setup.types is present in the package directory, the user will instead be presented with a list of installation types.
Each type has an associated product list which determines the products that are installed by default. If a type has no products associated
with it, then it is treated as a custom installation and the user is presented with a list of packages to choose from.
FILE FORMAT
The setup.types file is an ASCII text file consisting of type and product lines. Comments can be inserted by starting a line with the pound
sign (#). Each installation type is defined by a line starting with the word TYPE. Products are defined by a line starting with the word
INSTALL:
TYPE Typical End-User Configuration
INSTALL foo
INSTALL foo-help
TYPE Typical Developer Configuration
INSTALL foo
INSTALL foo-help
INSTALL foo-devel
INSTALL foo-examples
TYPE Custom Configuration
In the example above, three installation types are defined. Since the last type includes no products, the user will be presented with the
full list of products to choose from.
SEE ALSO
epm(1) - create software packages
setup(1) - graphical setup program for the esp package manager
COPYRIGHT
Copyright 1999-2007 by Easy Software Products, All Rights Reserved.
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MER-
CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
3 April 2006 ESP Package Manager setup.types(5)