• livros publicados

Linguagem de Programação Pascal, Lorenzi, Fabiana e Lopes, Arthur Vargas. Ed. ULBRA, 2000, 127p.

Estruturas de Dados para a Construção de Software - Volume I - Nível Básico, Ed. ULBRA, 1999, 440p.

Estruturas de Dados para a Construção de Software - Volume II - Nível Intermediário, Ed. ULBRA, 1999, 615p.

Introdução à Programação com Ada 95, Ed. ULBRA, 1997, 423p.

Linguagem C - Programação e Prática, Ed. dos autores Lopes, A. V. e Becker, 1996, 190p.

• artigos

Lopes, A. V. "Ada+SQL - An Overview." SigAda ´99, Redondo Beach, CA, Oct. 17-21, 1999.

Lopes, A. V. "Ada+SQL - An Overview." - Ada Letters, Volume XIX, No. 3, p157-162,  ACM Press, Set. 1999.

Feldman, M. B., Kann, C., Lopes, A. V. and Perez, M. "GW-Ada/Ed: Free Ada 83 Development Environments for IBM PC-Compatible and Apple Macintosh Computers." TRI-Ada 95, Anaheim, CA, Nov. 5-10, 1995.

AVLAda9X, GWAda & SmallAda, "The Ada Collection," Rush River Software, 6105 Arlington Boulevard, Falls Church, VA 1993-1999.

• referee

"Making Programming Knowledge Explicit," Computer & Education, Pergamon Press, April 1993.

• copyrights

Pascal X Compiler / Interpreter,  United States Copyright Office, Library of Congress, January, 2000, TXu 935-855.

Introdução a Programação com Ada 95 (livro), United States Copyright Office, Library of Congress, January, 1997, TXu 779-198.

AVL Ada 95 For Windows 95 and NT, United States Copyright Office, Library of Congress, May 30, 1996, TXu 754-707.

AVL Ada 95 Example Programs, United States Copyright Office, Library of Congress, May 30, 1996, TXu 744-039.

Ada 95 Reference Manual for Windows Help System, United States Copyright Office, Library of Congress, May 30, 1996, Txu 744-036.

Ada 95 Primer, United States Copyright Office, Library of Congress, April 30, 1996, TXu 775-444.

AVL Ada 95 Student Compiler and Interpreter, United States Copyright Office, Library of Congress, December 8, 1995, TX 4-244-434.

AVL Ada 9X Students Compiler and Interpreter, United States Copyright Office, Library of Congress, August 5, 1994, Txu 588-211.

• patents

• • Sheldon, S. and Lopes, A. V. Method and System for Transforming Multiple Alternate Equality Conditions, 2003 (submitted). Awarded on December 2008.

Lopes, Arthur V. and Becker, F. Bertilo, "Mecanismo para Credenciamento Eletrônico de Software," PI#8300833, Brazil, 1982.

• Propostas para registro invenção record -  Teradata-NCR Corporation

