Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

This might be some ambiguous but I have not much info about this so I need some start point;

As a general idea; in conventional RDBMS', there are a DB engine and storage of data. We use the language 'SQL' to access these datas on the DB. To access datas, is there other ways different from using SQL queries? Can we 'fire' events of DB engine without using SQL and get the datas in the storage? If yes, how?

share|improve this question

2 Answers

up vote 1 down vote

You can also use your favorite hex editor :). This can even be a good learning lesson to see how things work under the hood. For example, you could have a look at those posts/videos:

But using a high level language like SQL or your vendors implementation (tsql, pl/sql...) makes things so much easier.

share|improve this answer
Thank you, let me check your links. – Yasin Okumus Apr 20 at 12:57
up vote 1 down vote

To access datas, is there other ways different from using SQL queries? Can we 'fire' events of DB engine without using SQL and get the datas in the storage?

Sometimes you can, if the database engine offers such a mechanism. For example Pervasive PSQL is the descendant of the venerable Btrieve database. It allows you to use the "MicroKernel Database Engine" (MKDE) to make "Btrieve calls", or the "SQL Relational Database Engine" (SRDE) to execute SQL queries against the same body of data.

share|improve this answer
Thanks. These DBs are new approaches for me. I'll check them. – Yasin Okumus Apr 20 at 14:03

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.