 | | ^ click above ^ |
08.24.04
 By DatabaseProNews
TenFold Corporation today announced SmartSQL, an EnterpriseTenFold feature that automatically generates custom SQL for most popular RDBMS systems.
"So there I was, making an honest living tuning gloriously buggy, manually written SQL, the biggest performance problem in most applications, and TenFold comes along and suggests I might like to help sell their SmartSQL SQL autogenerator, which could put me out of business!" said Dan Tow, founder of SingingSQL.com and author of SQL Tuning (published by O'Reilly & Associates). "I mean, really! The nerve! The gall!"
|
"In SmartSQL, TenFold has automated and packaged an entire programming discipline so that people who do not program can build powerful database applications," said Dr. Nancy Harvey, TenFold's President and CEO. "Our goal has always been to take an unpredictable, inefficient industry -- applications software -- and revolutionize it the way that Henry Ford revolutionized the automobile industry. SmartSQL is just one example of why only EnterpriseTenFold offers the Speed, Quality, and Power to promise a similar revolution for applications software -- today."
EnterpriseTenFold provides a SmartSQL feature that automatically generates SQL. While writing some SQL is easy, writing efficient SQL to do complex data manipulation is difficult. And some SQL can be so complex that only a few programmers can correctly write it. To ensure efficiency, RDBMS vendors invest years in custom optimizers and SQL extensions that provide significant performance or functionality benefits, if used correctly. SmartSQL generates different SQL for different versions of different vendor RDBMSs so that your TenFold-powered application runs efficiently on every EnterpriseTenFold
platform.
"If your application runs on multiple RDBMS products, you need different SQL for each product," added Dr. Tow. "If you are a SQL expert, you may be able to write SQL that achieves optimal or near-optimal performance on more than one specific RDBMS product. And every time you want your application to run on another RDBMS, you must write an entire new library of SQL statements for your application to perform well on that new product. I really don't need to worry about job security for a while, because even experts need my services to ensure they get optimal SQL for different RDBMS products. However, SmartSQL dynamically generates great SQL for your application -- out of the box -- on Oracle, Sybase, DB2, Microsoft SQL Server, and MySQL database products -- so that you never write a line of SQL to efficiently read, add, update, or delete your applications data. Yikes, time to think about retraining!"
"SmartSQL is key for people who need an application to manage their business information, but who are not -- and do not want to be -- relational database or SQL experts," said Jeffrey L. Walker, TenFold's Founder and CTO. "With SmartSQL, you never have to author or maintain SQL code to have a high-performing, tunable database application."
"Big, complex, mission-critical applications store data in hundreds or thousands of database tables," added Mr. Walker. "Typically, you must write and maintain individual SQL statements that predict how end-users will query or update each table. How many ways do you query or update data for any one table? How many complex queries do you have that use data from 5, 10, or 20 tables? You may end up with thousands of SQL statements that you have to write and maintain for each RDBMS that you use. With EnterpriseTenFold, you can run any database query or update -- no matter how many tables you
have -- and SmartSQL dynamically generates and runs optimal SQL for you. With the Speed, Quality, and Power of SmartSQL, applications development teams can focus on describing business logic while EnterpriseTenFold does the dirty, complex work of efficiently managing database access."
About the Author:
DatabaseProNews offers news, articles and in-depth reports on database management and development for Enterprise IT Managers.
 By Andrew Karasev
Crystal Reports is the most flexible tool on the market and it has market recognition.
Multiple software vendors offer Crystal Reports as the main reporting tool: Microsoft, Best Software, Oracle to name a few.
Sometimes developers try to use Crystal directly to pull data from multiple database platforms - we understand the need to give you additional tips to increase Crystal report flexibility. Also common case when Crystal report should pull data from multiple database platforms. Assuming that you are creating Crystal Reports on Windows platform - we recommend you to use Microsoft SQL Server as a database access tool.
1. Use Crystal when you have your query tuned - regardless how good Crystal Reports is - it is reporting tool - not querying environment. Tune your query first and be sure that you are pulling the right data.
2. Use SQL Server Linked Servers. Use professional tool, such as Microsoft SQL Server, where you can create linked servers to Oracle, Ctree, Btrieve, MS Access, Unidata, DB2 and other platforms.
3. Use Distributed Queries - in the case of SQL Server - research the possibilities with OPENQUERY, OPENROWSET clauses to connect to non-SQL Server linked servers.
4. Create Stored Procedures - when you need parameters to be transferred to the SQL statement - you need stored procedure. You need stored proc if temp tables are required to do intermediate job in your SQL query.
5. Report Flexibility - when you have report based on the SQL view or stored proc - if you need to modify the data query - you don't have to change the report - you change your SQL view/ stored procedure.
6. Create SQL Query to probe the data - again - we always recommend tuning your query and see that you are getting adequate results - in any case - Crystal Report is just a nice tool to show the results of your query.
About the Author:
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, California, Texas, New York, Georgia and Florida and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.
Read this newsletter at: http://www.sqlpronews.com/2004/0824.html |
|    |
|