1. Lopes, A. V., Pampati, P.,  Sathya, P. & Sinclair, P. Query Rewrite For Zero Row Query. September, 2009.
2. Lopes, A. V. Apply Constant Folding to Non-deterministic functions. August, 2009.
3. Lopes, A. V. Combining Binary and Multi-way Joins in a Parallel RDBMS. July, 2009.
4. Lopes, A. V., Pampati, P. Infrastructure for Run-Time Low Level Code to Support Large Data Types. July, 2009.
5. Lopes, A. V., Pampati, P. Tool to Query Test Cases Based on Grammar Constructs Usage. July, 2009.
6. P.,  Sathya & Lopes, A. V. SQL User Defined Function Security Mechanism. May, 2009.
7. Lopes, A. V. Using a Hash Table to Prevent Unnecessary Parser Tree Copy Operations. March, 2009.
8. Lopes, A. V., Subramanjan, A. Ghazal, A. & Walter, T. An Efficient Algorithm to Perform Common Sub-Expression Elimination on Complex Expressions. February, 2009.
9.  Lopes, A. V.  Brown, D, Richards, A. & Pederson, D.  Autonomic Error Recovery Mechanism for a Parallel Database System. February, 2009.
10. Pederson, D., Lopes, A. V. & Pampati, P. Automatic Reparsing of Queries Running Out of Memory. January, 2009.
11. Lopes, A. V., Sinclair, P. and Brown, D. Adding an Extended Error Message Mechanism to a Parallel Database System. October 2008.
12. Lopes, A. V., Ghazal, A. Diaz, A., Sathya, P. & Walztky, M., Pederson, D. Adding User Defined Operators to a Parallel Data Base System. August 2008.
13. Lopes, A. V., Sirek, M., Pampati, P, Sinclair, P. and Brown, D. Adding Char PPI Table Recreation to a Real Time Wizard Within a Parallel Database Architecture. July, 2008.
14. Lopes, A. V., Cheong, B., Pampati, P. and Harris, T. Adding a Cache Mechanism for Insert Statements Within Parallel Database Architecture. June, 2008.
15. Lopes, A. V., Eliminating Duplicate Data Row Storage in Multi-set Tables Within a Parallel Database Architecture. June, 2008.
16. Lopes, A. V., Au, G. Brown, D and Filtz, D. Sharing Answer Sets Within a Parallel Database Architecture. June, 2008.
17. Lopes, A. V. Multi System Sub-query Optimization. May, 2008.
18. Lopes, A. V. Populating a Query Capture Database From an Query Plan in XML. May, 2008.
19. Lopes, A. V. Fast XML Name Decompression Mechanism. May, 2008.
20. Lopes, A. V. and Pampati, P.. Eliminating Unnecessary Include Header Files. May, 2008.
21. Lopes, A. V., Pampati, P., Wu, J. & Cheong, B. Adding a Fast Non Unique Secondary Index Option to a Parallel Database Architecture. March, 2008.
22. Lopes, A. V.  Brown, D & Richards, A. Optimized In-Memory Query Plans for Real-time Database System Management. March, 2008.
23. Lopes, A. V. Adding Multi System Table Join Optimization to a Parallel Database Architecture. March 2008.
24. Lopes, A. V., Lavandus, G. Adding Super Users to a Network of Parallel Database Systems. March 2008.
25. Lopes, A. V., Brown, D. and Morris, M. Adding Multi System Table Access Condition Pushing Optimization to a Database Architecture. February 2008.
26. Lopes, A. V., Lavandus, G. and Brown, D. Extending a Parallel Database Architecture with a Multi System Table Access Capability. February 2008.
27. Sathya, P., Lopes, A. V. and Kossic, J. Enhancing Index Wizard Recommendations Capability with Memory Resident Indexes. September 2007.
28. Lopes, A. V., Galeazzi, D., Shelton, J., Lawandus, G. and Brown, D. Allowing a Query to Reference Its Own Execution Plan. September 2007.
29. Julien, T., Brown, D. and Lopes, A. V. Optimized Maintenance for Coexisting Indexes Using Clusters in a Parallel Relational Database Architecture. September 2007.
30. Lopes, A. V. and Sathya, P. Adding Trie Indexing to Parallel Relational Database Index Wizard. September 2007.
31. Sathya, P. and Lopes, A. V. Adding Trie Indexing to Parallel Relational Database Statistics Collection and Sampling. September 2007.
32. Lopes, A. V., Julien, T, and Brown, D. Real Time Index Wizard for a Parallel Relational Database Architecture. September 2007.
33. Julien, T., Lopes, A. V. and Brown, D. Building Strategy for Volatile Indexes in a Parallel Relational Database. September 2007.
34. Shelton, J. and Lopes, A. V. Query Capture Output Available To User Defined Functions. September 2007.
35. Lopes, A. V. Optimized Method for Retrieving Keys from a Trie Indexing Data Structure. September 2007.
36. Lopes, A. V., Lavandus, G. and Glick, R. A Parallel Statistics Node Within a Parallel RDBMS. August 2007.
37. Lopes, A. V., Julien, T. and Brown, D. Adding a Plurality of Indexing Data Structures to a Parallel Relational Database. August 2007.
38. Wu, J., Lopes, A. V., Shank, E., Lee, J. and Reed, M. XML Support in TPUMP. August 2007.
39. Lopes, A. V. and Sathya, P. Estimating Rows per Value using a Primary Key Based on a Trie Index in Memory. August 2007.
40. Lopes, A. V. Multicolumn Index with Distinct Indexing Data Structures for a Parallel Relational Database. July 2007.
41. Lopes, A. V. Extending Teradata with the 2-3 Tree Indexing Data Structure. July 2007.
42. Lopes, A. V. Extending Teradata with the Hash23Tree Indexing Data Structure. July 2007.
43. Lopes, A. V., Julien, T. Awada, K. and Brown, D. Adding a Trie Indexing Mechanism to a Parallel Relational Database. July 2007.
44. Lopes, A.V., Shelton, J., Brown, D., Julien, T. and Vandervort, R. An Optimal Method for Grouping Database Level Objects Counts per AMP. June 2007.
45. Lopes, A. V. A General Purpose Query Based Data Generator. May 2007.
46. Lopes, A. V., Julien, T., Brown, D. and Glick, R. An Efficient Symbol Table for a Very Fast XML Retrieval System. May 2007.
47. Lopes, A. V., Shelton, J. and Brown, D. An Optimal Caching Method (Merging) for Counting Database Level Objects. May 2007.
48. Lopes, A. V. and Shelton, J. Optimized Data Structure for Random AMP Emulation. May 2007.
49. Wu, J., Lopes, A. V. and Reed, M. Query Plan Directive Wizard, May 2007.
50. Lopes, A. V. and Wu, J. An Interactive Fault Isolation Tool. May 2007.
51. Lopes, A. V. and Ghazal, A.Fast Algorithm for Common Factor Elimination. April 2007.
52. Lopes, A. V. Logical Expressions Rewrite. April 2007.
53. Lopes, A. V. Fast XML Tag Compression Mechanism. March 2007.
54. Lopes, A. V. and Ghazal, A. Rewrite Optimization for Unsatisfiable Query, December 2006.
55. Galeazzi, D., Kim, J. and Lopes, A. V. Providing SQL Interfaces to Performance Monitoring and Control Functionality, October, 2006.
56. Lopes, A. V. Teradata Simulation Mode, July, 2006.
57. Lopes, A. V., Kaufmann, F., Brown, D. , Galeazzi, D. Question Mark Parameter for the Query Band, July, 2006.
58. Lavandus, G. and Lopes, A. V. Synthetic Data Ordering for Aggregate Floating point Calculations, May 2006.
59. Lopes, A. V., Shelton, J.Fast Mechanism for Creating Visual Explain Input Data Usign XML. March 2006.
60. Lopes, A. V., Ghazal, A. and McKenna, B. Outer to Inner Join Conversion Rerwrite. August 2005.
61. Lopes, A. V. Flexible Insert – Inserting from a Flexible Select. July 2005.
62. Lopes, A. V. Flexible Select - Reducing the Number of Columns for the Output
63. of a Select Statement. June 2005.
64. Lopes, A. V. Adding a Query Metrics Mechanism to the Teradata RDBMS. June 2005.
65. Lopes, A. V. Optimized Data Structure to Store Objects Within the Teradata Parser Engine. March 2005.
66. Au, G., Lopes, A. V and Ghazal, A. Optimal Approach to Handle Zero Relation Terms with Unknown Results for Outer Joins. February 2005.
67. Reichart, D., Lopes, A. V. Logging Plan Directives. February 2005.
68. Lopes, A. V. Memory Management System Using Garbage Collection. May 2004.
69. Lopes, A. V. Extending the Teradata RDBMS with Topological Grouping. Jan. 2004.
70. Lopes, A. V. Optimizing Conditions with Constant Sub-queries. Dec.2003.
71. Lopes, A. V. and Sathya, P. Estimating Rows per Value. Nov. 2003.
72. Lopes, A. V. and Sathya, P.  Multi-AMP Sampling. Dec. 2003.
73. Lopes, A. V., Klindt, J. Chiang, K., Pederson, D. and Sathya, P. Improving Random AMP Sampling. Nov. 2003.

   74.   Lopes, A. V., Au, G.,Ghazal, A. and Sheldon, S. Simple Expression Optimization in an SQL Statement. Oct. 2003.

