Designing an alternative to SQL?

I'm thinking of developing and implementing my own SQL equivalent (DDL + DML), which ...

  • pure relational algebraic language and
  • has elegant Lisp syntax - / Scheme-like

Assuming RDBMS such as MySQL, where exactly will I need to start work on creating a language? To the top of a layer with a storage engine like InnoDB?

I don’t know that all the functionality of RDBMS is usually located on the storage platform? My real intuitive understanding is that the bulk of the work needed to create a DBMS (e.g. MySQL) would already be done as part of the storage engine (in particular, in InnoDB), and all you have to do is create wrap language around It. But I also know that if that were true, why did MySQL exist in the first place!

+5
source share
4 answers

, SQL, , rdbms, , SQL.

MySQL , MySQL , MySQL SQL , .

rdbms /, MySQL , , ( ) rdbms .

, , , , The Third Manifesto .

, , SQL, .

+5

, lisp. Lisp . , :

(select movies (<= 1990 year 2000) (member director '(terry-gilliam tim-burton)))

"select" - . , , , . , , , . :

(flet ((filter (item)
        (let ((year (movie-year item))
              (director (movie-director item)))
         (and (<= 1990 year 2000)
              (member director '(terry-gilliam tim-burton))))))
 (loop for item in movies
       if (filter item) collect item))

, ( Lisp, Lisp), , . , ( C, ?). , ( "select" ) . , ... , . , , - .

, , SQL, , lisp. , .

+9

rdbms isam - mysql - . , ..; , , ..

, isam SQL- . Google , SQL.

+1

Lisp, RDBS Music. .

+1

All Articles