unix has it's own database

Thread Tools Search this Thread
Top Forums Programming unix has it's own database
# 1  
Old 04-12-2002
unix has it's own database

Well I am new to Unix, I small doubt to clarify with our colloquies here.

Does Unix any of the versions contains its own database or it stores data on the file system.

How to migrate data in Unix to Oracle Data base is there any tool or utility available on Unix that helps to do this activity .
# 2  
Old 04-15-2002
I don't exactly understand your questions, but I'll give this a shot.

I seem to remember that some old versions of BSD did come with a simple version of ingress which was a relational data base. But then ingress became a product. The old free version of ingress could not complete with any current RDB product.

All versions of unix store data in a filesystem, but I have to believe that you already knew that. I'm not a super RDB expert, but every RDB that I know strongly prefers to store the database on a raw disk section thus bypassing the filesystem. They all support putting the database in the filesystem, but advise against this.

The all seem to have "import" utilities that can bring in data from properly formatted unix files. The import ulitity will come with the database package. Of course, some standrard unix commands may be helpful as you reformat your data to make it work with the import utility.
# 3  
Old 04-15-2002
Unix databases

I believe I am in a similar situation.

I have a customer who has some data stuck in an SCO Unix system and wants to get the data out onto a W2000 box. There's no access to cmd lines as it's a turnkey system so we're a bit stuck.

By asking for a backup to diskette from the menu system, we have established that there are some files something.dt and something.nx, (presumably data and index files) possibly others. It fills up the diskette so it's little use.

The vendor is not forthcoming and the only reference I can find to this sort of file is on a 3-com web page on Accessbuilder Name Server.

It's possibly a Novell database but there's little info about it.

A Unix sysadm I know said all this rings a bell but he has no access to manuals etc.

Any help welcome.
# 4  
Old 04-17-2002
You need to embed SQL into a script or a C ( Pro*C) program to move data from unix to Oracle.
# 5  
Old 04-18-2002
Computer Unix Database question & moving data

I have been researching the possibility of having a data driven dynamic web site and have encountered some information that might be helpful to you.

The website of www.perl.com has information on DBI (Database Interface) and DBD (Database Drivers), which is perl's version of 'ODBC' and the drivers necessary to talk to databases outside of 'unix'. It talks about what you need to put in your 'scripts', etc.... Search on DBI and a whole list of information on it comes up.

It does require loading some free perl modules, drivers as well as a database server daemon (from MySQL- suggested) onto the unix server so that you can use the perl DBI in a script similiar to how you use ODBC to connect to an Access database and SQL to get the data from it for inserting, deleting, etc....

I hope this assists you in some way. At this point for my company, I will be requesting if I can put a partition on my PC for 'Linux' and downloading of all these items to 'test' it out. But after reading your request, I thought using it in the reverse would be of help to you in achieving your project, which is the reverse of mine. Right now we don't have any 'data' on the unix web server, but would like to eventually.

If you have any suggestions on how to get my website data-driven and dynamic just using 'unix' please pass that information my way. So far, it looks like the 'ingress' mentioned in a previous reply is out. What's left?

wme9Smilie Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

What are the differences between 'bash' and 'sh'

Hopefully this doesn't come off as too much of a "newbie" question or a flamebait. But I have recently begun working with a Sun Solaris box after having spent the past five years working with RedHat. From what i can tell, thing look fairly similar and the 'man' command is some help. But I've... (7 Replies)
Discussion started by: deckard
7 Replies

2. UNIX for Advanced & Expert Users

How to remove a file with a leading dash '-' in it's name?

Somehow someone created a file named '-ov' in the root directory. Given the name, the how was probably the result of some cpio command they bozo'ed. I've tried a number of different ways to get rid of it using * and ? wildcards, '\' escape patterns etc.. They all fail with " illegal option --... (3 Replies)
Discussion started by: GSalisbury
3 Replies

3. UNIX for Dummies Questions & Answers

Unix ISO's for FTP, I've searched the other Posts

Where Do I download Unix ISO's for free? I have searched this database for other related posts, but to no avail. All I need is this info, and I don't want Linux; just a Unix site. Please and thank you for your help. (3 Replies)
Discussion started by: killrazor
3 Replies

4. IP Networking


Hey all, I've bought a few bits from Belkin who seem quite happy to support FreeBSD! Last time I bought a UPS from them and it's still going well :D I saw this on their website that the 16bit PCMCIA card was supported under FreeBSD: http://www.belkin.com/network/F5D5020.html I went to my... (0 Replies)
Discussion started by: WIntellect
0 Replies

5. UNIX for Dummies Questions & Answers

quoting echo 'it's friday'

echo 'it's friday' why appear the > (3 Replies)
Discussion started by: yls177
3 Replies

6. Filesystems, Disks and Memory

HELP! The '/var/adm/message' file increase every few seconds???

Hi, guys, I have a big problem. I've got a sun solaris 4.1.4 workstation, and the /var/adm/message file will add one row every few seconds. It soon becomes a large file. I wander if there are some mistakes configuring the workstation. the /var/adm/message is as follow: ... (1 Reply)
Discussion started by: cloudsmell
1 Replies

7. UNIX for Dummies Questions & Answers

UNIX PATH info required PLEASE HELP (I'm new to unix)

I need to know how to enter a unix path in a cgi script for a guest book: example: My URL is http://www.kitachi.info I have an html file in the main folder on my site, the file is called : gbook.html what would the correct unix path for this file be ??? the part of the script... (1 Reply)
Discussion started by: akitachi
1 Replies

8. UNIX for Advanced & Expert Users

Terminal 'Local Echo' lost on Modem Dial-out

Can anybody help me? I am developing a utility for automating message paging to a BT alphanumeric pager. I am using a USR 56K Fax-modem connected to /dev/cuab on a Sun Ultra-10. I am using the UNIX 'tip' utility to connect to the modem and I have configured the modem as follows: Baud Rate:... (2 Replies)
Discussion started by: mybeat
2 Replies

9. Shell Programming and Scripting

Clearify what it means under 'WHAT' when hit the 'w'-command

I wonder how I shall read the result below, especially 'what' shown below. The result was shown when I entered 'w'. E.g what is TOP? What is gosh ( what does selmgr mean?)? login@ idle JCPU PCPU what 6:15am 7:04 39 39 TOP 6:34am 6:45 45 45 TOP 6:41am ... (1 Reply)
Discussion started by: Aelgen
1 Replies

10. Programming

i can't use 'make' in my computer?

I need to compile a file,but 'make' does not work.please tell me how to use it or need which tools? (3 Replies)
Discussion started by: dsun5
3 Replies
Login or Register to Ask a Question