I am a system administrator for a company that supports a CRM CMS (Salesforce). I don't like the built-in functionality so I generally manage data through CSV/XLS files for uploading and downloading, because I can write better queries and the like. One of my tasks is uploading Contacts and Accounts. Because of a lack of unique Identifie...
What's a good intro database book for non-technical people? We have a user who will be managing some data and also be making some ad hoc queries. This person is our "subject matter expert" and won't be designing the schema, but we want her to be able to understand more or less what we're doing and how to experiment with making queries ...
I would like to know from the experienced programmers what they consider to be the most important considerations when designing a new database. ...
In my db, I have a table "customerNames" which has two columns "Id" and "Name" and approx. 1,000 results. I am creating a functionality where I have to pick up the 5 customers randomly every time. Can anyone tell me how to create a query which will get random 5 rows (Id, and Name) every time when query is executed. edited I am using M...
If I have a table CREATE TABLE users ( id int(10) unsigned NOT NULL auto_increment, name varchar(255) NOT NULL, profession varchar(255) NOT NULL, employer varchar(255) NOT NULL, PRIMARY KEY (id) ) and I want to get all unique values of profession field, what would be faster (or recommended): SELECT DISTINCT u.profession FR...
I'm looking for a light-weight database library that I can compile into a C++ application. Does any such exist? ...
I have an application where the majority of the database tables have a strong relationship to one other table. Currently I am enforcing referential integrity with foreign keys, but I'm wondering if this is really the best approach. Data in the primary table can be deleted from an admin interface by business users, which means having to d...
Hi, I have doubt in this design(er_lp). My doubt is in how to create many - to- many relationship with entities with composite keys, Secondly, in using date type as pk. Here each machines work daily for three shifts for different userDepts on one or more fields. So to keep record of working and down hours of machineries I have used shi...
This question is a continuation to another question, also entitled Entity Relationship. Dejene: you should transfer the material here into the original question and then delete this question. Elaboration: Yes, 'Field ' is referring to areas of land. We have several cane growing fields at different location. It [each field?] is named ...
I am currently developing a sports website where one of the pages with be forthcoming fixtures in which the user will be able to what team and where the team are playing their next match. I have a database with the following fields... ID TEAM NUMBER OPPOSITION VENUE DATE MEET TIME MATCH TYPE So a row of data pulled from the DB an...
Hi, I have a web application where I am getting data from an oracle database in a gridview. Can anyone tell me how to turn this data into links to other pages on my web application? For example, if I am getting data about a list of objects that have their own ID, I want to be able to click the ID and go to a page with information on ...
hi, I want to use the raise_application_error-procedure to stop the login process. I wrote a trigger, that checks the TERMINAL String, if it is right (I know that isn't realy secure, but at first, it is enough) So the Trigger works fine and does what i want, but the raise_application_error causes an rollback and sends not the exception t...
I need to salt and hash some passwords so that I can store them safely in a database. Do you have any advice or ideas as to how best to do this using Linq To SQL? ...
Triggers seems like a simple solution for Audit logging. Why should I use Interceptors? Database portability is one con of trigger... what are others? ...
Is there any other MS Access DB comparison tool like Cross-Database comparator? I want a tool that does a mass comparison like CDB ...
Hey, Using Apache Derby with Java (J2ME, but I don't think that makes a difference) is there any way of checking if a database already exists and contains a table? Cheers, Pete ...
Hello, guys I am working on a so-called Behavioral Risk Factor Surveillance System (BRFSS), a web query system dealing with questionnaires coming every year. I had hard time in coming up with a suitable database design for it. Here is the problem: Each questionnaire contains about 80 questions, with demographic info, e.g. age, educati...
I'd like to store username that has last modified table row to as a field in every table. I have following setup: an user logs in, web layer calls some EJB 3.0 beans. Those EJB beans create and modify some JPA entities. Now, I'd like that username (from weblayer) would be automatically stored to every JPA entity (and database row) that...
I’m writing an upload function in .NET for presentation images on user profiles. I’m choosing between two different ways of doing it, and would like to ask on advice and opinions as to the pros and cons. Store the images directly on the file system Store the images in the database So far I’ve been mostly pro the first option – naming...
Hi i'm doing a test how hash and salt passwords. Well , i can add hash and salt password to the Database but i got stuck to store passwords from database. i have a simple Database : Table _______ ProvaHS -------...