Subscribe to DSC Newsletter
JIANG Buxing
  • Male
  • Beijing
  • China, mainland
Share on Facebook
Share

JIANG Buxing's Friends

  • Jay Ammon

Gifts Received

Gift

JIANG Buxing has not received any gifts yet

Give a Gift

 

JIANG Buxing's Page

Latest Activity

Dirk Herzhauser commented on JIANG Buxing's blog post Relational Algebra Is the Root of SQL Problems
"Jesus it looks like the author does not understand relationa, Algebra. he claims relationa Algebra is disapointing when handling complex problems. His simples problems can be easily solved with windowing functions, recursions, grouping…"
May 12
JIANG Buxing posted a blog post

A New Way to Compare and Reorganize Data

In real-world daily business routines, it is common that data that comes from different sources is of the same structure. Sometimes each set of data is independent and there isn’t any overlapping, like the sales data each branch office exports from their own database. Other times data overlaps heavily. In a common complete business process, it is most probably that all systems and sections input data based on their store of data. To compare the overlapped data and find and correct the possible…See More
Apr 20
Prabhakaran Sampath liked JIANG Buxing's blog post A New Way to Compare and Reorganize Data
Apr 15
JIANG Buxing posted blog posts
Apr 12
JIANG Buxing's blog post was featured

A New Way to Compare and Reorganize Data

In real-world daily business routines, it is common that data that comes from different sources is of the same structure. Sometimes each set of data is independent and there isn’t any overlapping, like the sales data each branch office exports from their own database. Other times data overlaps heavily. In a common complete business process, it is most probably that all systems and sections input data based on their store of data. To compare the overlapped data and find and correct the possible…See More
Apr 11
JIANG Buxing and Jay Ammon are now friends
Mar 18
Connor McDonald commented on JIANG Buxing's blog post Relational Algebra Is the Root of SQL Problems
""Find the top 10 among one billion records." The statement "We have to sort all the 1 billion records to get the top 10" is not true. select * from ( select * from MASSIVE_TABLE order by 1 ) where rownum <= 10; uses a…"
Feb 11
Pratim Chakraborti commented on JIANG Buxing's blog post Relational Algebra Is the Root of SQL Problems
"Hello Author, A very enlightening article, could you help me to find some examples in the computational biology domain? I would really appreciate your help. Pratim"
Jan 27
Pratim Chakraborti liked JIANG Buxing's blog post Relational Algebra Is the Root of SQL Problems
Jan 27
Robert Lucente commented on JIANG Buxing's blog post Relational Algebra Is the Root of SQL Problems
"Thanks for the article. It was really hepful. Let me begin by stating that I am a recovering database administrator (DBA) :-) This top n query is a standard problem. I actually co-authored an article about this in Dr.…"
Jan 22
Peter Vanroose commented on JIANG Buxing's blog post Relational Algebra Is the Root of SQL Problems
"Just a (very) minor comment, as to you statement that "Find the top 10 among one billion records. ... SQL can’t express the algorithm". That's not really true, I believe: SQL (the language) allows you to write this as something…"
Jan 19
Joseph Callender liked JIANG Buxing's blog post Relational Algebra Is the Root of SQL Problems
Jan 18
Justin McBride liked JIANG Buxing's blog post Relational Algebra Is the Root of SQL Problems
Jan 17
JIANG Buxing posted a blog post

Relational Algebra Is the Root of SQL Problems

There is no doubt that SQL is the most widely-used working language for processing structured data. Not only is the language adopted by all relational database products, but its implementation is the goal of many newly-invented big data platforms. But in many aspects SQL isn’t so convenient to use in handling various computational and query demands. The procedurality issue stated in the last article is just a superficial one. SQL’s problems are rooted in its theory foundation, the relational…See More
Jan 16
JIANG Buxing's blog post was featured

Relational Algebra Is the Root of SQL Problems

There is no doubt that SQL is the most widely-used working language for processing structured data. Not only is the language adopted by all relational database products, but its implementation is the goal of many newly-invented big data platforms. But in many aspects SQL isn’t so convenient to use in handling various computational and query demands. The procedurality issue stated in the last article is just a superficial one. SQL’s problems are rooted in its theory foundation, the relational…See More
Jan 16
Julian Hatwell liked JIANG Buxing's blog post SQL: A Supposed English-like Language
Jan 7

Profile Information

Professional Status
C-Level
Years of Experience:
20
Your Company:
Raqsoft
Industry:
Software
Your Job Title:
President/Chief Data Scientist
Interests:
Other

JIANG Buxing's Blog

A New Way to Compare and Reorganize Data

Posted on April 10, 2018 at 12:30am 0 Comments

In real-world daily business routines, it is common that data that comes from different sources is of the same structure. Sometimes each set of data is independent and there isn’t any overlapping, like the sales data each branch office exports from their own database. Other times data overlaps heavily. In a common complete business process, it is most probably that all systems and sections input data based on their store of data. To compare the overlapped data and find and…

Continue

Relational Algebra Is the Root of SQL Problems

Posted on January 14, 2018 at 10:30pm 5 Comments

There is no doubt that SQL is the most widely-used working language for processing structured data. Not only is the language adopted by all relational database products, but its implementation is the goal of many newly-invented big data platforms. But in many aspects SQL isn’t so convenient to use in handling various computational and query demands. The procedurality issue stated in the last article is just a superficial one. SQL’s problems are rooted in its theory foundation, the relational…

Continue

SQL: A Supposed English-like Language

Posted on January 1, 2018 at 11:30pm 3 Comments

SQL is envisioned as an English-like language. Simple SQL statements read like English sentences. SQL writes a statement in an English way with English prepositions unnecessarily attached, while other main programming languages only use English words as the mnemonic of a certain concept or operation, producing formal program statements instead of English sentences. For example, the FROM clause is the main part of a query but it is put in the end of a SQL statement, and the BY in the…

Continue

An Open Computational System Brings Slim Databases

Posted on December 12, 2017 at 12:30am 3 Comments

As stated in the last article, database obesity due to numerous intermediate tables and stored procedures is rooted in the closed computational system. If there is an independent computing engine providing computing capability independent of databases, then the latter can lose weight.

 

With a separate computing engine, the database-generated intermediate data doesn’t have to be stored as data tables; instead, it can be stored in the file system to be further computed…

Continue

Comment Wall

You need to be a member of Data Science Central to add comments!

Join Data Science Central

  • No comments yet!
 
 
 

Follow Us

Videos

  • Add Videos
  • View All

Resources

© 2018   Data Science Central™   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service