schemaless

schema-less data warehouse and reporting

We have a system that generates many events as the result of a phone call/web request/sms/email etc, each of these events need to be able to be stored and be available for reporting (for MI/BI etc) on, each of these events have many variables and does not fit any one specific scheme. The structure of the event document is a key-value...

What is the best open source solution for storing time series data?

I am interested in monitoring some objects. I expect to get about 10000 data points every 15 minutes. (Maybe not at first, but this is the 'general ballpark'). I would also like to be able to get daily, weekly, monthly and yearly statistics. It is not critical to keep the data in the highest resolution (15 minutes) for more than two mont...

Entity groups in Google App Engine Datastore

So I have an app that if I'm honest doesn't really need transactional integrity (lots of updates, none of them critical). So I was planning on simply leaving entity groups by the wayside for now. But I'd still like to understand it (coming from a relational background). The way I see it, all queries for my app will be on a user by use...

What is couchdb, for what and how should I use it?

I hear a lot about couchdb, but after reading some documents about it, I still don't get why to use it and how. Could you clarify this mystery for me? ...

Best practices to access schema-less data ?

I am toying with RDF, and in particular how to access information stored in a rdf storage. The huge difference from a traditional relational database is the lack of a predefined schema: in a relational database, you know that table has those columns, and you can technically map each row to an instance of a class. The class has well defin...

Getting started with the Friendly ORM

I'm following this tutorial: http://friendlyorm.com/ I'm using InstantRails to run MySQL locally. To run Ruby and Rails, I'm using normal Windows installations. When I run Friendly.create_tables! I only get an empty Array returned: => [] and no tables are created in my 'friendly_development' database. Any help on this on one? Thanks!...

Can the Friendly ORM be used alongside a traditional database schema?

Can I use ActiveRecord for existing models and Friendly for new models? Basically, I want to decide which models I'd like to be schemaless and which models I'd like to be done the "old" style. ...

Django and NoSQL, any ready-to-use library?

So far Django has good integration with several RDBMS. NoSQL, schema-less and document-oriented DBMS are picking up. What's the status of integration those on-trend and fashionable DBMSes with Django? Are there any production-ready or at least ready-to-use libraries for Django? So far I have these at hand: http://github.com/lethain/co...

Does this schema sound better suited for a document-oriented data store or relational?

Disclaimer: let me know if this question is better suited for serverfault.com I want to store information on music, specifically: genres artists albums songs This information will be used in a web application, and I want people to be able to see all of the songs associated to an album, and albums associated to an artist, and artis...

Schema less SQL database table - practical compromise

This question is an attempt to find a practical solution for this question. I need a semi-schema less design for my SQL database. However, I can limit the flexibility to shoehorn it into the entire SQL paradigm. Moving to schema less databases might be an option in the future but right now, I' stuck with SQL. I have a table in a SQL d...

Schemaless Data Cache: NoSQL or Other Alternatives?

I am evaluating a number of NoSQL implementations (RavenDB and MongoDB at the moment) as a means of solving a specific set of requirements that involve storage/retrieval of data that is schema-less. I want to get some feedback on whether NoSQL is the direction I should be looking in, or if there are other (potentially simpler) options. ...

What's the Attraction of Schemaless Database Systems?

I've been hearing a lot of talk about schema-less (often distributed) database systems like MongoDB, CouchDB, SimpleDB, etc... While I can understand they might be valuable for some purposes, in most of my applications I'm trying to persist objects that have a specific number of fields of a specific type, and I just automatically think ...