Databases Knowledge Base
Databases? What are the different types of databases for small business? (accounting firm) What are the pros and cons of each program? Would Access be the best? Deltech wouldn't work right because its for larger companies?
Are websites that sell wholesale databases scams? Or do they actually have good information? I want to start selling items on e-bay. I have found some wholesale websites with pretty good prices but im thinking, if this is such a steal why isnt EVERYONE just buying from these websites and it seems too good to be true, i have seen many websites that sell wholesale "secret" databases that cannot be found doing basic searches. My question is, is it worth dropping the 30-75 dollars to get this information or is it just a scam?
How to Connect two databases in two different computers ? I need to develop a system using HTML, PHP, Apache. The system will have two databases in two different locations. Once in 24 hour one database will call/connect with other one and update so there can be no data inconsistency. How do I do that. I have worked in database system before but those are stand alone type not like distributed. Need more than suggestion. Coding will be greateful help but pointing out (beside coding, showing what to do) will also help. HELP !!!!
How do I use databases to make an inventory? I am interested in making a database with all my items. I want to include a picture of the item in the database. I am using Open Office and would like to create something where I can view all my items. I really want to learn what a database is capable of. If anyone could point me in the right direction to learn the basics about databases and what can be done with them would be much appreciated. Thank you.
Would Databases and Information Systems be a very difficult college module? Im trying to choose modules for college and this seems ok. Just want to know if it is difficult as i have no previous experience with databases.. things like Boyce-Codd and third normal form dont seem all that easy. Also is it worth studying? As in will i use it much in electronics? Thanks for any advice!
How much could I sell my databases for? I research small businesses and compile databases on company info that I find. How can I find out how much people normally expect to pay for this type of information? I am aiming to supply telemarketers and web designers/developers and improvers/email marketing companies/Insurance companies. Pretty new to this type of work. So any help with how much I could charge would be most useful, also how to sell them and where. I was thinking I could perhaps sell them as hard copies on Ebay one fee for multiple rights (to more than one buyer) or sole rights to one buyer, under Ebays BUY NOW policy. Compiling my databases by postal areas. eg. Cambridge, Birmingham.
How do I merge two microsoft access databases? I have two access databases that have exactly the same structure and layout, but different information. I'd like to merge them into one database. What is the easiest way? I'd be most grateful to know.
How do I link tables between two SQL 2005 databases on the same server? I have two SQL 2005 databases - GIS db contains tree tag IDs and Trees db contains info about each tag. I'd like to establish a link/relationship (preferably one that allows referencial integrity) between tables in each database. Is it possible to include tables from another database in a database diagram? Thanks so much for the help!
What the best resource for creating Excel Databases? Books, websites, etc. I don't want to use access, I want to use excel for databases that I am creating, where can I learn the most sophisticated and up-to-date info on how to do it. Thanks! the template for a database, not the data. I know that there is a way to turn excel into a "database" type of file, I just don't know how. ANy information on wehre I may find this type of instructions, will be greatly appreciated. Thank you.
How many types of databases are there? Want to know how many types of databases are there. Like Oracle, Microsoft SQL Server, IBM DB2, Sybase, Daffodil, MiniSQL etc. I once came across a website where all the types of databases were listed in alphabetical order.
Is it possible to lock databases with a password? Is it possible to lock the database with a password and make the login screen to enter password disable for sometime and enable it after a period of time.The other question is Is it possible to store patterns of iris and fingerprints in databases oracle and SQL or else suggest me other databases which has these features. How to compress the size of the database.
Including searchable databases on a Web Page? I want to set up a Web Page, which will include a searchable database. What web and database software should I use? (I currently use MS Access and Excel). And what image-editing or managing software should I use? Are there any good ones that are free or cheap? Web Hosting is another matter - what can you recommend? NB - I had a look at the Yahoo page design tour, and it makes no mention of databases or search forms or anything useful. Thanks, Robbie.
What databases/archives exist for checking ocean conditions (particularly swell) in the past? I require information as to the swell heights and other surf conditions during several nights of experimentation in the intertidal. I find it very easy to find web sites which give full surf reports for that given day's conditions, but I am unable to find a comprehensive database/archive for looking up surf conditions from the past. Any assistance in this matter would be much appreciated.
Which databases provide the best concurrency control? hi, I am working on a dissertation and i need to know which databases provide the best concurrence control. i am doing a comparison between Oracle, Ms SQL Server, MySQL, PostGre SQL and Ms Access. Please do help Thanks
Should I use multiple databases when creating a web application? Hey there, Just wondering what is the best way to build my database. I know this question depends on what type of application I'm developing, but in general, I was wondering if it was common to separate some things out into different databases for security reasons - for example, keeping user info in a different db than everything else? I know there should be backup db's as well, but my question is specifically within a single web app? Thanks.
How to compare fields in two dissimilar access databases? I have two dissimilar access data bases both of which contain a social security number. I need to determine which ssn's appear in both or conversely which do not. I am working in access 2003. I cannot find mention of any compare option so maybe someone could suggest another approach.
Where can I get databases with company names & addresses from? I need to do a load of marketing (UK) and for this I will keep all companies I contact on a data base. Problem is, it takes forever to find details and write them in. Can I get ready made ones on the Internet (in excel form)? And are there free ones or will I have to pay? Its for anything to do with construction and landscaping.
What Tool Would You Use To Create Sophisticated Databases For The Web? There are a variety of tools in the marketplace for developing databases for websites - some of which include PHP/MySQL, Microsoft Visual Web Developer, Ruby, Python, etc., etc. I am looking for something that is powerful yet easy to use. I am most comfortable with PHP/MySQL, but am curious of front-end tools that may or may not use PHP/MySQL on the back-end. What are your suggestions?
Importing a list of users to multiple databases? I need to know how I can add users to several databases that has been defined in the SQL Server without reinserting them in every database. There's an "Export list" option on Right Clickmenu inside the users object but I can not find nothing for importing them back. Please Help Me!
what databases can you connect to an html page? I was wondering what databases you can use with an html page I know of microsoft access i was wondering about any others?? im making a database driven website but dont wanna use php or another language just html pages thanks!
where can I find databases of information in access or sql format? I would like to find a place where i can find all different types of databases which i can download and use on my websites. Is there any place where you can go to download .mdb files or mysql dumps? Specifically i am looking for things like a mixed drink library or a video game cheat code database.
databases? how are they used? what are they used for? charachteristics that exist in databases examples of organisations that use databases
databases? does anyone know any free databases i could use to find primary documents? also..is search.com a database?
Databases? I have to compare different databases, these are ORACLE and MySql, I also need to understand advantages and disadvantages to both in regards to creating an online web database system. Thanks!
Databases?? For English class, we are writing a persuasive research essay, and I need two more sources. She doesnt want us to Google them, she wants us to get information off of databases. We have them at school, but I am at home, and I need them by next class time. (which is the day after tomorrow). So my question is: Does anyone know of a decent database? I might have to get an account somewhere, and that's okay, I just need something that it's simple to get an account and will give me decent information. My topic is that we should have more of a free period instead of our SIP time, which is like a 2-hour study hall for us. I think it would be more beneficial, so that's my question. I just didnt really mention any specifics, because sometimes people take that to mean I am looking for answers or someone to do my homework for me. I'm not, I just need a place to get the information. And when we have the data, we are supposed to print it out, highlight the importants parts, and then make note cards. I know what to do with it, and the info I need, I just need a decent database to get it from. A link would be great.
databases..? im doing some ict coursework and i am stuck on why ID numbers are useful in databases anyone know? thanks
………..Databases? If you wanted to store video, audio, text, dates and numbers what type of database would best serve this purpose, and why?
Databases ? what are some things to consider when doing operational testing.
Join databases? PHP help? Okay I have a database of people that work in certain cities. I have a second database with other (secondary) cities (near by) that they work in. What I want to do is go into the first database and see if there is no one listed for that city. If so, go into the other database and find those who have that city listed as a secondary city. Then get their ID and go back into the first database and get their info (using ID). Code: check for primaries if($cat_rows == 0) { $cat_altresult = DatabaseSelect(MY FUNCTION.. ITS FINE searches for secondary cities get array??); $cat_rows = sizeof($cat_altresult); if($cat_rows != 0) { $alt_msg = "blah"; } else $alt_msg = "blah blah"; } Take IDs from secondary cities, go into primary table and gather info for EVERYONE who has that city listed as a secondary. Getting the multiple rows is my problem... i think... someone recommend a join, but I am not sure how to do this on two databases. Thanks Someone recommend a join, but Im n I meant tables... :\ same DB two tables... my bad
How to identify unused databases? client company has around 25 sql servers . Each server has got 5 to 10 databases. Some of the databases are old. We don't know whether any applications using old databases or not. Is there any way we can find the unused databases in past 3 months or past 1 year using some Lastupdatedatetime or last action on sql server system tables using T-SQL scripts. If no application is accessing the database and no actions performed on that database from past 1 year then we need to delete that databases. How to identify unused databases? Any kind of help is greatly appreciated.
Hi, using ms access want to create a main database and "child" databases.? I would want the information from the child databases to update the main database(Using Ms Access). For example have all the databases in one folder, then when the child database is replaced with one having the current information, the main database gets automatically updated.The child databases would be used in standalone PC and from time to time information submitted to update the main database (also on a stand alone pc). Thanks for your help
ICT Databases help!? I have got my yearly school exams all next week and I really need some help for ICT revision on Databases. My Teacher told me that the exam will be focused on Databases. We learnt about Databases ages ago and I can't remember what they are and what parts there are to a Database. I have tried looking on the internet but I can't find anything. I just need a few definitions on some Database words eg: Query, Form, Field etc...AND MORE!!! PLEASE HELP ME!!! Thanks xxx
Uploading mysql databases in cpanel? I did a full backup on my old host which stored all my html and mysql documents. The mysql files are stored as .sql files. On the new host, in the backup section of cpanel it has a spot to upload databases. I keep trying to upload these .sql files and it says "Restoring database" after it uploads and that's it. I reload my cpanel page and it never shows the databases I uploaded. Then I figured i might have to manually create the databases and THEN upload them, but it never uploads them. The database always appears as empty. The sql files are not empty. Any ideas? I have created the database and added the same user to it as it was in the old web site. Same username, password and database name. And it doesn't upload
Illegal Databases? Is there any such thing as a "illegal database"? Is it possible to create a database system - and for it to be deemed not legal? Someone once used this phrase to describe one of my databases I designed and hope to sell (with no information in it obviously) - for a organisation a while back - and it worried me a bit - so I need to know is there a definative list of "illegal databases". Cheers.. Thanks for the response.. He wasn't saying it about the structure or code. (which is excellent btw). He meant the database itself was illegal.. Thanks Slipperm... The guy did seem a bit of a twerp tbh.
Databases - When is it appropriate and where are they used? I would like some answers to these questions about databases: When is it appropriate to use a database? and Describe 5 distinct examples of where databases are used in the wider community. Any answers will be well appreciated. Thankyou.
Databases: How to link an Account table with a Savings table and a Current table? Hi all! Databases question this time - I'm trying to build an ER diagram, and basically came up with this: SAVINGS 1 ------------------ 1 ACCOUNT 1 ------------------ 1 CURRENT While I know this isn't the most strategic approach, does this mean that if I create an account I'd need BOTH a Savings and a Current, or can it just mean 'either or'? Thanks :) I'll rephrase it: I have three tables: ACCOUNT, SAVINGS and CURRENT - trying to model a simple bank system. I'd like to know what relationships to put between account and savings AND account and current; right now I have one-to-one relationships on both ends. What I was wondering is, if account is related to BOTH savings AND current, how can I make it so that IF one of the tables is filled out, the other CANNOT be? :)
Do Yahoo Groups Databases support foreign key relationships? I recently created a new Yahoo Group and saw a database option. Cool, I know lots about databases, and some of the information I'd like to provide to group members could be very nicely represented in a relational database. However, I did not see any way to set up foreign key relationships between tables, nor a way to save a "query" to join tables. Is this supported at all in the Yahoo Groups Database? Thanks
Program for Large Databases? I am currently using Microsoft Access to manipulate large databases. The file is larger than 2 gigs and Access does not support this database anymore. I need a software system capable of handling a LARGE amount of information. Any suggestions for an adaquate program?
compare excel databases? I need a macro, or an excel aplication that will compare two databases in this way. Find the values or texts in a selected column from one database in the other, then copy some asociated values to the other in order to finally have two equal databases or at least the most similar posible. Sometimes the match will not be perfect but very similar, in such case, the aplication should ask the user what to do if it should copy the asociated values or or leave that registry (line) as unmatched. is there anyone out there that i could hire?
Microsoft Access - Databases? Hi, we've been given a few questions in class to do with microsoft access and creating databases. Strangely enough though, we'vew never used the program before and they're asking us to answer questions about it, which seems a little odd. I've answered as many as I possibly can, but am confused with a couple and as, as said previously, I've never used it before, I really do have no clue as to what the answers may be. They are: 1) What is the purpose of a databse, and how will it make some company's run more efficiently? 2)What is validation, and why is is to important? What could go wrong if validation was not used? 3)If you had 3 linked tables, how would the database work overall? 4) Once the data is inputted, how can the data be processed? 5)Why is microsoft access such a good choice of program for creating databases? Many thanks!!
Question on hosts and databases....? Hello, I am a web designer and currently have a business package with 1&1 Internet Ltd. I have recently been asked to design a website with a blog, but have only recently noticed that I'm only allowed up to 2 databases with my package. This seems an awfully small number! As in..1 more blog/e-comms website and I've maxxed it out! Is this correct? The larger packages allow up to 8 and 15 respectively...but that still doesnt sound like a lot to me. If i made 15 blog sites then I will have maxxed out the maximum package!? That sounds crazy to me. Is it right? I've also considered swapping to a different host- one that's UK based such as NamesCo or one such as IWD who offer up to 50 databases on their largerst package which is nearly half the price of 1&1 Internet's largest package. But I'm worried about the difficulties of such an idea. Transferring domain names etc and also the possibility that other web hosts just may not be able to do everything 1&1 does. Any suggestions please? Thanks for the help. However, I don't know how to add more tables to a database. I don't even know where I can see the database. I just know the blog is using one.....?! It would be good if I could use the same database for multiple blogs/sites but is that a bit dodgy?
Do you work with databases? I need to interview someone that works with databases for my Database Management class. If you are interested please contact me by replying to my email. The questions are fairly simple, but I need at least 1 page of information. Any help would be greatly appreciated. Thanks.
databases question ? hi..is there any difference between SQL and MYSQL databases...and does php have functions for non mysql databases.
Suoer Secret Databases? I disagreed with someone on a question here earlier,so she sent me an email informing me that I didn't know what I was talking about because I was uneducated and did not have access to the super secret federal databases she had done all her research on that proved I was wrong. My question to you is this this-When did America become a nation of unmitigated nut cases? Of course,being apparently unable to spell 'super' doesn't do much for my position.
Question about computer databases? I have to write a paper comparing two or three database systems that can be used in a hospital setting. These databases have to be able to handle not only text, but images. Everything I've looked up on the Internet is just confusing me even more. I don't understand all this mumbo jumbo! What kinds of databases do hospitals use?
relational databases? Does anyone know of any good websites that have tutorials for creating relational databases using microsoft acesss 2003 and does anyone have an idea for what sort of shop i could do my relational database for...? i'm only at highschool in the final year so it cant be to hard or easy
Linking tables in two MySQL databases? Hi, I have two MySQL databases, one forum and one directory and I need some help on how to link the Username and Password tables between the databases so that a person can sign up on database 1 and it automatically updates database 2 so they can login with the same details. Any help would be much appreciated. I've now created one database from the two but I still have two seperate tables feeding to the two programs, I'm quite new to MySQL so this is prob easy to do! I have table 1 called "dir_editors" with the fields "username" and "password" this is the table the data would be entered into. I then need this to pull automatically into table 2 called "pp_users" with the fields "username" and "user_password". So the data from table 1 username feeds to table 2 username etc. Please help I'm going nuts!!!
Science Databases access help? Do you know some good free science databases with full articles/papers ? or if anyone has some spare login+password for access into: Web of Science ISI Web of Knowledge or some other big database i would be grateful ;-) fx2006@centrum.cz
How to integrate databases with Adobe Flex? I'm in the brainstorming phase of a project in Adobe Flex and it's become evident that I need to use a server-side database to manage data. My questions are: How can this be done in Flex?; Which language would be best for working in Flex (MySQL)?; and finally Are there any good tutorials online that could help after I've picked out my database and language? I'd prefer video-based tutorials since I learn better visually, but online documentation works good too. If you've used Flex with databases before, could you share your thoughts on the process and what I should know going into it? Thank you all for the help.
On football manager the databases I made wont Show up !? When you click on new game normally it will give you an option of what game database you want to use but at the moment it just come's up with the database which comes with the game. By the way I made the databases on editior ! thanks for all help
How do you link two mySQL databases together? My host has a limit on the amount of memory you can have in your mySQL databases. While I can have an unlimited amount, each database can only have 100 mb in it. I'm at 129 mb, now, and I'm getting Database Errors. My host (1and1.com) responded and said I had to link another mySQL database to the original, but said that they don't support the script, and could provide no further information. Do you know what this? Any ideas on how I can solve this problem?
examples of databases? what are some databases of any industries or companies that feature some kind of information? and i need the source.. i looked on d internet but i cuddnt reli find anything.. so i wanted 2 ask here.. so that i myt get answers from some experienced people who hav actually worked at some company which use a database..
How many Database Administrator need to support 100+ production databases ? Nature of job : Install, create db, apply the quaterly patch , support the business application support by 24/7, problem support, contact oracle for problems, all the databases are mission critical, backup/recovery, upgrade with latest relaease of sw, maintain standard, meet the audit, etc
fantasy football databases....? I'm asking a question that is similar to one that someone else has asked, but which still hasn't been answered. I'm learning a couple of server-scripting languages, and getting familiar with SQL and databases in general. I'm currently working on a small fantasy football league application. I want to know: is there a database on the web which I can access from my scripts to get real-time or "live" NFL player stats? Oh, by the way... I HAVE GOOGLED IT, YOU IDIOT! Jeez, real helpful...
Querying data from online databases? I want to know how some programs can query data from online databases and search engines. Examples: Expedia - How do they go out and search all the different prices on all the different hotels on different websites? Weather Applets- If I wanted to make a weather applet to show the weather in different cities, I would have to have access to an online database where I can retrieve my data. Some job search engines (premiumjobsearch.com) gather job posting from various different websites and compiles then into one list. How do they do that? Wouldnt they need access to the various websites online database? I have this 3rd party program that enables you to log onto your brokerage account, make transactions and get quotes? Sure you have to provide you credentials, but how can they do they connect to get that data? How is it possible for these programs and websites to get access to this online data? Do they look at the querystring or source code of the webpage? So how you can you locate the RSS feeds?
Career in Databases? I like to earn a solid career in databases like Oracle,SQL Server, MySQL etc.Currently i am preparing for OCP(Oracle Certified Professional) exam. I like to know what is the best way to do preparation and which area in databases has got the most jobs around the world or in USA?
Relational Algrebra in Databases Help? Anyone know an easy way to remember the basics of relational algebra for databases, i.e. join, project...etc?? I need to learn it for my university databases class and i cannot work it all out :(
Does javascript use databases? I know you can make forms for webpages in javascript. But it doesnt tell you if you can add peoples details into a database with javascript. Can javascript use mySQL databases? if not arn't the forms pretty pointless in javascript?
Powered by Yahoo! Answers