On Tue, Apr 27, 2010 at 1:11 AM, Stanislav Muhametsin <[email protected]> wrote:
> I remember someone talking about Qi4j and RDBS support. I'm not sure if this > is what they meant, but I have coded a prototype for RDBMS-indexing. > What say you? At least stick it in sandbox... On a related note; I am in the finance sector and an interesting revelation came a bit unexpected. I was digging around code and found that all access to database, even the simplest of queries, were done as stored procedures. So, I asked why "SELECT abc FROM def WHERE xyz='rst';" was a stored proc. The answer I got surprised me; "Regulators demand that no one has direct access to the database. All SQL, except procedure calls, are disabled and authorization of access is per stored proc. The Fed wants to know what operations can be made on the data, and without this the answer would have been 'anything', which is not what they want to hear." So, no matter if it is a select, update or insert, it is not available, but one has to do procedure calls. And as far as I know, ORM tools doesn't have any good support for this, and we should keep it in mind. But interestingly, the NoSQL effort within the company has not addressed this issue in the same fashion and the in-house SQL-free world they are trying to do more what we are doing, and the Entity models will be used to convince the Fed. Not sure if that would work, but sure would benefit us if they can pull it off. Cheers -- Niclas Hedhman, Software Developer http://www.qi4j.org - New Energy for Java I live here; http://tinyurl.com/2qq9er I work here; http://tinyurl.com/2ymelc I relax here; http://tinyurl.com/2cgsug _______________________________________________ qi4j-dev mailing list [email protected] http://lists.ops4j.org/mailman/listinfo/qi4j-dev
