嘿大家，当我尝试添加对文件的引用时，我收到此错误：
Process started: biber.exe "dbperf"
INFO - This is Biber 2.11
INFO - Logfile is 'dbperf.blg'
INFO - Reading 'dbperf.bcf'
INFO - Found 6 citekeys in bib section 0
INFO - Processing section 0
INFO - Looking for bibtex format file 'biblio.bib' for section 0
ERROR - Data file 'biblio.bib' cannot be read in encoding 'UTF-8': Can't decode ill-formed UTF-8 octet sequence <92> at C:\Users\Admin\AppData\Local\Temp\par-41646d696e\cache-9d6b46fefde4bd584f892f8159e8daefd64788a3\inc\lib/File/Slurper.pm line 63.
INFO - ERRORS: 1
Process exited with error(s)
这是我的主要文件：
%==============================================================================
% Casus onderzoeksproces: Database-performantie
%==============================================================================
% Gebaseerd op LaTeX-sjabloon ‘Stylish Article’ (zie artikeltin.cls)
% Auteur: Jens Buysse, Bert Van Vreckem
% Compileren document:
% 1) latexmk -pdf db-performance
% 2) biber db-performance
% 3) latexmk -pdf db-performance
\documentclass[fleqn,10pt]{artikeltin}
%------------------------------------------------------------------------------
% Metadata over het artikel
%------------------------------------------------------------------------------
\JournalInfo{HoGent Bedrijf en Organisatie} % Journal information
\Archive{Onderzoekstechnieken 2016 - 2017} % Additional notes (e.g. copyright, DOI, review/research article)
%---------- Titel & auteur ----------------------------------------------------
\PaperTitle{Performantievergelijking van database-systemen}
\PaperType{Casus onderzoeksproces} % Type document
\Authors{Ian Martens\textsuperscript{1}, Voornaam Naam\textsuperscript{2}, Voornaam Naam\textsuperscript{3}, Voornaam Naam\textsuperscript{4}} % Authors
\affiliation{\textbf{Contact:}
\textsuperscript{1} \href{mailto:[email protected]}{[email protected]};
\textsuperscript{2} \href{mailto:[email protected]}{[email protected]};
\textsuperscript{3} \href{mailto:[email protected]}{[email protected]};
\textsuperscript{4} \href{mailto:[email protected]}{[email protected]}}
%---------- Abstract ----------------------------------------------------------
\Abstract{Een database systeem is een belangrijke factor in onze huidige maatschappij. Ze houdt alle data op een gestructureerde manier bij. Andere systemen zijn hier enorm afhankelijk van. De effectiviteit en efficiëntie waarmee de data wordt opgehaald is dus erg belangrijk geworden. We testen in dit onderzoek de performantie van twee database systemen: 'Microsoft SQL Server' en 'MySQL'. Dit doen we a.d.h.v. vooraf opgestelde queries. We testen op uitvoeringstijd, processorbelasting en memory gebruik. Uit de resultaten van het onderzoek blijkt dat MySQL algemeen beter scoort dan SQL Server. Dit verschil is echter verwaarloosbaar. Daaruit kunnen we concluderen dat geen van beide zich echt onderscheid t.o.v. de andere. We kunnen het onderzoek nog uitbreiden door andere database systemen te vergelijken en niet alleen op performantie te testen. Security van een database is ook interessant om eens van naderbij te bekijken. }
%---------- Onderzoeksdomein en sleutelwoorden --------------------------------
\newcommand{\keywordname}{Sleutelwoorden} % Defines the keywords heading name
\Keywords{Database-beheer. Relationele databases --- performantie. MySQL. Microsoft SQL Server.} % Keywords
%---------- Titel, inhoud -----------------------------------------------------
\begin{document}
%\flushbottom % Makes all text pages the same height
\maketitle % Print the title and abstract box
\tableofcontents % Print the contents section
\thispagestyle{empty} % Removes page numbering from the first page
%------------------------------------------------------------------------------
% Hoofdtekst
%------------------------------------------------------------------------------
% Er is al een zekere structuur gegeven hieronder, maar pas dit aan als dat zinvol is (bv. uitvoeren experimenten en analyse resultaten in aparte sectie, enz.).
\section{Inleiding} % The \section*{} command stops section numbering
\label{sec:inleiding}
De wereld functioneert afhankelijk van enorm veel data. Inlogsystemen, stockvooraden, persoonlijke gegevens... Alles wordt wel ergens bijgehouden. Deze data wordt op een database systeem opgeslaan, maar hoe kies je de juiste? Welk systeem heeft de hoogste performantie en is dus het effectiefst/efficiëntst. Om dit te testen voerden we ons eigen onderzoek naar performantie in database systemen. We bekeken eerst enkele andere studies:
\newline
\newline
\textcite{Datastax2018} doet een performance test op NoSQL Database systemen. Cassandra, MongoDB, Couchbase en HBase worden onderworpen aan de test. Apache Cassandra komt er uiteindelijk als de beste database uit.
\newline
\newline
Uit \textcite{H2Database2018} blijkt dat de H2 database in vergelijking met andere engines (Derby, MySQL, PostgreSQL…) de beste zou zijn. We moeten wel opmerken dat dit artikel is gepubliceerd op de H2 website. Er werd voor het onderzoek ook maar 1 pc gebruikt en simpele query’s.
\newline
\newline
In \textcite{Genesky2012} wordt LevelDB vergeleken met MySQL. Beide komen er gelijkaardig uit. LevelDB scoort beter met een hogere troughput en een lage latency. MySQL is wel stabieler over de volledige lijn en scoort even goed bij average latency en update performance testen.
\newline
\newline
Men vergelijkt in \textcite{Lo1998} niet hoe verschillende database engines het tegenover elkaar doen, maar hoe een DBMS zijn performance kan verschillen op verschillende processors.
\newline
\newline
Het artikel \textcite{Nayak2013} maakt de vergelijking tussen relationele SQL databases en NOSQL. Men concludeert dat beide DBMS voordelen en nadelen hebben in performance en dat je beide moet overwegen voor je een keuze maakt.
\newline
\newline
Uit de reading group hebben we geconcludeert dat \textcite{Bassil2012} het meest betrouwbare artikel was. De studie van \textcite{Genesky2012} leek er structureel op. De rest van dit artikel is als volgt gestructureerd:
\begin{itemize}
\item sectie~\ref{sec:methodologie} beschrijft de methodologie
\item sectie~\ref{sec:experimenten} beschrijft de resultaten van de experimenten
\item sectie~\ref{sec:conclusie} beschrijft de conclusie van het onderzoek.
\end{itemize}
\section{Methodologie}
\label{sec:methodologie}
Beschrijf hier in zoveel mogelijk detail hoe het experiment is opgezet. Het moet voor de lezer mogelijk zijn om aan de hand van de beschrijving het experiment onafhankelijk opnieuw op te zetten en uit te voeren.
\section{Experimenten}
\label{sec:experimenten}
Beschrijf hier hoe de experimenten verlopen zijn en de belangrijkste resultaten. Voeg ook tabel(len) en figuren toe.
Beschrijf zeker ook de uitkomst van de statistische toets: zijn de verschillen in performantie significant?
\section{Conclusie}
\label{sec:conclusie}
Beschrijf hier de conclusie en eventuele bijkomende onderzoeksvragen die in een verder onderzoek kunnen uitgediept worden
%------------------------------------------------------------------------------
% Referentielijst
%------------------------------------------------------------------------------
\phantomsection
\printbibliography[heading=bibintoc]
\end{document}
以下是 artikeltin 文件：
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
% LaTeX-sjabloon voor een artikel of kort document
% HoGent Bedrijf en Organisatie, opleiding toegepaste informatica
% Cursussen Onderzoekstechnieken en Bachelorproef
%
% Gebaseerd op ``Stylish Article'' class
% Version 2.1 (1/10/15)
%
% This template has been downloaded from:
% http://www.LaTeXTemplates.com
%
% Original author:
% Mathias Legrand ([email protected])
% With extensive modifications by:
% Vel ([email protected])
%
% License:
% CC BY-NC-SA 3.0 (http://creativecommons.org/licenses/by-nc-sa/3.0/)
%
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
\NeedsTeXFormat{LaTeX2e}
\ProvidesClass{artikeltin}
\RequirePackage{ifthen}
\RequirePackage{calc}
\AtEndOfClass{\RequirePackage{microtype}}
\DeclareOption*{\PassOptionsToClass{\CurrentOption}{article}}
\ProcessOptions*
\LoadClass{article}
\RequirePackage{ifpdf} % Needed to pick between latex and pdflatex
%----------------------------------------------------------------------
% FONTS & COLORS
%----------------------------------------------------------------------
\RequirePackage{times} % Loads the Times-Roman Fonts
\RequirePackage{mathptmx} % Loads the Times-Roman Math Fonts
\RequirePackage{xcolor}
\definecolor{color1}{RGB}{0,147,208} % Color of the article title and sections
\definecolor{color2}{RGB}{0,20,20} % Color of the boxes behind the abstract and headings
%----------------------------------------------------------------------
% VARIOUS USEFUL PACKAGES
%----------------------------------------------------------------------
\RequirePackage[utf8]{inputenc}
\RequirePackage{amsmath,amsfonts,amssymb}
\RequirePackage{graphicx}
\RequirePackage{booktabs}
\RequirePackage{csquotes}
\RequirePackage[english,dutch]{babel}
\usepackage{hyperref} % hyperlinks
\hypersetup{hidelinks,colorlinks,breaklinks=true,urlcolor=black,citecolor=color2,linkcolor=color2,bookmarksopen=false,pdftitle={Title},pdfauthor={Author}}
%----------------------------------------------------------------------
% MARGINS
%----------------------------------------------------------------------
\RequirePackage[left=2cm,%
right=2cm,%
top=2.25cm,%
bottom=2.25cm,%
headheight=34.9pt,%
a4paper]{geometry}%
%----------------------------------------------------------------------
% FIGURES AND TABLES CAPTIONS
%----------------------------------------------------------------------
\RequirePackage[labelfont={bf,sf,small},%
labelsep=period,%
justification=raggedright]{caption}
\setlength{\abovecaptionskip}{0pt}
\setlength{\belowcaptionskip}{0pt}
%----------------------------------------------------------------------
% PAGE HEADER
%----------------------------------------------------------------------
\RequirePackage{fancyhdr} % Needed to define custom headers/footers
\RequirePackage{lastpage} % Number of pages in the document
\pagestyle{fancy} % Enables the custom headers/footers
% Headers
\lhead{\includegraphics[height=1.1cm]{FBO-NL.jpg}}%
\chead{}%
\rhead{\small\sffamily\bfseries\@PaperTitle\ --- \thepage/\pageref{LastPage}}
% Footers
\lfoot{}%
\cfoot{}%
\rfoot{}%
\renewcommand{\headrulewidth}{0pt}% % No header rule
\renewcommand{\footrulewidth}{0pt}% % No footer rule
%----------------------------------------------------------------------
% SECTION/SUBSECTION/PARAGRAPH SET-UP
%----------------------------------------------------------------------
\RequirePackage[explicit]{titlesec}
\titleformat{\section}
{\color{color1}\large\sffamily\bfseries}
{}
{0em}
{\colorbox{color2!10}{\parbox{\dimexpr\linewidth-2\fboxsep\relax}{\centering\arabic{section}. #1}}}
[]
\titleformat{name=\section,numberless}
{\color{color1}\large\sffamily\bfseries}
{}
{0em}
{\colorbox{color2!10}{\parbox{\dimexpr\linewidth-2\fboxsep\relax}{\centering#1}}}
[]
\titleformat{\subsection}
{\color{color1}\sffamily\bfseries}
{\thesubsection}
{0.5em}
{#1}
[]
\titleformat{\subsubsection}
{\sffamily\small\bfseries}
{\thesubsubsection}
{0.5em}
{#1}
[]
\titleformat{\paragraph}[runin]
{\sffamily\small\bfseries}
{}
{0em}
{#1}
\titlespacing*{\section}{0pc}{3ex \@plus4pt \@minus3pt}{5pt}
\titlespacing*{\subsection}{0pc}{2.5ex \@plus3pt \@minus2pt}{0pt}
\titlespacing*{\subsubsection}{0pc}{2ex \@plus2.5pt \@minus1.5pt}{0pt}
\titlespacing*{\paragraph}{0pc}{1.5ex \@plus2pt \@minus1pt}{10pt}
%----------------------------------------------------------------------
% TABLEOFCONTENTS SET-UP
%----------------------------------------------------------------------
\newlength{\tocsep}
\setlength\tocsep{1.5pc} % Sets the indentation of the sections in the table of contents
\setcounter{tocdepth}{3} % Three levels in the table of contents section: sections, subsections and subsubsections
\usepackage{titletoc}
\contentsmargin{0cm}
\titlecontents{section}[\tocsep]
{\addvspace{4pt}\small\bfseries\sffamily}
{\contentslabel[\thecontentslabel]{\tocsep}}
{}
{\hfill\thecontentspage}
[]
\titlecontents{subsection}[\tocsep]
{\addvspace{2pt}\sffamily}
{\contentslabel[\thecontentslabel]{\tocsep}}
{}
{\ \titlerule*[.5pc]{.}\ \thecontentspage}
[]
\titlecontents*{subsubsection}[\tocsep]
{\footnotesize\sffamily}
{}
{}
{}
[\ \textbullet\ ]
%----------------------------------------------------------------------
% MULTIPLE AUTHOR SET
%----------------------------------------------------------------------
\newcount\@authcnt
\newcount\@tmpcnt\@tmpcnt\z@
\def\@affiliation{%
\ifnum\@tmpcnt<\@authcnt
\global\advance\@tmpcnt1
\raggedright \csname @auth\romannumeral\the\@tmpcnt\endcsname\hfill\\%
\let\next\@affiliation \vskip1pt
\else
\let\next\relax
\fi
\next}
\newcommand{\affiliation}[1]{%
\global\advance\@authcnt1
\expandafter\gdef\csname @auth\romannumeral\the\@authcnt\endcsname
{#1}}
%----------------------------------------------------------------------
% LIST CONTROL
%----------------------------------------------------------------------
\RequirePackage{enumitem}
\setlist{nolistsep} % Uncomment to remove spacing between items in lists (enumerate, itemize)
%----------------------------------------------------------------------
% ABSTRACT+AUTHOR FRAME
%----------------------------------------------------------------------
\newcommand{\PaperTitle}[1]{\def\@PaperTitle{#1}}
\newcommand{\PaperType}[1]{\def\@PaperType{#1}}
\newcommand{\Archive}[1]{\def\@Archive{#1}}
\newcommand{\Authors}[1]{\def\@Authors{#1}}
\newcommand{\JournalInfo}[1]{\def\@JournalInfo{#1}}
\newcommand{\Abstract}[1]{\def\@Abstract{#1}}
\newcommand{\Keywords}[1]{\def\@Keywords{#1}}
% ---------------------------------------------------------------------
\setlength{\columnsep}{0.55cm} % Distance between the two columns of text
\setlength{\fboxrule}{0.75pt} % Width of the border around the abstract
\renewcommand{\@maketitle}{%
\twocolumn[{%
\thispagestyle{empty}%
\vskip-36pt%
{\raggedleft\small\sffamily\bfseries\@JournalInfo\\\@Archive\par}%
\vskip20pt%
{\raggedright\color{color1}\sffamily\bfseries\fontsize{20}{24}\selectfont \@PaperTitle\\}%
{\raggedright\color{color1}\sffamily\bfseries\fontsize{13}{15.6}\selectfont \@PaperType\par}%
\vskip10pt%
{\raggedright\color{color1}\sffamily\fontsize{12}{16}\selectfont \@Authors\par}%
\vskip18pt%
\fcolorbox{color1}{white}{%
\parbox{\textwidth-2\fboxsep-2\fboxrule}{\centering%
\colorbox{color2!10}{%
\parbox{\textwidth-4\fboxsep-2\fboxrule}{%
\ifx\@Keywords\@empty%
\sffamily\textbf{\abstractname}\\\@Abstract%
\else%
\sffamily\textbf{\abstractname}\\\@Abstract\\[4pt]%
\textbf{\keywordname}\\\@Keywords%
\fi%
}%
}%
\vskip4pt%
\begingroup%
\raggedright\sffamily\small%
\footnotesize\@affiliation\par%
\endgroup%%
}%
}%
\vskip25pt%
}]%
}
%----------------------------------------------------------------------
% REFERENCES
%----------------------------------------------------------------------
\RequirePackage[backend=biber,style=apa]{biblatex}
\DeclareLanguageMapping{dutch}{dutch-apa}
\addbibresource{biblio.bib}
这是我使用的 biblio.bib：
% Encoding: UTF-8
@Article{Bassil2012,
author = {Bassil, Youssef},
title = {A Comparative Study on the Performance of the Top DBMS Systems},
journal = {Journal of Computer Science and Research},
year = {2012},
volume = {1},
number = {1},
pages = {20--31},
month = feb,
issn = {2227-328X},
abstract = {Database management systems are today’s most reliable mean to organize data into collections that can be searched and
updated. However, many DBMS systems are available on the market each having their pros and cons in terms of reliability,
usability, security, and performance. This paper presents a comparative study on the performance of the top DBMS systems.
They are mainly MS SQL Server 2008, Oracle 11g, IBM DB2, MySQL 5.5, and MS Access 2010. The testing is aimed at
executing different SQL queries with different level of complexities over the different five DBMSs under test. This would pave
the way to build a head-to-head comparative evaluation that shows the average execution time, memory usage, and CPU
utilization of each DBMS after completion of the test.},
keywords = {DBMS, Performance Study, SQL Server, MySQL, Oracle, DB2, Access},
owner = {bert},
timestamp = {2017-01-28},
}
@Electronic{VanVreckem2017,
author = {Van Vreckem, Bert},
title = {De bachelorproef informatica: een praktische gids},
year = {2017},
url = {https://github.com/HoGentTIN/bachproef-gids},
version = {v0.9.1},
organization = {Hogeschool Gent},
urldate = {2017-02-08},
owner = {bert},
timestamp = {2017-02-08},
}
@Electronic{Datastax2018,
author = {Datastax},
year = {2018},
title = {Cassandra vs. MongoDB vs. Couchbase vs. HBase},
organization = {Datastax},
url = {https://www.datastax.com/nosql-databases/benchmarks-cassandra-vs-mongodb-vs-hbase},
owner = {Ian},
timestamp = {2018-04-26},
urldate = {2018-04-26},
version = {v0.9.1},
}
@Electronic{Genesky2012,
author = {Eric Genesky},
year = {2012},
title = {A Performance Comparison of LevelDB and MySQL},
organization = {Database Zone},
url = {https://dzone.com/articles/performance-comparison-leveldb},
owner = {Geoffrey},
timestamp = {2018-04-26},
urldate = {2018-04-26},
version = {v0.9.1},
}
@Article{Nayak2013,
author = {Nayak, Ameya and Poriya, Anil and Poojary, Dikshay},
title = {Type of NOSQL databases and its comparison with relational databases},
journal = {International Journal of Applied Information Systems},
year = {2013},
volume = {5},
number = {4},
pages = {16--19},
month = mar,
issn = {2249-0868},
abstract = {NOSQL databases (commonly interpreted by developers as
„not only SQL databases? and not „no SQL?) is an emerging
alternative to the most widely used relational databases. As
the name suggests, it does not completely replace SQL but
compliments it in such a way that they can co-exist. In this
paper we will be discussing the NOSQL data model, types of
NOSQL data stores, characteristics and features of each data
store, query languages used in NOSQL, advantages and
disadvantages of NOSQ.},
keywords = {ACID, BASE properties, CAP theorem, DBaaS, scalability },
owner = {Ian},
timestamp = {2018-04-26},
}
@Electronic{H2Database2018,
author = {H2Database},
year = {2018},
title = {Performance Comparison},
organization = {H2Database},
url = {http://www.h2database.com/html/performance.html},
owner = {Jentel},
timestamp = {2018-04-26},
urldate = {2018-04-26},
version = {v0.9.1},
}
@Article{Lo1998,
author = {Lo, Jack L and Barroso, Luiz Andr{\'e} and Eggers, Susan J and Gharachorloo, Kourosh and Levy, Henry M and Parekh, Sujay S},
title = {An analysis of database workload performance on simultaneous multithreaded processors},
journal = {IEEE Computer Society},
year = {1998},
volume = {26},
number = {3},
pages = {39--50},
month = apr,
issn = {0163-5964},
abstract = {Simultaneous multithreading (SMT) is an architectural technique in which the processor issues multiple instructions from multiple threads each cycle. While SMT has been shown to be effective on scientific workloads, its performance on database systems is still an open question. In particular, database systems have poor cache performance, and the addition of multithreading has the potential to exacerbate cache conflicts.This paper examines database performance on SMT processors using traces of the Oracle database management system. Our research makes three contributions. First, it characterizes the memory-system behavior of database systems running on-line transaction processing and decision support system workloads. Our data show that while DBMS workloads have large memory footprints, there is substantial data reuse in a small, cacheable "critical" working set. Second, we show that the additional data cache conflicts caused by simultaneous multithreaded instruction scheduling can be nearly eliminated by the proper choice of software-directed policies for virtual-to-physical page mapping and per-process address offsetting. Our results demonstrate that with the best policy choices, D-cache miss rates on an 8-context SMT are roughly equivalent to those on a single-threaded superscalar. Multithreading also leads to better interthread instruction cache sharing, reducing I-cache miss rates by up to 35%. Third, we show that SMT's latency tolerance is highly effective for database applications. For example, using a memory-intensive OLTP workload, an 8-context SMT processor achieves a 3-fold increase in instruction throughput over a single-threaded superscalar with similar resources.},
keywords = {Computer systems organization, General and reference, Information systems, Networks, Architectures, Dependable and fault-tolerant systems and networks, Cross-computing tools and techniques, Data management systems, Network performance evaluation, Parallel architectures, Performance, Database management system engines },
owner = {Jentel},
timestamp = {2018-04-26},
}
@Comment{jabref-meta: databaseType:biblatex;}
这些都是我学校的模板，我不知道我做错了什么。
答案1
有两个错误需要解决：
- 确保 bib 文件中的编码是 UTF-8。
- 将 35% 更改为 35\%。
之后一切运行良好。
答案2
我必须在 Debian 上手动更改编码，如下所示：
iconv -f UTF-8 -t UTF-8 引用.bib > 引用2.bib
之后，我不得不删除文件 references.bib 并将 references2.bib 重命名为 references.bib。