Hi Given you have a domain model with a simple parent / child relationship, and each entity has it's own associated DAO, eg: Author AuthorDAO Book BookDAO If I want to add a DAO method for retrieving the books by a specific author, what's the best place for it? class AuthorDAO { List<Book> getBooks(Author author); } or class ...
Hi, i want to build a simple online exam system web application where students can give exam. Exam will be evaluated by the course teacher. I choose the entities: student teacher course question Exam result Please suggest that if this is ok or not. Another problem is that how can i store my questions in the database? there will be ...
Hi, Could I have my php scripts on server A and connect to the MySQL database on server B? If yes, how it would be done? Thanks in advance ...
I am designing a simple database of online exam system. But i can not figure out how the questions and the answers should be stored. I am thinking question and Answer as different entities. There will be both MCQ and short questions in the same question set and the number of questions in a set may be dynamic(choose by teacher). Please s...
I'm developing a project where users need to build reporting queries using complex Linq statements to generate data sets. The best way I could think of to compile these user-generated queries and then execute them is to use the CSharpCodeProvider object to build an assembly and then store the result in a database blob. Is there anythin...
I am building an application that includes a feature to bulk tag millions of records, more or less interactively. The user interaction is very similar to Gmail where users can tag individual emails, or bulk tag large amounts of emails. I also need quick read access to these tag memberships as well, and where the read pattern is more or...
I have an employee class with as follows: public class Employee { public string FirstName { get; set; } public string LastName { get; set; } public string UserName { get; set; } public string Password { get; set; } } The properties FirstName and LastName are stored in Employee table in Database1. UserName and Pa...
Hi, How can i define multiple attribute in database. Suppose the name field. It has three parts: Firstname, Middlename, Lastname. And the Address Attribute: Street Address City State Zipcode Country ....... ...
I'm building a local vm for doing web dev rather than using our on site development. I need a database locally, but I don't want to just pull down a production db and use that as it has information that, while not protected by HIPAA or anything, should not be available in the case of laptop theft. Are there any apps or recommended practi...
I have some pretty simple php code that returns binary image data from a database. ob_start(); $stmt = $db->prepare($sql); $stmt->execute(array($ImageID)); $stmt->bindColumn(1, $lob, PDO::PARAM_LOB); $stmt->fetch(PDO::FETCH_BOUND); ob_clean(); header("Content-Type: " . $content_type); fpassthru($lob); Let's call this script get_ima...
I am updating a piece of legacy code in one of our web apps. The app allows the user to upload a spreadsheet, which we will process as a background job. Each of these user uploads creates a new table to store the spreadsheet data, so the number of tables in my SqlServer 2000 database will grow quickly - thousands of tables in the near t...
I need to work with this db and would like to get a quick start. Would anyone recommend a decent documentation/tutorial/examples? I didn't find anything useful at the official website ...
I have a "Student" table which should have name column. But I made another table "StudentsName" for name since names have three parts: firstname, middlename and last name. Now my question is how should I relate these two tables? ...
What is the fastest method to fill a database table with 10 Million rows? I'm asking about the technique but also about any specific database engine that would allow for a way to do this as fast as possible. I"m not requiring this data to be indexed during this initial data-table population. ...
I'm trying to do quite a lot of querying against a Microsoft SQL Server that I only have read only access to. My queries are needing to work with the data in very different structure from how the DB architecture is. Since I only have read access, I can't create views, so I'm looking for a solution. What I'm currently doing is using com...
I'm placing and image into a databse, it could be eitehr an MYSQL database (the Server) or an SQLITE database (a Tablet PC for on the road). The Java application synchs with the server on a dialy basis, uploading new data and downloading any new data. Thats working terrirfic, the requirement is for it to be able to handle images as well....
I have a Visual Studio 2008 GDR Database Unit Test (Data Dude) with some TSQL that calls a sproc. I then have a single select statement that produces a 1-row result set with 2 columns. I want to pass the test if the values are equal and fail if it is not equal. I do not understand how to config/code this, can anyone point me in the right...
I am using php and mysql. i have a question, lets say, I have a userid column in users table under database A, and userid column in purchases table under database B. Can I execute a single query, using innerjoin, to get value from 2 databases? Or I must use multiple queries? Oh ya, if let say, i have this variable: $conn // connect t...
I have 2 databases. Users database and purchases database. Each database has different user and password. If i want to execute a query to call both databases. How do I connect the databases? $db = mysql_select_db(??????); ...
I am using a SQL server table to keep related information with a URL . So there is a Column as "URL" and its type is VARCHAR . In the application we have to use this URL as a unique key to query for information (We are using something like SELECT * FROM Table WHERE URL = "www.google.com\ig") Is there any disadvantages or known drawbacks...