Home > Archive > PHP Language > January 2008 > Creating non-relational database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Creating non-relational database
|
|
|
| Should I be using my-sql or php to design a non-relational database.
I looked at ezscripting.com but it doesn't give me the reporting
capabilities I need. Basically I need the user to be able to enter 5
fields into a database and then pull up a report. The report will be
predefined so the user won't need to enter any search parameters. The
report will be grouped by City and Sorted by 3 additional fields,
street name, street number, size. The output would be similiar to:
R&D (this is the main category)
Milpitas (the first city to be grouped on)
192 First Street 20,000 1.45 (the spaces are there
just to separate the data on the report)
32 Second Street 10,000 1.32
San Jose (second city that appears for the category)
2 First Street 5,000 1.10
etc.
The database can be a text file, access, dbase, I don't really care.
There won't be many entries so speed isn't an issue.
Thanks for the suggestions,
Chris
| |
|
| On 1 Jan, 04:40, Chris <chris95...@yahoo.com> wrote:
> Should I be using my-sql or php to design a non-relational database.
> I looked at ezscripting.com but it doesn't give me the reporting
> capabilities I need. Basically I need the user to be able to enter 5
> fields into a database and then pull up a report. The report will be
> predefined so the user won't need to enter any search parameters. The
> report will be grouped by City and Sorted by 3 additional fields,
> street name, street number, size. The output would be similiar to:
>
> R&D (this is the main category)
>
> Milpitas (the first city to be grouped on)
> 192 First Street 20,000 1.45 (the spaces are there
> just to separate the data on the report)
> 32 Second Street 10,000 1.32
>
> San Jose (second city that appears for the category)
> 2 First Street 5,000 1.10
>
> etc.
>
> The database can be a text file, access, dbase, I don't really care.
> There won't be many entries so speed isn't an issue.
>
Looks a hell of a lot like a relational database to me.
C.
| |
|
| C. wrote:
> Looks a hell of a lot like a relational database to me.
I was just about to post the same remark too. ;)
f.
| |
|
| On Jan 1, 12:56=A0pm, Cujo <f...@despammed.com> wrote:
> C. wrote:
>
> I was just about to post the same remark too. ;)
>
> f.
By my definition in order to have a relational database you need 2 or
more datafiles to pull info from. I only have 1 so to me anyway its a
flat file database.
| |
| Michael Fesser 2008-01-02, 4:00 am |
| ..oO(Chris)
>By my definition in order to have a relational database you need 2 or
>more datafiles to pull info from.
In database theory a relation is the formal description of a table,
where every column is an attribute of that relation. The relational
algebra is based on that.
From <http://en.wikipedia.org/wiki/Relational_model>:
| "Relation" is a mathematical term for "table", and thus "relational"
| roughly means "based on tables". It does not refer to the links or
| "keys" between tables, contrary to popular belief.
Micha
| |
| ashore 2008-01-04, 10:00 pm |
| I'm satisfied that if it can be manipulated by SQL, it's relational.
Therefore, table count doesn't apply.
AS
|
|
|
|
|