A database is any organized collection of data organized to provide efficient retrieval.
0
votes
0answers
13 views
Caching and indexing before persisting to DB [closed]
I'm quite in need for ideas for implementing indexing and caching on this code:
http://bit.ly/13SiKpW
Basically what I did was a proof-of-concept java.util.Map interface to the datastore and that ...
3
votes
1answer
107 views
asp.net (vb.net): handling of open database connection and calling shared function from web api
I'm working on an ASP.NET project using VB.NET that uses Dapper
and the code as implemented so far runs fine with just me testing.
In the example below, Dapper calls a stored proc.
But my I am ...
0
votes
0answers
64 views
Android database access
For my simple Android application I don't want to use an ORM, anyway I'd like to have a db-communcation layer easy to user, to read and efficient.
This is my solution: every entity (ex: Person) as an ...
2
votes
1answer
91 views
DAO Layer Code Review
Please review my following code for DAO layer.
public List<Channel> getListOfChannels() throws DataAccessException {
// will have the channel in form of List
// to hold the ...
1
vote
1answer
47 views
Keeping track of people's relationships in MySQL using a people relation table?
I am trying to track relationships among people. I came up with my own solution, but wondering if there might be another way or better way of doing this. To keep it simplified, I'll post just the bare ...
2
votes
1answer
59 views
Testing database table creation with NUnit
I'm new to using NUnit and have written a test to check for the existence of a database table. I have the below code that should check whether a new table named NewTable has been created in the ...
2
votes
1answer
50 views
ORM Entity with many similar relationships
To provide some background context, I'm implementing a web-based solution (Java, Spring, Hibernate) that allows the creation/authoring of task-centric workflow documents. Basically a workflow ...
1
vote
2answers
97 views
Make code looks more cleaner in the run method
I am trying to insert into Database using JDBC and each thread will be inserting into database. I need to insert into around 30-35 columns. I wrote a Stored procedure that will UPSERT into those ...
3
votes
3answers
52 views
Simplify things in the run method to look cleaner
I am trying to insert into Database using JDBC and each thread will be inserting into database. I need to insert into around 30-35 columns. I wrote a Stored procedure that will UPSERT into those ...
1
vote
2answers
97 views
PHP Class Inheritance / Object Instantiation / Object / Property Scope w/ Child / Parent Classes & Dependency Container Class
In PHP, I have a parent/child class and am using dependency container to load them. I am trying to use the same database connection on all of them without duplicating the object.
CLARIFICATION: MY ...
1
vote
2answers
82 views
First Database Schema - How did I do?
I would really like some advice from any DB gurus who have a few minutes free. After doing some reading and playing with sqlfiddle over the weekend I have constructed this postgresql schema and it is ...
0
votes
1answer
56 views
Nhibernate session and transaction implementation
In order to create loose coupling architecture on my web applications, I have created my own implementation for orm, in this case, nhibernate.
I want you please to review the code and tell me if you ...
0
votes
1answer
54 views
How to write a stable WCF service
I'm writing a WCF service for validating password and getting company ID for the clients that requests the services. The service runs on a server locally as a windows service, which sends queries to ...
0
votes
2answers
92 views
Backup a database over an SQL connection
Developing some industrial WinForms application for some industrial setting, I wanted to provide users of our software with a convenient way to back up the database the software uses (to send it to ...
0
votes
0answers
57 views
Building database from file C# Mysql
well as the question reads I am building a database with 3 tables. Now these tables are going to be used to store names in.
Table 1 will store First Names Table 2 will store Last Names Table 3 will ...