75. Lopes, A. V. and Cheong, B. Improving Condition Evaluation and Representation. Oct.  2003.
76. Lopes, A. V., Ghazal, A. and Au, G., Join Elimination for Unnecessary Outer Joins, 2002.
77. Lopes, A. V., Elimination of Redundant Data, 2002.
78. Lopes, A. V., High Performance Algorithms for Inserts, Deletes and Partial De-fragmentation for Teradata Cylinder Blocks, 2002.
79. Kostamaa, P., Julien, T. and Lopes, A. V.,  Reducing the Number of Collisions Using Multilevel Hashing, 2002.
80. Lopes, A. V. and Julien, T., Extending the Teradata RDBMS with a Compact Option, 2002.
81. Lopes, A. V., Sinclair, P., Kraus, T. and Kaufmann, F., Data Structure to Control Tree Nodes in the Teradata Parser, 2002.
82. Ghazal, A. and Lopes, A.V. Join Elimination Using Referential Integrity, 2002.
83. Lopes, A. V. and Sheldon, S., Programmer Wizard to Minimize the Usage of a Generic Data Type, 2002.
84. Lopes, A. V. Programmer Wizard to Assist Teradata Development, 2002.
85. Ghazal, A., Au, G., Lopes, A. V., Chiang, K. and Sinclair, P., Memory Management in the Teradata Query Optimizer, 2002.

86. Lopes, A. V. and Julien, T., Extending Teradata RDBMS with a Complete Parallel and Distributed Programming Language, 2001.

 

• relatórios técnicos

Lopes, Arthur V. and Feldman, B. Michael. "Small Ada Parallel Monitoring." The George Washington University, Technical Report GWU-IIST-91-12.

Lopes, Arthur V. and Feldman, B. Michael. "Small Ada PC Integrated Environment." The George Washington University, Technical Report GWU-IIST-91-17.

Lopes, Arthur V., Nagy, Thomas, and Feldman, Michael B. "Automated Debugger for Ada Tasks." The George Washington University, Technical Report GWU-IIST-91-22.

Lopes, Arthur V. and Feldman, Michael B. "Enhancing Small Ada with Task Type." The George Washington University, Technical Report GWU-IIST-92-04.

Lopes, Arthur V., Heller, Rachelle S. Martin, Dianne C., Feldman, Michael B, Nagy, Tomas and Youssef, Abodou. "Measuring the Effectiveness of an Automated Debugger for Ada Tasks." The George Washington University, Technical Report GWU-IIST-92-05.

Lopes, Arthur V. and Feldman, Michael B. "Enhancing Small Ada with Execution Traces and Task Activity Visualization." The George Washington University, Technical Report GWU-IIST-92-08.

Lopes, Arthur V. and Feldman, Michael B. "GWEd - A Full Screen Editor for AdaEd." The George Washington University, Technical Report GWU-IIST-92-27.