I am trying to automate order processing for a client their POS vendor doesn't have any sort of API with their software so I was hoping to be able to insert orders directly in the database. so what i want to do is take a snapshot of the database, enter an order manually and then take another snapshot and compare the 2 snapshots to see w...
Is there anything that slowed development down on a project you worked on and if so how did you improve it? We recently introduced continuous integration to solve the problem of a constantly broken build. To increase code quality we introduced code reviews. The client was constantly changing the static data (lookups) so we introduced a...
As part of a data regression and quality assurance exercise, I need to look for diffs between two tables that should, ideally, be nearly identical. I have looked at a large number of commercial products and can't seem to find one that satisfies all of our requirements: Must be able to compare LARGE tables (10 million rows, by 200 colum...
when am going to insert data into a child table for which i have added constraint(foreign key) the constraint is automatically disabling. can u please help me.......... ...
want to be able to explore the schema, run stored procs and run SQL statements. ...
suppose you have some simple sprocs eg AddXYZ(param1, param 2...etc) getAllXYZ() getXYZ(id) what is the "best practice" way of calling these sprocs from the "db layer" i don't want to use linq. just simple c# static methods on how to do this. im using sqlserver. ...
Is it best to use a pre created class / api for database interaction (e.g Pear MDB2 or php's PDO) or create your own? I will be only be using mysql with 1 database and perform relatively simple SELECT, INSERT, UPDATE, DELETE queries. ...
I save 100.000 Vectors of in a database. Each vector has a dimension 60. (int vector[60]) Then I take one and want present vectors to the user in order of decreasing similarity to the chosen one. I use Tanimoto Classifier to compare 2 vectors: Is there any methods to avoid doing through all entries in the database? One more thing! ...
If you need to minimize concurrency as much as possible, which isolation level (repeatable read, serializable, read committed, read uncomitted) would work best? ...
How do you join two data tables from different source databases in .NET? Ideally, I can craft two queries manually and simply join on a single field. In this case, linked servers and scheduled imports are not an option. I've looked into the data relation object, but (correct me if I'm wrong) that only works for parent-child relationshi...
Before denormalizing, I'm wondering what effect this is going to have on the following: Query response time Width of rows in the database Joins necessary for a result Number of queries necessary for requests to complete It seems, if I am not mistaken, that all of these will be reduced? ...
Do any versions of SQL Server support deferrable constraints (DC)? Since about version 8.0, Oracle has supported deferrable constraints - constraints that are only evaluated when you commit a statement group, not when you insert or update individual tables. Deferrable constraints differ from just disabling/enabling constraints, in that...
I'm trying to choose between these query plans for a range query: Sequential table scan Bitmap index B+ tree index Hash index My instinct is that a bitmap index would work here based on what I've read. Does that sound right? ...
Hi all, The question title is probably not correct because part of my question is to try and get some more understanding on the problem. I am looking for the advantages of making sure data that is imported to a database (simple example: Excel table to Access database) should be given using the same schema and should also be valid to th...
WARNING: LONG QUESTION. [QUESTION] If the strategy is to have a branch per database, as described in the problem below, where scripts are version controlled. How do you manage the data migration issues when trying to consolidate to fewer branches? Is it just a cost you incur as part of data migration? Essentially transform scripts wi...
I'm looking for a real-world example for the various ACID properties of a database. ...
I have used Relational DB's a lot and decided to venture out on other types available. This particular product looks good and promising: http://neo4j.org/ Has anyone used graph-based databases? What are the pros and cons from a usability prespective? Have you used these in a production environment? What was the requirement that prompt...
A hashtable in memcached will be discarded either when it's Expired or when there's not enough memory and it's choosen to die based on the Least Recently Used algorithm. Can we put a Priority to hint or influence the LRU algorithm? I want to use memcached to store Web Sessions so i can use the cheap round-robin. I need to give Session...
I would like to use postgresql with foreign keys to define relationships in data so that other platforms/apps would also be able to easily use the same database. Having some kind of ruby DSL to define database schema with migration support would also be great. Which framework would you recommend for me? Is there some kind of framework f...
Our company is developing an internal project to parse text files. Those text files are composed of metadata which is extracted using regular expresions. Ten computers are 24/7 parsing the text files and feeding a high-end Intel Xeon SQL Server 2005 database with the extracted metadata. The simplified database schema looks like this: ...