I am writing a python script that will be doing some processing on text files. As part of that process, i need to import each line of the tab-separated file into a local MS SQL Server (2008) table. I am using pyodbc and I know how to do this. However, I have a question about the best way to execute it. I will be looping through the f...
I am using SqlAlchemy, a python ORM library. And I used to access database directly from business layer directly by calling SqlAlchemy API. But then I found that would cause too much time to run all my test cases and now I think maybe I should create a DB access layer, so I can use mock objects during test instead of access database di...
If the degree of an entity is 8, what is minimum number of attributes required to form the primary key? ...
Hi All, I have installed the latest VisualSVN (2.0.5) and its trac-package on WindowsXP, but ran into a problem. The trac system works, except the "Timeline" tab. When I clicked on it, I saw Oops… Trac detected an internal error: OperationalError: attempt to write a readonly database Does anybody have any idea, why it does not works...
Hey there everyone, Sorry for the bad title, but I have no idea how to put this in short. The Problem is the following: I have a generic item that represents a group, lets call it Car. Now this Car has attributes, that range within certain limits, lets say for example speed is between 0 and 180 for a usual Car. Imagine some more attrib...
I'm using ADO.NET with a strongly typed dataset in C# (.NET 3.5). I want to insert a new row to two tables which are related in an 1:n relation. The table Attachments holds the primary key part of the relation and the table LicenseAttachments holds the foreign key part. AttachmentsDataSet.InvoiceRow invoice; // Set to a valid row, also...
What is the difference between a 'view' and 'base' relation in database systems? ...
At work we are having a bit of trouble with spatial support of SQL Server 2008. In SQL Server 2008 we have a big system in production going on, managing a bunch of important stuff. In some of the tables, I have pairs of coordinates and need to display them to ArcGIS and other GIS software. My question here really is: Is it possible to ...
I am trying to implement a search function on a database table using query expansion, and I'm aware that I have to add the FULLTEXT index on the fields I want to become searchable. I have tried to do this and got no errors from PHPMyAdmin, but when I examine the structure of the table the cardinality of the FULLTEXT index is 0. I have tr...
Hello, Here's the problem : I've got a huuge (well at my level) mysql database with technical products in it. I ve got something like 150k rows of products in my database plus 10 to 20 others tables with the same amount of rows. Each tables contains a lot of criteria. Some of the criteria are text values, some are decimal, some are just...
This is a moot question as I'm not on this project any more, but it continues to bug me. I wonder if anyone has a better idea for future reference and general good programming practices. The textbook approach to security is "role-based security". Every screen, report, or other task is attached to one or more roles; every user is assigne...
Possible Duplicate: Why would I ever choose to store and manipulate XML in a relational database? Although this question on the surface appears to be a rehash of what's already been previously asked, I'll state up front that it is not. My question is not how to store or retrieve XML from a relational database. The question at ha...
Hi, I have a rails app that I'm moving to another server and I figure I should use db:schema:load to create the mysql database because it's recommended. My problem is that I'm using capistrano to deploy and it seems to be defaulting to rake db:migrate instead. Is there a way to change this or is capistrano using db:migrate for a good re...
I have an existing webapp and want to add a tag feature so that users can tag existing objects. The question is should I add a tag column to each object? or should I normalize it and use a tag table where each object will have a collection of tags? I am leaning towards the latter because it feels cleaner, easier to report on and easier t...
I have a table inside my database, and i wish to insert/update/delete entries in a FormView Manner (I mean no datagrid) but a set of textbox/combobox/listbox/checkbox for one record. Before modifying/adding data i have to perform some extra checks to enter correct values to my database. How will i be best off doing it? I am currently usi...
Hello everyone. I have found this project on Codeplex. http://www.codeplex.com/ProjNET I need to integrate this code with Sql Server 2008, and found a similar project on the Web http://sqlspatialtools.codeplex.com/ The second one can be bound to Sql Server. What do i need to do, to "bind" the first one, the same way as the first? E...
I have a table that contains a StudyId, a PatientId, and a StudyStartDateTime. I'd like to graph the totals of the Studies and Patients between two dates specified by the user. The problem is with counting distinct values. Here is the query: SELECT s.StudyStartDateTime, COUNT(s.StudyId), COUNT(s.PatientId) FROM dbo_St...
Hi everyone. The DBDesigner can synchronize only with MySQL? I tried with SQL Server but don't works. DBDesigner Ver: 4.0.5.6 Tks. ...
At my work we have a small database (as in two hundred tables and maybe a total of a million of rows or so). I've always expected it to be quite fast in the order of several ten of thousands insertion per second and with querys taking milliseconds once the connection is established. Quite the contrary we are having some performance pro...
Suppose I am developing a web application that uses a database, and I create a branch in my version control system which requires significant database changes. Let's suppose I can't just use the normal trunk database as I often do for other branches, and in this case I actually need a new copy of the database for my branch. Now, suppos...