My situation is that I screwed up essentially. I inherited my code base about 1.5 years ago when I took this position and rather than reinventing the wheel, even though I know now that I should have, I kept the DAL in pretty much the same structure as the previous developer. Essentially there is one file (now at 15k lines of code) that...
I have two MySQL (MyISAM) tables: Posts: PostID(primary key), post_text, post_date, etc. Comments: CommentID(primary key), comment_text, comment_date, etc. I want to delete all the comments in the "Comments" table belonging to a particular post, when the corresponding post record is deleted from the "Posts" table. I know this can ...
Currently we only use one database server, and that should be all we need for quite some time. However if I was to convert the database to use HiLo for a POID strategy is there anything I can do now that would make sure I don't have problems with replication later? Is HiLo even compatible with replication? I am actually having quite a...
I am writing some stored procedures to create tables and add data. One of the fields is a column that indicates percentage. The value there should be 0-100. I started thinking, "where should the data validation for this be done? Where should data validation be done in general? Is it a case by case situation?" It occurs to me that alt...
I want to implement a Facebook updates(user action and notifications) on my web application as well. I am using LAMP. Should I make a db table where I store duplicate data or should I make calls to different tables to show user his updates. Is there a better way to do this. For Example: When someone comments on user's profile then that...
I've written some very basic tools for grouping, pivoting, unioning and subtotaling datasets sourced from non DB sources (eg: CSV, OLTP systems). The "group by" methods sit at the core of most of these. However i'm sure lot of work has been done in making efficient algorithms for grouping data... and i'm sure i'm not using them. And my ...
Database design question for y'all. I have a form (like, the paper kind) that has several entry points for data. This form has changed, and is expected to change over years. It is being turned into a computer app, so that we can, among other things, quit wasting paper. (And minor things, like have all the data in one central store that c...
First.. here are the two tables I've created (sans irrelevant columns).. CREATE TABLE users_history1 ( circuit tinyint(1) unsigned NOT NULL default '0', userh_season smallint(4) unsigned NOT NULL default '0', userh_userid int(11) unsigned NOT NULL default '0', userh_rank varchar(2) NOT NULL default 'D', userh_wins int(11) NOT ...
We need to run reports at a scheduled time of the day. The application runs 24*7 and so there is not "off-peak" time as such. Therefore, running the reports should not add undue load on the system. The application runs on WebSphere v6.1 and the database is Oracle 10g R2. I have the following approaches at my disposal A set of de-nor...
hi all what are the databases that we can connect to from forms?(that is can we connect to IMS database) ...
I need to store (possibly long) text in a MySQL database. The text may contain special characters and non-latin letters and it should be possible to perform full-text-search on it. MySQL 5 can't store such characters (but it will be possible in MySQL 6), so I though about URL-encoding the text before storing it and decoding it after fetc...
Need to be able to set server(s) that replicate all information, as a master data store that has all the data. Also need servers that specifically store/replicate certain data, available in local LANs, so that when the internet connection goes down, they can still access their local data. Under normal circumstances, the clients will ac...
In databases like MySQL or Oracle, how are indexes implemented? I think regular indexes are stored as B-trees, but couldn't find anything about composite indexes that index on multiple columns. I'm looking for the names of the data structures used so I can research them. More generally, where can I find more such information about datab...
What is the analogue of a class diagram in the world of relational/SQL databases? And what is a good way to generate this equivalent in Eclipse? Free is better, but good and commercial is fine as well. ...
Why did object oriented databases fail? I find it astonishing that: foo bar = new foo(); bar.saveToDatabase(); Lost to: foo bar = new foo(); /* write complicated code to extract stuff from foo */ /* write complicated code to write stuff to database */ Related questions: Are Object oriented databases still in use? Object Orie...
Hi All, I started developing simple application in WPF and XAML. I want to try accessign the sql server database and display the data from stored procedure onto the UI form. I have a table called parentProject -> idParentProject (pk), txtParentProjName varchar(max). my SP is parentProj_sp -> select * from parentProject. n I want to us...
When using a DBM database (e.g. Berkeley or GDBM), is it better to store data using fewer long strings or more short strings? I can easily structure my data either way. I'm looking for 'better' in the performance sense, but I'm interested in other implications as well. ...
Hello, I can't seem to find why this function doesn't insert records into the database. :( I get no error messages or whatsoever, just nothing in the database. EDIT: this is how my query looks now .. still nothing .. connection.Open(); XmlNodeList nodeItem = rssDoc.SelectNodes("/edno23/posts/post"); foreach (XmlNode xn in nodeItem)...
I am about to start a project using ASP.NET MVC. As part of the project, we need to display some data to the user. The data consists of an object graph that consists of 35 days per line. Each day can be a work day or off day. If it is a work day, there could be additional information associated with the work day. So basically, we have an...
I need to produce a large HTML table with quarterly counts for several (around 50) different groups (jurisdictions). I have a MySQL table with around 16,000 rows which have 'jurisdiction_id' and 'quarter' fields. Unfortunately my client doesn't want the resulting report to be paginated. How would I construct a good MySQL query from which...