So we have foods, which are usually of one single unit and recipes, which consist of varying amount of different foods. We want to track a few basic things like the price and the nutrition info. How would we design RDBMS schema for this? So, here is the probably most obvious solution: [Foods] : ID, Name, Carbs, Protein, Fat, Price [R...
I'm constantly running into issues with having hierarchical data stored in an RDBMS. To me, it seems like an indicator that it's the wrong tool for the job. The "job" is to store a hierarchical survey and the results from multiple respondents for a given date range. The survey questions may slightly vary from one date range to the next. ...
I am making a function (PHP). In this function it basically uses the dbms specified and connects, submits the appropriate query, <insert my problem here>, and disconnects. DBMSs include MySQL, MSSQL, Postgres, and Oracle. I am assuming that outside of this function, the user would not have access to specified DMBS, so whatever results I...
My first experience developing DBMS-based apps was with IMS, using COBOL calls to DLI. Later on, I worked with several other products, on a smaller scale, such as: DBASE, INFORMIX 3.3/SQL and ORACLE on DOS, UNIX-XENIX and VAX/VMS platforms. When I was a product planner for AT&T-IS Labs, I had the opportunity to eval several RDBMS-based a...
I want to write some queries which can work in almost all the databases without any SQLExceptions. So, where can I get the ANSI standards to write the queries ? ...
Hi everybody, Is there any way to use voltDB in a PHP application? It definitely seems like it have a few advantages over other Databases out there! ...
Hello, I am just curious how do you all create tables to maintain integrity? tblUserProfile UserId EyeColorId HairColorId RelationShipStatusId etc. Each of these values like EyeColorId has a set of values like Brown,Black,Yellow,Green. Similary HairColorId has black, blonde, crimson etc and RelationShipStatusId has Divorced, Marrie...
Hello, The queries that i create frequently have 7-8 joins to retrieve data. Are these many joins normal in a real database application or is my database design poor? I am curious because if on each request database has to do so much work, then won't it die if few thousands of client connect? ...
I've been looking into a lot of database's recently, and am not sure if it's because I'm bored or what, but I want to create a few web applications using database's other than MS SQL Server. Any suggestions that tie into ASP.NET nicely? ...
Hi. I have a database (running on postgres, precisely) , with the following structure : user1 (schema) | - cars (table) - airplanes (table, again) ... user2 | - cars - airplanes ... It's clearly not structurized the way classic relational databes should be, but it "just works" as it is now. As you can see, schemas are like prim...
What is the advantage in storing data as an object instead of storing them in separate table columns For example: storing an item details as Blob instead of storing the attributes separately in an items table (SKU, Name, Price etc) ...
I am new to PostgreSQL, mainly used MySQL before and SQLServer(for Clients Pressure; donno much), I've gone through several OODBMS Introductories over some Google Search. Most of them mainly focuses on Table <-> Object Mapping. But When using some Generic ORM Layer with any RDBMS Things are Hapily Mapped. So do we really need OODBMS ? I...
hello On you tube,facebook,flicker millions of photos and videos are uploaded by users so how they manage all such large uploads.i know that they have large space on their servers but i just want to ask that which technique they are using to store this kind of huge data? And also please suggest me to best way to get this kind of ...
There has been a lot of talk about contra-revolutionary NoSQL databases like Cassandra, CouchDB, Hypertable, MongoDB, Project Voldemort, BigTable, and so many more. As far as I am concerned, the strongest pros are scalability, performance and simplicity. I am seriously considering to suggest using some non-relational db for our next pr...
Hi, I have a requirement to build a Business Rule Engine. I use the SQL SERVER 2005. The business rules are massive, like 2000 pages long. eg. If col1 = 'xyz' then populate col2 otherwise not. if col3 = 'abc' and col4 = 'def' then col5 = 'ghy' etc. etc. So, I think we can't just write all those rules in if else condition in a proc...
There are several approaches how to store entities hierarchy in relation database For example there is person entity (20 basic attributes), student entity (the same as person but several new specific fields are present), employee (the same as person but some new fields are present) e.t.c. When you advice to use (and not to use) the fo...
After developing software for about 5 years now, I have spent probably atleast 20% and perhaps up to 40% of that time simply making a RDBMS able to save and retrieve complex object graphs. Many times this resulted in less than optimal coding solutions in order to make something easier to do from the database side. This eventually ended a...
Hello, I've met one person who claims he has wrote to over 5000 lines of stored procedure in Sql Server. Is that long stored procedure actually required ever? Or is it sign of a bad database and coding design? I am really worried. I never wrote anything long than 100 lines of code in Stored Procedure in one my live projects based on Ins...
How would I design the tables for a matching system doing something like this: We have X products which can have Y properties. The number of properties can vary from product to product and two products doesn't have to have any similar properties. My number one goal is to take one product and find the most similar product. Normally I w...
I'm planning to write an address book that stored contact information. Each contact could have an unlimited number of fields. Mostly strings and integers. But perhaps references to other Objects. What are the advantages and disadvantages of using an RDBMS with ORM vs OODBMS vs Document DBMS (like CouchDB). Thanks. ...