8,657 Hits in 7.2 sec

Ontology-Based Backpropagation Neural Network Classification And Reasoning Strategy For Nosql And Sql Databases

Hao-Hsiang Ku, Ching-Ho Chi
2017 Zenodo  
ON4NoSQL is responsible for enhancing the performances of classifications in NoSQL and SQL databases to build up mass behavior models.  ...  Mass behavior models are made by MapReduce techniques and Hadoop distributed file system based on Hadoop service platform.  ...  It can promise a significant improvement on the quality of the recommendations. 2) To classify data by unknown characteristics: Clustering is defined as the data which are classified by unknown characteristics  ... 
doi:10.5281/zenodo.1132612 fatcat:5fs4gkpsefhgjcfxee4njmsuj4

MonetDB/SQL Meets SkyServer: the Challenges of a Scientific Database

M. Ivanova, N. Nes, R. Goncalves, M. Kersten
2007 International Conference on Scientific and Statistical Database Management  
The lessons learned are 1) the column store approach of MonetDB demonstrates a great potential in the world of scientific databases.  ...  zoom-in/zoom-out access patterns, that are currently not captured by the system. 19th International Conference on Scientific and Statistical Database Management (SSDBM 2007) 0-7695-2868-6/07 $25.00  ...  of scientific databases.  ... 
doi:10.1109/ssdbm.2007.19 dblp:conf/ssdbm/IvanovaNGK07 fatcat:l7lp6i4imfcmvcyyyf25wzps3e

A Decade of Oracle Database Manageability

Peter Belknap, John Beresniewicz, Benoît Dageville, Karl Dias, Uri Shaft, Khaled Yagoub
2011 IEEE Data Engineering Bulletin  
Oracle took on the challenge of ever-increasing management complexity for the database server beginning some eleven years ago with Oracle 10g and continuing through the 11g release.  ...  Our efforts to improve database manageability can be classified into three levels of increasing sophistication: • Statistics and reporting level-where key workload performance statistics and run-time data  ...  Improving the ease-of-use of the database is an effort that encompasses all development teams.  ... 
dblp:journals/debu/BelknapBDDSY11 fatcat:ytxnj3kgkzag3p43fbzburg3jy

Investigation in Recommendations for Troubleshooting of Ineffectiveness of Queries to Database Tables

Ali Mohammed Saleh Ahmed
2018 Journal of University of Babylon  
However, there are no results of experimental investigations on the effectiveness of applying other recommendations given in scientific literature.  ...  One of the ways to increase work output of the applications connected with a database is the optimization of queries to database tables.  ...  In a database such as Firebird SQL or Oracle, the DISTINCT statement will cause the database engine to look through all the records from the required table one by one, in the database organized by MS SQL  ... 
doi:10.29196/jubpas.v26i10.1885 fatcat:hsyuhxh7fjd5req7cfzhtrlrqe

Query Optimization Techniques in Microsoft SQL Server

Costel Gabriel CORLATAN, Marius Mihai LAZAR, Valentina LUCA, Octavian Teodor PETRICICA
2014 Database Systems Journal  
Microsoft SQL Server is a relational database management system, having MS-SQL and Transact-SQL as primary structured programming languages.  ...  The most frequently used queries are those of data retrieval through SELECT command.  ...  He is currently a masterand of Database for Business Support program. His scientific fields of interest include: Databases, Web development and Application programming interfaces.  ... 
doaj:f9c09994258246638d3c0870f0273075 fatcat:m4gurwovifaull5tzv23hbndm4

Scalable long-term preservation of relational data through SPARQL queries

Silvia Stefanova, Tore Risch, Christoph Schlieder
2016 Semantic Web Journal  
The query processing is based on automatically generating an RDF view of a relational database to archive, called the RD-view.  ...  The proposed approach is suitable for archiving scientific data used in scientific publications where it is desirable to preserve only parts of an RDB, e.g. only data about a specific set of experimental  ...  Much less work has focused on the preservation of databases and scientific data, where there is a recognized need to preserve scientific data [12] [28] [37] [38] [39] .  ... 
doi:10.3233/sw-150173 fatcat:yh2cmr3r2nhbzpmg5l63btv3hy

Big Scale Text Analytics and Smart Content Navigation [chapter]

Karsten Schmidt, Sebastian Bächle, Philipp Scholl, Georg Nold
2015 Lecture Notes in Business Information Processing  
With HANA, we are able to implement this functionality over big data on a single machine by making use of HANA's SQL data store and the built-in application server.  ...  Our demo shows an intelligent way of doing guided research in big text collections, using the collection of the major scientific publisher Springer SBM as an example data set.  ...  The Big Data Challenge Our database consists of 3.7 million scientific articles and book chapters 1 , all in PDF format, with a raw data volume of 3.6 TB.  ... 
doi:10.1007/978-3-662-46839-5_12 fatcat:pf5cqj3h3bcppietf75zpol32m

Report: 4th Int'l Workshop on Self-Managing Database Systems (SMDB 2009)

