I am working on a content management application in which the data being stored on the database is extremely generic. In this particular instance a container has many resources and those resources map to some kind of digital asset, whether that be a picture, a movie, an uploaded file or even plain text. I have been arguing with a colle...
MyTable.Update(long.Parse(id), txtLocation.Text, txtCode.Text, locale, chkAvailable.Checked, DateTime.Now); Neither chkAvailable.Checked or DateTime.Now cause an update but changing the other fields do... What's going on? I'm using SQL Server 2005. .NET 3.5 SP1 Rob ...
Currently working on a project that is centered around a medical nomenclature known as SNOMED. At the heart of snomed is are three relational datasets that are 350,000, 1.1 mil, and 1.3 mil records in length. We want to be able to quickly query this dataset for the data entry portion where we would like to have some shape or form of auto...
I am tasked with exporting the data contained inside a MaxDB database to SQL Server 200x. I was wondering if anyone has gone through this before and what your process was. Here is my idea but its not automated. 1) Export data from MaxDB for each table as a CSV. 2) Clean the CSV to remove ? (which it uses for nulls) and fix the date s...
I'm creating a DW that will contain data on financial securities such as bonds and loans. These securities are associated with payment schedules. For example, a bond could pay quarterly, while a mortage would usually pay monthly (sometimes biweekly). The payment schedule is created when the security is traded and, in the majority of case...
While computer programming evangelists predicting the future of Cloud Computing to be very bright, is there a chance for relational databases to be on their way out? What are the DBs that are more suitable for Cloud Computing? ...
As I learn new features in Oracle, sometimes I want to test how a function or type conversion works. Is there a quick way to evaluate a literal expression without querying a table? For example, if I wanted to see how date arithmetic worked, I might construct the following query: SELECT SYSDATE - 1 as dateMinusLiteral, TRUNC(SYSDATE) m...
Hi guys, I am trying to increase the overall Integration test execution time and I am currently evaluating various in-memory db solutions. The idea is to have DAOs hit in-mem db during the tests as opposed to hitting a real DB. This is a java app using Hibernate for persistence. I'd be interested to see your experience with one of thes...
I don't quite know what to use for terminology, so bear with me... Are there any cross-platform frameworks out there that facilitate a kind of "virtual file storage" to encapsulate adding files along with a database of metadata? I'm thinking about something along the lines of iTunes or iPhoto, where the program manages a whole bunch of ...
I'm using SQLite ADO.NET in my project so that I can unit test using an in-memory database. I want a copy of my real database but it is across the server. From what I've read, it looks like I have to specify ":memory" for the data source for the SQLite connection string. My problem is that I don't even know if it's possible to load a ...
I'm starting a new opensource project (for real estate) and wanted to focus on using MySQL, but would also like to ensure it works in PostgreSQL. What is the best way to doing this without having to continually test in both environments? I'm assuming the db schema is close to the same, but there could be some differences on the SQL scr...
Consider the following two tables: User - UserID - UserName Group - GroupID - GroupName The obvious association is that Users will be in Groups. This by itself is a simple many-to-many join situation, so lets add a 3rd table: UserGroup - UserID - GroupID Under this textbook schema, I can easily include a specific User in a s...
I have created a memory-only server instance of hsqldb , is it possible for me to connect to this memory database from 2 clients in separate jvms ? ...
We are considering using PostgreSQL 8.4 on RHEL for some upcoming projects. We've been heavy users of MySQL since 3.23 (now on 5.1). The database servers are behind a load balanced cluster of web/app servers. Our usage is mostly business related web apps (user accounts with lots of emails / contacts / stats / projects / plans / task...
Wondering what is the best or most popular database client tool. Similar to Microsoft's SQL management studio, but one that can work with various databases. Other tools I have found are: Toad for SQL Server Database fishing tool Apex SQL Studio Some of these tools can even compare and sync database schema's and some cases the data ...
New to database and so no to get upset with simple questions. As far as my googled and gathered knowledge normalization reduces redundancy of data and increase the performance. But really, I didn't understand what exact reason for dividing the master table into other small tables, applying relationship among them, retrieving the data usi...
I want to select a row where the matching condition is What's. How to write the Query? I can't write like - "SELECT * FROM WHERE [TITLE] LIKE 'What's'.. What to do ? ...
Hi , I am trying some way to optimize following sql statement: exe_sql "DELETE FROM tblEvent_type WHERE eguid in (SELECT rowid FROM tblEvent_basic WHERE sguid=11);"; exe_sql "DELETE FROM tblEvent_group WHERE eguid in (SELECT rowid FROM tblEvent_basic WHERE sguid=11);"; It is said that sqlite3 did not perform well in subquery and not...
I am trying to restore database data using the following command from a large .sql file "Type myfile.sql | sqlsmd –S server –U username –P password" I get the following error: Sqlcmd: Error: Scripting error. I am unable to open the file, there is not enough memory. ...
Hello, I'm designing an application that receives information from roughly 100k sensors that measure time-series data. Each sensor measures a single integer data point once every 15 minutes, saves a log of these values, and sends that log to my application once every 4 hours. My application should maintain about 5 years of historical da...