Let's say for example we've got a SIMPLE eCommerce system, with two separate systems: an Inventory Management System (IMS) and an Order Management System (OMS). Assume IMS provides information around inventory (getItem, getItemQuantities etc) and OMS provides ordering services (startOrder, addItemToOrder, finalizeOrder etc) These two s...
I've got a requirement that I believe must occur very frequently around the world. I have two records that are linked together and whenever a change is made to them a new pair of records is to be created and retain the same link. The requirement I'm working on has to do with the insurance industry which requires me to deactivate the cur...
What are specific scenarios where pessimistic concurrency is used? ...
Hello Everyone, This is my first question on StackOverflow, so please be nice ;) Let's say I've got a trigger like this: CREATE TRIGGER trigger1 ON [dbo].[table1] AFTER UPDATE AS BEGIN --declare some vars DECLARE @Col1 SMALLINT DECLARE @Col1 TINYINT --declare cursor DECLARE Cursor1 CURSOR FOR ...
I am looking at ways to make our application more extensible and easier to manipulate without having to alter the web.config (or, in our case, application.config files, which contain the appsettings node). One way I have thought about is keeping the app settings in the database table that has a sqlcachedependancy. This means that: Any...
I am accessing a MySQL database within a C++ app using MySQL C++ Connector. It works fine if I have the C++ and the MySQL on the same machine. So, something like the following code works fine: sql::Connection *_con; sql::mysql::MySQL_Driver *_driver; _driver = sql::mysql::get_mysql_driver_instance(); _con = _driver->con...
We have a SQL 2005/2008 database that has a table with a computed column. We're using the computed column as a discriminator in NHibernate so having it in the database is proving to be very useful. In order to gain the benefits of faster integration tests, I'd like to be able to run our integration tests against an in-memory database su...
In one of my very previous company we used to have a separate table that we stored long descriptions on a text type column. I think this was done because of the limitations that come with text type. Im now designing the tables for the existing application that I am working on and this question comes to my mind. I am resonating towards s...
Which is the best Data Modeling and Web Site Wireframe tool for web application ...
How to access a remote database with Visual Basic 6? It's been a while since I've done any code in Visual Basic 6, I remember ODBC connections however I'm not sure how I would go about it. All that I need is to have a database on a host computer and then some clients would connect to it, probably without need to guarantee simultaneous ...
Hi, I have an Apache Derby database running (in networked mode) inside a java swing application, I connect to it through direct JDBC calls via a java client application. This is all very good and works great however I know have an additional requirement to implement concurrent licenses for this client/server application. Ideally a user...
Is it possible to query apache derby for a list of current connections/active sessions? Any system tables etc? thanks, Phillip ...
I'm trying to build a blog/messageboard that uses static HTML files to serve content. I know MovableType used to manage their blog engiene this way, but using Perl CGI scripts. How do I edit/append to HTML files preferebly using PHP? What other methods would people reccommend? ...
What would be the best way to separate users and guarantee processing power? Scenario is this: Every user has their own database. Every user has purchased on guaranteed processing power amount of X cycles or whatever you use to measure it. The most important part is that all users must be completely separated. Good way to grasp the ide...
can i use javascript to save an item to a database using sql script? ...
Hi there I have a projects table which has two foreign keys for users (user_id and winner_user_id), one for the owner of the project and one for the winner of the project. Something like +----------------+-------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Defaul...
I was going over AdventureWorks2008 database and wanted to create a new table that associates a product to a sales person. There is a many-to-many relationship between those tables. The question is, Of two schemas, Sales and Production, does ProductSalesPerson table belong to? ProductSalesPerson doesn't neccessarily belong to either ...
I've been reading up on the benefits of salting and hashing passwords, but one thing still eludes me... When I provide a random salt for each user, how do I then know what the salt was when I try to authenticate them to login? so if I do.. HASHPW = PW.RANDOMNUMBER I could store the random number in the database, but that seems to k...
is there anyone have read the source code of dtl in c++? I found there is a class called variant_row, it used to store all kinds of data, and i tried to read the source code, but it is really hard for me, can someone explain how it is implemented and the class struct? Thanks ! ...
I'm developing a web app and currently using sql server 2008 for it. But, I am considering moving to another database (simpledb) for improved performance. I have a background process that inserts up to 10000 rows every hour into one specific table. That table is also read from to display data in the web application. When the background...