Ashraf Aboulnaga, Kenneth Salem
2009 IEEE Data Engineering Bulletin  
The SMDB Workshops are sponsored by the IEEE TCDE Workgroup on Self-Managing Database Systems.  ...  The workshop concluded with a panel discussion on "grand challenges" in database self-management.  ...  The setting considered by the paper is one in which scientific data is stored in a cloud of databases, and users pose queries against this data.  ... 
dblp:journals/debu/AboulnagaS09 fatcat:g7ss7udhn5btxftorbb63dbimm


Nodira Khoussainova, YongChul Kwon, Magdalena Balazinska, Dan Suciu
2010 Proceedings of the VLDB Endowment  
SnipSuggest aims to help the increasing population of non-expert database users, who need to perform complex analysis on their large-scale datasets, but have difficulty writing SQL queries.  ...  We evaluate SnipSuggest over two query logs: one from an undergraduate database class and another from the Sloan Digital Sky Survey database.  ...  One of the most commonly used views, PhotoPrimary, has 454 attributes! The learning curve to becoming an expert SQL user on a specific scientific database is steep.  ... 
doi:10.14778/1880172.1880175 fatcat:ysfyrr6ejfcepmyrvneggjzqqe

Research issues in data provenance

Chad Vicknair
2010 Proceedings of the 48th Annual Southeast Regional Conference on - ACM SE '10  
As the volume of scientific data increases, the need for automated data provenance has expanded. Currently, several provenance systems exist to aid users in recording and querying provenance data.  ...  They range from very specific programs designed to accomplish a small number of clearly defined tasks to broad-range applications intended to appeal to a wider audience.  ...  Any opinions, findings and conclusions or recommendations expressed in this material are those of the author and do not necessarily reflect those of the National Science Foundation.  ... 
doi:10.1145/1900008.1900037 dblp:conf/ACMse/Vicknair10 fatcat:jgxkoosxyvdo7cn24ebzgg332q

The database group at the University of Washington

Magdalena Balazinska, Bill Howe, Dan Suciu
2014 SIGMOD record  
The database group at the University of Washington (UW) was founded in 1998 when the department hired Alon Halevy (now at Google).  ...  We give here a short overview of the recent research themes in our group; more details are available on our website:  ...  Common explanations claim a mismatch between scientific data and the models and languages of relational databases, or simply that "scientists won't write SQL."  ... 
doi:10.1145/2627692.2627701 fatcat:65vam45eifab5nnl6uypj5rjey

Keyword Query Expansion Paradigm Based on Recommendation and Interpretation in Relational Databases

Yingqi Wang, Nianbin Wang, Lianke Zhou
2017 Scientific Programming  
Due to the ambiguity and impreciseness of keyword query in relational databases, the research on keyword query expansion has attracted wide attention.  ...  To address this problem, a novel two-step query expansion approach is proposed based on query recommendation and query interpretation.  ...  In the field of keyword query in relational databases, the majority of existing studies have focused on how to improve the efficiency of query algorithms, while effective query preprocessing has yet to  ... 
doi:10.1155/2017/7613026 fatcat:igrxbycdejekli4zl5rigk5wii

Mitigating SQL Attacks on Enterprise Database

MADUAKO Nnanyereugo C, OWOLABI Olumide
2019 International Journal of Advances in Scientific Research and Engineering  
A secure database is one which is shielded from different possible attacks.  ...  The effectiveness of the developed system in protecting data stored in a database was demonstrated by attempting some attacks on the database. The system was able to thwart the attacks.  ...  One way (recommended) to improve database security is by adding security layers. Multiple security methods are deployed here to protect the system instead of using only just one.  ... 
doi:10.31695/ijasre.2019.33615 fatcat:rmlwqkfk7bcidllrsirwwgvd7a

Recommendations for Evolving Relational Databases [chapter]

Julien Delplanque, Anne Etien, Nicolas Anquetil, Stéphane Ducasse
2020 Lecture Notes in Computer Science  
We present a semi-automatic approach based on recommendations that can be compiled into a SQL patch fulfilling RDBMS constraints.  ...  To support recommendations, we designed a meta-model for relational databases easing computation of change impact.  ...  Section 4 describes our approach based on impact computation and recommendations to generate SQL evolution patch.  ... 
doi:10.1007/978-3-030-49435-3_31 fatcat:qxb3jwg55fdy3fu5lxnwvn2vx4

A Comprehensive Analysis of Proprietary and Open Source Data Mining Tools

Sonia Rani Chowdhary, Mr Vikash
2020 International Journal of Scientific Research in Computer Science Engineering and Information Technology  
With the rapid development of technologies and business interest in using electronics and latest technologies plays important role in improvement of data mining field.  ...  On the basis of well-designed User interface, short time analysis, statistical and mathematical analysis user can select the best tool as per their requirements.  ...  on mobile platform should be improved. • Most of researchers are not familiar with it.s • SQL • Can create offline Database • Analysis Services (AS) data models • Integration Services (IS) packages •  ... 
doi:10.32628/cseit206210 fatcat:463k5b47q5h6fkq4p6abeqx2oa
« Previous Showing results 1 — 15 out of 8,657 results